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.

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.

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.
• 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.
• !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.

• 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.

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.
• 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.
• 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.
• 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.
• 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.
• 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.

• 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.
• 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.

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.

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.