SUMMARY

• Over 8 years Diversified experience in Project Life Cycle Management (PLM) and Software Development Life Cycle (SDLC) which includes (Business Requirement Documentation and Analysis, Designing, Test Planning, Execution and Implementation, Control and Closure as a Software Quality Assurance engineer in the Area of Client/Server and Web-based Application and Web services.
• Experienced in both Manual and Automated testing using Test Director, HP Quality Center, Winrunner and Quick Test Professional.
• Expertise in requirements gathering and defining based on product knowledge and end user interaction.
• Extensive experienced in using tools such as Quick Test Pro, Win Runner, and Rational
• Expertise ad hoc and exploratory testing beyond pre-existing test cases and User stories.
• Comprehensive knowledge of Mainframe test plan, regression testing, and techniques.
• Expertise in SDLC Models such as (RUP, Waterfall, V-shaped, Structured Evolutionary Prototype, RAD, Incremental, Spiral, Agile, Feature Driven Design{FDD}, Dynamic System Development Method{DSDM}, Adaptive, Tailored
• Performed Back-End Testing by means of executing SQL queries.
• Extensively involved in Unit testing, GUI testing, Functionality testing, Integration testing, System testing and User Acceptance testing, Migration testing, security testing, Regression testing
• Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development.
• Experienced in diverse areas like Banking, Finance, Retail, Insurance, and Telecom.
• Extensively involved in UAT testing with internal and external Customers.
• Good understanding of 3 tier, ntier and Service Oriented Architecture (SOA) .
• Extensively involved in Equity Trading Applications with main focus on Electronic Trading Systems.
• Experience in Testing SSIS (Sequel server integration service) Packages.
• Designed and Tested SSRS (sequel server reporting service) Reports.
• Analyzed business requirement, software requirement specification to create Test Plan and Test Cases for manual and automated testing.
• Expertise in various levels of testing such as Unit Testing, Functionality Testing, System Testing and User Acceptance Testing with an extensive Preparation of Test Beds, Installation and Replication of problems, and Generation of Defect reports using various QA tools and follow ups with the development team.
• Experience in different QTP features like Object Identification, Exception Handling, Descriptive Programming, Checkpoints, Regular Expressions, Object Repository, Smart Identification and Recovery Scenario Manager.
• Experience in executing SQL queries in order to view successful transactions of data and for validating data
• Prepared Test Traceability Matrix to confirm the test coverage.
• Used Quality Center for managing, executing test cases and defect logging.
• Working knowledge on Oracle and SQL Server Technologies based projects.
• Excellent communications skills and strong interpersonal skills, which provide me with the ability to interact with end-users, managers, and Developers.
• Experienced in creating and updating the Requirement Traceability Matrix (RTM) based on the Customer Specifications and needs.

EDUCATIONAL QUALIFICATION

• MBA in Finance

TECHNICAL SKILLS

QTP 10.0/9.5/9.0/8.2,Quality Center 10.0/8.2.Winrunner.8.0,8.2.

Operating Systems

Win 95/98/00/XP, UNIX, Linux, MS-DOS.

Databases

SQL Server 2005, MySQL , Oracle 11i,9i

Languages

C, C++, .Net, SQL, HTML, XML, HTTP.

Methodologies

Agile, RAD, WATERFALL, SPIRAL.

Defect Tracking Tools
Source Control

HP–Quality Center,8.2,9.2Rational Clear Case 7.2.2,7.2.3,Clear Quest, 7.1.2.2,7.1.2.3, Bugzilla 3.6,4.0,Jira 4.0,4.2.

WORK EXPERIENCE

Client: Confidential, Sanantonio Texas Mar 2010 – Apr 2012
Sr.QA Analyst
Line of Business: Banking, Mutual funds, Mortgage solutions, Lockbox.
Project Description: Online personal Banking application provides the solutions to automate branch (platform, teller and lending) and Internet banking with Mutual Funds Trading Solution and Total Mortgage Solution. The system performs banking transaction such as checking/saving accounts check facility, deposits & withdrawals, calculating interest of accounts and customer inquiries. The system also generates various reports for both the customers and banking personnel of USAA Federal Bank. The application is integrated to mutual funds and mortgage applications.
Roles & Responsibilities:

• Reviewed business requirements Document from various Lines of Businesses (LOB’s) of USAA banking environment.
• Executed waterfall methodology for the project.
• Generated a Requirement Traceability Matrix RTM and Customer Risk Assessment System.
• Was involved with all the Development and Technical teams for writing the Technical specifications according to Functional requirements specifications.
• Involved in development and Reviewed of Test plans, Test cases and Test scenarios to facilitate the process of testing.
• Developed and executed automated scripts using Win Runner to perform Functionality Testing of the online web application.
• Performed Regression Testing using Win Runner.
• Worked within an Agile / Scrum Environment
• Involved in testing flow of Mortgage files received from Lockbox and involved creating reject report for sequential unpaid accounts.
• Tested the client for ACH, Lockbox, and wire transactions in mainframe for X12, 820, 821, 835, 837, 270/271, 276/277, 278, 996, 997.Also checked data for these transactions in warehouse after loading, releasing these data file transactions.
• UAT tested the clients for ACH, Lockbox, and wire transactions in mainframe for X12, 820, 821, 835, 996, 997.Also tested clients for human readable files like Fax, Cashpro and Email. Checked data for these transactions in Connexion warehouse in LaSalle production and in Bank of America UAT warehouse connexion after loading, releasing these data files transactions.
• Participated in Kick off meetings and Walk through meetings with Development, Business and other QA Team.
• Conducted Scrum meetings, Triage Meetings, Defect resolution meetings.
• Carried out Defect triage meeting using waterfall methodology.
• Performed ad hoc and exploratory testing beyond pre-existing test cases and User Stories.
• CICS (CONTROL information control system it is a part of Mainframes which is primarily used to maintenance and services of the credit card
• Used SNAP (system for new application processing) primarily used for creating new accounts.
• Used File/Aid for retrieving credit card a/c in test region.
• Various command like ARTB are mainly used for maintenance of the credit in the CICS region in Mainframes.
• Developed project implimentation report (PIR) using waterfall methodology
• Performed SQL queries in the Mainframe to extract data required for various different scenarios
• Good Understanding 0f utilizes risk-based testing approaches.
• Made recommendations on testing approaches including what to test or exclude, and how the test should be performed.
• Performed Back-End Testing by means of executing SQL queries.
• Involved in developing the QTP Hybrid Framework for automated testing
• Created library of reusable functions using expert View of QTP.
• Performed Exception Handling in application using Recovery scenario Manager in QTP.
• Extensively worked with VB scripting, checkpoints and Descriptive programming by using QTP.
• Participated in requirements gathering and defining based on product knowledge and end user interaction.
• Involved in Backend Testing writing complex SQL queries and sub queries for database testing
• Conducted annual Internal Quality audits - Identified and recommended corrective actions and continuous process improvements
• Responsible for identifying the regression test cases for Automation.
• Worked with Quality Center to report/track all issues and defects.
• Interacted with developers to follow up on defect reports and actively participated in enhancement meetings.
• Analyzed the data mapping and developed test scenarios to verify the data migration from different sources
• Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer.
• Expert in Developing Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
• Performed Smoke Testing, Functional Testing, Integration Testing, Regression Testing, and System Testing.
• Provided daily operational support for production application systems. Provide some off-hour support coverage for critical business needs.
• Defects tracking, review, analyze and compare results using Quality Center.
• Participated in Kick off meetings and Walk through meetings with Development, Business and other QA Team

Environment: Quick Test Pro 10,Quality Center 10.0, Oracle 11i, JAVA, J2ee, Agile, Waterfall Methodologies, , Mainframes. Lock box.

Client: Confidential, Sanfrancisco CA Oct 2008-Jan 2010
Sr QA Analyst
Project Description
Worked as a senior QA Analyst for the QA test activity on a web application called “Broker Portal”, the application was used by Investment Adviser of Fidelity Investments to manage securities, lending
And margin finance; Broker portal application allows users to access sales, trades, investment products, cash management and online FX trading, FIX protocols(Financial Information Exchange) are used for communication with stock exchanges for equity trading.

Roles & Responsibilities:

• Developed Test Plans, Test Cases and Test Scripts.
• Performed client acceptance testing, functional testing, integration testing, system testing, performance testing, stress testing and load testing.
• Automated some of the end to end scenarios using QTP.
• Developed detailed System Test Plan.
• Extensively involved in ETL testing like Unit Testing, Functionality, Integration testing
• Conducted various SQL Queries in order to perform the back end testing
• Performed SQL queries in the Mainframe to extract data required for various different scenarios.
• Maintained and executed test cases using Quality Centre.
• Performed extensive testing of manual test cases
• Various command like ARTB are mainly used for maintenance of the credit in the CICS region in Mainframes.
• Performed GUI Testing, Functional, Testing manually
• Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer.
• Used File/Aid for retrieving credit card a/c in test region.
• Design/review test scenarios, test data and test cases for different financial user
• Group based on system requirements, solution diagrams, help files, and screen mockups.
• Participated weekly team meetings with business users, developers and updates on the status and raise any issues to the management.
• Analyzed the log files to verify the transfer of data and check the flat files for missing data while calling to the third party applications
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary
• Conducted Scrum meetings, Triage Meetings.
• Used SNAP (system for new application processing) primarily used for creating new accounts.
• Extensively involved in UAT by supporting Testing and implement QA Process
• Wrote test cases using Test Director and logged defects
• Involved as a Tester in Manual and Automation testing of Web based Application
• Executed the test scripts using QTP and analyzed the results

Environment: Quality Centre 9.0, QTP 9.5, Oracle 9i, Java, Windows XP, Agile Methodology, Mainframes.
Client: Confidential, Colebrook NH June 2007- Aug 2008
QA Analyst
Project Description: Automated Underwriting System
Bank North Insurance group Inc is a provider of financial services such as banking mortgage, insurance and investment planning and investment banking. AUS is a web-based application, which provides a financial analysis of the customer’s ability to apply for a loan or an insurance policy. AUS takes the data directly from the online applications and Forms case files, which are checked and validated. A decision is arrived at based on the score.

• Roles & Responsibilities:
• Developed Test Plans and Test Cases and Test Scripts based on the functional requirement documents
• Executed and run manual and automated tests using QTP and Quality Center. Reported the defects to the concerned developer
• Performed Smoke Testing, Functional Testing, Regression Testing, Integration Testing and System Testing.
• Developed data-driven testing, synchronization points, checkpoints and batch testing using QTP.
• Conducted Scrum meetings, Triage Meetings, Defect resolution meetings.
• Used extensively Parameterization to provide varied inputs for the scenario under testing
• Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer.
• Identified and documented all issues and defects to ensure application software functionality.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Performed SQL queries in the mainframe to extract data required for various different scenarios
• Preparation of System Test Results after Test case execution.
• Coordinated with Offshore team and Onsite managers
• Conducted daily scrum meetings.
• Managed defects, Execute Test cases, and track product progress
• Consolidated the Status Reports on Daily and Weekly Basis.
• Involved in reviews, Manual Testing, Integration Testing, Regression Testing, Functional Testing, System Testing, and User Acceptance Testing

Environment: Quick Test Pro 9.0,Quality Center 8.2, SQL, Oracle 9i, Windows XP, VB.NET,
ASP.NET, HTML, Agile Methodology.

Client: Confidential, Chicago, IL Jan 2006 – April 2007
QA Analyst
Project Description:
BACCS (The billing and Customer Care System ) provides centralized database to maintain the call details, rating parameters, bill collection and customer details .This system has web based interface for bill collection,enquiry,addition/modification of rating parameters and new services. Web based interface ensures accurate collection updates to customer accounts.

Roles & Responsibilities:

• Involved as a QA Analyst in Manual and Automation testing of Web based Application
• Executed the test scripts using QTP and analyzed the results
• Automated some of the end to end scenarios using QTP.
• Worked on Object Repository, Object Repository manager, Associate Repositories and Map Repository parameters, using expressions, data table.
• Performed data driven testing using Excel sheets and Database in QTP and verified that the application was working properly with different data inputs.
• Documented the Test Cases, Test Procedures, Test Scripts and Test Metrics.
• Maintained and executed test cases using Quality Centre.
• Performed Functional ,Regression and Integration testing to make sure the application
• Conforms to the requirement specifications.
• Involved in Reviewing, Peer reviewing of Test cases and scenarios
• Involved in test case creation and modifying existing scripts/Test cases
• Involved in Test case merging with existing regression scripts.
• Test case execution and defect logging using Test Director.
• Performed sniff testing for regular builds
• Resolved issues and provided on-call support regarding production system.
• Regularly involved in the meetings with the onsite co-coordinators to discuss the issues and report the status.

Environment: Quick Test Pro 8.2, Quality Center 8.2,SQL, Oracle 9i, ASP, HTML, Agile Methodology

Client: Confidential, Columbus, OH Feb 2004 -Nov 2005
QA Analyst
Project Description
DSW, Inc. One of the biggest retail companies in US, which sells footwear products. The project was enhancing existing functionality of online shopping by Member account, Guest account and store Locator.
Roles & Responsibilities:

• Analyzed Business, Functional Requirements and Use cases and developed Test Plans, Test cases for both positive and negative tests.
• Involved in Test plan and Test case preparation.
• Performed Functional Testing, System Testing, Regression Testing, Integration Testing and Smoke Testing.
• Performed Regression Testing to verify various sections of the system to ensure that changes or fixes in the system not only work, but also do not adversely affect the remainder of the system.
• Performed SQL queries in the Mainframe to extract data required for various different scenarios.
• Implemented waterfall methodology for the project Execution.
• Executed project top down and bottom up approach.
• Carried out waterfall methodology for bug triage meetings.
• Developed project implementation report (PIR) using waterfall methodology
• Responsible for identifying the regression test cases for Automation.
• Initiated defects and assigned to Development teams with appropriate severity levels.
• Actively participated to setup the test environment for the application(s) needs to be deployed on test environment
• Validated database operations by executing SQL statements.
• Contribution in creatingRequirement Traceability MatrixinQuality Center.
• Prioritized and reported defects using Quality Center, to present documents and reports in weekly team meetings.
• Analyzed the error log file in theUNIXfor troubleshooting
• Used Test Director as a tool for Bug Tracking and Test Management

Environment: Compuware QA Run, Compuware QALoad, Compuware QA Director, Java, ASP. Net J2EE, Apache Tomcat, MS SQL Server, DB2, UNIX, Windows XP/2000/NT, Mainframes, Waterfall Methodology.