Nov 2022 – Jun 2023 · 7 mos · Gurugram, Haryana, India · On-site

• Attribution of Assisted Sales Logic– Sales team wanted to understand the actual assistance provided & Sales team contribution in revenue via Calls, SMS, WhatsApp, Email and Form Enquiries. A new logic was built to find the contribution of each medium in Assisted Sales which eventually led to find the agent performance & enhancement in the incentive calculation
• Setting CSAT for different verticals - Prior to Dec’22, CSAT link was being sent to the users on email for the calls. We had lower response rate then. We decided to send type form link to the users on SMS. We are now having better response rate and improved CSAT score
• Chats & Forms Enquiries Performance: We wanted to ensure timely responses to the customer queries coming via Chats. We created the data visibility for the Sales team to improve the response rate. Response rate has increased to 99% in Mar’23 from 81% in Oct’22
• CRM Pipeline for Australia Market –We set up a process for UTM mapping and mechanism for bringing data from all sources and creating visibility for CRM campaigns. Now, the stakeholders can easily understand the impact of changes in the campaigns and deep dive into the funnel analytics
• Product Feed for Facebook Catalogue campaigns Australia - We had been using an API to fetch active listings on platform(website), but faced multiple challenges with it. Therefore, we built a solution from Snowflake to get the accurate data by removing the reserved cars and saving cost

Mar 2022 – Oct 2022 · 7 mos · Gurugram, Haryana, India

• Cohort Analysis & Slots Visibility – In Mar’22, we decided to move from Retail Inspection to Home Inspection. We did a RCA for the loss in appointments & inspections and identified the stores which had a lower share of appointments getting scheduled within T+2 days
• We started capturing visible slots data when the user lands to select slots for Home Inspection. Post having the data captured, we decided to shift the users from >D2 cohorts to <=D2 cohorts as conversion was better
• Duplicate Appointments: ~2.6% of overall verified appointments were duplicate and we eased up of ~1800 slots for inspection to achieve ~350-400 stock-ins
• Actual Seller Survey - To Find the % actual sellers out of customers who interacted with Cars24 at various stages of the funnel viz. Lead, appointment & inspection level. Also, identifying key competition at each level and evaluate potential for exchange offer
• ETL for Slot Occupancy –It is an essential metric for business team and gives the efficiency of a store/city in terms of how much percentage of slots are occupied. A new ETL was created to bring the updated dynamic slot timing and the CJ number was calculated basis the attendance shared by store manager
• Checking Seller Intent at Lead & appointment level – As we had limited slots, so we wanted to prioritize the users based on the intent and improve the funnel metrics. Users providing the Registration numbers and wanted to sell the car in next 2 weeks were high intent users
• Setting MMP across channels – Our team decided to look beyond the Inspections, Purchases and Stock-In and calculate marketing margin per purchase (MMP) across all paid channels – Google SEM, Facebook. DSA and Affiliates. This helped in optimizing the cost. Also, we automated MMP for DSA and Affiliates partners so the stakeholders could identify the partner-city where optimization need to be done and more number of inspections can be scaled up while keeping the MMP as positive

Jul 2021 – Mar 2022 · 8 mos · Gurugram, Haryana, India

• Executing growth strategies for B2B platform partners
• Strategic alliances with Flipkart Supercoins, PhonePe & Paytm Subscriptions
• Growth Analytics for Gift card distribution partners like Qwikcilver, Gyftr & Paypoint
• Optimization of user acquisition via Enterprise partners like NW18, NDTV and Republic media
• Created Dashboard for B2B partnerships for tracking transactions and revenue trend

Nov 2018 – Jun 2021 · 2 yrs 7 mos · Gurugram, Haryana, India

• Identifying, actualizing & tracking growth-focused metrics for business: RPC, BPC, Utilization, ROI & LTV
• Optimizing Utilization of Fleet: Segment-City & Model-City Analysis using Tableau
• Fleet Optimization: New Car procurement, Car shift and Car retirement
• Digital campaigns optimization: Channel-mix analysis, driving down the CAC
• Improving PG Success Rate - Increased Success Rate by 50%
• Fraud detection of Affiliates
• Implementation of New pricing plans
• Projects:
• Tableau Dashboards
• Google Engagement Rewards
• Integration of App analytics tool
• Journey creation on GA & Firebase
• Amazon Pay Integration

Jun 2018 – Sep 2018 · 3 mos

• Statistical Analysis to discover underlying trends and tracking weekly as well as monthly deviation at both category and merchant level; identifying the reasons of deviation and then presenting summary and projections
• Consumer insights –synthesizing users frequency, repetitiveness and dormancy trend , checking quality user drop out pattern – basis RFM model – further breaking it down at gender and age group level
• Operational Research on Payments Success Rate – identifying reasons of failure; exploring Payments opportunities on merchant’s platform
• Cross sell – Movie offers, Flight offers , Uber rides – basis historical behavior of users on a merchant platform
• Campaign planning basis budget allocated and objectivity of merchant/KAM
• Campaign effectiveness basis average spent per txn/user; acquisition of new users or revival of dormant users; increase in txn frequency; tracking promo-code redemptions; conversion rate; monitoring stickiness post campaign
• Automation – Profitability model and customized settlement report

Jun 2016 – Jun 2018 · 2 yrs

• MIS of Payments Business - trends and projections – tracking growth of category and Team Leads on daily basis
• Consumer insights on merchants as well as category to generate behavior of users on multiple platform to assign scorecard; synthesizing users repetitive and dormancy trend to provide recommendations for campaign
• Campaign execution – some prominent campaigns - Uber 555, Uber 222, UBERMOVIE, FLYUBER, Upto 50% cashback, Cashback on nth number of txn of user or on merchant etc
• Manage campaign analytics – Identifying potential base to target them via Push notification , mailer and SMS; and monitoring conversion rate
• Automation of report – PG success rate
• Deck for monthly review and few slides for Board presentation
• Offline collateral management

Jun 2015 – Jun 2016 · 1 yr

• Data analysis and management, Wallet Marketing and Promotions,Sales lead management.
• Analyzing transaction of major players of e-commerce industry.
• Extracting critical information from transaction data and planning campaign on basis of this information.
• Identifying consumer behavior in Food, Transport, Entertainment and Hyperlocal industry.
• Assisting Payments vertical in various Business activities as required (Marketing, Operations).
• Segregating customer on transaction behavior and running targeted promotions.
• Gathering market knowledge on Payments Business.
• Sales lead management. (June-October).

Jun 2014 – Jul 2014 · 1 mo · Greater Delhi Area

• Assisting company management in various Business activities as required (Marketing, Operations).
• Gathering market knowledge on cloud telephony industry.
• Assisting company in sales of cloud telephony products and services.

Jan 2014 – Jan 2014 · 0 mo · Greater Delhi Area

• Documenting research in 20000 word research paper highlighting loopholes in existing tourism policies
• Making concrete policy recommendations to boost tourism in India
• Making policy recommendations to improve tourist safety in India
• Developing a standard redressal mechanism for tourists who have been exploited/ cheated by tour operators/ agencies.