We provide IT Staff Augmentation Services!

Sr Conversion Etl Qa Analyst Resume

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.

Hire Now