Rahul Patel

978-***-****

acqqlo@r.postjobfree.com

Status: Green Card

SUMMARY

Experienced QA Application automation Tester with 3+ year’s expertise in all phases of functional testing including Integration Testing, Smoke Testing, Test case creation, Test plan reviews, Regression testing, Test data creation, Traceability and Test execution.

Strong knowledge and extensive experience and understanding of Health care industry, claims management process with knowledge of Medicaid and Medicare Services.

Performed quality assurance and testing on National Provider ID project. Ensured valid segments were generated for providers sending NPI and/or legacy numbers. Tested NPI for billing, attending, referring, operating and other physician types as well as group provider for 837I & 837P.

Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.

Good Knowledge and thorough experience of EDI transactions, ASC X12 Transaction sets: 834(Benefit Enrollment and Maintenance), 820(Payroll Deducted and Other Group Premium Payment for Insurance Products) 270/271(Explanation of Benefits (EOB)/Response to EOB), 276/277(Claim Status/Claim Status Response), 835(Remittance Advice and notifications), 837’s (Claim).

Strong command over X12 format files and related structures, Loops, Segments and Data Elements, with knowledge of mapping X12 formatted files to flat files using the translator.

Hands on experience with testing web services using SOAP UI.

Good experience in developing Test Plans and Test cases using requirements and specifying Testing Overview, Approach Strategy and techniques.

Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy, SSIS, SSRS, Cognos and Business Objects.

Strong in performing backend testing using SQL on SSIS, SSRS and SSAS databases.

Experience in Design and Execution of Test Cases, Test Scenarios, Test Scripts and Test Reports.

Exposure to test automation using Mercury Interactive Tools like QTP.

Exposure to Performance testing using Load Runner.

Exposure to VB scripting and Shell scripting languages.

Experience working on e commerce and e business websites.

Firm knowledge in different phases of STLC and SDLC including Agile Methodology and Waterfall.

Education: Bachelor’s in Business administration

Nobel University, Los Angeles, CA

EXPERIENCE:

New York State Department of Health (NYSDOH), NY Jan 14 – Feb 15

Application Tester

Responsible for analyzing requirements and designs to develop test plans and test cases.

Involved in backend testing by verifying and validating DB2 tables by executing SQL queries.

Execute regression, application and integration test scripts and log defects in QC.

Performed GUI Testing, Functional Testing, Integration Testing and Regression Testing.

Develop application and integration test scripts according to the standards defined by the NYSE-CON Testing Team.

Analyzed system requirement and business requirement documents and developed test cases and test scripts.

Performed data driven testing and GUI Check Points using QTP and enhanced the overall functionality of the application.

Used SQL commands to validate the database and test its integration with the front end.

Communicate status on testing efforts, including metrics such as test execution percent complete and defect/issues logs.

Performed system testing and documented test results in the system test reports.

Prepared defect consolidation log and defect metrics.

Execution of manual test cases and responsible to track and log the defects using Quality Center.

Interacted with developers to sort out the issues and the defects.

Written reusable VBScript functions and accessed them from the library files which are stored in the Quality Center.

Developed automated regression scripts using Quick Test Professional utilizing VBScript scripting for both positive and negative boundary conditions.

Created and executed scenarios in Load Runner controller to analyze system performance in Load Runner Analyzer under load.

Used rendezvous concept of Load Runner to generate peak load onto the server thereby stressing it, and measuring its performance.

Attended the Review meetings and walkthroughs and interacted to Business Analysts and Developers for defects solving.

Used Mercury Quality Center for Defect Reporting, Analyzing, Tracking and Report Generation.

Performed Regression testing by executing QTP scripts on the new build.

Performed Integration, System, UAT and Usability Testing.

Used QC for the test management and test execution for Functional testing.

Participated in quality assurance sessions, walk-through and quality reviews.

Responsible for Compatibility testing, Security testing, Positive, Negative, Integration testing, and Navigational testing.

Written several complex SQL queries for validating SSRS Reports.

Conducted Database Testing and Boundary Conditions Testing using SQL queries.

Participate in quality assurance sessions, walk-through and quality reviews.

Responsible for Compatibility testing, Security testing, Positive, Negative etc.

Worked with Data Migration team by providing Business Requirements for migrating the data from Mainframe to Oracle database.

Presented Weekly Status Report to the manager and client.

Environment: HP Quality Center 9.5, VB,C #, Mercury Quality center, Rational Clear case, Rational Requisite pro, SharePoint, MS Visio, MS Word, MS Excel, MS Project, SQL, SSIS, SSRS.

Montefiore Health IT – NY Jan 13- Jan 14

EDI BA / QA tester

Montefiore Health IT provides professional services and IT-based solutions that deliver clinical transformation and revenue cycle optimization. Our mission is to help you explore ways to increase operational efficiencies and discover innovative solutions for improving patient care. Our goal is to build lasting client relationships in which each project engagement contributes to achieving sustainable business value.

E820 Health Plan 4010 to 5010:- As part of this project, I have worked in E820 Health plan 4010 to 5010 conversion that focuses on 820(Payroll Deducted and Other Group Premium Payment for Insurance Products) and 834(Benefit Enrollment and Maintenance) transaction sets.

Medicaid Client Implementation: I have also worked on the New Medicaid client implementation for Montefiore health IT Play a pivotal role in the implementations in the 4010 versions and transformed it to the 5010 versions of the enrollment and the premium payment file.

QNXT 5.01 Upgrade: As part of this project, I have worked in CCMS to QNXT upgrade project and also responsible for Business requirements and technical solution documents for QNXT and Interface Provider Web Portal, 834 Data Validation, EVV Authorization and claim processing, Several EDI interfaces for QNXT go live.

Responsibilities:

Extensive and thorough Gap Analysis for HIPAA 4010 834 and HIPAA 5010 834 Companion Guides and also for HIPAA 4010 820 and HIPAA 5010 820 Companion Guides.

Exhaustive study and analysis of the various trading partners’ (Medicaid and Commercial) companion guides to identify the specific changes required for that particular client.

Study other enrollment processing systems and perform impact analysis with an objective to establish the impact and scope of the changes needed for the systems.

Conduct review sessions with business owners to establish business rules and identify data requirements for the changes within the 5010 834 transaction set

Support for dual processing capabilities i.e. both the 4010 and 5010 versions of the 834 transaction set. This ensures that both type of clients who want to remain on 4010 version and those who wish to convert to 5010 can also be supported.

the project functionalities and consistently track the requirement changes and prepare change request documents.

Extensive back end data validations with SQL queries to ensure proper data load to existing and the newly added tables, comparison of 4010 set of data against 5010 set of data using SQL output.

Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Experience in creating configuration files to deploy the SSIS packages across all environment

Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.

Prepared the complete data mapping for all the migrated jobs using SSIS

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Building an entirely new translator that takes the 834 and 820 X12 5010 files as input and converts them into flat file layout.

Perform Extensive analysis prepare comprehensive design for the new translator as per the requirements of the state and commercial clients. Data mapping to ensure that the data in 5010 is understood by the translator and make it 5010 compatible.

Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.

Ensure that both 4010 format files for clients who have not yet converted to 5010 and also new 5010 format files for clients who have converted are supported by maintaining the dual usage functionality.

Write the translator related test plans as well as the other common test scenarios for the new 5010 process flow. Also perform system testing for the X12 formatted data that gets converted to the flat file via the translator

Ensuring a proper setup where in the trading partners receive either a 997(Functional Acknowledgement) or 999(Implementation Acknowledgement), but not both.

Environment: Windows 2003, Citrix, Toad, MS Office (MS Excel, MS Access, MS Word, MS Power Point), MS Outlook, MS Visio SQL Server 2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008, .Net, Bugzilla, SharePoint library, SharePoint Defect Tracking Tool.

Sports Academy, TX August2012-December-2012

Quality Analyst

Responsibilities:

Prepared Test Strategy, Test plan and test cases based on the non-functional business requirement to meet SLA timings.

Gathered and Analyzed business requirement and procedure.

Responsible for developing the performance test strategies, plans and cases.

Developed Vuser scripts that contain tasks performed by each Vuser, task performed by Vuser’s as a whole, and task measured as transactions.

Responsible for parameterizing large and complex test data to accurate depict production trends.

Validated the scripts to make sure they have been executed correctly and meet the scenario description.

Responsible for testing RMS Application for Sport Academy.

Coordinated creation of stress environment to conduct stress/ load testing.

Involved in project planning, coordination and implemented performance methodology.

Conducted load test for multiple users using performance center.

Coordinated with internal business departments on their information system needs.

Developed Vuser scripts using Performance centre web (HTTP/HTML), Oracle _NCA, and Web services (SOAP/SOA) protocols based on the user workflows.

Worked with team to identify the bottlenecks and performed regression testing to achieve the pre spin off results.

Responsible for reviewing the code in order to identify the root cause.

Updated scripts for new release and added new functionality as per new releases.

Extensively used Performance Center to conduct performance testing using different host systems.

Developed load runner Vugen scripts using Correlation to parameterize dynamic value.

Responsible conducting for root causes Analysis.

Monitored the metrics such as response time and server resources such as Total Processor time, Available bytes and process bytes by using performance center Monitors.

Correlated and parameterized scripts as well as configured the run time setting in Virtual User Generator.

Monitored performance using windows performance monitors and performance center monitors.

Tracked defects using Quality center.

Configured Parameters to monitor Memory Utilization, CPU Utilization, Throughput, Network Connections, etc.., for web server, App server and data base server in performance center.

Monitored Different kinds of graph including Throughput, Hits/sec,Transaction Response time, Windows resources (Memory Utilization, CPU Utilization, Thread, etc) While executing the scripts from HP ALM Performance Center.

Work closely with Software Developers and take an active role in ensuring that the software component meets the highest quality standards.

Developed SQL Queries for checking the data transaction.

Used SQL for database queries on UNIX operating System.

Used Virtual User Generator to generate Vugen Scripts for web protocol. Ensure that quality issues are appropriately identified, analyzed, documented, tracked and resolved in Quality Center.

Implemented HP ALM Performance Center at an Enterprise Level.

Configured 22 Load generator and 10 controllers in HP ALM Performance Center environment.

Implemented and maintained and effective performance test environment.

Identify and eliminate performance bottlenecks during the development life cycle.

Accurately produce regular project status reports to senior management to ensure on –time project launch.

Used scenario by schedule in the controller to change the Ramp up, Duration and Ramp Down settings.

Identified the load balancing issues on the serves.

Environment: Performance Center 11.5(HP ALM), Load runner, QTP, QC, HTML, SOAP, XML, Oracle 10g, Web services, Windows, MS-Office.

REFERENCES WOULD BE AVAILABLE UPON REQUEST.

Contact this candidate