Apr 2022 – Nov 2023 · 1 yr 7 mos · Texas, United States

Oct 2021 – Apr 2022 · 6 mos · Bengaluru, Karnataka, India

Jul 2019 – Oct 2021 · 2 yrs 3 mos

• Ingested Claim data into Hive tables using partitioned tables. Denormalized Diagnosis tables using the complex Array and Map Datatypes.
• Cleaned and loaded data in append mode using spark data frames
• Developed spark streaming pipelines for CMS response file processing like 999, HRR, MAOs etc.

Aug 2014 – Jul 2019 · 4 yrs 11 mos

• Designed data Pipelines to load EDI files into Datawarehouse using informatica and B2B Data Transformations. ETL pipelines to re-generate claim EDI file for CMS submission without losing the hierarchy of a claim. Developed crucial response workflows for CMS response file processing (277, 999, HRR, MAOs).
• Unix shell scripting and stored procedures to build ETL framework, and runtime parameter file generation for concurrent. Developed generic Auditing process to track the Job and Batch status along with the appropriate logging process.
• Sourced variety of source systems like XML, CCF, Tables, CSV and other regular file formats.
• Developed Metadata-driven framework for best performance in processing the claim life cycle.
• Added a great level of restart ability to achieve ease of maintenance. The Majority of Failure handling scenarios are controlled and automated.
• Designed a controlled way of job looping technique in job scheduling.
• Co-ordinate with offshore teams to get the quality deliverables.

Jul 2013 – Aug 2014 · 1 yr 1 mo

• Worked with business analysts to gather requirements and Prepared development design.
• Involved in project activities from analysis, build, unit testing and deploying the components.
• Developed ETL mappings to read Cobol file as source to provide the output for each mail transaction with complete details.
• Wrote PL/SQL packages for reconciliation and count auditing process.
• Coded UNIX shell scripts for handling the file validation, movement and logging all activities.

Nov 2012 – Jun 2013 · 7 mos

• Supporting the DW and Datamart by working on small modules, which provides the Addon features to code like Root cause fix for repeated prod failures, better functionalities, preventative fix for possible issues and ensuring Batch wellness and performance.
• Have developed ETL Workflows to populate data metrics from Third-party Member prior insurance details. This helped business in deciding the accurate insurance price for its members.
• Implemented complex ETL pipelines for Slowly Changing dimensions, Dataflows which can evaluate MSR performance metrics for all LOBs, and Reconciliation process.
• Writing SQL for unit testing of the developed mappings and ETL code. Perform peer review.

May 2010 – Oct 2012 · 2 yrs 5 mos

• Senior Software engineer at TCS

Feb 2007 – May 2010 · 3 yrs 3 mos · Chennai / Pune

• Develop and Unit testing of ETL pipelines using Informatica tool. Developing and unit testing of data mappings, workflows(pipelines) and sessions in Informatica
• Provide technical support to troubleshoot production issues in DataStage pipelines.
• Prepare job metrics and failure metrics for weekly analysis and status reports.