Overview
Work History
Education
Extra-Curricular Activities
Positions Of Responsibility
Affiliations And Awards
Hobbies and Interests
Timeline
Generic

Sanat Jain

Gurgaon

Overview

10
10
years of professional experience

Work History

Senior Manager Business Intelligence, Analytics and Data Science

Nykaa
01.2023 - Current
  • Playing multiple roles including Individual centric and people manager.
  • Trained, mentored, and managed a team of 10 highly coordinated, skilled, and efficient analysts in uncovering actionable product, business, marketing, website, and consumer insights with goals to drive the analytics efforts for the Brand and Category management team.
  • Scored the Nykaa Beauty Catalog dashboard based on Fill rate and Quality of data by comparing the data with the competitive Website Myntra and Amazon.
  • Managed the team of 4 that Designed, Developed the KPI tracker to extract Action items with CXO's and management monthly.
  • Brand and Category Data Sharing- Identified, Instrumentalized the KPI for different brands/Category and created the monthly automated pipeline to roll out the monthly brand performance with the respective category and brand management head. This helped the team to track important KPI's like traffic, AOV, ASP and Revenue.
  • Off boarded The Off-role team and helped in setting up the in-house Analytics Team from Scratch resulting in better quality work and actionable insights and saving huge cost.
  • Automated the Cohort analysis to get the Monthly, Quarterly, Half yearly retention at Customer, Revenue, Order and Lifetime Value Cohort.
  • Owned the Automation drive of Adhocs and repetitive tasks resulting in increased band width. With reduction of 3 FTE's, team can now focus more on advanced analytic requirements like Makeup softness, ABS drop, Quality of Customer etc.
  • Helped the category teams to build Makeup and Skin regimes using the Market basket analysis and Category Affinity to increase the Category width and Virtual combos' creation resulting in incremental revenue of 7%.
  • Customer Affluence Segment- Managed the team of 2 that created 4 customer cohort based on affluence to target specific user groups with personalized experiences on Homepage and Native landing pages. Ran multiple experiment in cross collaboration of Various teams.
  • Conducted and analyzed A/B tests on Personalization algorithms to determine the impact on user engagement and conversion rates and revenue upliftment based on user segmentation models and validate the model output.
  • Designed a detailed document for making the onboarding of new employee in Central analytics team and reduced the onboarding time by 50%. This has smoothened the onboarding for online and offline candidates.

Business Intelligence Engineer 2 (Manager Grade)

Ola
09.2021 - 01.2023
  • Playing multiple roles including Individual centric and people manager.
  • Managed the team of 4 that Designed, Developed and Enabled the mobility business team with 100 plus KPI's to extract actionable insights on business performance across demand, supply, pricing and fulfillment categories to power real time dashboards and standard reports.
  • Built an ETL layer and designed the pipeline that captures all the facts and KPIs to define the operational strategies and help in improving the efficiency for Vehicle journey from factory to SDC (Scooter Delivery Centre) to Customer and got the Appreciation from CIO (Chief Information Officer).
  • Automated the live alerts for Registration partners and document verification team on the basis of Turnaround time (TAT) for different processes involved in First and Last Mile delivery and improved the operational efficiency by 50%.
  • Developed and owned the User Base Fact - A Data Asset and a single source of truth with 150 plus user facts and attributes used to represent behavioral, loyalty, financial, demographic, p-mix and campaign profiles of the end customer.
  • Owned a Mobility Product Experience and Funnel Dashboard that enabled strategies on Demand Drop-off and funnel conversion, booking funnel, Pickup and Drop experience, Safety, Support and Payments. This is being used by the top leadership and CEO's office for taking critical business decisions.
  • Owned a BI pipeline that calculates metrics for Ola Foods and Dash business to power real time dashboards and standard reports in order to derive strategies on business improvements.
  • Single handedly designed the Demand Estimate Daily for one of the business verticals that clubs all the session in the range of Demand Session start and End time.

Project Lead

Axtria
04.2021 - 09.2021
  • Playing multiple roles including analyst, project lead and people manager.
  • Leading end-to-end project on predicting the Next Best action for Health care professionals (HCPs)that could provide maximum benefits in terms of Profits and Trx(Total prescriptions) using Random Forest and implementing them using the Knime.
  • Lead daily discussions and project handovers from the onshore; managed ad-hoc requests from client.

Senior Associate

Axtria
04.2018 - 03.2021
  • Leading data analytics team for client's Market Access and Management Division.
  • End-to-end involvement in identification of high controlling Integrated Delivery Networks (IDNs). Helping client identifying the IDNs for the best (top-down approach) to be used for sales & marketing efforts instead of bottom-up.
  • In light of the recent COVID-19 situation, US Pharmaceutical Leadership team (PLT) of one of the largest pharma companies want to closely monitor channel performance which includes KPIs like Demand, Supply, Inventory, Hub Enrolments, New Patients based on State lockdown status on weekly basis. Created weekly summary to get hold of significant disruption in Demand (for instance Patients stockpiling leading to artificial jump) and Supply (lower inventory at SPs) along with impact on the production cycle.

Associate

Axtria
04.2016 - 03.2018
  • Worked as an individual contributor to provide analytical solutions to multiple business problems and provide usable and effective solutions to the client.
  • Automated the report generation and quality check process using VBA and R resulting in an increased efficiency by 300%.
  • Created a dashboard performing data warehousing, information management to track sales and streamlined reporting processes.
  • Enhanced calculation to measure adherence of patients; provided valuable insights on drivers of persistence and compliance.
  • Evaluated the impact of nurse calls to make patients more persistent.

Analyst

Axtria
07.2015 - 03.2016
  • Secured $500K+ in annual revenues by servicing 25+ Reports & Dashboards as part of a three-member team.
  • Saved potential loss of $6M+ by designing a model to predict 550+ patients at the risk of discontinuation.
  • Achieved 300% increase in process efficiency by ideating & designing an automated segmentation dashboard.
  • Reduced report creation times by 80%+ and error rate by ~95% by automating the process using R Python and Excel.
  • Co-authored a white paper on 'Driver Score-Parameter to decide insurance premium'- Awarded second position in an organization-wide paper writing competition with a total of 22 entries which is now published on official website of Axtria.
  • Successfully completed 2 months of rigorous training designed by Axtria Institute on Excel, SQL, SAS, Tableau, VBA and statistical modeling along with basic pharma and BFSI domain knowledge.
  • Developed a logistic regression model to predict the delinquent customers for a credit card portfolio for one of the leading banks.

Education

B.E - Electronics and Communication

Netaji Subhas Institute of Technology
Delhi
01.2015

AISSCE - Class XII

Blooming Dales
Hisar
01.2011

AISCE - Class X

K.L ARYA D.A.V Public School
Hisar
01.2009

Extra-Curricular Activities

Co-Founder NSIT BLOOD DIARY Volunteer at Don Bosco Ashalayam and Anugrah Foundation Played for the College Football team

Positions Of Responsibility

  • Placement Coordinator, Training Placement Cell, NSIT, 04/01/13, 06/30/15
  • Director of Club Finances, Rotaract Club of NSIT Regency, 08/01/13, 06/30/15
  • Treasurer, Innovision, NSIT, 12/01/13, 06/30/15
  • Cultural Secretary, Ramanujan Hostel, 08/01/11, 05/31/12

Affiliations And Awards

  • Delhi University Merit Scholarship, 08/01/12
  • Excellence in Academic Proficiency, Ongoing
  • ACE Team Award, Ongoing
  • 99.61 percentile in AIEEE, Ongoing
  • Bravo Award, Ongoing
  • International Olympiad in Mathematics, 2009

Hobbies and Interests

  • Playing Football
  • Getting involved in Social Work
  • Internet surfing
  • Sudoku-solving

Timeline

Senior Manager Business Intelligence, Analytics and Data Science

Nykaa
01.2023 - Current

Business Intelligence Engineer 2 (Manager Grade)

Ola
09.2021 - 01.2023

Project Lead

Axtria
04.2021 - 09.2021

Senior Associate

Axtria
04.2018 - 03.2021

Associate

Axtria
04.2016 - 03.2018

Analyst

Axtria
07.2015 - 03.2016

B.E - Electronics and Communication

Netaji Subhas Institute of Technology

AISSCE - Class XII

Blooming Dales

AISCE - Class X

K.L ARYA D.A.V Public School

Similar Profiles

CREATE PROFILE
Sanat Jain