Harshil shah

Senior Data Analyst

Ahmedabad, Gujarat 8+ yrs exp 95 · Outstanding

About

Senior Data Analyst with 6+ years of experience driving business insights across EdTech, E-commerce, Manufacturing, and Market Research. Proven expertise in data wrangling, visualization and delivering actionable business insights using SQL, Power BI, Python, and Advanced Excel. Adept at stakeholder communication, cross-functional collaboration, and end-to-end project management. Currently leading analytics operations for Physics Wallah’s Gujarat region, supporting strategic decision-making through advanced data analysis, Forecasting, Data Modeling, KPI Tracking, A/B Testing, dashboards, cohort analysis and reporting.

Skills & Expertise (35)

Python Advanced

8.5/10

Years Exp

Power BI Advanced

8.5/10

Years Exp

SQL Advanced

8.5/10

Years Exp

Pandas Advanced

8.0/10

Years Exp

MySql Advanced

8.0/10

Years Exp

Excel Dashboards Advanced

8.0/10

Years Exp

Advanced Excel Advanced

8.0/10

Years Exp

Google Sheets Advanced

7.5/10

Years Exp

NumPy Advanced

7.5/10

Years Exp

Jupyter Intermediate

7.0/10

Years Exp

Google Workspace Intermediate

7.0/10

Years Exp

Ad Hoc Reporting Intermediate

7.0/10

Years Exp

Critical thinking Intermediate

7.0/10

Years Exp

KPI Tracking Intermediate

7.0/10

Years Exp

stakeholder communication Intermediate

7.0/10

Years Exp

Cohort Analysis Intermediate

7.0/10

Years Exp

ETL Pipelines Intermediate

7.0/10

Years Exp

Business Acumen Intermediate

7.0/10

Years Exp

Postgresql Intermediate

7.0/10

Years Exp

Tableau Intermediate

7.0/10

Years Exp

Google Data Studio Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

Seaborn Intermediate

7.0/10

Years Exp

Cross-Functional Collaboration Intermediate

7.0/10

Years Exp

Data Warehousing Intermediate

6.5/10

Years Exp

Project Management Intermediate

6.5/10

Years Exp

Root Cause Analysis Intermediate

6.5/10

Years Exp

Forecasting Intermediate

6.5/10

Years Exp

BigQuery Intermediate

6.5/10

Years Exp

Git Intermediate

6.0/10

Years Exp

Notion Intermediate

6.0/10

Years Exp

Trello Intermediate

6.0/10

Years Exp

A/B testing Intermediate

6.0/10

Years Exp

SPSS Intermediate

6.0/10

Years Exp

Automation Fundamentals

Work Experience

Senior Data Analyst

Physics Wallah

Mar 2024 - Present

Managed all data operations across the Gujarat region, reporting to Business and Center Heads. Automated daily reporting dashboards using SQL + Power BI, reducing manual work by 40%. Coordinated with 6+ departments to gather data requirements, ensuring 100% data availability for strategic decisions. Identified student engagement trends using Python scripts, influencing 10% increase in retention.

Data Analyst

ActionEdge Research Services

Aug 2022 - Mar 2024

Developed interactive dashboards in Power BI and Excel for 10+ market research projects. Analyzed raw cloud data using SQL and Excel Pivot Tables to generate key business insights. Enabled faster decision-making by improving report turnaround time by 25%.

Data Analyst (Marketing Analytics & Strategy)

Topsun Energy

Oct 2020 - Jul 2022

Led marketing data initiatives including campaign tracking, customer segmentation, and MIS reporting. Conducted competitive analysis and developed dashboards for product performance and sales growth. Managed solar project data from lead generation to government tender submissions.

Franchise & Marketing Executive

Bookmyparts Networks

Jul 2018 - Oct 2020

Handled B2B franchise growth and implemented strategies to increase product visibility. Collected and analyzed customer feedback data to improve service delivery.