JOHN HA, Experienced Software QA Engineer

Mobile: 408-***-**** Email: acdt60@r.postjobfree.com Linkedin Profile

PROFESSIONAL SUMMARY

Ten years of experience specializing in Data Analyst, Test and Validation,

and software quality assurance with a valuable blend of IT background

experience in network, systems, development, configuration management, and

software quality across the government, healthcare, IT, and energy

industries.

Experienced and successful in monitoring the software engineering processes

and methods used to define process improvement solutions aligned with

project strategies and objectives to strengthen quality of system for web

apps and services and Biometric devices such as Handheld, USB, and Smart

Cards.

Experienced in full life cycle development of projects, including

specification design, test development, unit testing, integration testing,

regression testing, system testing, user acceptance testing and validation,

deployment, risk analysis, disaster recovery, backup methodologies, manual

and automated software testing, stress/load software testing, and Security

and Penetration testing.

Good understanding of SAP, Application Lifecycle Management, object-

oriented programming (Java and Python), database concepts, and knowledge of

Active Directory, DNS, LDAP, and BIG Data / Data Grid systems like Hadoop's

maps and reduce algorithms.

TECHNICAL SKILLS

MS Suites/ Database: Salesforce, Excel, Visio, Access, SQL Server 2008,

Oracle 10G, 11G, PLSQL, MySQL.

Programming/Scripts Languages: Python, Java, JavaScript, HTML, Bash,

Shell, Unix, Linux, XML, XSLT.

SCM tools: Hadoop, Maven, Tomcat, Jenkins, SVN, Visual SourceSafe,

activeMQ, VMware.

Test Management Tools: HP Quality Center, Clear Quest, JIRA, Product

Studio,TOAD, Putty.

Test Automation Tools: ToolKit (SOAPUI), TestPartner, Selenium, Unica,

Eclipse, Firebug, QTP.

Bug Tracking & Reporting Tools: Bugzilla, JIRA, Clear Quest, QC,

TestDirector, Tableau, Splunk, Cacti.

PROFESSIONAL EXPERIENCE

Archimedes (San Francisco, CA)

Software QA & Test and Validation Engineer (11/2012-12/18/2013)

Analyzed tested, and validated complex health care software simulations

based on health care protocols and case study research.

Checked the data flow through the front end to back end or vice versa and

used SQL queries, to extract the data from the database

Executed the SQL queries in the database to verify the data Integrity

between GUI and database.

Conducted Backend Testing using SQL queries to validate data for change in

the mileage Verification

Performed extensive database testing, wrote SQL scripts to compare the UI

results with that in the database.

Managed all Test PCs, VMWare Test Environments and installer/Software Build

process to ensure a Clean Install for each test cycle on various platforms

such as: VMware and Amazon EC2.

Developed, maintained, ran automated test scripts and tested bug fix from

provided functional and technical designs, functional test scripts or adhoc

for affected functionality.

Verified patches for all code changes and bug fixes and push new builds to

QA for bug fixes verification or regression and end to end testing using

Bugzilla, Linux, Salesforce DB, XML, Jenkins, and Tomcat.

Conducted Functional, Regression, Integration, Performance, and UAT Testing

and supported customers with production's issues.

Analyzed, validated, performed BIG Data / Data Grid Testing and logged the

results of aggregated outputs like cost analysis, gender analysis that is

done by Hadoop map and reduce algorithm using logs and monitor tools such

as Cacti, Splunk, and Putty.

Defined QA process, and developed and executed test cases, and built

analytic reports and dashboards per customers' requirements for the BI

project using tableau.

Global Software Resources - PG&E (San Ramon, CA)

Data Quality Analyst & Test and Validation Engineer(02/2011 - 8/2012)

Successfully developed, improved and maintained QC process using Bash

scripts and Excel for image compression and Data upload processes that

saved 50% of time.

Checked the data flow through the front end to back end or vice versa and

used SQL queries, to extract the data from the database

Executed the SQL queries in the database to verify the data Integrity

between GUI and database.

Conducted Backend Testing using SQL queries to validate data for change in

the mileage Verification

Performed extensive database testing, wrote SQL scripts to compare the UI

results with that in the database.

Used CRM system ECTS to review the CR ids and prepared project status

reports.

Validated daily uploads (15k records per day) and delivered thorough QA

testing reports that determined product quality and release readiness using

ECTS, Excel, Access, and SQL Server 2008.

Assisted other teams with UAT and Performance Testing and worked on

authenticating Web applications for clients requests.

Worked with developers to create technical templates base on the Business

Requirement.

Coordinated with cross functional teams in different locations for data

quality and analysis and distributed tasks to team.

Investigated and mapped out strategies by pulling and analyzing data and

identifying issues to correct data quality using Excel, Access and SQL

Server 2008.

Hewlett Packard - DMDC (Monterey, CA)

Information Analyst II & Test and Validation Engineer (12/2008 - 02/2011)

Provided software testing and validation support for applications that

support Defense Enrollment Eligibility System (DEERS) & Card Technology

Identity Solutions (CTIS).

Conducted UAT, Functional testing, Regression testing, Load and Performance

testing, Penetration testing, System testing, data validation and reported

bugs/issues using SQL, JIRA and Excel.

Analyzed, designed and automated TDD test cases using XML, XSLT, MySQL,

Oracle 11G, VBA, Linux, Excel, QTP, Toolkit (SOAPUI) and Test Partner with

industry-standard analysis techniques.

Assisted in functional specification generation and created test plan and

test cases.

Used CRM system JIRA to review and approved the CR ids and prepared test

coverage reports.

Delivered thorough Test metrics reports that determined product quality and

release readiness to management using Microsoft Excel, Visio, and

PowerPoint.

Leveraged existing knowledge of the software development process to help

identify areas for improvement in the QA process.

Owned and performed QA testing (manual/automation) in full life cycle

development of 7 projects (Web apps/services) for Biometric devices and

Smart cards.

Accenture (client-facing Projects At: AT&T, Cisco System, Ross, and

Ebay) (San Francisco,CA)

Software QA lead & Test and Validation Engineer (01/2007 - 10/2008)

Defined and created Functional Specification, Test Plan, Work Plan and

review with peers and business representatives for sign off.

Attended scrum meeting to triage and resolve defects identified during

testing.

Developed and presented Test Metrics and Status to impacted teams and

management.

Conducted UAT, Regression, Integration, Performance, System testing, data

validation and reported bugs/issues using Excel, SQL, BugZilla, Quality

Center, Unica, Bash, Unix, and Linux.

Coached the planning and provided leadership in performing proper oversight

to on site and offshore team(s) of 1-6 members.

Created UNIX shell scripts to run the Informatica workflows and controlling

the ETL flow.

Created ETL test data for all ETL mapping rules to test the functionality

of the Informatica.

Planned, scheduled, resolved prerequisites, communicated changes, and

assured resolution of all conflicts and changes prior to implementation.

Volt (client-facing Projects At: Intel, Microsoft, Cingular,

Saflink) (Redmond, WA)

SDET Lead & Localization Engineer (05/2004 - 12/2006)

Defined and created System Test Plan, executed test cases and review with

business representatives for sign off for Web applications and web services

and USB devices.

Maintained all Test PCs, VMWare Test Environments to ensure a Clean Install

for each test cycle.

Conducted Functional, Regression, Integration, Penetration, Component, UAT,

and Stress testing using SQL, DHTML, CSS, and JavaScripts.

Developed and presented Test Metrics and Status to impacted teams and

management.

Assisted in training junior QAs in software testing methods and QA tools.

Verified patches for all code changes and bug fixes using HTML, Unix and MS

Visual SourceSafe.

Proficiently interfaced with users, other teams, and Business Partners

within the release area.

Attended Scrum meetings to triage and resolve defects identified during

testing.

Verified display of strings in specific localized languages using D j vu.

EDUCATION

Computing and Software System (BS) - University of Washington

Associates in Applied Science (AAS) - Bellevue Community College

CERTIFICATION

Boot Camp PMI class training.

PMI certification - in progress.

Contact this candidate