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).
• Experienced Informatica, DataStage, ODI and Microsoft SSIS developer.
• Experienced in reporting tools such as Cognos, Business Objects and Microsoft Reporting Services
• 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

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

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

PROFESSIONAL EXPERIENCE:

Confidential (Bloomington, MN)

ETL Architect/ Informatica Admin/ 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 9.5 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 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.
• 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 DataThe goal is to take all time entry data and organize it into a Star Schema for Budget, Revenue and Cost reporting. I am responsible for designing source to target mappings and developing all mappings on this project. This project involved many complex mappings to complete. The source of all data is SAP’s Business Warehouse in a DB2 Database.
• This project involves extracting SAP workflow information. A workflow in SAP is a process to create objects, in this case Materials. Business users want to report on durations involved in creating, modifying or extending materials. There are several workitem steps involved in creating a material. Examples of these steps are the various approval steps (Finance, Basic, Tax). The business wants to know what steps are holding up the Material Workflow process and through business process improve turnaround time.

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.

Confidential (Charlotte, NC)

ETL Architect/ Informatica Developer

Responsibilities:

• Worked specifically with mapping legacy data into Dukes data warehouse.
• Completed all of the business analysis by interviewing business users to effectively map legacy data into current logical metrics.
• Created all source to target documentation and mapping specifications.
• Created all Informatica mappings, sessions and workflows following specifications I had put together.
• Validated, tested and migrated all Informatica mappings to production.

Confidential (Eagan, MN)

ETL Architect/ Informatica Developer

Responsibilities:

• This was a short engagement to enhance existing ETL processes. The source data for this project was SAP Business Warehouse. Guided by Source to Target specifications I was able to modify, test and implement all of the Informatica code.

Confidential (Bloomington, MN)

ETL Architect/ Informatica Developer

Responsibilities:

• Worked as the ETL Architect/ Developer/ Data Analyst in a team environment
• This project involved integrating call center data from many different systems. Confidential was unable to report across platforms due to the nature of the data and the tool sets available to them at the time. We were able to Design and Develop mappings to extract huge amounts of data and implement Change Data Capture on all tables. Many of these tables contained up to four hundred million rows, which required much Informatica and Database tuning.
• Extracted and transformed data from many sources (Teradata, SQL Server, Informix, Flat files and Oracle).
• Analyzed and tested target data and tied back to source systems to ensure guaranteed delivery of data.
• Worked as part of a team to develop Database Indexing Strategy

Confidential (Richfield, MN)

ETL Architect/ Informatica Developer

Responsibilities:

• Architected the various environments needed for ATK’s ETL processes to ensure guaranteed delivery of data. Environments include an operational data store, ETL staging area and Star Schemas
• Developed all ETL standards and best practices for ATK. Part of the effort at ATK was to mentor some entry level Informatica developers.
• The toughest obstacles at ATK were that they had acquired many companies. These companies used different GL applications. The purpose of the project was to extract data from the various applications, guided by common business rules and integrate them into one reporting solution. Source systems included many instances of Oracle Financials, Cincom, GEAC, Impresa and Deltek.
• Designed and developed all mappings to populate the Star Schemas
• Incorporated all dependencies into ATK’s enterprise scheduling tool (ESP).
• Build interfaces between the Cognos Planning Application and our Star Schemas. Actuals are transformed and moved to the Cognos Planning Application and Plan and Projections are moved from the Cognos Planning Publishing operation into the Star Schemas.

Confidential (Bloomington, MN)

Lead Informatica Developer

Responsibilities:

• Involved in the complete life cycle of all of these projects from gathering requirements to data analysis, ETL development, testing and promotion to production. All of these projects utilized SAP as a primary source and Oracle 9i as our target database.
• Designed and developed mappings for Shipments and Deliveries
• Designed and developed all mappings for Confidential Financials, CO-PA, Special Ledger and S905. This project involved huge data, up to fifty million records in one fact table. One of the challenges was that S905 records in SAP can be updated in the past. They needed to account for records being updated as long as two years in the past. Updating of the fact table for a delta load was taking ten to twelve hours to complete. By partitioning the fact table by fiscal period, the daily load was reduced to less than thirty minutes.
• Designed and developed mappings for Sales Order Detail Star schemas, Order Header, Order Item, Schedule Line and Partner Functions.
• Extracted data from the SAP change log on a daily basis. There were well over a hundred million records in the SAP change log. While trying to extract changes from the SAP delivered DataSource, temp space in SAP would fill up and the jobs would cancel. I developed and automated a method of pulling changes from each individual table based on Change Number. This method not only allowed the jobs to complete, but it completes in less than thirty minutes daily. The purpose was to keep track of pricing control attributes for Customers, Materials and Orders. Star schemas were loaded for each of these areas to determine what pricing control attribute changed, who changed it, the old and new value and the date and time it was changed.
• Lead developer for the Transportation Project. This project measured Carrier Performance over time. What time was a delivery scheduled, what time it left the warehouse, what time it arrived at the customer and what time it left the customer?
• Lead developer for Confidential ’s TCC ( Confidential Credit Corp) project. This project included Approvals and Audits.
• Worked extensively with SAP, pulling data, utilizing SAP’s BCI capabilities. He also pushed data to SAP from Oracle using Informatics’ RFC/ ABAP functionality.

Confidential (Plymouth, MN)

Informatica Developer

Responsibilities:

• Develop complex ETL specifications for NextGen Data Warehouse
• Develop Informatica Mappings from Business Specifications
• Developed processes to monitor load control processes and handle error re-cycle processes
• Transform data from many different sources. XML, DB2, Flat Files, Oracle, SQL Server and Informix

Confidential (Eden Prairie, MN)

Business Analyst/ Informatica Developer

Responsibilities:

• Analyze current ETL and convert ETL specifications from DataStage to Informatica
• Develop mappings from Informatica specification

Confidential (Eagan, MN)

Informatica Developer

Responsibilities:

• Develop and design Informatica processes for their Agrimine Data Warehouse. This involved extracting and transforming data from Flat file feeds from several of their distributors. The files from each distributor were in different formats. The solution to this problem was the use of mapping parameters to accommodate the varying formats
• Develop and design Informatica processes for their Financial Data Warehouse.
• Design dimension mappings using Type II logic, Load Control and error handling.

Confidential (Plymouth, MN)

Data Warehouse load and maintanence

Responsibilities:

• Design transformations to load data in a hosted environment for Confidential Corporation.
• Designed mappings using Data Transformation Services to format and load Web Data and Standardized data.
• Published data using Business Objects Web Intelligence for quarterly reporting.

Confidential (Minneapolis, MN)

Lead Informatica Developer

Responsibilities:

• Transformed PL/ SQL code into Informatica mappings for their Data Warehouse.
• These efforts were performed during a critical time. I designed, implemented and tested four dimensions which met their deadline.
• Mentored employees in Informatica to assure that they had the knowledge to further develop and maintain their Data Warehouse.

Confidential (Bloomington, MN)

Data Warehouse ETL Specialist

Responsibilities:

• Assisted in developing best practices and standards for creating mappings using DataStage.
• Developed several mappings to populate many libraries in their Data Warehouse.
• Assisted in designing a strategy for implementing Ascential DataStage
• Developed DataStage jobs for Health Partner Dictionaries

Confidential

ETL and File Transfer Specialist

Responsibilities:

• Designed and developed processes to collect data from remote stores using Xcellenet.
• Transformed and loaded data into SQL Server for data storage and analysis using Data Transformation Services.

Confidential (Cincinnati, OH)

Lead Informatica Developer

Responsibilities:

• Gathered requirements from business users.
• Designed and developed several iterations of their Digital Cockpit project using Informatica. There were many different sources for this Warehouse sources included Oracle, SQL Server, XML, Flat files and irregular web based files.
• Develop mappings from Informatica specification

Confidential (Minneapolis, MN)

Informatica Developer

Responsibilities:

• Gathered requirements from Business Users.
• POS data was trickled using TIBCO to a staging area.
• Developed Informatica mappings to transform POS data from the staging area and move it into mainframe data formats.
• Developed Informatica mappings to transform mainframe data formats into relational formats for their Loss Prevention department.

Confidential (Minneapolis, MN)

MCSE/Network Specialist

Responsibilities:

• Designed, implemented and maintained Confidential internal network.
• Implemented Exchange Server, Web Servers and all internet access.
• Support and maintenance of all internal Servers and workstations.