Qa Analyst Resume
Jacksonville, FL
SUMMARY
- Around 7 years of experience in Information Technology with emphasis on Software Quality Assurance and Testing in N - Tier client server and SOA through agile (scrum iterative) and waterfall methodologies.
- Proficient in analyzing and reviewing functional specifications, system specifications and Business Requirement document(s).
- Expertise in Requirement Analysis, preparing Test Plan, Test Strategy, Test Cases, Test Execution and Defect Management.
- Expert at utilizing various testing types such as Functional, Smoke, System, Integration, Regression and User Acceptance testing (UAT),Final Acceptance testing (FAT) during testing life cycle.
- Extensively worked on backend testing and well versed with SQL, PL/SQL queries to run the data integrity tests.
- Involved in data driven tests using SQL queries to extract data from different databases and verified them.
- Developed SQL test scripts for functional and regression testing.
- Reviewing and Analyzing Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) and coordinating with developers in writing Test Plans and formulate Test Cases.
- Hands on experience in writing test plans, test cases, developing and maintaining test scripts.
- Good judgment skills while reporting and prioritizing software bugs in conjugation with the development and QA managers.
- Major experience in Insurance suite product(s) like Guidewire, Insurity and with other proprietary insurance applications
- As a scrum team member actively involved in daily meetings, in requirements gathering, reviewing user stories and in planning sprint/iteration backlog through point evaluation.
TECHNICAL SKILLS
Packages: MS Office, Visio, Insurance Guidewire, Insurity
DBs & RDBMS: Oracle 10i, MySQL, SQL Server, TOAD
Operating Systems: Windows, UNIX
Testing Tools: Test Director, Quality Center, HP ALM, Rally, QTP, Load Runner
Web Technologies: HTML, XML, CFML
Version Control: PVCS, Share Point, TFS, SVN, CVS, Doors, Clear Case
SDLC: Agile, V, Waterfall methodologies
PROFESSIONAL EXPERIENCE
Confidential, Jacksonville, FL
QA Analyst
Responsibilities:
- Reviewed and understood user stories/ functional Requirements and various business requirements documents.
- Designed and executed Test plans and Test cases according to product backlog and user stories
- Involved in testing the Guidewire Policy Center for the policies of commercial residential and non-residential.
- Created and Completed the Acceptance Criteria in the Rally as per the business rule defined in the requirement task.
- Prepared Test cases for the requirements to validate against the Source (DB2) to Target (SQLServer 2008).
- Maintained Database integrity for the migration renewal process.
- Worked extensively on running QTP extracts on QTP and reporting the defects.
- Used Quality Center ALM to write Test Cases and log Defects.
- Created the projectTest strategy documentwhich provides the overallframework for the testing activities in the project.
- Test Scripts forUserAcceptance Testingwill be provided after all the sprints are completed and executed inUAT(User Acceptance Testing)
- Identified and organized the overall plan for test data, strategy and the Scope of testing within the context of each Sprint.
- Performed Sprint level testing, Functional Testing, Systems Integration Testing, UAT, and Regression Testing.
- Participated in daily Scrum Meetings, Sprint Planning Sessions, Sprint Review and Sprint Retrospective Sessions.
- Involved in preparing burned down chart for measuring the progress of the project with stakeholders.
- Demonstrated to client/product owner in sprint review sessions that all requirements are met as per sprint backlog
- Interacted with developers, Business & Management Teams and End Users
- Prepared and provided status summary reports on system status, system changes, problems and potential impacts.
- Tested various major functionalities like Policy Submissions, Changes, Cancels, Reinstate, Rewrites and Renewals.
- Performed Policy and Billing Center Integration Testing on various Billing Instructions.
- Worked with developers by updating the defects and resolving them and tracking the status.
- Defects found during testing were logged in HP ALM (Quality Center 11).
- Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data
- Reviewed Product backlog and updated task status in Rally.
- Used QTP 11 for regression testing for functional areas of the application.
- Discussed with the team in identifying regression areas that can be automated
- Involved in creating the frame work for automation testing
- Executed test scripts in QTP for regression testing to ensure the quality of the system
- Maintained RTM to check if all the requirements are implemented and Tested according to entry/exit criteria
Environment: Windows 2003 and 2008, Windows NT/XP, MS Office, Visio, IE, Java/J2EE, XML, HP ALM(Quality Center 11.0), TFS, Windows Share Point Services (WSS), QTP, SQL Server, Oracle 10i, SQL, OnBase, xPression, Guidewire Application suite(Policy Center and Billing Center), Rally.
Confidential, Appleton WI
QA Analyst
Responsibilities:
- Analyzed and reviewed the functional Requirements, system requirements and process flow documents
- Participated in designing and maintained testing process documentation, plans and strategies
- Mentored, coached and trained other test engineers.
- Created Test Cases for user interface, functionality, system and ad-hoc testing from process flow
- Manually executed Test cases after reviewing the business requirement document and technical specifications
- Executed test cases and logged defects using HP ALM (Quality Center)
- Executed end to end Test plans and compared actual results to expected results
- Performed functional, integration, system and regression testing
- Performed UAT and FAT in system testing, preproduction and preproduction-mirror testing environments
- Investigated bugs and consulted business units and developers to reproduce, resolve and retest
- Involved and collaborated in meetings and in WebEx session to solve issues, defects and design of the system with the product application developers and business units onsite/offshore
- Analyzed data that is retrieved from OBS Data Solutions for MVR and D&B Credit check Reports
- Queried database using the SQL for data validations
- Analyzed and captured business data flow in a SOA that uses various applications like TIBCO, .Max and SAP
- Reported status in project and updated management and the integration team(s) on issues
- Responsible for defect management by recording, reporting, analyzing and tracking defects to resolution
- Developed and maintained Requirement Traceability Matrix (RTM)according to entry/exit criteria
Environment: Windows 2003 and 2008, Windows NT/XP, MS Office, Visio, IE, .Net/ASP.Net, XML, QTP, Quality Center, HP PPM, TFS, Windows Share Point Services (WSS), SQL Server, Oracle 10i, Apache, SQL, LexisNexis Insurance Exchange, Data Solutions, TIBCO, .MAX and SAP
Confidential, Madison, WI
Test Engineer
Responsibilities:
- Reviewed and understood user stories/ functional Requirements and various business requirements documents.
- Designed and executed Test plans and Test cases according to product backlog and user stories
- Identified and organized the overall plan for test data, strategy and the Scope of testing within the context of each Sprint.
- Performed Sprint level testing, Functional Testing, Systems Integration Testing, UAT, and Regression Testing.
- Participated in daily Scrum Meetings, Sprint Planning Sessions, Sprint Review and Sprint Retrospective Sessions.
- Involved in preparing burned down chart for measuring the progress of the project with stakeholders.
- Demonstrated to client/product owner in sprint review sessions that all requirements are met as per sprint backlog
- Interacted with developers, Business & Management Teams and End Users
- Prepared and provided status summary reports on system status, system changes, problems and potential impacts.
- Interacted with different integrations services like Rating, Motor Vehicle, Address validation and Document & Forms
- Tested various major functionalities like Policy Submissions, Changes, Cancels, Reinstate, Rewrites and Renewals.
- Performed Policy and Billing Center Integration Testing on various Billing Instructions.
- Worked with developers by updating the defects and resolving them and tracking the status.
- Defects found during testing were logged in HP ALM (Quality Center 11).
- Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data
- Tested business integration between internal and external systems in a SOA.
- Reviewed Product backlog and updated task status in Rally.
- Used QTP 11 for regression testing for functional areas of the application.
- Discussed with the team in identifying regression areas that can be automated
- Involved in creating the frame work for automation testing
- Executed test scripts in QTP for regression testing to ensure the quality of the system
- Maintained RTM to check if all the requirements are implemented and Tested according to entry/exit criteria
Environment: Windows 2003 and 2008, Windows NT/XP, MS Office, Visio, IE, Java/J2EE, XML, HP ALM(Quality Center 11.0), TFS, Windows Share Point Services (WSS), QTP, SQL Server, Oracle 10i, SQL, OnBase, xPression, Guidewire Application suite(Policy Center and Billing Center), Rally.
Confidential, Cherry Hill, NJ
Test Engineer
Responsibilities:
- Reviewed the Functional Requirement Specification (FRS), Product Design Document (PDD).
- Analyzed business requirements and developed Test cases based on Use cases to evaluate the functionalities
- Manually executed Test cases after reviewing the business requirement document and technical specifications
- Involved in preparing Test Strategy, Test Plan, Test Evaluation Summary Reports, Test Cases and Test Scripts
- Participated in UAT, Security, Smoke/Sanity, Regression and Usability testing.
- Extensively used SQL to test Business Object Reports.
- Sent data files to users and developer when requested
- Executed SQL queries to validate the Data tables using TOAD
- Automated the test scripts for the GUI, Functional and Regression testing using QTP
- Manual and Automation Test Scripts were executed in Test Director and Quality Center
Environment: Test Director, Quality Center, C++, CVS, java, J-unit, J2EE, Windows NT/XP, IE, SQL Server, SQL, Web logic 7.x, XML, Oracle Xi, TOAD, PL/SQL and UNIX.
Confidential
Test Engineer
Responsibilities:
- Analyzed the business requirements, functional specifications, system requirements and process flows
- Created Test Cases, mapped requirements to the Test Cases designed executed tests and logged defects using Test Director
- Performed sanity, Black Box, and Regression Testing.
- Analyzed Error log files to find the root cause of issue.
- Responsible for defect management and analysis after defects fixing.
- Developed and maintained Requirement Traceability Matrix (RTM).
Environment: HTML, ColdFusion, J2ee, JSP, Web sphere, Oracle 9.0, JavaScript, Windows 2003, Test Director