About
Data Analyst with 1+ year of hands-on experience analyzing sales, ERP, and market data using Excel, SQL, Python, and Power BI. Skilled in data validation, MIS reporting, exploratory data analysis, dashboard development, KPI analysis, and competitor research, backed by a Data Science internship in data preprocessing and clustering.
Experience1
Data Analytics
Jul 2025 — PresentPrakash Pump EST
Analyzed and validated sales, dispatch, and ERP data in Excel using Pivot Tables and LOOKUP functions, identifying a formula error in a dispatch MIS report. Conducted market and competitor analysis across multiple countries, presenting insights to support business decisions.
Projects3
Netflix Content Analytics
Queried and analyzed content-addition trends using Python and SQL joins, CTEs, and window functions; annual additions rose from 82 titles in 2015 to 1,879 in 2020, with 2019 peaking at 2,016 titles.
- Python
- SQL
Sales Analysis Dashboard
Developed a DAX-powered interactive Power BI dashboard with KPI cards, slicers, and drill-through; summarized approximately 438K in sales, 37K in profit, and 5,615 units sold across customer, product, and regional views.
- Power BI
- DAX
Shoe Sales Business Analysis
Performed EDA on shoe sales data using Pandas, correlation, and IQR analysis; calculated approximately $1,453 average revenue per transaction and identified a strong positive relationship between units sold and revenue.
- Python
Education1
BTech
2021 — 2025Arya College of Engineering & IT
Artificial Intelligence & Data Science