NASCAR Lead Management: Established AWS infrastructure and built a centralised dashboard for 239 monthly users to track brand pipeline progress, key metrics, and self-serve reporting
This solution replaced multiple obsolete reports, delivering 15 HC monthly time savings and generating 3.5 K views in the past year
OLP (One Lead Pipeline): Engineered a critical automation layer for NASCAR Lead Management that integrates lead programs, SM signals, and comprehensive brand data
This sophisticated system automates the NASCAR Lead Management UI while providing robust cross-program reporting capabilities, generating approximately 200 HC yearly time savings for Vendor Managers
Vendor Segmentation: Built vendor profiles based on listing experience for a Hold-out and high-profile customer most-wanted brands
This helped analysing listing behaviour of different vendor cohorts which informed our technology vision with actual industry requirements
It revealed why leading vendors struggled to partner with platforms to streamline their listing and catalog management costs
Beacon Migration Pipeline Redesign: Revamped the brand evaluation pipeline to accommodate new data sources and tools, providing VMs with insights across Pre-Pitch Analysis, Brand Identification, and Post-Onboarding stages
Implemented Nielsen data integration and enhanced features, projecting a €250 million 3-year product impact
Senior Data Science Consultant
Ernst & Young
05.2021 - 01.2024
Campaign Analytics: Developed an analytical approach for CD Retention, using Clustering and Rule-Based Algorithms
This strategy significantly reduced out-of-bank money movement for retail products, resulting in a monthly incremental of $210 million
Channel Analytics: Created a custom financial transaction journey mapping engine on GCP using Big Query and Python, reducing mapping time by approximately 300%
Subsequently, worked on customer/journey and channel analysis, including Digital Spillover, Hopper-Dropper, and Customer Sentiment analysis
Propensity to shift to Digital Channel Analysis : Conducted in-depth analysis using Python/SQL to identify customers with a high potential for transitioning from offline to digital channels, leading to a remarkable 9% increase in the digital adoption rate within a month
Implemented this analysis within a classifier framework for ongoing optimization
Senior Business Analyst
Dell Technologies
01.2020 - 05.2021
Propensity to Buy LOB Analysis: Worked on a Machine Learning model using Python and created a data pipeline to forecast customers' propensity for their next Line of Business purchase on a quarterly basis
This model empowered the marketing and sales teams to accurately identify 91% of the total customer base, leading to a remarkable incremental revenue of $74 million over the quarter
Buyer Base Analysis : Developed a comprehensive analytical data pipeline/framework using SQL, Python, Statistics, and SSIS, facilitating in-depth analysis of the Customer Life Cycle (CLC), RFM analysis, and Switch rate for various levels of Dell Technologies support and services
Portfolio Performance Dashboard : Designed and deployed multiple Tableau Dashboards that enhanced visibility into portfolio performance, resulting in a 75% increase in data-driven decision-making and the efficient management of support and services across regions
Portfolio Trend Scanner : Engineered an automated trend scanner that analyzed N portfolio metrics across M levels
This solution efficiently identified issues in trends by analyzing the slope of each metric trend, significantly reducing issue identification time and enhancing efficiency by 35%
Decision Scientist
Mu Sigma
10.2017 - 01.2020
Advanced Customer Targeting: Created a prioritization framework to identify potential customers who are likely to renew their service contract before its expiry
This R and SQL based robust Classifier framework helped the client to increase their renewal rate by 6% and also fetch 3M additional revenue
Drug Safety Analysis in RWE: Conducted a study in the US Claims Data in SAS and ML to prove the safety of a Phase-IV drug in terms of Adverse events as a part of the safety report for FDA by leveraging Regression techniques for the outcome
Application Analytics: Worked on defining user-related KPI's to enhance users' experience and determine features priority
This improved the average application usage time from 2.3 Minutes to 5.1 Minutes for following month
Education
Bachelor of Technology - Computer Science & Engineering
KIIT University
08.2013 - 07.2017
Skills
SQL
BigQuery
SparkSQL
Python
Excel
Predictive Analytics
Data Analytics
Clustering
Business Intelligence
Customer Analytics
Banking Analytics
Customer Segmentation
Software
Tableau
QuickSight
GCP
Athena
SAS Studio
AWS(EC2, DynamoDB,Redshift,Lambda)
MS Office
Interests
Stakeholder Interaction
Story Boarding
Team Management
Problem-solving
Timeline
Business Intelligence Engineer II
Amazon
01.2024 - Current
Senior Data Science Consultant
Ernst & Young
05.2021 - 01.2024
Senior Business Analyst
Dell Technologies
01.2020 - 05.2021
Decision Scientist
Mu Sigma
10.2017 - 01.2020
Bachelor of Technology - Computer Science & Engineering