Assortment Planning & Solution for a Fortune 1 Retailer- Setup an automatic assortment generation process for 250+ stores, for an O2O unit, in about 30 cities leading to a saving of 1320 Man Hours per month- Measured the performance of the rolled out assortment using Test & Control, Pre-Post Analysis in a Lift ReportDigital Marketing Analytics for the largest insurance provider in the United States- Created a linked database of disparate data sources of ad impressions and other metrics in order to facilitate and enable reporting of campaigns- Helping stakeholders track the performance of their digital marketing efforts by identifying appropriate metrics and measuring them through Impression reports and Lift reports- Technologies used : Hive SQL, Impala, Oracle, Microsoft ExcelMarketing Analytics and Business Insights for a Fortune 500 US based Pharmaceutical Firm- Enabled easy monitoring of the adoption of a newly launched cancer drug at various geographical levels through the development of a Key Performance Indicators module- Customer Targeting and Segmentation to enable efficient targeting and an increase in the promotional penetration of drug in the marketProstate Cancer Survival Prediction for US based Medical Devices and Pharmaceutical Firm- Predicted if a cancer patient will survive within 7 years based on various medical metrics like stage of cancer, race, symptoms etc.- Applied Statistical model to classify & identify features that were more significant in increasing the odds of survival for a Prostate Cancer patient