Mrunmayee Santosh Pawar

Data Analyst

Kalyan, IN.

About

Highly analytical and detail-oriented Data Analyst with a B.Sc. in Computer Science and a Master Certification in Data Science. Proven ability to transform complex datasets into actionable insights, driving decision-making and business growth through robust project experience. Eager to leverage strong skills in Python, SQL, Power BI, and Excel in an upcoming Data Analyst Internship and to solve real-world challenges in a dynamic data-driven environment.

Work

Analytics Career Connect

|

Data Analyst Intern

Kalyan, Maharashtra, India

→

Summary

Contributes to data-driven strategies by cleaning, analyzing, and visualizing large datasets to enhance reporting efficiency and accuracy.

Highlights

Streamlined data processing workflows by cleaning and analyzing large datasets using Excel and SQL, boosting reporting efficiency by 30%.

Identified critical trends and patterns through in-depth data analysis, elevating report accuracy by 20% and directly informing strategic business decisions.

Volunteer

Content Analyst (Volunteer)

|

Maharashtra News 24 (1M+ YouTube subscribers)

→

Leveraged data analysis to optimize content strategy and audience engagement for a major YouTube news channel.

Highlights

Conducted in-depth analysis of content performance data for a YouTube channel with 1M+ subscribers, identifying key viewer behavior trends to inform and optimize content strategy.

Designed and maintained an interactive dashboard, increasing Click-Through Rate (CTR) by 12% through data-driven insights.

Delivered weekly analytical reports and strategic recommendations to stakeholders, directly influencing editorial decision-making and content planning.

Education

Smt. C.H.M. College, Mumbai University

Mumbai, Maharashtra, India
→
Bachelor of Science (B.Sc.) Computer Science

Certificates

Master Certification in Data Science

IT Vedant

MySQL, Python, Advanced Excel

IT Vedant

Statistics for Data Analysis

Data Analyst Duo

Power BI Certification

Growth School

IBM Python for Data Science

IBM

Skills

Data Analysis & Visualization

Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, Excel, Data Cleaning, Data Visualization, Dashboard Development.

Database Management

MySQL, Data Extraction, SQL Joins, Aggregation, Query Optimization.

Statistical Analysis

Hypothesis Testing, Regression, Probability.

Business Intelligence

KPI Definition, Dashboard Development, Storytelling with Data.

Professional Skills

Communication, Problem-Solving, Detail Orientation, Strategic Thinking, Analytical Thinking.

Projects

SQL Data Analysis – Gemini Ultra vs ChatGPT

→

Summary

A comparative analysis project leveraging MySQL to evaluate the performance of leading AI models, Gemini Ultra and ChatGPT.

Exploratory Data Analysis – Employee Attrition Rate

→

Summary

A Python-based project focused on identifying key drivers of employee attrition through in-depth data exploration and visualization.

Excel Dashboard – Airbnb Data Insights

→

Summary

An Excel-based project to visualize and analyze Airbnb listing data, uncovering key trends and patterns.

Statistical Analysis – Taxi Fare Hypothesis Analysis

→

Summary

A statistical analysis project using hypothesis testing to compare spending habits between different payment methods for taxi fares.