Prakash Gadhamsetty

Desire to attain a position where I can render my services for the growth of the company and thereby pave a good career path so as to gain professional dignity.

Professional consultant with strong analytical and problem-solving skills tailored for delivering impactful solutions. Demonstrates focus on team collaboration and adaptability to changing needs, ensuring reliable results. Expertise in project management, client communication, and strategic planning enhances overall team effectiveness and success.

• Rich Experience in the Banking And Financial , Insurance and Airline domain
• Skilled QA in various databases, Data warehousing technologies like Oracle,SQL.
• Experience in testing the DB & DW applications in order to view successful transactions of data and for validating data.
• Experience in Preparation of Test cases, Test Scenarios and Test Data.
• Worked on Validation of various mapping & workflows in Informatica 9.0 .

Company Name:  TCS

Key Projects

Project# 1           :  CHUBB Insurance (COG CBD)

Client Name        : CHUBB Insurance Limited

Domain                : Insurance

Role                     : Assistant Consultant for QA and data analyst

Technologies       : UNIX Operating System, SOAP UI, XSLT, XML, XSL

Backend Database: Microsoft SQL server

Version controller : GIT Repository

Test Management Tool: JIRA

Responsibilities

• Analysing the Epics, stories i.e., gap and no gap analysis, and communicating with the PO/EO for better understanding of the feature.
• Setting up Kick off meeting involving all the business stake holders to freeze the requirements
• Identified End to End test scenarios ,Test cases,and testdata.
• Providing knowledge sharing sessions to the other Scrum teams.
• Azure data Bricks as cloud services and creating clusters ,tables and workspaces
• Bigdata Solution along with Hadoop ecosystem using spark and SCALA language
• Verifying events generated for changes consumed by MDM through event manager application.
• Creation of effort estimation and team sizing plan, Testplan during feature refinement meetings.
• Involved in QA activities i.e., sanity testing ,system testing ,exploratory testing and regression
• Creation of dashboard setup for regression run (by pull, push and commits requests in GIT repository)
• Involved in meetings with Product managers ,account level managers for activation and cutover plans in production (live) env.
• Apart from developing datastage jobs, working on certificate installations and configuring datastage project to work with latest technologies like Kafka CL, Avro files etc.

Project# 2   :  Customer and Counterparty Master (CCM)

Client Name        : Nordea Bank AB (

Domain                : Banking and Financial Institution

Role                     : Assistant Consultant for Release test train team

Technologies       : UNIX Operating System, SOAP UI, XSLT, XML, XSL

Backend Database: SQL Developer 4.2.1,

Version controller : GIT Repository

Test Management Tool: JIRA, Amadeus Terminal Emulator, Test tool server

Responsibilities

• Analysing the Epics, stories i.e., gap and no gap analysis, and communicating with the PO/EO for better understanding of the feature.
• Setting up Kick off meeting involving all the business stake holders to freeze the requirements
• Identified End to End test scenarios ,Test cases,and testdata.
• Providing knowledge sharing sessions to the other Scrum teams.
• Running health check ups to Make sure the environments are stable with no impediments for daily activities.
• Real time change data capture when source make any changes in legacy system using IBM Change data Capture(CDC).
• Ran datastage jobs which runs in infinite loops to capture delta changes.
• Generate XML files and loads into target database(DB2) to be consumed by MDM BPM.
• Read the acknowledgement Message Queues from the upstream system whether the generated files are valid(MQ – Success,Fail,Backout)
• Azure data Bricks as cloud services and creating clusters ,tables and workspaces
• Bigdata Solution along with Hadoop ecosystem using spark and SCALA language
• Verifying events generated for changes consumed by MDM through event manager application.
• Creation of effort estimation and team sizing plan, Testplan during feature refinement meetings.
• Involved in QA activities i.e., sanity testing ,system testing ,exploratory testing and regression
• Creation of dashboard setup for regression run (by pull, push and commits requests in GIT repository)
• Involved in meetings with Product managers ,account level managers for activation and cutover plans in production (live) env.
• Apart from developing datastage jobs, working on certificate installations and configuring datastage project to work with latest technologies like Kafka CL, Avro files etc.

Company Name:  Alten Calsoft labs

Key Projects

Project# 3   :  Light Ticketing Product

Client Name        : Amadeus India(May 2017 to present)

Domain                : Airline

Role                     : Implementation Engineer(BA+QA role)

Technologies       : UNIX Operating System, SOAP UI, XSLT, XML, XSL

Backend Database: SQL Developer 4.2.1, ABR

Version controller : GIT Repository

Test Management Tool: JIRA, Amadeus Terminal Emulator, Test tool server

Responsibilities

• Analysing the airline specific requirements i.e., gap and no gap analysis, services supported by airlines though SOAPUI.
• Setting up Kick off meeting involving all the business stake holders to freeze the requirements
• Raising Work orders(WO) and Task records(TR) for network link setup, system settings, ABR table updates ,test links
• Creation of XSLT for new and existing airlines(when airline migration from old architecture to new architecture )
• Creation of effort estimation and team sizing plan, Testplan, brush testacases , TTS scripts for regression testing
• Involved in QA activities i.e., sanity testing ,system testing ,exploratory testing and regression in different test environment by creating PNR using cryptic commands , raising PTR when deviation occurs between expected and actual outcome.
• Creation of dashboard setup for regression run of TTS scripts (by pull, push and commits requests in GIT repository)
• Worked with DEV team in resolving the PTR raised , Provide signoff for the QA activities
• Involved in meetings with Product managers ,account level managers for activation and cutover plans in production (live) env.

Company Name: Epsilon

Key Projects

Project# 4   :  CitiGR Thankyou Rewards Program

Client Name        :  CitiBank(01.09.2015 to 12.05.2017)

Domain                : Banking and Finance

Role                     : Quality Analyst

Technologies       : UNIX Operating System. SOAP UI

Backend Database: SQL Developer 4.2.1, Oracle, Cognos

Test Management Tool: TFS ,Testtrack

Responsibilities

• Drafting High Level Business Scenarios based on the requirements
• Preparation of Functional specific documents , Integrated control document .
• Being part of DWH testing team. Testing of Extract ,Transform and load is validated using Informatica.
• Roles and Responsibility involves Analyzing the requirement, understanding and Test case planning, Writing Test Cases, Execution of test case
• Involve in Test case Planning, Test Case creation, Test Execution and Defect Tracking
• Worked in ETL process for loading and processing data files from Source DB to Target DB using Informatica.
• Responsible for monitoring all the jobs that are running, scheduled, completed and failed. Debugged the log files of the failed job.
• Written test cases and SQL scripts/queries
• Responsible for creation testdata according to business requirement.
• Responsible to send the status report on daily basis, Attend Triage meeting with developer & B A from customer side.
• Test case design and end to end execution, raising defect, update the QC, prepare the TRD and maintain the traceability matrices.
• Execution of workflows based on sessions with various transformations loaded in the target DB as per the requirement.
• Executions of webservices API for memberprofile ,PlaceOrder, Modify order, Cancel Order etc for successful response.
• Report testing by generating reports from Cognos and comparing with the DB as per BR.

Company Name: Wipro Technologies

Project#5   : QATARAIR-OPS-AD-8103102

Client Name        :  Qatar Airways (18.06.2013 to 20.08.2015)

Domain                : RCTG

Role                     : TEST ENGINEER-L2

Technologies       : UNIX Operating System.

Backend Database: MS SQL 2008

Test Management Tool: RQM

Responsibilities

• Drafting High Level Business Scenarios based on the requirements
• Preparation of Functional specific documents , Integrated control document .
• Test case design and end to end execution, raising defect, update the QC, prepare the TRD and maintain the traceability matrices.
• Involve in Smoke, Functional, and Integration & Regression testing for ETL process.
• Preparation of status reports on Daily basis.

Project#6 :   TEST FACTORY VIDA -Spain Migration project

Client  :    Zurich Financial Services(27.03.2012 - 02.05.2013)

Role  :    QA -L2

Domain    :   Insurance

Tools Used     :    HP Quality Center 9.2,HP ALM ,AS400

Technology    :    DB2

Responsibilities

• Execution of around 600 test cases in Quality Center.
• Knowledge of scenarios like claims, finance, documentation andPolicyadmin.
• Being part of DWH testing team. Testing of Extract ,Transform and load is validated using Informatica.
• Roles and Responsibility involves Analyzing the requirement, understanding and Test case planning, Writing Test Cases, Execution of test case
• Involve in Test case Planning, Test Case creation, Test Execution and Defect Tracking
• Worked in ETL process for loading and processing data files from Source DB to Target DB using Informatica.
• Responsible for monitoring all the jobs that are running, scheduled, completed and failed. Debugged the log files of the failed job.
• Written test cases and SQL scripts/queries
• Drafting test cases for target tables using transformation logic including Joins with multiple table, Derived columns value, Aggregate function, Grouping functions, Linked server source type columns, SCD type columns
• Timely report to the managers regarding any issues.

I hereby declare that the information furnished above is true to the best my knowledge. 

Date: September 2025

Place: Hyderabad