SACHIN MALIPATIL
Summary
Passionate analyst with experience in solving complex business problems through data driven decisions
Predictive Analytics: Building gain chart using a classification model to improve the telemarketing performance thereby reducing the campaign cost. Customer segmentation model, where we have built RFM (Recency, Frequency, Monetary) model to increase penetration and target group. Have been part of a customer churn model where I have performed data preprocessing like imputation of missing data, Outlier detection, data visualization, data transformation etc. Performing campaign measurement through A/B testing, observing key KPIs and giving recommendations based on the same. Building a model to restructure the sales incentives
Overview
5
5
years of professional experience
4
4
years of post-secondary education
Work History
Senior Associate(Data Analyst)
Affine Analytics
10.2021
- Analysis of the performance of onboarding and cross-selling campaigns and tracking different KPI’s like Click rate, Bounce rate, Conversion, Usage, seat expansion etc
- Analyzing the product attachment ratio by deciding the target tenants for campaigns Analyzing the churn behavior of the customers based on different criteria like usage, total subscription, and product attachment with other Microsoft products
- Building power bi dashboard according to the Ad hoc requests from senior management.
Senior Decision scientist
Axtria
8 2022 - 1 2024
- Segment prescribers based on their prescribing patterns (e.g., frequency, volume, or diversity of drugs prescribed) and compare them across specialties or regions by building the clustering model
- Prescription and sales trend analysis, analyzing the prescribing behavior of the physicians, adoption analysis and Campaign ROI analysis, We used to analyze the effectiveness of the marking campaigns like(Calls, samples) by measuring the increase in sales and prescribing behavior
- Patient adherence and retention report, Analyze patient data to track adherence to Nuedexta treatment and identify factors that lead to better retention
- You can also identify which patient segments are more likely to discontinue treatment.
Business Analyst
Swiggy
02.2021 - 08.2021
- Analyzing the effect of ads on restaurant partners Based on Market share, customer retention, improvement in GMV, aftereffects of Ads
- Analyzing and changing the incentive structure of sales partners which led to increase in sales by 2%
- Performing A/B testing for newly introduced widget to the platform and observing effect on KPI’s like IPS, CPS, CTR, CVR, etc., and giving recommendations on the same
- Creating/updating Power BI dashboards according to the ad hoc requests.
Senior Software Analyst
Capgemini India
11.2018 - 11.2020
- Building gain chart using classification model to improve the telemarketing performance thereby reducing the campaign cost
- Have been part of a customer churn model where I have performed data preprocessing like imputation of missing data, Outlier detection, data visualization, data transformation etc
- Customer segmentation model, where we have built RFM (Recency, Frequency, Monetary) model to increase penetration and target group.
Software Analyst
Capgemini India
09.2016 - 11.2018
- Coordinating with live customers to resolve issues related to orders Monitoring alarms and other regular running jobs Journaling, cross node
- Handled credit and debit node for operation team
- Handling Interim billing
Education
M.S.Ramaiha college of Engineering (BE)
01.2012 - 04.2016
undefined
Jawahar Navodaya Vidyalaya Bangaluru
01.2012 - undefined
undefined
Jawahar Navodaya Vidyalaya Koppal
01.2010 - undefined
Skills
Power BI Excel Python Seaborn
A/B testing Hypothesis testing T-test Z-test Proportion test
Python, SQL
statistical model(Regressions, Classification Model) Clustering (K-Means)
Timeline
Senior Associate(Data Analyst)
Affine Analytics
10.2021
Business Analyst
Swiggy
02.2021 - 08.2021
Senior Software Analyst
Capgemini India
11.2018 - 11.2020
Software Analyst
Capgemini India
09.2016 - 11.2018
M.S.Ramaiha college of Engineering (BE)
01.2012 - 04.2016
undefined
Jawahar Navodaya Vidyalaya Bangaluru
01.2012 - undefined
undefined
Jawahar Navodaya Vidyalaya Koppal
01.2010 - undefined
Senior Decision scientist
Axtria
8 2022 - 1 2024
Similar Profiles
HARISH VADLAMANIHARISH VADLAMANI
Consultant at Affine AnalyticsConsultant at Affine Analytics
Gourav BoseGourav Bose
Senior Associate at Affine AnalyticsSenior Associate at Affine Analytics
ALTAF UDDIN AHMEDALTAF UDDIN AHMED
Asst. Manager Admin at Affine Analytics Pvt. Ltd.Asst. Manager Admin at Affine Analytics Pvt. Ltd.
Manisha SharmaManisha Sharma
Senior Associate/Data Analyst at Fidelity International Pvt LtdSenior Associate/Data Analyst at Fidelity International Pvt Ltd
Sowmiya SridharSowmiya Sridhar
Senior Associate, Data Analyst at Movate - Palo Alto Network ProjectSenior Associate, Data Analyst at Movate - Palo Alto Network Project