Back to Developers
Harsh Gupta

Harsh Gupta

Data Analyst

Thane, India
80
Profile Score

About

Data Analyst with strong expertise in Advanced Excel and Power BI, experienced in handling datasets ranging from 50K to 7M+ records. Proven ability to design automated reporting frameworks, perform complex data cleaning using Power Query, and deliver executive-ready dashboards. Skilled at bridging backend data extraction (SQL/Python) with business-friendly spreadsheet and BI visualizations for decision support.

Skills & Expertise (22)

MS Excel Advanced
8.2/10
1
Years Exp
Python Advanced
7.9/10
1
Years Exp
Exploratory data analysis Intermediate
7.4/10
1
Years Exp
Pandas Intermediate
7.3/10
1
Years Exp
SQL Intermediate
7.1/10
1
Years Exp
Microsoft Copilot AWS Fundamentals GitHub MySql SQL Server Trend Analysis Outlier Detection Statistical Modeling VLOOKUPs Advanced Pivot Tables Tableau Power BI R Matplotlib Seaborn scikit-learn NumPy

Work Experience

Data Analytics Intern

Trainity

Jul 2025 - Oct 2025

Engineered Excel-based financial and HR reporting models analyzing 50K+ records, using Power Query to automate data cleaning and transformation workflows. Designed interactive Excel dashboards with Pivot Tables and Slicers to track KPIs, diversity metrics, and profitability trends for management-level reporting. Performed exploratory analysis, outlier detection, and correlation studies to improve data reliability and consistency in business-critical spreadsheets. Owned end-to-end Excel reporting workflows, from raw data extraction to final dashboard delivery.

Data Science Intern

Prodigy Infotech

Jul 2025 - Aug 2025

Processed and analyzed 7M+ US accident records using Python, exporting structured datasets into Excel for refined trend and pattern analysis. Synthesized complex demographic and severity data into clear, executive-friendly visual reports using Matplotlib and Seaborn. Supported analytical reporting through data cleaning, preprocessing, and structured exploratory analysis.

Education

Bachelor of Science in Computer Science - Smt. Chandibai Himathmal Mansukhani College, University of Mumbai

2022 - 2025 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceFeb 2026

Availability Details

Relocation

Depends on Offer

Skills (22)

MS Excel Python Exploratory data analysis Pandas SQL Microsoft Copilot AWS Fundamentals GitHub MySql SQL Server +12 more