Back to Developers
pragati pawar

pragati pawar

Data Analyst | Business Analyst

Pune 9+ yrs exp 95 · Outstanding

About

6+ years in total /9+ Months in Data Analyst with hands-on experience in SQL, MySQL, Advanced Excel, Power Query, Power BI, and Tableau, with 6+ years of overall experience across Quality and Production. Experienced in data cleaning, transformation, exploratory data analysis, KPI reporting, data modeling, dashboard development, and deriving actionable business insights. Completed projects in Bank Loan, E-commerce, and Manufacturing Analytics involving SQL analysis, data visualization, performance analysis, and interactive dashboards. Strong analytical, problem-solving, and process-improvement skills with a detail-oriented approach to data-driven decision-making.

Skills & Expertise (17)

Exploratory data analysis Advanced
8.0/10
6
Years Exp
Power BI Advanced
8.0/10
1
Years Exp
Analysis Advanced
8.0/10
6
Years Exp
Tableau Advanced
8.0/10
1
Years Exp
Problem Solving Advanced
8.0/10
6
Years Exp
Advanced Excel Advanced
8.0/10
6
Years Exp
Communication Advanced
8.0/10
6
Years Exp
Data Cleaning Advanced
8.0/10
6
Years Exp
Data Transformation Advanced
8.0/10
6
Years Exp
Dashboard Development Advanced
8.0/10
1
Years Exp
SQL Advanced
7.5/10
4
Years Exp
Statistics Advanced
7.0/10
6
Years Exp
MySql Advanced
7.0/10
3
Years Exp
Data Modeling Advanced
7.0/10
3
Years Exp
KPI Reporting Advanced
7.0/10
6
Years Exp
Python Intermediate
6.5/10
3
Years Exp
SAS Intermediate
5.5/10
2
Years Exp

Work Experience

Data Analyst Intern

Excelr

Jan 2023 - Present

Performed data cleaning, transformation, validation, and exploratory data analysis using Excel and Power Query. Developed SQL queries using filtering, aggregation, joins, subqueries, and KPI calculations to derive business insights. Built interactive Power BI and Tableau dashboards using KPIs, charts, filters, and data visualization techniques. Worked on Bank Loan, E-commerce, and Manufacturing Analytics projects, analyzing business, sales, customer, operational, and quality data. Created data models, relationships, Pivot Tables, Pivot Charts, and interactive dashboards to identify trends, performance gaps, and actionable insights.

Quality Engineer

Kap Engineering

Sep 2022 - Sep 2026

Maintained and analyzed quality records, inspection reports, rejection data, and defect-related data using Excel. Used Excel for data cleaning, sorting, filtering, lookup functions, pivot tables, and report preparation to organize quality information.

Trainee Engineer

Bajaj Auto LTD

Aug 2020 - Jul 2022

Managed day-to-day production activities on the manufacturing line. Monitored production output, quality parameters, and process performance. Maintained production records and analyzed data to identify process issues.

Education

Bachelor of Engineering in Mechanical Engineering - International Center Of Excellence In Engineering And Management

- 2025 · Afghanistan

Diploma in Mechanical Engineering - Government Polytechnic Jalgaon

- 2020 · Afghanistan

Certifications

Data Analyst

Excelr · 2026

Data Analyst

NASSCOM · 2026

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

Profile Overview

Member sinceOct 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer