Andrew Huang

Email: ad1egu@r.postjobfree.com Mobile: 571-***-****

Professional Summary:

20+ years of experience in IT field as QA Team Lead, Project Manager, Analyst and Engineer.

Hands-on experience in creating test strategy and test plan, designing test environment and test data, and creating, executing and documenting test cases.

Extensive experience in all aspects in QA methodologies, including Software Testing Life Cycle, Software Development Life Cycle, and Defect Life Cycle.

Extensive knowledge in Enterprise Revenue Database and Billing Systems testing, including SOX compliance testing and audit process, PCI and 508 compliance testing.

Extensive knowledge in test management, coordination and planning, resource management, risk management/mitigation, vendor management and conflict management/resolution.

Extensive experience in identifying/implementing QA process improvements to increase product quality and cost reduction.

Strong leadership and management skills in working with large team (up to 50+ test team members) both onshore and offshore.

Extensive experience in SDLC/Waterfall and Agile project framework and various project tools.

Extensive experience in testing ETL, data warehouse, data modeling, and reporting process, using SQL, PL/SQL and other queries to execute backend testing and modify/verify test data.

Extensive experience with relational DB (Oracle) and file-based DB (MongoDB).

Extensive experience in web services testing, UI and API interfaces, across various platform: Linux, Windows, and MacOS.

Extensive experience in test automation, including SOATest, FitNesse, Selenium, Postman, JMeter, SoapUI, Robot Framework, SauceLabs.

Extensive experience in planning and executing QA verification with various approaches for different purposes, such as black/white box testing, functional testing, security/risk testing, integration testing, compatibility testing, performance testing, regression testing, user acceptance testing, sanity testing, data migration testing, etc.

Highly motivated and hardworking with excellent analytical, communication, time management, problem solving and technical skills and the ability to work in a team as well as independently.

Professional Experience:

Somos, Inc. Herndon, VA 12/2016 – 06/2023

Lead Test Engineer

Served as architect for quality engineering efforts, including defining systems elements for testing and certification in quality projects.

Coordinated QA efforts in an FCC-sponsored, multi-year, centralized muti-million record Toll-Free Number Registry modernization project in Agile project management style.

Coordinated with development, requirement teams and other stakeholders in a multi-year, multi-phase project. Earlier phases including building webservices with Oracle backend providing UI and API interfaces to the customers, later phases including re-hosting the whole system onto AWS with PostgreSQL backend.

Planned and executed manual UI and API testing across various platform: Linux, Windows, MacOS.

Planned and executed manual database testing with SQL (Oracle / PostgreSQL).

Planned and implemented test automation suites using Postman/Newman, Robot Framework with Selenium libraries and SauceLabs browser simulation.

Worked with DevOps team to include test automation into CI/CD pipeline with Jenkins, GitHub, Bitbucket, CodeFresh, Docker, etc.

Served in technical project management role, governing testing teams (located both in-house and offshore), lead planning and progress tracking for each release.

Served in product management role, facilitating communication between customer and engineering organization, compiling business and technical requirement documentation, and coordinating updates and releases.

Served in account / program management role, tracking contract items with outside vendors in system features and functionality, developing acceptance criteria and verification process.

Lead defect triage among stakeholders, testing and engineering teams, tracking defect life cycle, and preparing defect report.

Created on-boarding process and training for new project team members and knowledge transfer.

Coordinated test automation requirements creation, planning and test suites review.

Tools / Environments: VersionOne, Robot Framework, AWS, Codefresh, Docker, PostgreSQL, Postman/Newman, Linux, MacOS/Unix, Shell Scripts

Verisign, Inc. Reston, VA 05/2012 – 12/2016

Engineer IV

Designed and executed test cases on web services APIs across Linux, Windows, MacOS, iOS.

Designed and executed test cases on back-end DBs (Oracle, MongoDB) with SQL, PL/SQL and Compass.

Designed and implemented test automation with SOATest and FitNesse to cover web services APIs.

Successfully conducted reverse-engineering as part of investigation/documentation for existing systems functionality.

Plan and executed release deployment using Ansible with RPM/Yum.

Worked closely with InfoSec team in security analysis before certification and deployment.

Planned and executed QA certification in agile software development team, with JIRA as project management and defect management tool, on various web services applications using Oracle, PL/SQL, SOAtest, etc on Linux platform; analyzed business and technical requirements to map onto testing coverage; developed and implemented standard methodology and practices in QA process.

Lead Agile QA Project efforts, planning and executing QA certification on data escrow application that extracts daily Top-Domain data from Verisign systems to data storage sites.

Lead Agile QA integration testing between Verisign naming system and other systems including internal and external partners.

Lead test automation migration from SOATest to FitNesse.

Tools / Environment: Linux, Oracle 12g, Shell Scripts, SQL, PL/SQL Scripts, WebLogic, Glassfish, JavaScript, SOA, HTML, XML, REST, mongoDB, FitNesse, JIRA, Ansible.

AOL Inc. Dulles, VA 11/2001 - 04/2012

Senior Software QA Engineer

Lead QA teams to successfully complete multi-year corporate finance/accounting system projects.

Lead QA teams to support SOX compliance testing and audit, PCI audit and internal IT audit, and 508 compliance audit.

Lead planning and executing QA certification efforts on multi-year projects on major corporate billing and financial data system with a globally distributed team (US, Ireland, India, and Germany).

Lead integration testing between AOL revenue data system and other systems including external partners.

Coordinated parallel testing with operation team to debug issues caused by environment and data, and other factors.

Conducted daily defect tracking and prioritization meetings keeping project team updated with the day-to-day progress of the QA certification.

Lead efforts in Maintaining integrity and availability of networked testing environment, including system administration, installation, configuration and change management, updating software, system/process monitoring and root-level tasks. Configured and customized continuous integration of servers and processes. Ensured the functionality and performance of multi-tier application (client browser - application server - database).

Developed and conducted training programs on AOL revenue data system for QA teams.

Supervised and trained outsourced teams on technical approach and testing methodology.

Served as QA representative on technology organization’s project plan and design team that provided analysis on new technology impacts, project technical design, and cost estimation.

Excellent in working with development team and other project team members to ensure that mutual understanding and support would lead to success for the organization.

Authorized and reviewed test strategy, test plan, test cases, test scripts, test reports and evaluation to ensure QA deliverables are completed on time.

Excelled both in Agile/Scrum and SDLC project environments, tools include Agilefant, JIRA, VersionOne, BLT, and CVS.

Developed and executing test plans and test cases in various development environments and performing all types of testing (functional, corner case, negative, regression, installation, integration, interface, acceptance, browser compatibility, load, stress, performance, volume, and ad-hoc) in developing AOL’s billing and financial data warehouse system.

Lead QA team in testing Ab Initio based ETL batch process on linux environment and Oracle/Sybase databases, and in testing and debugging UNIX/HP-UX C and PL/SQL processes with distributed Oracle databases.

Architected testing system automation, communicating with operation and development teams to ensure that key scenarios will be automated through a production-like QA environment and data flow at key points are monitored and validated.

Developed UNIX/linux shell scripts with vi editor for test automation, including file manipulation, cron job scheduling, parameter definition, error searching, output/log file validation.

Tested and debugged Oracle and Sybase stored procedures with client tools DBArtisan, SQL Developer.

Created test data set and verified data movement and transformation with SQL scripts on client tools DBArtisan and SQL Developer.

Compiled data validation reports using SQL script and Ab Initio.

Tested and debugged SQL-based and Ab Initio based data migration and consolidation processes on Oracle databases.

Configured AutoSys jobs for UNIX/linux batch processing.

Created and deployed file-system image process for QA UNIX/linux testing hosts to facilitate a more standard testing environment and to allow installations on clean environment with significantly shorter preparation time.

Created and maintained virtual test hosts via VMWare virtualization.

Installed, tested and debugged Apache/Tomcat based web services that provide access to customer accounts and financial record data through APIs to various front-end systems.

Design and executed large, distributed web services test cases for functional, regression, and performance testing in Apache/Tomcat hosted Java environment using SOATest, XML, SoupUI, JMeter and RESTClient.

Developed and maintained automation to process functional and regression test scenarios using SOATest, developed and maintained performance (baseline, load, blast) test scenarios with JMeter.

Planned and implemented SDLC QA processes and practices, including defect and test management, and bug/test case/requirement traceability.

Established processes and procedures including change management, work tracking and time management.

Tracked software defects using HP Quality Center, and BLT.

Excellent in communication with systems end-users to understand their business requirements.

Supported end-users in defining functional requirements and conducting UAT.

Familiar with information assurance concepts and practices such as risk analysis and management, vulnerability mitigation, intrusion detection, data forensics, system hardening, firewall, and security testing using Nessus and Snort.

Completed graduate degrees in accounting and business while working full-time.

Tools / Environment: UNIX/HP-UX/linux, Oracle 9i/10g, Sybase, Ab Initio, Shell Scripts, SQL Scripts, AutoSys, PL/SQL, Apache/Tomcat, JavaScript, SOA, HTML, XML, REST, SOATest

NASDAQ Gaithersburg, MD 04/2001 - 11/2001

Software QA Analyst

Authored comprehensive test plans including acceptance, certification, performance, and performance tests of software components.

Installed and configured test systems in UNIX.

Maintained test environment’s availability and integrity including change management, version tracking, and system performance monitoring.

Tested and debugged data extract batch processed in UNIX from Oracle databases.

Used SQL Scripts to create test set and to verify test results.

Configured Maestro to schedule batch jobs.

Developed test automation using UNIX Shell Script and SQL Script.

Environment: UNIX, Oracle 8, TOAD, Maestro

Education:

Florida Atlantic University

MS, Accounting

Keller Graduate School of Management

MBA

Contact this candidate