SUMMARY

• Around 7 years of hands - on experience in diversified fields of the Software Development Life Cycle with experience in managing testing lifecycle process end to end using Waterfall & Agile methodologies.
• Quality Assurance experience in manual/automation testing, Compatibility Testing, audit process especially in performance/Load and Stress testing.
• Expertise in implementing testing strategies for the web-based application - Insurance Policy Admin tools (OIPA and ALIP), Portals.
• Experience in Leading an offshore QA team of 13 testers.
• Experienced in Reporting and Tracking Defects by using Bug Tracking tool such as Quality Centre (9, 10, 11,12).
• Experience in writing test cases using ZEPHYR in JIRA.
• Strong experience in web-apps Manual Testing (using HP QC/ALM/JIRA/Zephyr) and API Testing using POSTMAN tool.
• Strong experience in Manual and Automation Software Testing which includes Mobile Testing, Web Services Testing, working SDLC methodologies such as Waterfall, Agile and Scrum.
• Experienced in Web Application testing with Selenium WebDriver on multiple browsers such as Firefox, Internet Explorer, Safari and Chrome.
• Experience in QC Test Plans, Test Planning, Test Strategy, Test Cases Design, Test scripts, Test Data Setup, Defect Management, Test Traceability Matrix and Test Reports.
• Experience with relational databases like SQL Server, Postgres, DBVisualizer and MySQL databases.
• Expertise in database testing, validating data in two different database/same database. Worked on Teradata, Oracle and Postgres databases.
• ETL testing for testing the workflow from front end source systems to databases and end reporting.
• Programming knowledge in Java, XML and HTML.
• Strong experience in Insurance domain and knowledge in Banking, and Retail domains.
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC).
• Involved in all standard Agile activities like Functional Testing, show and tell before User Acceptance Testing, Preparation of Training material, and conducting actual User acceptance testing.
• Strong experience in Designing and Implementing Test Plans, Test Scenarios, Test Cases, Test Scripts, Manual, Automation and Performance Testing, Web Testing, Batch Testing, ETL Testing, End to End Testing, Black-box Testing, API Testing, System Testing, Stress Testing, Smoke Testing, Usability testing, Black Box Testing, Test Documentation, Release documents Quality process.
• Experience in Bug Reporting and Defect tracking, conducting Bug review meetings and coordinating with Development team for Bug fixation.
• Extensive experience in Defect management using tools like JIRA, HP-ALM, Bugzilla.
• Experience in Data Driven Testing. Executed SQL queries, joins and stored procedures.
• Strong experience with SOA architecture which includes SOAP and RestFull Web Service Testing.
• Experience in testing and writing SQL and PL/SQL, T-SQL statements and Stored Procedures.
• Familiar with Mobile App testing using Appium and Selenium Mobile Drivers on IOS and Android Devices.
• Knowledge on Selenium Grid for running the Automation Test script on different Platforms and Browsers.
• Test Plan management including Requirement analysis, identify QA scope, identify QA resources and managing their allocation, providing QA estimates, billing, test plan and strategy preparation.
• Test Organization management including staffing, training, team building, supervising, assessing teams and individual’s performance.
• Test Documentation management involving develop test plan, manage test project schedules, test case management, defect management and preparing requirement - test case traceability matrix.
• Extensive working experience on OPAS, ALIP, Web &Workflow Systems, Postgres, ETL testing, QA Functional Testing, GUI Testing, Unit Testing, Integration Testing, System Testing, End-to-End testing, Regression Testing and User Acceptance Testing
• Vast Experience in developing Manual Test Cases in Manual Testing Using HP ALM/Quality Center, JIRA, Zephyr.
• Expertise in defect management using HP Quality Center.
• Extensive working Experience on Insurance domain.
• Hands on Experience in Automation Testing Using Selenium Java.

TECHNICAL SKILLS

Testing Methodologies: Manual and Automated Testing, ETL Testing, User Acceptance Testing ( UAT ), White/Black box testing, Regression Testing, Integration Testing, Batch Testing, End-to-End Testing, System Testing, Performance Testing.

Testing Tools: Selenium Web Driver, Jmeter

Business Analysis: Requirement Management, Use Cases, Test Strategy, Test Plan and Test Cases.

Development Methodologies: Agile, Scrum, Waterfall

Frameworks: TestNG

Bug Management Tools: HP Quality Center/HP ALM, JIRA, Bugzilla, QTest

Programming Languages: Java

Database/ Database Tools: Oracle Server, SQL Server, Postgres, Teradata, MySQL, Toad, SQL, DB Visualizer, SQL, Zephyr, JIRA, POSTMAN, HP ALM 9.0, 10.0, 11.0

Utilities/ Tools: Eclipse, Jenkins, GitHub

Operating System: Windows, Unix/Linux, MacOS

Policy Admin Tools: ALIP (Accenture Life Insurance Platform), OPAS (Oracle Insurance Policy Administration System)

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Sr. QA Lead

Responsibilities:

• Worked on ADS(EDM), ALIP, OPAS, PDFs Comparison, Policy Pages, Correspondence, and Actuarial Reports modules.
• Assessed & Analyzed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures and Test reports.
• Identify the scope of the testing required for a particular release based on the requirements document.
• Reviewed Functional Requirement Specifications and created test cases in Zephyr/JIRA based on test scenarios drawn from functional requirements.
• Identifying the required metrics and work to have them in place. These metrics includes an inherent goal for the test team as well as what is being testing.
• Identifying the needed testing effort by calculating the sizing needed for the given release and plan the effort needed for the same.
• Creating Test Strategy and planning test activities for the team based on Sprint.
• Used defect tracking tools like JIRA and Zephyr.
• Creating SQL Queries to verify the values between source and target.
• Reading the Mapping document to verify and check the data between source and target.
• Identify the tools for test reporting, test management, test automation, etc.
• Prepare any risk mitigation plans in case there are any delays are foreseen.
• Involved in Conducting scrum events like Sprint Planning, Backlog Review, Sprint Review, Sprint Retrospective, and Daily Scrum calls.
• Involved in functional testing of SOAP and RESTful API services using SOAP UI Tool and tested both XML and JSON formats.
• Use of Postman to do manual testing for API using POSTMAN tool for GET, POST, PUT requests.
• Checking the response time, response code and output condition for different response using POSTMAN tool.
• Prepared test reports, traceability matrices, defect reports and various other management reports using HP Quality Center and conveyed with Management.
• Created SQL scripts for the retrieval of data from the relational database (inner joins, outer join, group by, order by, cursors, etc.)
• ETL testing for testing the workflow from front end source systems to databases and end reporting.
• Wrote defect reports, manages defect-feedback loop and tracks ETL change requests.
• Conducted Integration, ETL Testing, End to End, SIT, functional testing, regression testing, Sanity testing, and UAT.
• Using Jenkins as continuous integration tool to schedule the automated builds by monitoring the version control system.
• Documented the Lessons Learnt and Best Practices from each release and shared with the business for the Process Improvement and implemented them in the future effort.
• Did a POC to convert existing framework to Cucumber ( BDD ).
• Involved in writing Tests and doing manual Interaction with Behavior Driven Development framework.
• Daily scrum and stand up call with offshore team.
• Coordinating with 5 offshore testing teams with 13 resources.

Environment: HP Quality Center, Zephyr, JIRA, Postgres, SQL, ETL, Jira, ALIP, OPAS, SQL Developer, Zephyr, ADS, EDM, Docupace, Jenkins, Sprint planning, Scrum calls, Smoke Tests, JMeter, JIRA, Functional and Performance Testing, Firefox, Chrome, Safari, Edge & Explorer.

Confidential, West Des Moines, IA

QA Lead

Responsibilities:

• Worked on Policy Admin System(OPAS), Oracle and Teradata Database, and Web & Workflow Systems modules.
• Test plan preparation after discussions with the test team and have it reviewed and approved by the management/ development team.
• Identifying the required metrics and work to have them in place. These metrics includes an inherent goal for the test team as well as what is being testing.
• Identifying the needed testing effort by calculating the sizing needed for the given release and plan the effort needed for the same.
• Identified the scope of the testing required for a particular release based on the requirements document.
• Present the timely status to the stakeholders and management.
• Created SQL Queries to verify the values between source and target.
• Reading the Mapping document to verify and check the data between source and target.
• Involved in database Testing (created and executed SQL Queries).
• Creating Test Strategy and planning test activities for the team based on release.
• Use of HP Quality Center/ALM for maintaining testing activities.
• Prepare any risk mitigation plans in case there are any delays are foreseen.
• Prepared test scenarios, test plan and test strategy.
• Reviewed Functional Requirement Specifications and created test cases based on test scenarios drawn from functional requirements.
• Prepared test reports, traceability matrices, defect reports and various other management reports using Quality Center (ALM) and conveyed with Management.
• Used Quality Center (ALM) for Defect Reporting and Defect Tracking.
• Daily status call with offshore counter parts.
• Tracked the defects and reported the defects using Quality Center.
• Conducted Integration, End to End, SIT, functional testing, regression testing, Sanity testing, and UAT.
• ETL testing for testing the workflow from front end source systems to databases and end reporting.
• Identified the tools for test reporting, test management, test automation, etc.
• Done performance testing to determine that the web application, under test will satisfy high load requirements using JMeter
• Coordinated with the development team to resolve the defects and provided technical problem resolution and system enhancement support. Conducting daily defect triage meetings and reporting.

Environment: Oracle SQL, Teradata, JMeter, XML, SQL, DB Visualizer, Quality Center 10.0, 11.0, JIRA, JAVA, Wed-based applications, Jenkins, Quality Center, JMeter, Performance Testing, Stress Testing, Load testing, Integration Testing, Regression Testing, Firefox, Chrome, Safari, Edge & Explorer, Win dows, Agile.

Confidential

QA Automation Tester

Responsibilities:

• Worked on OPAS/OIPA (Oracle Policy Admin Server), A2K (Workflow Applications), SS - IAS - Oracle, IAS - EDW (Data warehouse) - Teradata, and EDW - Portals (Web based application) modules.
• Involved in the requirements gathering and Analysis of requirements.
• Involved in story pointing during sprint planning.
• Working through planning and giving estimates on planned changes.
• Involved in the test plan preparation.
• Creating Test Strategy for testing the items based on the requirements documents.
• Use of HP Quality Center/ALM for maintaining testing activities.
• Preparation of Test Scripts as per business requirements.
• Automation of test cases with TestNG framework in Data Driven Model.
• Performance testing using Jmeter.
• Building reports through and checking with back end database tables.
• Developed SQL Queries for testing.
• ETL testing for testing the workflow from front end source systems to databases and end reporting.
• Testing different type of requests in API using POSTMAN tool.
• Created Test Scripts for Application & System Testing and Regression Testing.
• Defect Management, Defect resolution Time frames.
• Defect Tracking and Status Reporting.
• Involved in Release Management.
• Preparation of Test summary report.
• Co-Ordination with Onshore team on daily basis.

Environment: XML, SQL, DB2, Wed-based applications, Soap UI, SQL, Postman, Quality Center, Agile, Sprint, Jenkins .