Relevant Experience:

• IT Professional with over 25 years working as a Developer, Analyst, Architect, DBA, and Data Modeler.
• Skilled in TERADATA SQL, TAP XML, ANSI SQL, Stored Procedures, Macros, TERADATA V2R4.1, V2R5.1, V2R6, R12, and R13.10.
• Experienced in Data Warehousing concepts including Data Mart and Data Mining using Dimensional Modeling (Star Schema Design) and 3NF for ODSs.
• Experienced in developing UNIX Shell Scripts, BTEQ, FASTLOAD, FASTEXPORT, TPUMP, and MULTILOAD scripts for data migration and for Scheduler Utilities.
• Experienced in INFORMATICA ETL mapping development using PowerCenter 6.2, 7.1, 8.1, and 8.6.
• Experienced in MAINFRAME TERADATA development including JCL, REXX, COBOL, VSAM, DB2, FOCUS, and EASYTRIEVE in CMS and MVS.
• Experienced in ORACLE development, JAVA, HTML, and TAP XML coding.
• Experienced in CRM development including customer matching and standardization.

Technical Skills:

Software: INFORMATICA POWERCENTER, TERADATA SQL ASSISTANT, TERADATA ADMINISTRATOR/ MANAGER, QUERYMAN, BTEQ, MULTILOAD, FASTLOAD, TPUMP, ERWIN, TOAD, ERWIN, EASYTRIEVE, SYNCSORT, QMF, CA7, VSAM, CICS, TSO/ISPF, VM/CMS, FILE MANAGER for DB2, FILE-AID, JES2, MS ADT/WORD/ EXCEL/PROJECT.
Languages: TAP XML, UNIX KORN SHELL, PL/SQL, PERL, PACBASE, COBOL, COBOL II, JCL, VISUAL BASIC DAO/ADO, SQR, FOCUS, SQL, C, REXX, XEDIT.
Databases: TERADATA, ORACLE, INFORMIX, SQL SERVER, DB2, VSAM, FOCUS, ACCESS.
Experience Highlights:

SENIOR ARCHITECT, Confidential,Warrenville, IL: Dec 2011 Present.

• Developed Korn shell scripts and assist with Unix maintenance as necessary; performed on-call duties.
• Responsible for high-level and detailed ETL designs and process flows for data migration from Oracle to TERADATA.
• Responsible for the development of an architecture and plan to migrate the data off the mainframe for several large BP/Amoco applications.
• Acted as liaison for technical team and stakeholders for development of functional specifications.
• Developed nonfunctional specifications document; consulted with enterprise architects.
• Developed Technical Design Document showing detailed process flow.

SENIOR ETL ARCHITECT, Confidential, Raleigh, NC: Dec 2010 Nov 2011 (D.O.D. Secret Security Clearance).

• Provided production support of the U.S. Postal Service’s dually-loaded enterprise data warehouse using AIX KORN shell, FASTLOAD, MULTILOAD, and BTEQ.
• Implemented performance tuning methodologies on TERADATA databases and assisted admin personnel with data-specific administrative tasks.
• Optimized database tables by identifying data access paths using TERADATA VISUAL EXPLAIN with QUERY CAPTURE FACILITY (QCF).
• Designed and developed user enhancements and conducted/participated in code peer reviews.
• Developed Korn shell scripts and assisted with Unix maintenance as necessary; performed on-call duties.

SENIOR ETL ARCHITECT/MODELER,Confidential,Dallas, TX: May 2010 Dec 2010.

• Responsible for high-level and detailed ETL designs and process flows for data migration from Oracle to TERADATA.
• Performed data analysis and mapping in ERWIN and create entities and attributes.
• Facilitated Change Requests to the data model adding FK constraints, migrating keys to child tables, and using the Forward Engineering facility to generate schema DDL for TERADATA.
• Created mainframe SYSIN members containing TERADATA FASTEXPORT code to create extract files to GDGs.
• Developed INFORMATICA 8.6 POWERCENTER mappings, sessions, and workflows to create load-ready files to load to TERADATA using TPT with unix wrappers.
• Supported enterprise data warehouse production by mentoring offshore production support team.

LEAD ETL ARCHITECT, Confidential, Minnetonka, MN: Mar 2009 Apr 2010.

• Led a team of four ETL developers responsible for design, development, testing, and implementation of a parallel data warehouse load using TERADATA Stored Procedures, Macros, BTEQ, and MLOAD in a unix environment (process loaded over a Terabyte of data).
• Designed, coded, and developed INFORMATICA 8.6 POWERCENTER mappings, sessions, and workflows using ODBC connections to Oracle and TERADATA.
• Designed and created data models to reflect proposed dataflow tables and physicalize tables on TERADATA.
• Optimized existing process flows by proposing TERADATA best practices and prototype proposals for customer review.
• Addressed process defects by implementing code fixes and performing maintenance releases.

PRINCIPAL CONSULTANT, Confidential,DeSoto, TX: Jan 1997 Feb 2009

CONSULTANT, BearingPoint (at Tinker Air Force Base), Oklahoma City, OK: Aug 2008 Feb 2009 (D.O.D Secret Security Clearance).

• Brainstormed ETL design for Informatica development of the Air Force C-130 PLM Data Vault.
• Decomposed Oracle procedures for conversion to Informatica transformations.
• Developed ETL mappings using INFORMATICA 8.5 PowerCenter to include Warehouse, Mapping, and Workflow designers with Workflow Manager.
• Coded Oracle functions to use in Informatica transformations; create views.
• Performed unit testing and verification using SQL Developer and TOAD.

SENIOR ETL ARCHITECT, Confidential,Englewood, CO: Jan 2008 Jul 2008.

• Developed ETL mappings using INFORMATICA 8.1 PowerCenter to include Warehouse, Mapping, and Workflow designers with Workflow Manager.
• Analyzed INFORMATICA and TERADATA batch cycle and optimize jobs using AUTOSYS.
• Coded Korn shells to use MULTILOAD, FASTLOAD, and BTEQ to load data.
• Maintained MULTILOAD and FASTLOAD scripts.
• Developed PL/SQL code for use in ORACLE batch using TOAD.
• Participate in on-call rotation for ORACLE and Teradata batch cycle.

SENIOR ETL DEVELOPER, Confidential, Plano, TX: Apr 2007 Dec 2007.

• Designed and developed ETL mappings using INFORMATICA 7.1 PowerCenter to include Warehouse, Mapping, and Workflow designers with Workflow Manager.
• Assisted DBAs by creating physical db structures from logical models.
• Code MULTILOAD and BTEQ scripts using KORN shell for use in conversion table load processes; use TERADATA ADMINISTRATOR and QUERYMAN for validation.
• Gathered requirements and otherwise interacted with users.

LEAD DATA WAREHOUSE DEVELOPER, Confidential,Southlake, TX: Feb 2006 Mar 2007.

• Led a team responsible for developing, coding, testing and debugging highly complex TERADATA solutions using TERADATA BTEQ, MULTILOAD, TPUMP, and FASTLOAD in SUN SOLARIS environment.
• Coded ETL mappings and created workflows with INFORMATICA 7.1 PowerCenter using Mapping Designer, Workflow Designer, and Workflow Manager.
• Designed and coded complex applications using TERADATA MACROS and PROCEDURES; created optimization programs to resolve problems; designed and built prototype applications.
• Led design and coding of Abilitec algorithms supplied by Axciom to develop in-house customer matching system for CRM; generated deals for CRM to present on the TRAVELOCITY website.
• Developed ORACLE PL/SQL and used TOAD.

TERADATA CONSULTANT, Confidential,Fort Worth, TX: Aug 2005 Feb 2006.

• Designed and coded AIX KORN shell scripts to run TERADATA FASTLOADs, MULTILOADs, and BTEQs supporting train operations and expenses.
• Coded JCL and loaded tables using mainframe TERADATA; decomposed mainframe COBOL code for DB2 and designed/normalized Teradata tables.
• Developed TERADATA macros to perform specific expense-related tasks.
• Mapped data from source to target using Star Schema methodologies and created tables using TERADATA ddl.
• Developed Visual Basic code to extract data from Excel to Access; load to TERADATA via ODBC.

TERADATA CONSULTANT, Confidential,Washington, DC: Jan 2005 Aug 2005 (P.S. Public Trust Clearance).

• Designed and coded AIX KORN shell scripts to run FASTLOADs, MULTILOADS, and BTEQs utilizing TERADATA’s parallel processing capability.
• Tuned TERADATA databases and assisted ADMIN personnel with specific administrative tasks.
• Met with users to map data and advised on the design of batch data warehouse processes.
• Decomposed mainframe FOCUS code and designed/developed compatible TERADATA processes.
• Performed on-call duties and assisted as necessary.

TERADATA CONSULTANT, Confidential, Richmond, VA: Sep 2004 Jan 2005.

• Responsible for conversion of SQL Server stored procedures to TERADATA procedures.
• Designed and developed ETL mappings using INFORMATICA 6.2 PowerCenter; execute and monitor using INFORMATICA Workflow Manager.
• Performance tuned TERADATA databases using established NCR methodologies.
• Assisted DBAs by creating physical db structures from logical models, generating DDL from Erwin.
• Coded TERADATA Macros and compared all AMP performance to one-AMP PROC processing.
• Converted mainframe FOCUS and DB2 extracts to WEBFOCUS and TERADATA BTEQ scripts using MVS/TSO.
• Coded MULTILOAD and FASTLOAD scripts for use in conversion table load processes.

TERADATA CONSULTANT, Confidential,Atlanta, GA: May 2004 Sep 2004.

• Coded FASTLOAD scripts to load data files using WIN32 Teradata for WINDOWS NT.
• Developed FASTEXPORT, MULTILOAD, and BTEQ scripts to transform data in existing TERADATA tables from staging to target.
• Assisted DBAs with implementation utilizing performance tuning skills, transforming LDM to PDM.
• Created data models from TERADATA SQL using reverse engineering methodologies with ERWIN.
• Supported AIX batch cycle using MAESTRO and KORN shell scripting; worked with PERL and AWK to perform file handling and operating system functions.
• Coded and ran Korn shell jobs using BTEQ, FASTLOAD, FASTEXPORT and MAESTRO.
• Developed JCL and loaded TERADATA tables using MVS/TSO.

TERADATA CONSULTANT, Confidential,Las Colinas, TX: Jan 2004 May 2004.

• Responsible for the entire Data Warehouse batch cycle using AIX Shell Scripting, BTEQ, FASTLOAD, FASTEXPORT and MULTILOAD; ran jobs on the mainframe using JCL to call AIX Korn Shell Scripts.
• Developed AIX Shell and PERL Scripts to perform transformation and load tasks with complex TERADATA SQL; exposure to Teradata Miner Stats.
• Worked closely with Teradata DBAs to identify performance issues and resolve using PMON in TERADATA MANAGER; assisted in DDL implementation from data models using ERWIN.
• Identified specific bugs in TERADATA V2R4.1 RDBMS and related findings to onsite NCR personnel.

ETL DEVELOPER, Confidential,Richardson, TX: Feb 2003 Dec 2003.

• Built tables in TERADATA Data warehouse using MULTILOAD, FASTLOAD, and BTEQ tools.
• Developed COBOL/DB2 extracts transforming DB2 tables for FASTLOAD into TERADATA.
• Developed TERADATA macros and manipulated tables using QUERYMAN.
• Developed VBA/MS ACCESS code supporting source to target data mapping; manipulated data models using ERWIN.

DATA WAREHOUSE DEVELOPER,Confidential,Kansas City, KS: Jun 2002 Jan 2003.

• Coded MVS JCL to use TERADATA BTEQ in batch; coded jobs that also use FASTLOAD and MULTILOAD to populate TERADATA tables.
• Performed database backup, recovery, archiving and restoration strategies including appropriate use of Archive/Recovery (ARC) utility, FastLoad, Online, and continuous backup (fallback).
• Developed TERADATA macros and stored procedures using QUERYMAN.

DATA WAREHOUSE DEVELOPER, Confidential,Plano, TX: Mar 1999 Jun 2002.

• Developed TERADATA extended SQL control cards for MVS batch using FASTLOAD and MULTILOAD.
• Coded MVS/JCL for TERADATA BTEQ in batch; used FILE-AIDE for DB2 to TERADATA mapping.
• Coded INFORMIX 4GL and C programs creating flat files to populate TERADATA tables.

PROGRAMMER/ANALYST, Confidential,Fort Worth, TX: Aug 1997 Feb 1999.

• COBOL II/CICS/INFORMIX online production support of manufacturing system.
• C/ESQL/INFORMIX 4-GL development in UNIX; KORN shell/C extract development.
• Support nightly batch cycle using VIS-TP/C/UNIX/CRON/SHELLS.

PROGRAMMER/ANALYST,Confidential, Dallas, TX: Jan 1997 Aug 1997.

• FOCUS/REXX development supporting online and batch production processes.
• VB/ACCESS development supporting Human Resources.
• PC FOCUS development and support.

PROGRAMMER/ANALYST, Confidential, Dallas, TX: Apr 1995 Jan 1997.

• COBOL II/IMS/PACBASE system development supporting BLUE SHIELD of California.
• IMS file maintenance using WAAPDSUT/ALC/COBOL.
• Generated reports and extracts using EASYTRIEVE PLUS/ALC.

PROGRAMMER, Confidential,Dallas, TX: Jun 1994 Apr 1995.

• JCL/COBOL II/DB2 batch development supporting State of Missouri child support system.
• COBOL II/CICS/BMS online screen development; 370 C/REXX/SQL-DS application development.
• DB2/QMF online report generation; utilized XM and other IBM internal tools.

Education:

MS Degree program in Information Technology
BS in Information Technology,
Electrical Engineering major