For UNIFY project, adaptation of HUB (Warehouse) application which became
MiNi HUB application and executed in incremental mode, checking the missing data for several target applications and including them.
Analysis and design of one of target application QEP (Quality Enhancement Plan) which Uses HUB as source.
Support proof of concept with IDQ on deduplication person, address and institution entity.
Informatica Powercenter 9, IDQ 9, Oracle 11G, Unix
Support the implementation of IDQ and Powercenter 9.5.1 Hotfix1, best practices, configuration management, code review, server configuration between Informatica and LDAP (AD), with the implementation of SAP Connectors (IDOC), Siebel, WebService, TIBCO, generating quality rules given as mapplet from IDQ to Powercenter.
Manage developments subcontractor.
Support the applications package reversibility from EDF (French Electricity
Company). Development of the new version on Powercenter.
Informatica Powercenter 9, Oracle 11G, Unix
Support solutions on DWH project "sensitive" about the loan insurance, work on the existing to optimize the data loading model of Teradata FS-LDM with EBCDIC files. Redefinition of the data flow of new model for DWH management SCD (Slowly Changing Dimension) type 2 and ensure better maintenance and evolution.
Informatica Powercenter 8, Power Exchange, Teradata, Unix, Shell.
Completion of the study needs, rejects and recyclings of exchange flows internally and externally. Design of the exchange flows from Wynsure (ERP) to accounting, data warehousing, etc ..., through the ICE (Exchange platform based on TIBCO). Implementation of rejects and recycling solutions based on the existing.
Informatica Powercenter Expert
Design and development Powercenter to load CALLIDUS, BI tool oriented Sales Performance Management. Integrating the team to stay on schedule and play a team leader on developments.
On site and home working.
Informatica Powercenter 7, Oracle 10g, Unix.
Consulting and assistance in setting up Quality Center (monitoring tools for test management). Specific tools development to manage repositories.
Assist testers
Quality Center, VB Script
Assistance in writing the functional.
Development of a Business Objects universe for a data mart on the Europcar fleet.
Definition of contexts in the universe.
Managing the most complex calculations through ETL, including consideration of retroactivity (rentals made but not yet recorded) over 3 months.
Establishment of development standards. Consideration and adjustment of the functional set. Tracking mappings and scheduling thereof.
Loading the data warehouse.
Load optimization. (mappings / sessions)
Organizing Folders Powercenter Informatica.
Developers Managment.
Support business.
Analyse and design on several application between PC and AS400.
NT 3.51, Win95, Windev 4.1, Easycom, Access, lotus notes...
Mainframe
desktop administrator 2 years
JCL administrator / Operator 7 years