SUMMARY

• Over Seven plus years of experience in software quality assurance for client/ server, web based applications and mainframe applications. Experience in implementing QA methodologies, strategies and plans in all stages of software development life cycle.
• Experience of reviewing requirements, analyzing useful and non testable requirements. Escalating issues with business analyst.
• Good experience on Manual testing.
• Experience in manual and automated testing using black box, Grey Box and automation tools. Effectively created, maintained and executed manual and automated test scripts for functional, regression, system, confidence, performance, stress and integration testing.
• Experience of working with automated tools like Quick Test Pro (QTP), and Quality Center. Extensively used, Quality Center for reporting and tracking defects
• Excellent experience in SQL Tuning using Explain and other tools.
• Strong experience in writing SQL queries for data extraction and data mapping.
• Experience of working with Windows, UNIX and Linux operating systems.
• Worked on applications involving Oracle, SQL. HTML, Java, Visual Basic and other environments.
• Very good experience in backend Mainframes testing and DB2 programming.
• Very good experience in Bug Tracking and Bug Reporting using management tools such as Quality Centre.

TECHNICAL SKILLS

Programming Languages: Visual Basic 6, VB .Net, C#, Cobol370, UNIX and Shell Scripting

Operating Environments: UNIX, Windows, and z/Os.

RDBMS: SQL Server, Oracle, DB2 and knowledge of IMS.

Tools: / Utilities DB2 File Aid, BMC Admin and IBM Spufi, QMF and Admin Tool

Testing Tools: ALM, Quality Center 10 and QTP, Compuware Xpediter/Code Coverage, Load Runner, Winrunner and Mobius

Other Tools / Utilities: VSAM, Endevour, Pacbase, Savrs, Xpediter, File Aid, CA - 7, and Serena Changeman.

Hardware: IBM’s z/OS and IBM PC Compatibles.

Office Tools: MS Office (Excel, Word and Power Point)

PROFESSIONAL EXPERIENCE

Confidential, St. Louis

QA Analyst

Responsibilities:

• Worked with Development, Production Support and Business Analyst to build comprehensive regression test packs to for the QA effort.
• Performed SQL Tuning to improve the response time of queries.
• Used SQL queries to extract data from the target tables to validate the data mapping needed for system and user generated reports.
• Performed all aspects of verification, including Functional, Integration, End to End, Regression, Performance and System testing before moving the application to the production environment.
• Performed User Acceptance Testing.
• Performed both white and black box testing against releases
• Designed, developed and implemented complex test automation both at the functional and system level. Leverage existing test tools to automate new regression test packs including using Quick Test Professional as an add-in Quality Center.
• Created test case coverage metrics and requirement coverage metrics and checked test case run, pass or fail, not run, not run due to defect, total number of open defect and total number of closed defect in quality center or test director and reported progress of my team.
• Work with other members of the QA team to improve processes and procedures, tool utilization and selection, defect management process, testing methods and strategies, effectiveness and efficiency.
• Understand the Software Development Lifecycle methodology. Understand how Support fits with the SDLC.
• Analyzed Business Requirements Specification, Functional Requirements Specification (FRS), and Use Case documents to understand the Functionality and develop test cases.
• Analyzed the defects, and prepared & executed test cases, reviewed and verified the test results and logged defects in Quality Center and tracked the progress of the same.
• Discussed discrepancies with the development team identified during QA environment regularly. Submitted weekly status reports showing percentage of application tested and detailed reports on bugs, pass/fail report using Quality Center.

Environment: Quality Center,SQL, SQL Query and Tuning, VB .Net, DB2, Oracle, File-Aid, MS Excel and Word

Confidential, LOS ANGELES

QA Analyst

Responsibilities:

• Worked closely with development team to ensure high quality products are released in time efficient manner. Created test plans and test scripts for application using Quick Test Professional as an add-in Quality Center.
• Created test case coverage metrics and requirement coverage metrics and checked test case run, pass or fail, not run, not run due to defect, total number of open defect and total number of closed defect in quality center or test director and reported progress of my team.
• Involved in manual testing of application using Quality Center.
• Analyzed Business Requirements Specification and Functional Requirements Specification (FRS) and Use Case documents to understand the Functionality and develop test strategies.
• Performed regression and functional testing by Automation tool for Auto Policy Processing System.
• Analyzed the defects, and prepared & executed test cases, reviewed and verified the test results and logged defects in Quality Center and tracked the progress of the same.
• Coordinated user acceptance testing and interacted with the Flow, Development, Design and other teams.
• Performed SQL Tuning to improve the response time of queries.
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Performed analysis of new code in programs using Compuware Xpediter/Code Coverage tool, which is an advanced analysis tool that shows how much of an application/program has been tested and how risky it is to move an application/program into production.
• Discussed discrepancies with the development team identified during QA environment regularly. Submitted weekly status reports showing percentage of application tested and detailed reports on bugs, pass/fail report using Quality Center.
• Worked with manager to identify resource requirements, communicate expected timelines and manage the process improvement effort through implementation and adoption.
• Performed analysis of Code Coverage reports and testing reports.

Environment: Quality Center, SQL, SQL Query and Tuning, Compuware Xpediter/Code Coverage, VB .Net, DB2, File-Aid, MS Excel and Word

Confidential, COLUMBUS, OH

QA Analyst

Responsibilities:

• Participated in the Business Requirements Review & Scope Meetings along with Business Users, Business Analysts and the Development Team.
• Involved in manual, regression and functional testing by Automation tool for My Nationwide project. f application using Quality Center.
• Wrote test cases for manual testing, and created requirement traceability metrics in Quality Center.
• Analyzed the Requirements for each release and provided resource estimation for the project.
• Analyzed and performed SQL query tuning to improve the through put of applications and queries.
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Communicated defects to the developers using Quality Center validated and performed actions as necessary.
• Involved in the weekly status update with the manager and the project leader.
• Interacted with developers and Business Analysts to clarify functionality and requirements in order to achieve an accurate testing of the system.
• Performing IST and UAT testing.
• Prepared defects reports, final reports and test summary reports.

Environment: Quality Center, IBM z/Os, SQL, SQL Query and Tuning, VB .Net, MS Excel and Word, DB2

Confidential

QA Analyst

Responsibilities:

• Involved in reviewing Business Requirement Documents, System Requirement Specification, the Technical Specification, and Functional Requirement Document, Use case document prior to testing for creating scripts.
• Wrote manual test cases using quality center and using requirement document. Run test cases from test lab and logged in defects using Quality Center.
• Performed in debt SQL tuning of queries in the application
• Wrote SQL queries to perform data validation and testing.
• Created test coverage and requirement coverage metrics.
• Participated in UAT, creating and running UAT test scripts.
• Performed functional and regression testing using Quick Test Professional and enhancing script using check points, synchronization point and parameterization and used multiple actions.
• Prepared the Test schedule and System Test Plan and executed the system test cases.
• Interaction and Co-ordination with the Flow, Development and Design Teams
• Interaction and Co-ordination with the service center and external teams to Confidential
• Preparation and execution of regression test cases
• Recording the test logs and updating the QC for the defects

Environment: Quality Center, SQL, SQL Query and Tuning, Visual Basic, QTP and Mobius

Confidential, COLUMBUS, OH

QA Analyst

Responsibilities:

• Participated in all phases of SDLC. Planned for manual testing procedure and scripts,
• Examined and analyzed requirement to document test cases using Test Director. Created test plan and test cases and mapped according to requirements. Involved in defect tracking and generating reports for movement. Identified critical functionalities for performance testing.
• Coordinating with the development team to resolve issues affecting test progress, and execution of test cases, reporting and investigating of test issues.
• Performed SQL Tuning using IBM Explain tool.
• Wrote SQL Queries to extract data from mainframe DB2 environment.
• Performed IST and UAT testing.
• Coordination with client and team.
• Used Quality Centre for defect tracking and bug reporting
• Adhoc work request
• Created technical documents

Environment: Quality Center, DB2, SQL, SQL Query and Tuning, JCL, COBOL, Ezytrieve, UNIX, Shell Scripting and Mainframe DB2 Tools/Utilities.