Prithvi Raj

Experience

• 

  Hansa Cequity

  Jan 2011 - Jan 2012

  Data Analyst

  - Built personal loan default model for a loan financing company using logistic regression in SAS- Developed marketing-mix-model for a leading FMCG client using linear regression and non-linear regression in SPSS; created planning simulator in MS-Excel using the model’s output to help client to better plan their future consumer promotions and television media spends- Created a rule based customer segmentation in SQL to identify ethnicities of customers of a Digital-To-Home (DTH) client

• 

  Accenture

  Mar 2012 - Mar 2014

  Analytics Analyst

  - Part of Financial Services Analytics team in GTIN in Accenture Management Consulting group- Built propensity models using logistic regression in SAS for various insurance products for a leading insurance company; guided the client is using the models standalone and also to sell next best product to each customer- Explored various classification techniques including – SVM in R, and Neural Network and Ensemble in SAS E-miner – and compared their performance against performance of logistic regression in R to conduct customer segmentation.- Performed text analytics and sentiment analysis on twitter, and secondary research data using tools such as Radian 6 and Simplify 360 to identify major focus issues for a coal mining company and calculated sentiments associated with them to be used in Reputation Management Strategy- Wrote code in 'Revolution R' equivalent to various stages of logistic regression in SAS to evaluate Revolution R's capabilities and cons as compared to SAS Voir moins

• 

  Myntra

  Jan 2014 - Jan 2014

  Business Analyst

  - Created (Recency Frequency Monetary) RFM segments to identify best customers to increase visits on website by 10%- Identified dormant customers for email targeting to increase visits on website by 30% and revenue by 3%- Built and utilized logistic regression model in R to identify customers with high propensity to transact in next 15 days

• 

  Dubai Islamic Bank

  Jan 2015 - Nov 2015

  Analytics Data Analyst

  - Part of Business Planning and Analytics Team- Built cross-sell models for personal loan and credit card using logistic regression in SAS; the model delivery 1.3x convertion rate improvement over BAU approach- Built attrition model to reduce loss due to early settlement of loans using logistic regression- Created 360 degree view of customers by aggregating 600+ variables in Netezza and created visualization in SAP Lumira, and presented summarized view to consumer banking leadership

• 

  OYO

  Nov 2015 - Nov 2016

  Analytics Manager

  - Build and deployed predictive models to identify high potential and high likely transactors- Performed A/B tests to personalize campaigns and measure efficacy of running campaigns

• 

  Epsilon

  Jan 2016 - Jan 2022

  - Created customer segmentation using K-Means in AWS SageMaker to identify loyal and disengaged customers, and profiled them based on their key characteristics to support differentiated campaign strategy for a global FMCG client- Performed market basket analysis in AWS SageMaker to identify opportunities to cross-sell and top competitor SKUs for each of the SKUs of a global FMCG client.- Built and deployed cross sell-and up-sell models using Gradient Boosting Tree in PySpark to increase subscription rate of magazines by 10% per week- Created customer segmentation employing K-Means clustering using Jupyter Lab in GCP to identify profiles of customers with high propensity to download mobile app for a Fortune 100 FMCG client- Generated actionable insights and communicated findings to clients; trained clients on building machine learning models using PySpark and AWS EMR and s3; assisted client in measuring performance of campaigns based on cross-sell model- Predicted future value, and attrition scores of customers using SAS to create segments, and created plan for differentiated offers based on customers' key characteristics for a Fortune 100 logistics client Voir moins

  • Lead Data Analyst, Analytics

    Jan 2020 - Jan 2022

  • Senior Data Analyst, Analytics

    Jan 2016 - Mar 2020
• 

  Amazon

  Jan 2022 - now

  Business Intelligence Engineer III

  - Automated monthly and quarterly YTD YoY reports to summarize sales, and pricing of deals and promotions for FMCG category by building data pipelines using Amazon Datanet- Created SQL based simulation, and automated it using AWS SageMaker for 200+ configuration elements in Amazon's transportation network; suggested 100+ configuration changes to save ~$2MM annually- Created reporting framework, devised metrics, and built dashboard using SQL and AWS QuickSight for configuration change in Amazon's transportation network leading to re-structure of delivery time for ~7% of total Europe volume. Created SQL simulation to show cost savings of ~$15MM annually Voir moins