SUMMARY

• me am a Senior Consultant (Seventeen Years) with a focus on teh 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 teh ETL Design and Development process.
• me am a team leader who has architected and developed Data Warehousing solutions from every aspect of teh SDLC (system development life cycle).Specific Expertise
• 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 Window Plaforms, AIX, HP UNIX, Linux

OLAP Tools: Business Objects, Cognos, Microsoft SSAS

ETL Tools: Informatica PowerCenter, DataStage and Microsoft SSIS, ODI

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

PROFESSIONAL EXPERIENCE

Confidential

ETL Architect/ Informatica/ ODI Developer

Responsibilities

• ETL Architect/ Informatica Developer/ ODI Developer. Teh lead developer working with several off - shore resources.
• Worked on several projects using Informatica as well as ODI
• Developed and architected several ETL processes from many different source systems
• Worked with Oracle’s OBIA systems and customized teh Indirect Spend, Finance and Supply Chain Modules in ODI.
• A member of teh approval process to migrate all code from Development to Test and Production.
• Modeled several dimensions and fact tables, including indexing for reporting purposes.

Confidential

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 dis proprietary RDMS.
• Data integrity was not enforced on teh source system. Many data cleansing activities needed to be included in teh 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 dis project from teh backend (Database) to teh front end presentation (Business Objects).

Confidential

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
• Teh goal is to take all time entry data and organize it into a Star Schema for Budget, Revenue and Cost reporting. me am responsible for designing source to target mappings and developing all mappings on dis project. dis project involved many complex mappings to complete. Teh source of all data is SAP’s Business Warehouse in a DB2 Database.
• dis project involves extracting SAP workflow information. A workflow in SAP is a process to create objects, in dis case Materials.

Confidential

ETL Architect/ Informatica Developer

Responsibilities

• Teh first project was called teh WFSmart Re-plumb project. Unity is one of their JDE applications for Order detail. Confidential ’ Lakes was upgrading dis JDE application, but needed to include all historical data from teh previous version for reporting. We loaded dis data and tan matched to their new version to meet their reporting needs.
• Teh second project me worked on was called CRM Integrations. me extracted Data from their reporting Data Warehouse and pushed dis Data to Oracle CRM OnDemand. Oracle CRM OnDemand is an application hosted by Oracle. Informatica has a new plugin which allows insert/ update and deletion of data through web services. Teh 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 teh new Informatica plugin we are currently integrating two instances of CRM OnDemand (BDS and Winfield) on a nightly basis in less TEMPthan thirty minutes.

Confidential

ETL Architect/ SSIS Developer

Responsibilities

• Teh objective of dis project was to clean and enhance existing code for their medical claims data mart. Teh previous developers were well over budget and did not complete teh 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

ETL Architect/ Informatica Developer

Responsibilities

• Worked specifically with mapping legacy data into Dukes data warehouse.
• Completed all of teh 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 me had put together.
• Validated, tested and migrated all Informatica mappings to production.

Confidential

ETL Architect/ Informatica Developer

Responsibilities

• dis was a short engagement to enhance existing ETL processes.
• Teh source data for dis project was SAP Business Warehouse. G
• uided by Source to Target specifications me was able to modify, test and implement all of teh Informatica code.

Confidential

ETL Architect/ Informatica Developer

Responsibilities

• Worked as teh ETL Architect/ Developer/ Data Analyst in a team environment
• dis project involved integrating call center data from many different systems. Confidential was unable to report across platforms due to teh nature of teh data and teh tool sets available to them at teh 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

ETL Architect/ Informatica Developer

Responsibilities:

• Architected teh 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 teh effort at ATK was to mentor some entry level Informatica developers.
• Teh toughest obstacles at ATK were that they had acquired many companies. These companies used different GL applications. Teh purpose of teh project was to extract data from teh 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 teh Star Schemas
• Incorporated all dependencies into ATK’s enterprise scheduling tool (ESP).
• Build interfaces between teh Cognos Planning Application and our Star Schemas. Actuals are transformed and moved to teh Cognos Planning Application and Plan and Projections are moved from teh Cognos Planning Publishing operation into teh Star Schemas.

Confidential

Lead Informatica Developer

Responsibilities

• Involved in teh 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. dis project involved huge data, up to fifty million records in one fact table. One of teh challenges was that S905 records in SAP can be updated in teh past. They needed to account for records being updated as long as two years in teh past. Updating of teh fact table for a delta load was taking ten to twelve hours to complete. By partitioning teh fact table by fiscal period, teh daily load was reduced to less TEMPthan thirty minutes.
• Designed and developed mappings for Sales Order Detail Star schemas, Order Header, Order Item, Schedule Line and Partner Functions.
• Extracted data from teh SAP change log on a daily basis. There were well over a hundred million records in teh SAP change log. While trying to extract changes from teh SAP delivered DataSource, temp space in SAP would fill up and teh jobs would cancel. me developed and automated a method of pulling changes from each individual table based on Change Number. dis method not only allowed teh jobs to complete, but it completes in less TEMPthan thirty minutes daily. Teh 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 wat pricing control attribute changed, who changed it, teh old and new value and teh date and time it was changed.
• Lead developer for teh Transportation Project. dis project measured Carrier Performance over time. Wat time was a delivery scheduled, wat time it left teh warehouse, wat time it arrived at teh customer and wat time it left teh customer?
• Lead developer for Confidential ’s TCC ( Confidential Credit Corp) project. dis 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

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

Business Analyst/ Informatica Developer

Responsibilities:

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

Confidential

Informatica Developer

Responsibilities

• Develop and design Informatica processes for their Agrimine Data Warehouse. dis involved extracting and transforming data from Flat file feeds from several of their distributors. Teh files from each distributor were in different formats. Teh solution to dis problem was teh use of mapping parameters to accommodate teh 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

Data Warehouse load and maintanence

Responsibilities

• Design transformations to load data in a hosted environment for Confidential .
• 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

Lead Informatica Developer

Responsibilities

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

Confidential

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

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 dis Warehouse sources included Oracle, SQL Server, XML, Flat files and irregular web based files.
• Develop mappings from Informatica specification

Confidential

Informatica Developer

Responsibilities

• Gathered requirements from Business Users.
• Developed Informatica mappings to transform POS relational data into mainframe data formats.
• Developed Informatica mappings to transform mainframe data formats into relational formats for their Loss Prevention department.

Confidential

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.