MUGDHA GOKULDAS BAGUL
Pune
Summary
Business-focused NASSCOM certified Business Analyst / BI Analyst with 6+ months of hands-on analytics experience across internships, industry-grade simulations, and real-world projects. Strong expertise in SQL, Advanced Excel, Power BI, Tableau, and GenAI-assisted exploratory analysis. Experienced in analyzing large datasets (10k-15k rows), defining KPIs, automating dashboards and reports, and delivering actionable insights for business, strategy, and operations teams. Strong communicator with exposure to Agile/Scrum environments and stakeholder presentations.
Overview
1
1
Certification
Work History
Data Analyst Intern
Ai Variant
10.2025 - Current
- Analyzed structured datasets (10k-15k+ rows) to identify delinquency patterns, transaction trends, and performance KPIs.
- Performed end-to-end data analysis using SQL joins, partitions, and ranking functions.
- Built 3 interactive dashboards using Power BI, Tableau, and Advanced Excel.
- Automated weekly reporting workflows, reducing manual effort by 30-40%.
- Designed Power BI data models and DAX measures for stakeholder reviews.
- Collaborated with a 7-member Agile/Scrum team and presented insights to management.
Data Analytics Job Simulation
Deloitte Australia (Forage)
11.2025 - 12.2025
- Completed forensic-style simulations involving data cleaning, visualization, and developed Tableau dashboards and Excel analyses to present actionable recommendations.
Data Analytics Job Simulation
Tata iQ (Forage)
12.2025
- Conducted GenAI-assisted EDA, identified payment-delay and utilization patterns, and proposed a predictive risk-scoring framework.
Education
Bachelor of Engineering - Computer Science
05.2018
Skills
- SQL / MySQL (JOINs, GROUP BY, HAVING, Window Functions)
- Power BI (Data Modeling, DAX)
- Advanced Excel (Pivot Tables, Power Query)
- Tableau (Interactive Dashboards)
- Python (pandas)
- R (Statistics)
- ETL & Data Cleaning
- GenAI Tools for Analytics
- Requirement Gathering & Business Understanding
- Stakeholder Communication
- KPI Definition & Performance Tracking
- Data Visualization & Storytelling
- Reporting Automation
- Problem Solving & Analytical Thinking
- Agile / Scrum Methodologies
Websites
Certification
- NASSCOM Certified Business Analyst, MeitY, Govt. of India, 12/01/25
- Data Analytics Virtual Internship, Deloitte Australia (Forage)
- GenAI Powered Data Analytics, Tata Group (Forage)
- Business Analyst Certification, ExcelR, 11/01/25
- Certificate in Java Programming, Maharashtra Business Training Board, 02/01/17
- AI Career Accelerator, BE10x, In Progress
Projects
Zomato Restaurant Analytics, Analyzed 10k rows × 21 columns to identify top-performing cities and customer trends using SQL and BI dashboards. AI-Driven Customer Delinquency Risk (Tata iQ Simulation), Identified payment delay patterns and proposed scalable risk-scoring rules using Power BI and GenAI tools.
Languages
- Hindi (Fluent)
- Marathi (Native)
- English (Fluent)
- Hindi (Fluent)
- Marathi (Native)
Core Other Skills
- Requirement Gathering & Business Understanding
- Stakeholder Communication
- KPI Definition & Performance Tracking
- Data Visualization & Storytelling
- Reporting Automation
- Problem Solving & Analytical Thinking
- Agile / Scrum Methodologies
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Marathi
Native
Native
Timeline
Data Analytics Job Simulation - Tata iQ (Forage)
12.2025
Data Analytics Job Simulation - Deloitte Australia (Forage)
11.2025 - 12.2025
Data Analyst Intern - Ai Variant
10.2025 - Current
Cummins College of Engineering For Women - Bachelor of Engineering, Computer Science