LOI V. NGUYEN

abmrss@r.postjobfree.com 206-***-**** (c), 206-***-**** (h)

SUMMARY

. Extensive range of experience in Information Technology including

database administration, application design and development.

. Positions held included Database Administration, Senior Programmer

Analyst, Project Leader, Consultant and Network Production Support.

AREAS OF EXPERTISE

. Hardware: Mainframe Z/OS, distributed severs running on Windows and HP

UNIX platforms.

. Software: SQL, SQL Sever, T-SQL, Oracle, PL/SQL, HP UNIX, DB2, DB2

Connect, Visual Explain, IBM Tools for DB2, TMON, BMC software for DB2,

CICS (Macro and Command Levels), DL/1, Microsoft Windows, MS Office,

Visual Basic, Access, C, PL/I, Micro Focus systems, COBOL, COBOL II, IBM

Assemblers, JCL, VSAM, TSO/ISPF, REXX, Roscoe, IBM utilities, ChangeMan,

ENDEVOR.

. CICS interactive debugging tools: CEDF, EZTest, Intertest, Expediter.

. Skills: Database management, systems analysis, application design,

development, documentation, structured methodologies, project management,

users training.

PROFESSIONAL EXPERIENCE

PEMCO Corporation Computer Services, Seattle, WA 1988 -

2009

SQL Server DBA 2002 - 2009

Managed multiple instances of an in-house developed SQL Server database

application - OneSource. Application joined profiles of all PEMCO

companies' employees and contractors into one central location. Database

serves as input data source to many in-web applications to support multiple

companies.

V Programmed, maintained and debugged T-SQL stored procedures.

V Wrote ad hoc queries.

V Troubleshot application and server errors.

V Created and managed database backups, maintenance jobs and alerts.

V Replicated the database to other servers for users' in-web

applications data access.

V Created user accounts, added permissions to database access and audit

access violations.

V Installed patches and upgraded servers to newer versions after testing

them in Dev. domains.

V Installed and configured SQL Server 7, 2000 and 2005.

DB2 - DB Administrator 2002 - 2009

. Managed in-house developed database system for the Information Data

Warehouse - IWH.

. Managed a very complex database system for client/server insurance system

- Exceed.

. Managed a multiple subsystems of databases for Federal Home Loan Bank -

FHLB.

. Supported DB2 conversion from version 5 to 7 and 7 to 8.

. IWH:

V Created COBOL programs to extract data on VSAM and sequential files

from old insurance system and loaded transformed data to DB2.

V Managed users' access to databases.

V Managed space allocation and monitored data growth.

V Converted users managed space allocation to Storage Group and SMS.

V Built and managed data-marts from central database to support

individual dept.'s data needs.

. Exceed:

V Directly responsible for installation, management and tuning of

databases for critical insurance system with over twelve environments

for 24/7availability - each environment has over 1000 tables.

V Supported application development team and helped tuning their

application programs for maximum performance on DB2 insurance system.

V Created and monitored database backup jobs.

V Managed users' access to databases.

V Partitioned large tables to multiple-partitioned for ease of

maintenance and faster data access.

V Maintained Rexx programs to generate reorg jobs reorganizing data on

weekly basis.

V Created and maintained data migration jobs to copy data from one

environment to another.

. FHLB:

V Managed multiple subsystems databases for the banking systems.

V Supported developer team throughout development cycles and implemented

objects to production.

Oracle DBA 2001 - 2002

Directly responsible for multiple instances of critical Oracle databases

for client/server insurance system - PRIME. System ran on HP UNIX servers.

V Installed, managed and monitored multiple instances of Oracle

databases on three HP servers.

V Programmed, Maintained and Debugged PL/SQL stored procedures.

V Wrote ad hoc queries.

V Wrote HP UNIX scripts to backup databases.

V Wrote HP UNIX scripts to migrate data from one instance to the other.

V Created user accounts, added permissions to database access and audit

access violations.

Network Engineer 1997 - 1998

Responsible for building and installing new NT servers to support company's

growth due to increase usage of the client server environment.

V Built first NT System servers in the company using Master Domain model

and RAID arrays.

V Managed shared network drives.

V Installed sniffer tools to monitor network traffic to identify network

bottle neck areas and network failures.

V Managed NT user logon accounts and assigned permissions to shared

network drives.

V Backed-up users' data on network drives to tapes for archives and

restored them on request.

Sr. CICS Programmer Analyst 1988 - 2001

. Developed, maintained and supported many batch and online application

programs using COBOL and Assembler languages.

. Sole analyst responsible for supporting entire CICS (Macro and Command

Levels) insurance system - PMSC.

V Analyzed and supported year 2000 date compliance conversion project on

PMSC system. Key responsibilities included analyzing and documenting

areas in CICS programs to convert - both in COBOL and Assembler.

Tested and implemented converted system.

V Developed and supported Employees Education Tracking system for PEMCO

HR using Visual Basic and Access database.

V Participated in developing first insurance system's PC project - Rate

Disk System - using Micro Focus Dialog System, Micro Focus COBOL and

some Visual Basic.

V Participated in Contract Management System pilot project using CICS

and DB2.

V Installed, tested and enhanced the converted Alpha Cross Reference

System with extensive customization in record time. System served as

central depository information tracking system of all customer

information. The system was converted from CICS Assembler Macro Level

to CICS COBOL Command Level.

V Maintained and tuned a very complex set of I/O modules, written in

Assembler language, for the CICS system to access data in VSAM KSDS

and ESDS combination.

V Tuned weekly batch processing programs to reduce run time from seven

hours per run to just over two hours per run. Saved thousands of

dollars per month in processing costs and made data available to users

sooner each week.

V Enhanced and developed many utility programs for use by programming

staff.

OTHER RELEVANT EXPERIENCE

United Pacific Insurance Company, Federal Way, WA

Sr. CICS Programmer Analyst

Responsible for stabilizing the online CICS system after the implementation

of the manually rated system from PMSC.

Technical lead for a team of four developers and contractors to convert an

existing application from CICS Macro level programming to CICS Command

level programming.

Data Systems Technology Inc., Columbia, South Carolina

Consulting Analyst

Provided CICS consulting services to Westinghouse Electric Corporation,

Nuclear Fuel Division. Lead a team of five developers to automate the

chemical laboratory's data gathering and recording system using CICS and

DL/1.

Policy Management System Corporation (PMSC). (Now Computer Science

Corporation (CSC) Columbia, South Carolina

Lead CICS Programmer Analyst

Led a team of six developers to develop a very complex CICS insurance

system. PMSC sold this system to many large insurance companies worldwide.

Awarded Employee of the Month as a result of quality work - PMSC had over

1000 employees in programming staff at the time

EDUCATION TRAINING & CERTIFICATION

Bachelor of Science, Computer Science, University of South Carolina,

Columbia, SC.

Associate of Science, Computer Programming, Midlands Technical College,

Columbia, SC.

TRAINING and CERTIFICATION

IBM Certified for Database Administration for DB2 for Z/OS, Version 8

SQL Server database administration training at SQL Soft Institute

Oracle Database administration training at Oracle University

Contact this candidate