We provide IT Staff Augmentation Services!

Data Integration Consultant Resume

PROFESSIONAL SUMMARY:

  • ETL/BI Architect/Developer specializing in Data Warehousing and Enterprise Analytics, with over thirty years analytical, design, development and project management experience:
  • Experienced in operational, financial and technical/clinical environments.
  • Industry experience includes internet, finance, pharmaceuticals, entertainment, manufacturing, aerospace, government/law enforcement, gaming and health care.
  • Major strengths in enterprise analytics, data warehouse/business intelligence design and development, master data analysis and reconciliation, data/application integration and EDI, application and platform conversion, compliance analysis, data mining, data profiling, process analysis, application and database development.
  • Adept at both business and technical analysis, and cross - boundary communications.
  • Expert in the design and implementation of reusable, data driven, auto-cleansing processes.
  • Extensive experience in both 3rd normal form and dimensional data modeling, including aggregation strategy and slowly changing dimensions.

PROFESSIONAL EXPERIENCE:

Confidential

Data Integration Consultant

Responsibilities:

  • Designed and developed complex, parameter driven, asynchronous ETL system to ingest several patient demographic and medical data domains into centralized, conformed data store, from multiple source systems; developed feedback mechanism to provide ingestion results to source systems.

Environment: Sourced Oracle, proprietary XMLTargeted custom Oracle data store and JMS, using Informatica PowerCenter 9.6.1

Confidential

Data Integration Consultant

Responsibilities:

  • Developed and implemented several two-way scalable custom ETL processes between corporate data hub and subscribing applications, using complex transformation rules.
  • Developed and implemented parameter driven data capture scripts to facilitate data transfer between corporate data hub and subscribing applications.
  • Developed and implemented parameter driven administrative operations scripts to facilitate ETL metadata retention and management

Environment: Sourced XML, proprietary operational applications (Microsoft SQL Server based)Targeted custom data hub data model and proprietary operational applications (Microsoft SQL Server based), using Informatica PowerCenter 9.5.1 and Informatica PowerExchange 9.5.1(Change Data Capture)

Confidential

Analytics Application Architect

Responsibilities:

  • Developed and implemented packaged and customized ETL processes for several Oracle EBS application modules.
  • Developed and implemented several completely custom ETL processes for client specific HR analyses; developed new and extensively revised existing data model.
  • Developed and implemented several completely custom ETL processes for new contracts subject area; developed completely new data model.

Environment: Sourced Oracle E-Business Suite (Oracle RDBMS)Targeted custom data warehouse data model (denormalized) as well as extended Oracle Business Analytic Warehouse data model (Oracle RDBMS), using Informatica PowerCenter 9.1BI: Oracle OBIEE

Confidential

Analytics Application Architect

Responsibilities:

  • Implemented customized ETL processes for order management and customer retention; converted existing Oracle Warehouse Builder processes to Informatica PowerCenter.
  • Implemented customized ETL process for vendor audit and reconciliation; developed custom SQL, Informatica & Oracle Warehouse Builder processes; developed and revised data model.

Environment: Sourced Oracle E-Business Suite (Oracle RDBMS), vendor-sourced data (primarily csv)Targeted custom data warehouse data model (denormalized) (Oracle RDBMS), using Informatica PowerCenter 9.0.1 and Oracle Warehouse Builder 10G & 11G, custom SQLBI

Confidential

Analytics Implementation Consultant

Responsibilities:

  • Implemented packaged and custom ETL and Business Intelligence processes to establish financial data warehouse.

Environment: Sourced Oracle E-Business Suite (Oracle RDBMS),Targeted Oracle Business Analytics Warehouse (Oracle RDBMS), enhancing existing data entities, as well as implementing custom entities, using Informatica PowerCenter 8.6 and Informatica PowerCenter 9.0.1BI

Confidential

Data Integration Consultant

Responsibilities:

  • Re-engineered custom ETL processes reducing incremental load times over 99%.

Environment: Sourced Siebel CRM (Oracle RDBMS),Targeted Siebel Marketing Analytics Warehouse (Oracle RDBMS), enhancing existing data entities, as well as implementing custom entities, using Informatica PowerCenter 8.6BI: Oracle OBIEE

Confidential

Data Integration and Business Intelligence Consultant

Responsibilities:

  • Designed and developed data models, ETL processes and reporting systems in support of packaged and custom data warehousing and reporting implementation.
  • Designed and developed approximately 20 custom ETL processes enabling operational analysis of client’s multinational credit exposure, costing of past due receivables, and sales/use tax and value added tax exposures.
  • Performed extensive source system analysis and mining to identify required data-set and master data consolidation rules, based on transactional system data mapping (Oracle EBS).
  • Modeled and implemented 28 new database objects to support data gathering and reporting requirements.
  • Designed and developed 12 complex custom Business Intelligence reports, providing conforming cross-fact reporting, combining up to four facts per report, including custom data selection and currency conversion.
  • Liaised with client’s Credit Analysis, Tax Management and IT development teams, as well as third party consultants to ensure design conformity, master data integrity and performance standards.

Environment: Sourced Oracle Enterprise Application Suite (Oracle RDBMS), Oracle Business Analytics Warehouse (Oracle RDBMS),Targeted Oracle Business Analytics Warehouse (Oracle RDBMS), enhancing existing data entities, as well as implementing custom entities, using Informatica PowerCenter 8.6BI: Oracle OBIEE

Confidential

Data Integration Consultant

Responsibilities:

  • Designed and developed data models and ETL processes in support of packaged and custom data warehousing and reporting implementation.
  • Designed and developed more than 40 customized ETL processes providing operational and analytical empowerment of client’s multinational recruitment processes
  • Liaised with Human Resources Recruitment Management to develop requirements and quality assurance levels
  • Designed and developed more than 15 customized ETL processes providing operational and analytical empowerment of client’s Accounts Payable reporting
  • Provided analysis, design, troubleshooting and additional developments support to other financial subject areas
  • Liaised with Business Intelligence development team to ensure design conformity and performance standards

Environment: Sourced Oracle Enterprise Application Suite (Oracle RDBMS), flat files,Targeted Oracle Business Analytics Warehouse (Oracle RDBMS), enhancing existing data entities, as well as implementing custom entities, using Informatica PowerCenter 8.6 and Unix (Redhat Linux) scriptsBI: Oracle OBIEE

Confidential

Senior Manager, Data Warehouse

Responsibilities:

  • Managed multiple teams of 2 to 10, including staff and independent contractors
  • Directed development of several new subject areas, growing the Data Warehouse to more than 12 terabytes
  • Teamed with Business Analysis group to develop requirements and quality assurance levels
  • Directed specifications development, data architecting (normalized/transactional and star schema), coding, and final implementation
  • Defined ETL development standards and methods

Environment: Sourced Weblogs (Apache), Oracle, internal & external flat files), Excel worksheets, Targeted Oracle, using Informatica PowerCenter 7.x-8.x and Unix (Redhat Linux & Solaris) scriptsBI: Microstrategy

Confidential

Senior ETL Engineer

Responsibilities:

  • Liaised with BI and marketing analysis teams to architect analytic reporting databases.
  • Architected application interfaces to connect disparate systems and technologies.
  • Developed and implemented daily cycle ETL, with ongoing operational support.

Environment: Sourced Weblogs (Apache), Oracle, internal & external flat files, Excel worksheets,Targeted Oracle and SQL Server, using Informatica PowerCenter 7.xBI: Microstrategy

Confidential

Senior Consultant

Responsibilities:

  • Managed teams of 3 to 20, including client staff, independent contractors and third party vendors
  • Developed product lifecycle and implementation lifecycle plans
  • Developed master data reconciliation and consolidation strategies
  • Developed project plans, contingency plans and budgets
  • Directed all aspects of requirements gathering, specifications development, data modeling (normalized/transactional and star schema), coding, quality assurance and final implementation
  • Delivered analytical systems/data warehouses, integration systems, data models and architectural standards.
  • Architected databases up to 2.5 Terabytes in size.
  • Sourced Oracle, internal & external flat files, and Excel worksheets, targeted Teradata to build DWH and migrate proprietary RDBMS application datasets to Teradata using Informatica PowerCenter 7.x for major entertainment companies (multiple projects at two clients)
  • Sourced and targeted Oracle, using Informatica PowerCenter 7.x and Unix (Solaris) scripts to migrate and transform subsidiary financial detail to parent for major toy manufacturer
  • Sourced and targeted DB2 UDB, using Informatica PowerCenter 7.x and Unix (AIX) scripts, to build financial DWH for major computer storage subsystem manufacture
  • Sourced Mainframe DB2, VSAM, offloaded Cobol and EDI files (HIPPA claims and payment) data, targeted DB2 UDB using Informatica PowerCenter 7.x and PowerExchange 5.x and Unix (AIX) scripts to transform application data and build DWH for major life/health insurer
  • Sourced SQL Server, targeted Oracle, converted and upgraded Informatica metadata repositories using Informatica PowerCenter 4.x-7.x, Windows scripts and Unix (Solaris) scripts to convert and update student records systems and DWH for state university system
  • Sourced SQL Server, targeted SQL Server to build financial DWH using Informatica PowerCenter 7.x, consolidating performance and patient data from heterogeneous set of hospitals and clinics, for large regional healthcare provider
  • Sourced Oracle, targeted Oracle to build clinical DWH using Informatica PowerCenter 7.x, consolidating trial metrics and participant attribute data for international pharmaceuticals maker
Confidential

Data Warehouse Analyst

Responsibilities:

  • Provided analysis, design and database development services to home entertainment division.
  • Developed over 20 ETL interfaces between operational systems and financial data warehouse.
  • Developed divisional sales performance analysis datamart
  • Developed exception analysis process.
  • Developed intranet-based user/developer support materials.
  • Developed Data Warehouse Development Methodology

Environment: Sourced and targeted DB2 UDB using Informatica PowerCenter 4.xand Unix (AIX) scripts to build

Confidential

Systems Consultant

Responsibilities:

  • Analyzed over 30 business processes identifying critical data relationships, redundancies and integrity risks.
  • Designed database architecture to support worldwide scheduling and reporting application, providing integration with enterprise applications.
  • Developed over 100 PL/SQL programs to transform and load historical and reference data from ten legacy and enterprise systems.
  • Developed several automated ETL interfaces between critical scheduling/decision support application and enterprise systems.

Environment: Sourced and targeted Oracle using Informatica PowerCenter 4.x and UNIX (Solaris)

Confidential

Systems Consultant

Responsibilities:

  • Coordinated rollouts of systems products for workgroups of up to 200
  • Developed networked, remotely administered training facility
  • Implemented intranet-based research management application
  • Designed, developed and supported over 160 database and workflow applications
  • Developed automated tax data collection application
  • Developed interfaces between several tax preparation applications
  • Developed two IRS audit tracking & modeling systems
  • Developed detailed procedural instructions for over 120 applications and workflow processes
  • Coordinated logistical, technical and budget support for 25 departmental projects and 20 facility reorganizations.
Environment: Desktop Xbase 4GL on Microsoft desktop

Hire Now