Quality Assurance Data

Khoi Nguyen

Address: **** ********* *****, #***

Santa Clara, CA 95054

Phone: (408) 256 - 2711

Email: ******@*****.***

Highlight

. Seven years of IT experience with emphasis in Business Intelligence,

Database Design, System Integration and Quality Assurance for

Enterprise Systems.

. Expert in Oracle 9i/10i - DBMS, OLAP, OLTP, Information Repository,

Data Warehouse, Data Model, Data Normalization, Stored Procedure, ETL,

Trigger, Report, Form.

. Working experience with latest Business Intelligence, Web Services

technologies, Service-Oriented Architecture SOA enterprise platform,

failed-safe system.

. Experienced in System Integration, Quality Assurance Practices - Black

Box Testing, White Box Testing, Smoke Testing, Regression Testing,

Load and Stress Testing.

. Knowledge of Object Oriented Programming Methodology, UML concept,

design pattern.

. Experienced in analyzing and developing system specification, business

requirement, design document, master test plan, detailed test plan,

and test scenario.

. Participated in multiple large-scale enterprise-level IT projects

throughout the whole software development lifecycle (SDLC).

. Actively involved in the Electricity & Utilities Industry and the

Wholesale Energy Market.

. Strong teamwork skills and ability to communicate effectively with

developers, managers and team members to coordinate multi-tasks.

. Strong team management experience in leading and mentoring project

teams.

Experience

1. ERCOT Taylor TX (Jun 2007 - Mar 2010)

Data Architect/ Developer Industry: Energy

Overview:

The Electric Reliability Council of Texas ERCOT operates the electric

grid and manages the deregulated market for 75 percent of Texas. The

Texas Nodal Program exists to facilitate the transition from a zonal to a

nodal market. With budget in exess of $600m, the project's goal is to

utilize lastest information technologies to enhance grid reliability and

increase energy wholesale market efficiency.

Responsibilities:

. Member of System Integration Team, responsible for ensuring

availability, reliability, accuracy and transparency of common

dataflow among enterprise systems: Commercial Systems, Congestion

Revenue Right, Market Management System, Energy Management System.

. Built complex database structures, triggers, stored procedures and

ETL, using PL/SQL in Oracle 10i, MS SQL Server, and TIBCO BW, for BI

Data Warehouse Integration.

. Designed logical and physical data models for Energy Market Data

Repository System.

. Implemented Oracle 10i XML DB library framework, for storing,

generating, validating and data mining CIM-format XML payloads.

. Performed SOA Web Service API connectivity validation, by creating XML

payloads, using LISA, MapForce, XMLSpy and other scripting languages.

. Participated in Market Simulation project, analyzing overall dataflow

of the market system and feeding pilot data for FAT test, smoke test,

regression test and performance test.

. Delivered reporting framework and database solution for data audit,

data validation procedure, using Crystal Report, which is now in use

for communicating over registration information with over 100 external

market participants.

. Prepared interface specification, data mapping, data architecture,

defect reports as well as release notes.

. Lead project team in delivering pilot data for Commercial System

Integration.

Environment:

Web Services, SOA, XML, Oracle 10i, TOAD, SQL Server, PL/SQL, SQL Loader,

Stored Procedure, Trigger, ERWin, Mercury Quality Center, Crystal Report,

Informatica, MapForce, ASP.NET.

2. California ISO Folsom CA (Jan 2006 - May 2007)

System QA Analyst Industry: Energy

Overview:

The California ISO is a not-for-profit public-benefit corporation charged

with operating 80% of California's high-voltage wholesale power grid.

Market Redesign and Technology Upgrade (MRTU) is a comprehensive program

that enhances grid reliability, replacing aging technology with modern

technologies that keep pace with the dynamic needs of California's energy

industry.

Responsibilities:

. Analyzed Business Requirements, System Specifications, and Business

Process of the Post Transaction Repository (PTR) MRTU Project.

. Wrote complex SQL statements, PL/SQL stored procedures, Data Warehouse

ETL for data validation and maintaining Data Repository's data

integrity with Actuate Reporting.

. Wrote Master test plans and QA test cases for Smoke Test, Load Test,

Functional Test, and Regression Test.

. Deployed Mercury Quality Center for documenting Test scenarios,

scheduling and executing test sets, collecting test results, tracking

defects and analyzing data.

. Created XML payloads, and validated Web Service data loading process

through SOAtest

. Wrote QTP scripts for test automation to cover GUI functionality of

PTR Actuate Reporting Active Portal.

. Presented defect report and test execution status during meetings with

development group and technical lead.

. Acted as Team Lead in mentoring QA teammates, reviewing and assisting

others' test cases, test runs, test results; signing off new releases.

Environment:

XML, Oracle 10i, DBMS, TOAD, ETL, PL/SQL, ACTUATE, Quick Test Pro 8.2,

Mercury Quality Center, LoadRunner, SOAtest, Perforce, XMLSpy, MapForce.

3. HealthTrio Inc. Tucson, AZ (Sep 2003- Sep 2005)

Software QA Engineer Industry: Technology

Overview:

HealthTrio is a leading provider of e-health applications and core

business systems for organizations that manage care. Software

applications include HealthTrio connect, a web-based communication

platform that enables real-time, HIPAA-compliant interactions between

health plans, providers, members/patients, employers and brokers.

Responsibilities:

. Worked as part of a team responsible for new Web Services application

development.

. Designed logical and physical data models, and built table structures

in Oracle database.

. Wrote codes in XML, Cold Fusion, PHP and Java to connect web GUI

portals with back end database.

. Implemented the automated QA system for HealthTrio product suite,

using CompuWare TestPartner.

. Evaluated existing web servers and set up environment for web

application load & stress test process.

. Wrote test scripts using OpenSTA for automated load, stress test.

. Implemented and analyzed data network traffic flows using SNMP, MRTG

during stress test.

Environment:

XML, Oracle 9i, Cold Fusion, PHP, JServlet, JAVA, TestPartner, TSL,

Eclipse, Linux, Apache, Tomcat, Jboss, CVS, SourceSafe.

4. MISYS Tucson, AZ (Jun 2003 - Sep 2003)

QA Integration Engineer Industry: Technology

Overview:

Misys provides award winning EMR software, electronic health record

systems, Hospital information systems, Physician, Home care and hospice

solutions.

Responsibilities:

. Wrote automated test scripts, using WinRunner for multiple systems'

performance analysis in Systems Integration Lab.

. Wrote regression test scripts using PERL and other Enterprise Testing

Application Suites.

. Set up hardware, software and customized application servers for

testing environment.

. Involved in reviews, requirements design, project team meetings.

. Cooperated across departments for achieving higher standard in quality

of new products.

Environment:

WinRunner, LoadRunner, TestDirector, TSL, Perl, C/C++, IIS.

5. Key Group Ltd. Tucson, AZ (Sep 2002 - Jun 2003)

System Analyst/ Developer Industry: Finance

Overview:

Key Group Ltd is a financial service provider, focus in Phoenix, Tucson-

area commercial real estates.

Responsibilities:

. Developed an Internet marketing system communication of packages and

web page management system

. Developed an automated script for transferring records among multiple

databases

. Migrated ownership information from public records to REA database and

new database

. Maintained and provided technical support and trainings to company's

employees

Environment:

JAVA, HTML, JSP, Windows 2000, IIS, SQL Server 2000

6. Unilever Vietnam (May 2002 - Aug 2002)

System Analyst Industry: Comsumer Good

Overview:

Unilever is the leading manufacturer of global brands in foods, home and

personal care.

Responsibilities:

. Coordinated in Distribution Management Systems (DMS) Project Team

. Monitored and analyzed Business Process Controlling Systems (BPCS

. Evaluated Microsoft Business Solutions Software - Solomon IV.

. Determined inputs and outputs for Distributors' Pilot Automated

Accounting Systems

. Benchmarked an order-entry software on Palm platform for company's

mobile sales forces

Environment:

Microsoft Business Solutions: Solomon IV, Mobile Workforce, Windows 2000,

POS, Palm OS.

Education

University of Arizona -- Eller College of Business and Administration

B.S. Bachelor of Science in Business Administration

Major: Management Information Systems

PREFERENCE

"Khoi is a very skilled dependant data architect who works to complete

the tasks in the estimated delivery time. He also has the ability to view

a particular problem from multiple angles to ensure the end solution is

the most appropriate." -- M. Boyda, Lead Data Architect, ERCOT

Contact this candidate