Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Languages
Core Other Skills
Languages
Timeline
MUGDHA GOKULDAS BAGUL

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

Cummins College of Engineering For Women
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
MUGDHA GOKULDAS BAGUL