EMPLOYMENT HISTORY:

Confidential

Technical Consultant

Confidential

Managing Consultant

Confidential, Suwanee, GA

Analytics ETL Lead

Responsibilities:

• Lead a team of 4 Confidential data integration professionals.
• Assure that technical deadlines are met.
• Responsible for keeping track of the project plan to assure dates are met.
• Work with Project Manager to track status of changes and projects.
• Convert SQL Server Procedures to DataStage Jobs
• Convert SQL Server scheduled jobs to DataStage Sequencers.
• Streamline the data flows utilizing DataStage
• Validate and test data once it was loaded.
• Work with Cognos Developers to design Datamart.
• Train Confidential and GCPS resources to use DataStage

Confidential

Data Integration Lead

Responsibilities:

• Lead a team of 3 Confidential data integration professionals.
• Assure that technical deadlines are met.
• Responsible for keeping track of the project plan to assure dates are met.
• Work with Project Manager to track status on build of the warehouse.
• Defined extracts and jobs to load Confidential s Clinical data
• Created jobs to transform and load CIHI (Canadian Health Care Extract) into the data warehouse.
• Created SQL which loaded the Data Mart.
• Validate and test data once it was loaded.

Confidential, Nashville, TN

ETL Developer

Responsibilities:

• Create an extract solution for four data sources
• Create the solution for loading Historical data
• Assure that technical deadlines are met.
• Created the extract criteria from the Vanderbilt ODS.
• Responsible for keeping track of the project plan to assure dates are met.
• Work with Project Manager to track status on build of the warehouse.
• Create the ETL solution for the VUMC DataMart

Confidential, Dallas, TX

ETL Lead

Responsibilities:

• Lead a team of 4 Confidential data integration professionals.
• Assure that technical deadlines are met.
• Created the extract criteria from the Confidential ODS.
• Responsible for keeping track of the project plan to assure dates are met.
• Work with Project Manager to track status on build of the warehouse.

Confidential, Chicago, IL

Technical Lead

Responsibilities:

• Leading a team of 9 Confidential and Perficient data integration professionals.
• Assure that technical deadlines are met.
• Requesting Access for the applications needed by the data integration team to fulfill their parts of the project.
• Worked with the Confidential Business Metric owners to define the requirements for the prototypes and build process
• Worked with the Confidential IT staff to acquire and define data integration for the prototypes and builds.
• Once source systems were determined, I had to request Security for the various applications and data bases.
• Defined the security requirements for the Netezza EIA System
• Contributed and oversaw the completion of the five prototypes which were delivered to Confidential .
• Contributed and oversaw the production implementation of four of the completed prototypes.
• Worked with the Confidential project manager to oversee the completion of the prototypes
• Contributed to the build of the Solutions Architecture Document deliverable
• Contributed and oversaw the completion of the Harvest Reports deliverable
• Participates in the Confidential Architectural Decision Team.
• Implemented the UMLS standard codes into the EIA data warehouse.
• Work with Project Manager to track status on build of prototypes and the warehouse.

Confidential, Richmond, VA

Data Integration Team Lead

Responsibilities:

• Leading a team of 4 Confidential data integration professionals.
• Request Security for the various applications and data bases.
• Set up the test environment which was the base for the training and scoring UAT environments.
• Worked with the Confidential DBA s to finalize and verify the data copy sheets for the 7 states

Confidential, Roanoke, VA

ETL Lead

Responsibilities:

• Managed a team of 4 Confidential data integration professionals.
• Creating ETL jobs in DataStage to load EPIC Clinical Data into the Enterprise Data Warehouse (EDW).
• Gathered and organized all code information from Confidential and Aetna.
• Managed Offshore resources in India
• Managed onsite and Michigan resources.
• Created Netezza Load Scripts called by DataStage
• Created ETL jobs in DataStage to create the Chronic Care Data Warehouse.
• Worked closely with Carilion resources for smooth turnover

Confidential, Tampa, FL

ETL, DataStage Developer

Responsibilities:

• Created an assessment of an existing data mart
• Created a detailed list of improvements
• Created a document for upgrading to DataStage

Confidential, Washington, DC

ETL Lead

Responsibilities:

• Managed and coded a major RTI effort in DataStage
• Worked on a Business Objects XI upgrade
• Worked on a Netezza Conversion from Teradata
• Leading effort to move processing off mainframe
• Created ETL for new daily data marts
• Lead effort to migrate to upgrade the DataStage server
• Manage all on - going ETL changes.
• Created the mapping documents for each client
• Created shared code to be used by 5 of the clients

Confidential, Colorado Springs, CO

Data Integration Specialist

Responsibilities:

• Working with the Confidential account and Confidential customer to define the requirements for the migration.
• Created the ETL specifications.
• Created the ETL for the financial cut over.

Confidential, Columbia, SC

Data Integration Specialist

Responsibilities:

• Working with the Data Architect to define the customer requirements.
• Created all of the ETL specifications.
• Created all the ETL for the Warehouse.
• Trained and turned over the warehouse to the account team.

Confidential, St. Louis, MO

ETL Lead

Responsibilities:

• Worked on multiple data warehouse projects at Confidential during the years 2000 - 2007
• Worked with the Data Architect to define the customer requirements.
• Worked with the Data Architect to define the data model.
• Managed an on-shore and off-shore team of six ETL professionals, including assigning work
• Created all of the ETL specifications, initial and enhancements
• Designed and created all the ETL for the data warehouse in 2001
• Designed and created all the ETL for the numerous enhancements
• Trained and turned over the warehouse to the account team
• Business Objects universe and report developer for route delivery data warehouse

Confidential, Des Moines, IA

ETL Lead

Responsibilities:

• Created the specifications for an enhancement to load drug claims into the Data Warehouse.
• Evaluated ETL tools for the customer