Summary
Overview
Work History
Education
Skills
Rewards
Curriculum Dissertation Projects
Tools Expertise
Affiliations
Accomplishments
Timeline
Generic
Chanchal Gupta

Chanchal Gupta

Pune

Summary

Seasoned Data Scientist experienced working with large datasets, breaking down information and applying interpretations to complex business concerns. Proficient in distribution, predictive and hypothetical modeling. Bringing 10+ years of related experience strengthening company operations.

Overview

12
12
years of professional experience

Work History

Lead

Bajaj Finserv (Data Science & Engg. Unit)
Pune
01.2023 - Current
  • Handling Data Science team of 5 members to work across various B2B products with each member responsible for different product
  • Customer Propensity analysis for Rural Consumer Loans for specific products for the current financial year
  • Call center efficiency improvement for better customer reach using combination of Customer Propensity analysis and multi-channel orchestration methodology for a given product
  • Product and competitor analysis for the new business launch by analyzing the sales across 3 years; along with location finalization for product launch for the first phase of launching period.
  • Customer segmentation analysis to identify a set of customers with high probability of conversion.
  • Cross sell analysis for a group of products by segmentation analysis of customer to identify next product to be bought by the customer

Lead Engineer II

John Deere (Warranty & Reliability)
Pune
05.2019 - 05.2021
  • Won 1st Prize for Best Presentation Delivery for Reliability System Modeling: Feasibility Impact and Advantages in TCI Annual Conference and R1 LETS
  • Paper presentation in TCI Annual Conference and R1 LETS on “Application of artificial intelligence methodology for Warranty Cost Modeling”
  • Paper presentation in Spoorthi ’20 (Wave II) on “Association Rule mining with Deep Learning in Primary and Secondary Failure Prediction & Replaced part identification”
  • Paper presentation in international conference on Predictive & Predictive Maintenance (RAMS ’20)

Consultant

Infosys BPM (Quality Solutions)
Bangalore
09.2014 - 05.2019
  • Customer profiling for the identification of probable customers for attrition and predict revenue loss at monthly basis, using logistic regression and random forest method
  • Fraud transactions identification to reduce the time taken to audit sample selection for the banking client, using logistics regression
  • Customer profiling for the identification of probable customers for payment of remaining income tax for Income Tax Department, using logistic regression
  • C-Sat survey analysis using NLP on the free text provided by the customers to identify the root cause for customer dissatisfaction and increase the C-Sat score
  • Process study performed and data insights provided to engagements, for backlog reduction in data process, shift planning according to the volume arrival pattern & location wise comparison of agent efficiency performed to capture the best practices across globe
  • E-module created for organization wide training on Effort Estimation, to solve the problems in future
  • Effort estimation tool (Excel based) developed to streamline and standardize the process of FTEs calculation at RFP stage

Assistant Manager

Concentrix (acquired IBM Daksh) (Research & Analytics Deptt.)
Pune
06.2012 - 08.2014
  • Forecasting for the staffing problem of client using ARIMA methodology using SAS, for several engagements. Call volume forecasted with 5% of MAPE value.
  • Prioritize the policies for the communication establishment for revival of policies using the decision tree, multinomial logistic and logistic regression to get the prioritized customer for communication. Premium collection increased to 7-fold from 3crores/month to 20crores/month.
  • Forecasting and optimization for staffing problem of client using ARIMA methodology

Education

M.Tech. (Quality, Reliability and Operations Research) -

Indian Statistical Institute
01.2011

B.Tech. (Electrical Engineering) -

Dr. K. N. Modi Institute of Engineering and Technology
01.2008

12th -

C.B.S.E. Board
01.2002

10th -

C.B.S.E. Board
01.2000

Skills

  • Customer Research
  • Data Mining
  • Statistical Analysis
  • Machine Learning
  • Deep Learning
  • Database Management
  • BI Tools Expertise
  • Database Structures
  • Advanced Data Mining
  • Data Modeling
  • Data Validation
  • SQL
  • Statistics and SAS
  • Python Programming
  • Business Intelligence
  • Root Cause Analysis
  • SQL Expert
  • Process Improvement

Rewards

  • Best data analytics project of the year for the year 2017
  • Suggested business idea identified as one of the top 6 ideas for Big Idea awards from CEO for 2017
  • Suggested business idea identified as one of the top 6 ideas for Big Idea awards from CEO for 2018
  • Best Process Improvement Consultant of the Oct. ’18 quarter
  • Best in Theme award under Data Science Theme at Spoorthi ‘20
  • Winning 1st Prize for Best Presentation Delivery for Reliability System Modeling: Feasibility Impact and Advantages

Curriculum Dissertation Projects

  • SVM based classification and regression models for mechanical properties of steel coils: Variables affecting the mechanical properties of coils were chosen by statistical knowledge and industrial expertise. Classification and regression method applied to predict the mechanical properties of the coils.
  • Parameter estimation for hyperbolic reliability model, for progressively type-II censored samples: The parameter estimation of hyperbolic reliability model after simulating the data was done and the best optimized progressive censoring scheme was found.

Tools Expertise

  • R
  • Python
  • SAS
  • Minitab
  • MS-Excel
  • MATLAB
  • Etc.

Affiliations

  • Playing Harmonica
  • Solving mathematical puzzles

Accomplishments

  • Best data analytics project of the year for the year 2017
  • Suggested business idea identified as one of the top 6 ideas for Big Idea awards from CEO for 2017
  • Suggested business idea identified as one of the top 6 ideas for Big Idea awards from CEO for 2018
  • Best Process Improvement Consultant of the Oct. ’18 quarter
  • Best in Theme award under Data Science Theme at Spoorthi ‘20
  • Winning 1st Prize for Best Presentation Delivery for Reliability System Modeling: Feasibility Impact and Advantages

Timeline

Lead

Bajaj Finserv (Data Science & Engg. Unit)
01.2023 - Current

Lead Engineer II

John Deere (Warranty & Reliability)
05.2019 - 05.2021

Consultant

Infosys BPM (Quality Solutions)
09.2014 - 05.2019

Assistant Manager

Concentrix (acquired IBM Daksh) (Research & Analytics Deptt.)
06.2012 - 08.2014

M.Tech. (Quality, Reliability and Operations Research) -

Indian Statistical Institute

B.Tech. (Electrical Engineering) -

Dr. K. N. Modi Institute of Engineering and Technology

12th -

C.B.S.E. Board

10th -

C.B.S.E. Board
Chanchal Gupta