• Architecture/design and successful implementation of electronic medication prescription data transformation from text data with 70 % Data accuracy. • Architecture and implementation of workflow for data exploration, adhoc querying using Glue data crawlers and AWS Athena.• End to end implementation of ETL workflows and Datawarehouse implementations to transform electronic health records data using Scriptella as ETL tool, powershell, Apach PIG on EMR, AWS Lambda with python boto 3.• Development and implementation of description analytics scripts using PL/SQL, Apache PIG.• Worked on enhancing performance of SQL analytics scripts to reduce run times and better resource utilization using SQL execution plan, Extended events and resource monitor. Analytics run time was improved by 80% by this exercise.• Created scripts to evaluate data quality and sanity. • Work closely with Chief medical officer to understand and translate medical terms to actionable data insights• Proven mentor for Junior Associates and Freshers• Handled recruitment for data Engineering team

• Architecture design and implementation of SQL Access path comparison tool using IBM path checker, REXX and JCL. Widely used in application release testing to proactively identify database performance issues.• SQL workload Performance Tuning and optimization. Working with developers and application teams to gain knowledge of DB2 activity from applications and participate in SQL code reviews and assist in coding optimized SQLs calls• SQL performance tuning to improve performance of batch and online applications connecting to Z/OS DB2• Churning, summarizing and aggregating DB2 accounting, auditing and statistics trace data collected in DB2 Performance management warehouse tables and derive significant insights to improve MIPS and overall CPU usage on Z/OS• Infrastructure automation using DB2, SQL, REXX and mainframe scripting language JCL

DB2 Administration , Workflow Automations on Mainframe.

PL/SQL Development, Solutions Desing and implementation, Database administration and Design and deployment of high availability solutions on mainframe.

DB2 DBA on mainframe