Soni Priya Relangi

About Soni Priya Relangi

Experienced in the field of Data Integration, I’ve worked with a different set of tools with primary focus on Informatica PowerCenter. Have good knowledge in development, unit testing, standard development life cycle process.Possess excellent technical skills in implementing ETL Informatica designs/Mappings using all the Informatica client components such as Designer, workflow Manager, Workflow Monitor. Always assured that my code is up to standards and perform diligent unit testing to maintain the quality of the code. I strongly believe efficient understanding and perfect implementation of requirements is the key to be a great developer.Apart from being a highly technical and methodical individual, I have been recognized numerous times as a valuable team player who has an ability to effectively contribute as part of team in various challenging situations to provide deliverables of high standards on time.Key SkillsInformatica PowerCenter 8x / 9x, SQL Queries, SQL Server, Sybase, DB2, Cybermation, XML, Perl, Unix Shell Scripting, Healthcare, Facets, SVN, Data Warehousing, Data Migration, ETL Design and Development, Object Oriented Programming, Agile and Waterfall methodology, Performance Tuning, Deployment Management and Planning, Innovator, Team Player, Effective Communication Skills, Customer Facing and Requirements Gathering. Goals:Expertise in Data Warehousing, ETL architecture, Business Intelligence and Data Quality through innovative solutions.

Experience

1. Data Engineer -sr Cons Ii

   National General

   Aug 2022 — Present

   Part of Claims Data Warehouse Team which deals the daily batch and maintains the EPIC(source of auto/property claims) data in the Warehouse. Played key role in monitoring and minting the Claims Datawarehouse batch jobs on dailybasis. Developed new programs to report the auto claims feeds for different policy systems tomultiple vendors. Re-platformed multiple programs from informatica to YellowBrick cloud SQL platformusing the DBeaver application. Extensively used informatica 10.5 for new development and updating existing programsas per the new requirements. Was part of weekly on call rotation to resolve the production abends during the nightlybatch and day jobs. Worked with peers and database admins to avoid any bottle necks that occurs duringthe CDW batch jobs processing. Worked with database admins to improve the performance of the long running jobs. Built SQL queries to do the balancing between EPIC and Claims Data Warehouse. Used Oracle SQL Developer and Microsoft SQL Server to analyze the data in CDWdatabase and EPIC database to help understand the requirements from Analytics Team. Did enhancements to the CMS Query process which sends Medicare eligible claims toCMS and documents to process flow and mapping details for all the fields for betterguidance and find the opportunities to improve the process. Did bunch of enhancements to existing processes for the new requirements. Was part of code review team to review the code from peers and deployed the changesto production. Created process documents for several CDW core batch jobs and other jobs that outteam maintains.