Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Awards
Personal Information
Timeline
Generic
Apoorv Mehta

Apoorv Mehta

Bangalore

Summary

Result-driven individual with high ownership and impact. Proven track record of delivering timely insights and provide recommendations to drive business growth and improve customer experience metrics

Overview

10
10
years of professional experience

Work History

Specialist 2 - Data Science

HP Inc.
Bengaluru
06.2024 - Current
  • Led the connectivity flow of HP printers from the discovery of the device on the HP Smart app to the network connection.
  • Developed an analytical framework capturing consumer printer performance (setup, onboarding, and usage).
  • Developed clickstream pipeline capturing end to end User Activity on HP Smart app thereby enabling actions
  • Conceptualized and developed Getting Connected Flow using Wifi Telemetry, Front end Telemetry - tracking metrics like Latency across screens, Setup Success Rate, CC calls RCAs driving actions and recommendations
  • Built Analyst Co-pilot - with GPT -4o - A solution to produce automated Insights for a Problem Statement
  • Worked on problem to tasks, text2sql spaces; techniques - Prompt Engineering, Langgraph, RAG Architecture

Manager - Analytics

Myntra Pvt. Ltd
Bengaluru
02.2022 - 06.2024
  • Designed and Developed Return Abuser Framework - Charge high return customers 199/299/- at order level
  • Conceptualized and developed Size Reco. Framework based on customer returns and style prime attributes
  • Conceptualized and developed couple of Attribution Models - a) Attributing spike/drop of returns to features like Speed, Selection, Price etc. b) Model to classify each return on platform to one of the hypotheses
  • Developed Styles Delisting Framework - Framework to identify low performing styles on the platform and thereby delisting/Blocking further replenishment. Realised Impact ~30 bps
  • Fraud Prediction Model - Developed a Classification Model to predict fraudulent customers early in their purchase journey. Techniques/Models used - XGBoost, Oversampling, AUC-ROC, OOS Testing
  • Built PQI score at style/seller level to identify styles performing bad in PQ - Impact - 0.02 on platform rating
  • Platform Fee Rs 20/- Launched A/B experiment to evaluate ROI on charging platform fee to customers. With positive results, this experiment was scaled 100% with a monthly collection of ~20-25 crore
  • Free Shipping A/B - Launched A/B experiment to check ROI on charging ps2-4 shipping fee.
  • RCA on RTO spike - Identified one of the root causes in RTO spikes leading to 10-20 bps RTO goodness
  • Other A/B experiments - Warning customers on returns (-ve ROI), social proofing (high returns on test set), Differential Platform fee(CX hit, higher RPU drop)
  • Product Happiness Quotient - Built PHQ as a check metric for initiatives taken in Product Quality charter

Data Scientist

Accenture
Bengaluru
05.2021 - 02.2022
  • Digitally transforming hiring process of monthly 100K+ hourly workers using Python, SQL and PowerBI
  • Supporting client with adhoc data analysis and dashboard requirements to streamline workforce management

Business Analyst

PolicyBazaar.com
Gurgaon
10.2017 - 05.2019
  • Generated ₹ 10 Cr additional revenue Implemented COR Model in motor vertical
  • Ideated Payment First in motor insurance customer journey; improved in selection to conversion by 17%
  • Led E2E integration process; brought 5+ clients onboard generating 500+ monthly additional bookings
  • Led the process of launching 3 - year brand new car plans leading to increase in average ticket size by 3X
  • Ideated and launched 12+ commercial insurance plans; led to net growth of ₹ 15 lakhs in monthly revenue
  • Executed world's 1st digital behaviour-based pricing logic with 80% cheapest rates in car insurance market
  • Predicted the premiums to be charged; improved Policybazaar's competitiveness with competitors by 3%
  • Analysed motor renewal business; reduced error percentage from 30% to 5% leading to renewals increase
  • Single point of contact for data requirements and monthly reconciliation of 600+ insurance policies
  • Prepared integration roadmaps for 30+ bundled/standalone plans; annual premium increase of ₹ 1.8 Cr
  • Managed a team of 70+ sales agents single-handedly and extended technical/product support throughout
  • Represented Motor vertical to 15+ clients; facilitated transition from business requirements to production

System Engineer

TATA Consultancy Services
Gurgaon
08.2015 - 10.2017
  • Company Overview: Gurgaon
  • Worked on multiple initiatives to uplift fraud detection capability of one of the leading banks in London
  • Developed an algorithm to block bad devices from login leading to a 5% decline in fraudulent transactions
  • Gurgaon

Education

MBA - Business Analytics

SCMHRD
Pune
01.2021

B.Tech. - Computer Engineering

College of Technology, GBPUAT
Pantnagar
01.2015

Class XII - CBSE

Kendriya Vidyalaya, F.R.I
Dehradun
01.2011

Class X - CBSE

Kendriya Vidyalaya, F.R.I
Dehradun
01.2009

Skills

  • Data analysis
  • Machine learning
  • SQL programming
  • Statistical modeling
  • A/B testing
  • Predictive modeling

Accomplishments

  • Recognised by Flipkart Group Finance Conference for contribution in Returns at Myntra
  • Top 3%/11 lakhs of candidates in AIEEE; Top 3 in Class X and Class XII Board exams 2023
  • Merit Scholarship worth ₹ 5000 for being among the top 1.5% of all Kendriya Vidyalaya students in Class XII examinations

Awards

  • Top Performer, TATA Consultancy Services, 2016
  • Quarterly Award, HP Inc., 2023
  • Annual Award, Myntra, 2023
  • Consecutive Quarterly Awards, Myntra, 2023

Personal Information

  • Age: 32
  • Gender: Male

Timeline

Specialist 2 - Data Science

HP Inc.
06.2024 - Current

Manager - Analytics

Myntra Pvt. Ltd
02.2022 - 06.2024

Data Scientist

Accenture
05.2021 - 02.2022

Business Analyst

PolicyBazaar.com
10.2017 - 05.2019

System Engineer

TATA Consultancy Services
08.2015 - 10.2017

MBA - Business Analytics

SCMHRD

B.Tech. - Computer Engineering

College of Technology, GBPUAT

Class XII - CBSE

Kendriya Vidyalaya, F.R.I

Class X - CBSE

Kendriya Vidyalaya, F.R.I
Apoorv Mehta