SUMMARY:

• A Software QA Lead with 6+ years of professional Software Quality Assurance experience in Retail Banking, E Commerce and Airlines domain and proven skills and expertise to contribute effectively towards shaping up an excellent Quality Product/Solution.
• 5+ Years of Functional/Automation Testing using RIT / Green Hat Tester and developed framework for continual testing of Web services (API) flows and also Batch/ETL flows.
• 1+ year of Browser Automation using iMacros tool
• 4+ Years of Batch/ ETL testing using IBM Data Stage application and Mainframe / CA7 application
• Extensive experience in the design, development, and implementation of Test Strategies, Test Plans, Test Estimations, Test Procedures, Test cases, Test Reports, Defect Reports and involved in all phases of testing (Integration, Functionality, Regression, End to End, Defect Triages) with 3 + years of Onsite - Offshore work model
• 1+ year of Functional testing of Mobile apps for Confidential client using Perfecto Mobile tool.

TECHNICAL SKILLS:

Domain Knowledge: Airlines, Retail Banking, E Commerce, Media and Information Systems

Manual Testing: System Integration Testing, UAT, Component Testing, End to End Testing, Database Testing, SQL Query validation, Project Defect Management, Web services Testing

Test/Project Management Tool: Quality Center, Rally, Share Point, JIRA, Confluence, SharePoint.

Test Automation Tool: Rational Integration Tester (RIT V8.6.0.3), Greenhat (GH Tester 5.1), iMacros

Database: Oracle 9i, DB2, Netezza.

Other Tools: IBM Data Stage, QMF, SoapUI, DB2, Autosys, SQL Developer, Putty CM, CA7, Aginity Client for Netezza, ISO/ISPF, File AID, DB2 AID, Clear Quest

PROFESSIONAL EXPERIENCE:

Functional Test Lead

Confidential, Dallas,TX

Responsibilities:

• Functional testing of Crew Member system applications using Agile Methodology.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Development of Automation test scripts for Crew Web Applications using iMacro test tool
• Developing SQLs for Automation test cases for validating the CREW database.
• Preparation and Reviewing of QA Deliverables (Test Plan, Test Scripts, Traceability Matrix) by analyzing Business Requirement Document (BRD) and High-Level and Low-Level Design (HLD &LLD) technical design documents
• Document software defects, using a bug tracking system RALLY /QC, and report defects to software developers.
• Update Test suite based on User stories change, Understanding the Rules harvesting book for Pilots and Flight attendants and modifying Test scenarios’/cases based on that.
• Participate in product design reviews to provide input on functional requirements, product designs, schedules, potential problems.
• Developed automation test suite using iMacros for the browser related regression test cases.
• Development of SQLs for Automation test cases validations

Special Software: Oracle SQL Developer, WinSCP, Rally, XQuery, Quality Center, iMacros, SQL Editor.

Confidential, King of Prussia, PA

Automation RIT Developer

Responsibilities:

• Development of RIT component in the Automation framework
• Preparation and Reviewing of Automation SQLs for each subject area in the data warehouse batch flow
• Mapping the ETL Transformation stages into the SQLs for executing through the framework
• Take part in Work Group Meeting, JAD Session for Design Discussion and in Client Status Meeting for Test Report and Results discussion
• Designing automated test scripts for the Rational Integration tester tool for the Impacted Batch flow.
• Preparation of Execution summary report, Defects reports and Test completion/ Sign off report and coordinating with offshore
• Data Conditioning for Functional Testing, Regression Testing and End-to-End testing using the RIT tool.
• Defect Management & Reporting using Rally and triaging the issue.
• Developed automation test framework using RIT tool to trigger the ETL Batch flows and display the execution results reducing the manual effort for test data and testing timelines from 8 weeks to 2 weeks.
• Developed RIT Regression suite across 10 Data warehouse subject areas which will be executed for each release to ensure the proper functioning of basic functionalities and developed a process to continuously update the suite to include the new functionalities getting added after each release.
• Developing a continual learning process by conducting regular training for the team members on RIT, ETL testing and functional testing on RDS apps, thus reducing the effort on test planning activities.
• Ability to translate ETL maps into the SQL based validations.

Special Software RIT/Green Hat Tester, IBM DataStage, Unix, Autosys, Aginity Netezza editor, Oracle SQL Developer, WinSCP, Rally, XQuery.

Confidential, Charlotte

Test Lead, Release Lead

Responsibilities:

• Leading the QA team as a single POC between Business team, Developers and coordinating with offshore team member for delivering quality products
• Preparation and Reviewing of QA Deliverables (Test Plan, Test Scripts, Traceability Matrix) by analyzing Business Requirement Document (BRD) and High-Level and Low-Level Design (HLD &LLD) technical design documents.
• Take part in Work Group Meeting, JAD Session for Design Discussion and in Client Status Meeting for Test Report and Results discussion
• Designing automated test scripts for the Rational Integration tester tool for the Impacted Web services API.
• Preparation of Execution summary report, Defects reports and Test completion/ Sign off report
• Data Conditioning for SIT Testing, Regression Testing and End-to-End testing.
• Performing functional testing of Mainframe batch flows and ETL Job flows using IBM Data stage.
• Performing functional testing of Bank’s Mobile Applications using Perfecto Mobile
• Perform System Integration Testing, Regression Testing and End-to-End Testing for all RDS apps
• Perform quality assurance activities using IQMS Tool
• Defect Management & Reporting using HP Quality Center and triaging the issue.
• Perform Project Management Activity using IPMS & IRIS Tool.
• Perform Project Billing activities in IPMS and Fieldglass.
• Developed automation test framework using RIT tool to do data conditioning for ETL job flows testing, reducing the manual effort for test data and testing timelines from 6 weeks to 2 weeks.
• Developed Regression suite across 14 RDS applications which will be executed for each release to ensure the proper functioning of basic functionalities for the RDS apps and developed a process to continuously update the suite to include the new functionalities getting added after each release.
• Developed excel macro to process the bulk volume of data comparison which is used for test results validations and reducing manual effort.
• Working with front end teams and business architect teams and help the RDS developers to avoid potential design gaps and plan the testing activities in Agile environment and also in Waterfall model.
• Developing a continual learning process by conducting regular training for the team members on RIT, Perfecto Mobile tools, ETL testing and functional testing on RDS apps, thus reducing the effort on test planning activities.
• Using Imacros (Browser Automation) tool using (Record and Play) functionality, have performed functional testing for bulk data to cover maximum combination of scenarios reducing the manual effort.

Environment: Hardware: IBM 390

Operating System: OS 390, Z/OS, Windows 7 Professional

Languages: DB2, JCL

Special Software: RIT,GH Tester, IIS Suit, Autosys,DB2 Command editor, ISO/ISPF, File AID, DB2 AID, QMF, Unix, HP Quality Centre 11, IRIS, IQMS, IPMS, Clarity Tool, Field glass, Soap UI 4.6.2, Clear Quest, CA7, Perfecto Mobile .

Confidential

Tester

Responsibilities:

• Gathering the impact details of all Web Services application.
• Creating System Integration Testing (SIT) Test Scripts documents
• Data Conditioning for SIT Testing, Regression Testing and End-to-End testing.
• Perform System Integration Testing, Regression Testing, and Testing and End-to-End Testing
• Defect Management & Reporting using HP Quality Center 9.2

Environment: Operating System Windows XP Professional

Languages Visual C#, SQL

Special Software MS Visual Studio 2005, MS SQL Server 2005, HP Quality Center 9.2, IQMS, IPMS, Soap UI 2.6