Managing a team to deliver advanced analytics solutions to leading telecom clientsProduct Recommendation Engine: Developed a hybrid framework built around association rule mining, cosine similarities & business rules to recommend hyper-personalized prepaid bundles to 8 million telecom subscribers across AfricaTelecom Churn Prediction: Proactive identification of churn behavior among 6.6 million active subscribers based on their MoM usage activities, demographics, device &… Show more Managing a team to deliver advanced analytics solutions to leading telecom clientsProduct Recommendation Engine: Developed a hybrid framework built around association rule mining, cosine similarities & business rules to recommend hyper-personalized prepaid bundles to 8 million telecom subscribers across AfricaTelecom Churn Prediction: Proactive identification of churn behavior among 6.6 million active subscribers based on their MoM usage activities, demographics, device & e-Wallet attributes using Random Forest classificationCustomer Market Share Maximization: Prediction of required net customer additions for sales agents to increase market share quarterly by 0.5% through various factors such as churn, customer acquisitions, re-connections in both operator's as well as competitors' networksCluster-based Customer Acquisition: Identified the ideal customers to be targeted for various Value-added service campaigns through K-Means clustering on usage KPIs & customer persona Show less

Individual Contribution to advanced analytics projects & ad-hoc descriptive/inquisitive analytics supportPrice Sensitive Modelling: Developed a log-log regression based framework to simulate impact on revenue & usage KPIs from various price-points, macro-economical factors and customer movementAnomaly detection: Automated detection of anomalies in usage, revenue & active subscriber KPIs across each cell site based on Facebook Prophet ForecastsCab Ride Cancellation… Show more Individual Contribution to advanced analytics projects & ad-hoc descriptive/inquisitive analytics supportPrice Sensitive Modelling: Developed a log-log regression based framework to simulate impact on revenue & usage KPIs from various price-points, macro-economical factors and customer movementAnomaly detection: Automated detection of anomalies in usage, revenue & active subscriber KPIs across each cell site based on Facebook Prophet ForecastsCab Ride Cancellation Analytics: Identification of root cause factors leading to ride cancellations and corresponding corrective measures to minimize cancellationsMobile-Wallet User Churn Prediction: Predict probability of churn for 2 million mobile wallet users based on their activities across P2P, Bill Payments, Merchant Payments, Bank transfers using Random Forest classification Show less

Competitor threat analysis:Enabled a leading US home improvements retailer to build assortment and pricing strategies for countering an emerging competitor and effectively re-capture 4% of the market share in 3/5 product categories through automated tableau dashboards connected to competitor intelligence data captured through in-house web scraping frameworks.The dashboard encompassed information ranging from the top selling competitor SKUs, brands and prices to geospatial… Show more Competitor threat analysis:Enabled a leading US home improvements retailer to build assortment and pricing strategies for countering an emerging competitor and effectively re-capture 4% of the market share in 3/5 product categories through automated tableau dashboards connected to competitor intelligence data captured through in-house web scraping frameworks.The dashboard encompassed information ranging from the top selling competitor SKUs, brands and prices to geospatial strongholds. Show less

Data Engineering & Reporting:Led a team of 4 to deliver clean, structured & analysis ready real-world evidence data on a centralized Teradata platform along with various utilities for data profiling, quality & utilization assessment built using SAS, SQL & Spotfire. Price Simulation:Developed an Excel VBA - R tool that enabled end users to design pricing strategies for various products & channels & simulate their impact on sales using multiplicative price elasticity based… Show more Data Engineering & Reporting:Led a team of 4 to deliver clean, structured & analysis ready real-world evidence data on a centralized Teradata platform along with various utilities for data profiling, quality & utilization assessment built using SAS, SQL & Spotfire. Price Simulation:Developed an Excel VBA - R tool that enabled end users to design pricing strategies for various products & channels & simulate their impact on sales using multiplicative price elasticity based models and Monte Carlo simulationTrade Promotion Optimization:Led a team of 6 to develop 3 tier architecture web based tool using ReactJS, Django, PostgreSQL to generate optimal promotion calendars based on end user constraints. Weather Triggered Advertising:Created an anomaly detection tool to identify anomalies in customer movement patterns across various segments for an advertising framework built using Spark, Python & R, Excel VBA Show less

Customer Segmentation & Impact Analysis:Performed impact assessment of a newly launched online grocery channel for a leading US retailer on sales, customer segments & other channels. Leveraged technologies such as SAS, Hive (SQL) & Hadoop to create periodic reports on sales, churn, campaign effectiveness, lift & cannibalization