2005 - 2016
BI / Datawarehousing Freelance Consultant
january 2017 - july 2018
Saint-Gobain Bâtiment Distribution France
(SGBDF/PointP)
Production architecture evolution et optimization of ODI
(covering v10 to v12)
Built a dynamic data flows cartography (consolidated out of ODI et
$U repos)
Standardized roll-out/go-live through ansible/sqlline/xldeploy and
agents monitoring (150 within 5 environments, 20K runs a day, 1600
scenarios in production) ; developed Centreon/Nagios probes.
Normalized incidents repository and corrective process follow-up.
Animated a knowledge base upon Confluence.
april 2014 - august 2016
La Banque Postale
Architecture of Talend Enterprise (TEDI) data integration
plateform
Defined data integration platform architecture upon Talend
Enterprise ETL (TEDI) along several applications migration from a
massively PL/SQL legacy code and Talend community edition (TOS
5.6/Tomcat).
Carried out upgrade from TIS 5.6 toward TEDI 6.1.
Formalized code integration and roll-out process upon SVN.
Designed relational and dimensional (SCD2 constellation) models of
several data stores (ODS, DWH and ROLAP cubes) for LBP regulatory
risk reporting covering both market and retail data.
Promoted ELT-style design for large volume transformations (TB
within Virtual Private partitioned DB based on reporting dates).
Animated a technical knowledge internal community upon Redmine.
february - july 2013
Carmignac Gestion, Change Management dept.
Technical lead of ETL migration from Informatica to SSIS over
data integration components (ODS, DWH, DMT)
Defined to_be architecture and migration roadmap.
Set up one-to-one, Sql-only, comparative testing model.
Drove implementation team (4 outsourced developers + PM – flat rate)
and managed LCM & roll-out streamlining between environments.
Refactored history re-processing features, Infa mapplet simulation,
xml generation.
september 2012 – january 2013
Carmignac Gestion,Reporting dept.
Designed and led implementation of Olympia DWH & DMT (Asset
Management KPI’s)
Modeled snowflake ROLAP dimensional matrix with strong dimensional
history reqs. (SCD6 = 1+2+3) and dimension hierarchies reusability
needs (cubes constellation and cross-drilling features).
Drove imlementation upon SqlServer Integration Services (SSIS 2012),
SqlServer 2012 (Denali); Toad4MSSS ; XML, PowerAMC 16, Visual
Studio, BI Developement Studio (BIDS) / SqlServer Data Tools (SSDT),
SqlServer Management Studio, Team Foundation Software.
january – july 2012
Carmignac Gestion, Change Management dept.
Architecture, design and development of Austerlitz ODS
Initial POC for robustness, traceability and leverage of repo
meta-data upon native functionalities of Informatica 9.0.1
Initiated and implemented an advanced interface with Ctrl-M.
september - december 2011
Carmignac Gestion, Reporting dept.
Audit and development of Vendôme Datawarehouse (SqlServer
2008R2)
re-architectured Informatica Services (v9.0.1) for availability.
Setup of an incident log and reporting process around DWH load.
march - june 2011
ReedMidem
Audited target data architecture in the context of a complete
reengineering of RM’s Information System (eBusiness,
SalesForce.com, PeopleSoft).
Modeled upon Embarcadero of the subsidiary business requirements and
analysed gap against ReedExhibitions group data model.
Recommended good practices about re-urbanization in the context of
the aimed Enterprise Service Bus (ESB), a MDM setup for CDI and the
future Datawarehouse.
2010 / 2013 / 2016
Technology watch / self
Prototyped a datamart upon ODI/Sunopsis v11 and v12
Installation du produit sur les plateformes Windows & Linux
Debian.
Installed product on Windows & Linux Debian.
Installed Oracle 11.2 dbms, created db, Master & Work
repositories and configured agent.
Designed Knowledge Modules (KM's), interfaces/mappings, packages and
load plans ; deployed scenarios ; benchmarked many common ETL
functionalities.
november 2009 - july 2010
Bourbon Automobile
Extended Manufacturing Process Management datamart at Bourbon
(auto parts manufacturer) to sales process and forecasting.
Re-engineered the environmental architecture ; integrated flows from
R&D ; designed new Olap cubes in respect to existing dimensional
bus ; design & developed ETL process flows and mappings.
april - october 2009
Antadir Assistance
Defined QA environments and promotional methodology of project
SàD at Antadir federation (medical support & logistics)
Normalized TNS model and actually deployed Oracle rdbms over seven
client sites.
Architectured federated view model for SàD operational reporting.
Prototyped a replication model based on Oracle Streams.
june 2008 - march 2009
ING Brussels
Audited Market Risk Management ODS on behalf of service support
dpt. at ING Bank.
Trained and coached a development team during the whole cycle to go
live of brand new Asset & Liabilities Management ODS.
Defined an advanced Oracle multi-layers partition scheme for fast
historical timetables consolidation
october 2007 - march 2008
Bourbon Automobile
Architecture, design and implementation of a dimensional
datamart
Designed and implemented a datamart upon procurement statistics of
an auto parts maker, covering accountancy and production sites of
eight european subsidiaries.
Trained and handed over to the company staff.
march - october 2007
Antadir Assistance
Design and implementation of inter-ERP synchronization
Designed and implemented data synchronization architecture upon
OWB10gR2 in the context of a migration project toward two
complementary ERP on behalf of Antadir Assistance medical support
& logistics.
march - may 2007
Gras Savoye
Data modeling and Change Data Capture (CDC) design
Counselled an insurance broker on dimensional modeling, incremental
extractions design, CDC (Change Data Capture) implementation and
optimization upon OWB10gR2 and Oracle Streams.
2007
Miscellaneous clients
Various expertise interventions, audit and training upon OWB
at Fortis Insurance, Cap Gemini, Sanofi-Aventis, departmental
administration of Bordeaux, Avolys training center of Rouen,
Logi-tech of Nantes, SIIM 94 in Ivry.
november 2006 - february 2007
T-Online/Club Internet
Re-engineered ODS / DWH / Datamart architecture over OWB 10gR1
contributed to implementation, optimization and migration to 10gR2.
june - october 2006
Miscellaneous clients
Produced various training sessions
on datawarehousing upon OWB 10gR2 within a regional administration
in Nantes ; Oriented architecture, data modeling and development
methodology of a departmental administration in Lilles with OWB 9i
nov. 2005 - may 2006
Crédit du Nord
Architecture and methodology OWB
Contributed to the definition of the datawarehouse architecture and
development good practices over OWB 10gR2 at CdN bank.
1993 - 2005
Experiences as a salaried employee
june 2004 - october 2005
Thalès IS Finance subcontracted to compte
Cpr-Online (now BforBank)
DataWareHousing Consultant – Stock Exchange / Trading On Line
Technical and functional migration (Oracle WareHouse Builder / OWB)
of the middle-office DataWareHouse following the adoption of a new
back-office provider.
Profiled data and elaborated data quality tests.
Re-engineered and modeled the warehouse and reporting tools
referring to users and CIO.
Planned migration, switch time, production impacts (evolutions,
deployments, job planning, automated objects push between quality
environments over OMB+, etc.) collaborating with Geneva (database
hosting) and NYC (DBAs) Managed a senior developer.
sept. 2002 - nov. 2003
IOS company (Informática, Organização e sistemas),
Brasília, Brésil
Support Manager of the Free Software Department
Organized system and network infrastructure, security and technical
support; migrated all internal services to Linux platform (DNS,
Samba, Ipchains, OpenLDAP, Postfix, Apache + MySQL/PostgreSQL,
etc.); Recruited new engineers and leaded several
prototypes implementations within the free software laboratory;
Participated to various open source / free software events.
july 1998 – july 2002
CRI company subcontracted to OCM/SNDI (government
IT), Abidjan, Côte d'Ivoire
Project Leader - Integrated System of Public Finance Management:
SIGFiP/Oracle (distributed execution of the entire national
ivorian budget)
Defined software architecture and quality process over 3 releases of
the product assisted stakeholders in specifying/validating
functional requirements for 3rd version; customized and exported 2nd
release to Benin Republic (operational since 2001);
Managed an up to 10-engineers team (designers, developers, DBA)
along the entire process of technical design, implementation,
testing, documentation and deployment; organized the users help desk
workflow;
Implemented a ROLAP hyper-cube Datamart accessed with Discoverer
3.0; Prototyped the migration to J2EE architecture (JSP, EJB) with
JDeveloper 9i + oc4j/OAS9i.
may 1997 - may 1998
Sopra company subcontracted to Crédit Lyonnais, La
Défense, Paris
Team Leader - DIRECT-INFO (Intraday financial extranet system)
Maintenance of the Cosmos Web Server access to the Oracle database
through Pro*C; Reengineered and re-architectured webapp over
Netscape enterprise Server 3.0 (Javascript LiveWire Server Pages);
managed the Web front end sub-project: Direct-Info (3 engineers).
may - october 1996
ISE company (Interactive Software Engineering),
Santa Barbara, Ca., USA
Developer - Eiffel language network libraries (OOP)
Designed and embedded in Eiffel libraries the C language TCP/IP and
UDP/IP sockets mechanisms (Unix & Win32); Designed and developed
advanced tools for asynchronous communication.
sept. 1993 - july 1995
INSEE (National Statistics) over the French Caribean, Pointe-à-Pitre, Guadeloupe
System/Network Engineer - Coordinated and administered
INSEE-DIRAG Sept. - July LAN's
Supervised media (cable) installation of the four LANs; Installed
servers (LAN Manager/OS2 and Win NT) and instructed regional
administrators; Deployed e-mail system and interconnected disparate
sites; Defined strategies for access, security and backup systems;
Designed and developed a push utility for remote
installation/configuration/upgrade.