Project Manager Data

JAMES F. KEEGAN

** **. ******** ***

201-***-****

Westwood, NJ 07675

********@*****.***

SUMMARY

Excelled as IT professional for over 30 years. Designed and programmed in

multiple languages and tools (FORTRAN, COBOL, Basic, Focus and, most

recently, K shell scripting for UNIX). Mastered DBA skills for IDMS, DB2,

Sybase, and Oracle. Also worked with MS SQL Server and UDB. Led

Application Development teams and performed as an individual contributor.

Roles have included Programmer, Systems Analyst, Project Manager, and Data

Base Administrator (DBA). Industry experience covers Financial,

Communications, Entertainment, and Engineering.

PROFESSIONAL EXPERIENCE

UBS (formerly Paine Webber), Weehawken, NJ

1996 - Present

Data Base Administrator (DBA)

. Sybase / Oracle DBA: design and develop database objects (tables,

indices, triggers, stored procedures, and views), utilizing skills in

data modeling, capacity planning, and data storage design.

. Performed troubleshooting for performance, data, and application

issues.

. Experienced in data security and backup and recovery.

. Sybase Replication

. Developed extensive suite of Sybase stored procedures to facilitate

DBA work.

. Designed and implemented the Resource Management Account (RMA)

Interactive Voice Response (IVR) database utilizing alternate data

sources for fail-safe redundancy, coding multiple listeners in the

Interfaces files.

. Designed and implemented an automated solution to the limit of 65,535

Sybase login IDs.

. Designed and implemented procedure to maintain synchronization of

Sybase logins from primary to secondary instance.

. Designed and implemented an automated process to replicate Oracle

production data into the QA database.

. Experienced with ERwin Data Modeling tool, 3rd Normal Form data

models.

. Experienced in using Autosys to schedule production jobs.

. Extensive k-shell scripting.

. Experienced with AIX and Solaris operating systems.

. Installed and upgraded Sybase Dataservers on both IBM and Sun hosts.

. Installed and upgraded Oracle Database Instances on IBM and Sun hosts.

Taught a quarterly Sybase TSQL course to programming staff.

. Fundamentals of Relational Databases

. Third Normal Form

. Data Base Objects

. DDL

o Create

o Alter

o Drop

. DML

o Insert

o Update

o Delete

o Select

. Data Storage

o Clutered Indexes

o Nonclustered Indexes

o Devices

. Stored Procedures

. Triggers

. Relational Integrity

The Dreyfus Corporation, New York, NY

1988 - 1996

Data Base Administrator (DBA) (1992 - 1996)

. Performed DBA functions using Sybase, IDMS, and DB2.

. Installed and upgraded Sybase Dataservers on both IBM and Sun hosts.

. Created and maintained database objects in Sybase Dataservers.

. Created and maintained database objects in IDMS DBMS.

. Performed back-ups and restores, as needed.

Programmer / Analyst (1988 - 1992)

. Developed and maintained programs using COBOL/IDMS and ADSO.

PRIOR EXPERIENCE

Thompson McKinnon, Group Manager

. Implemented and Supported the Municipal Bond Desk System

Western Union / EDS, Project Manager

. Modular Billing System

American Broadcasting Co., Systems Analyst

. Local Station Rating System

Tymshare, Computer Consultant

Permutit, Computer Programmer

Bergen Community College, Adjunct Assistant Professor, Mathematics

US Army, First Lieutenant, Finance Corps

EDUCATION

MS, Computer Science, Fairleigh Dickinson University

BA, Mathematics, Providence College

Contact this candidate