Aman Arora Email and Phone Number

As part of the Real World Data and Insights team, helped some of the largest pharmaceutical companies gain insights into patient and physician behaviors and decision drivers from granular patient-level dataProvide insights into the trends based on patient journeys and patient needs in a cancer market• Carried out an advanced analytics project to help a pharma giant scope opportunity areas in a cancer market using the last 5 years of payer claims data throughout a patient's journey. Provided insights into the market segmentation, competitor analysis, source of business, drug adherence and compliance, comorbidities, line of therapy, as well as physician deciling for the existing market.Devised quality check processes for a KOL mapping tool utilizing data from multiple sources• Created processes and robust mechanisms for deduplication and quality checking of names and affiliations data of key opinion leaders (KOLs), flowing into an R Shiny based KOL mapping tool from multiple data sources using techniques like fuzzy matching, topic modelling, and rule-based entity resolution. Scaled up the solution to check for 3M+ KOLs across 92 disease indications and 239 countries.

Moved multiple projects into production from various platforms on Microsoft Azure• Led a team of 7 members to carry out the migration of big data from Microsoft SQL database to Azure Data Lake, data wrangling and manipulation codes from SQL workbench, project codebases in R language to Azure ML workbench. Created requisite pipelines to set data connections to model codes and model outputs to front-end Power BI dashboards, for a major Technology giant.

Classification model to target potential customers for a support service offering • Led a two-member team to build a propensity model for the sales team of a Fortune 10 technology client to predict the likelihood of a customer to purchase an advanced support service. • A hypothesis-driven approach was leveraged to identify the features affecting an advanced support contract to be purchased, with the model attaining accuracy of 74%, helping Sellers target 45pp more potential customers with the same effort compared to random targettingCustomer acquisition propensity tool• Developed a customer acquisition propensity model to help sellers identify customers from the products side of business most likely to adopt a newly introduced product support services model, based on their historical behavior across multiple fronts like consumption, purchases, interactions, etc.Evaluated the impact of discount coupon codes on incremental sales• For an Electronics Retailer in the UK, optimized the discounts provided by the top-performing coupon codes and recommended the removal of ineffective coupon codes for some specific product groups through trials/experiments• Helped the business improve their voucher profitability by 1.2x with negligible impact on the £ and unit salesMix Calculator for attribution of sales dispersion• For the largest US-based alcoholic beverages company, created a Python-based margins loss attribution calculator to help the Revenue Management team evaluate the difference of actual sales from the budget, helping the team cut losses through improved subsequent budget allocations

Led the ENACTUS Panjab University team, where we tried to identify potential solutions to complex issues in our communities and implement impact projects with entrepreneurial action, to create a better, more sustainable world

I completed my summer training at Bharat Petroleum Corporation Ltd., Mumbai Refinery, Mumbai. Along with the overview of the whole refinery, the unit of my focus was the Hydrocracker Unit.