Bhavya Gupta Email & Phone Number

Bengaluru, Karnataka, India

Analytics - Streamlining & Migration- Eliminated multiple reports which showed similar metrics with different cuts into a unified report/dashboard for everyones consumption (Reduced analytics workload by 15-25%)- Identified key insights which helped optimize the home page leading ~10% increase in listening mins- Handled the migration of data and dashboards from GCP to Databricks - Market Mix Model - Identified thresholds for marketing budgets across channels to identify lowest CAC while achieving/over-achieving revenue targetsGo To Market (GTM) - Business Model Expansion- Launched pay as you go (coin base pricing model) alongside subscription business- Conducted market research and set-up pricing and retention models to identify goals needed to achieve profitability- Guided the integration of finance and tech to ensure revenues are appropriately accounted forEnhanced Customer Experience- Set-up a complete User Journey using various Communication methods to increase user retention- Identified key drop-off points of users and helped solve for them to increase retention by 20%

Business Growth- Set-up revenue models which enabled the company to increase ARPU by 2x without increasing spends- Finalised pricing for the subscriptions business after analysing multiple price points to maximise LTV and understand price elasticity of the users- Helped streamline business metrics reports across the org, which enabled efficiently run weekly business review meetings Investor Relations- Maintained monthly reports of KPIs that were shared with investors- Engaged with VCs & PEs to understand and answer their questions around the business- Set-up processes to reduce finance teams workload by 66% (3 days to 1 day)Go To Market (GTM)- Led the launch of 4 regional languages and managed their journey from 0 to 1- Identified product improvements which helped increase conversion from free to paid by 30%

New Delhi, Delhi, India

Go To Market Sales Force Redesign- Re-imagined the entire US sales force of a major US Pharmaceutical companybased on Covid impact (Annual Sales $2.2 Billion)- Directly engaged with the top leadership of multi-billion Dollar brands to understandtheir needs and ensure smooth delivery of the projectBehavior based Customer Segmentation- Conceptualized a new methodology to analyse customer behavior.- Provided behavior based customer cohorts to implement targeted messaging Covid-19 Impact on Business- Team lead in creating a dashboard to track \& monitor Safe-to-Return US counties.- Devised an analysis to observe doctors treatment affinity to drugs in correlation with Covid Cases in the US and analyzed potential for targeting new markets to attain a higher market share.- Successfully trained fresh graduates despite challenges of remote work.

New Delhi Area, India

- Deployed a marketing strategy and suggested optimal frameworks for product promotions for a major player in the pharmaceutical industry- Optimized reports, using VBA and Python, to reduce operational time by 33% alongside automating repetitive work during ad-hoc requests- Currently, assisting in the creation of a Jupyter Notebook in Python to deep-dive into data and create dynamic visualizations

Mumbai Area, India

- Dealt with Market research in the Equity Derivatives business.- Market research for the Asia Pacific Derivatives Desk based upon the fluctuations in Equity Structured products due to ongoing market events- Also worked to operationalise and automate existing processes leading to a 75% reduction in time

Hyderabad Area, India

- Led a club of 60 Shutterbugs- Conducted a photography fest comprising of top photographers as speakers and judges, Workshop by Nikon, Exhibition by Tamron- Collaborated with another club to start photojournalism on campus

Vishakhapatnam Area, India

- Led a team of 15 interns to create a handbook on basics of construction management of large scale residential projects

New Delhi Area, India

- Worked on brand launch events across 4 cities. - Part of the operations team which overlooked the execution of the events.

Minor In Finance, Finance, General

Projects - Securities Analysis using Modern Portfolio Theory - Studying the behavior of Indian Futures Market compared to Spot Markets

B.E. (Hons.) Civil Engineering

Activities and Societies: Photography Club, Civil Engineering association, Engineers Without Borders Secretary, Photography Club - Led.

Education record