Soumya Sri Tangellapally

Project Title : EDWARD - RVNU - WGS BALANCING Enhancement in Daily Load Program to Correct Product Chart Field Assignment

Corrected product chart field code affecting approximately 11K records. Implemented updates with filter conditions to ensure accuracy

Project Title : EDW - CLM - WGS: WGS Claims: FFS Amount in EDWARD CLM_LINE

Corrected FFS amounts for 6K records.Identified and fixed incorrect records through detailed analysis and precise script changes.

Project Title : EDW-CLM-EDW_ALLPHI View Contains External Data

Introduced a new column and excluded external data Impacting 7 billion records, Adapted to changing requirements and ensured data accuracy.

Supported my team mate to tackle challenges by creating new tables and helped in migrating the scripts& tables in below project.

Project Title : EDW-CLM-WGS: EOB Duplicates

Current Project Title : EDWARD - CLM - WGS: Summary Claims EOB

• Impact: Correcting amounts impacting approximately $600M. Implementing incremental and history updates to ensure proper record accuracy.
• Challenges: Overstating (duplication) of records due to various changes made to the script.
• How I Tackled Them: Introducing new tables and columns, and added various SQL functions to resolve the duplication issue. Conducted thorough testing to ensure data integrity.