Utkarsh Pande

Experience

• 

  Bharat Heavy Electricals Limited

  May 2016 - Jun 2016

  Summer Internship
• 

  Amazon

  May 2018 - Jul 2018

  Process Associate

  - Performed audits and process improvement tasks to monitor and ensure the accuracy of products pricing.- Led a coordinated multi-team deep-dive project to identify the root cause of pricing issue in of the cosmetic segments.

• 

  ZS

  Aug 2018 - Jul 2020

  Decision Analytics Associate (Business Analyst)

  - Analytical Projects: 1. Analyzed product performance by tracking end users’ consistency on the client’s product against its competitors (funnel analysis), the movement to/from competitors’ products, consumption rates, time to convert etc. 2. Performed multiple market dynamic analyses of a competitor’s product as an analogue prior to a product launch to design the marketing strategy. 3. Deciled 7000+ physicians into profitable segments based on their prescription behaviour.Assessed the success of a marketing program by performing Test Control analysis for a targeted sector. 4. ETL Processing and quality assurance of primary data to incorporate with secondary for Segmentation and targeting customers with high rejection rate due to administrative issues and increased market share by 1.8%- Reporting Projects: 1. Created KPI trackers of a newly launched product to understand conversion rates, market cannibalisation and switching trends from competitors’ products. 2. KPI Trackers automation to reduce man-hours from 36 hours to 30 minutes.- Development/Migration (Big Data) Project: 1. Data transition project to big data platform (Hadoop/Hive/Impala) from conventional DBs of SQL/Teradata by managing a team of 3. 2. Performed UAT for data transfers and replication of data processing structure/flow previously done on SQL to data frame concept of Pandas using Spark.sql and Jupyter. Show less

• 

  D Cube Analytics

  Jul 2020 - Apr 2021

  Senior Business Analyst

  - Led a new client engagement and built client relationship by performing a smooth transition from previous vendor.- Optimized processes by automating weekly reporting decks (created by previous vendor) into one-click dashboard and by streamlining delivery process.- Customer Behaviour Analysis: expense and consistency on brand Vs generic products for different insurers.- Created a dashboard with complete industry view - metrics at Insurer, Prescription, Patient, Account level.

• 

  PhonePe

  Apr 2021 - Dec 2021

  Business Analyst

  - Managed the MF category (Business to Product); Customer behaviour analyses, funnel analyses, AB tests, dashboard creation to improve UX, onboarding, retention- Executed exhaustive funnel analyses to improve KYC process, led to an ~7% increase in conversion- Improved SIPs’ restart rate from 24% to 33% by performing customer repeat analysis- Detected best performing Mutual funds based on category, min investing amount, brand, increasing acquisition by 5%

• 

  Gameskraft

  Sept 2022 - Jan 2024

  Senior Business Analyst

  - Led the Marketing Analytics division of the 3rd Largest rummy brand, and collaborated with multiple stakeholders to increase the acquisitions while maintaining quality- Performed RCAs, Fraud detection, user acquisition, cost optimisation, product, improvements, user behaviour, retention, funnel etc, increasing revenue by 55% and reducing CAC by 25% within a year- Defined KPIs and automated 20+ reports from scratch for leadership and stakeholders- Analysed time slots, offers for different segments and reactivation CRM campaigns, increasing blended CTR by 12% Show less

• 

  Pocket FM

  Mar 2024 - now

  Senior Product Analyst

  - Ads analytics pod with the goal to increase revenue while maintaining user experience- Calculated ad opportunities, identified issues and put forth actionable insights, increasing revenue by ~45% and ~20% for two ad formats- Identified users for targeted ads offers with ~0% impact on in-app purchase revenue- Analysed funnel channels to increase user base for rewarding ads by ~8%- Collaborated with tech to improve ads UX by reducing latency by ~22%