Click for printable pdf resume.
- DB2 Universal Database for z/OS & OS/390
- Database Management
- Conceptual, Logical and Physical Data Modeling
- Database Creation/Maintenance
- Leadership
- Project Management
|
SQL ERWin PowerDesigner Microsoft Project COBOL Endevor Recovery BAL LOTUS 123 DB2 Stored Procedures DB2 Admin for z/OS PowerPoint |
Bufferpool Tool CA DB2 Products REXX Microsoft Access PL/1 IMS Windows Environment PowerPoint DSN1COPY DB2 Table Constraints DB2 Object Compare for z/OS SQL/PL |
JCL ISPF DB2 Utilities Microsoft Excel C FORTRAN Lotus Notes Freelance DB2 Connect DB2 Triggers DSN1PRINT BMC DB2 Products |
Education, On-site education 2001 -
Performed on-site education for Themis, Inc. and Sheryl M. Larsen, Inc. at various customer locations in the US. Subjects include: Beginning SQL, Intermediate SQL, Imbedded SQL, Advanced SQL and Performance, DBA, Stored Procedures, and DRDA & DB2 Connect. Consistently receive top scores from students. Performed consulting assignments for various clients. Tasks included Data Modeling and Data Analysis as well as the developing of Stored Procedures, User Defined Table Functions and complex SQL. Implemented views to perform exception based geopolitical data queries.
ROYAL & SUNALLIANCE: 1994 - 2001 One of the 20 largest property and casualty insurers in the U.S., with more than 7000 employees.
DB2 Database Administrator, Database Department, Charlotte, NC 1995-2001
Performed database administration including object creation, backup and recovery, security, reorganizing, and performance tuning. Performed conceptual, logical and physical data modeling for many projects.
Converted claims database from IMS to DB2 resulting in successful on time delivery, improved response time, and a maintainable database that has accommodated subsequent requirement changes with minimal impact.
- Taught and helped users with complex SQL resulting in improved response time and CPU time.
- Initiated the effort to convert all DB2 objects from PDB managed to DFSMS managed data sets resulting in significant reduction of DBA effort for that activity.
- Initiated the use of data modeling tools that greatly enhanced the quality of data design.
Developed COBOL programs to extract and summarize data from DB2. Developed ACCESS applications for analysis of that data.
INTERNATIONAL BUSINESS MACHINES, Inc. : 1970-1993 With over 300,000 employees, develops and manufactures advanced information technologies.
Programmer, Check Image Development, Charlotte, NC 1992-1993
Led Project Management Team for a multi-million dollar four product software development Personal effort contributed to an on time GA.
Programmer, IBM Insurance Industry, Newport, RI & Hamden, CT. 1988-1992
Developed and demonstrated to IBM insurance customers an OS/2 PM Life Agent workstation prototype that resulted in the successful formation of a joint development partnership. Led the effort to define the system architecture requirements for a Pension and Annuities system for a major insurance company.
Selected to present workstation prototype to numerous customers and at a number of conferences throughout North America.
System Architecture was finished on time and under budget.
Proposal support, Manassas, VA 1986-1988
Performed technical and schedule analysis of the Mk2 Fire Control System for Submarines, a $400 Million bid. Performed independent assurance of the software sizing estimate for a major Navy proposal, a $2.5 billion bid, to provide a Command and Control System for a new submarine.
Manager, Monitoring Subsystem Development, Newport, RI 1985-1986
Managed department of nine programmers and engineers, responsible for engineering, software development, testing and training system development for the Trident submarine on-board Noise and Vibration Monitoring Subsystem (100K SLOCS). Performed program management of scheduling and customer interfacing.
Project completed on time, under budget and was recognized for exceptionally high product quality.
Lead Target Motion Analysis Programmer, Newport, RI 1975-1985
Led development programming effort, of Fire Control Subsystem (300K SLOCS) for the Trident submarine.
Developed training and graphical display software as well as background processing programs. Generated machine code patches for the on board military computer resulting in quick fixes. Performed system engineering and led programming responsibility for the complex algorithms of Target Motion Analysis.
Recognized by peers, management and customer for expertise in finding solutions to precision and timing problems.
Co-defined and implemented a new algorithm for target motion analysis that earned an Outstanding Innovation Award.
Programming for a ballistic missile defense system, Morris Plains, NJ 1970-1975
Wrote software that generated threat input for real-time exercise of Safeguard ballistic missile defense system including coordinate transformation routines, complex algorithms of targeting, integrators and scenario generation programs. Served as lead programmer for User Support and Software Maintenance. Recognized by peers and management for PL/1 and debugging expertise
Member of the IDUG North American Conference Planning Committee(NACPC) 2000, 2001, 2002, 2003
Southeastern Inter-Relational Database Users Group(SIRDUG)
President 2000, 2001
Board of Directors 2003
The Data Warehousing Institute(TDWI)
SO YOU WANNA GET THE RIGHT ANSWERS-Numeric and Dates - Delivered to IDUG North American and European conferences in 2000
"LET CARTESIAN PRODUCTS BE YOUR FRIEND - BUT PROCEED WITH CAUTION" - Delivered to IDUG European conference in 2002
RECURSIVE SQL for DUMMIES - Delivered to IDUG 2004 European and 2005 North American IDUG Conferences
" Need a Date? Here's DB2's Answer- Using Chronological Data in DB2 Chronological Data Type Formats" in the IDUG Solutions Journal - Volume 11 Issue 3 December 2004
"Let Cartesian Products be Your Friend - But Proceed With Caution" - IDUG Solutions Journal - Volume 8 Issue 3, 2001.
"DB2 for z/OS DM Tools for Database Administration and Change Management" - IBM Red Book.