Objective
To obtain a position within the Data Warehousing area (, including analysis, coding, design, QA, and operations).

Employment

02/2006 -  11/2006
Sr. Release Engineer

Feb 06 Nov 06 : Functioning as the Data Warehouse Lead, performed Quality Assurance, debugging pre-production validation and approval tasks for all ETL and Data Mining components, : Oracle SQL like both DML and amp ; DDL, Unix Scripts and batch schedules, Appworx, Trillium/Tibco modules and Informatica Sessions, Workflows and amp ; Mappings.

acted as a key participant during all major US, European and Asian software releases, rendering guidance and assistance to developers, project managers and business analysts in addition to providing as-needed 24/7 support during and after each implementation.

In addition, created all necessary Production Release Methodology documentation, for use when assuming the bi-weekly role of Instructor during formal company-wide training classes.

03/2005 -  01/2006
Sr. Technical Architect

Mar 05 - Jan 06:Performed Quality Assurance (QA) duties on the Technical Architecture and Design Products of a multi-phase Data Warehouse CA-TNG implementation and conversion, as well as :

Gathering business requirements, and developing functional specifications to meet additional
marketing and product-positioning needs; writing the TNG Project Proposal, developing the
project ERD, and creating resource usage and cost estimates/proposals for each phase;
obtaining Business Unit Management approval of staffing levels and the project timeline;
performing a Sarbanes-Oxley compliance audit; functioning as a Technical Writer, composing
nearly two-thousand pages of technical and production job/script specifications, process
diagrams, and step-by-step operations error-handling procedures; creating the TNG batch
schedule definitions for each Informatica task/ETL transformation; and providing remote
operations support.

Environment: SUN Solaris (UNIX), Teradata (SQL Assistant), Oracle Tools, Sybase 12,
WinSCP3, FTP/Telnet, MS-Access, MS-Word, MS-Excel, X-Client, Windows XP, CA-TNG,
Visio, Documentum, SharePoint, MS-Visual Studio 6 Tools, Informatica 7 Workflow
Manager

09/2004 -  01/2005
Sr. Quality Control Analyst - Data Warehousing

Sept 04 - Jan 05 : Was assigned to the Quality Control team as a Senior Analyst and Tester, tasked with ensuring that new software releases and Enterprise Data Warehouse changes met each
Functional Specification and Business Requirement. Identified all coding changes to be made to conversion feeds, extracts and Business Objects reports ; verified the data cleansing and transformation routines, coding and executing all required Teradata SQL data transfer or data administration utilities and UNIX commands/scripts.

Additionally, functioned as a Subject Matter Expert for the Billing and Conversion systems and worked with the Business Analysts and ETL Programming Teams to resolve all pre- production issues.

Environment : HP UNIX, Teradata, Teradata Tools Administrator, SQL Assistant, Visual
Explain, Warehouse Miner, WinSCP3, Telnet, MS-Access, MS-Excel, Business Objects
Web Intelligence, MS-Query, Hummingbird, Windows XP, MS Data Transfer
Services, Visio

07/2004 -  08/2004
Data Warehouse Designer

Jul 04 - Aug 04 : On a Data Warehouse conversion project, functioned as a
Business Analyst and Testing/Validation Co-ordinator, working with User Management and Subject Matter Experts to define system requirements, data definitions, cross- functional interfaces and to validate the metadata repository.

Also, in advance of the start of the programming phase, worked with the team to create
Business Rules Spreadsheets, identify and correct errors in domain definitions and to refine both the warehouse and data mart models.

Environment : MVS Z/OS, AIX, SAS, TSO, JCL, DB2 or UDB 7, MS-Query, SQL, MS-Access, DB2 Tools for Win2K, Mainframe Utilities, Visio, Lotus Notes, Windows 2000

10/2003 -  06/2004
Sr. Data Warehouse Programmer/Analyst

Oct 03 - Jun 04: Created extracts for custom-designed Datamarts using FOCUS (online and batch), Easytrieve, COBOL, JCL/Clist, IMS/DL1, MS-Access and DB2, for loading into an Oracle on Solaris database. As well, was assigned sole responsibility for all Marshall Fields projects, performing all necessary Business Analysis, Requirements Definition, Testing and
Implementation, then created an original set of Technical Documentation. Other software
used included SQLTools, SQLPlus, CA-SMR/JMR, RPT-VIEW, GSAM/VSAM (, plus FileAid,
Endevor, & Strobe).

Environment: MVS Z/OS, COBOL, FOCUS, TSO, Easytrieve, JCL, VSAM, GSAM, FTP, Clist,
Dialog Manager, Oracle, SQLTools, SQLPlus, CA-SMR/JMR, Visio, MS-Access,
Windows XP

08/2003 -  08/2003
Sr. Programmer/Analyst

Aug 03 - Aug 03: Coded COBOL and PL1 programs, along with associated JCL/procs, then implemented and executed, in order to effect the cleansing and loading of historical data into the comprehensive Customer Information Data Warehouse.

Environment: MVS/OS390, COBOL, PL/1, TSO, JCL, VSAM, DB2, SQL, Windows XP

07/2002 -  02/2003
Sr. Programmer/Analyst

July 02 - Feb 03: Worked on retrofitting new functionality into an existing online and batch Federal Railroad Administration Compliance system, primarily using mainframe FOCUS, Teradata, Clist, and PL/1. Designed, coded, created Data Models for, and implemented all necessary screens, scripts, databases, and programs, as I was assigned sole responsibility for the entire effort. Additionally, designed and coded the Lotus Notes data interface, then
performed all post-testing Quality Assurance tasks.

Environment: MVS/OS390, TSO, JCL, Lotus Notes, FOCUS, Teradata, Clist/REXX, PL/1,
Mainframe Utilities, Visio, Windows 2000.

06/2001 -  06/2002
Independent Consultant

Jun 01 - Jun 02: Worked as an Independent Consultant, setting-up and configuring both ethernet (Windows, Unix, and Macintosh) and wireless networks. As well, I worked as an instructor specializing in Windows, Web usage, Macintosh, and Applications Software, and functioned as a part-time IT Placement Agent.

Environment: UNIX/Linux, Macintosh, LinkSys/USRobotics Routers, Windows XP.

12/2000 -  06/2001
Project Lead - Data Warehouse

Dec 00 - Jun 01: Performed Claims & Pharmacy business analysis and data design as part of a large Data Warehouse Extract, Transform, Cleanse, and Load (ETL) effort. Also, working withinthe Data Administration group, created, validated and refined a series of Warehouse /ODS data models, sourced from IMS, VSAM, SAS and FOCUS.

Additionally, coded and tested several MVS COBOL ETL programs for a parallel UDB/DB2
Operational Data Store (ODS), performed Data and Process Architecture Design (using
Er/Win), and worked with the Business Objects/Oracle Data Mart CRM and SCM delivery
teams.

Finally, as Project Lead, was called upon to design/create the batch architecture for the
loading of the mainframe Data Warehouse and Oracle Data Marts.

Environment: MVS/OS390, TSO, JCL, IMS, VSAM, SAS, FOCUS, COBOL, Oracle,
Business Objects, Mainframe Utilities, DB2/UDB, MS-Access, Er/Win, Visio, Windows 98.

04/2000 -  10/2000
Sr. Data Warehouse Consultant

Apr 00 - Oct 00 : Was engaged with Extract, Transform, Cleansing and Load tasks for a critical portion of a new state Public Assistance and Medicaid Tracking History Data Warehouse. In the course of doing so, I coded routines in SAS, QMF, MVS/COBOL, IMS/DB, VSAM and UDB/DB2 like, along with associated JCL and utilities and retrofitted existing CICS data conversion programs.

Tasks included validating the Data Models, from both a functional and technical standpoint, so as to ensure the completeness and correctness of the Warehouse and the
Data Marts. Finally, participated in cleansing/mining/OLAP tool selection, Microstrategy and in pre-production operational support.

Environment: MVS/OS390, IMS, VSAM, SAS, FOCUS, COBOL, CICS, DB2/UDB, TSO,
JCL, Mainframe Utilities, Microstrategy, Windows 2000.

01/1999 -  10/1999
Sr. Programmer/Analyst

Jan 99 - Oct 99 : Supported the Marshall and amp ; Ilsey Accounting/Collections System, performing all required business analysis. As well, coded new and maintained existing, programs in COBOL, IMS DB/DC, CICS, VSAM, FOCUS, Assembler and SAS. Concurrently, I supported proprietary Desktop Systems written in Lotus 1 - 2 - 3 and MS-Access, and functioned as a Mentor and amp ; Technical Resource, while participating in the development, design, and ETL of the Collections Data Warehouse. As well, generated and maintained production reports using both Crystal Reporting Tools and Cognos.

In addition, was responsible for every task related to the implementation of Western Unions
PhonePay and QuickCollect. This consisted of : debugging a half-dozen Beta versions and identifying necessary modifications ; specifying, budgeting for and ordering all necessary hardware, software, security and physical infrastructure ; and scheduling installation, support and training.

Environment : MVS/OS390 IMS, VSAM, SAS, FOCUS, COBOL, CICS, TSO, Lotus, Assembler, MS-Access, Visio, Crystal Reports, COGNOS Impromptu/Powerplay, JCL, Mainframe Utilities, Windows 98.

08/1997 -  11/1998
Sr. Programmer/Analyst

Air Products and Chemicals
Sales Management, European Operations Systems

Viasoft or ASG Software
Software Development, Consulting and Technical Services

20th Century Fox
Internal Control and Accounting Systems

Aug 97 - Nov 98 : After having completed the successful conversion and Quality Assurance certification of 2 large CICS, FOCUS, COBOL/IDMS, VSAM, Assemblerbased mainframe and Windows systems, lead a team involved of an effort to re-develop several mid-sized MVS systems, using such tools as CA-Revolve.

In addition to teaching/mentoring the portion of my team located in Madras, India, and like as QA Lead, developing Quality Assurance metrics, my responsibilities included : Account

Technical Lead like and technical resource for other accounts, nationwide, Business Impact

Analysis, PC Support, full-scale Unit Test design authoring and modification/testing of several hundred like batch, online and PC-based FOCUS programs. Concurrently, was tasked with activities like coding, reviewing, testing and implementation associated with existing Clist, REXX, COBOL, SAS, IDEAL, Assembler, PL/1 and FORTRAN modules.

Environment: MVS/OS390, VSAM, FOCUS, COBOL, CICS, SAS, PL/1, TSO, JCL,
Assembler, Mainframe Utilities, FORTRAN, IDMS, Windows 95/NT, Visio, Clist/REXX

01/1996 -  08/1997
Sr. Programmer/Analyst

Jul 96 - Aug 97: Performed as a key, independent member of a team developing batch, online, and EDI interfaces between cross-functional internal systems, and other transportation firms systems. Completed all tasks, in every phase of the development cycle, where the functional areas that had been assigned were involved. These tasks included: Business Analysis, Logical Design, Physical Data and Process Design, Formal Specification andDocumentation, and Construction/Implementation.

Physical components were built using COBOL2, CICS, IMS-DB, and DB2, as well as FOCUS
and BMS/GT. Also used were QMF, BMC and Platinum utilities, Business Objects, and
INFOPAC.

Jan 96 - Jul 96: Personally modified, tested, and implemented dozens of inter-related, inter-dependent COBOL and FOCUS programs, as part of a Sales Analysis System (and Sales Force Management) restructuring. After completing, was presented with a Corporate
Outstanding Achievement and Excellence award.

Environment: MVS, IMS, VSAM, DB2, FOCUS, COBOL2, CICS, BMS, TSO,
Business Objects, Mainframe Utilities, EDI X.12, JCL, Visio, Windows 95/NT, OS/2

10/1995 -  01/1996
Sr. Programmer/Analyst

Oct 95 - Jan 96: Coded several dozen programs using COBOL, CICS, VSAM, Oracle, and DB2, from pre-written specifications. Developed the test plan for each program, as well as the
plans for systems integration.

Environment: MVS, VSAM, COBOL, CICS, DB2, Oracle, Novell Netware, TSO, JCL

04/1995 -  09/1995
Sr. Programmer/Analyst; Data Administrator

Apr 95 - Sep 95 : Participated in the logical design of an Asset Accounting, Tracking and Billing system, and was solely responsible for the physical design of many of the mainframe-based components. Functioning as the Lead Analyst/Programmer, re-designed key DB2 tables and coded core-function modules, using online and batch APS COBOL
IMS/DB2/VSAM, Assembler and C. In addition, created and maintained the mainframe
System Design Documentation set and was responsible for all implementation and Quality Assurance tasks.

Environment : MVS, APS Online/Batch, COBOL, IMS, DB2, CICS, VSAM, Assembler, C, TSO, JCL, Mainframe Utilities, Windows 95

03/1993 -  03/1995
DBA; Data Administrator; Database Performance Engineer

Wachovia / First Union National Bank
Capital Markets Federal Reserve Reporting Arbitrage and Trading Floor Operations

Fieldcrest Cannon Textiles
Inventory, Production and Operations Research Systems

Home Depot
Corporate Database Administration Group

Mar 93 - Mar 95 : Redesigned and re-indexed large DB2 databases, greatly improving performance ; associated Easytrieve/SQL to take advantage of new data structures. Wrote utilities to uncover and report potential DB2 DASD usage problems, utilizing Access Method Services, SAS and DataEase PC Also, as the need arose, engaged in systems-level application performance monitoring and tuning and older CICS/COBOL programs, based on requirements gathered using APS prototyping. As needed, wrote and enhanced C programs, Assembler modules, Forest and Trees and Oracle queries and HTML Intranet pages.

Environment: MVS, COBOL, APS, IMS, DB2, CICS, SAS, Assembler, C, Easytrieve
EZ-IQ, HTML, Oracle, DataEase, Windows 3.1/95, Novell Netware, Visual Basic, TSO, JCL

01/1992 -  01/1993
Lead Enterprise Analyst

Sep 92 - Jan 93 : Coded conversion programs in COBOL2 and IDEAL/SQL ; coded online screens and EIS modules in IDEAL, using System Builder or IDEAL code generator ; created Datacom/
Database SQL views using CA/Data-Dictionary ; performed first-cut performance evaluation. Also developed end-user reports and Executive Information System macros using DataQuery.

Jan 92 - Aug 92 : Joined IT Business Process Re-engineering team as Lead Enterprise Analyst and was assigned the Materials Management and Supply Chain business group. Participated in JADs, defined E-R Diagrams using AutoMate/System Engineer and developed Data
Flows. Additionally, designed and coded the firms inventory forecasting models and functioned as Lotus Notes Administrator.

Environment : MVS, COBOL2, Datacom Database, CA-IDEAL, CA-DataQuery, Systems
Engineer, TSO, JCL, Systems Architect, DR-DOS, Windows 3, Visio, Lotus Notes

01/1989 -  12/1991
Software Engineer

Jan 91 - Dec 91: Created System Internal Specifications for a new batch system. Programmed critical COBOL2 (DB2/IMS) programs under BTS/IMS, and tuned databases. Creation of proto-type ad-hoc environment (views, queries, and FOCUS execs) followed. Personally designed batch system architecture, including the DB2 and Oracle data models. Was then chosen from a group of over one-hundred to develop a rapid-payback alternative;
generated SCM cost/benefit analysis yielding savings of 4.5 million per year, for 5 years.


Jan 89 - Dec 90: Was engaged in IMS DB development using PL/1; implemented enhancements to the existing insurance claims system. Then, joined a large DB2/IMS project, and worked on the JAD and System Design Phases. Created Data Flow Diagrams, E-R Models, and data structures using SAS (Base, Stat, Graph), FOCUS, and QMF.

Was then assigned responsibility for Reporting subsystem, and adhoc (on-demand) query
development. Coded Reporting System prototypes in Easytrieve Plus, and wrote specific-
ations for all programs / screens.

Environment: MVS, COBOL, IMS, DB2, SAS, VSAM, Oracle, FOCUS, PL/1, BTS, QMF,
Clist/REXX, IEF, SAS/JMP, TSO, JCL, Easytrieve Plus, VAX VMS, Windows 2.0

06/1986 -  12/1988
Systems Engineer

Jun 86 - Dec 88: Maintained and enhanced a large online system using IMS DB/DC, Janus DB, MFS, and PL/1. Also wrote and maintained a variety of programs in both PL/1 and
Easytrieve Plus, and performed Data Modeling / Data Administration activities.

Was chosen to personally design and develop a secure system front-end consisting of
two dozen screens, a similar number of programs, and a new (converted) database.

Functioned as Systems Administrator for Honeywell/Multics-based Consistent System
(CS) online and batch system, performed staff-level customer support activities, and
provided technical support with CS staff at the Massachusetts Institute of Technology.

In addition, performed as the Janus Database Administrator, in which capacity designed
and maintained all physical/logical database structures, and coded all necessary
application programs, system utilities/scripts, and queries. Concurrently participated in
the JAD of planned system re-design and mainframe conversion, and developed an
Executive Information System (EIS) using Janus/UNIX DB and scripting.

Environment: MVS, TSO, JCL, UNIX/MULTICS, COBOL, PL/1, IMS DB/DC, MFS,
Easytrieve Plus, Clist/REXX, Dialog Manager, VAX VMS, Janus DB, UNIX Scripting

Education

Miscellaneous
Skills Inventory

SKILL / YEARS EXPERIENCE

Microcomputer/PC Programming 28
SQL, QBE and JCL 22
Microsoft Word, Excel (Office Tools) 22
Source and Document Library Mgmt Tools 21
COBOL, COBOL2, MVS COBOL/390 17
CA1, CA7, CA11 17
FileAid, Syncsort, DFSort 17
Clist, REXX, Dialog Manager 14
Visio, Powerpoint, Graphic Design Tools 13
DB2, UDB, SPUFI, DB Utilities 12
IMS DB/DC, MFS 12
Data Modeling and Design 11
Focus (Online, Batch, and Web) 8
CICS, BMS, Intertest 7
Expediter 7
SAS (Base, Graph, Stat, JMP) 7
Easytrieve Plus, EZ-IQ 7
OLAP and Data Mining Tools 7
Microsoft Access 7
PL/1 and PL/C 7
Data Warehousing and Quality Assurance 7
CASE and Modeling Tools 6
Assembler (IBM, DEC, PC) 5
UNIX, Multics, AIX,HP/UX, Shell, Tools 5
Viasoft Insight, Smarttest 4
Oracle and Oracle Tools 4
Lotus Notes, Domino 3
Electronic Data Inter. (EDI) 3
DataEase PC3
APS Batch & Online Express 2
CA-DATACOM, IDEAL, DataQuery 2
C 2
Teradata and Tools 2
IDMS 1
CA-ROSCOE/RPF 1
HTML/XML 1
Sybase 1
Informatica PowerCenter 1
Trillium / Tibco Middleware 1

ADM, SAM, Method/1 - Accenture Methodologies
SLC/SDLC - Systems (Development) Life Cycle
SDM/70 - Systems Development Methodology
Kimball & Inmon - Data Warehouse Design