Robert Gaylord

IT Specialist /Consultant

rtcvo8@r.postjobfree.com

PROFESSIONAL EXPERIENCE

_______________________

Profile

IT Specialist and Consultant with over twenty seven years of information systems experience including e-business technology in the following industries: banking, education, government, finance, insurance, manufacturing, real estate, retail, telecommunications, travel & transportation, and utilities.

Proven track record in data warehouse and database administration with expertise and technical knowledge in data management, database design, and all aspects of administration and has performed the functional roles of architect, data modeller, database application specialist. Experienced in business application development, database solutions, middleware design, network design and implementation.

Goal

Significant contribution to ROI of enterprise business intelligence through performing all activities supporting and enhancing data warehouse environments and databases in a permanent or consulting position.

Key Skills

* DB2 UDB with DPF on Unix and Windows, DB2 Query Patroller, Governor, and QMF

* IBM InfoSphere Balanced Warehouse

* Microsoft SQL Server

* 4GL SQL

* Microsoft and Lotus Office Suites

* ERwin Data Modeler with DDL and DCL generation

* CASE

* Software installation and configuration

* Technical Skill transfer

Key Courses and Training

* SI Methods For Professionals 1999

* DB2 Universal Database Administration for UNIX 2000

* DB2 UDB EEE Administration for UNIX 2000

* Business Intelligence Engagement Model 2000

* Global Services Method 2002

* Team leadership 2002

* DB2 Advanced Recovery & High Availability 2002

* DB2 EEE Unix Performance Monitoring & Tuning 2003

* Quality Management System 2006

* Technical Leadership Exchange 2006

* Tivoli System Automation (TSA) for Multiplatforms 2008

* Linux Jumpstart for UNIX System Administrators 2010

WORK HISTORY

____________

IBM

* 09/1998 to 04/2011 IT Specialist/Consultant

* For national and global companies as well as state and federal governments successfully supported single and multi-terabyte partitioned HR, customer, and analysis/reporting operational data stores and data warehouses with custom, SAP and Peoplesoft data sources on Windows and AIX timely and efficiently exceeding customer expectations.

* Performed database administration, system upgrades and migrations with expansion and data redistribution, monitoring, tuning, statistic updating, data balancing, capacity planning, maintenance, backup and recovery, and security. Teamed with system administrators supporting fault tolerant implementations.

* Performed logical and physical database design with security including Materialized Query Tables, common table expressions, SMS/DMS tablespaces and containers, logging, indexing, stored procedures and trigger development using Erwin.

* Created shell scripts to automate administration, enhance parallel processing, monitor database availability and stability. Supported data access via a web server and Lotus Notes application.

* Provided thought leadership and technical design on the performance tuning of SQL, database server parameter tuning, query management and resource utilization resulting in decreased system utilization and increased system capacity. Resolved database issues of connectivity, data access, availability, and performance.

* Designed a complex security management process that was table driven data control language generating scripts increasing efficiency by reducing manual operations by personnel.

* Provided technical leadership advice, designed, and scripted shell programs and database scripts for ETL processes performing data loading and exporting with alerting. Resolved ETL processing and database issues. Designed and scripted a process to dynamically manage load tables and consolidation via union views.

* Architected and implemented a meta data database solution embracing production selection, installation, configuration, and administration of the meta data platform for a marketing data warehouse.

* Team lead for a global team consistently meeting SLAs including knowledge transfer of best practices. Teamed with product support on PMRs, work arounds, and fixes for system problem resolution. Teamed with Tivoli and BMC Control M support personnel. Designed and maintained documentation Wiki.

IBM Assignments

* 09/2007 – 04/2011 Data Warehouse/Database Administrator , Financial, (Phoenix, AZ)

* 11/2006 – 08/2007 Data Warehouse/Database Administrator, Human resources (various locations)

* 01/2003 – 11/2006 Data Warehouse/Database Administrator, Retail (Minneapolis, MN)

* 09/2002 – 12/2002 Data Warehouse/Database Administrator, Insurance (Chevy Chase, MD)

* 11/2001 – 09/2002 Data Warehouse/Database Administrator, Distribution, ( Cincinnati, OH)

* 07/2001 – 10/2001 Data Warehouse/Database Administrator, Federal Government. (Gaithersburg, MD)

* 02/2001 – 07/2001 Database Administrator, Travel & Transportation. (Schaumburg, IL)

* 09/2000 – 02/2001 Data Warehouse/Database Administrator, Utilities. (Charlotte, NC)

* 05/2000 – 08/2000 Application Specialist, Insurance. (Cedar Falls, IA)

* 05/2000 – 05/2000 Data/Report Analyst, Manufacturing. (San Diego, CA)

* 01/2000 – 05/2000 Solution Architect, Manufacturing. (Raleigh, NC)

* 10/1999 – 01/2000 Data Warehouse/Database Administrator, Manufacturing. (Holmdel, NJ)

* 01/1999 – 09/1999 Data Warehouse/Database Administrator, State Education. (Columbia, SC)

* 09/1998 – 01/1999 Database Administrator, Utilities. (Raleigh, NC)

MEAG Power

* 01/1994 - 09/1998 Solution Architect/Data Warehouse Mgr./Sr. DBA

* I contributed to team strategic planning effort and led data specific project planning including solution architecture at a wholesale electric utility. I led the technology due diligence effort and subsequent production selection, installation, configuration, administration and support for an n-tier/middleware data warehousing solution.

* I performed the data architect role with logical and physical data modelling.

* I migrated and transformed legacy data to data warehouse operational data store, which also embraced meta data creation and management.

* Responsibilities included managing the complete data infrastructure and acting as the database administration team lead responsible for corporate wide databases on MS SQL Server and systems architecture for packaged, custom n-tier, data warehousing, and web applications. This included supporting databases in the full application life cycle of custom applications with data modelling with logical and physical design of databases for all production systems.

* Report writing using FOCUS and SQL.

State of Georgia

* 02/1989-12/1993 DOAS Computer Services Division, Programmer, Network Architect and Administrator, DBA

* Created Easytrieve Reports

* Responsible for complete system development for a mainframe real estate application.

* Lead reverse engineering of CICS code using CASE.

* I managed the complete office network infrastructure for the telecommunications department statewide which involved network design, implementation, and administration including database administration and systems architecture for packaged applications.

IBM

* 02/1986-01/1989 Contract Programmer

* In microcomputer environment responsible for custom applications and data repository using IBM Personal Decision Series on DOS.

* Acting as lead designed using rapid application development methodology and programmed in BASIC.

* Developed business applications supporting areas of Special Business Offerings, Software Marketing, and Complementary Resources, a reseller incentive award system.

Decatur Federal Bank

* 01/1984-02/1986 COBOL Programmer

* Performed mainframe computer program maintenance.

EDUCATION & QUALIFICATIONS

__________________________

Education

* MS / Computer Information Systems / Georgia State University / Atlanta, GA (USA) / 1988

* BS / Animal Science / Delaware Valley College / Doylestown, PA (USA) / 1973

Qualifications

* Certification / NOVELL CNE / Novell / Boulder, CO (USA) / 1990

* Certification / IBM Consultant / IBM / Armonk, NY / 2002

OTHER RELEVANT INFORMATION

__________________________

Publications

* Submitted Publication/Disclosure RSW8-2000-0262 for research disclosure in the Invention Publication Database.

* Publication: Data and Database Standards and Procedures, MEAG Power, 1996

Membership in Professional Organizations

* Speaking engagement at the Data Warehouse Institute August 1997 Boston presenting case study.

* Data Warehouse Institute (DWI): Member 1993-1998

* Network Professional Association (NPA): Member 1989-1993

Other Job-related Activities

* Voluntary contributor to IBM Practitioners Support Network.

Contact this candidate