Naga Muktavali Rupanagudi

E-mail : ad22jh@r.postjobfree.com

Mobile No. : +1-470-***-****, +91-887*******(WhatsApp) Work Authorization : L2 (No sponsorship required), Available immediately. Location Preference : New York, New Jersey (WFO), Hybrid or Remote Detail-Oriented Problem Solver and Robust System Builder with a Passion for Critical Thinking and Continuous Learning

Experience Summary

Highly professional and skilled ETL Engineer with over 12 years of experience in large scale data and systems within the financial services industry, specializing in data warehousing, ETL, and analytics development and testing. Have a proven track record of early identification of defects and detailed documentation that helped in reducing testing time and costs; further ensuring compliance with regulatory requirements of those critical projects. Experienced in leading team of testers and collaborating with cross-functional teams. Consistently achieved high customer satisfaction ratings by delivering quality products and timely support. My adaptability, self-motivation, and commitment to excellence have allowed me to consistently deliver exceeding-expectation results. Qualifications & Certifications

• AWS Certified Cloud Practitioner - CLF-C01

• Snowflake SnowPro Core Certification

• Data Science and Machine Learning Course with Scaler Academy (Currently pursuing)

• Post graduate Diploma in System Software Development

• Bachelor’s Degree in Electronics & Communication Engineering Technical Skills

• Programming Languages: SQL, Python, C++, VBA (Macros), Shell for UNIX \ LINUX

• Cloud: AWS

• Databases: Snowflake, Oracle, SQL Server, Teradata 13.0, Netezza 7.2 and SAP Hana, DB2 11.0

• Test Management Tools: Micro focus Quality Center / ALM

• ETL Tools & Applications: Informatica Power Center 9.6, Informatica DVO, AB-initio, SSIS, OFSAA - Oracle Financial Services Analytical Applications

• Reporting/Automation Tool: Cognos, SSRS, Platinum Work Experience:

Cognizant Technology Solutions

Roles Played Senior QA Analyst

Duration June 2014 – August 2023

Highlights ● Assumed the role of technical lead and was also the Subject matter expert on SQL and Reverse engineering on intricate, multi-level systems developed over an extended period using Informatica mappings.

● Always among the top 1% performers in the projects. Customers consistently expressed their satisfaction with my work and interactions and often specifically request my presence for complex projects and singular research.

● Designed and reviewed test scenarios and test cases, and test plans for SIT, UAT, and regression testing, ensuring data integrity, accuracy, and completeness.

● Verified data movements and ETL mappings using complex SQL queries, ensuring compliance with regulatory requirements.

● Established governance of agile testing and development process along with stake holder reporting

● Was considered the knowledge champion and team player. Groomed and trained 30+ juniors. Projects Santander Holdings bank:

• Managed Quality of a reporting hub for monitoring client performance and profitability at a detailed product level in the Corporate and Investment Banking sector.

• Verified the Consistency of data marts for liquidity management, general ledger storage, average balance calculations, solvency consolidation, and loan financial reporting.

• Involved in the modernization and replacement of the outdated payment transaction storage and archival system.

• Validated an application for personalized financial insights and guidance to customers based on their unique financial circumstances, empowering them to make informed decisions.

• Supported Data systems setup for Digital transformation of commercial lending with AFS Vision Voya Financial (Insurance):

• Automated the generation of annuity experience studies by extracting data from the source system and exporting calculated results for different annuity types, such as Lapse and Mortality using OFSAA.

• Updated Risk Management applications, including financial management database, annuity hedging, analytics applications, and centralized warehouse, to adapt to evolving business requirements and technological advancements.

• Separated data between two companies within the investment risk management application's centralized warehouse as part of a data separation program, ensuring data sourcing, cleansing, and analysis for various annuity products at both seriatim and compressed levels. BB&T Bank:

• Implemented an all-in-one solution for loan origination, servicing, and reporting with custom data extraction and standardization for downstream use. Managed the distribution of balance sheet, investment, insurance, bond, funding, liquidity, mortgage, derivatives, and hedging data to multiple teams, and utilized Informatica Power Exchange to read data from 120 source systems. Additionally, upgraded record-keeping systems for investment portfolio, corporate funding, money center, and Fed Funds products.

Barclays Bank

• Managed monthly demands and change requests for the Card portfolio system, focusing on improving and expanding its functionality.

• Developed a subscription framework to provide standardized data access from a single platform, enabling multiple applications and users to utilize the data efficiently.

• Enhanced the Credit Risk process in TRAID, resulting in a 50% increase in benefits and implemented Tableau dashboards for performance attribution and risk management.

• Streamlined the data validation process for the VPG Automation project, reducing manual effort for testers when validating data loaded into the Teradata table. Tech Mahindra

Role QA Analyst, ETL Developer

Duration April 2011 – April 2014

Highlights ● On Client request, I have moved to Cognizant for the same project.

● Deeply involved with Development and testing automation using informatica

● Received multiple customer recognition and awards for development and testing. Projects Barclays Bank

• Same as mentioned in Cognizant.

Contact this candidate