Kenny Fogarty

Past

• Senior DBA at Bank of America
• DB2 Systems Programmer at Toyota Motor Europe
• IT Consultant at European Patent Office

• DB2 Systems Programmer at Lloyds TSB Bank
• IT Consultant at IBM Netherlands
• Operations Analyst at Abbey National Finance and Investment Services
• Operations Analyst at Forte PLC
• Various Roles at Amadeus Global Travel Distribution

see less...

5 more...

Education

• Open University Business School
• http://www.brainbench.com
• Alpha Training Limited

• Yew Tree Comprehensive School

see less...

1 more...

Recommended

10 people have recommended Kenny

Connections

99 connections

Industry

Information Technology and Services

Websites

• My Website
• My Company
• My Blog

Kenny Fogarty’s Summary

IBM mainframe systems engineer with a number of years of experience in the travel, banking, insurance, automotive and leisure industries, specialising in DB2 for z/OS.

Direct experience with DB2 subsystem installations, upgrades and maintenance on IBM mainframes (z/OS) using SMP/E and CustomPac. Installation, customisation and maintenance of associated products, e.g. QMF & Data Propagator and product sets from BMC, Computer Associates and CDB.

Interested in DB2 subsystem and application performance tuning and optimization.

Hands on experience of several large migration projects, including:
Migration of DB2 plus associated product and utility sets from version 4 through to version 7.
Migration of an entire software development platform utilizing ISPFLMF to SCLM.
Migration to Language Environment (involving circa 65,000 separate application programs written in Assembler, COBOL, PL/I).
Migration from CSP to VisualAge COBOL.
Migration to Enterprise COBOL V3.4.

Kenny Fogarty’s Specialties:

z/OS (via OS/390, MVS), VM, CMS, TPF, TSO, JES2, JES3, SDSF, TWS, REXX, REXX Tools, CLIST, ISPF/PDF, CICS, IMS, VSAM, DB2, DB2 subsystem performance, application SQL tuning, subsystem parameters (DSNZPARMS), JCL, SMP/E, SCLM, Endevor, ISPFLMF, ISPW, ECMVS (IBM internal product, including STIC1 and ABR), BMC Recovery Products, BMC DB2 Utilities, BMC DB2 Administration Products, IBM DB2 Utilities, DSN1COPY, DSN1SDMP, IBM utilities (IEBGENER, IEBCOPY, IEHLIST etc).

Kenny Fogarty’s Experience

• Senior DBA

  Bank of America

  (Public Company; 5001-10,000 employees; BAC; Banking industry)

  November 2006 — November 2007 (1 year 1 month)

  Senior DBA providing DB2 consultancy and mentoring to in-house application development staff and other team members.
  Implemented a cost-effective DB2 application object monitoring solution using REXX and DB2 Real Time Statistics and Mainview Performance Reporter.
  Instigated a standardisation project designed to align JCL standardisation across the different development environments, minimising change, and increasing development and testing times.
  Implemented several REXX execs to assist in monitoring DB2-related events across all LPARs within the BOA framework.
  Standarised the use of DB2 utility programs including several 'best practice' methods to increase data availability while maintaining data integrity.

• DB2 Systems Programmer

  Toyota Motor Europe

  (Public Company; 10,001 or more employees; TMC; Automotive industry)

  May 2006 — October 2006 (6 months)

  Supporting Toyota DB2 subsystems located in Europe and UK.
  Analyse all DB2-related system and/or performance problems (application deadlocks, timeouts, application-specific DDL/DML/SQL analysis), other performance bottlenecks.
  Development of a new bufferpool strategy to maximise subsystem performance.
  Maintainance of DB2 subsystem parameters (DSNZPARMS & DSNHDECP).
  Support in-house development teams who are developing and maintaining application code for dealer ordering systems, vehicle ordering systems, central warranty systems.
  Implementation of WLM-managed DB2 stored procedures.
  Installation and customisation of DB2 Content Manager for z/OS.

• IT Consultant

  European Patent Office

  (Non-Profit; 501-1000 employees; Government Administration industry)

  June 2005 — May 2006 (1 year)

  Working in a two-man team I was responsible for the following tasks:
  
  Migration from in-house developed source code management application to SCLM.
  Implementation of new Enterprise COBOL Compiler v3.4 on the IBM mainframe.
  Co-ordinated testing of new compiler, analysing all application code for migration issues. This project was completed within six months.
  Development and maintenance of SCLM language definitions.
  Creation and maintenance of tools mostly developed in ISPF/REXX, that provided extra functionality to our SCLM-based in-house software delivery system.
  Analysis of application-related DB2 performance issues.
  Correction of application JCL to ensure that all production batch jobs met established site standards.
  Development of an in-house XML-based metadata repository which was used to store configuration data for all development environments (IBM mainframe, AIX, Windows plus various development applications).

• DB2 Systems Programmer

  Lloyds TSB Bank

  (Public Company; 10,001 or more employees; TSBD.L; Banking industry)

  July 2003 — June 2005 (2 years)

  Installation of DB2 related software products from BMC and CA to V7 exploitative levels.
  Migrated all Lloyds TSB and Cheltenham & Gloucester DB2 subsystems from V6 to V7.
  Applied regular software maintenance to DB2 subsystems and related software.
  Used performance tuning and system monitoring tools from IBM, BMC & CA to provide pro-active system monitoring and problem resolution.
  Knowledge of DB2 system internals, made dynamic changes to subsystem parameters using BMC OperTune.
  Resolving application software problems.
  Involved in a bank-wide ISV software rationalisation project (DBMS software) that reduced software licensing costs by several million pounds.
  Close liaison with vendors, ensuring any problems are reported, followed up and applied to the systems in a timely and correct manner.

• IT Consultant

  IBM Netherlands

  (Public Company; 10,001 or more employees; IBM; Computer Software industry)

  January 1997 — July 2003 (6 years 7 months)

  Application packaging, shipment and installation using SMP/E.
  Application maintenance packaging, shipment and installation worldwide.
  Providing 3rd level support to customers based in US, Canada, Peru, Mexico, Brazil, Israel, UK, Germany, Holland, Belgium, Italy, France, Australia, India and Japan.
  Development support for over 15 IBM Finance Systems applications.
  DB2, CICS, IMS systems programming. DB2 DBA tasks - object creation and management.
  Development of ISPF-based tools written in REXX, Assembler, COBOL, PL/X and PL/I.
  Source code management using ISPFLMF, SCLM and ABR (Internal IBM tool).
  Critical team member for Y2K cutover.

• Operations Analyst

  Abbey National Finance and Investment Services

  (Public Company; 5001-10,000 employees; Insurance industry)

  October 1996 — December 1996 (3 months)

  Operations analyst on a short-term (three month) contract. Environment was MVS, JES2, CICS, DB2, CA-Scheduler, CA-Opera, CA-NetMan, REXX, OS/2, Regina REXX.

• Operations Analyst

  Forte PLC

  (Public Company; 1001-5000 employees; Leisure, Travel & Tourism industry)

  April 1996 — October 1996 (7 months)

  Operating environment, MVS, JES2, CICS, DB2, REXX, ISPF/PDF, SDSF, OPC/A, Tandem.

• Various Roles

  Amadeus Global Travel Distribution

  (Public Company; 5001-10,000 employees; Airlines/Aviation industry)

  March 1991 — April 1996 (5 years 2 months)

  Various roles, starting out in Operations as a peripheral operator, progressing through Operations, and by the time I left the company, I was working in Test Systems Coverage, as a Systems Support Programmer.
  
  Operating environment, MVS, TSO, ISPF/PDF, SDSF, BETA92, ISMF, AbendAid, DB2, CICS, CA-1 (UCC1), SAS, OPC/A, VM, CMS, REXX, CMS Pipelines, TPF V3.1, VM Oper, TPF Oper, VPARS, TPF file recoup, capture, restore, Assembler, COBOL.

Kenny Fogarty’s Education

• Open University Business School

  Professional Certificate in Management 2000 — 2001

  The Open University Professional Certificate in Management provides a broad-based, practical introduction to the key ideas, techniques and overall competencies needed in order to manage effectively and productively in modern organisations in any part of the world.

• http://www.brainbench.com

  Certificate in Project Management 1999 — 1999

  The Project Management examination encompassed all facets of project management in order to ensure that objectives are met on time and within budget.
  
  The test was based on the Project Management Institute's (PMI's), Project Management Body of Knowledge (PMBOK) methodology.
  
  The examination covered the following topics: Project Costs, Project Framework, Project Human Resources and Communications, Project Integration, Project Processes, Project Procurement, Project Quality, Project Risk, Project Schedule, Project Scope.

• Alpha Training Limited

  Application Programming (COBOL). 1989 — 1990

• Yew Tree Comprehensive School

  1977 — 1982

Additional Information

Kenny Fogarty’s Websites:

• My Website
• My Company
• My Blog

Kenny Fogarty’s Interests:

Writing, photography, travel, football, my dogs, my family.

Kenny Fogarty’s Honors:

Certification in Project Management (from Brainbench.com).
Open University Professional Certificate in Management.
Six Sigma Root Cause Analysis.
City & Guilds 424 Application Programming (COBOL).

Kenny Fogarty’s Contact Settings

Interested In:

• career opportunities
• consulting offers
• new ventures
• job inquiries
• expertise requests
• business deals
• reference requests
• getting back in touch