SUMMARY:

• 7 years of experience in Quality Assurance and Software Testing in various industries
• Experience in requirement analysis, creating traceability matrix, test planning, creating test data and implementation of test suite (test plan, test scripts and test cases)
• Extensive experience in testing Client/Server and Web - based Applications
• Excellent manual testing ability with strong skills on QC
• Strong Hands on the writing SQL queries to get the data from the database
• Expertise in Automated testing tools such as Win Runner and QTP
• Expertise in Bug reporting tools such as Test Director and Quality Center
• Analyzed test results to ensure existing functionality and recommend corrective action where necessary
• Involved in 4010 and 5010 transactions along with ICD 9 and ICD 10 codes, and validated the HIPAA Syntax
• Strong Knowledge of all aspects of the Agile methodology of SDLC
• Proficient in manual and automated testing of applications on Windows and Unix environment
• Extensive knowledge in Running FACETS batch jobs and simultaneously checking the functionality of FACETS
• Extensive knowledge in FACETS claim Processing, Billing and membership data testing
• Experience with TriZettos Facets Application Groups: Claims Processing, Guided Benefit
• Configuration, Medical Plan, Provider, Subscriber/Member, Utilization Management.
• Very good experience in Back-End Testing using SQL on UNIX and Windows platform to validate the consistency of data
• Experienced working with 5010 transactions changes analysis, design and migration strategy
• Have good knowledge of HIPPA 4010 /5010 versions
• Profound understanding of insurance policies like HMO and PPO and proven experience with HIPPA 4010 EDI transaction codes such as 270/271(inquire/response health care benefits),276/277(Claim status), 834(Benefit enrollment), 835(Payment/remittance advice), 837(Health care claim)
• Maintained Requirement Traceability Matrix and Test summery report
• Strong Knowledge on MS Office suite, MS Visio, MS Project, and MS Access
• Extensive knowledge in testing Enterprise Data Warehouse (EDW) and Reports developed by reporting tools.
• Understanding of HIPAA Standards and Compliance issues, HIPAA Privacy policy, opt in/opt out policy.
• Expertise in testing of Enterprise Data Warehouse and Healthcare applications
• Experienced in DW projects ETL testing against DW testing with Informatica and data stage tools.
• Good working knowledge of major Operating Systems such as Windows and UNIX
• Hands on experience with SQL in writing joins, triggers, tables, user defined functions, views, indexes, and relational database models and data integrity.
• Extensive knowledge of all aspects of the Software Development Life Cycle
• Excellent communication and writing skills with the ability to adapt to new and dynamic environments
• Good team leader, Player and can work alone with minimal or no supervision
• Ability to multi-task, prioritize and work with time constraints while paying attention to details
• Good problem-solving, judgment, and decision-making skill
• Working knowledge of major operating systems and tested applications developed in wide variety of environments viz., Windows XP/7

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro (QTP) and Win Runner

Bug Tracking Tools: Quality Center and Test Director

Operating Systems: Windows XP/7, MS DOS, UNIX

Reporting Tools: Toad, Rational Clear Quest

Languages: TSL, T-SQL, HTML, VBScript.

RDBMS: SQL Server 2000/2005, DB2, MS Access, Oracle, TERADATA

Utilities/Application: MS Office Suite 03/07, MS Visio MS Project 03/07, Adobe Acrobat Reader/Writer, Adobe Photoshop

PROFESSIONAL EXPERIENCE:

Confidential, VA Beach, VA

QA Analyst

Responsibilities:

• Directly involved in download data from production environment to different test environment, defined in Oracle Database.
• Performed Data Analysis to make sure its correctness and completeness in test environment.
• Worked on new business as well as expansion in business areas in different states including Louisiana (New Business) Washington (New Business), Texas (TX-JP expansion), NY (NY Homeless, NY Health Plus expansion).
• Participated in weekly meetings to keep up to date with issues and business changing elements.
• Conducted regular meetings with the people directly responsible for the business in each State.
• Executed Test Cases Manually, once the application is stable and documented the successful or unsuccessful completion of each test case in HP ALM for End-to-End Scenario based testing.
• Created Test Plans, SQL scripts for verifying the ETL process as part of the Enterprise Data Warehouse (EDW).
• Involved in testing Web services and XML using SOAP UI. Verified the response received by updating the request XML.
• Performed the role of QA Analyst as a core role and also took a lead in resolving problem logs.
• Closely worked with SME’s Business Analyst, System Analyst on every stage of application.
• Used QTP for automated testing, modified VB Scripts to meet requirement.
• Used Claims Test Pro for processing claims.
• Analysis of inbound and outbound interfaces and extensions to Trizetto FACETS Claims Processing system.
• Prepared Test Strategy, test plans and Test Cases, Scenarios as per requirements and executed as and when needed.
• Validated Medical, Hospital and Dental claims in FACETS, verified Codes with description and requirements, verified adjudication process of Claims of FACETS.
• Extensively used Claims processing, Provider, Subscriber/Member, Utilization Management and NetworX Applications in FACETS, verified Co-pays and
• Acted as a technical lead on BPT Component scripts creation and mentored the team on BPT/Automated Testing using Quality Center and Quick Test Pro
• Worked on SQL using Oracle-TOAD to create and run SQL.
• Conducted Functional, Positive/Negative Testing, Integration Testing and System Testing using JIRA for different modules of application.
• Extensively involved in Back-End Testing, database table manipulations of relational database systems by writing complex SQL queries manually.
• Maintained Test Matrix and Requirements Traceability Matrix. Performed Gap Analysis on the same.
• Performed ETL data validation using SSIS ETL environments and BI report validation using SSRSBI environments.
• Worked on End-to-End data validation for ETL & BI systems,
• Involved in Functional, Black Box, Usability and Regression Testing for UAT (User Acceptance Testing) using QTP.
• Responsible for running ETL jobs in batch server and validating mapping rules.
• Analyzed and logged defects in ALM and interacted with the developers to resolve technical issues.
• Designed data in SQL SSIS and reports in SSRS.
• Used HP ALM (defects management tool) for defects/bugs tracking.

Environment: Trizetto FACETS, Claim Test Pro, HP, Teradata, SSRS, Oracle, SQL Server, HP ALM, QTP, Mainframe, OS/390, TSO/ISPF, JCL, COBOL, DB2, SPUFI, MS Office, Windows.

Confidential, Buffalo, NY

QA Tester

Responsibilities:

• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Involved in HIPPA Complaint X12N837 Transaction testing.
• Developed and implemented EDI applications to process Health Care transactions as per the HIPAA implementation
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice
• Written multiple Test Cases (System, Integration) for multiple transactions include 837I, 837P, 835, (both inbound and outbound) transactions
• Worked on Claims Test Pro of Facets for project tracking and for reporting progress.
• Analysis and Design of the Trizetto FACETS Data Model to ensure optimal system performance and tuning.
• Used SSRS for generating reports regarding the data and to verify the integrity of the data.
• Handle the tasks of explaining UAT scope, criteria and entry/exit strategy to less train professional.
• Prepared test matrices based through defect status in ALM.
• Involve in testing of FACETS Implementation, involve in end-to-end testing of FACETS Claims Processing module, Membership and benefits.
• Developed Automated Test Scripts for functionality testing using HP Quick Test Pro
• Interfaces and Extensions, Load and extraction programs involving HIPPA 837 and proprietary format files and Reports development
• Logged defects in ALM and interacted with the developers to resolve technical issues.
• Worked on Unix Platform and experienced in back end testing by executing SQL Queries.
• Worked on Data mapping, logical data modeling and used SQL queries to filter data within the Oracle database tables.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• UAT process by reviewing test requirements, assessing business impacts of systems development, coordinating testing teams and developing and reviewing test scripts to ensure users conduct thorough and careful testing.
• Performing Backend Testing extensively by writing validation queries on DB database.
• Analyzed and tested data on claims manually and writing queries on DB database for validating data.
• Performed Database testing (Data Warehouse/ETL) on ETL applications validating the data in Sources/Targets using Data Stage Client Tools.
• Used DB2 interfaces to connect to the mainframes and databases.
• Wrote SQL queries for data Validation and outstanding knowledge of preparing simple/ complex queries.
• Prepared Test Cases for the mappings developed through the ETL Informatica tool and executed those Test Cases.
• Worked with the Developers, Infrastructure teams to resolve the issues.

Environment: Configuration and Testing Management (In house Tool), Teradata, Facets, Interactive SQL, MS Word, MS Project, MS Excel, HP ALM, QTP.

Confidential, Dallas, TX

QA ANALYST

Responsibilities:

• Involved in developing detail Test Plans for different benefit packages according to Business requirements documentation.
• Involved in discussion with the Subject Matter Experts (SME) during creation of test plans and updating of business requirements.
• Acting as liaison between end user and Facets for user problems, outstanding issues, training needs and new software releases
• Follow up management on errors made by Data Entry associates.
• Assisted in logging defects with TFS, correcting defects and creating builds for remedial testing
• Developed complex queries by joining different Dimensional tables to Fact tables and retrieved the data From EDM and validated the data against EDW.
• Tested various operations in the claims Pro test processing (Adjustments, Claims, and Overpayments, underpayments, COB).
• Monitored workflow of the Resolution/Adjustment Unit, delegate tasks accordingly, and ensure that quality, quantity, and efficiency standards are met or exceeded.
• Worked under HIPAA compliance standards.
• Used JIRA to perform test management activities.
• Performed Front-End Testing, Functionality Testing, and Data Driven Testing using QTP.
• Used Ramp up and Ramp Down options in Load Runner to simulate real time scenarios.
• Developed test automation scripts using Quick Test Pro.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL statements on the Database
• Wrote SQL queries on TOAD and performed backend testing on oracle.
• Reported defects in TFS found during testing to the development team.
• Maintained Test Matrix which gives overview of the Testing Effort.
• Enhanced the Test Scripts by adding Check Points in QTP.
• Used Quality Center as a Bug Reporting Tool for entering the Bug
• Reviewed existing QTP Test Scripts, and modified as required for new changes.
• Validated the Data in the Enterprise Data Warehouse (EDW) using SQL queries
• Tested Claims intake/Logged claims/Failed claims data from Pulse tables to Oracle Financials.
• Monitoring the defect life cycle, generating customized graphs and reports for the client, using Quality Center.
• Used Quality Center to record documenting information useful in debugging process, evaluating test data.
• Used Quality Center for reporting and tracking bug and generating reports.

Environment: FACETS, Java, Windows, Oracle, Quick Test Pro, Teradata, Quality Center.

Confidential, Schenectady, NY

QA Analyst

Responsibilities:

• Participated in setting up testing environment.
• Reviewed Business requirement Documents and functional requirements.
• Involved in preparing Test Cases based on business requirements.
• Performed Back-end database testing by executing advanced SQL Queries to make sure that Enterprise Data Warehouse (EDW) is working fine.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Extensively worked all Regions Inbound and Outbound Interfaces.
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Quality Center.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
• Queried the DB2 database in Mainframes for the proper validating the claims into the Database.
• Perform functional, exception and scenario testing.
• Used descriptive programming in scripting dynamic objects and reusable actions in defining scenario flows in Quick Test Professional (QTP).
• Used JIRA for reporting and tracking bug and generating reports.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Performed User Acceptance Testing manually.
• Worked and coordinated in UAT preparation activities, documentation of UAT Test Scenarios, Test Cases and Test Scripts; defining and preparation of Test Data.
• Developed and executed automated scripts using QTP/UFT for Functional and Regression testing.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using Quality Center.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Extensive knowledge of Test Matrix, Traceability Matrix.
• Quality Center was used to create the test plan, store test cases and run the test sets.
• Provides feedback concerning completeness and accuracy of AUT.
• Used Quality Center to analyze, track and report defects.
• Worked within a team to resolve Relational Database problems.
• Worked on uploading all the Test cases to the Quality Center for the current and prior releases.
• Responsible for performing System and integration testing for release.

Environment: Windows, Facets, Oracle, SQL, Teradata, Mainframe, Quality Center, MS Office, MS-Visio, SOAP UI

Confidential, Dayton, OH

QA Analyst

Responsibilities:

• Participated in setting up test environment and creating test data.
• Tested the claims flow for both Medical and Hospital in Facets
• Was Responsible in finding the eligibility of the members and filing Claims for the States Disability Insurance benefits for both short term disability who are not eligible for the Social security benefits and for the Long term disability customers who are qualified under Social security plan for the payment of benefits as a result or injury.
• Documented changes and implemented procedures for these changes as discussed in Change Request meetings.
• Wrote SQL queries to check for data validation.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Validated DRG codes, Procedure codes, Accumulators in Facets.
• Created and executed SQL statements manually to perform Backend Testing that ensured data consistency on the Front-end.
• Validated pricing based on provider contracts using Facets benefit applications (NetworX Pricing).
• Involved in conducting Functionality, Negative/Positive, and Security testing.
• Performed extensive Regression Testing.
• Performed Functionality, Security, UAT and Regression Testing for 2 different modules of Humana web application.
• Wrote automated test scripts using QTP.
• Verified the data transformations and loaded from external data sources in Teradata, Oracle and SQL Server to the data warehouse and from the data warehouse to data mart using SSIS.
• Detected and tracked the bugs with the help of Quality Center and reported them to the developers to fix it.
• Coordinated with developers on bug fixes and defect status updates on a regular basis.
• Participated in various meetings to discuss Enhancement and Modification Requests.
• Facilitated meetings with the business and the development team to discuss all major issues faced by the testing team.

Environment: Oracle, QTP, QC, Windows, MS Office.