Cricket, Music
Yogesh Kodag
Program Manager – Retail Expansion & Data Analytics
Navi Mumbai
Summary
Dynamic Program Manager and Data Analyst with over 6 years of specialized experience in retail operations and new store development. Expertise in advanced Excel, Power Query, and DAX, supported by a strong background in data modeling, ETL processes, and Power BI dashboard creation. Proven track record in tracking SLAs/KPIs, conducting cost MIS reporting, and performing delay analysis with a focus on root cause identification. Recognized for fostering cross-functional collaboration, enhancing stakeholder communication, and maintaining rigorous data validation and audit compliance to drive operational efficiency and deliver actionable business insights.
Overview
9
9
years of professional experience
3
3
Certifications
3
3
Languages
Work History
Deputy Manager
Reliance Retail
01.2024 - Current
- Leading MIS reporting for 2,800+ store launches across India
- Designed and maintained Power BI dashboards and Excel templates for SLA, readiness, and cost metrics
- Used Power Query for automated ETL workflows and integrated multiple raw data sources
- Built DAX-powered KPIs for zone-wise and project-level performance dashboards
- Improved data quality through audit logic, conditional flags, and error checks
- Collaborated with multiple internal departments for real-time reporting and SLA governance
Assistant Manager
Reliance Retail
03.2021 - 12.2023
- Supported 2,500 SMART POINT grocery store launches across India
- Managed Excel-based trackers for project milestones and vendor SLAs
- Automated reports using pivot tables, formulas & conditional formatting
- Built and distributed zonal dashboards for real-time progress tracking
- Created cost MIS and budget comparison reports using structured formats
- Used Power Query for automated ETL workflows and integrated multiple raw data sources
- Built DAX-powered KPIs for zone-wise and project-level performance dashboards
- Improved data quality through audit logic, conditional flags, and error checks
- Collaborated with multiple internal departments for real-time reporting and SLA governance
- Supervised day-to-day operations to meet performance, quality and service expectations.
Hub Incharge
BigBasket
01.2019 - 01.2020
- Company Overview: B2C Grocery Operations
- Managed hub operations, manpower, delivery, and inventory control
- Created daily/weekly MIS reports for logistics and service KPIs in B2C Grocery Operations
Beverage Associate
Jazz Hotel
03.2018 - 08.2018
- Managed bar operations including stock control, daily beverage MIS, and shift rosters
- Assisted with service audits and guest satisfaction tracking during high-volume events
- Maintained service quality standards and hygiene compliance as per hotel SOPs
Hotel Operations Intern
Sahara Star Hotel
01.2017 - 12.2017
Education
PGDM - Supply Chain Management
Welingkar Institute of Management
01.2023 -
B.Sc - Hotel Management, Tourism
Dr. D.Y. Patil School of Hospitality
01.2017 -
Skills
Advanced Excel formulas
Power Query transformations
Data merging techniques
DAX (Data Analysis Expressions)
Data modelling in Power BI
Drill through functionality in reports
Use of slicers for interactive dashboards
Real-time dashboard development
ETL (Extract, Transform, Load) process expertise
Data extraction from multiple sources
Data transformation for analysis
Structured data loading practices
Conditional logic for flagging and automation
Basic knowledge of VBA scripting
Data validation and consistency checks
Quality control and audit support
SLA and KPI dashboard creation
Cost-based MIS reporting
Delay analysis and root cause identification
Effective cross-functional collaboration
Stakeholder communication and coordination
SOP (Standard Operating Procedure) documentation
Certification
Certified Business Professional Plus: Advanced Excel With Grade A+
Interests
Accomplishments
- Biggest achievement: Developed mini ERP in MS Excel for small organization Hardcarb Pvt Ltd to assign and track daily activity. Also monitoring delays and measuring performance department-wise/team.
- Developed time saving and organized techniques: Cost estimator, Cost WIP, MIS, Contract review form, OTD, Dashboard etc. (Due to this, the daily review meeting was stopped and all status everyone started to know status online).
- Familiar with Data Analysis Tools: Excellent in MS Excel, PowerQuery, Fundamental knowledge of VBA, SQL, PowerBI, Experience in MIS reporting.
Timeline
Deputy Manager
Reliance Retail
01.2024 - Current
PGDM - Supply Chain Management
Welingkar Institute of Management
01.2023 -
Assistant Manager
Reliance Retail
03.2021 - 12.2023
Hub Incharge
BigBasket
01.2019 - 01.2020
Beverage Associate
Jazz Hotel
03.2018 - 08.2018
Hotel Operations Intern
Sahara Star Hotel
01.2017 - 12.2017
B.Sc - Hotel Management, Tourism
Dr. D.Y. Patil School of Hospitality
01.2017 -