SUMMARY:

• Developed Bind Manager and Path Checker for IBM DB2 Tools.
• Developed Express Hints to manage setting DB2 Hints through ISPF Panels.
• DB2 / SAP tuning and availability
• IDAA implementation in DB2 / SAP environment.
• Personally responsible for SMP/E maintenance for DB2 Subsystems for V8, V9, V10 and V11
• Used Confidential to insure the stability and performance of the Development Environment.
• Wrote and maintained stored procedures, CLIST, and other programs as needed.
• Developed QMF feature to explore EXPLAIN STATEMENT CACHE ALL data.
• Developed programs to use the Plan Table data from the Statement Cache.
• Developed programs to assist in Tuning SQL where the DB2 Optimizer had rewritten the SQL
• Responsible for DB2 REORGs, Load / Unloads, etc.
• Developed both Stored Procedures and PL/SQL to identify differences between Dynamic SQL as written and the results of DB2 SQL Rewrite.
• Upgraded DB2 V10 on our ADCD System
• Installed DB2 V11 on our ADCD System
• Upgraded four production DB2 V10 subsystem to DB2 V11

SKILL:

• Worked as team lead and DBA mentor for DB2 Migrations from both V8 and V9 to V10,
• Lead DB2 Migrations from V10 to V11 CM and NFM
• Installed and configured DB2 Z/OS including underlying VSAM datasets, DSNZPARMs, and bufferpools
• Consultant on DB2 database applications architecture.
• Version migrations on System z from DB2 V2 to V10
• Tuning on DB2 and VSAM systems resolving cost impacting performance problems
• Experienced using tools and utilities from IBM, CA, and BMC
• Extensive application COBOL, PLI and ALC coding for database access
• Implement multi - platform solutions
• Installed and configured DB2 on Windows, AIX, and Linux (including z/Linux)
• Experience with 32 and 64-bit architectures
• Performance tune and health check services

TECHNICAL SKILLS:

• COBOL
• C, C++
• ALC
• PLI
• REXX

PROFESSIONAL E XPERIENCE:

Confidential

Responsibilities:

• Lead both DB2 consultants and DB2 Software Developers.
• Sold Bind Manager and Path Checker to IBM Tools in December 2012
• Responsible for SMP/E maintenance for DB2 Subsystems for V8, V9, V10 and V11
• Did several sites visits for IBM Tools for consulting on tool use and SQL Performance issues
• Held consulting jobs as needed to assist in cash flow. Three examples are below.

Confidential

DB2 System Administrator

Responsibilities:

• V11 Migration and Performance
• Migrated SAP DB2 Subsystems from V10 NFM toV11 New Function Mode.
• Responsible for SMP/E maintenance for DB2 Subsystems for V8, V9, V10 and V11
• Developed REXX and SQL procedures to capture both SQL, EXPLAIN data, and Statement Cache data both before and after V11 Migration to assist in finding performance changes.
• Worked on INSLITP issues with SAP Applications
• Worked with IBM on performance issues.

Confidential

DB2 System Administrator

Responsibilities:

• Team Lead and Mentor for DB2 V10 NFM Migration and install of CICS V5R2.
• Migrated 4 DB2 Subsystems from V10 CM to New Function Mode.
• Migrated Db2 Subsystem to V11 CM
• Developed methodology to alter Simple Tablespaces to UTS format. There are approximately 200 Simple Tablespaces per DB2 Subsystem.
• Planned for DB2 V11 migration for last quarter of 2016.
• Automated daily production from multiple jobs to a single job using LISTDEF and TEMPLATE structures.
• Installed and tested CICS V5R2 on two LPARs. Moved CICS V5R2 into production.
• Trained multiple staff members in basics of DB2 V10.

Confidential

DB2 System Administrator

Responsibilities:

• Team Lead and Mentor for DB2 V10 Migration
• Resolved the 6-month project in 3 months.
• This involved four subsystems that had not had maintenance in three years.
• Trained two DBAs and several developers

Confidential

DB2 Performance and Data issues

Responsibilities:

• Technical Consultant to the team migrating from one system design to another.
• Resolved several issues missed with the original data model that impacted completion.
• Removed data issues that bottlenecked DB2 performance.
• Actions resulted in operational cost reductions.

Confidential

DB2 System Administrator

Responsibilities:

• Development of DB2 System to replace VSAM based Credit Card system
• Managed both DBA and Data Modelling teams.
• Resolved Data Modelling issues that heavily impacted DB2 source development.
• Brought the effort out of the Data Modelling phase and into DB2 source development.
• Resolved both VSAM Production issues and DB2 Project implementation concerns.
• Brought the DBA efforts in on schedule and just under budget.

Confidential

Consultant to EVP of International Sales

Responsibilities:

• Handled European Pre-Sales Support development resolving both morale and sales relationship issues.
• Assisted Sales in presenting products where a representative from the Home Office was required.
• Integrated with National Sales efforts in the UK, Germany, France, Italy, Spain, and Denmark.
• Work with both Spain and Denmark assisted with nearly doubling their annual sales.

Confidential

Technical Sales Consultant

Responsibilities:

• Participated in development of improvements for Confidential f
• Specifically, designed graphics for presentation of performance information.