L

Lovish Pandey

Business Development Executive

Gurugram, Haryana, India6 yrs 3 mos experience

Key Highlights

  • Expert in predictive modeling and data analysis.
  • Proven track record in enhancing sales performance.
  • Strong background in inventory management optimization.
Stackforce AI infers this person is a Data Science expert with a focus on Media and Retail industries.

Contact

Skills

Core Skills

Data ScienceBusiness AnalysisData AnalysisMachine Learning

Other Skills

A/B TestingAmplitudeAnalytical SkillsApache AirflowContent StrategyData StructuresDefining RequirementsFlaskGitHTMLHerokuInformaticaInterpersonal CommunicationMicrosoft ExcelMicrosoft Power BI

About

Learning from the experience

Experience

Disney+ hotstar

Assistant Manager - Strategy & Business

Sep 2024Present · 1 yr 6 mos · Gurugram, Haryana, India · Hybrid

  • Now JioHotstar
  • Category Analytics/Programming Strategy & Content Marketing - Leading Tamil and Malayalam Charters
  • Currently developing a predictive model for forecasting title level acquisitions for revenue forecast , providing foundational data for content green lightning strategy
A/B TestingSQLAnalytical SkillsBusiness AnalysisAmplitudeContent Strategy+4

Tredence inc.

3 roles

Associate Manager - Data Science

Jan 2024Sep 2024 · 8 mos

  • SE performance Analysis
  • Collaborated with a Fortune 100 Travel and Hospitality client to enhance sales agent performance by identifying and implementing traits of top performers.
  • Addressed disparities in sales executive metrics, such as Volume per Guest (VPG) and Close Rate, through exploratory analysis and developed regression and XGBoost models to improve performance.
  • Utilized SQL for data extraction and Python for data manipulation, model development, employing regression and tree-based models to identify key features and applied gradient descent to formulate an Expected VPG calculation.
  • Used various statistical testing methods( Mann Whitney U ,Chi Square , etc.) for tests of fairness for the expected VPG calculation
  • Bad Goods Reduction
  • Worked on methodology to optimize inventory management by developing a mechanism for suggesting supply adjustments.
  • Ideated an automated system to address long-term salvage risk by analyzing root causes and providing actionable insights.
  • Developed supply move recommendations with predefined thresholds and matrices. Leveraged PySpark and SKU segmentation for forecasting.
  • Resulted in a net increase in Customer Order Fulfillment (COF) by 3%.
SQLPython (Programming Language)Defining RequirementsRegression AnalysisPySparkStatistics+2

Consultant

Promoted

Jan 2022Dec 2023 · 1 yr 11 mos

  • Real Estate Analysis
  • Estimated market potential for a leading Container and Ground level office supplier in the construction segment.
  • Analyzed Sales Rep Performance, classified High/Medium/Low value projects/volume products, aiding sales strategy optimization.
  • Delivered ad hoc analyses as per clients' requirements for sales strategy optimization using Python, Tableau, Salesforce, and Forecasting.
  • These ad hoc analyses resulted in savings of ~$500 k for the client in labor management, contributing to a ~$1mn increase in total revenue.
  • Product Pricing optimization
  • Contributed to a 4-member team in a fast-track project to create marketing regions using a 2-step clustering approach using K-Means , supporting the sales team in optimizing product pricing.
  • Successfully implemented methodology by curating data and running models for clustering using Python libraries Sklearn, pandas.
  • Order Cancellations predictions
  • Performed a POC to provide client visibility on order cancellations at different timeframes, demonstrating the relationship between customer/site behavior, climatic conditions, and cancellation risks to aid labor and logistics.
  • Developed multiple classification models for different quantity buckets, aiming to enable plant managers to track scheduled and
  • forecasted quantity for optimized labor and material requirements.
  • Projected cost savings in annual labor were over $2mn+
  • Commercial Services
  • Part of a Rapid Insights Team for a leading CPG Client, where Insights resulted in ~2% enhancement in Strategic Business Objective(SBO) Metrics in verticals such as Accounts Payables and Receivables.
  • Collaborated closely with the client to identify visibility opportunities using Tableau Dashboards and SQL for data extraction
SQLPython (Programming Language)Time Series ForecastingTableauDefining RequirementsStatistics+5

Senior Business Analyst

Sep 2021Dec 2021 · 3 mos

  • War On Waste
  • Assisted a Fortune 500 CPG major in constructing a tool and delivering interactive dashboards, leading to a reduction in excess/obsolete inventory and subsequent wastage.
  • Developed front-end and back-end codes for presenting perishable goods data, contributing to an ~8% decrease in inventory wastage through Python and Tableau analysis, focusing on identified pain areas after dashboard development
StatisticsMicrosoft ExcelMicrosoft Power BIData AnalysisBusiness Analysis

Cognizant

3 roles

Programmer Analyst

Jul 2020Sep 2021 · 1 yr 2 mos · Pune, Maharashtra, India

  • Claims Denial Prediction Model using Python:
  • Predicted the claims that are likely to get denied during payment for multiple US Healthcare provider clients.
  • Developed various regression and classification algorithms by using various Sklearn libraries such as Linear Regression, Decision Trees, Random Forest, CatBoost, XGBoost, Naïve Baye’s
  • Developed interactive dashboards using RShiny.
  • Reduced the rate of inaccuracy to meet SLAs and avoid penalties.
  • Increased the Revenue Collection by 5% .
FlaskSQLPython (Programming Language)Machine LearningR (Programming Language)Data Analysis

Programmer Analyst trainee

Jul 2019Jun 2020 · 11 mos · Pune, Maharashtra, India

  • Collaborated with analytics teams to create business solutions for clients by extensively working on data analysis.
  • Participated in data pre-processing techniques in order to make data useful for creating Machine Learning Models.
  • Developed tools for the deployment of the Machine Learning solutions using packages and frameworks like Flask, and Shiny .
SQLInformaticaInterpersonal Communication

Intern

Feb 2019Apr 2019 · 2 mos · Pune/Pimpri-Chinchwad Area

Education

Jaypee Institute Of Information Technology

BTech - Bachelor of Technology

Jan 2015Jan 2019

Lucknow Public School, Sec-I

Stackforce found 100+ more professionals with Data Science & Business Analysis

Explore similar profiles based on matching skills and experience