➢ Migration from Legacy System to Big Data Environment(ADA - DBS Bank)-> Tech Stack – CDSW, Pyspark, Python, SQL(MySQL), Superset, SAS, Presto, Jenkins, Airflow, Hive, Grafana etc.,- Migrated legacy System to the ADA environment using a Spark (PySpark) framework, enhancing data processing efficiency and handling huge volumes of data for real-time and batch operations.- Created a custom PySpark solution to replace Proc Export, saving SGD 50K annually on licensing costs.- Leveraged Spark, Spark SQL, and Presto to transform raw data from Data Lake to Data Mart and Data Warehouse for efficient storage and analytics support.- Developed a Python script to extract SAS dataset metadata, which reduced manual effort by 90%.➢ Rewiring from BIP Teradata to ADA (Big Data) Environment(DBS Bank)-> Tech Stack – Sparkola, SQL(MySQL), SAS, Presto, Collibra- Facilitated the transition from BIP Teradata to the ADA environment by adapting SAS scripts for Hive compatibility and optimizing queries with Presto.- Fixed a long-standing issue with an automated macro that generated incorrect SQL queries, improving accuracy and reducing errors by 100%.- Verified rewired code by reconciling records between BIP and ADA tables to ensure data quality and accuracy in the ADA Environment.

➢ Reporting and Compliance Solutions (IQVIA)-> Tech Stack – SAS (SAS EG and SAS Studio), Python, Bitbucket- Partnered with various teams to develop customized reporting frameworks that met unique client requirements and improved data accessibility.- Worked with SAS edit checks, including global, therapeutic area, study-specific, and third-party vendor checks, ensuring data integrity and compliance throughout the trial process.- Managed the integration and analysis of diverse datasets, optimizing processes for data extraction and reporting, which improved overall operational efficiency.

➢ Reporting Solutions and Data Management (Sanofi Aventis)->Tech Stack – SAS (SAS EG and SAS Studio), SQL, Python, R (RStudio)- Collaborated with Data Managers to understand reporting needs and delivered tailored solutions that enhance data management and visualization.- Utilized standard SAS programs to develop Patient Profile Reports, improving data visibility and supporting clinical decision-making.- Developed a SAS program to review other SAS programs, identifying potential impacts from amendments, resulting in a 100% reduction in manual effort.➢ Data Management Enhancements (Bellerophon)-> Tech Stack – SAS (SAS EG, SAS Studio and SAS Display Manager), SQL- Developed and maintained standard SAS programs to generate insightful reports for clinical trial data, aiding data-driven decision-making.- Generated highly customized reports in the form of listing, HTML, RTF, and PDF using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL.- Created a Python script to identify reusable components from client requirements, achieving 60% reusability metrics and established a standard library.