RONAK PAWAR
Aspiring Business Analyst | Data Analyst Intern
Navi Mumbai
Summary
Recently completed a Data Analyst Internship at Unified Mentor, where I built interactive dashboards and analyzed multi-source datasets (10,000+ rows) to extract meaningful insights. I worked on data cleaning, transformation, and visualization using tools like Power BI, SQL, Python, and Excel, focusing on delivering clear and impactful data storytelling. I am currently pursuing a B.Sc. in Information Technology from the University of Mumbai (expected April 2026), with hands-on experience through real-world projects in business intelligence and data analysis. Through projects such as Netflix Content Analysis, Retail Sales SQL Analysis, and a Multi-Branch Product Sales Dashboard, I have developed the ability to translate complex data into actionable insights. I am actively seeking entry-level opportunities as a Data Analyst / Business Analyst where I can contribute to data-driven decision-making in FMCG, retail, or consumer-focused industries.
Overview
4
4
Certificates
2
2
years of post-secondary education
Work History
Data Analyst Intern
Unified Mentor(Internship)
01.2026 - 04.2026
- Analyzed and cleaned datasets to extract meaningful insights and support data-driven decision-making. Created basic reports and visualizations using Excel and Power BI while working closely with mentors to understand analytical requirements.
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
- Conducted in-depth analyses to uncover trends and insights, driving strategic decision-making.
Projects:
1. Netflix Data Cleaning & Visualization
- Cleaned and transformed Netflix dataset to analyze content distribution by genre, country, and release year.
- Created visual dashboards to identify trends in content production and audience targeting.
2. Uber Trip Data Analysis
- Analyzed Uber trip data to identify peak hours, demand patterns, and ride distribution.
- Built visualizations to support operational and demand forecasting insights.
3. Coffee Sales Analysis
- Evaluated coffee sales data to identify top-performing products, revenue trends, and seasonal patterns.
- Developed dashboards to assist in inventory planning and sales performance tracking.
Education
Bachelor of Science - Information Technology
Tilak Education Society's J.K College of Science & Commerce
Mumbai, India 06.2024 - 04.2026
Skills
Python (Pandas, Matplotlib)
Microsoft Excel
Databases (SQL)
Data Visualization(Power BI & Tableau)
Data Cleaning & Preprocessing
Trend & Pattern Identification
Revenue & Sales Analysis
Stock & Inventory Insight Generation
Analytical Thinking
KPI & Performance Analysis
Root Cause Analysis
Problem Solving
Data-Driven Decision Making
Stakeholder Collaboration
Certification
Google Data Analytics Professional Certificate (Issued by Google Career Certificates Delivered via Coursera)
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
Marathi
Advanced (C1)
Timeline
Data Analyst Intern
Unified Mentor(Internship)
01.2026 - 04.2026
Bachelor of Science - Information Technology
Tilak Education Society's J.K College of Science & Commerce
06.2024 - 04.2026