SUMMARY:

• Accomplished, results - driven Senior Systems Programmer, DBA, Architect and Technical Lead with over 30 years experience in large 24/7 test and production mainframe systems.
• Extensive expertise in IBM database management and operating systems, performance tuning, capacity planning and automated operations.
• Well versed in data center activities, such as systems software support, utilities usage and change/problem management.
• Demonstrated success managing product selection, configuration, planning, testing, upgrades and migrations.

SOFTWARE:

Databases: IMS, DB2

Platforms/OS: z/OS, OS/390, MVS

Software/Tools: SQL, STROBE, Confidential, Mainview, TMON, BMC DB2 and IMS tools, Compilers, CICS, LE, RMF, Tape Management Software, Share Tape Components, SAS, SPSS, DHFSMS, SMF, FDR, RMF, Sysplex, Data Sharing, Rexx, Shared Message Queues, SMP/E DB2 Connect, IRLM, TSO, OPSMVS, DB2 PM, IMS/DC, IMS/TM, Fastpath, DDF, IBMLINK, APAR, PTF, PUT Tape.

EXPERIENCE:

Confidential

Database Systems Programmer

Responsibilities:

• DB2 systems programming.
• Planned and performed version upgrades including fallback service.
• Reviewed and adjusted systems options.
• Trained other associates

Confidential

Lead Systems Programmer

Responsibilities:

• DB2 and IMS systems programming.
• Planned and performed version upgrades from unsupported versions to supported ones .
• Improved performance with buffer pool adjustments saving 6 hours CPU each night in the batch cycle.

Confidential

IMS Systems Programmer

Responsibilities:

• Responsible for IMS systems programming support running z/OS at Unum's Portland, ME data center.
• Provided all aspects of IMS v10 support .
• Assisted in bringing IMS support back inhouse from an outsourcer.

Confidential

IMS/DB2 Systems Programmer

Responsibilities:

• Provided systems programming support for Confidential clients, specifically in the IMS and DB2 areas.
• Acted as sole IMS systems programmer with additions responsibilities in DB2 support. Major accomplishments included:
• Performed many upgrades from out of support IMS systems to IMS V11 and V10.
• Provided conversion from IMS SMU security to external security (Some clients were RACF others were ACF2).
• Insourcing and marketing to new clients with IMS requirements.
• Retired several IMS clients and consolidated IMS systems.
• Replaced various vendors database tool sets with the CA IMS tools.
• Provided installation of the IMS / MQ bridge.
• Supported DBCNTL (CICS) and TM clients.
• Assisted with automation improvements.
• Stabilized a large number of reoccurring operational failures, especially ones related to Stored Procedure failures.
• Provided advance identification of D/R changes needed when changing from volume restores to mirrored DASD.
• Provided technical support for DB2 Data Sharing / Sysplex clients.
• Assisted in upgrades from various old versions to V9 including a V4 to V9 upgrade.
• Assisted with automation improvements.

Confidential

DB2/IMS Systems Programmer

Responsibilities:

• Configure, support, install, maintain and upgrade: OS/390, MVS, IMS, DB2, STROBE, MQSeries, Confidential, AFOPER, OPS/MVS, Mainview, BMC products, compilers, LE & RMF, tape management software, SMS, Share Tape components.
• Perform physical DBA activities for IMS and DB2.
• Monitor systems for performance and capacity.
• Utilize DFHSMS, DFP and other program products for storage management.
• Train system programmers, developers, operations and management.
• Beta tested new system software releases for vendors.
• Performed subsystem consolidation, separation and tuning.
• Supported test and quality assurance labs at IBM and end-user sites.
• Handled product evaluation and testing.
• Delivered technical presentations at Guide and Share conferences.
• Efficiently supported large test and production environments using z/OS, IMS and DB2.
• Eliminated 95% of subsystem failures by designing, documenting and implementing an ongoing preventive/corrective service strategy.
• Upgraded 20+ DB2 members in 3 sysplexes, to V7. Upgrade approach included hot down leveled system support if needed. Supported the entire application lifecycle from conception to production on both DB2 versions until upgrade was complete.
• Implemented SYSPLEX data sharing at a large investment bank.
• Conducted specialized performance studies for database buffer pools, workload balancing, applications, database communication configurations and batch usage. Predicted the performance impact of buffers in data spaces, EDM cache sizes and data archiving. Improved batch window constraints.
• Established the first database environment at various companies.
• Utilized 3-pronged approach to effectively address crisis situations: circumvent the failure, evaluate the response (technically and managerially) and institute long-term process changes to reduce future issues.
• Provided crucial non-disruptive, on site systems programming support to multiple firms preparing for data center facilities management. This required close collaboration with the remaining technicians, outsourcers, firm management and end users.

Confidential

Developer

Responsibilities:

• Developed SQL interface for IMS/DB.

Confidential

Consulting Systems Engineer

Responsibilities:

• Initial team member for OPS/MVS operations automation software.
• Wrote operations methodologies including IMS & DB2 support.
• Provided consulting services prior to employment (1985 - 1989).

Confidential

Senior Technical Consultant

Responsibilities:

• IMS subsystem consolidation and tuning (Systems & DBA)
• Performance and Capacity Planning
• Establish DB2 Environment (Systems & DBA)
• Software Inventory Management

Confidential

DB2/IMS Consultant

Responsibilities:

• IMS DBA product development and support for a software vendor (BMC).
• Supported and tested IMS Performance and Accounting products (Boole & Babbage).
• Confidential performance product enhancements (IMS, DB2, MVS).
• IMS and DB2 education for Systems Programmers and DBAs.
• IMS Systems and DBA support (installations, backups, recoveries, reorgs, performance).
• IMS DBA support

Confidential

IMS Specialist

Responsibilities:

• Initial team member Confidential family of IMS performance monitors.
• Wrote and delivered IMS education and services worldwide.

Confidential

Senior Systems Engineer/IMS Specialist

Responsibilities:

• Provided SE and PSR services to local customers.
• Served as the database specialist.
• Delivered worldwide back level version support.