Gaurav

Data Analyst | Private Equity | Business Intelligence
Delhi, IN.

About

Highly analytical Data Analyst with experience in private equity due diligence and strategic consulting, leveraging advanced data tools to drive investment decisions and optimize business outcomes. Proven ability to translate complex data into actionable insights, enhance operational efficiency, and develop innovative technical solutions for diverse industry challenges. Eager to apply robust data science and engineering skills to high-impact roles.

Work

Bain & Company
|

Data Analyst (Private Equity Group)

Delhi, Delhi, India

Summary

Led data-driven strategic and commercial due diligence for high-value private equity deals and global expansion initiatives, optimizing investment decisions and market entry strategies.

Highlights

Enabled investment decisions for a $2.2B private equity deal (client with $7B+ AUM) by identifying key risks via detailed financial and operational due diligence, optimizing value creation and returns.

Supported global expansion for a $200B global media conglomerate by conducting strategic and commercial due diligence for new product entry into Southeast Asia, aligning recommendations with regional consumer behavior.

Delivered M&A strategy for a ~$90B semiconductor client by leveraging data insights from an 8.3% CAGR sector to assess long-term strategic viability and investment impact.

Improved product-market fit for a $200M+ wipe manufacturing company by identifying Key Purchase Criteria (KPCs), enabling product adjustments and forecasting ~8% growth over 5-6 years.

Conducted commercial due diligence for a private equity firm evaluating a $35B+ pharmaceutical packaging company, analyzing market dynamics, KPCs, and growth drivers.

Devised go-to-market strategy for an EHR software firm in a ~$12B US market (45% of global EHR revenues) by conducting market analysis of top U.S. hospitals and identifying key competitive positioning indicators.

Executed strategic due diligence for an email security software firm, assessing ~$2.1B in 2024 with ~60% cloud deployment share by analyzing customer sentiment and competitive positioning.

Developed a browser extension for web data scraping, reducing manual effort by ~40% and saving time through streamlined data extraction and processing for multiple teams.

Indian Oil Corporation Limited
|

Summer Intern (M&I Department)

Delhi, Delhi, India

Summary

Streamlined maintenance and inspection processes and enhanced operational efficiency through data management and documentation for the M&I Department.

Highlights

Reduced manual effort by ~20% through maintaining daily logs and device data in structured MS Excel sheets, thereby streamlining operational tracking.

Improved equipment reliability and minimized downtime by supporting the Maintenance and Inspection team in asset monitoring.

Enhanced documentation quality and internal communication by contributing to daily maintenance reporting and technical documentation across teams.

Supported preventive maintenance planning through analysis of historical logs and recurring equipment issues, enabling data-driven prioritization of high-risk components.

Education

Delhi Technological University, New Delhi
New Delhi, Delhi, India

B.Tech

Electrical Engineering

Grade: 6.9 CGPA

Courses

Achieved 97.28 percentile in JEE Mains (Joint Entrance Examination)

Convent of Gagan Bharti Sr Sec Public School
Ghaziabad, Uttar Pradesh, India

CBSE

Class XII

Grade: 91.5%

Convent of Gagan Bharti Sr Sec Public School
Ghaziabad, Uttar Pradesh, India

CBSE

Class X

Grade: 87.5%

Awards

Bain-A-Thon 2025 Finalist

Awarded By

Bain & Company

Recognized as a finalist among 200+ participants in Bain & Company's case study competition, demonstrating strong analytical and problem-solving skills.

Languages

English

Certificates

Tableau Certification

Issued By

Tableau

ChatGPT Prompt Engineering Certification

Issued By

Various Providers

Alteryx Certification

Issued By

Alteryx

Data Structures and Algorithms (DSA) Certification

Issued By

Code Help Learning Platform

Skills

Analytical Tools

Python, Advanced MS Excel, Tableau, SQL, PowerPoint.

Programming Languages

C++, Python, JavaScript.

Web Technologies/Databases

CSS, ReactJS, ExpressJs, NodeJS, Firebase.

Development Tools

MySQL, Outlook, Teams, Git, Visual Studio Code.

Computational Skills

Data Structure and Algorithms, OOPs, Pandas, NumPy, Matplotlib.

Interests

Hobbies & Interests

Badminton, Chess, Cooking, Sketching.

Projects

Interactive Tableau Dashboard

Summary

Developed a dynamic Tableau dashboard for comprehensive business intelligence, visualizing profit, revenue, quality, and sales data across multiple years.

Answer BOT

Summary

Developed a real-time question-answering website utilizing the Gemini API, featuring a history tab for enhanced user experience.