SUMMARY:

• An energetic senior level ETL Developer with over thirty years experience in Information Technology. Possess mainframe, data warehouse and client server skills. Strengths include the ability to assimilate new information and come up to speed quickly, willingness to do whatever is necessary to complete the assigned tasks, and possesses a solid work ethic.

TECHNICAL SKILLS:

Tools: WebSphere Datastage 9.1, UNIX, BTEQ, TPT, Multiload, Toad, EDI, SQL Assistant, Shell Scripts, PL/SQL,T - SQL, SQL, DB2, COBOL,CICS, Micro Focus COBOL, Talend 5.1, Informatica 9.5

Databases: SQL Server, Oracle, Sybase, Teradata

O/S: Windows 9x/NT/2000/XP, Linux, Solaris, UNIX, DOS

PROFESSIONAL EXPERIENCE:

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Design & Creation of Datastage 9.1 Jobs and Sequences
• Creation of Unix Shell Scripts
• Creation of system documentation, mapping documents
• Creation of Autosys JIL
• Creation of Cross System Mapping
• Team mentoring of Jr members
• Creation of Oracle 11g scripts

Confidential

PS Consultant

Responsibilities:

• Design & Creation of Datastage 8.7 Transformations
• Creation of Teradata 13.10 BTEQ and TPT scripts
• Performance Tuning of Datastage 8.7 Teradata Jobs
• TWS Schedule creation
• Assist with onshore/offshore team supervision
• Kron scheduling
• Creation of Shell Scripts
• Datastage Client 8.7 install
• General Motors
• SR DATASTAGE DEVELOPER
• Analysis, design and creation of Datastage 7.5.2 server ETL transformations Oracle 10g
• Modification and creation of PVCS documentation
• Creation/Design Oracle DDL/DML
• Creation shell scripts

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Analysis, design and creation of Datastage 7.5.2 parallel ETL transformations
• Performance improvement modifications
• Creation of system documentation, detail design documents

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Analysis, design and creation of Datastage 8.1 transformations
• Creation of Technical Specs and Unit Test Documentation
• Creation of UDB SQL Queries
• Datastage 8.1 Client Install

Confidential

SR. TERADATA DEVELOPER

Responsibilities:

• Modification of SAS procedures and job streams
• Creation of Teradata ETL
• Creation of BTEQ/FASTEXPORT/MLOAD scripts
• Creation of ESP job control
• Creation of shell scripts

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Analysis, design and creation of Datastage 7.5.2 parallel ETL transformations
• Creation of BTEQ and multiload scripts to load teradata tables
• Creation of Systems Documentation
• Coordination of program releases Subversion

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Creation of BTEQ and Multiload scripts
• Design and creation of new processes to assist with automation of processes
• Creation of System Documentation
• Creation of Teradata SQL scripts to replace existing jobs

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Creation of System Documentation utilizing SDF.
• Analysis, design, creation of Datastage 7.5.1 Server
• Creation of BTEQ and multiload scripts.
• Co-Ordination of on-shore and off-shore non-employee resources

Confidential

SR. DATASTAGE DEVELOPER

Responsibilities:

• Creation of Summit Requirements, Technical Specifications and Testing documentation.
• Analysis, design, creation of Datastage 7.5.1 Server Transformations from and to Oracle 9.0i and Teradata V2r5 using PL/SQL.
• Creation of Tivoli Workload Scheduler jobstreams
• Creation of stored procedures and triggers

Confidential

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Modification of Medicare to create additional match/merge capabilities using COBOL, CICS, DB2, ENDEVOR and calling stored procedures.
• Analysis and Technical Specifications of Modifications.

Confidential

DATASTAGE DEVELOPER

Responsibilities:

• Analysis, design, creation of Datastage 6.0 Server Transformations from and to Oracle 8.0i using PL/SQL, sequential file and UDB for Microsoft SQL Server.
• Creation of system documentation, detail design documents and autosys run jcl
• Daily support of Cobol, CICS, DB2, FTP and NDM applications
• Modification of existing stored procedures.

Confidential

DATASTAGE DEVELOPER

Responsibilities:

• Analysis, Design and Creation of Datastage 7.0.1 Server Transformations to and from Oracle 8.0i, Sybase, UDB for SQL Server and Mainframe DB2 loads.
• Creation of related korn shell scripts, procs, and run jcl in an
• AIX environment
• Acting Team Mentor for four programmers

Confidential

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Modification of Medicaid Claims Adjudication State of Georgia in COBOL, CICS, DB2, and creation of stored procedures.
• Analysis and Technical Specifications of Claims Modifications.

Confidential

DATASTAGE DEVELOPER

Responsibilities:

• Creation and modification of EC Gateway processes, korn shell scripts and procs on AIX.
• Creation of micro-focus COBOL programs for use in Ansi X12 HIPAA transaction processing.
• Multiple ETL transformations for a mainframe data warehouse using DATASTAGE 5.2 and Sybase Transact-SQL, UDB for SQL Server, Oracle 8.0i(PL/SQL), mainframe DB2.
• Creation and modification of RS6000 korn shell scripts used to control FACETS nightly adjudication.
• Modification of FACETS claims adjudication using C.

Confidential

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Maintenance and enhancement of COBOL, CICS, DB2 programs for online billing.
• Modification of billing system using C, Unix, Korn Shell Scripts, ENDEVOR and Lotus Notes

Confidential

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Installation of in-house developed Data Warehouse System using Cobol, CICS, DB2
• Creation of custom user reports to ensure integrity of newly loaded data using QMF

Confidential

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Responsible for maintaining, and enhancing the Vantage One annuities system per customer requirements using COBOL, VSAM.
• Responsible for enhancements to the Vantage One IPS (Insurance Publishing System) to meet customer specifications.

Confidential

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Site support of four Nuclear Plants, maintaining and enhancing as constructed/as designed system to ensure that all systems were meeting the current NRC guidelines for record accountability using a mix of Cobol, CICS, DB2, Unix, C, Endevor and Oracle.