Dilip Suwal Email & Phone Number

Utah, United States

Utah, United States

• Worked with Business Analyst and Business Users to understand the business requirements.• Prepared SQL scripts based on the business requirements to update medical records retrieval application databases in both UAT and production environments.• Configured Medical Image Processing Systems to generate medical records in PDF format with extracts.• Worked with data operation team in Commercial and Medicare risk adjustment domain to troubleshoot issues encountered during ETL processes.• Prepared SQL scripts to perform backfill operation in production databases after ETL is performed.• Provided operation and production support by handling tasks assigned through Microsoft Team Foundation Server (TFS) tool.• Documented standard operating procedure (SOP) of reoccurring tasks.

Kathmandu, Nepal

• Supervised a team of around 15 database engineers and data QC engineers who are responsible for developing and modifying SQL based ETL scripts as well as performing data QC once data is loaded into common data model.• Involved in recruitment process to hire database engineers, conducted training programs to provide training to new hires, and involved in performance review.• Conducted daily scrum stand-up meeting to review ongoing development and data QC activities.• Implemented JIRA Software in Data Operation department to track and manage daily tasks.• Optimized Data QC SQL script to reduce the execution time by 30%.• Performed frequent communications with directors, engineering managers, project managers, and other stakeholders regarding resources, project plan, and risks mitigation. • Documented standard operating procedure (SOP) of data operation tasks in confluence pages.

Kathmandu

• Built data QC team of around 15 data QC engineers from scratch to perform data QC for more than 80 healthcare clients.• Prepared test plan, test cases, and test SQL scripts in order to perform data QC on common data model after ETL is executed.• Worked with data QC team to develop internal data QC reporting tools to generate data QC reports.• Prepared reconciliation data QC report covering extraction layer, multi-dimensional MSSQL relational database layer, and SSAS based OALP Cube.• Prepared and analyzed quality metrics report.• Documented standard operating procedure (SOP) of data QC processes in confluence pages.

Kathmandu

• Supervised a team of around 10 database engineers who are responsible for developing, modifying and execution of SQL based ETL scripts.• Involved in hiring and performance review processes.• Developed SQL based ETL scripts to load healthcare data into common data model for 3 clients.• Migrated MSSQL based ETL scripts to Oracle PL/SQL scripts for around 15 clients.

Kathmandu

• Developed SQL import scripts to load healthcare raw data files received in various formats such as Text, CSV, XLS, and MS-Access into client specific MSSQL and Oracle databases.• Performed data profiling analysis on loaded data to define mapping and business logic between client specific data elements and target common data model and documented them in WebDTS (Data Translation Sheet), an internal tool developed by Cotiviti.• Developed transformation SQL scripts based on data mapping and business logic in order to load into common data model.• Modified SQL based ETL scripts as per change requests received from clients.