Led multiple projects through all stages of project life cycle. Created documents for Effort estimation, Work Orders/Contracts (SOW), Business Requirements, Design documents, code deployment packages (IQs), test scripts(OQs), user guides and Architecture diagrams for data migration, automation, application upgrades and AWS infrastructure.Led end to end implementation of multiple successful data migration projects to migrate Argus data from Oracle database to AWS S3 bucket of clients using PL-SQL framework.Led L3/L4 production support of Deloitte's Data warehouse Analytics and BI Reporting Product, including maintenance of BI reports, ETL monitoring, data analysis, code changes (CRs), incident resolution within SLA, server restarts, root cause analysis (RCA), weekly and monthly status reporting, supporting BI product upgrades, MedDRA upgrades, Duo Security Migration and client dealing for APAC, US and EMEA regions.Created Oracle Argus Safety Auto-narrative templates for Japanese and European clients.Created BI reports on SAP Crystal Reports for Periodic/Aggregate and compliance PV reporting.Facilitated communication between multiple teams and stakeholders including Product development team, Infrastructure team, Cloud Management team and clients. Mentored junior team members.

Led multiple projects through all stages of project life cycle and created documents for Effort estimation, Work Orders/Contracts (SOW), Business Requirements, Design documents, code deployment packages (IQs), test scripts(OQs) and user guides.Led end to end implementation of mutiple successful data migration projects to migrate Argus data from Oracle database to AWS S3 bucket of clients using PL-SQL framework.Led L3/L4 production support of Deloitte's Data warehouse Analytics and BI Reporting Product, including maintenance of BI reports, ETL monitoring, data analysis, code changes (CRs), incident resolution within SLA, server restarts, root cause analysis (RCA), weekly and monthly status reporting, supporting BI product upgrades, MedDRA upgrades, Duo Security Migration and client dealing for APAC, US and EMEA regions.Led end to end implementation of Oracle database solution to capture history of all transactions done on Oracle Argus Safety front-end in a new database table using database triggers and display in newly developed Auto-narrative templates using SQL.Created BI reports on SAP Crystal Reports for Periodic/Aggregate and compliance PV reporting. Improved SQL report performance for BI reports.Customized report logic for all BI reports in the system to enable new features as per latest version of in house BI product (ConvergeHealth Safety). Enhanced data pipelines using Informatica ETL and SQL, between Oracle Argus Safety database, Microsoft SQL Server and SAP HANA DB to improve data quality and fix issues.Facilitated communication between multiple teams and stakeholders including Product development team, Infrastructure team, Cloud Management team and clients. Mentored junior team members. Trained B-school hires on BI and PV reporting during bootcamp.

Worked on L3/L4 production support of Deloitte's Data warehouse Analytics and BI Reporting Product, including maintenance of BI reports, ETL monitoring, data analysis, code changes (CRs), incident resolution within SLA, server restarts, root cause analysis (RCA), supporting BI product upgrades, MedDRA upgrades and client dealing for APAC, US and EMEA regions.Created BI reports on SAP Crystal Reports for Periodic/Aggregate and compliance PV reporting.Customized report logic for all BI reports in the system to enable new features as per latest version of in house BI product (ConvergeHealth Safety). Enhanced data pipelines using Informatica ETL and SQL, between Oracle Argus Safety database, Microsoft SQL Server and SAP HANA DB to improve data quality and fix issues.Authored OQ scripts and provided SME support for Argus Japan module and combo products testing and UAT during Argus Safety upgrade validation project.

Developed and published Tableau dashboards using Oracle Argus Safety database as source and created interactive visualizations using Bar graphs, Pie charts, Line charts, Tooltips, Dashboard actions and Dashboard filters. Enhanced Windows PowerShell script to load data into Argus database from external XML files.

Created various database objects including PL-SQL procedures, materialized views, database links and scheduler jobs as per new requirements and to fix data logic issues.Created Linux shell scripts used for executing Oracle Database procedures.Performed Informatica ETL mappings changes and workflow deployment.

Performed Informatica ETL mappings changes and workflow deployment.Executed OQ test scripts for Oracle Argus Safety upgrade validation project for Case Processing, E2B import and E2B transmission pilot testing with partner agency.