Consulting for Novartis Pharmaceutical as a data engineer, offering project-based solutions to improve their data architecture and analytics capabilitiesDeveloped and executed comprehensive HCP patient referral networks for over 10+ brands,leveraging insights from IQVIA, Veeva, and Komodo.Developed and refined KOL strategies for over 7+ brands using cutting-edge graphalgorithms, significantly enhancing the impact and precision of HCP marketing campaigns.Architected PySpark pipelines to manage extensive datasets, crafting optimized code toenhance data processing efficiency and performance.Designed and implemented robust data models to streamline data integration and enhanceanalytical capabilities, optimizing overall performance and accuracy.Developed and implemented advanced data quality frameworks, ensuring accuracy,consistency, and reliability across large-scale datasets, enhancing overall analytical integrity.

Set up an AWS environment to build a scalable data pipeline with Python and PySpark,integrating marketing data from Google Analytics, Facebook Ads, and sales data from CRMinto Redshift.Developed data mappings and transformations using pySpark and other data integrationtools to extract, transform, and load data from various sources into the data warehouse.Automated real-time reporting using Python and Tableau, improving performance trackingand decision-making.