SUMMARY:

• 6+ years of experience in Functional and ETL (Extract Transform Load) testing; in all phases of testing life cycle, including requirements gathering and analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Certified Scrum Master (CSM), working predominantly in Agile environment using CA Rally (Agile Central) as a Scrum tool. Also worked with Rational Team Concert (RTC).
• Experienced in Waterfall methodology as well.
• Expertise in Personal and Commercial Insurance products of Insurance like Life and Health Insurance, Property Insurance, Vehicle Insurance, Tradesman and Professional Insurance.
• Adept in working on ASC X12 EDI file formats file for Confidential Enrollment, 270/271 Eligibility/Benefit response files, file for Confidential Claims processing and QNXT hub (database and UI) for data verification.
• Working on Health Insurance and Commercial Insurance applications handling clinical data and administrative data files exported to vendors.
• QA Analyst for implementation projects for individual health plans and Large projects, individually performing and also mentoring a team performing Quality Assurance activities.
• Professional experience in policy life cycle from Quote and Accept - Adjustments - Renewals - Cancellations, servicing of contracts on policy administration systems and also worked on Insurance Underwriting workstation, and Claims and Payments workstation.
• Thorough working knowledge of ETL testing using SAS ( Statistical Analysis System ) for client specific applications, worked with Windows Task Scheduler for scheduling and monitoring jobs and AS/400 target/load system to validate the insurance policy details.
• Proficient in Microsoft SQL for performing database validations.
• Experience in Web Services Testing using XML
• Individually handled System and Regression Testing, System Integration Testing and User Acceptance Testing while working with test management tools - HP ALM, IBM Clear Quest, RQM (Rational Quality Management), SilkCentral.
• Underwent separate training in automation using TOSCA Test Suite and .NET framework.
• Active interaction with Client management and timely communication with all stakeholders (Developers and Business Analysts) to report, analyse and clarify issues.
• Experienced in handling onsite-offshore team structure, working with multiple vendors and geographically distributed teams.
• Involved in preparing Project Audit related artifacts as a Defect Prevention Anchor.

TECHNICAL SKILLS:

Languages: SQL

Testing Tools/ Bug Tracking Tools: HP ALM, SAS, IBM RQM, Clear Quest, RTC, CA Rally, Silk Central, Test Director, Mercury Quality Center 8.2, Rational Suite7.1/2001 and Selenium

Operating System: Windows O/S Family, Mainframe zOS, AS/400 and Linux

Databases: Microsoft SQL Server and Oracle

PROFESSIONAL EXPERIENCE:

QA Analyst

Confidential, Phoenix, AZ

Responsibilities:

• Responsible for requirement analysis, ELV, User Story review and sizing, in Agile environment for Project Delivery.
• Responsible for testing the load of inbound 834 file data from State, through EDI Gateway, into Confidential data repositories.
• Understand the State specific guidelines and requirements for Member Enrollment through 834 file format, from requirement document, Companion Guide and State sample file.
• Individually performing quality assurance activities in implementation projects for new health plans.
• Involved in successful implementation of new Health plans for Confidential Confidential .
• Part of the core team for Confidential Better Health Initiatives like Other Insurance Coverage (OIC) implementation for all Health Plans and Qualified Medicare Beneficiary (QMB) project implementation.
• Work on preparing test 834 file, using Ultra Edit for Confidential Member Enrollment processing per State requirements, for Confidential serviced plans.
• Monitor the Confidential 834 file processing jobs which parse file data into tables in Confidential customized databases.
• Work on parsing 834 file to Microsoft Excel format to simplify data validation.
• Verify member data in the QNXT databases and QNXT User Interface.
• Responsible for testing the load of inbound 837 claim file data from clearing houses, through EDI Gateway, into Confidential data repositories.
• Understand the 837 file format from Companion Guide and State sample file.
• Work on preparing test 837 file for Confidential Claims processing per State requirements, for Confidential serviced plans.
• Monitor the Confidential 837 file processing jobs which parse file data into tables in Confidential customized databases.
• Verify claim data in the QNXT databases and QNXT User Interface.
• Adjudicate the claims using QNXT Mass Adjudication to get the claims to ‘PAY’ or the required status and trigger Check-run process for Payments.
• Verify secondary claims for members with dual eligibility.
• Work on other ancillary applications for verifying Confidential member data. Verify the outbound data extracts to 3rd party vendors.
• Individually handled a project which spanned across 16 plans serviced by Confidential and multiple applications.
• Leverage Robotic Process Automation solution using Infosys NIA tool in various Insurance applications where Artificial Intelligence systems reduce manual intervention.
• Update status of test progress in the scrum meetings.
• Analyze the code to understand and identify the cause of a defect and report findings to the developer to help in resolution.
• Analyze the scope for automation and trigger automation scripts already in place.
• Provide QA sign-off for production implementation and post implementation check-out. Environments and Tools: Windows OS family, IBM RQM, Clear Quest, RTC, CA Rally, MS SQL Server and Selenium.

QA Analyst

Confidential

Responsibilities:

• Involved in Functional and Regression testing of various modules of Life and Health Insurance work stations for products handled by the company.
• Worked on processes of Policy Quoting, Underwriting, Binding and Issuance and Claims using Navigator and Policy Administration system.
• Involved in testing of web based policy administration systems and applications for policy issuing and servicing.
• Involved in testing of legacy systems which are mainframe applications for policy issuing, servicing and maintenance for Health Insurance products.
• Responsible for individually transitioning the Health Insurance products’ testing from client and driving the project at offshore location.
• Involved in requirement analysis and review for understanding the business needs, detecting possible gaps and raising queries.
• Test planning which includes test scenario and test case design, preparing executable test scripts and test data set up.
• Test execution and defect management for various modules. Drive the defect triage meetings to work on and get the defects to closure.
• Monitor and track the progress of the team to complete all deliverables on time.
• Actively interact with Client and other stakeholders to report, analyze and clarify issues.
• Document learnings from the project and share them on knowledge portals. Seek information and leverage the knowledge gained.
• Impart cross-functional knowledge transfer sessions within the team to enable them to handle different modules.

Environment: Windows OS family, HP ALM, Silk Central, Navigator, and MS SQL Server.

Test Engineer

Confidential

Responsibilities:

• Worked on Functional and ETL testing of various modules of Commercial Insurance applications.
• Performed functional testing and regression testing for Policy lifecycle starting from Quote and Accept - Adjustments - Renewals - Cancellations using Acturis policy management system.
• Worked on testing of Underwriting Rules, Policy Documents and Letters testing, Pricing testing for Commercial Insurance products - Property, Vehicle, Tradesman/Professional.
• Worked on testing of Acturis system’s Web Service calls using XML Request and Response to validate the data populated in different fields during Policy management.
• Worked on Windows Task Scheduler for scheduling and monitoring jobs to pull data from database of front-end applications to intermediary database.
• Worked on Statistical Analysis System (SAS) which is an ETL tool to extract data from source system (intermediary database), transform the source data with transformation logic to make it compatible with target system and load the transformed data to target system.
• Worked on Microsoft SQL for querying the database to verify transformation of data in the ETL process.
• Worked on AS/400 target system - IS2000, to validate the insurance policy details.
• Worked on generating extracts from AS/400 system and loading them to Acturis policy management system through SAS Integration layer.
• Involved in requirements analysis meetings with Business, Onsite Co-coordinator.
• Involved in requirement analysis, test planning, test case scripting, test data set up, execution and defect management for various modules.
• Individually handled the entire End-to-End System Integration Testing.
• Participated in onsite-offshore interactions as required to provide timely updates on project execution status.
• Involved in Quality related activities for the project like being Defect Prevention Anchor for Defect Prevention activities.
• Document learnings from the project and share them on knowledge portals, seek information and leverage the knowledge gained.

Environment: SAS, Test Director, HP ALM, AS/400, Acturis.