Nhat Nguyen

e: abnim0@r.postjobfree.com t: 267-***-****

LinkedIn = http://www.linkedin.com/in/natfromphila

Background

Mr. Nguyen is an ADP Human Resource and Payroll System consultant; he has a well-

rounded knowledge of database development (Oracle 8i, 9i, 10g and MS SQL Server)

and administration, along with ADP two and three tier application processes. His

hands on functional and technical experience with HR, Benefits, and Payroll modules

of ADP’s HRMS applications have lead to many successful client engagements. The

projects he has been involved in include ADP Enterprise Upgrades, Implementations,

SQR Programming, and wide array of HRIS related work. (Below is my lengthy

consulting resume which lists all my work history).

Relevant Work Experience

CIT Group, Banking, HRIS Manager, ADP EV4 on Hosted Environment.

Acted as HRIS Manager on many of the HRIS day to day tasks. Acted as the subject

matter expert and technical lead on various projects. Technical lead on the HR’s

organizations charting in Org Plus, and numerous inbound and outbound vendor files.

Developed robust solutions on various HR related critical processing. Improved HRIS

efficiency by automating many of the regular manual processes. Worked with

Humane Resources partners to resolve escalated issues. First source of contact for

any company wide reporting needs.

Mintz Levin, Law Firm, Upgrade Consultant, Upgraded ADP Enterprise v3 on SQL

Server 2000 to ADP EV-5 on SQL Server 2005

Acted as Lead DBA and Upgrade Specialist. Migrated database from SQL Server 2000

to SQL Server 2005i. Upgraded the application from Enterprise v3 to v5. Worked with

clients on developing custom panels and reports to accommodate their specific

needs. Converted SQR programs and Reportsmith reports to comply with new EV5

platform. Helped clients transmitted parallel and live payroll. Responsible for post

production support.

CRETEX, Manufacturing, Crystal Report Developer and Technical Support, 1800

Employees, Payforce.

Worked with client on analyzing old reports from legacy HRIS system and developed

new custom SQL for Crystal Reporting in E-Portifolio. Developed complex reporting

solutions that took advantage of Crystal direct SQL commands and other capabilities

to resolve auditing for this multi-states company. Trained client on Crystal Reporting.

MPG, Marketing and Advertising, Implementation Support Consultant, 800

Employees, ADP EV5

RCM Technologies, Inc. – Enterprise HR Solutions 9 Polito Avenue, Suite 950, Lyndhurst, NJ 07071 201-***-**** www.rcmt.com/ehs

Nhat Nguyen 2

Third party consultant on ADP EV4 implementation. Provided resolutions to many

unknown processes and outstanding issues from their implementation. Trained client

on HR and Payroll and Benefits functions of EV5 and also provided implementation

support. Assisted client in collecting data for implementation upload. Trained client

on Reportsmith and wrote reports for data integrity validation.

United Water Resources, New Jersey, ADP Reporter Developer, 2,800 Employees,

ADP EV5,

Converted Payroll, Benefits and HR ReportSmith Reports to ADP Reporter Reports.

Worked directly with ADP Reporter Solution Center to resolve many anomalies for a

client new to ADP Reporter’s world, there were missing custom tables, inability to

accommodate functionality as was used in Reportsmith. Provided post production

support for an implementation. Developed custom Macro reporting solution to resolve

complex data reporting from multiple data sources. Data were housed in both

database and Excel spreadsheets that needed to merge for submission to Success

Factors and OC Tanner. Technical lead in Success Factors development for

Performance Management and Compensation data pull modules.

Brooklyn Queens Health Care New York, Lead Upgrade Consultant, Enterprise

EV3, 3000 Employees

Applied the September 2007 EEO Patch Upgrade on an advanced tools ADP database.

Recreated Production environment on off-site lab; created Test, Devl, and Prod

databases. Installed SQL Server, ADP EV3, and configured application and process

servers. Upgraded the environment and process parallel payrolls to validate data

integrity and financial output.

La Brea Bakery, Food Industry; Implementation Consultant, Enterprise V5, 1100

Employees

Acted as lead consultant on an implementation from PCPW to Enterprise V5. Setup

all Payroll, Human Resources and Benefits tables. Setup benefits programs and plans

to link with Autopay. Designed and implemented application security. Trained client

on all aspects of the applications and was the first line of contact on all issues.

Processed payroll on parallel and production environment. Converted employee

history data from legacy database into EV5. Third party applications involved were

ADP 401K, Enterprise eTtime, and ADP Cobra.

City Center of Music & Drama, Theater; Implementation Consultant, Payforce,

1000 Employees

Acted as lead consultant on an implementation from PCPW to Payforce. Analyzes

client business to setup all Payroll, Benefits and Human Resources tables. Trained

client on all aspects of the applications and was the first line of contact on all issues.

Processed parallel and production payroll on both test and prod environment.

Health Dialog, Healthcare Mgnt; Implementation Consultant, Enterprise V5, 1500

Employees

Nhat Nguyen 3

Acted as lead consultant on an implementation from PCPW to Enterprise V5. Setup all

Payroll, Human Resources and Benefits tables. Setup benefits programs and plans to

link with Autopay translation. Designed and implemented application security.

Trained client on all aspects of the applications and was the first line of contact on all

issues. Processed payroll on parallel and production environment. Created custom

SQR programs to resolve complex reporting. Converted employee history data from

legacy database into EV5. Third party application was Enterprise Etime.

VWR International, Scientific Products; HRIS Manager, Enterprise 4E. 4,000

Employees

Managed daily operation on HR system and synchronization of HR, Benefits, and

Payroll departments to function as one. Coordinated work flow on daily processes

between all the departments. Managed the upgrade from EV4-D to EV4-E to comply

with the 2007 EEO reporting. Responsible for creation of ReportSmith reporting and

data integrity audits from their legacy Powersource and ADP application. Created

complex procedural SQL scripts for data cleanup and reporting. Created SQR program

for business specific solutions. Acted as liaison between VWR and ADP technical staff.

Trained an in-house replacement and provided knowledge transfer on all the

processes. Tested Benefits file processing for Cobra and other benefits providers;

consulted with ADP programmers on various resolutions.

Tyco Safety Products, www.tycosafetyproducts.com, Patched Upgrade EV4-D to

EV4-E, Oracle 9i, Enterprise V4

Applied the September 2007 EEO Patch Upgrade on an advanced tools ADP database.

Recreated Tyco Production environment in off-site lab; created Test, Devl, and Prod

databases. Installed Oracle, ADP EV4, and configured application and process servers.

Performed trouble-shooting on database performance and provided resolution.

Completed project on time and under budget.

DDB Worldwide Communication Group Inc., Communication Group; System

Administration support; SQLServer 7, HRizon 9

Acted as technical consultant on a HRizon V9 and SQLServer 7 system. Provided

consultation to the IT staff on resolving database server performance issues.

Assisted IT department in building a new environment to house the production

database for reporting purposes. Helped payroll department in resolving business

logic strategy to migrate from current system to new system. Edited more than 20

SQR programs to accommodate business logic. Installed ReportSmith and performed

trouble-shooting of issues for end-users. Reworked end-user security to allow proper

access to the HRizon system. Customized HRizon panels to accommodate payroll

daily process.

Equinox Fitness, Health Club; Database and Application Server Disaster Recovery

Implementation; SQLServer 2000; 800 Employees

Acted as lead consultant on ADP HRMS disaster recovery implementation. Equinox

had previously crashed their production database and application server; and wanted

Nhat Nguyen 4

to create “hot” redundant environments (application server and database server) to

production. The SQL Server database is replicated to a secondary server and the two

application servers (production and secondary) can connect to both the new and old

databases. This setup allowed for fail-over of the production application server the

database server or both. The setup was successfully tested on multiple disaster

scenarios.

The County of Middlesex, NJ, Government; Upgraded ADP Enterprise V2k to V4c

Advance SQLServer V7 to V 2000; 4000 Employees

Acted as DBA, Lead Upgrade Specialist, and Developer on an offsite advanced tools

upgrade. Installed and configured ADP EV4d according to ADP installation standards.

Migrated SQLServer 7 to SQLServer 2000 version. Upgraded the application from

Enterprise 2K to Enterprise 4C. Worked with clients on developing customs panels

and reports to accommodate their specific business needs. Converted SQR programs

and ReportSmith reports to comply with new EV4 database changes. Implemented

new EV4 security. Resolved java and database issues that affected the functionality

of the application.

Shurgard Storage Co., Advance Upgraded ADP Enterprise 2k to 4c Oracle 9i to; 500

Employees

Acted as Upgrade Specialist, DBA and Developer on an offsite advanced tools

upgrade. Upgraded the application from Enterprise 2K to Enterprise 4C. Worked with

client on developing custom panels and reports to accommodate their specific needs.

Converted SQR programs and Reportsmith reports to comply with new EV4 database

changes. Implemented new EV4 security.

GE, Real Estate Division; Carveout ADP Enterprise V-3 database to split one company

into two. Worked on Oracle 9i; 14000 employees

Acted as DBA and Programmer on an offsite database split. GE sold off their

subsidiary company to Storage USA. Developed a custom SQR program to terminate

all the employees in the old database and another SQR program to delete opposite

employee population from the new database. Deliverable were two databases, for

two separate companies. Worked with client to resolve many critical business

decisions.

Forbes, Publishing; Upgraded ADP Hrizon 9f on Oracle 8i to ADP Enterprise V4

Express on Oracle 9i; 500 Employees

Acted as DBA and Trainer on an offsite database upgrade. Converted database from

Oracle 8i to 9i. Upgraded the application from Hrizon v9 to Enterprise v4. Trained two

colleagues on how to do upgrade and how to execute the different processes and

behind the scenes steps. Taught them on how to utilize different Enterprise toolsets

to accomplish the job.

Volunteers of America, Nonprofit Housing; Upgraded ADP Enterprise V-2 on Oracle

9i to ADP Enterprise V-4 Express on Oracle 9i; 1500 Employees

Nhat Nguyen 5

Acted as DBA and Developer on an offsite database upgrade. Upgraded the

application from Enterprise V-2 to Enterprise V-4. Worked with clients on developing

custom scripts and reports to accommodate their business needs. Implemented new

EV4 security.

Publishing Clearing House, Publishing; Upgraded ADP Hrizon v9e on Oracle 8i to

ADP Enterprise V3 Express on Oracle 9i; 500 Employees

Acted as DBA and Developer on an offsite database upgrade. Migrated database from

Oracle 8i to 9i. Upgraded the application from Hrizon v9 to Enterprise v3. Worked

with clients on developing custom panels and reports to accommodate their specific

needs. Converted SQR programs to comply with new EV3 platform. Implemented

new EV3 security.

Robert Wood Johnson University Hospital of Hamilton, Hospital; Upgraded

ADP Hrizon v9m on Oracle 8i to ADP Enterprise V3 Charter on Oracle 9i; 2,000

Employees

Acted as DBA and Developer on an onsite database upgrade. Migrated database from

Oracle 8i to 9i. Upgraded the application from Hrizon v9 to Enterprise v3. Worked

with clients on developing custom panels and reports to accommodate their specific

needs. Converted SQR programs and Reportsmith reports to comply with new EV3

platform. Implemented new EV3 security. Helped clients transmitted parallel and live

payroll. Responsible for post production support.

Centennial Communication, Telecommunication; Upgraded ADP Hrizon v9f on

Oracle 8i to Enterprise V3 on Oracle 9i; 4,000 Employees

Acted as DBA and consultant on an offsite database upgrade. Engaged in client

interaction to resolve technical issues. Rebuild database to it original environment in

Oracle 8. Converted database from Oracle 8i to 9i. Upgraded the application from

Hrizon v9 to Enterprise v3. Created complex SQL scripts to migrate to new

environment. Tested the upgrade for quality assurance.

Visiting Nurses Association, Medical Care; Upgraded ADP Hrizon V9.k on SQL Base

to Enterprise v3 on SQL Server

Acted as DBA and consultant on an offsite database upgrade. Engaged in client

interaction to resolve technical issues. Converted database from SQL Base to SQL

Server. Upgraded the application from Hrizon V9 to Enterprise V3. Created complex

SQL scripts to migrate to new environment. Tested the upgraded application for

quality assurance.

Nhat Nguyen 6

Additional Work Experience

Developed three tier e-commerce Web sites using Java, Java-bean, Java-Script, Web-

Development, SQL, and Flash

Experience Summary

Roles: Implementation and Upgrade Consultant, Functional Payroll,

Functional HR, Technical Consultant, System and Database

Administrator, Installation Specialist

Applications: SQR, SQL, Java, C, C++, JSP, JavaScript, Web Development, Visual

Basic

Technical Skills: Database Upgrades and Implementations, Relational Database

Theory, Object Oriented Development, Software Engineering, Data

Structure and Algorithm, 3-Tier Client/Server Application

E-Tools: Data Mover, Application & Process Server, Record Editor, eBuilder,

Security Administrator, ReportSmith, Crystal Reports, ADP

Reporter, Business Objects Reporting

Database: Oracle 8i, 9i & 10G, Microsoft SQL Server, Access

Upgrade: ADP Enterprise- Hrizon v9 to Enterprise V2, V3, V4 and V5; Oracle

and SQL Server Systems

ADP Applications: Hrizon; ADP Enterprise V2, V3, V4 and V5; Payforce; HR

Anytime

Vendors: Trion, Success Factors, LMS, Aetna, ADP Enterprise E-Time,

Heat, Org Plus

Infrastructure Tools: Citrix Winframe

Education

Temple University, Bachelor of Science in Computer and Information Science

Contact this candidate