Gautam Girotra

Senior Associate at Bain & Co. | ProcDNA | DTU(DCE)

Delhi, India

About

I am a problem solver skills and experience pertaining to Retail Analytics, Healthcare consulting and Sustainability. Currently, I am looking for opportunities in a similar space. I have an experience of 3.5+ years in Consulting and Data analytics. I have hands-on experience on tools like Excel, Alteryx and Tableau. I've always had a knack for entrepreneurship and am constantly looking to challenge myself in new ways

Experience

  • Bain & Company (Gurugram, Haryana, India · On-site)
    • Senior Associate
      Mar 2024 - Present · 2 yrs 5 mos

      Managed a Retail CoE team, delivering for diverse clients: -Led 30+ initiatives for an Indian quick commerce retailer, increasing transaction value and improving economics. -Facilitated merger of 2 US retailers, optimizing procurement and KPIs via PowerBI analytics. -Developed Advanced Retail Buying tool for Middle Eastern pharmacy, optimizing product range. -Formulated better selling approach for UK grocery B2B retailer, achieving 3% margin uplift. -Provided strategic insights for North American retailer, aiding in achieving 30% market share. -Conducted analysis on customer behavior, assortment, and pricing, developing training modules, and awarded BCN Retail Spotlight in 2024

    • Associate
      Apr 2022 - Present · 4 yrs 4 mos

  • Business Analyst at ProcDNA
    Oct 2020 - Mar 2022 · 1 yr 6 mos

    - Provided impactful Commercial Analytics and Technology solutions for healthcare and gaming firms in the USA. - Generated insights for Pharma and Gaming companies' sales-force, marketing, and forecasting teams. - Analyzed KPIs such as market share, sales, and patient metrics across various geographies and accounts. - Led alignment analyses for offshore clients and launched new drugs from an analytics perspective. - Utilized Big Data sources like LAAD and IQVIA OneKey for payer mix analysis. - Completed daily ad hoc tasks, delivered training sessions on tools and business areas for new joiners

  • Equity Research Associate at Kotak Securities
    Jun 2020 - Oct 2020 · 5 mos

    ❖ Created and analyzed numerous portfolios involving equity stocks ❖ Communicated with clients clearly and efficiently regarding portfolio updates ❖ Identified Intraday trades and also analyzed earnings quality and statements

  • Business Analyst Intern at EY
    Jun 2019 - Aug 2019 · 3 mos

     Prepared a Presentation for client EESL (Energy Efficiency Services Limited) using key insights of the EV industry of India.  Prepared Cost Analysis of a Solar and Wind Power Plant and key insights through extensive market research of the industry and learnt Financial Due Diligence with Valuation, Modelling and Economics team.

  • Business Analyst Intern at NBCC (India) Limited
    Jun 2018 - Jul 2018 · 2 mos

    NBCC is a Govt. of India Enterprise and an undisputed leader in Project Management Consultancy and Real Estate Development.  Analysed construction costs for the Development of World Trade Centre project and learnt about the construction practices .  Collected, weighed, analysed and tabulated cost data to be used in developing individual estimates for housing construction.