Utkarsh Pande Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

-Led the Marketing Analytics division of the 3rd Largest rummy brand, and collaborated with multiplestakeholders to increase the acquisitions while maintaining quality.- Performed multiple analyses – Fraud detection, user acquisition, cost optimisation, product, improvements, user behaviour, retention etc, increasing revenue by 55% within a year.- Defined KPIs and Created 20+ reports from scratch for leadership and stakeholders.- Helped design multiple campaigns and marketing strategy for CRM

Mumbai, Maharashtra, India

- Managed a complete category from Business to Product; Performed various customer behaviour analyses, Funnel analyses, A|B tests, dashboard creation to improve customer onboarding, retention and experience.- Performed exhaustive funnel analyses to improve customer experience, led to an 6% increase in conversion- Helped improve SIPs’ restart rate from 24% to 33% by performing customer repeat analysis and by pitching ideas.- Performed multiple AB Tests to improve the product; Customer profiling analyses to understand the customer base and to create specific marketing campaign for different profiles

Bengaluru, Karnataka, India

- 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.

Pune, Maharashtra, India

- 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.

Bengaluru Area, India

- 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.

Bhopal, Madhya Pradesh, India