• Developed ETL processes for generating extracts to be used for marketing mix analysis by a major pharmaceutical company• Developed ETL processes for supporting marketing dashboards used by HQ users, field users at a major pharmaceutical company

• Led a cross-functional team of 6 associates throughout the operations of an industry leading data product (AccessMonitor US) – analysing the behavioural changes in healthcare providers towards personal promotional channel based on data from ~35 pharmaceutical companies across ~30 specialties for ~250 brands• Designed timelines and successfully executed a largescale process transformation for AccessMonitor US involving - Standardization of ETL processes and execution strategies, Migration of processing from SAS environment to AWS based big data platform (Hadoop), Design of archival strategy of historical data on AWS S3, Migration of historical data from SAS environment to AWS S3, Automation of processing using shell scripting which resulted in cutting down the delivery time by 40%• Played a major role during the design phase, testing phase of RPA implementation in AccessMonitor US• Developed the report generation process for AccessMonitor Canada• Led the data processing using Spark, R for email content sequence optimization project undertaken for a major player in US hospitality market