Title:Associate
******@******.***
Document
Source below
NAME:,
ADDRESS:
ADDRESS2:
CITY:
STATE: CA
ZIP:
CANDIDATE ID: 2921985
US CITIZENSHIP:
EDUCATION:
EXPERIENCE: 0
WILL RELOCATE: No -
JOB WANTED:
RATE NEEDED:
TELEPHONE: 925-***-****
EMAIL: ******@******.***
HOMEPAGE:
HOTTEST SKILLS: database, db2, sql, oracle, unix, engineer, programming, cobol, informix,
software engineer, database administrator, peoplesoft, programmer, c++, cics, java,
kernel, microsoft, risc, solaris
REVISION: 08-SEP-02
RESUME:
NAME:
ADDRESS:
CITY: San Ramon
STATE/PROVINCE: California
ZIP/POSTAL CODE: 94583
COUNTRY: US
EMAIL: Home: ******@******.***
PHONE: Home: 925-***-****
CANDIDATE ID:
CITIZENSHIP: United States
Citizen or National
EDUCATION: Bachelor Degree
EXPERIENCE: 21 Years
WILL RELOCATE: No
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED: $85,000/yr
HOMEPAGE:
COMMENTS:
HOTSKILLS:
Nancy Y. Chang
5110 Canyon Crest Drive
San Ramon, CA 94583
Telephone: 925-***-****
(home)
(work)
Email Address: ******@******.***
Qualification: With an over 18 years as Database
Administration, System Administrator and
Software Engineer in various databases
on different platforms. Extensively
support and develop on data warehouse
software package which interfaces with
various RDMBS and platforms.
Hardware: NCR35555, HP-UX, IBM 370, IBM 380X,
IBM 3090, IBM ES/9000, RISC/600, HP-300,
Compaq Proliant, Unisys
OS: Windows NT 3.51 and 4.0, Windows 3.1,
Windows 95, Windows 98, HPUX, Solaris,
OS/MVS, MVS/XA, MVS/ESA, MPE, VAX
DBMS: Oracle, Sybase, Microsoft SQL Server 7.0,
DB2, IDMS, IMS, Datacom/DB, VSAM, FOCUS,
ALLBASE, Red Brick Warehouse, Informix
Language: IBM Assembler, SAS, DB2 SQL, IMS DL/I,
IDMS DML, COBOL, ADS-O, IDEAL-DB2, C,
Tcl, Unix Shell, Java
PROFESSIONAL EXPERIENCE:
March 1998
PeopleSoft, Pleasanton, CA
to
Present Sr. DBA - Work on FSOnline benchmark
Tool Kit. The Tool Kit has been used by
various hardware vendors to do the performance
benchmark. Make performance and tuning efforts
for the Tool Kit on both Oracle and MS SQL 7
database in Unix and NT platforms.
October 1995
Sybase, Emeryville, CA
to
Feb. 1998
Staff Engineer I - Focus on Sybase SQL
Server performance and tuning in
Windons NT. Participate Compaq TPC-C
benchmark for Sybase SQL Server on
Windows NT. Work on Gryphon (11.5 ASE)
Beta onsite engineer support. Maintain
Sybase SQL Server and Adaptive Server.
Work at NT Kernel Group.
April 1994
Prism Solutions, Sunnyvale, CA
to
October 1995
Platform Software Engineer - Install
Sybase, Informix, Oracle, Teradata,
Red Brick Warehouse on Unix.
Develop Prism's data warehouse product
which interfaces with various databases
on different platforms in C on Windows
and IBM Assembler and COBOL or MicroFocus
COBOL on each target platforms. Develop a
lot of major platform specific interfaces
to handle different data types conversion.
August 1993
Lucky Store, Dublin, CA
to
April 1994
Senior Software Engineer - Work on
performance and tuning in DB2 environment
and Client/Server Pilot project. Use
Informix as the database on Unix.
May 1991
Longs Drug Stores, Walnut Creek, CA
to
July 1993
Senior Database Administrator -
Work on 3 projects in Client/Server open
systems:
Using 3-Tier Client/Server open systems to
design, implement and develop a major Sales
Tracking System (Decision Support System).
Perform major tuning for Longs in:
1.) Regarding CPU usgae, dispatching
priority, DASD activities, CICS
shutdown statistics for DB2 in
MVS/ESA. DASD planning and
implementations so DB2 datasets
can be evenly distributed among
packs based on activities and usage.
2.) Redesign DB2 database and review all
the SQL coding to enforce performance
resulting in 60% reduction of CPU usage.
3.) Support all Long's RDBMS which are DB2,
Allbase, Red Brick Warehouse, and
SQLBASE in different platforms.
Sept. 1987
American President Line, Oakland, CA
to
May 1991 Senior Database Performance Specilist
Developed BATCH SERVICE REGION system
which downloads data to System/36 in Asia
when data in the mainframe on-line changes
and the systems is capable of multi-tasking
simulaneously scheduling batch sweeps of
the database while answering requests for
data from on-line system communicated SVC
calls.
Developed IPCS-IDMS for dump reading.
Use SAS for post-implementation performance
analysis.
Sept. 1985
ESL, A Subsidiary of TRW, Sunnyvale, CA
to
Sept. 1987
Senior Database Administrator - Responsible
for installations, technical services and
education for IDMS Programmers.
June 1983
GTE Directory Corporation, Chicago, Illinois.
to
Sept. 1985
Database Systems Programmer in Systems
Support Group. Responsible for on-site
technical services.
June 1983 Held programming positions at Montgomer Ward
prior to and Honeywell in Illinois.
Jan 1978
Education: Bachelor of Sciences
in Computer
Science
from University of
Illinois,
December 1981.
UCB Extension
WIN32 Programming for Windowns NT,
Computer Networks, Internetworking with
TCP/IP, C Language, Obejct-Oriented
programming with C++, Unix Internal,
Unix Network Programming
Oracle
Oracle 8 Administration
Oracle 8 Performance and Tuning
Oracle 8 SQL Performance and Tuning
PeopleSoft
Tools I and II
PeopleCode
Application Engine
IBM DB2
Fundamental, Database Administration,
System Administration, Security,
Recovery, Performance and Tuning,
Performance Estimating
IBM SMP/E