Sr Conversion Etl Qa Analyst Resume
3.00/5 (Submit Your Rating)
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.