Mayur Pawar

Data Analyst

Pune, India 0+ yrs exp 81 · Excellent

About

Results-driven Data Analyst with proven internship experience in data analysis, business intelligence, ETL pipelines, and dashboard development. Proficient in Python (Pandas, NumPy), SQL, Power BI, Tableau, and Excel. Skilled in EDA, statistical analysis, data modeling, and data visualization to surface actionable insights. Seeking a Data Analyst role at an MNC to drive measurable business impact through data-driven decision-making.

Skills & Expertise (41)

Jupyter Notebook Intermediate

6.5/10

Years Exp

Google Sheets Intermediate

6.5/10

Years Exp

Dashboard Design Intermediate

6.5/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Data Storytelling Intermediate

6.5/10

Years Exp

Data Visualization Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Relational Database Design Intermediate

6.5/10

Years Exp

SQL Query Optimization Intermediate

6.5/10

Years Exp

KPI Reporting Intermediate

6.5/10

Years Exp

VS Code Intermediate

6.5/10

Years Exp

Anaconda Intermediate

6.5/10

Years Exp

Google Colab Intermediate

6.5/10

Years Exp

Git Intermediate

6.5/10

Years Exp

GitHub Intermediate

6.5/10

Years Exp

Analytical Thinking Intermediate

6.5/10

Years Exp

Problem Solving Intermediate

6.5/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Matplotlib Intermediate

6.5/10

Years Exp

Seaborn Intermediate

6.5/10

Years Exp

EDA Intermediate

6.5/10

Years Exp

Data Modeling Intermediate

6.5/10

Years Exp

Microsoft Excel Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

ETL Pipelines Intermediate

6.5/10

Years Exp

Analysis Intermediate

6.5/10

Years Exp

JavaScript Intermediate

5.5/10

Years Exp

CSS Intermediate

5.5/10

Years Exp

HTML Intermediate

5.5/10

Years Exp

React.js Intermediate

5.5/10

Years Exp

Data Structure Intermediate

5.5/10

Years Exp

OOP Intermediate

5.5/10

Years Exp

DBMS Intermediate

5.5/10

Years Exp

Statistics Intermediate

5.5/10

Years Exp

stakeholder communication Intermediate

5.5/10

Years Exp

Team Leadership Beginner

4.5/10

Java Beginner

3.5/10

Work Experience

Full Stack Developer Intern

SevenMentor Pvt. Ltd.

Oct 2025 - Mar 2026

Developed 5+ production-ready responsive web applications using HTML, CSS, JavaScript, and React.js, improving UI consistency and user experience. Designed and integrated RESTful APIs with MySQL databases to build scalable backend data pipelines supporting web platform operations. Streamlined debugging, testing, and deployment workflows, reducing bug resolution time by 20% through structured QA practices and code reviews.

Data Analyst Intern

Aroma Brand Solutions

May 2025 - Jul 2025

Collected, cleaned, and analyzed 10,000+ structured/unstructured records using Python (Pandas, NumPy), SQL, and Excel to ensure data accuracy and consistency for business reporting. Designed and deployed interactive KPI dashboards in Power BI and Tableau enabling real-time performance monitoring and stakeholder reporting across business units. Built automated ETL pipelines and reporting workflows, reducing manual reporting effort by 30% and significantly improving data turnaround time.