Datawarehousing / BI Freelance Consultant
Data & ETL Architecture
Datawarehouse / Datamarts Design & Modeling
English, French and Portuguese speaker/writer
30 rue d’Issy
92100 Boulogne-Billancourt
.docx version
.pdf version
French HTML Versionin French
email : xavier@beaume.org
mobile : +33 6 60 06 60 26
url : http://www.beaume.org/beaumex/cv-fr.html




PROFESSIONAL EXPERIENCE (reversed chronology)

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

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.
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.


Nov. 96
Master of Science in C.S.: Parallel Processing, Networks and Distributed Systems
École Nationale Supérieure des Télécommunications de Bretagne (ENST Br.)
July 93
Bachelor of Science in Computer Science (graduated with honors)
San Jose State University (SJSU), San Jose, California, USA
Equivalence granted by the University of Paris XI, Orsay, France
July 92
License in Computer Science (graduated with honors)
University of Paris XI, Orsay
July 91
DEUG A (Mathematics and Physics, graduated with honors)
University of Paris XI, Orsay
July 88
Baccaulauréat: C serie (Mathematics and Physics)
Lycée Ste Barbe, Paris