Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pratikkumar Patel

Aubrey,TX

Summary

More than 4 years of experience in Quality Assurance and Software Testing in the Healthcare Domain. Excellent skills in writing Test Plans and Test Cases. Extensive experience in testing Client/Server and Web-based Applications. Proficient in manual and automated testing of applications on Windows and Unix environments. Very good experience in Back-End Testing using SQL on UNIX and Windows platforms to validate the consistency of data. Knowledge of MS Office suite, MS Visio, MS Project, and MS Access. Proficient knowledge in various types of Software Testing such as Unit testing, Integrated testing, System Testing, Black box testing, Positive Testing, Negative testing, Performance Testing, Stress Testing, Load Testing, Volume Testing, Data Driven Testing, Back end Testing, and Regression Testing. Extensive knowledge of SDLC. Working Knowledge of HIPAA. Experience with JIRA or other Agile SCRUM tracking applications is an asset. Excellent communication and writing skills with the ability to adapt to new and dynamic environments. Good team leader, Player and can work alone with minimal or no supervision. Ability to multi-task, prioritize and work with time constraints while paying attention to details. Good problem-solving, judgment, and decision-making skills. Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center/ALM, TFS - Team Foundation Server. Expert in writing complex SQL queries for back-end testing. Experience in interacting with Clients, Business Analysts, UAT Users, and Developers. Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing, and GUI Testing. Experience in preparing documentation, preparing test environments, and executing and analyzing the results.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Operations System Coordinator

DHL Supply Chain
07.2023 - Current
  • Coached employees through day-to-day work and complex problems.
  • Entered data, generated reports, and produced tracking documents.
  • Set priorities and problem-solved workflow issues to maintain rapport with customers and managers.
  • Gathered and organized materials to support operations.
  • Responsible for operational system integrity, including setup and control.
  • Facilitate site(s) Warehouse Management System with proficiency.
  • Assist management with facility layout and design to efficiently utilize the WMS.
  • Project development and implementation.
  • Monitor WMS for inventory management control.
  • Interface with operation staffs to maximize system efficiencies.
  • Develop, implement, and monitor sites performance systemically.
  • Analyze system discrepancies; generation of reports as necessary.
  • May write crystal programs as required to facilitate the success of the total network.
  • Interface with customer host representative to identify and resolve issues systemically.
  • Diagnose complex end user device issues, recommend and document process for resolutions.
  • Develop and maintain training materials and guides to using the system

Business Analyst

Fast Switch - Great Lakes LLC
08.2022 - 10.2022
  • Responsible for Merger-related projects
  • Have experience in writing SQL queries to analyze the impacts of system changes on existing data flowing through the data warehouse
  • Conduct workshops and requirements-gathering sessions with large groups across multiple business functions
  • Have experience documenting business and technical requirements in user story format
  • Analyzed and diagramed existing processes and product workflows
  • Worked with cross-functional teams to identify process improvement opportunities
  • Lead the execution of the proposed process improvements
  • Responsible for executing the system definition and design processes within the Software Development Life Cycle (SDLC)
  • Designed and developed complex PDF Data mappings including Type-II slowly changing dimensions
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
  • Resolved issues related to Configuration Management during System Test/QA phase and Enterprise Data Warehousing stage
  • Responsible for Medicaid and Medicare Claims Reimbursement for state healthcare plans using MMIS.

Quality Tester

Gainwell Technologies (DXC) - Remote
08.2020 - 07.2021
  • Execute tests to ensure that the testing environment has been set up correctly
  • Utilize the appropriate testing methodology to analyze testing requirements and design
  • Interact with the project team to gain an understanding of the business environment, technical context, and conformance criteria
  • Participate in the analysis of results and the defect management and resolution process
  • Apply analytical skills in the design of test cases
  • Perform smoke testing
  • Develop testing strategy, review testing strategy, validate requirements and specifications, develop test plans, review test plan, develop test scenarios, select test design techniques, and develop testing metrics collection plan to plan and prepare for testing
  • Proficient in testing analysis and design, functional and performance models, and test specifications to develop functional models for testing, develop performance models for testing, evaluate and validate test cases and scripts, validate functional models for testing, validate performance models for testing, develop test specifications, validate test specifications, validate testing coverage, validate testing environment to develop test specifications
  • Execute test cases and scripts, analyze test results, report on testing progress and results, facilitate defect resolution, and document final test results to execute testing engagement
  • Review test summary reports, provide testing project feedback, and archive testing assets to verify the completion of testing.
  • Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing a QA perspective.
  • We documented testing procedures for developers and future testing use.
  • It is operated under Agile and Scrum frameworks to complete releases and well-organized sprints.

QA Tester

WPS
12.2018 - 03.2019
  • Operated within a very agile environment, employing 2-4 week sprints, and daily scrum meetings
  • Participated in requirement walkthrough and creation of test plan
  • Scripted test cases using Rational Manual Tester
  • Worked on Unix Platform and experienced in back-end testing by executing SQL Queries
  • Checked the data flow from the front end to the back end and used SQL Queries to extract the data from the database
  • Involved in writing extensive SQL Queries for backend testing Oracle database
  • Tested and Validated Requests and Responses of XML using SOAP UI
  • Performed rigorous manual testing such as GUI testing, Black box testing, Integration testing, and System Testing
  • Developed Test Plans, Test Cases for the test
  • Tested the interface between the database and the application
  • Attended requirements and design meetings, reviewed and analysis of requirements and design documentation
  • Exposed to Claims Test Pro for gathering and analyzing data Claims Groupings to seed new Claim Groupings
  • Developed automated test scripts using Quick Test Pro
  • Experienced in testing the application developed using various mobile technologies for application web testing using SOAP UI
  • Proficient in overall Defect Management /Problem solving including tracking bugs and reporting using Quality Center and JIRA
  • Analyzing business requirements and reporting SME and SA for updating docs
  • Good Understanding of the EDI (Electronic data interchange), Implementation, and Knowledge of HIPAA code sets
  • Tested Regression of EDI 834 Transactions following the HIPPA compliance EDI Standard of X12
  • Exported and imported data into ORACLE Tables to perform database testing
  • Developed Test cases, Test scenarios, and Test scripts based on business requirements
  • Tested some failed claims in Facets XT database
  • Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions
  • Agile Management and Software development with Extreme Programming, Scrum, RAD, and Agile RUP
  • Created SQL scripts and embedded them into the UNIX Shell scripts to automate the Back-End testing
  • Used Quality Center to house all test documentation and report/track all issues and defects
  • Interface testing by comparing flat files from the exchange information against an application.
  • Collected and analyzed data to measure the effectiveness of quality control processes.

Education

Diploma - Hospitality Administration And Management

Gujarat Institute Of Hotel Management
Gujarat, India
08.2010

Skills

  • SQL Developer, SQL
  • Windows XP/2007/2010, LINUX/UNIX, MacOS
  • SQL
  • HP Quality Center/ ALM
  • DB2, MS SQL Server 2000/2008/2012, Oracle
  • Cognos, Crystal Reports, Business Objects
  • MS Office Suite, MS Project
  • Operations Management
  • Administrative Leadership

Certification

Business Analyst

  • [Business Analyst] Training - [6 Months]

Timeline

Operations System Coordinator

DHL Supply Chain
07.2023 - Current

Business Analyst

Fast Switch - Great Lakes LLC
08.2022 - 10.2022

Quality Tester

Gainwell Technologies (DXC) - Remote
08.2020 - 07.2021

QA Tester

WPS
12.2018 - 03.2019

Diploma - Hospitality Administration And Management

Gujarat Institute Of Hotel Management
Pratikkumar Patel