Analyst Manager

Title:Program Manager

abphzn@r.postjobfree.com

Document

Source below

NAME: preston, sheila

ADDRESS: **** ***** **

ADDRESS2:

CITY: broomfield

STATE: CO

ZIP: 80020

CANDIDATE ID: 2268312

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: No -

JOB WANTED: Any

RATE NEEDED: Open

TELEPHONE: 303-***-****

EMAIL: abphzn@r.postjobfree.com

HOMEPAGE:

COMMENTS:

HOTTEST SKILLS: oracle =3+ yrs, dba =5+ yrs

REVISION: 15-NOV-01

YOE: 5

RESUME:

EDUCATION: Bachelor of Science

in Computer Science for Business (4.0/4.0 GPA)

DeVry Institute of Technology,

Kansas City, MO (1983)

CERTIFICATIONS: I have completed the first test towards my Oracle 8i DBA certification. I

should have all tests completed within the next few months

.

EXPERIENCE: Over 18 years experience in data processing, with more than 10 years

experience as a DBA.

Data Base Administrator/Lead Technical Analyst

10/96

- PresentEDS, MCI/Worldcom

DBA for the development, user-test, and production databases running applications used

for bad debt monitoring on long distance calls, centralized blocking of long distance

calling, and producing letters notifying customers of various account actions. These

applications consist of over 400 tables and indexes with approximately 375 functions,

procedures and packages, many of which are utilizing the Oracle Transparent Gateway for

DB2. The production database server is on a Sun E5500 running Solaris 2.6 and holds

approximately 100g of data managed with Veritas file systems.

Responsibilities include running and monitoring the daily backup, coalesce and analyze

functions, as well as continual performance monitoring and tuning. Control change

management of all new/modified procedures and functions into the production and user-test

environments. These daily functions are accomplished using Unix c-shell and k-shell

scripts, Unix crontabs, SQLPLUS, PL/SQL, SQL-Station, and DBArtisan.

Installed and tested the upgrade of Oracle from release 8.0.5 to release 8.1.6 and

currently working on the upgrade to 8.1.7. Created UNIX scripts to run a variety of SQL

processes in background. Assist with testing of all upgrades to the Oracle Transparent

Gateway for DB2.

In addition, was originally the primary DB2 DBA in the OS 390 environment and now provide

backup support and mentoring of the current DBA.

Also, currently responsible for the high-level design on all projects, as well as the

supervision of 5 programmer analysts. The main application consists of a mainframe

component written in COBOL using DB2, a Power Builder GUI interface, and the Oracle

database component using PL/SQL and SqlPlus.

Data Base Administrator/ Programmer Analyst

5/94

- 10/96CIBER, Inc

.

DBA and programmer analyst

at various sites.

Shared DB2 DBA responsibilities for all production maintenance and performance tuning of

102 databases containing approximately 950 tablespaces with over 4000 tables and indexes.

Designed and implemented utilities to automate the daily tasks of monitoring the tables,

producing informational reports and submitting the necessary maintenance jobs.

Primary IMS DBA responsibility for 3 production IMS regions containing approximately 85

databases and indexes. Coordinator for all IMS support activity within 4 states,

encompassing 70 IMS control

regions.

Developer on various COBOL/DB2 and COBOL/IMS projects, performing analysis, design, code

and test.

Programmer Analyst

10/90

- 4/94US West

Lead programmer on the design and rewrite of a large bill formatting subsystem written in

COBOL II using IMS DB, DB2 and VSAM access.

Lead technical analyst and lead programmer for a variety of projects to make major

enhancements and minor changes to the new bill formatting system.

Involved in the coding and testing of major enhancements to the bill calculation

subsystem.

Data Base Administrator/Programmer Analyst

7/83

- 10/90Federal Reserve Bank of Kansas City

DBA for the IMS production and test regions. Responsible for all backup/recovery

functions, database creations and modifications, and daily performance monitoring and

tuning.

Responsible for maintaining and enhancing the DBA ISPF dialogs which provided for

automation of most routine daily duties, including DBRC processing.

Designed a process to utilize DBRC to generate the JCL necessary for reorganizing

databases and performing pointer verification.

Developed DBA procedures for CICS table maintenance and for backup, recovery, and

reorganization of CICS VSAM datasets.

Provided consultation to the programming staff and taught courses on IMS programming

concepts.

Installed a Banking Statistics system, including the design of necessary interfaces and

training of the programmer and user staff.

Involved in the analysis, design, code, test, and implementation of a statistical data

collection system.

Contact this candidate