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

  1. Data Analytics

    Jul 2025 — Present

    Prakash 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 — 2025

    Arya College of Engineering & IT

    Artificial Intelligence & Data Science