SUMMARY

• Senior QA Consultant with over 8 years of expertise in Software Quality Assurance Methodologies and Testing.
• Experience involves testing various software applications including Client/Server and Web based applications across multi - platform environments using automated testing tools Quality Center and QTP.
• I have been broadly involved 10X, Agile, Waterfall based Software methodology, SDLC processes, Java/Web based UI, High Performance, exploratory, load/stress, boundary, Sanity, regression, Automation, protocol, testing, deployment and support.
• Strong knowledge of Software Development Life Cycle (SDLC) as well as Testing Methodologies and the Role of QA/ EDI Specialist.
• Experience and Familiarity working with Waterfall, AgileandScrum methodologies.
• Experience includes developing HIPAA Companion Guides for 834 Enrollments, 270/271 Eligibility Inquiry/Response & 820 - Health Plan premium payments.
• Experience with Claims Processing, Guided Benefit Configuration, Medical Plan, Provider, Subscriber/Member, Utilization Management.
• Develop various test cases for testing HIPAA 837 I/P (4010 and 5010).
• Experience includes writing SQL queries, stored procedures, functions and triggers.
• Experience in all phases of SDLC including requirements analysis, detailed design, development, testing, maintenance and deployment of the application along with documentation, estimation, and scheduling and defect prevention.
• Experience testing the NASCO NPS claim system and edits in EEC.
• Strong experience with ETL Datawarehousing and Business Intelligence (BI) Testing.
• Created Validationscripts in PL/SQL tocompare Expected results versus Actual results
• Involved in UAT and End to end testing; designed, scheduled and executed test plans within the predefined timeframe coordinating with users while performing UAT.
• Experience testing the Xcelys adjudication tool.
• Experience in developing Test plans, designing Test Strategies, defining Test Cases & log defects in ALM Quality Center, developing and maintaining automated test scripts.
• Reviewed test results from the selenium test suite after nightly test runs.
• Experience with data mappings for 4010 and 5010
• Experience with EDI 835, 837I, 837P, 834, 276/277, 278, 270, 997, 999.
• Expertise in Bug Reporting, Tracking and Documentation using jira and Quality Center.
• Experience with automated test frameworks such as Selenium, Watir, Webdriver, cucumber.
• Experience in developing business based functional test scenarios. Experience in conducting Requirement Analysis.
• Extensive experience in writing and manual testing scripts for various testing. Performed Black box testing, functional testing, regression testing and data driven testing using both manual and automated testing techniques.
• Possess strong analytical, verbal and inter- personal skills along with project management and leadership qualities to handle multiple projects simultaneously.

PROFESSIONAL EXPERIENCE

Confidential, Farmington, CT

Sr.QA Analyst

Responsibilities:

• Tested web services using SOAP UI.
• Did the 4010/5010 gap analysis for all EDI transactions such as 837, 835, and 999.
• Validated SOAP Responses using different Assertions like Schema Compliance, SOAP Response, X-Path Match, Contains, Not Contains, etc in SOAP UI.
• Validated WSDL’s using SOAP UI after the member profile data is migrated from DTG systems to C-MDR.
• Expertise in using FIX Protocol API. Testing admin and application FIX messages like heartbeat, logon, logout, resend request, reject, sequence, pre-trade, trade and post-trade messages.
• Wrote complex queries in Teradata SQL assistant to analyze the data.
• Expertise in EDI transactions used in healthcare industry and good knowledge of HIPAA X12.
• Experience as an EDI analyst performing verification and validation of the EDI transactions.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Created ANSI X12 EDI 834 enrollment file to enroll new members, add members to existing coverage contracts and changed details of existing contracts.
• Wrote SQL queries and validated data.
• Created ETL source to target queries.
• Created test cases for 834 enrollments and updated the test cases based on the PCR's given.
• Used 834 files to enroll new members, change existing members and for cancelling existing members.
• Used the Web service layer operation to test the functionalities like Adding a Customer, Update customer, Enroll Customer, Identify Customer, Search Customer etc.
• Executed the inbuilt test steps for various functionalities.
• Performed smoke testing after the new builds and regression testing using the SOAP UI.
• Extensively used HP ALM for defect tracking, defect reporting, also followed up with the development team to verify defect fixes.
• Validated the data in the backend using the Teradata Studio express for the migration from DTG systems to C-MDR.
• Participated in the Daily Stand up's for the defect reviews.
• Used the HP ALM to track the progress of the project for the weekly meeting.
• Created User Acceptance Testing (UAT) Test Cases for production testing
• Developed and implemented test case mapping to requirements, Project Status reports, Issue defect matrices, UAT test plans and User Training documents.

Environment: Teradata, UNIX, HP ALM, SOAP UI, SQL, SQL Server, Oracle, Quality Center

Confidential, Raleigh, NC

Sr. QA Analyst

Responsibilities:

• Performed benefit testing for the new health plan.
• Responsible for testing IBU (Individual business units) products as Premier.
• Worked Extensively with Inbound 837 I and 837 P, 835s(Out bounds) claims processing systems.
• Use Fix Protocol to understand various message types. Read and understand the FIX logs and debug if any issues.
• Worked on 837, 835, 276 and 277 Institutional and Professional, EDI Gateway.
• Expertise in working with direct submitters, clearing houses and providers in regards to all the issues with EDI setup, claim submissions, eligibility transactions and ERA’s.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively worked with Edifecs Specbuilder to create test files, analyzed all EDI test files with 5010 implementation guides and gap analysis of EDI transactions.
• Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target.
• Responsible for testing Small groups products as community Blue, Simply blue and Large group products(Large group ASC, Large group Gold, silver and bronze and MSP gold,silver and bronze healthy blue achieve INS(Insured)) as community Blue, Simply blue and healthy blue achieve
• Coordinating with Metavance team to create test memberships and contracts in Nasco sandbox environment and update 2014 Benefit package ids(BPIDs) and Bstrings that are to be tested
• Update the group nums that are to be tested in SNDBXTBL to make sure benefits are read from Sandbox,if groups are not defined in SNDBXTBL benefits are read from Model office
• Pulling the facility & professional claims 837(P&I) from V-claims and modified those claims by using the testing criteria given by the business utilizing ICD-9 and HCPCS codes in theNASCO test environment(Sand Box).
• I-num the claims in the NASCO environment for the EDI 837(P&I) with the subscriber or dependent members that are created in sandbox environment based on appropriate test criteria
• Wrote SQL queries and validated data.
• Created ETL source to target queries.
• Submitting the 837 P&I ICNS and validate the cost shares once the benefits loaded from the test region(ST2 environment) in to NASCO sandbox environment
• Validating the cost shares for the 837 I&P claims (deductibles, coinsurance and co-pay) as defined in the product level
• Responsible for documenting the ICNs for passed test cases in test grids provided by the business for Individual Business unit (IBU),large groups(LG INS) after validating cost shares.
• Extensively used Clear Quest was used to create the test cases, store test cases and execute the test cases.
• Used Clear Quest for defect tracking, defect reporting, also followed up with the development team to verify defect fixes and update defect status.
• Attending the claims triage meetings with Business to fix the edit codes for inappropriate test criteria.
• Review Data anomalies with the team and determine course of action to correct it
• Conducted User Acceptance Testing (UAT) and after interacting with the end users and collecting their feedback; documented the changes/enhancements required
• Developed and implemented test case mapping to requirements, Project Status reports, Issue defect matrices, UAT test plans and User Training documents.

Environment: EDI, .net, SQL Server, VB Script, UNIX, Windows XP, NASCO,, Edifices Spec builder, Rational Clear Quest, toad.

Confidential, Tampa, FL

Sr.QA Analyst

Responsibilities:

• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
• Transactions focused on were 270,271, 834, 835, and 837.
• Worked extensively on different modules in the Xcelys application like Premium Billing, Claims, Benefits & Pricing.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD. Extensively writtenTeradataSQL Queries, creating Tables and Views by following Teradata Best Practices.
• Worked on the Beyond Compare tool for the xcelys system upgrade to compare the data between the two environments.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
• Used WINSCP to process the claims to the xcelys application.
• Extensively used Oracle SQL developer in database testing by writing and executing SQL queries to validate that data is being populated in appropriate tables.
• Stored all the reusable data in distinct tables for easy access
• Created expected results and actual results table in Oracle
• Identify Legacy records to use as test data for those scenario
• Used Selenium and converted manual regression test cases to automated tests
• Contributed to the selenium test suite by adding custom step definitions.
• Wrote specifications using Gehrkin syntax for cucumber Proof of concept project
• Stored all the reusable data in distinct tables for easy access
• Created Validationscripts in PL/SQL tocompare Expected results versus Actual results
• Quality Center was used to store Business requirements, test cases and run the test sets.
• Logged defects in Quality Center QC, re-tested defects, analyzed defect with Users and Developers.
• Tested the Claims system through the 837 HIPAA X12 Formats (837P, 837I).
• Involved in Change Request process and performed System and UAT as the project is inProduction.
• Analyzed system requirements and developed detailed Test plan and Test cases for testing the functionality.
• Facilitated weekly meetings with review teams to improve the QA process for the application development.

Environment: Xcelys, SAS, HP Quality Center QC, HIPAA, Oracle SQL developer, Selenium, cucumber, Ruby, Toad, MS Office Suite, Beyond Compare.

Confidential, Philadelphia

QA Analyst

Responsibilities:

• Responsible for reviewing the scripts and system environments.
• Reviewed Business requirement in preparing test scenarios and test cases based on business requirements.
• Analyzing and Testing the 837 (Institutional/Professional - Inbound/Outbound), 834 Inbound, 835 Outbound, 997 Acknowledgement Inbound and Outbound EDI Transactions.
• Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Involved in preparing the Test data for the claims.
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 professional & Institutional and 835.
• Involved in writing and testing complex SQL queries involving more than three table joins and getting explained to verify the SQL performance.
• Validated the reports and files according to HIPAA, ANSI X12(4010) enforced standards.
• Developed various test cases for testing HIPAA 837 I/P (4010 and 5010).
• Prepared test data, analyzed existing 4010 claims production data and converted according to 5010 specifications.
• Worked on Power MHS application for Membership screens (ME1081, ME1082, ME1014), Provider screens (PR1061, PR1062), and claims screens (CL1081, CL1082).
• Wrote SQL Statements in Power MHS to extract the production and test claims from the data base.
• Extensively worked on the tools like Crimson Editor, INGENIX Claredi, and Tumbleweed version 4.8.1 312 to check and validate the claims to test the modules.
• Worked on portal testing for rejected claim status inquiry (RCSI) to generate the error codes for the 5010 professional claims.
• Executed the test cases for the online SOR portal testing for the 835 claims.
• Executed the test data for member eligibility in the claims.
• Interacted with Business teams and Developers to understand business requirements and bug fixes.
• Quality Center 10.0 was used to create the test plan, store test cases and run the test sets.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using Quality Center.
• The Software development life cycle methodology used is Agile, where the weekly and monthly status reports were prepared to track the progress.
• Participated in daily scrum meetings to report issues and defect tracking.
• Communicated with developers through all phases of testing to prioritize bug resolution.

Environment: QC 10.0, EDI, HTML, JavaScript, MS office, Oracle, Mainframe, Windows XP, Java, Crimson Editor, Claredi, Tumbleweed, Power MHS.

Confidential

Responsibilities:

• Created Test Plan, that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required.
• Experience with Medicare, Medicaid, and commercial insurances in HIPAA ANSI X12 formats including 270/271, 276/277, 834, 835, 837.
• Involved in claims submission and payment (remittance) retrievals by using ASCX12N 820 for the In- bound premium payments; ASC x12N 834 for the Inbound Enrollment and Maintenance; ASCX12 276/277 for the claims status enquiry and response; and ASC X12 835 for the Health care Claim Payments.
• Identified, built and executed Test Cases and Test Sets for Functional, Error Handling, Navigation and Regression in Test Director.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
• Created some macros in Teradata to load the test data in to Target tables.
• Manually tested the entire application before the tests were automated. Involved in EDI Medical Claims Analysis, Design, Implementation and Documentation. Validated the reports and files according to HIPAA X12 enforced standards.
• Use Load Runner Analyzer to prepare detailed Load Test Analysis Report with Graphs and the applicationbottlenecks from the scripts execution.
• Extensively use SQL scripts/queries for data verification at the backend.
• Performed back-end testing by using log files and database.
• Created test scenarios for performance testing.
• Involved in testing maps and translated data.
• Used WSDL & Web services protocol in VUGen to create scripts.
• Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837.

Environment: JSP, Servlets, JavaScript, JDBC, SQL server, Windows XP, NT, IE 5.5/6.0. Quick Test Pro, Load Runner, Test Director, HIPAA X12