Summary

ETL Specialist with 14 years of combined IT experience.
Demonstrated aptitude and willingness necessary to digest new technology and related tools.

Recognized for superior customer service skills and system troubleshooting skills, even during high-pressure and mission-critical outages.


Employment

2007 -  2008
Senior Database Developer

Currently responsible for implementing and maintaining ETL processes

2000 -  2007

Assistant Database Administrator/ETL Supervisor/ETL Developer hired to assist implementing an Oracle Data Warehouse like 1+ TB and associated Extract, Transformation and Loading processes.
Supervised ETL team of 3 responsible for developing, loading and maintaining all data loads from transactional system and from various outside vendors
Responsible for 600+ daily sessions loading data from XML files, CSV flatfiles and various Oracle tables
Responsible for testing developed ETL processes prior to going into production
Highly involved with planning and requirement gathering as it related to the Data Warehouse
Expert in Informatica Workflow management and development
Lead developer on extracting State Reporting requirements for Tennessee
Assisted in developing mappings for loading encrypted data
Instrumental in selecting ETL tool - Informatica versions PowerMart 4 through PowerCenter 7.1.2
Instrumental in hiring decisions for initial Data Warehouse department
Responsible for Informatica Administration server, security and hardware configurations
Assisted in UNIX directory layout for incoming flat files to be loaded
Introduced Informatica partitioning into workflows to increase performance
Recommended and assisted in creation for Oracle schemas and tables
Primary contact for Informatica vendor and licensing
TECHNOLOGIES USED ON A DAILY BASIS
Informatica PowerCenter 7.1.4
TOAD
SQL
AIX UNIX
Progress Procedure Editor
PuTTY
PowerTerm

1997 -  2000

Conversion Programmer hired to convert data from acquired clients into Sedgwick JURIS application.
Developed conversion programs in Progress database for loading data from Third Party Administrators like TPA into conversion databases
Developed programs to convert TPA into Sedgwick JURIS logic - financial conversions, financial balancing and notes
Developed programs to load converted data into Production database

1995 -  1997

Data Production Specialist responsible for balancing monthend financial reporting by client like approx. 700+ and monthly tape generation.

1993 -  1995

Support Analyst assisting with in-house software phone support and new client setup and maintenance.

Education