Specialized for the last five years in managing very large enterprise Data Warehouse implementations and data warehouse tool recommendations.  I've also managed Oracle DBA’s, Programmers, Client/Server migration projects, Web site implementations, and RDBMS porting projects. Having held every role in a data warehouse implementation, I know exactly what to look for and bring senior level highly qualified professional consultants or permanent candidates to each project.

UNIX, Network, and Database System Administrator with 13+ years of UNIX, C, and Relational Data Base administration, and programming using PL/SQL and C. Extensive knowledge of IBM’s RS6000 hardware and AIX (with HACMP), HP-UX and Solaris operating systems; Token Ring and Ethernet networks using TCP/IP, NFS, DCE, Encina; and shell script writing.

June 1999 - Present                                Data Warehouse Project Architect, Data Modeler, Consultant, for AEP – Columbus OH sub-contracting to MSI

• Consulted on the creation of project scope document, project plan, requirements document, gathering the requirements, and methodology to be used.
• Produced all logical, physical, and dimensional data models (high-level subject area, enterprise, and the first three data marts) in ERwin.
• Designed the technical architecture and assisted in the evaluation/recommendation of all infrastructure tools.
• Delivered high-level data warehouse seminar information to technical and business team members.
• Assisted IBM UDB DBA’s in data warehouse specific tuning, loading, archiving, indexing, parallel, etc. strategies.
• Designed, implemented, and trained team on MDD OLAP technologies and Cognos BI end user tool & IBM DB2OLAP deployment.

Feb. 1999 - Present                                Data Warehouse Instructor & Sr. Consultant, sub-contracting with The Inteq Group, Inc.

• Teach 4 days of Data Warehouse Seminars about every other month

  2-day Planning, Modeling & Mapping

  2-day Design & Construction

• High level data warehouse mentoring, for  Iridium NA in Phoenix AZ  with The Inteq Group, Inc.  in April & May 1999
• Evaluated and recommended all data warehouse infrastructure tools & designed enterprise architecture
• Consulted on the development methodology to be used and reviewed ALL deliverable documentation – data models, DBMS DDL’s, Definition/Requirements document, Design document, etc.

August 1997-Jan. 1999                              Data Warehouse Project Manager/Architect, PageMart Inc.

                                                                        Incorporated Don Meyer & Associates, Inc. and Sub-contract with The Database Group (Supervisor: Mary Jo Sabetti)

• Gathered end user requirements, created project scope document & project plan.
• Conducted readiness assessment & delivered data warehouse orientation materials/seminars on the methodology I use, the roles involved, preliminary cost/benefits, and risk assessment
• Reviewed and assisted in the data model creation with enterprise subject area diagrams
• Evaluated and recommended all data warehouse infrastructure tools and vendors
• Hired business analysts, data modelers, PL/SQL extraction/load programmers, DBA, End User Tool Specialist, Trainers, and Data Quality experts

                                                                        Sub-contract with AiC/EDS, Dallas, TX (Supervisor: Bob Dunbar) responsibilities:

• Gathered end user requirements, assisted in project scope document and project plan creation
• Review of data model creation with enterprise subject area diagrams
• Work with UNIX and database admin., extraction programmers, & end user tool IA/Express developers for capacity planning, implementation, performance tuning, and operational process procedures
• Evaluated and recommended End User Access Tool & DW vendors

March 1997                               1 week Data Warehouse Design Review consulting engagement of Financial data mart using 104 node IBM-SP, AIX, Informix, and MicroStrategy for MCI Colorado Springs, Co.

                                                                Contract with Triad Data Inc., Dallas, TX, (Supervisor: Terrance Johnson)

• Mentor Oracle DBA’s, consulting on installations, configurations, backups, and performance tuning as well as providing daily support assistance.
• Architected DCE/Encina infrastructure design, implementation and support for 3-tier client/server object oriented application development.
• Developed strategic design of HP-UX, AIX, and Solaris system administration.
• Evaluated and implemented client/server proactive management tools including HP-Open View and BMC Patrol (unix/oracle modules)

• DCE Administration, Transarc
• Encina Administration, Transarc
• Oracle’s DBA Masters Program, Oracle

            December 1995                       Contract with AiC, Dallas, Texas (Supervisor: Tom Walker)

January 1995-                         Manager of Information Systems, CompuAdd

            September 1995             Austin, Texas (Supervisor: Billy Lowe)

• Managed Re-engineering/Downsizing Migration from MVS/DB2 to UNIX/Oracle 7
• Managed team of database administrators, report writers, system operators, programmers, network and accounting administrators.
• Installed and configured UNIX on RS/6000s using HACMP with TCP/IP on PC’s and Macintosh’s and Ethernet 10baseT hubs, routers, and switches managed by Netview/6000
• Ported all C and embedded SQL, batch jobs/scheduler, server side of the communications, CICS, process control daemons, and used SAR (report management tool).
• Migrated MVS SAS production reports to Solaris SAS (saving six months of porting costs to Oracle Reports).
• Installed and evaluated Oracle Case development tools
• Installed Oracle Distributed Server as Data Warehouse using Cognos Impromptu as add-hoc end user tool
• Ported Dunn & Bradstreet accounting application (stored in VSAM files) to Oracle Alcie.
• Established company internal e-mail and Internet Web server.

(See article, A Downsizing Diary: Maximize Your Move to Client/Server, I authored for Enterprise Reengineering for more details)

March 1994-                                     ORACLE DBA and Sun/AIX System Administrator, Eaton SED

                January 1995                      Contract with Interskills, Austin, TX (Supervisor: Barbara Newlan)

• Implemented CMS--an information management tool for controlling revisions, file access, and automatic process routing for work/change requests.
• Implemented a batch-loader tool written in C and SQL to load thousands of autocad files into the CMS/Oracle database. Configured and administered SunOS 4.3 server; installed all client PC workstations with DOS 6.2/Windows 3.11/FTP 2.3/PC-Xware 1.1 to access the SunOS-based CMS.
• Responsible for AIX system administration and strategic implementation of Novell 4.0, Lan Workplace , and Novell NFS.
• Designed and implemented building expansion network layout including 10baseT cable drops to all offices, Cisco routers, fiber optic backbone, and ETSMIMS hubs.

    1992-1994                             Contract with Century Design, Austin, TX (Supervisor: Jim Ploumen)

• Ported NFS network to AFS, Configured clients and servers with cache, acl permissions, user environments, etc.
• Served as a backup network AIX administrator assisting in upgrading 35 servers and 90 clients from AIX 3.2.3 to 3.2.4 and then to 3.2.5. Relied primarily on Kron scripts to execute SMIT commands and continuously update user environments.
• Performed C tool development concentrating primarily on Infocrafter softcopy cd-rom builds and ORACLE database loads/performance admin. Developed softcopy front end build tools using C, AIX Korn shell, and SGML, Interleaf, Frame and Perl filters.
• Redesigned Oracle’s database to support new processes; ported Oracle from version 6 to 7, Forms, menu, and reportwriter.
• Extensive FORMS, C, embedded SQL development and performance tuning and AIX Korn shell batch updates/reports.

    1990-1992

• Ported network from PC RT’s running DS to NFS-TCP/IP on the RS/6000
• Ported library access control tool to NFS using TCP/IP sockets -vs- DS ipc-Tables (in C)
• Responsible for 25 servers/75 user AIX/Xwindows operating environments including installations, configurations, and X-motif tool needs
• Ported database from INGRESS to ORACLE and redesigned entire database schema’s, forms, reports based on new business process for building books and softcopy cd-rom databases.

    1988-1990

• Designed, configured and installed a 10 server/60 user PC RT token ring network running TCP/IP and IBM’s Distributed Services(DS). Responsible for all backup, printer, cron, device configurations, RT to VM communications, network administration, user add-hoc support and trouble shooting
• Developed an Interleaf source document access control system to control access to articles involving distributed services interprocess communications allowing Get & Put operations on each document based on INGRESS entered permissions (written in C and AIX shell scripts).
• Designed, programmed, implemented, and maintained an INGRESS-database for tracking articles written in Interleaf for scheduling, controlling permissions, and assigning articles to a softcopy database
• Developed Interleaf filters and tools to assist in taking Interleaf source documents and converting them to Hypertext softcopy cd-rom on-line databases

March 1986-                                 Support Programmer/Analyst, Moore Business Systems

                December 1987        Denton, Texas (Supervisor: Jack Mayo)

• Developed, maintained, supported and tested various software packages for business
• Two years COBOL/C/Informix SQL development, maintenance and data salvage utility programming and support in UNIX/XENIX environments
• Extensive UNIX/XENIX shell scripting, device configuration and system maintenance.
• Proposed, designed, tested, and implemented an Electronic Insurance Claims Module for health care system, proven to be a strong seller (COBOL, 3780 Emulator and IBM JCL)

Education

        BBA in Computer Information Systems, December 1985 3.2 GPA