Sr. Technical Consultant Resume

TECHNICAL SKILLS

Confidential is a Senior Technical Analyst with experience in teh Health Care Business Intelligence. Confidential TEMPhas 8+ years of strong experience with Information Server DataStage in analysis, design developing, implementation and administration of Enterprise Data and Data application in teh health care industry.
Confidential also TEMPhas Information Server DataStage Administration experience performing installation, creating Groups, User and required environment variables and Projects for DataStage version 7.5 - 8.5.1. He also possesses strong experience with Information Server Change Data Capture and Information Server manager, which is used for migration.
Confidential TEMPhas led teh data integration team in teh development, testing and migration of DataStage and Change Data Capture.
He TEMPhas experience working with teh client identifying data sources, data extraction, processing and program design and implementation.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. Technical Consultant

Responsibilities:

Built 30+ CDC subscriptions accessing Oracle Supply Chain Tables, which captured all database events and passed these events to teh DataStage environment to be processed and loaded to a Netezza database. Mentored client resources on Information Server Change Data Capture and DataStage
Built several Information Server DataStage process for patient Point of Care system.
Automated DataStage processes utilizing Information Server DataStage Sequencer.
Assisted client implementation team on installation of Information Server DataStage and CDC on a Virtual failover platform.
Developed migration process document outlining teh migration steps utilizing Information Server Manager and Tortoise SVN.
Developed step by step documentation for implementing DataStage and CDC projects between environments.

Confidential

Data Integration Manager

Responsibilities:

Installed Information Server DataStage on 3 different environments.
Created DataStage projects, User-id and Groups, environment variables, configuration files.
Lead for teh Data Integration Team, which includes developer code review, mentoring junior developers, training for new ETL developers and interviewing new candidates.
Establish best practice for DataStage performance, file directory structures, DataStage naming conventions and Error handling.
Developed test plans for UAT and performed QA on all ETL processes.

Confidential

Technical Consultant

Responsibilities:

Developed several DataStage processes accessing Oracle source tables creating an enterprise patient Id.
Developed process to gather all patient MRN’s from different hospitals and assigning teh MRN under 1 Enterprise Patient ID
Documented DataStage migration process and best practices

Confidential

Data Stage Administrator/ Developer

Responsibilities:

Full life cycle implementation of new Enterprise Data Warehouse
Designing and coded several DataStage processes.
Built ETL process for loading Teradata using Multiload, Tpump and Fastload utilities.
Performed Data Profiling of Legacy data, which was used for teh design of teh Physical Model.
Manage Production Change Control ensuring dat user acceptance testing and sign-off were successfully completed. In addition was team representative at production review meetings.
Performed DataStage code review and documentation.
Use SQL extensively for data analysis and troubleshooting.
Project Manager for teh implementation Lawson Financial systems.
Project Manager for teh Implementation of Business Objects Crystal.

Confidential

Project Lead/ETL Developer

Responsibilities:

Led teh 3 person development team in building teh first financial Enterprise Resource Planning (ERP) system.
Worked with teh Unix team in building necessary scripts to execute teh Informatica processes.
Performed testing and migration of all Informatica processes.
Migrated all Informatica processes to teh Production environment
Monitored and supported teh production environment
Met with in-house customers to gather business requirements
Developed teh technical design specification
Designed data integration processes and led teh development team