We provide IT Staff Augmentation Services!

Sr. Qa Analyst Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • 9 years of experience as a Quality Assurance Analyst with extensive knowledge and experience across the project life cycle in Systems Development Life Cycle (SDLC) in the fields of Insurance, HealthCare and Finance.
  • Implemented and experienced in various QA methodologies.
  • Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC)
  • Performed planning and development of Test Plans, Test Strategies, Test Cases and Test Scenario to meet product’s business requirements.
  • Proficient in Defect Reporting and Tracking throughout the entire defect life cycle.
  • Possess strong problem - solving skills with the ability to adapt to a new environment and meet deadlines.
  • Expertise in Testing of Client/Server and Web based applications.
  • Skilled in bug reporting and tracking using Test Director, HP HP ALM.
  • Strong in IT research, software analysis and design skills.
  • Extensive experience in Backend Testing on distributed databases using SQL queries.
  • Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, configuration Testing, User Acceptance Testing.
  • Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
  • Knowledge of Medicaid and Medicare Services.
  • Knowledge of health information and health care services regulatory environment including HIPAA, Medicaid/Medicare, ICD -9 and ICD-10
  • Worked with ETL (Informatica) developers for creating real-time data interfaces and DB extracts (ETL Design).
  • Worked with relational databases, and developed PL/SQL queries to interact with Databases.
  • Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
  • Documented the dimensional models of ETL system.
  • Involved in design of the data warehouse using Erwin, created Informatica source and target definitions and mappings.
  • Worked with solutions/delivery teams to implement data quality processes during acquisition, ETL, and delivery stages for Business Intelligence solutions and changes to Data Warehouses.
  • Extensive expertise in SQL for Back End Testing.

TECHNICAL SKILLS

  • Methodologies: SDLC, RUP, Agile, Waterfall
  • Platforms: Windows, Mainframe
  • Testing tools: WinRunner, LoadRunner, HP ALM, Quick Test Professional
  • Change Management Tools: Rational ClearQuest, TestDirector, HP Mercury Quality
  • Office Tools: MS Project, MS Office, MS Visio
  • Database: MS SQL Server, MS Access, Oracle, Toad

PROFESSIONAL EXPERIENCE

Confidential

Sr. QA Analyst

Responsibilities:

  • Analyzed and identified the requirements from Group Class Plan (GCP) document for member and subscriber demographic information and the insurance plans.
  • Responsible for writing the Test Cases and Test Scenarios based on the Business Requirement Document (BRD) and technical Specifications and loaded in HP Quality Center.
  • Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using HP Quality Center.
  • Processed claims in FACETS and verified 835X12's are generated and sent to Provider. Created test members through Express Claim Test Pro application for testing purposes.
  • Extensively used Express Claim Test Pro application to modify existing claims data to suit the testing scenarios for the new markets.
  • Performed detailed testing for Authorization of claims, Benefits, Claims Payment, Pricing, Member Accumulator and System Readiness Review testing.
  • Processed 837P, 837I & 837D transactions, verified those 837 transactions converted correctly to XML file format & XC keyword file format and verified the claims data loaded to FACETS for further processing.
  • Retrieved claims data from different test environments by executing SQL statements in TOAD
  • Performed end-to-end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
  • Performed Member Accumulator check based on the respective claims and member plans.
  • Provided regular status updates to Team Lead on high priority issues and Testing Progress.
  • Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.

Confidential, Indianapolis, IN

Sr. QA Tester

Responsibilities:

  • Analyzed and identified the requirements from Group Class Plan (GCP) document for member and subscriber demographic information and the insurance plans.
  • Responsible for writing the Test Cases and Test Scenarios based on the Business Requirement Document (BRD) and technical Specifications and loaded in HP Quality Center.
  • Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using HP Quality Center.
  • Identified issues with the testing tools and the environment configurability and reported to the Lead.
  • Analyze change requirements for Benefit, Providers, Contracts and Claims processing modules configuration in FACETS system for Medicaid and Medicare Advantage for AL, FL, GA, IL (ICP &MMAI), MD, NC, SC, PA and TN plans in different environment UAT 4, ITE and UAT 3
  • Performed detailed testing for Authorization of claims, Benefits, Claims Payment, Pricing, Member Accumulator and System Readiness Review testing.
  • Retrieved claims data from different test environments by executing SQL statements in TOAD
  • Performed end-to-end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
  • Performed Member Accumulator check based on the respective claims and member plans.
  • Provided regular status updates to Team Lead on high priority issues and Testing Progress.
  • Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Translated Business processes into Informatica Mappings for building Data marts.

Confidential, GA

QA Tester

Responsibilities:

  • Analyzed the business requirements, functional specification and use case documents.
  • Developed test plans, test cases using requirements, use cases, wire frames and design documents.
  • Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
  • Performed and coordinated User Acceptance Testing (UAT) with the appropriate group to ensure the correct business logic.
  • Assisted the business partner in preparing UAT plan/scripts and assured project manager has taken steps for alignment of Operational Quality Checklist.
  • Performed Manual Testing prior to automate testing on the application.
  • Profiled the data using Informatica data quality (IDQ)
  • Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor
  • Responsible to work on Medicaid Management Information System which includes two divisions: HIPAA compliance and Maintenance units division and Claim processing division.
  • Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
  • Involved in testing EDIs according to code set X12 835 Claim Payment & Remittance Advice Claims processing and 837 Claim transactions with HP ALM
  • Tested the ETL process that loaded the data into target database after performing all the transformations as per the business requirements
  • Tested all the ETL processes built for fetching various source data into Data warehouse
  • Performed data validations on the loaded data by comparing against source data through complex SQL queries
  • Written complex SQL queries for validating the data against different kinds of reports generated by Cognos
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
  • Validated Reports generated by Cognos application by creating SQL scripts.
  • Outlined the scope for and wrote test plans for the UAT testing of appropriate front end modules of the application
  • Executed UAT testing for appropriate modules
  • Logged the UAT defects in Clear Quest based on the defect type.
  • Customized Mercury HP ALM to suit the requirements of testing effort
  • Monitored the Defect Tracking Process and generated customized graphs and reports for the client using HP ALM.

Confidential, Blue Bell, PA

QA Tester

Responsibilities:

  • Participated in developing test plans templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
  • Involved in the development of Test Plans and Test Cases and coordinated the tests with the QA team to verify implementation of new features and enhancements.
  • Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations involved in FACETS Implementation, involved end to end analysis of FACETS Billing, Claim Processing and Subscriber/Member module.
  • Set claim processing data for different FACETS Module.
  • Design, analyze and performed Integration and wrote System requirements on different leading health care software’s such as FACETS.
  • Writing Test Plans/Test Scenarios/Test Cases/Test Matrix.
  • Followed the Agile methodology for the entire SDLC
  • Involved in writing and executing test cases using HP ALM based on the requirements
  • Performed Back-End testing using SQL Query.
  • Wrote SQL queries to check for data validation.
  • Created and executed SQL statements manually to perform Backend Testing that ensured data consistency on the Front-end.
  • Used SQL to test various reports and ETL load jobs in development, QA and production environment
  • Developed design Specification Writing Test report s and documenting Test results

We'd love your feedback!