PRASHANTH NAGATHOTA

• Led quality assurance activities application focused on providing solutions, process improvements, and supporting multiple applications
• Understanding business requirements and analyzing functionality to define test scenarios
• Tested data validation scenarios and Data ingestion, pipelines, and transformation processes for ETL.
• Prepared and ran SQL queries to verify Dimensional and Fact table’s data in target database after ETL process
• Review & validate data from On-Premise to ODS. Validate data across different layers with diff check points using hive tables.
• API testing for DCS portal with Azure Devops for Test Management activity defect tracking tool
• Created Test Plans, Test summary and defect summary reports.
• Assisted in hiring process by interviewing potential QA analysts and providing feedback to Director of QA

Projects:

#1. Teletrack – Client : Equifax

ETL Testing - Insurance Domain (Data Migration)

#2. Digital Customer Strategy(DCS) – Client: NFUM

API testing using SOAP UI - Insurance Domain

#3. Annuities, Data & Reporting - Client: LFG

ETL Testing - Insurance Domain

• Involved in ETL and Web -API testing
• Been part of Back Office Data Warehouse QA Team
• Analyzing and understanding of business requirements and system functionality.
• Backend testing for front end of application using SQL queries.
• Coordinating and communicating with Onshore/offshore teams for daily and weekly status reports.
• Identified Test Scripts for Regression testing.
• Defect Analyzing, reporting in Jira and prepare status reports.

Projects:

#1. AIS DW (Alternate Investments Solutions Data Warehouse)- Client:

State Street

ETL Testing- Investment Banking

#2. Koch, Neff & Volckmar GmbH - Client : KNV

API Testing E-Commerce

• Derive Quality test Cases as per Functionality Specification
• Review test case and execute test case
• Involved in Functional and Regression testing and System Integration testing of application
• Defect Analyzing, reporting in Jira and prepare status reports.

Project

#1. AllScripts Emergency Department- Client: HealthAssist for AllScripts

Manual Testing- Healthcare Domain

• Worked on Manual testing for Banking applications
• Worked on Back-office securities settlement system and Trade & Settlement processing system.
• Testing interfaces like db CRIS, Message broker, dbOne, CIRM and eSpear using message types like SWIFT and XML messages.
• Created and involved in writing Functionality specification Test cases, positive and negative scenario test cases
• Peer to Peer test case reviews based on User stories, FRD and BRD specifications.
• Involved extensively in executing Build Validation, Functional testing, Ad-hoc testing, System Integration Testing(SIT), Regression testing, UI testing and E2E (end to end) application testing. ·
• Defect logging and Defect Tracking using Quality Center/HP ALM

Projects:

#1. MyWealth – Client: CBA( Commonwealth Bank, Australia)

Web Application Testing - Investment Banking

#2. NexClear DB Trader – Client: Deutsch Bank

Manual Testing- Investment Banking

#3. Boris DB Trader - Client: Deutsch Bank

Manual Testing - Investment Banking