SUMMARY:

I am a Senior Consultant (Seventeen Years) with a focus on the architecture and development of Data Warehousing solutions. My focus has been on ETL development using Informatica, although many of my efforts include Business Analysis and Data Analysis to complete the ETL Design and Development process. I am a team leader who has architected and developed Data Warehousing solutions from every aspect of the SDLC (system development life cycle).

SPECIFIC EXPERTISE:

• Experienced Informatica, DataStage, ODI and Microsoft SSIS developer.
• Experienced in reporting tools such as Cognos, Business Objects, Microsoft Reporting Services and OBIEE
• Designed and implemented Metadata, Data Warehouses and Decision Support Systems
• Analyzed multiple types of transactional data stores to effectively design and map data marts and data warehouses

TECHNICAL SKILLS:

Industries: Financial, Healthcare, Manufacturing, Insurance, Agriculture

Languages/Utilities: XML, .NET, Toad, SQL Navigator, SQL Developer, SQL Server Enterprise Manager, SQL Server Query Analyzer

Databases: Oracle, DB2, Teradata, Sybase, AS400, Progress, MS SQL Server, MS Access and Informix

Operating Systems: All Windows Platforms’, AIX, HP UNIX, Linux

OLAP Tools: Business Objects, Cognos, Microsoft SSRS, OBIEE, Microstrategy

ETL Tools: Informatica PowerCenter versions 4.5 - 9.5, DataStage, Microsoft SSIS and ODI

Reporting/Decision Support: Cognos Products, Business Objects, Microsoft SSRS, OBIEE, Microstrategy

PROFESSIONAL EXPERIENCE:

Confidential, St Louis Park, MN

ETL Architect/ Informatica Developer

Responsibilities:

• Was able to reduce the load time from 9 hours to less than two hours.
• Indexes were not being dropped and recreated during Fact Loads
• By utilizing a rename strategy for fact tables, reporting down time is reduced to about 1 minute.
• Working on a source to target matrix to translate Informatica logic for their eventual migration to SSIS
• Analyzed data for month end reporting to verify validity of their reports

Confidential, Bloomington, MN

ETL Architect/ Informatica Developer/ ODI Developer

Responsibilities:

• ETL Architect/ Informatica Developer/ ODI Developer. The lead developer working with several off-shore resources.
• Worked on several projects using Informatica Power Center as well as ODI
• Developed and architected several ETL processes from many different source systems
• Worked with Oracle’s OBIA systems and customized the Indirect Spend, Finance and Supply Chain Modules in Informatica and ODI.
• Worked with OBIEE developers to translate and ensure proper join criteria from the Data Marts to the underlying OBIEE structures.
• Hands on experience with DAC scheduling and dependencies matrix.
• Shell Scripting experience for file manipulation.
• A member of the approval process to migrate all Informatica code from Development to Test and Production using Deployment Groups.
• Modeled several dimensions and fact tables, including an indexing strategy for reporting purposes.

Confidential, Saint Paul, MN

ETL Architect/ Informatica Developer

Responsibilities:

• Interviewed several business users and analysts to gather requirements for reporting.
• Architected and modeled several dimensions/ fact tables for their iterations needed for reporting on this proprietary RDMS.
• Data integrity was not enforced on the source system. Many data cleansing activities needed to be included in the ETL loads.
• Developed and architected all Informatica Workflows/ Sessions/ Mappings to include change data capture for all target tables as needed.
• Implemented and migrated all database objects as well as ETL objects from dev to test to prod.
• Was responsible for all aspects of this project from the backend (Database) to the front end presentation (Business Objects).

Confidential, Eagan, MN

ETL Architect/ Informatica Developer

Responsibilities:

• ETL Architecture/ Development, Analyzing source data as well as target data to ensure expected results. Design Business Objects Universe Models to support reporting requirements. Model database objects to support reporting requirements.
• Project Time Entry Data

Confidential, Minneapolis, MN

ETL Architect/ Informatica Developer

Responsibilities:

• The first project was called the WFSmart Re-plumb project. Unity is one of their JDE applications for Order detail. Confidential ’ Lakes was upgrading this JDE application, but needed to include all historical data from the previous version for reporting. We loaded this data and then tied to their new version to meet their reporting needs.
• The second project I worked on was called CRM Integrations. Extracted Data from their reporting Data Warehouse and pushed this Data to Oracle CRM OnDemand. Oracle CRM OnDemand is an application hosted by Oracle. Informatica has a plugin which allows insert/ update and deletion of data through web services. The previous method used to integrate CRM OnDemand was a .Net program which would take anywhere from ten to twelve hours on a daily basis. With the new Informatica plugin we are currently integrating two instances of CRM OnDemand (BDS and Winfield) on a nightly basis in less than thirty minutes.

Confidential, Eden Prairie, MN

ETL Architect/ SSIS Developer

Responsibilities:

• The objective of this project was to clean and enhance existing code for their medical claims data mart. The previous developers were well over budget and did not complete the project to Univitas acceptance.
• Cleaned up existing SSIS packages.
• Created new packages to fill in gaps in dimensional attributes.
• Developed, tested and promoted SSIS code to production.