SUMMARY:

• 7 years of experience in the IT industry with emphasis on Quality Assurance/Software Testing with exposure of both Manual and Automated testing tools.
• Expertise in validating and testing of Client - Server and Web-Based Applications in various environments.
• Strong experience in Quality Assurance and Software Testing.
• Exposure to both Manual and Automated Testing of applications developed on Windows and UNIX platform.
• Extensively used HP ALM to plan tests, manage test assets, create and run manual and external scripts to check GUI and functional features of the AUT.
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Extensive knowledge of SDLC methodologies.
• Performed HIPAA Analysis and Testing.
• Strong knowledge of HIPAA-ready claims and plan administration.
• Expertise in Oracle table data manipulation using SQL queries and UNIX commands/UNIX scripts.
• Extensive knowledge of database management systems such as SQL and PL/SQL querying tools.
• Strong Knowledge in Healthcare EDI transactions (837, 835, 820, 834, 277, 997, 999) and EDI testing process.
• Experienced in automating regression suite using QTP/UFT, descriptive programming & VBScript.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Hands on experience in writing SQL queries and executing procedures to perform back end testing for the expected results.
• Expert in retrieving database information writing SQL Queries and transforming data to information as needed.
• Created and added tables to the SQL database when required.
• Performed Sanity, smoke testing as well as manually performed User Acceptance Testing (UAT).
• Experience using testing tools such as Quality Center ALM, Quick Test Pro and SOAP UI.
• Performed an End to End web services testing and XML validation using the SOAP
• Experience in Black Box, Positive, Negative, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.
• Experienced in Regression and Functional Testing.
• Expertise in Bug tracking using bug-reporting tools such as Test Director and Quality center.
• Expertise in writing SQL Queries using SQL Server and DB2 in validating data into Data Warehouse/ETL applications.
• Created updated and maintained Test Matrix and Traceability Matrix and involved in Gap Analysis.
• Used Online Monitors and Graphs to analyze the results.
• Experienced in conducting Performance testing, Stress testing, Load testing.
• Used Quality Center for Bugs reporting and communicating to developers, product support and test team members.
• Ability to quickly understand and interpret business requirements.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Excellent in communication, presentation, and interpersonal skills. Good team player with the ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro, QC Alm, Load Runner, Selenium IDE

Bug Reporting Tools: Test Director, Quality Center/Alm,Jira

RDBMS: MS SQL Server, Oracle, MS Access, DB2, Toad

Languages: HTML, Visual Basic, SQL, PL/SQL, .Net

Operating Systems: Windows, Red Hat Linux, SolarisUNIX

Servers: IIS, Apache, Web sphere, web server, ATG

Other Tools: MS (Word, Excel, Power point, Outlook Visio, Project), SharePoint, FACETS

Web Browser: Internet Explorer, Netscape Navigator, Mozilla Firefox

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

Quality Analyst

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan.
• Performed Manual Testing for the EDI transactions.
• Conducted GAP analysis and filling gap according to the format set by HIPAA.
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Elicit requirement to be able to generate the tools and info needed to process the ICD-10.
• Work on coordination of benefits (COB) in a claim processing.
• Developed Test Script for Functionality, Security, and Regression testing.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Performed GAP analysis for HIPAA 4010 to 5010.
• Wrote Test scenarios and test cases for testing the migration of EDI4010 to 5010 and the processing of member enrollment and benefits, (834) batch jobs corresponding to the claims (837).
• Perform troubleshooting and resolve errors in 834 and 820 transactions for health insurance exchanges.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 835, 837.
• Executed and validated data mapping for Claims via EDI into RDC through Oracle PL/SQL.
• Assisted in working in establishing EDI system security by suggesting the solution and getting the solution implemented
• Processed EDI 834 with various scenarios and validate the related tables from database using SQL query.
• Hands on experience in working on designing and reviewing the EDI system applications.
• Perform compliance testing on 834 and 820 EDI transactions
• Application of EDI 834 transactions in reinstating members, new enrollment, and terminating member enrollment
• Tested all HIPAA transactions for HIPAA 5010 and validate the database.
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers for professionals.
• Perform Root Cause Analysis.
• Tested the HIPPA EDI 834, 835, 837 transactions according to test scenarios and verify the data on different modules.
• Perform middleware testing between Front- end application and MIS (Members information system) database using SOAP UI.
• Responsible for continuous process improvement of the reconciliation process
• Transforming Analyst Notes in Preparation for outreach team to contact consumer
• Accessed Health Insurance Casework system for Membership coverage 834 & 820Enrollment reconciliation process
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 834,835 transactions.
• 834 Membership enrollment data mapping with the use of workbook Performed Back-End Testing to check database integrity by writing SQL queries.
• Set claim processing data for different Facets Modules.
• Tested HIPAA regulations in Facets HIPAA privacy module.
• Wrote test cases in HP ALM derived from the Design documents and generated a Traceability Matrix for testing purposes.
• Created Traceability Matrix to ensure implementation of all functionalities, identify all test conditions and test data needs.
• ICD 9- ICD-10 Conversion Analysis - Worked in the analysis of the ICD 9 - ICD-10 codes.
• Uploaded the diagnosis codes, procedure codes to the related tables in test environment to verify the changes related to ICD9 - ICD-10 changes.
• Tested the configuration of Claims, Enrollment and Customer Service Sub-Systems in Facets.
• Experience with Trizetto Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound
• Validated member’s benefits against the benefits matrix.
• Validated SOAP and REST services using SOAP UI pro.
• Good experience as SOAP web services tester.
• Analyzed and tested data on claims manually and writing queries on DB database for validating data.
• Worked within a team to resolve Relational Database problems.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Investigated software bugs and interacted with developers to resolve technical issues using HP ALM.
• 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.
• Used ALM to record documenting information useful in debugging process, evaluating test data.
• Created Automation Scripts for all online interfaces using Quick Test Professional (QTP)/UFT Wrote test cases, implemented ran and added versions and iterations using test manager for positive, negative and end-end test cases.
• Experienced in creating generic, reusable test functions and Automation scripts using VBScript in QTP to fully automate the application functionality.
• Worked with Large DB2 and Oracle, SQL Server databases doing loading, validation and manipulation of data
• Prepared and maintained the Test Matrix, Requirements Traceability Matrix.
• Participated in release meetings and also participate in Retrospective session.
• Extensively worked on any requirement upgrade and/or change request while doing UAT.
• Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end-to-end process.
• Participated in weekly status meeting with Development and Management Teams.

Environment: Agile/Waterfall, MS Office Tools, Windows XP, ALM, Facets, Java, DB2, SOAPUI, MS SQL, UNIX.

Confidential, Dublin, OH

QA Tester

Responsibilities:

• Analyzed and defined testable requirements created and implemented test plans.
• Developed Test Cases/Conditions for manual and Automation testing of the above Applications and Reports.
• Gathered requirements from the users and analyzed the requirements.
• Involved in performing functional, application, integration, system, and regression Testing.
• Developed the Test Data for different Groups
• 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.
• Communicated with development team to ensure testing issues are resolved
• 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.
• 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.
• Prepared and executed different SQL Queries against the Oracle.
• Involved in Up-gradation of HIPAA X12 4010 transactions to HIPAA X12 5010 and ICD 9 CM to ICD 10.
• Tested the HIPPA EDI 834, 270/271, 837/835 transactions according to test scenarios and verify the data on different modules.
• Experiences working in ANSI x12 837-835 EDI Transaction.
• Verified and Validated the Rates Calculations and Rate Renewal Calculations for different Products and benefits by Preparing and executing different SQL Scripts.
• Validate EDI Claim Process according to HIPAA compliance.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Performed tests for EDI transactions (834, 837, 835, 270, 271,276 and 277) in various phases of implementations.
• Involved in Up-gradation of ICD-9-CM to ICD-10
• Monitoring, maintenance, and troubleshooting to ensure accurate EDI transmissions, including working with trading partners and personnel to determine root cause, and other projects related to EDI development as defined by customers.
• Modified the 834 file and then checked if the eligibility enrollment is properly loaded onto Facets.
• Extensively involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules.
• Involved in Testing Web Services using SOAP UI.
• Tested and delivered Inbound/Outbound Facets interfaces
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Maintained Test Matrix and Requirements Traceability Matrix. Performed Gap Analysis on the same
• Evaluated clinical laboratory test results, patient demographics, pharmacy information, radiology reports and images, pathology reports, hospital admission/discharge/transfer dates, ICD 9 codes, discharge summaries, and progress notes.
• Led and managed the User Acceptance Testing (UAT) for the implementation of Facets Extended Enterprise administrative system with emphasis on ensuring that the HIPAA regulations are met across all the modules.
• Performed Functional, Regression and Usability Testing.
• Performed Compatibility Testing against different browsers and versions.
• Used HP ALM for reporting defects.
• Tested the SSRS reports to verify the data is accurate.
• Used SOAP over HTTP as the transportation protocol to create a test SOAP request very quickly.
• Used HP ALM to enter and Report defects for Rate Quote Remediation
• Extensively involved in Back-End Testing, database table manipulations of relational database systems by writing complex SQL queries manually.
• Conducted navigational testing, functional testing.
• Queried the DB2 database in Mainframes for the proper validating the claims into the Database.
• Prepared Application Testing Metrics Reports using MS Project.
• Prepared and submit the weekly test status reports to QA Lead and Manager
• Followed and Implemented the SDLC to improve the Testing Process and Efforts.
• Coordinated with the Business users, BA’s and Testers in order to perform UAT Testing.
• Responsible for QA Sign Off for the above applications using Care first QA Sign Off Forms
• Interacted with Business users and BA’s regarding the Requirement Issues.
• Involved in Weekly Testing Status meetings with Testing Team and Weekly Rate Quote Task force meeting with Business Users and Developers.
• Maintained Test Matrix and Requirements Traceability Matrix. Performed Gap Analysis on the same.
• Utilized HP ALM for test plan creation and execution.
• Involved in Functional, Black Box, Usability and Regression Testing for UAT (User Acceptance Testing) using QTP.
• Developed and executed automated scripts using QTP/UFT for Functional and Regression testing.
• Analyzed and logged defects in ALM and interacted with the developers to resolve technical issues.
• Used Pivot tables, formulas and relational tools to show the relation between the tables in Excel for the upload purposes.
• Environment: HIPPA, EDI, Facets, Oracle, SQL, Mainframe, DB2, ALM, MS Office, MS-Visio.

Confidential, Louisville, KY

QA ANALYST

Responsibilities:

• Analyzed system requirements and developed detailed Test Plan.
• Performed Manual Testing as well as Automation Testing for the EDI transactions.
• Conducted GAP analysis and filling gap according to the format set by HIPAA.
• Developed Test Script for Functionality, Security, and Regression testing.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Involved in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing
• Performed Back-End Testing to check database integrity by writing SQL queries.
• Set claim processing data for different Facets Module.
• Tested HIPAA regulations in Facets HIPAA privacy module.
• Tested the claims processing with EDI transactions (270, 271, 835, and 837) in HIPPA and HL7 Environment.
• Involved in creating documents and diagrams for Membership Enrollment according to the HIPAA 834 Compliance Standards for Membership Enrollment.
• Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 834, 276/277, 270/271, 837/835.
• Enrolled members through online screens and 834 Transactions to Facets.
• Modified the 834 file and then checked if the eligibility enrollment is properly loaded onto Facets.
• Wrote complex SQL queries in TOAD (Relational DB) to perform Back-End testing. Participated in data analysis for verification purposes using SQL queries, views and procedures
• Worked on Data mapping, logical data modeling and used SQL queries to filter data within the Oracle database tables.
• Wrote test cases in Quality Center derived from the Design documents and generated a Traceability Matrix for testing purposes.
• Executed Functional and Regression testing using application HP QTP
• Good knowledge in data driven web services testing via soap using the source-testing tool SoapUI Pro.
• Created Traceability Matrix to ensure implementation of all functionalities, identify all test conditions and test data needs.
• Used HP Quality Center to record documenting information useful in debugging process, evaluating test data.
• Designed, developed and implemented a concurrent processing scheme for checkpointing and restart/recovery. This involved the partitioning of certain application dependent Mainframe DB2 tables.
• Prepared and maintained the Test Matrix, Requirements Traceability Matrix.
• Participated in release meetings and also participate in Retrospective session.
• Extensively worked on any requirement upgrade and/or change request while doing UAT.
• Worked closely with development team to ensure the application performance and stability and also ensure the application completes the whole end to end process.
• Participated in weekly status meeting with Development and Management Teams.

Environment: Oracle, Windows 2000/XP/VISTA/7, HIPAA, FACETS, IIS, DB2, Quality Center, JAVA, HP QTP and MS-Suit.

Confidential, Pittsburgh PA

QA Analyst

Responsibilities:

• Worked on migrating ICD-10 codes and mapping ICD-9 and ICD-10 codes.
• Involved in Up-gradation of HIPAA X12 4010 transactions to HIPAA X12 5010 and ICD-9-CM to ICD-10.
• Designed, updated and reviewed the Test Cases for members’ information, Providers according to HIPAA.
• Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Thoroughly analyzed the business requirement documents and create test cases according to it.
• Implemented Standardized and Unified process throughout the Software Development Life Cycle (SDLC).
• Actively participated in all the phases of the testing Life cycle (Planning, Designing, Development and Reporting and Results).
• Developed standardized FACETS testing, implementation and QA processes, and performed Integration testing, system testing.
• Processed claims in Facets and verified 835X12's are generated and sent to Provider.
• Involved in testing the EDI transactions 834, 837, 835. 270/271 & 276/277 conversions to Facets.
• Extensively used SQL in order to retrieve data from the databases by writing Stored Procedures, views, triggers etc.
• Data was retrieved from SAS data warehouse and processed using SAS
• Developed Test Script for Functionality, Security, and Regression testing.
• Performed SOA / Web Service testing using Soap UI.
• Created Data for XML Requests in Soap UI.
• Maintained tables (SAS formats) used by production jobs; validated accuracy of data
• Used Complex SQL queries using joins and sub-queries to test the reports generated by the different modules as a part of back-end testing.
• Maintained strong relationships with developers which helped in better execution of test plan.
• Developed and executed SQL queries to verify the proper insertion, deletion and updates into the data Warehouse supporting tables.
• Developed and maintained the test scripts, test data and test cases.
• Involved with other team members to set up testing tools, implementation and other testing environments.
• Performed various types of testing, such as functional, regression, user acceptance testing manually.
• Created the test scripts for both positive and negative testing.
• Defect Identification and created defect tracking reports till the close of the defect.
• Preparing Test Metrics using Quality Center.
• Attended various Functional Walkthroughs and writing high level testing scenarios.
• Designed, updated and reviewed the Test Cases for member’sinformation, Providers according to HIPAA.
• Developed and maintained the test scripts, test data and test cases.
• Worked with relational databases, and developed PL/SQL queries to interact with Databases.
• Performed legacy DB2 Testing to cross check new database entity relations
• Performed Manual Testing using Quality Center (QC) and User Acceptance Testing (UAT)
• Utilized JIRA to Track, Report, and Manage defects and bugs throughout the test cycle and attended Defect Status Meetings during testing cycle.
• Generated and recorded test scripts that provided extensive application coverage using QTP/UFT.
• Prepared Test Scripts and test Plan for automated testing using QTP
• Involved with other team members to set up testing tools, implementation and other testing environments.
• Performed various types of testing, such as functional, regression, user acceptance testing manually.
• Created the test scripts for both positive and negative testing.
• Defect Identification and created defect tracking reports till the close of the defect.
• Preparing Test Metrics using Quality Center.
• Attended various Functional Walkthroughs and writing high level testing scenarios.

Environment: HTML, Waterfall, SQL Server, Quality Center, QTP, MS Excel, Windows XP, UNIX.

Confidential, Chicago, IL

QA Tester

Responsiblities

• Wrote test cases manually and using automation tools to validate the functional and non-functional part of the application.
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010; 837, 835, 270/271, 273, 278, and others.
• Performed configuration Testing, end to end testing, regression testing.
• Authorized Test Cases for HIPAA EDI transactions specifically 837.
• Tested HIPAA Transactions and code sets standards.
• Worked with FACETS Team for HIPAA Claims Validation and Verification Process (Pre-Adjudication).
• Logged the errors, reported defects, determined repair priorities, did regression testing and closed bugs using Quality Centre.
• Tested HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
• Tested 837/ 835, 270/271, 273, 276/277,278, transactions with File Aid.
• Documented XML file processing use case as well as identified XML file level processing errors.
• Extensively worked on different kinds of joins and operators to fetch data from multiple tables.
• Conducted data integrated and data validation.
• Involved in testing HIPAA Transactions &Code Sets Standards like (820- Premium Payment for enrolled health plan members, 834(X12) - Enrollment /Dis-enrollment to a health plan, 835, 837 ...etc.)
• Perform Header and Body Testing as a part of Regression Test using SOAP UI
• Functional Testing of Member Portal UI for Accident forms and Admin screen which are developed on Grails to handle Human intervention workflow process.
• Planning for and reviewing the Test cases for Functionality, Security, Performance, Database and User Acceptance testing.
• Checked the data flow from front end to backend and used SQL queries to extract the data from database.
• Used Quality Center for Requirement Traceability.
• Used HP Quality Center as the test repository and used it for executing the test cases and scripts and logging and generating various reports and graphs for further analysis.
• Used HP Quality Center for bug tracking and reporting, also followed up with the development team to verify bug fixes and update bug status.
• Performed Functionality and GUI testing using QTP.
• Identified Test cases to perform Regression Testing.
• Set claim processing data for different FACETS Module.
• Involved in maintaining the test matrix and RTM.
• Participated in QA meetings and defect tracking meetings.

Environment: Oracle, Windows 2000/XP, Quality Center, and QTP.