SUMMARY:

• 7.5 years of experience in Software Testing in Manual, ETL, Database testing.
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle.
• Worked in Banking and Financial services domain, especially in Capital Markets, Private Banking, Mortgage Services and Leasing.
• Extensive experience in Black Box Testing Functional Testing, Integration Testing, System Testing, Regression Testing of Web and windows based Applications.
• Expertise in Design, Development and Executing Test Cases.
• Expertise in writing SQL Queries using Oracle, SQL Server in validating data into Data Warehouse/ETL applications
• Involved in preparation of Test Plans, Test Cases based on High level requirements and make an ensure detailed/system level process wrote Test Scripts
• Involved in preparation of Test Data to test the functionality of ETL Sources Mappings and Targets
• Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tools such as ALM, MI - Tracker, 2S Track and HP-QC, Team track, Qualify
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases.
• Experience in maintaining support documents, QA Sign off Documents and maintaining Weekly Status Reports
• Completed ISTQB Certification.
• Single handedly delivered projects.
• Have good client facing experience and worked in client site in UK, US

TECHNICAL SKILLS:

Software Testing: Test Methodologies, Test Execution, Defect,Tracking, Web/component/Windows/ETL/Database

Operating Systems: Windows

Databases: SQL Server 2005, MySql,Oracle 11 G

Languages: C,Visual Basic

Test Management Tool: MI-Tracker, 2S Track and HP-QC, Team track, Qualify

Automation Tool: Rational robot and Rational Functional tester

ETL Tools: Informatica

Scheduler: Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Tools: Used: Informatica 9.6.1, Oracle 11G, Toad, Autosys, Clear Quest, ALM, Confidential

Responsibilities:

• Understanding the client requirements by studying functional document Interacting with BA’s for requirement analysis and issue resolution
• Involved in the preparation of test scenarios, test cases and test data
• Identified test requirement and checked if the test cases were complete to test the business functionality.
• Writing SQL Queries for Data validation as part of ETL Testing
• Review of the ETL Scripts and suggesting modification in the scripts.
• ETL testing of data extraction, transformation and load process
• Executing the scripts and reporting the bugs through defect tracking tool.
• Reporting to the Test manager about the status of the test activities on a daily basis.
• KT sessions to team members on application functionality.

Confidential

Applications: AS400, SAP

• Understanding the client requirements by having the business discussions
• AS400 testing and SAP testing.
• KT sessions to team members on application functionality.
• Involved in the preparation of test scenarios, test cases and test data
• Identified test requirement and checked if the test cases were complete to test the business functionality.
• Review of the Scripts and suggesting modification in the scripts.
• Executing the scripts and reporting the bugs through defect tracking tool.
• Interacting with the onsite people and resolving the offshore issues.
• Module owner for one of the modules of the application

Confidential

Team Member, Module Owner

Environment: JAVA, J2EE, My SQL, Windows 2003

• Understanding the client requirements by studying functional document.
• KT sessions to team members on application functionality.
• Involved in the preparation of test scenarios, test cases and test data
• Identified test requirement and checked if the test cases were complete to test the business functionality.
• Review of the Scripts and suggesting modification in the scripts.
• Executing the scripts and reporting the bugs through defect tracking tool.
• Reporting to the offshore lead about the status of the test activities on a daily basis.
• Interacting with the onsite people and resolving the offshore issues.
• Module owner for one of the modules of the application

Confidential

Team Lead

Environment: JAVA, J2EE, My SQL, Windows 2003

• Preparing the Test strategy document
• Understanding the client requirements by studying functional document.
• Involved in the preparation of test case, test data.
• Identified test requirement and checked if the test cases were complete to test the business functionality.
• Review of the Scripts and suggesting modification in the scripts.
• Executing the scripts and reporting the bugs through defect tracking tool.
• Reporting to the onsite coordinator about the status of the test activities on a daily basis.
• Interacting with the onsite people and resolving the offshore issues.
• Attended weekly status meetings and provide detailed status report to the client. Previous Work Experience

Confidential

Team Member

Environment: Java, GUI, Manual Testing.

• Testing of Corporate Action Adjustments and Reports.
• Handling the complete testing process.
• Preparing and executing test case documents.
• Reporting, discussing and defining the criticality of bugs and then closing the defects once it was fixed
• Performing Functional Testing and System Testing.

Confidential

Team Member

Environment: Main Frames, NCS.

• Providing Confidential for NCS Corporate Actions.
• Monitoring Batch processing.
• Resolving & Tracking User Queries through 2S Track.