Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Languages
Personal Information
Projects And Analytical Tools
References
Timeline
Generic

Sagar Tatkare

Melbourne,Australia

Summary

Aspiring Business Analyst with expertise in sales strategy, client engagement, and market research. Currently pursuing a Master’s in Business Analytics at Deakin University. Proficient in SQL, Excel, Tableau, and Power BI, aiming to apply analytical skills to enhance data-driven decision-making and address complex business challenges. Seeking internship to contribute actionable insights and innovative solutions. Detail-oriented Assistant Manager offers more than extensive progressive record of accomplishment in leadership roles. Establishes clear guidelines and enforces consistent policies to keep staff satisfied and on-target to achieve important objectives. Excellent relationship-building, multitasking, and decision-making skills.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Assistant Manager – Business Intelligence

MakeMyTrip India Ltd
Mumbai, India
09.2021 - 06.2024
  • Managed a portfolio of 250+ hotels, using performance dashboards and KPIs to drive revenue optimization.
  • Conducted site audits and presented data-driven reports to improve partner performance and increase occupancy by 15%.
  • Created MIS reports and market intelligence dashboards using Excel and Power BI.
  • Implemented dynamic pricing models based on ARR, RevPAR, and competitor analysis.
  • Supported forecasting and budgeting using demand trends and historical data.

Market Research Intern

Big Bazaar Retail (Future Group)
Mumbai, India
06.2020 - 07.2020
  • Collected and analysed over 100+ customer surveys to derive retail space and product assortment insights.
  • Recommended data-backed promotions that led to a 15% increase in category sales.
  • Used Excel to present trend data for seasonal marketing strategies.

Market Research Intern

United Breweries Ltd.
Mumbai, India
12.2019 - 01.2020
  • Analysed liquor consumption patterns and compiled competitor insights for marketing teams.
  • Built reports to support price positioning, promotional strategies, and distribution planning.

Education

Master of Science - Business Analytics

Deakin University
Melbourne, Australia
06.2026

MBA - Marketing

Mumbai University
Mumbai, India
08-2021

Bachelor of Engineering - Electronics Engineering

Mumbai University
Mumbai, India
08-2016

Skills

  • Excel and SQL
  • Power BI and Tableau
  • Business intelligence and reporting
  • Forecasting and revenue management
  • Stakeholder communication
  • Data visualization and dashboarding
  • CRM and ERP systems
  • Analytical problem solving
  • Agile methodologies
  • SDLC processes

Certification

  • SQL for Data Analysis – Udemy
  • Tableau for Hotel Revenue Management – Coursera
  • Power BI for Business Analysis – Microsoft
  • Hotel Revenue Management – eCornell
  • Agile Business Analysis – Simplilearn
  • Power BI Essential Training – LinkedIn Learning
  • Fundamentals of Sales & Marketing – Northeastern University

Accomplishments

  • 120% YoY GMV growth at MakeMyTrip through pricing analytics and targeted sales.
  • Ranked Top 10 nationally in KRA performance dashboard (2022–2023).
  • Awarded 'Go Tripper' title 7 times for top performance across India.
  • Led the onboarding of 50+ hotel partners using competitive data and market strategy.

Languages

  • English (Fluent)
  • Hindi (Fluent)
  • Marathi (Native)

Personal Information

Title: Business Analytics Intern

Projects And Analytical Tools

  • Hotel Revenue Dashboard, Power BI, Created a dashboard to analyse occupancy trends, RevPAR, and seasonal demand.
  • Customer Segmentation, Excel + Tableau, Clustered hotel partners by performance metrics to prioritize account management focus.
  • SQL Queries, Extracted and transformed hotel booking data for insights into booking patterns and cancellation rates.
  • Predictive Modelling, Used regression in Python to forecast room demand based on historic trends and events.

References

References available upon request.

Timeline

Assistant Manager – Business Intelligence

MakeMyTrip India Ltd
09.2021 - 06.2024

Market Research Intern

Big Bazaar Retail (Future Group)
06.2020 - 07.2020

Market Research Intern

United Breweries Ltd.
12.2019 - 01.2020

Master of Science - Business Analytics

Deakin University

MBA - Marketing

Mumbai University

Bachelor of Engineering - Electronics Engineering

Mumbai University
Sagar Tatkare