Back to Developers
Pranjal Gupta

Pranjal Gupta

Data Analyst

Jamnagar, India 1+ yrs exp 84 · Excellent

About

Data Analyst with hands-on experience in Excel, SQL, Python, Power BI, and Tableau. Skilled in data cleaning, visualization, and building KPI-driven dashboards. Proven ability to transform raw data into actionable insights to support business decisions.

Skills & Expertise (15)

Attention to Detail Expert
8.5/10
2
Years Exp
Problem Solving Advanced
8.2/10
2
Years Exp
Power BI Advanced
8.1/10
2
Years Exp
Analytical Thinking Advanced
8.0/10
2
Years Exp
Excel Advanced
7.8/10
2
Years Exp
Data Visualization Advanced
7.8/10
2
Years Exp
SQL Advanced
7.5/10
2
Years Exp
KPI Tracking Advanced
7.5/10
2
Years Exp
Data Cleaning Advanced
7.2/10
2
Years Exp
EDA Advanced
7.0/10
2
Years Exp
Forecasting Intermediate
6.5/10
1
Years Exp
Python Intermediate
6.4/10
1
Years Exp
Pandas Intermediate
6.0/10
1
Years Exp
NumPy Intermediate
5.8/10
1
Years Exp
Tableau Intermediate
5.5/10
1
Years Exp

Work Experience

Data Analyst Intern

UNIFIED MENTOR

Present - Present

Cleaned and transformed datasets using Excel and SQL, working with ~1,000–3,000 rows to prepare data for analysis. Built interactive Power BI dashboards tracking KPIs such as revenue, orders, and regional performance. Automated reporting workflows using Excel and Power BI, reducing manual reporting effort by ~30–40%. Performed exploratory data analysis (EDA) to identify trends and patterns, supporting business insights. Wrote SQL queries (joins, aggregations) to extract and organize data for reporting and dashboard development. Handled missing values and removed duplicate records to improve dataset consistency before analysis.

Quality Control Officer

SPARSH BIO-TECH PVT LTD

Aug 2024 - Sep 2025

Conducted QC tests (LOD, LOQ, IR) across API, raw, and finished products ensuring compliance. Monitored quality parameters, improving reporting accuracy and reducing deviations.

Apprentice, R&D

PIRAMAL PHARMA SOLUTIONS PVT LTD

Jul 2023 - Mar 2024

Performed chromatography and synthetic reactions; analysed experimental data using LCMS/NMR. Improved data recording processes, reducing manual errors, and enhancing data accuracy for analysis. Supported research teams by structuring and interpreting experimental datasets.

Education

M.Sc. Organic Chemistry - PARUL UNIVERSITY

2021 - 2023 · Afghanistan

B.Sc. Chemistry - SAURASHTRA UNIVERSITY

2018 - 2021 · Afghanistan

Certifications

No certifications added yet

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 9/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 84/100

Profile Overview

Member sinceMay 2026