Divyam Rastogi Email & Phone Number

Bengaluru, Ka, In

Gurugram, Haryana, India

Financial AnalystAnalyzed 70+ Asset purchase/ Share Purchase Agreements (APA/SPA)Prepared 100+ seller payment models as per the earn-out/profit sharing terms of APA/SPA’s.Conducted inventory and cost analysis for ~40 acquired businesses.Tools Used: MS Excel (Macabacus), SQL, Tableau

Gurugram, Haryana, India

Analyst Intern at Bain Capability Network's Consumer Products and Retail Centre of ExcellenceConducted in-depth market analysis and competitor research for Top 5 Indian e-commerce companies.Administered surveys for an Indian fashion e-commerce company, gathering data from ~3000 number of respondents to inform inventory management and consumer behavior strategies.Performed social media sentiment analyses for ~10 e-commerce giants across different categories, analyzing… Show more Analyst Intern at Bain Capability Network's Consumer Products and Retail Centre of ExcellenceConducted in-depth market analysis and competitor research for Top 5 Indian e-commerce companies.Administered surveys for an Indian fashion e-commerce company, gathering data from ~3000 number of respondents to inform inventory management and consumer behavior strategies.Performed social media sentiment analyses for ~10 e-commerce giants across different categories, analyzing ~50K number of social media posts across platforms to gain a comprehensive understanding of customer feedback and perceptions.Providing valuable insights on consumer behavior and preferences to client. Show less

Mumbai Metropolitan Region

Involved in Equity Research and valuations. Researched about Indian agricultural sector, particularly the seed processing niche of it and consequently evaluated listed Agritech companies.

Gurugram, Haryana, India

Involved in daily operations of various skill building initiatives taken by NSFI. Built dashboards, using pivot tables of the data on beneficiaries on MS Excel and presented the same to the stakeholders.