Summary
Overview
Work History
Education
Skills
Timeline
Projects
Projects
Generic
Prashant Kumar

Prashant Kumar

Analytics Consultant
Noida

Summary

Seasoned analytics & data science professional with 7 years track record of providing exceptional services in client facing role for analytics projects. Highly-skilled in customer analytics, root cause analysis, data crunching, predictive & descriptive modelling and developing insights for business leaders. Strong self-motivator with an exceptional work ethic.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Consultant - Product Analytics

Xeno - The Future of CRM (SaaS)
New Delhi
08.2022 - Current

B2C | Retail - E-commerce and Brick & Mortar

  • Led the product analytics vertical, overseeing a team of 1-3 analysts, and fostered close collaboration with product directors and product operations to drive data-informed decision-making.
  • Improved retention and growth KPIs like CLTV, MAUB etc. by 2-5% over the last 10 months through comprehensive analysis of customer behavior and A/B testing.
  • By leveraging advanced analytics, analyzed marketing campaign data to drive a remarkable 15% increase in campaign effectiveness and a substantial 24% improvement in marketing ROI.
  • Collaborated with marketing and product teams to provide real-time visibility into campaign performance, operational efficiency, and key metrics.

Lead - Product & Data

Wavemaker
Mumbai
08.2021 - 07.2022

Data Strategy - Beauty and Cosmetics

  • Collaborated with cross-functional teams, leveraging analytics, to conduct comprehensive data analysis. Identified patterns, trends, and delivered actionable insights to enhance product features and optimize the user experience.
  • Designing reports for stakeholders and CXOs and helped brand teams to reduce their data analysis time by 50%.
  • Evaluating performance of various platforms & creatives for campaign activation using A/B testing and look-a-like audience planning using various platforms by analyzing customer affinity data.
  • Led a project on data integration and automation. Helped team in visualizing target audience for their go to market strategies and AOP planning.
  • Strategy lead for D2C takeoff strategy for Kerastase - L'Oreal.

Assistant Manager - Analytics

Netscribes
Mumbai
04.2020 - 07.2021

Customer Analytics - F&B - Energy Drinks

  • Led a team of analysts dedicated to specific clients, overseeing their work and ensuring successful project outcomes.
  • Conducted proof-of-concept (POC) projects for prospects, monitoring business growth and providing solutions for business problems.
  • Managed multiple visualization projects using Power BI to extract actionable insights, empowering internal stakeholders with impactful deliverables and data-driven decision-making.
  • Developed and implemented data-driven solutions to optimize business processes and enhance operational efficiency.

Associate Consultant

Cartesian Consulting
Bangalore
05.2017 - 03.2020

Management Consulting - Retail and Hospitality

  • Applied customer analytics and built statistical models to drive insights and improvements.
  • Managed end-to-end analytics projects, collaborating with cross-functional leaders and CXOs.
  • Leveraged various datasets like sales, CRM, inventory, feedback to provide actionable insights for business heads.
  • Developed interactive Power BI dashboards for retail, buying and merchandising teams, enabling data-driven decision-making.
  • Collaborated with retention and product teams, utilizing marketing analytics techniques and A/B testing to improve conversions.
  • Utilized product analytics to inform product development strategies, enhance customer satisfaction, and drive revenue growth.

Development Apprentice

PRADAN
Torpa
06.2016 - 04.2017
  • Worked on different projects for rural development in Jharkhand state as development apprentice
  • Facilitation and managing team members at community based organization
  • Action research on different aspects of tribal community
  • Work for integration of natural resources associated area

Education

B.Tech - Mining Engineering

NIT Rourkela
Rourkela
06.2016

Intermediate -

Kendriya Vidyalaya
Bulandshahr
2011

High School -

Kendriya Vidyalaya
Bulandshahr
2009

Skills

  • MS Excel
  • SQL
  • R Programming
  • Python
  • Power BI
  • Retail Analytics
  • Regression and Classification
  • Clustering and Recommender Algorithms
  • Root cause analysis
  • KPI Dashboarding
  • Team Management
  • Stakeholder Management

Timeline

Consultant - Product Analytics

Xeno - The Future of CRM (SaaS)
08.2022 - Current

Lead - Product & Data

Wavemaker
08.2021 - 07.2022

Assistant Manager - Analytics

Netscribes
04.2020 - 07.2021

Associate Consultant

Cartesian Consulting
05.2017 - 03.2020

Development Apprentice

PRADAN
06.2016 - 04.2017

B.Tech - Mining Engineering

NIT Rourkela

Intermediate -

Kendriya Vidyalaya

High School -

Kendriya Vidyalaya

Projects

  • Business Expansion Model for Product Launch | Lead Consultant : FnB clients wanted to understand the opportunity areas for product launch. Developed resusable business working model to understand the opportunity areas for product launch and campaign planning for the same.
  • Standardizing reports and Data integration | Assistant Manager :
    At Netscribes, Primary focus was to establish dependability of client on deliverables. Started with migrating excel reports to Power BI and standardizing the simplified data base to use for day to day engagement and providing quality inputs for client's business operation.
  • Prioritization Business Model | Associate : Club Mahindra member's experience team wanted to prioritize member's booking basis member's behavior to minimize the refusal and last minute cancellation. Built statistical model to analyze customer behavior and set rules to prioritize booking preference and dynamic booking window recommendation.
  • Product Assortment Model | Associate Model which finds out the different personas present in the customer base. useful for marketing, buying and merchandising and product teams. Used K-means clustering for segmentation.
  • Buy Plan | Senior Analyst : This is recurring activity carried out by buying and merchandising team of apparel brand, which happens twice a year and requires data backed recommendations for better strategy for new season launch. Used size set optimizer , segmentation to make better understanding in charting out buy
    plan. Used descriptive and predictive analytics.
  • Business Process Calender | Senior Analyst : BPC is a debrief for brand COO for better understanding about the brand position and how brand should move by analyzing feedbacks, sales, inventory and customer data. Used descriptive analytics.
  • Market Basket Analysis | Senior Analyst : Built a re-usable model to find the association between products to uplift the auxiliary product sales by infusing idea of bundling of best products which are most likely to being bought in a bucket. Used apriori algorithm.
  • Churn Model | Analyst : Built a statistical model by using logistic regression to predict the probability of customers who are going to churn out from CRM program. Used R, SQL and Excel to carry out whole modelling process and was able to restrict the churn by providing customers for campaigns.
  • Store Clustering | Analyst : Built a reusable docket for team and client for store clustering, this model could solve problems related to store or finding out opportunities for particular catchment, modelling was done on R studio , used K-means clustering .

Projects

  • Business Expansion Model for Product Launch | Lead Consultant : Tacobell India wanted to understand the opportunity areas for product launch. Developed re-usable business working model to understand the opportunity areas for product launch and campaign planning for the same.
  • Standardizing reports and Data integration | Assistant Manager : At Netscribes, Primary focus was to establish dependability of client on deliverables. Started with migrating excel reports to Power BI and standardizing the simplified data base to use for day to day engagement and providing quality inputs for client's business operation.
  • Prioritization Business Model | Associate : Club Mahindra member's experience team wanted to prioritize member's booking basis member's behavior to minimize the refusal and last minute cancellation. Built statistical model to analyze customer behavior and set rules to prioritize booking preference and dynamic booking window recommendation.
  • Product Assortment Model | Associate: Model which finds out the different personas present in the customer base. useful for marketing, buying and merchandising and product teams. Used K-means clustering for segmentation.
  • Buy Plan | Senior Analyst : This is recurring activity carried out by buying and merchandising team of apparel brand, which happens twice a year and requires data backed recommendations for better strategy for new season launch. Used size set optimizer , segmentation to make better understanding in charting out buy
    plan. Used descriptive and predictive analytics.
  • Business Process Calender | Senior Analyst : BPC is a debrief for brand COO for better understanding about the brand position and how brand should move by analyzing feedbacks, sales, inventory and customer data. Used descriptive analytics.
  • Market Basket Analysis | Senior Analyst : Built a re-usable model to find the association between products to uplift the auxiliary product sales by infusing idea of bundling of best products which are most likely to being bought in a bucket. Used apriori algorithm.
  • Churn Model | Analyst : Built a statistical model by using logistic regression to predict the probability of customers who are going to churn out from loyalty program. Used R, SQL and Excel to carry out whole modelling process and was able to restrict the churn by providing customers for campaigns.
  • Store Clustering | Analyst : Built a re-usable docket for team and client for store clustering, this model could solve problems related to store or finding out opportunities for particular catchment, modelling was done on R studio, used K-means clustering .
Prashant KumarAnalytics Consultant