Hitesh Patel

adtvfe@r.postjobfree.com

201-***-****

Summary:

Experience of 8+ years as QA Analyst/Tester in healthcare domain.

8+years of overall Quality Testing experience and Automation Testing Experience (Selenium Web driver).

Excellent communication and interpersonal skills and capable of working independently.

Reliable, proactive, responsible, hardworking, and good team player.

Working Experience of Claims adjudication rules and auto adjudication.

Knowledge of Provider and enrolment module of Health care.

Experience with Medicare, Medicaid, Medigap/Medsupp & commercial insurances in HIPAA

ANSI X12 4010, 5010 formats including 270,271, 276, 277, 835, 837, NPI, ICD 9, ICD 10,

Expertise in conducting and participating in different Types of Testing - Integration, System, Functional, Regression, Sanity, Smoke and User Acceptance Testing (UAT).

Strong in analyzing and understanding Business specifications, testing requirements and Developing Test plans, Test cases, Test Scenarios and Traceability Matrix.

Excellent knowledge of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Good Experience in working on projects in Agile Environment.

Experience testing POS applications in Retail and ecommerce.

Experience testing in POS of Medical billing Retail portal.

Expertise on performing Front End (End to End Testing, System Integration Testing) of applications.

Good Expertise in automating the Front End Testing using Selenium Web drivers, CORE JAVA and Test NG Framework

Expertise in working with Selenium IDE and Selenium WebDriver using TestNG.

Experience in developing a framework using Hybrid model.

Experience in writing CSS Selectors, Xpath Expressions to identify Web Elements.

Experience on working with TestNG for automation reports.

Extensive experience in GUI, Functional, System and Regression testing of Web based applications.

Experience on ETL tool Testing.

Well knowledge on ETL tool and process.

ETL test validations and checks / Quality checks.

Expertise in SQL database testing involving SQL Queries, Joins to pull data from database

Very good experience with Quality Center / HP ALM to develop Test cases, executing test cases in Test lab, and creating and tracking defects in Defects module and also generating reports in Quality center.

Design automated tests to validate applications by creating scripts that run testing functions automatically. This includes determining priority for test scenarios and creating execution plans to implement these scenarios.

Analyze bug reports and highlight problems to help identify fixes for them. They deliver regular reports identifying these bugs to other members of the engineering team.

Manage the execution of System/Integration/Functional tests and the documentation of tests results and manage the defect logging/tracking/reporting process.

Ability to write Test plan, Test Strategy, Test cases, Test Scripts from BRD (Business Requirements Documents) and Use Cases.

Used ETL (SSIS) to develop jobs for extracting cleaning, transforming, and loading data into target tables.

Experience in SSIS script task, look up transformations and data flow tasks using T-SQL and visual basic scripts.

Used Tableau for Performing and documenting data analysis, data validation, and data mapping/design. Reviewing and improving existing systems and collaborating with teams to integrate new systems. Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.

Strong expertise in establishing QA Policies, Root Cause analysis (RCA), Procedures, strategies, metrics, developing appropriate process and team to ensure the quality of product.

Excellent Experience in Defects Tracking in the Application.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center / ALM, JIRA, Test Link, Rally, Doors, Selenium (Selenium IDE, Selenium Webdriver, TestNG), Postman, IntelliJ IDE, SQL Server Management Studio

Testing Types: Frontend Testing, Manual Testing, Automation Testing (Selenium IDE, Selenium Webdriver, TestNG), API Automation testing, Database Testing, Reports validation.

Database: Oracle, SQL Server, Teradata, DB2.

Skills: Core JAVA, Selenium Web Driver, SQL Server, HTML.

Automation Framework: Hybrid Framework, Data Driven Framework

Work Experience:

Advantasure, Richmond, VA Dec 19 – Till Date

Test Lead

Advantasure is a health technology and business process services company that improves the performance of health plans and provider organizations in the delivery of government healthcare programs. Providing solutions in Claims processing, Regulatory compliance, Medicare Advantage, Enrollment, Revenue optimization, Utilization management, Medicaid, Medicare membership/payment reconciliation, Provider performance, Dual eligibility administration, AEP, and workers’ compensation.

Reviewed Business Requirements Documents and Technical Specifications and Functional Specifications.

Involved in Performing Functional testing, Regression testing, System testing, and User Acceptance Testing.

Design automated tests to validate applications by creating scripts that run testing functions automatically. This includes determining priority for test scenarios and creating execution plans to implement these scenarios.

Analyze bug reports and highlight problems to help identify fixes for them. They deliver regular reports identifying these bugs to other members of the engineering team.

collaborate with other members of the engineering team to find the best methods for solving problems in apps and systems.

Involved in Back End testing, written SQL queries to retrieve and validate the data.

Run regression and smoke test suites on the application.

Developing test cases based on the User stories and functional requirement specification document.

Involved in preparing high level scenarios based on Agile Methodologies for each Scrum.

Analyzed System Requirement Documents and determined types of testing apply.

Performed Manual Testing of the application.

Wrote detailed Functional and GUI testing and User acceptance testing (UAT).

Wrote SQL queries for Backend data verification, retrieving data from related tables and Testing.

Work closely with Master Data Management (MDM) programmers to ensure data sources are accurate, available and analyzable.

Hands on with Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management).

Create and edit SQL queries within Tableau to build calculated fields.

Create interactive filters, parameters and calculations for preparing dashboards and worksheets in Tableau.

Build and publish interactive dashboards on Tableau Server. Collaborate with MDM programmers and QA analysts to test, clean, and standardized data to meet the business requirements.

Conducted End-to-End testing of the system manually.

Detected bugs and reviewed them with business and developers and classified them based on the severity.

Participated in daily scrum meetings to report daily progress of automation activities and sprint planning for test planning activities.

Extensively worked on Jenkins for continuous integration and for End to End automation for all build and deployments.

Interacted with the Project Manager, Business Analysts and Developers to understand the application design and functional specifications.

Work in Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC)

Processing and Manipulating claims through EDI 837 files as per HIPAA guidelines.

Created test processes, test cases and methods for performing the tests.

Conducted Functionality, System and Regression testing during the various phases of the development.

Functional tests to ensure business functions have been met.

Conducted User Interface testing to provide the users with appropriate navigation flow through the functions of the application.

Actively participated in defect status and review meetings to resolve the defects in efficient and timely manner.

Issue reporting, tracking, and preparing review report using JIRA

Responsible for updating existing Test Cases against the change of requirements.

Environment: PL/SQL, SQL Developer, Windows 10, web-services, JIRA, MS-Office, Agile, Outlook, Skype, Microsoft Teams, Join-me.

Dean Health Clinic, Madison, WI Oct 18 – Nov 19

QA Analyst

Dean is one of the largest integrated healthcare delivery systems in the country. It offers primary, specialty and tertiary care for patients throughout southern Wisconsin. The project was the implementation of Electronic Health Record (EHR) system which generates the complete electronic record of a clinical patient encounter. It also included development and / or enhancements to other care-related activities directly or indirectly interfacing with patient, physician, laboratory, billing and health education portals.

Analyzed use-case document and functional requirement specification document.

Designed and implemented Automation Frameworks such as Data Driven Framework and Hybrid Framework for a number of projects. Created Test Scripts using Selenium Web driver with Page Object Model

Created different document and matrices like test log, test incident report, test coverage matrix, tractability matrix etc.

Generated test reports and test cases using QC.

Prepared and maintained the Requirement Traceability Matrix to ensure completeness.

Created test cases and test data from the functional requirement specifications.

Primarily responsible for reviewing the approved Change in Requirements and analyzing and identifying the impact to existing test cases and scripts.

Primarily responsible for reviewing the approved Change in Requirements and identifying and preparing the new test cases and test scripts.

Worked in building automation scripts and frameworks from scratch using Selenium Web driver with Java.

Hands on experience on numerous Healthcare domains and knowledge of HIPAA, EDI (834 and 837) and HIX (Health Insurance Exchange)

Involved in Black box, Manual Testing, and prepared Test Suite for all the Test Cases.

Tested the system to verify the compliance with HIPAA in terms of privacy, security and standards

Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting for MMIS testing.

Wrote detailed Functional and GUI testing and User acceptance testing (UAT).

Wrote SQL queries for Backend data verification, retrieving data from related tables and Testing.

Conducted End-to-End testing of the system manually.

Detected bugs and reviewed them with business and developers and classified them based on the severity.

Generated various Reports for PMO including Weekly Status Report and Open Defect Report using Excel.

Conducted the Regression tests for already reported Bugs and change requests to test whether fix has been applied or not and to test and ensure the fix does not cause a new problem or break existing functionality.

Environment: Windows 8, UNIX, Text pad, FTP client, JIRA, SOAP UI, HP Quality, Java, MS-Office

RCA, Richmond, CA Jan 17 – Aug 18

QA Analyst

The client is a leading Dental Insurance provider in United States. They are migrating to a new ERP health care system MetaVance. The project scope involved the testing and Quality Assurance of the data migrated from legacy systems to MetaVance and verifying the functionalities of MetaVance per the company’s business need. Legacy to MetaVance migration was done by using BODS. MetaVance includes the online application and the batch processing for daily / weekly / monthly processing.

Logged the issues in internal bug tracking tool JIRA and QC (ALM) as well.

The areas of online application testing I covered were Membership, Benefits, Claims processing and Billing.

Designed and implemented Automation Frameworks such as Data Driven Framework and Hybrid Framework for a number of projects. Created Test Scripts using Selenium Web driver with Page Object Model.

Participated in daily scrum meetings to report daily progress of automation activities and sprint planning for test planning activities.

Extensively worked on Jenkins for continuous integration and for End to End automation for all build and deployments.

Prepare and deliver an in-depth presentation on agile methodologies and software craftsmanship including Scrum.

Prepared requirements traceability matrix for each legacy systems to ensure the data migration is achieved with accuracy.

Involved in Bug Review meetings and participated in weekly meetings with management team.

Provided testing results and weekly status reports to the QA Manager

Preparation of Requirements traceability matrix for HIPAA compliance, various business rules depending on the state and ensuring the MetaVance functionalities are in compliance.

Performed 508-Compliance Testing on web-based applications.

Participated in JAD sessions to ensure appropriate scope management for MMIS.

Responsible for validating and testing clear ICD-9 to ICD-10 conversion.

Knowledge of 837, 835, 276,277, 270, 271, 834, HIPAA EDI and X12 transactions.

Writing system test plans, test scripts, check lists and its review.

Experience in testing using message queues (JMS) in SoapUI/GEMS or any supporting tool.

Extensively performed Manual testing process to ensure the quality of the software.

Wrote the test cases and execution based on the documents such as BRD provided from business users.

Used SOAP UI for testing web services (request XML and response XML).

Responsible for special projects, external audits, evaluations and process improvements in support of governance initiatives while working on MMIS application.

Created Use Cases, Use Case Diagrams, Activity Diagrams, Sequence Diagrams using MS Visio supplement the BRD and FRD.

Involved in production tickets triaging. Analyzed ticket, Provided RCA, Raise defects, tested again after fix.

Develop scripts and test cases for Integration Testing, Regression Testing and Stress Testing.

Extensively used SQL scripts/queries for data verification at the backend.

Interaction with the legacy SME, business, IT team and HP for technical clarifications.

Worked closely with the legacy team to ensure adequacy of testing through clear understanding of Design aspects and business requirement.

Environment: PL/SQL, DB2, SQL Developer, UNIX, Windows 10, web-services, JIRA, SOAP UI, MS-Office, Agile, ALM/QTP.

AmeriHealth, Cranbury, NJ Sep 15 – Dec 16

Test Engineer

AmeriHealth, the largest health care insurer in the Mid-Atlantic region with its offices in District of Columbia, Maryland, North Carolina, Northern Virginia and West Virginia and serving nearly 3.1 million members.

Reviewed and analyzed Business Requirement Documents (BRDs), Technical Requirement Documents (TRDs), and Conceptual Specification Design Documents (CSDs).

Wrote Test Scenarios and Test Cases based on the BRDs, TRDs, CSDs, process flows, architectural diagrams and business needs. This activity included Individual and Group Setup in Members Edge; Health Exchange Payment (820); Health Exchange Enrollment (834), Invoice & Billing activities.

Involved with the testing phases for SIT (System Integration Testing), PT (Product Test) and UAT (User Acceptance Testing).

Responsible for testing and verifying new unemployment claims website compliance to section 508.

Performed technical evaluation of products and built efficiencies across the teams through brainstorm sessions and root cause analysis (RCA).

Performed backend testing by writing and executing SQL queries to validate that data is being populated in appropriate tables and manually verify the correctness of the data with frontend values.

Performed Cross-Browser Testing on different browsers for 508 compliance tests.

Used MQ test and SoapUI for XML response for the member information from Siebel GUI interface purpose and WSDL files uploaded in SoapUI testing using client security certs.

Updated daily stats of blocked, failed and passed test case and logged execution time in JIRA.

Identified Test Data by querying and created Test scripts for SIT, Regression and UAT.

Used various CPT (Claims Test Pro) functions including, Member and Provider Conversion, Created Keyword and EDI File and Modify the Member Data as per the Business Requirement Document and as per the test case.

Created test processes, test cases and methods for performing the tests

Performed All phases of end-to-end testing which includes Smoke testing, Functionality testing, Integration testing, Regression testing, back end testing etc.

Responsible for updating existing Test Cases against the change of requirements.

Queried the DB2 database in Mainframes for the Proper validating the claims into the Database.

Environment: HIPAA EDI, JIRA, Microsoft SQL server 2008 R2, Microsoft Outlook, SQL, SOAP UI, web-services, Microsoft Office communicator 2007.

MVP Healthcare, Rochester, NY Nov 14 –Aug 15

QA Engineer

MVP Healthcare will provide a higher standard of health care coverage and improves the quality of care for every member. It sets the standard for outstanding quality health care, service and value. It is the leader in access, affordability and quality in the competitive health insurance market.

Reviewed the Requirements document for 4010 and prepared the test plan and test cases.

Involved in Manual Testing of the application.

Conducted functional, system, data and regression testing.

Interacted with the Developers and BA for defects and problem resolution.

Wrote SQL statements to extract data from Tables and transactions validated the data by using SQL.

Generated Bug Reports and Test case coverage reports for status meeting and involved in resource planning for test cases coverage.

Using FTP we upload and download files for testing data

Using Text pad to validate the data

Tested the web services for Provider and Recipient Portal.

Designing test scripts for testing of Claims in Development, Integration and production environment.

Involved in testing HIPAA EDI Transactions (837I/P/D, 270/271, 276/277, 835,834, 820) for 4010/5010.

Involved in writing Complex SQL Queries using TOAD to validate the loads.

Wrote the SQL queries on EDW tables and Data Mart Staging Tables to validate the data results.

Record Count Verification DWH backend/Reporting queries against source and target as an initial check and incremental loading check.

Assists in the confirmation of problems reported from outside sources and assists system development staff in understanding problems and desired resolution.

Backend testing of the DB by writing SQL queries to test the integrity of the application and databases.

Responsible for writing version release notes as well as maintenance of the defect tracking system.

Maintained Metrics participated in weekly status updates showing the progress of the testing effort and open issues to be resolved.

Environment: MS Office, Text pad, UNIX, FTP client, Clear case, Clear Quest, Spec builder 6.2/7.0.

EDUCATIONAL DETAILS:

Master’s in Computer science from University of the Potomac, Vienna, Virginia_2017.

Contact this candidate