Summary

• A Senior Database professional with extensive experience in large and complex database environments. Excels in all areas for DB2 for z/OS, DB2 LUW, Microsoft SQL Server, and IMS DB/TM DBMS environments. Superior abilities in performance tuning, problem identification, and problem resolution. Exceptional analysis and problem solving skills. Expertise identifying and writing requirements and specifications. Proficient in logical/physical database design.
• Over twenty 25 years of experience in the insurance industry Life, Health, Annuity, and Property and Casualty P C .
• In the most recent seven years performed as a Sr. Database Administrator working DB2 z/OS, DB2 LUW and IMS environments. Systems and Applications Database Administrator activities involved:
• Performance tuning. Troubleshooting, and resolving space issues.
• Performing logical and physical database design/modeling.
• Conducting infrastructure, performance and capacity planning.
• Creating and performing backup, restore, and disaster recovery procedures.
• Assisting Developers in database related tasks.
• DBMS Installation and Configuration
• Prior to Transamerica, performed as a Sr. Systems Programmer, Sr. Database Administrator, Database Developer, and Systems Specialist.

Three examples of accomplishments include:

Confidential

Initiated the redesign and implementation of a Management Information System database interface resulting in over 600,000 in bottom line savings.

Confidential

Received a spot award for resolving a serious space issue with an IMS database.

Confidential

created a DB2 Provider Database for HMO, PPO, and Point of Service Products. This database consisted of over a hundred logical and physical tables. Project activities included data modeling, logical design, physical design, and system integration.

Computer Languages

Computer Software

Experience

Confidential

Senior Database Analyst and Administrator

• Performed DB2 for z/OS, DB2 LUW, Microsoft SQL Server, Sybase, IMS, and CA-Datacom data base administration for a large life insurance organization,
• Conducted performance measurement and capacity planning activities.
• Created and maintained backup, recovery, and maintenance procedures.
• Evaluated DBMS-related application changes and recommended improvements in SQL calls and web-based service requests.
• Installed, configured, and converted databases and software to new releases.
• Information integration in Windows and AIX Server environments.
• Provided 24 by 7 on-call support for the Database Administration area.

Confidential

Systems Software Consultant

Serving the AFP Division of AEGON Americas, Kansas City MO

• Performed IMS and DB2 data base administration for a large life insurance organization,
• Conducted performance measurement and capacity planning activities.
• Created and maintained backup, recovery, and maintenance procedures.
• Evaluated DBMS-related application changes and recommended improvements in SQL calls and web-based service requests.
• Supported WebSphere MQ, WebSphere Message Broker, DB2 LUW, and DB2 for z/OS.
• Information Integrator in a Windows Server environment.
• Provided 24 by 7 on-call support for the Database Administration area.

Confidential

Systems Software Consultant

• Performed system generation, definition, and implementation activities for IMS/DB and IMS/TM, including support of High-Availability Large Data Bases HALDB .
• Provided IMS data base administration services to a large corporation providing stock and security processing services.
• Provided z/OS Assembler Language and COBOL programming support for in-house developed database system exits and utilities.

Confidential

Systems Software Consultant

• Provided design and programming for IBM mainframe and midrange applications including CICS, DB2, IMS, and COBOL for a large agency of the State of Missouri.
• Provided database design and modeling assistance in constructing a new statewide application system.

Confidential

Senior Data Base Systems Programmer

• Provided design, programming and debugging support for IBM mainframe applications including CICS, DB2, and COBOL.
• Installed, maintained, and supported all mainframe DBMS software including IBM DB2 for z/OS, DB2 LUW, CA-Datacom, and CA-IDMS.
• Installed, maintained, and supported all mainframe messaging and ETL software including IBM Websphere MQ and DataMirror Transformation Server.
• Installed, maintained, and supported all mainframe DBMS-related utility and monitoring software including BMC Utilities for DB2, BMC Mainview for Websphere MQ, BMC Patrol for Websphere MQ, CA-Insight, Erwin, PowerDesigner, and Compuware File-Aid for DB2.
• Provided z/OS Assembler Language programming support for in-house developed DB2 Call Attach Facility, DBMS Utilities, and system exits.

Confidential

Systems Software Consultant

• Provided design and programming for IBM mainframe applications including CICS, DB2, IMS, COBOL, Websphere MQ, VTAM, TCP/IP and Assembler.
• Provided programming, DBA, and DA services as required by life, property/casualty, and health insurance brokers.
• Provided design, development, and support to insurance brokers and health care providers as an independent contractor.
• Provided customized programming solutions for mainframe and micro-based systems in business office environments.

Confidential

Data Base Analyst

• Designed, programmed, and implemented data access facilities for CICS and IMS programs needing data from IMS data bases and DB2 tables. These programs, consisting of over 100 modules, are used by most major application systems in the Local Telephone Division for Customer Billing, Accounts Receivable, Telephone Equipment, and Telephone Facilities applications.
• Documented user requirements and wrote program specifications in support of batch and on-line programming assignments.

Confidential

Senior Software Engineer

• Provided consulting services to Sprint designing and programming a middleware data layer to isolate CICS and IMS application programs from direct access to IMS data bases. Components of the system included batch COBOL, CICS, IMS/DB2, and Assembler programs as well as micro-based maintenance components written in C .
• Designed and programmed cross-systems interfaces for CICS and IMS applications using DB2 and Websphere MQ facilities.
• Documented user requirements and wrote program specifications in support of batch and on-line programming assignments.

Confidential

Assistant Vice President

• Led programming teams to design, develop, and maintain commercial property/casualty and group life systems in a multi-platform environment including both mainframe and micro-based systems. Mainframe on-line programming for property/casualty and group life systems utilized COBOL, CICS, and VSAM.
• Led design and programming efforts for the development of CICS on-line surety systems for the largest provider of surety services in the United States.

Confidential

Information Technology Consultant

• Designed, programmed, and implemented health insurance software using COBOL, CICS, and IMS/DB for a large Eastern U.S. Blue Cross and Blue Shield company.
• Met with client personnel and documented user requirements as functional and technical specifications.

Confidential

Director, Application Systems

• Directed and managed four large project teams in support of health insurance clients, including five large Blue Cross and Blue Shield companies.
• Designed and implemented health insurance solutions for large health insurance enterprises using COBOL, CICS, IMS, and DB2 facilities.
• Performed the role of data base administrator and data modeler for a new health and life system in an MVS, CICS, DB2, and IMS environment.
• Met with client personnel and documented user requirements as functional and technical specifications.

Confidential

Director, Technical Support and Application Systems

• Oversaw the acquisition and implementation of a new Information Technology department serving multiple hospitals and clinics.
• Wrote and implemented design and programming standards.
• Supported CICS/TM and IMS/DB in a 24 by 7 real time environment.

Confidential

Data Center Manager

• Managed fifty data center personnel in a 24 by 7 environment.
• Supported Information Services processing for all U.S. and overseas subsidiaries of Baxter Travenol.

Confidential

Senior Systems Programmer

• Installed and maintained infrastructure software products such as MVS, IMS, and CICS.
• Worked with IMS DBA's to configure and install real-time application data base environments.
• Initiated changes that allowed the Data Center to exceed all response time and availability service level goals.