SUMMARY

• Result oriented professional with 12+ 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 and Agile methodology.
• 4 years of experience as a Test Lead in multiple projects managing and delivering enterprise scale software on-time and quality with their scope intact.
• 4 years of experience in Guidewire ClaimCenter testing (Configuration, Integration and Conversion)
• Strong domain knowledge in Insurance (Annuity, Life, Workers Compensation and Property & Casualty), Banking & Financial Services.
• Strong SQL knowledge and expertise with all ORACLE database objects.
• Good hands-on experience in Salesforce.com testing.
• Involved in developing complex reports using Crystal Reports XI R2.
• Extensive experience in ETL/datawarehouse testing.
• Strong experience in web-apps Manual Testing (using HP QC/ALM), Automation Testing (using QTP/UFT and Selenium).
• Extensive experience on Issuing Annuity policy in Oracle Policy Admin System and AS400 policy admin systems.
• Extensive experience in User Acceptance Testing, System Testing, Black-box Testing, End-to-End Testing, Functional Testing, Smoke Testing and Regression Testing.
• Expertise to implement testing strategy and process based on production release schedule.
• Experience in coordinating the QA activities in testing team in support of systems and projects.

TECHNICAL SKILLS

Testing Tools: HP ALM/Quality Center, JIRA, Xray, XML Spy, Soap UI, Selenium, Cucumber, Excel Macros

Programming Languages: Java, Python

Operating Systems: Microsoft Windows XP/ Vista/ Windows 7/ Windows 10

Database/Tools: Microsoft SQL Server, Oracle SQL, TOAD

Packages: MS Office products

Methodologies: Agile, Waterfall

Other: Beyond Compare, FileZilla, Putty

Applications: Guidewire ClaimCenter, Salesforce, Crystal Reports XI, Oracle Policy Admin System (OPAS)

PROFESSIONAL EXPERIENCE

Confidential

Sr Conversion ETL QA Analyst

Responsibilities:

• Developed automated test scripts for creating Property & Casualty and Worker’s compensation claims by using Selenium.
• Created a test plan for testing configuration and conversion workstreams of ClaimCenter implementation.
• Written the SQL queries for testing the data migration from Legacy claims system to Guidewire ClaimCenter.
• Created manual test scripts for verifying different integration user interfaces such as Medical Bill Review, Document templates, Policy admin system and Legal-X.
• Tested end to end claims process from first notice of loss through the execution of financial transactions, including the payment and setting of reserves.
• Created test data for multiple policy coverage and policy type combinations and verified whether the response is received from ISO.
• Verified user roles, groups, permissions, message queues and WC parameters in Administration screen.
• Written and executed the SQL queries for checking data balance between the current system and ClaimCenter after every data migration load.
• Executed web service calls (soap and rest) to agency interface and Central Management System (CMS) through Soap UI.
• Assisted the automation team in providing test cases and test data which are to be automated and ran the test scripts using selenium for regression testing.
• Tracked and reported defects in JIRA and interacted with developers to resolve technical issues by participating in daily defect status calls.
• Verified Team dashboard and Desktop screen queues with multiple user logins.
• Performed a security testing to make sure that each user role (adjuster, supervisor etc) has appropriate permissions.
• Co-ordinated with different downstream teams and helped them for their validation.

Confidential

QA Lead

Responsibilities:

• Reviewed and analyzed the business requirements. Created a high-level test strategy and present it to the business team.
• Attended the source to target mapping walkthrough meeting and analyze the source to target mapping document.
• Developed and executed the Test Plan, Test Scripts and Test case execution based on Waterfall/Agile methodology.
• Prepared the source and target SQL queries in Oracle SQL developer and Teradata SQL Assistant.
• Accessed and query the flat files through Microsoft SQL query.
• Created a master test bed spreadsheet for tracking all the test data requirements.
• Issued annuity policies from Oracle Policy Admin System and AS400 policy admin systems.
• Developed the data model test cases.
• Generated planning traceability report and requirement traceability matrix for each release.
• Evaluated the readiness of test environment.
• Conducted knowledge sharing and training sessions for offshore team.
• Executed Test Scripts using HP QTP and managed all the defects in HP Quality Center.
• Co-ordinated with the developers to fix the defects logged in HP Quality Center.
• Co-ordinated with UAT team and help them for their validation.
• Generated execution traceability report and Metrics report from HP Quality Center.
• Prepared a weekly status report and send it to all QA team.
• 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.
• Prepared the exit criteria and complete the testing workbook.

Confidential

Sr QA Analyst

Responsibilities:

• Reviewed and analyzed the business requirements. Created a high-level test strategy and present it to the business team.
• Attended the source to target mapping walkthrough meeting and analyzed the source to target mapping document.
• Developed and executed the Test Plan, Test Scripts and Test case execution based on Waterfall.
• Prepared the source and target SQL queries in Oracle SQL developer and Teradata SQL Assistant.
• Accessed and query the flat files through Microsoft SQL query.
• Created a master test bed spreadsheet for tracking all the test data requirements.
• Issued annuity policies from Oracle Policy Admin System and AS400 policy admin systems.
• Developed the data model test cases.
• Developed manual test cases for testing Salesforce.com UI.
• Generated planning traceability report and requirement traceability matrix for each release.
• Evaluated the readiness of test environment.
• Conducted knowledge sharing and training sessions for offshore team.
• Executed Test Scripts using HP QTP and managed all the defects in HP Quality Center.

Confidential

QA Analyst

Responsibilities:

• Understood and discussed QA scope and requirements specification in QA kickoff meeting.
• Reviewed and analyzed the business requirements and prepare the query log.
• Created a high-level test plan and present it to the business team.
• Initiated a testing workbook and complete the End of planning checklist.
• Analyzed the source to target mapping document and prepared a query log and send it to onsite team.
• Developed and execute the Test Plan, Test Scripts and Test case execution based on Waterfall methodology.
• Prepared the source and target SQL queries in Squirrel SQL Client.
• Understood the data model for Target database.
• Developed the test cases for UNICA reports developed in Business objects.
• Generated planning traceability report and requirement traceability matrix for each release.
• Evaluated the readiness of test environment.
• Developed and execute Test Scripts using Microsoft Excel VBA.
• Managed all the defects in Star team.
• Co-ordinated with the developers to fix the defects logged in Star team.
• Generated execution traceability report and Metrics report from HP Quality Center.
• 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.
• Completed the end of release and end of project checklists.