SUMMARY:

• Over 7+ Years of professional experience in Quality Assurance Analyst & testing in Banking, Financial and Insurance (Property & Casualty) domains
• Exposure to both Manual as well as Automated Testing of Client Server as well as Web - based applications
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Adept at using both Manual and Automated Testing tools to troubleshoot systems, Integration, User Acceptance, Positive and Negative, GUI and Functionality, Regression Testing
• Expertise in Automated Testing for functionality with Rational Functional tester, QTP, Win Runner
• Have good exposure to modern Agile methodologies such as SCRUM, TDD (Test Driven Development)
• Experience in working with Agile as well as traditional SDLC cycles.
• Experience with Agile Sprint Management and Bug tracking solutions such as VersionOne/Jira.
• Experience in Functional, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.
• Good understanding of all modules of Quality Center such as Requirements, Test Plan, Test Lab, Defects and Dashboard reports.
• Performed Back End Testing by executing SQL queries.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Performed User Acceptance Testing (UAT) manually.
• Experience in working with the databases such as SQL Server, MS Access and Oracle and wrote SQL queries for Backend Testing
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.
• Used Quality Center for Bugs reporting/communicating to developers, product support & test team members.
• Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
• Extensive working experience in Oracle on UNIX Environment.

TECHNICAL SKILLS:

Testing Tools: Quick Test Professional (QTP), Win Runner

SDLC: Waterfall, Agile, Spiral, RUP.

Defect Tracking Tools: VersionOne, Rational Clear Quest, Quality Center, QTP, Bugzilla

Operating Systems: UNIX, Windows, Mainframe, CICS

RDBMS: SQL Server, Oracle, DB2, Teradata

MS Office Suite: MS Word, Excel, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

QA Analyst/Tester

Responsibilities:

• Performed Functional, System, Security, and Regression & User Interface testing of software applications.
• Created & maintained detailed test cases to perform various types of testing in Test Plan module of QC.
• Interacted with the Business Users and BA to determine and review BRDs, SRSs, and FRDs.
• Created Detailed Test Plan, Test Approach, Test Matrix, Test Strategy documents based on the information gathered through business requirements and design/application walkthroughs.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Created & executed test plans and scripts to verify software functionality & adherence to business requirements.
• Performed Grey Box, Black box testing and User Acceptance Testing.
• Utilized Defect module of HP ALM/Quality Center for Defect Management.
• Manually test each and every module of the application and verify against expected results.
• Performed Sanity and Smoke Testing of the application manually after each build.
• Performed Functional, GUI, Security, Positive and Negative Testing.
• Performed rigorous manual testing before a release.
• Used Test Lab module of HP ALM/QC to perform test execution activities by creating various test sets.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Documented & reported defects within established process & tracking systems using HP ALM/Quality Center.
• Experience with Agile Sprint Management and Bug tracking solutions such as VersionOne
• Involved in the discussions of Defect Tracking Process and Updated Work Progress in Excel Sheets.
• Wrote and maintained test documents; converting documents to soft version maintained by the customer.
• Carried out GUI, Functionality, Integration and Regression testing using HP ALM/Quality Center.
• Performed Backend testing using SQL queries against Oracle database to perform data validation, to check data integrity etc.
• Worked with business users, business analysts and SMEs to understand different critical business processes.
• Facilitated defect management, meetings and test execution status meetings.
• Identified, analyzed, and documented defects, errors, and inconsistencies in the application using HP ALM/Quality Center.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.
• Tested for data in the database by writing SQL queries for SQL Server before testing the module
• Extensively utilized Requirements, Test Plan, Test Lab & Defects Modules of HP ALM/QC during STLC.
• Coordinated with the developers on Defects Status on a regular basis.
• Participate in various meeting and discussed Enhancement and Modification request.

Environment: Windows, SQL, Server, VersionOne/HP ALM/Quality Center, SOAP UI, SOA, XML, SQL, QTP, Web logic, UNIX, Oracle, Agile, UAT

Confidential, Somerset, NJ

QA Analyst/Tester

Responsibilities:

• Created Test Cases, Test Scenarios in ALM/Quality Center ensured traceability to Business Use Cases and according to application.
• Involved in creating of Test Accounts in mainframe application according to the Business Requirements in utilization for testing.
• Created test cases manually to perform different types of testing such as positive/negative, functional/regression, interface, black box, batch testing, screen navigational testing, smoke/sanity testing, unit testing, performance testing, exploratory testing or Backend testing
• Used ALM/Quality Center to create test plans and test cases
• Performed onsite-offshore coordination for multiple projects to perform test related activities.
• Designed & maintained test schedules, test plan, test strategy, test assignment docs for various testing activities.
• Develops and executes test cases based on user stories contained within an Agile Sprint
• Using share point to access and share commonly used documents.
• Using Team Foundation Server to report defects found.
• Used SQL queries to validate the data between the backend and the front end
• Analyzed business requirements to write test plans and test cases
• Executed test cases in three different environments (Test, Model and Integration)
• Performed various testing such as end to end, regression, negative and positive.
• Generated the test execution report in ALM/Quality Center to be reviewed by the QA Manager and development team.
• Wrote SQL statements by inserting, deleting, updating data to/from the database to test new entry, update, and delete operations.
• Reviews project requirements to ensure requirements are testable.
• Worked with development teams and business analysts to understand the functional specs regarding the critical business areas.
• Exported Manual test cases into ALM/Quality Center and maintained the same in the Test Plan module.
• Provides estimates on the amount of time needed to complete testing related tasks within a sprint
• Facilitates test case review sessions with other Agile team members
• Testing integration points between multiple systems
• Wrote complex SQL scripts for Backend testing and Frontend Data validations
• Performed test case assignments in Test Lab modules of ALM/Quality Center.
• Generated and published various Daily and Weekly test status reports during the test execution phase of STLC.
• Led the Bug Review meetings to identify, analyze & drive the issues towards resolutions based on BA severity.
• Created and executed the Test Scripts for Data Migration and Data Verification testing
• Generated various defect reports for stakeholders.
• Detected, reported and tracked defects using ALM/Quality Center.
• Recommend and implement naming convention for Test Cases, Test Sets and Defects.
• Attended Weekly status meeting in reporting and provided a weekly report that includes test metrics consisting of status reports.

Environment:: ALM/Quality Center, Agile, SQL, UAT, QTP, UNIX, Oracle, DB2, HTML. .Net, MS Office, WindowsConfidential, Irvine, CA

QA Analyst/Tester

Responsibilities:

• Analyzed system requirements developed detailed Test Plan and test cases.
• Selected, designed, and prioritized test scenarios and test cases that provided efficient coverage of requirements consistent with acceptable level of risk.
• Manually tested modules for compliance with functional requirements.
• Performed negative and positive testing manually.
• Identified, analyzed, and documented defects, errors, and inconsistencies in the application using MS Excel.
• Imported test cases from MS Excel, MS Word to Quality Center.
• Worked in Agile Scrum methodology for both manual and automation testing.
• Use Quality Center application for Defect entry and maintain test cases for Agile process.
• Conducted Back-End Testing for Oracle databases using complex SQL queries.
• Performed functional testing, navigation testing.
• Performed Database Integrity Testing by executing SQL statements.
• Performed comparison of actual report with the expected values by querying the database.
• Performed extensive manual testing on critical functionalities of the application.
• Coordinated with the developers on Defects Status on a regular basis.
• Worked closely with development team to resolve various issues.
• Experienced in backend testing by executing SQL queries.
• Manually tested the web application to ensure the flow of the application functionality
• Tested applications and documented results and bugs including documentation of information useful in the debugging process.
• Participated in release meetings.

Environment: MS SQL Server, Quality Center, HTML, MS Office, MS Outlook, SQL, Agile, MS Excel, MS Word