Portfolio - Mayur Pawar

Mayur Pawar

Data Aspirant

[email protected]

PHONE

+91 7378793585

Download CV

About Me

Hello There 👋🏻

Welcome to my portfolio! 😃 I'm a Data Analyst dedicated to transforming complex datasets into clear, actionable insights. Proficient in Advanced Excel, Power BI, SQL, and Python, I tackle analytical challenges head-on.

My experience includes:

➽ Creating impactful dashboards that tell a story and drive user engagement.
➽ Ensuring data quality using techniques such as standardization and deduplication.
➽ Extracting and analyzing data with precision using SQL.
➽ Delivering data-driven solutions to complex business problems.
➽ Enhancing stakeholder engagement by delivering clear and actionable insights.

🔍 Explore my portfolio to see the projects I've undertaken and the value I can add to your team. Let's collaborate to uncover insights that drive your organization's success.

Regards,
Your Next Analyst ✨

1

Excel Project

3

PowerBI Projects

1

SQL Project

Key Skills

SQL

Power BI

Presentation Skills

Stakeholder Management

Problem Solving

Effective Communication

My Projects

My Experience

AtliQ Technologies - Data Analyst Intern (Remote)
Jan 2025 - Feb 2025

Applied advanced data cleaning techniques, including standardization, deduplication, and normalization, to improve the accuracy and consistency of client datasets.
Performed ad-hoc analysis and variance analysis using Excel and Power BI, focusing on identifying business trends, order fluctuations, and data discrepancies.
Optimized SQL queries in MySQL Workbench for precise data extraction and validation.
Automated client network operation reports, reducing manual effort and significantly improving the reporting turnaround time.
Analyzed a dedicated dashboard on 5G implementation, showcasing its impact on financial performance, operational efficiency, and customer engagement patterns.
Built an interactive Power BI dashboard for Shield Insurance to monitor customer acquisition and revenue growth, integrating advanced filters and dynamic visuals for enhanced decision-making.

PwC Virtual Case Experience - Call Center Solution
Dec 2024 - Jan 2025

Implemented data quality checks and validation procedures to improve overall data integrity.
Investigated call center data using Excel and SQL, identifying a rise in call abandonment during lunch hours.
Conducted comprehensive trend analysis on 8 months of call center data, processing large datasets to extract meaningful insights.
Developed an interactive dashboard for call center performance analysis, enabling better decision-making and operational efficiency.