Sr.qa Analyst Resume
Farmington, CT
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.
- 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.
- 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.
- 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.
- 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
- 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.
- Worked extensively on different modules in the Xcelys application like Premium Billing, Claims, Benefits & Pricing.
- Worked on the Confidential Compare tool for the xcelys system upgrade to compare the data between the two environments.
- 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, Confidential 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.
- 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.
- Identified, built and executed Test Cases and Test Sets for Functional, Error Handling, Navigation and Regression in Test Director.
- 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