Tom Mcgregor Email & Phone Number

Responsible for DB2 support for Databases on ZOS. My duties include Performance and Tuning, all DBA Tasks, Project Coordination, Operations Support, Disaster Recovery Planning and execution. I also Support Microsoft SQL Sever 2012 an a DBA. I Support Cognos BI Tool as an administrator and modeler. Helping with design of new Cognos Data Models and Performance and tuning.

Marlbourgh Ma

Responsible for DB2 and IMS Application support for Databases and Systems Programming and installation on ZOS. My duties include Performance and Tuning, all SYSTEMS and DBA Tasks, Project Coordination, Operations Support, Disaster Recovery Planning and execution. Converted DB2 V8, V9 systems to V10, No outages. Have done IMS upgrade from V11 to V13,. I am the technical lead for a group DBA’s, I am currently Mentoring Junior Systems Programmers in IMS and provide training for DB2 and IMS applications DBA’s.

Pheonix Az

General overview of experience:▪ Starting in the 1970’s has been a systems programmer on IMS, CICS, MVS, BTAM, TCAM and VTAM. Also has been inthe DBA Role on multiple DBMS’s (pre-DBMS’s BDAM, ISAM, VSAM) IMS DB, IDMS, DB2, DB2 6000, DB2 UDB,Teradata, Oracle, Sybase. I am currently on a multidisciplinary team a subject matter expert in Database Systems IMS,DB2. I am currently certified as an IBM solutions expert for DB2 Version 9 and 10 for ZOS and Version 8 DB2 UDB UNIX,Windows, and Linux.▪ I have been a member of the SAS users group international, Apple Developers group (I write PC GAMES for sale on theMAC), I have been a member of the Platinum developers/users group, Share, Guide, International Security AdministratorsGroup, and others. I have regularly attended all above user group conferences plus the IBM Information On Demand, HRuser's group, and Call Center technology's group. I am on the IBM DB2 Customer Advisory Council. I have a 37+ yearsuccess record of excelling in this field.; Responsible for DB2 Databases on ZOS. My duties include Performance and Tuning, all DBA Tasks, ProjectCoordination, Operations Support, Disaster Recovery Planning and execution. Heavily involved in Converting 20+ DB2Groups to DB2 V10, I handle all day to day task assignments for the the Customer and Accounting Systems.▪ !USAA

Responsible for DB2 and IMS Databases on ZOS. My duties include Performance and Tuning, all DBA Tasks, ProjectCoordination, Operations Support, Disaster Recovery Planning and execution. Developed a REXX based ISPF DBAToolkit that generates Utility JCL based on database statistics on a weekly basis that is easy to use and automates manyDBA activities and reduces human errors. Converted 15 DB2 Groups to DB2 V8, V9 and now V10, No outages. Havedone IMS upgrade from V9, V10, and V11 and have converted many databases to HALDB. I am the technical lead for agroup of 14 DBA’s, I handle all day to day task assignments for the group. Have been to india Twice once in the role oftrainer and once as Manager on duty to a few hundred contractors. Participated in the IBM DB2 V10 early ship programand lead an effort for the Optim Infosphere Data Growth series of products.

Project Manager Data Warehouse▪ Responsible for DB2 Data warehouse on ZOS. I managed data modelers, ETL programmers, report/query designers,BusinessObjects administrators and designers. BusinessObjects was the BI query and reporting tool. I was also thetechnical mentor to my team and to the DBA team.!Pacfic Systems for USPS

Responsible for DB2 Database Administration for US Postal Services. My duties include Data Model Analysis,Performance and Tuning, all DBA Tasks, Project Coordination, installation, and Training, Disaster recovery Planning andexecution. Installation and setup with SMPE of Data Capture product ENET. VLDB and 8-way data sharing environment.!Comforce for SABRE

Responsible for Database Administration for Canadian Air Family of applications. My duties include Data Model Analysis,Performance and Tuning, all DBA Tasks, Project Coordination, installation, and Training, Sterling Coolgen Tech Design. AllUnix related tasks such as scripting for DBA and customer tasks, debugging, design, software installs, hardwareupgrades, currently upgrading to IBM DB2 UDB v5.2.▪ Responsible for IMS TM/DB, DB2 systems, Marketing Data Warehouse using IBM RS6000 and DB2 for AIIX!JTA for FRITO LAY

Responsible for Database Administration for International Family of applications (inventory, tracking, routes,etc). My dutiesinclude Data Model Analysis, Performance and Tuning, all DBA Tasks, Project Coordination, installation, and Training.▪ Responsible for CICS, IMS DB, DB2 systems.!Computer Horizons for AT&T

Responsible for Database Administration for AT&T CBS RAMP Family of applications (billing). My duties include DataModel Analysis, Performance and Tuning, all DBA Tasks, Project Coordination, installation, and Training.▪ Responsible for IMS DB, DB2 and Teradata systems.!DLS Consultants for AT&T

Responsible for Database Administration for AT&T Risk Management Data Warehouse on an MPP UNIX Teradataplatform. My duties include Data Model Analysis, Performance and Tuning, all DBA Tasks, Project Coordination,installation, and Training.▪ Responsible for all Security and access for Database and UNIX platforms. Also responsible to coordinate all Non-Database related UNIX processes.

Application Planning and Architecture▪ Responsible for Application Planning, Architecture, and Project Management which includes Market Analysis, VendorSelection, Contract Negotiation, Project Coordination, installation, and Training.▪ Managed Data Center Consolidation two data centers to one. Responsible for all Information Security, Database, CallCenter, and Bank Card Projects from inception to installation, including long term strategic Technical Direction.▪ Produced E-mail, Information Security, HR, and Call Center Strategic Information Systems white papers for executivemanagement. Also produced for EVP of IS, Pegasystems Users Group Presentation, and many other executivemanagement presentations.▪ Procured various products such as Call Center Technology (ACD’s, PBX’s, Predictive Dialers, VRU’s, PegasystemsWorkflow, IMA EDGE, DSI Collection Systems), Credit and Behavior Scoring applications, LAN Security Products, CBTtraining systems, E-mail, and others.

Database and Data Administration▪ Managed Data and Database administration group, was responsible for Large IBM mainframe and LAN environment ofIMS DB/DC, IDMS, DB2, UNIX based Sybase, OS/2 DBM. Managed this environment with various products such asBMC, Platinum, Omegamon Also managed Site-automation operations software support Boole and Babbage anddocument image Filetek.▪ Managed 4 million plus transaction p/day IMS TM on-line environment.▪ I performed all managerial duties plus technical head of outage groups, which included from time to time product and fixinstallation, debugging including dump reading, and Database Recovery.

Responsible for database and on-line systems support for IMS DB/DC, CICS, IDMS, TERADATA and DB2 Including,Installation, debugging, modifications and performance and tuning. Also responsible for related products such as CrossSystem Product (CSP), Data Dictionary, DISOSS, QMF. Managed technical support for all MD financial applicationsproducts. Project leader of the CICS and Relational Database system support groups. As Project Leader, set standards,assigned tasks and provided technical guidance to others within the group(s).!!!!Martin Marietta Data Systems

Responsible for ACF/VTAM, NCP, and IMS DB/DC systems software support including Installation, debugging,modification, and performance/tuning. Related program product support for ADF, Data Dictionary, MVS SP 1.3 IPO. Onthe IBM beta test programs for 3275’s, installed software, wrote TPNS scripts for benchmarks against TSO, IMS DB/DC,CICS and created documentation and trained operations staff for production.

Responsible for CICS systems software support including Installation, debugging, and modification. Created softwareprotocol converters to allow non-IBM banking devices to communicate with IBM mainframes.

Responsible for IMS DB/DC systems software. Maintained Credit Card Applications Systems written in IBM MainframeAssembler Language.