SUMMARY:

Confidential is a Senior Technical Analyst with experience in the Health Care Business Intelligence. Confidential has 8+ years of strong experience with Information Server DataStage in analysis, design developing, implementation and administration of Enterprise Data and Data application in the health care industry. Confidential also has 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 has led the data integration team in the development, testing and migration of DataStage and Change Data Capture. He has experience working with the client identifying data sources, data extraction, processing and program design and implementation.

PRIMARY TECHNOLOGIES:

Architecture: Data Integration and Transformation

Integration Information Server DataStage

Information Server Change Data Capture

Implementation: Information Server Manger

Administration: Installation of IBM Information Server Suite

TECHNICAL SKILLS:

Tortoise SVN

Informatica Power

UNIX

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 the 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 the 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 the 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 the 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 the design of the Physical Model.
• Manage Production Change Control ensuring that 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 the implementation Lawson Financial systems.
• Project Manager for the Implementation of Business Objects Crystal.

Confidential

Project Lead/ETL Developer

Responsibilities:

• Responsible for forming the Data Integration team with mainframe programmers that I had mentored to used Informatica Power Center.
• Led the 3 person development team in building the first financial Enterprise Resource Planning (ERP) system.
• Worked with the Unix team in building necessary scripts to execute the Informatica processes.
• Performed testing and migration of all Informatica processes.
• Migrated all Informatica processes to the Production environment
• Monitored and supported the production environment
• Met with in-house customers to gather business requirements
• Developed the technical design specification
• Designed data integration processes and led the development team

Confidential

Consultant

Responsibilities:

• Project Leader responsible for retiring 5 legacy systems as part of the Y2K conversion process, which I Identified all recipients and documented all outputs produced in the Legacy systems.
• Developed a customer questionnaire that was distributed to each of the output recipients to identifying their report or file and to have them list their requirements for the output that they receive.
• At the project end 3 of the 5 Legacy systems were retired.

Confidential

Consultant

Responsibilities:

• Member of a team of 3 developers to design and build a Juvenile court system using MicroFocus Cobol, the system will tracks and registered the Juvenile as they are processed through the court system.
• The system would keep records for 5 years and will flag repeat offender.

Confidential

Consultant

Responsibilities:

• Developer on the credit card project, technology used COBOL and CICS that would notify the customer service representative on customer that are eligible for a Confidential credit card.
• The system design would keep the notification prompt regardless of what DataBase domain was being used.

Confidential

Consultant

Responsibilities:

• Mainframe developer on the IBM development team using COBOL on Product system, which used a new process where Supervisor and Atomic level programs were developed to take data from the Online system and update DB2 tables.

Confidential

Senior System Analyst

Responsibilities:

• Project lead for the Premium Claims Accounting mainframe system, technology used; COBOL, CICS, JCL and TSO, additional responsibilities included customer and production support.