SUMIT GUPTA

Sheopur

Summary

Results-driven Data Analyst with strong expertise in cleaning, analyzing, and transforming data using SQL and Python (Pandas, NumPy). Demonstrated ability to conduct Exploratory Data Analysis (EDA) and design interactive dashboards in Power BI and Excel to deliver actionable insights, optimize business processes, and support data-driven decision-making.

Overview

Certification

Work History

Trainee

GRASS SOLUTION Pvt.

Jaipur, India

06.2025 - 11.2025

Extracted, cleaned, and transformed data using SQl and Python to ensure accuracy and consistency.
Conducted EDA to identify trends, patterns, and anomalies supporting data-driven decision.
Analyzed KPIs and metrics to monitor performance and produce actionable reports.
Executed dataset validation and peer reviews to maintain high data quality standards.
Built interactive dashboards in Power BI and Excel to deliver actionable business insights.

Education

Bachelor of Science - Zoology

Jiwaji University

Gwalior, India

03-2025

XII (M.P. Board) - Biology

Excellence Higher Secondary School

Sheopur, India

04-2022

Skills

SQL: Strong in Joins, Subqueries, and Window Functions for efficient data extraction and analysis
Power BI: Interactive dashboards, DAX measures, and KPI reporting

Advanced Excel: Lookups, Power Query, PivotTables, and charts for data analysis
Python: data analysis using Pandas and NumPy, including data cleaning and EDA, with Matplotlib and Seaborn for data visualization

Certification

ISRO-Data Analytics & AI/ML for Geodata Analysis (Link)
HackerRank-Advanced SQL (Link)

SELECTED PROJECTS

Car sales Price Prediction (2025)

Created an interactive Excel dashboard to analyze car prices by brands, fuel type, transmission, and year.
Used Pivot Tables, Pivot Charts, and slicers to identify pricing trends and key influencing factors.
Cleaned and organizes raw data to deliver clear, actionable insights.

Global Mobile Price Project (2025)

Analyzed global smartphone pricing data (2025) by brand, processor, 5g support, OS, and charging wattage.
Used Pivot Tables and Pivots Charts to compare average price, brand performance, and feature distribution.
Built an interactive Excel dashboard with slicers to highlight pricing trends and key market insights.

Timeline