PROFILE:

• Consultant with 24 years experience in software development with an emphasis on data integration strategies in the business intelligence space.
• 15 years focused on the full suite of functionality in Informatica’s PowerCenter to deliver mission critical data integration solutions.
• Thorough understanding of data warehousing concepts and strategies (relational and dimensional)
• Excellent communication and diagnostic skills, earning a solid reputation for productivity, complex problem resolution and professionalism

SOFTWARE/TECHNOLOGIES:

Informatica PowerCenter 5.1 - 10.1

Informatica PowerExchange

SQLServer Integration Services

Microsoft Azure Cloud

Dell Boomi (completed Boomi Developer certification in October 2019)

SAP (limited to PowerCenter specific functions)

SQLServer 2003, 2008, 2012

Oracle (PL/SQL)

Sybase

Unix (Solaris, HP, AIX)

C++

PowerBuilder

Java

PROFESSIONAL EXPERIENCE:

Sr Integration Developer

Confidential, Tulsa, OK

Responsibilities:

• Developed ETL solutions using SSIS to populate corporate Data Hub consisting of relational and dimensional models
• Designed framework to in corporate common functions for error detection/logging
• Built Dell Boomi integrations to retrieve employee data from Kronos via API calls

Informatica Consultant

Confidential, Bartlesville, OK

Responsibilities:

• Leading independent oil and natural gas exploration and production company
• Utilized Informatica to integrate data from Salesforce (Account/Contact/Agreement) into various reporting tools (Oracle, SQLServer, SAP).
• Created Informatica mappings to pull data from SAP (R/3) and HANA to support decision systems for Marketing and Transportation business units.
• Supported Informatica jobs that parse large files from 3rd party credit card processors, perform extensive validations, route errors to appropriate resolution channels, and load internal credit card settlement system (Oracle).
• Adapted existing Informatica workflows to conform to new cloud sources/targets (AWS, Azure)
• Utilized Informatica to consume various 3rd party vendor data feeds (web service, xml, REST)

Informatica Consultant

Confidential, Oklahoma City, OK

Responsibilities:

• Leading independent oil and natural gas exploration and production company
• Member of conversion team responsible for migration of legacy data into SAP/BW
• Developed ETL solutions sourcing from SAP/BW (ABAP) into Operational Data Store, Dimensional Data Warehouse
• Optimized high volume integration jobs to utilize Informatica partitioning and Oracle multi-threaded reads
• Developed design patterns for BIDW team, incorporating reusable mapplets for error handling and event creation.
• Provided technical consultation to onshore/offshore Informatica developers

Informatica Consultant

Confidential, Tulsa, OK

Responsibilities:

• Administer repositories, train/assist new developers, provide expertise on data migration and integration projects.
• Developed dimensional data mart correlating manufacturing operations and material usage. Data rendered to user community via SSAS/SSRS.
• Built ETL solution to maintain enterprise data warehouse which supports inventory reduction and supply chain management. Presentation layer developed in .NET.
• Provided technical consultation on a regular basis to in-house Informatica staff members

Data Integration Consultant

Confidential, Bartlesville, OK

Responsibilities:

• As member of the Global Applications Integrations team, selected to strategic project team tasked with converting a legacy IT integration tool (eGate) to Informatica PowerCenter. As part of this team, hundreds of legacy integration jobs were documented, developed in PowerCenter, tested, and migrated to production. Emphasis given to code reusability and common error handling components. Additional tasks included comprehensive data cleansing efforts and elimination of duplicate data stores.
• Consolidated daily volume metrics in a dimensional data warehouse for Ops Reporting in the Lower 48 business unit using PowerCenter. This high availability low latency repository allows production accounting to accurately report and forecast well production and the financial impact of down time.
• Redesigned SAP BW data integration interfaces to use RFC application connectors in PowerCenter.
• Designed and developed PowerCenter workflows to synchronize HR data with 3rd party vendor (Taleo) using web services.

Senior Software Developer

Confidential

Responsibilities:

• Developed ETL to support Enterprise Data Warehouse sourced from various custom and vendor systems (Siebel via PowerExchange). This EDW is the corporate decision support system for all business units as well as the master data repository for all IT systems.
• Responsible for the administration of all PowerCenter servers (development, test, and production), including code migration, server support, and first line troubleshooting for all development teams.
• Upgraded all PowerCenter environments from 5.1 to 7.1 and mentored development teams in new functionality and best practices after system migration.
• After merger of Wiltel and Level 3, assigned to integration team responsible for synchronizing customer and network usage data between dimensional data marts of legacy Level 3 and enterprise data warehouse of legacy Wiltel.
• Assisted in requirements gathering, data model design, integration testing and implementation.

Application Developer

Confidential

Responsibilities:

• Responsible for high volume middle tier application (C++) that parses, validates and loads customer switched data product information in CRM database (Sybase).
• Enhanced and maintained Powerbuilder application utilized by 1800 customer support reps. to remediate service and billing disputes.
• Served as member of IT transition team during merger between WorldCom and MCI.