PROFESSIONAL OVERVIEW

• Seasoned IT professional with over 20 years of experience implementing datawarehousing and business intelligence solutions around the globe.
• Data Architect, Technical Architect, ETL Architect, Product Development Solutions Lead
• Team Lead Primary Technologies
• Infosphere Datastage v8 Certified, QualityStage, SSIS, SSRS, SSAS, Informatica, Crystal Reports
• Oracle 9i, DB2 UDB 8.1, Netezza, SQL Server 2008, DashDB (DB2 on the cloud), SQL Server on Azure
• C, C++, VB, Perl, Unix Scripting
• EPIC/Clarity, Envision, Quadromed, Confidential HCPDW Atomic Warehouse Model, Confidential EPM
• Microsoft Project, CVS, SVN, SourceForge, Visio, Erwin
• Linux, Unix, Windows Server Other Technologies Ab Initio
• Hyperion Essbase, Wired for OLAP
• Java, Tivoli Workload Scheduler (TWS)

PROFESSIONAL EXPERIENCE

Confidential

Senior Technical Architect/Product Development Solutions lead

Responsibilities:

• Lead a team of 5 developers in an implementing the ETL Architecture.
• As all where new developers, worked extensively to train them on our ETL Architecture and the UDMH Confidential model
• Worked with the QA team and the Data Analyst team to train then on applications and procedures that will be implemented on all healthcare projects going forward.
• Worked closely with the project manager to implement the Agile methodology as part of the project and to build out the project plan for Developers and Testers
• Created Unit Test Plans and Deployment Processes
• Worked with client resources to do knowledge transfer of the entire load process

Confidential

Responsibilities:

• Gathered requirements and created a detail design document that would implement the solution
• Worked with the client to define matching rules based on patient id, Medical record number, Patient Name, Patient Address
• Based on Patient requirements, used very small variances to determine duplicate patients to eliminate as many false positives as possible
• Survivorship rules where implemented to merge duplicate records into one master record
• Data Architecture was designed to have a cross reference table that would link the new master record to the original patient records for reporting purposes

Confidential

Responsibilities:

• Lead a team of 8 developers in an implementing the ETL Architecture
• Worked with project manager to implement the Agile methodology as part of the project
• Created Unit Test Plans and Deployment Plans
• Mentored young developers into more senior roles
• Worked with client resources to do knowledge transfer of the entire load process
• Created additional standard ETL Assets that are now added to our architectural solution

Confidential

Responsibilities:

• Lead a team of 10 developers in implementing a new ETL Architecture
• Did data analysis of the EPIC/Clarity source system
• Created a new ETL Architecture to load data from multiple source systems to the Confidential Atomic Warehouse Model
• Created Unit Test Plans and Deployment Plans
• Designed and Implemented a fully integrated load process involving, DataStage, Unix Scripts, Multiple databases and Control - m Scheduling tool

Confidential

Responsibilities:

• Did Requirements Gathering, Analysis and then created High Level Design and Technical Design Documents
• Created the Asset Management Data Model as well as an Audit, Balance and Control Data Model to manage the entire process
• Coordinated between the source systems, the business and the development team to build, test and to deploy the data warehousing solution into production
• Created the Confidential data warehouse using SQL Server 2005
• Used SSIS as the ETL tool to build packages that would take data from source systems, place data into landing directory, cleanse the data and place into staging tables, and then load into the data model
• Used SSIS Control Flows to automate the data flow process and build dependencies between packages, run packages based on prior conditions and to send out success and failure emails to developers and source systems data providers
• Wrote custom VB.NET scripts to extend the functionality of SSIS where standard toolbox components were not available to meet the needs of the project

Confidential

Responsibilities:

• Lead a team of 3 developers in implementing the ETL Architecture
• Worked with project manager and ETL Architecture lead to integrate the solution with the existing Assets for CHS
• Created Unit Test Plans and Deployment Plans
• Mentored young developers who aren’t familiar with how the assets work

Confidential

Responsibilities:

• Gathered requirements and then created High Level Design and Technical Design Documents
• Developed Code using Infosphere DataStage, Perl, and Unix Scripting
• Created Unit Test Plans and Deployment Plans
• Created a process to deploy code from a remote development environment to the clients testing environment
• Installed and configured DataStage Dev, Test and Production environments on linux
• Created a process to upgrade DataStage 7.7 Environment to DataStage 8
• Configured DataStage to Work with Oracle 10i database

Confidential

Sr. Technical Consultant

Responsibilities:

• Loading the accounts payable data mart by customizing the Confidential EPM DataStage jobs to meet the clients’ needs
• Creating technical specs and ETL best practices documents
• Create Deployment plan to better manage the deployment of Code from one environment to another.

Confidential

Responsibilities:

• Create Project Plan, high level design documents and Technical Design Documents.
• Created the HR Confidential Data model.
• Knowledge Transfer to the client on datawarehousing standards and best practices

Confidential

Sr. Technical Consultant

Responsibilities:

• High Level Design for the overall Confidential
• Managed the creation of the detail designs based on the High Level Design
• Technical lead in the overall development of the Confidential

Confidential

Responsibilities:

• Team Lead to 20+ Confidential Consulting Developers
• Responsible for All ETL code related to this project
• Create Documents on ETL standards and Best Practices

Confidential

Responsibilities:

• Write All custom datastage code and prepare it for loading into SAP
• Train All Confidential on how and when to use DataStage PX vs. DataStage Server
• Create deployment scripts for all ETL code created for this project