INDORE , INDIA

21:48 GMT+5:30

Profile Image

Dev Kumar Gupta

Data Analytics and ML Specialist

About Me

I am a freelance Data Analyst with hands-on experience in SQL, Python, and Power BI, delivering data-driven solutions that improve forecasting accuracy and business performance. I have successfully completed client projects focusing on sales optimization, automation, and dashboard insights. My work consistently drives measurable growth and operational efficiency

Experience

Retail Data Analyst

Freelancing

·

Jan 2025 - Present

Led an end-to-end analytics project focused on profit optimization and operational efficiency using Python, SQL, and visualization tools. Delivered data-driven insights that directly contributed to cost reduction and productivity enhancement for the client.

  • Increased profits by 5.1% and reduced costs by 6% using predictive sales modeling in Python

  • Boosted productivity by 10% by designing an interactive Power BI dashboard integrated with SQL and Excel data models

Data Analyst Intern

Cognifyz Technologies

·

May 2024– June 2024

During my internship, I conducted descriptive and predictive analytics to improve forecasting accuracy and streamline reporting processes through automation. I also developed interactive dashboards that enhanced decision-making speed across sales operations.

  • Improved monthly sales forecasting accuracy by 10.4% using Python-based predictive models

  • Reduced data preparation efforts by 15% through SQL/Excel automation and Power BI dashboards

Education

Bachelor's Of Technology In Data Science

Institute Of Engineering & Science Indore

·

2021 - 2025

A comprehensive program focused on Machine Learning, Predictive Analytics, Data Mining, Deep Learning, and Business Intelligence. Gained hands-on expertise in Python, SQL, and Power BI with real-world data projects involving forecasting, automation, and dashboard development.
Key Academic Highlights:

  • Completed capstone in Predictive Analytics for Business Forecasting using ML models

  • Built ETL pipelines and automated data cleaning workflows using Python & SQL

  • Led a team project using Power BI to track sales KPIs and deliver insights for strategic decisions

Certifications

Stack

Python

Advance SQL

Power BI

DAX

Tableau

Git & Github

Microsoft Excel (Power Query, Pivot Tables, VBA)

Streamlit

Figma

Skills

Data Manipulation

Data Mining

Data Storytelling

Data Processing

Presentations

Google Sheets

Business Analytics

Languages

German

Intermediate

English

Fluent

Create a free website with Framer, the website builder loved by startups, designers and agencies.