Sqa Engineer Software Development

Jerry Cheung

Email: **********@*****.*** Melrose, MA 617-***-****

SUMMARY:

Experienced Senior SQA Engineer with a proven track record in ensuring data accuracy, completeness, and integrity within ETL workflows. Specialized in functional testing for Medicare and Medicaid Payers, demonstrating extensive expertise in EDI 278, JSON, and XML. Proficient in identifying and validating data correctness through SQL queries and adept at working within cloud-based testing environments. Possess comprehensive experience in validating electronic healthcare data files, such as 834, 835, 837, HL7, and 278 EDI. Successful track record in migrating data from legacy systems to new databases.

Skilled in testing various applications, including browser web-based, cloud-based, client-server, and mobile applications on different versions of IOS and Android. Adept at collaborative efforts with cross-functional teams, including Project Managers and Developers, to enhance testing strategies for data warehouse projects.

Solid understanding of the Software Development Life Cycle (SDLC), encompassing Test Planning, Test Development, Test Execution, and Test Reporting. Demonstrated proficiency in conducting Regression, Functional, Usability, Smoke, and UAT testing at the end of each Sprint in QA, Preprod, and Prod environments. Committed to delivering high-quality results through meticulous testing methodologies.

SKILLS:

Languages: Java, XML, UNIX shell scripting, C, Visual Basic

Cloud: Azure

Tools: Azure DevOps, HelixALM, DOORS,TFS, JIRA, Swagger, TestRail, Jenkins, Confluence, ALM, PractiTest, SVN, CVS, AccuRev, Symantec Visual Café, JBuilder6, MsgRunner & Test Runner, Test Director, Visual Source Safe

OS’s: HP 9.0/10.0/11.0, SUN Solaris 2.8/2.9, XP, Windows 10.0, WinNT 4.0, AIX 4.2/4.3, Linux 7.2

Database: Oracle DB and MS SQL Server

QA Environment: Agile or Waterfall methodology

PROFESSIONAL EXPERIENCE:

OncoHealth, Atlanta, GA Feb 2023 – Jul 2024

Sr. SQA Engineer

Attended to daily standup for reporting on test plan/test case, test execution and test defect via Azure DevOps.

Analyzed user story with Business/Product Mgr to define test coverage in review sessions.

Submitted defect and re-tested communicate with dev team if issue is resolved, and utilized SQL queries to validate data correctness.

Developed and executed comprehensive test plans and test cases via ETL workflows, focusing on data accuracy, completeness, and integrity.

Worked closely with Project Mgr, Developers and others QA members on multiple tasks via cloud space.

Collaborated with cross functional QA to participate on monthly releases.

Supported functional testing for several Payers for Medicare and Medicaid members as well as providers.

Performed data validations on EDI 278, JSON and XML via ETL process as well as cloud environment.

Validated the correctness of migrated data from the legacy system to a new database.

Ran regression, functional tests on new and existing features in Preprod or Prod environments.

Nova Biomedical, Waltham, MA Jan 2022 – Feb 2023

Sr. SQA Engineer

Reviewed Software Documents Specification and verification/validation test plans based on a scope of work.

Created test script, installed test build, run scenarios file for validation test in every phase (IQ/OQ/PQ).

Performed hand-on test execution on firmware, Sensor and Medical device software.

Estimated, executed and maintained manual test cases via DOORS.

Executed functional and regression testing protocol via simulator.

Submitted defect and well documented clearly in HelixALM.

Worked closely with the R&D team in GMP environment to data gathering, document and triaging of issues.

Participated in risk analysis from both a system and software perspective.

Understand of medical device regulated processes like 21 CFR 820, ISO 13485 and ISO 9001.

Advisor360, Weston, MA Nov 2019–Dec 2021

Sr. SQA Engineer

Analyzed user stories, create test plan, test case, test script execution and generate test report.

Performed Ad-Hoc, Smoke, Functional, Regression and end to end testing of web based financial applications

Collaborated with the development team, QA as well as work with cross functional QA team.

Adopted to Agile methodology for Sprint planning, testing status, defects and test reports.

Tested applications on mobile devices with Android and iOS using Emulator likes Investor360 Client, Advisor360 and CommLink apps. Validated various of versions of IOS and Android platforms.

Implemented and maintained automated testing scripts for data warehouse testing, ensuring repeatability and efficiency.

Validated back-end testing using sql queries on Oracle and SQL Server databases.

Promoted/deployed codes into QA, Preproduction environments using by Jenkins.

Performed and risk analysis on applications for multiple user interfaces in various browsers, and support testing in DEV, QA and PREPROD/PROD environments to fully validate functionalities per specification.

Validated API’s testing using Swagger in various environments such as DEV, QA and Preproduction.

Utilized TestRail/JIRA as a software defect tracking, testing scripts and test documents to effectively communicate defect status.

Triage, solved problems promptly and effectively, document defect in details.

Commonwealth Care Alliance, Boston, MA Nov 2016-May 2019

Sr. SQA Analyst

Adopted to waterfall/agile method to create test plan/test script, test data and test cases for all Project.

Performed backend testing using Oracle/SQL and EDI testing for file formats and validated complex scenarios.

Performed black-box testing, data validations, and regression testing of all internal CCA applications.

Utilized test tool such as PractiTest for requirements, test plan, test execution, defects and test status.

Submitted defects in JIRA and provide a detail steps for DEV to replicate issue in Test; created detail document, screenshot, communicate, and work with DEV to resolve all software defects.

Implemented key data quality metrics and benchmarks, measuring the success of data migration efforts and providing actionable insights for continuous improvement.

Performed black-box functional testing of data extracts via ETL for Members, Providers, Clinical and Claims data mapping throughout EDW.

Validated electronic healthcare data file such as 834, 835, 837, HL7 and 278 EDI.

Identified test requirements from specifications, map test cases requirements as well as design test coverage plan.

Designed and executed comprehensive test plans and test cases to validate the functionality and performance of data warehouse processes.

Defined the scope of testing based on functional and technical requirements.

Setup a set of data via informatica cloud portal, manipulated test data based on test requirement and evaluated test results.

Coordinated functional, regression and UAT end-to-end testing activities for releases prior to production; also post-production support and solving customer issues.

Collaboratively worked with the MassHealth, engaging with project managers, developers, and business analysts across functional teams to ensure seamless coordination and successful project outcomes.

Quintiles, Inc., Cambridge, MA Mar 2011-Nov 2016

Sr. SQA Engineer

Manually validated software applications in all aspects of block-box testing, including functional, regression, scalability and overall system testing.

Participated functional specifications review with CTS and DEV as well as SQA; familiar with SDLC process throughout every release.

Adapted Agile or waterfall methodology with team members and TPM.

Manually tested Healthcare Informatics and Patient Registries such as data entry for the patient's personal health data in Web EDC system. Validated backend data using data download tool or SQL queries.

Worked closely with development and project management to define, specify, implement and validate a project as it moves through DC. Author in the creation of validation Test Documentation, Test Data, Test Reports and Test Files. Developed and maintained test cases, defects verification and report test results into HP ALM.

Reviewed and approved documentation, including manual test execution script, specification and validation discrepancy reports.

Developed and executed XML tests for various web APIs. Validated the xml file against XML schema Definition and field’s validation on web as well as store correct data in Database. Use XSD schema to define properties of elements, attributes, multi-select and repeat group’s elements data mapping.

Performed black-box and white-box testing, load testing via Uploader and report testing.

AstraZeneca Inc., Waltham, MA Mar 2010-Sept 2010

SQA Engineer, Consultant

Worked with small team using Agile methodology and attended scrum meeting on daily basis.

Reviewed, developed, executed test plans, test metrics, and user cases; identified problems as early in the lifecycle as soon as possible.

Ran script to update the correct build in QA environment, validated the data correctness, data accurately via workflow using informatica.

Developed or coordinated testing with cross functional team and managed multiple testing projects.

Entered defect into bug tracking system and collaborated with developers to resolved any issues.

Worked with UNIX/Linux commands; validated backend data using Oracle queries.

Performed regression testing for every phase release and bug verification.

American Student Assistance (ASA), Boston, MA 2005-2009

Software Quality Assurance Engineer

Familiarity with Agile development methodology life cycle and SDLC.

Reviewed functional requirements with business user; created and developed manual test plans as well as test cases.

Worked closely within the scrum team to develop QA sprint backlogs and meet all release deadlines.

Evaluated test data, test steps and test grid for automation team.

Performed black box functional testing via Client/Server, Web base applications and back end data validation using SQL 2000.

Executed automated tests suites by running Mercury WinRunner.

Analyzed test results and submitted defect into bug tracking system using HP Quality Center.

Documented test results/test reports/test plans into Visual SourceSafe or Document Locator.

Configured and maintained databases, such as restored/upgraded database schema and reference data transfer in QA local environment.

Wrote SQL script to find test data that meet selection criteria and validate test data generation.

Ran regression testing on both automated and manual test cases.

Performed a formal demo of the product to Business User and Product Manager.

Progress Software Corporation, Bedford, MA 2000-2004

Performance Engineer/SQA Engineer

Created test strategies, test plans with test case based on Product Requirement Document (PRD) and other documentation.

Performed and executed software installs on various platforms. (All windows and Unix environment).

Implemented load testing using both MsgRunner and Test Runner automated tools.

Scheduled the performance testing twice weekly and documented any defects found in testing.

Measured performance test data and reported results in an Excel spreadsheet.

Updated SonicMQ performance weekly test results on the intranet web page.

HTTP/HTTPS Proxy testing with Apache 1.3/2.0, Squid, Iplanet server, HTTP tunneling, JNDI with Borland 5.0 & 5.1, Pluggable Cipher Suite, Pluggable Authentication Security Service, Windows Service and SonicMQ, a JMS Messaging Server.

Tested JNDI/GUI interface with an LDAP server and Borland AppServer.

Imported the xml file into Directory Server using GUI or Administration tools.

Exported the xml file from the Directory Server to the file system using GUI or Administration tools.

Performed multi-server and multi-client white-box testing on Windows and UNIX platforms.

Developed and tested Applet using TCP/HTTP protocol with IE or Netscape browser; tested a JMS client sample test scenario for Topic or Queue.

Evaluated the performance of the third-party databases testing with clients, such as PointBase database, Progress database and Borland database.

Collaborated with developers for the Patch release or bug fixed and track defects in the ClearQuest database.

EDUCATION:

Wentworth Institute of Technology, Boston, MA Bachelor of Science degree in Computer Science System

Contact this candidate