Soumodeep Mukherjee

About

Junior Data Analyst with 1+ year of MIS and reporting experience, skilled in SQL, Power BI, and Excel. Builds dashboards and recurring reports to support decision-making across e-commerce, retail, and entertainment analytics projects.

Experience

• Office Executive
  AHEAD
  2025 – Present

Education

• Bachelor of Technology
  Meghnad Saha Institute of Technology
  Computer Science & Business Systems · 2020 – 2024

Skills

Tools / apps / platforms

Projects

• Diwali Sales Data Analysis
  Python

  Performed exploratory data analysis on retail sales data using Python and Pandas. Cleaned and transformed datasets to improve analytical accuracy. Identified top-selling products and customer purchasing trends through visual analysis.

• Blinkit Sales Analytics Dashboard
  Power BI

  Analyzed 8,000+ grocery sales records across 12 business attributes using Power BI. Built an interactive dashboard with KPI cards for Total Sales, Average Sales, Orders, and Items Sold. Applied DAX measures and data modeling techniques to calculate business KPIs and performance metrics.

• E-Commerce Sales Analysis
  SQL, Python

  Analyzed 10,000+ e-commerce transaction records using SQL and Python. Applied joins, aggregations, CTEs, and window functions to uncover sales trends and customer behavior. Conducted exploratory data analysis and built visualizations to support business decision-making.

• OTT Content Analytics Dashboard
  SQL, MySQL, Power BI

  Analyzed 200+ OTT titles and 1,000+ cast/crew records using SQL, MySQL, and Power BI. Built a 3-page interactive Power BI dashboard featuring KPI cards, genre analysis, rating trends, and actor/director insights. Used SQL joins and aggregations to identify content distribution and audience rating patterns.

Courses & certifications

• Virtual Internship in Java Programming

⚽ Extracurricular activities

• Internal Hackathon

  Participated in a team under time constraints to deliver a working solution.