Jan 2022 – Feb 2023 · 1 yr 1 mo · Gurugram, Haryana, India

• ⊛ Conducted 20+ research and analytics-driven due diligences for mid/large cap PE funds including market research, workforce optimization, digital due diligence, disruption assessment for several cash cow industries, competitive benchmarking and target screening
• ⊛ Trained over 20+ new hires on analytics (Alteryx & Excel), research tools/methodologies (CapIQ, Refinitive, Factiva, etc.) and other Bain resources
• ⊛ Automated and tested internal products such as the survey and sentiment analytics tool, using VBA/Python for quicker turnaround times and better quality of output for the clients
• ⊛ Conducted an end-to-end digital due diligence for clients with a focus on understanding social media engagement, the evolution of search interest, web traffic drivers, and assessment of key opportunities to realize growth vs competition
• ⊛ Collaborated with multiple Bain’s divisions and third party vendors to source data on market trends and design B2B, B2C surveys for portfolio companies of the client

Aug 2021 – Jan 2022 · 5 mos · Gurugram, Haryana, India

• ⊛ Developed repositories by processing and analysing data in Excel and SQL to enhance search relevance and generate actionable insights from data, saving over 100+ stakeholder hours every month
• ⊛ Codified methodologies for cases by highlighting key processes and strategies which can be used as templates for case work with clients
• ⊛ Conducted practice area performance analysis using data extracted from Power BI
• ⊛ Collaborated with BCG knowledge experts to curate BD materials, which included client winning proposals and case vignettes for cases across key topics such as corporate strategy and digital roadmaps for banks and financial institutions
• Assist insurance case teams with materials presenting data insights and implications for clients on market landscape, industry trends and company financials

Jul 2020 – Aug 2020 · 1 mo

• ⊛ Analysed stock price movements to find patterns and trends using various technical indicators like Fibonacci Retracements, S&R forecasts, Dojis and different candlestick patterns
• ⊛ Prepared reports on listed companies’ financial statements to determine long term and short term investment horizon in the Indian market

Jul 2020 – Aug 2020 · 1 mo

• ⊛ Reviewed forecasting drivers for modelling of the financial statements to determine the pay out capacity of the company to execute the project
• ⊛ Studied supply chain of the unit and identified measures to reduce freight cost incurred via operations
• ⊛ Assisted in preparation of Discounted Cash Flow and Capital Budgeting reports of the company

Jan 2019 – Feb 2019 · 1 mo · Delhi, India

• ⊛ Conducted industrial research on the hospitality industry and carried out surveys to determine the niche market for the company
• ⊛ Abetted in designing promotional events for the company