CV du
consultant

BDD

DataWareHouse ORACLE BIG DATA DB2 RMAN SQL SERVER SYBASE

Connaissances fonctionnelles

OBIee Assurance BROKER CAISSE CRM DISTRIBUTION Finance Marketing PORTAL RETAIL SIEBEL SIG TELECOM Tuning WEB

Langages

INFORMATICA SQL BUSINESS OBJECT C Excel EXCHANGE OPTIM PL/SQL SHELL

Méthodes

MDM MIGRATION

Réseaux et Middleware

WINDOWS SERVER

Systèmes

AIX APACHE IIS SOLARIS UNIX UNIX AIX WINDOWS WINDOWS 2000 WINDOWS NT

. 2004 - Bac + 5 - Audit des Systemes d'Information
. 1998 - Bac + 4 - M.I.A.G.E
. 1991 - Bac + 3 - Bachekor of Business Adminsitration ( B.B.A)

. Île-de-France
. Royaume-Uni

=============================================================================

KEY POINTS

=============================================================================

[#1] - 17 BIAPPS LIVE Projects.



[#2] - 15 years of software consulting acquired working for leader software vendors:



#2.1 Oracle

#2.2 Siebel

#2.3 Business Objects



[#3] - 13 years of Datawarehouse and Business Intelligence Expertise



[#4] - 9 years as OBIEE/OBIApps/Informatica Technologies acquired at Siebel and Oracle



[#5] - BIAPPS Key Roles: Solution Architect, Technical Lead, Developer for blue ship customers.



[#6] - Cross-industry knowledge



[#7] - 39 months of work experience abroad in main Western European countries, Czech Republic, Emirates, South-Africa and Senegal. Willingness to work in Europe and US.



[#8] - Daily exposure to International Virtual Team work and management as involved in offshore and near shore implementations



[#9] - Dual academic background in Finance and Computer science (Business School and Computer Science Master)



[#10] Awarded for BIAPPS license deals over $1.5M.



[#11] Oracle Endeca Information Discovery Evangelist (OEID).





===========================================================================

CAREER PROFILE

===========================================================================

I am Business Analytics Solution Architect and Lead Developer on Oracle Business Intelligence set of technologies.



My 13 years career in DW & BI has been built-up in the Consulting Departments of Business Objects, Siebel and Oracle.



I am a certified expert in Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Business Intelligence Application on top of CRM and ERP applications (BIAPPS), INFORMATICA and DAC.



My experience comprises from business requirements gathering to all the technical areas of Data Warehouse and Business Intelligence projects with hands-on in Data modeling, ETL scripting, Metadata and Application Development in the design, build, test and roll-out phases.



By extension, I have a decent knowledge of the main areas with which Business Intelligence is linked to: MDM, Database Tuning, Identity Management, Virtualization and Appliance Architectures.



I have worked on a wide range of projects either as a developer, technical lead and solution architect for large global companies.



I have also added an International dimension to my professional path by working abroad.



I have had the opportunity to work in different sectors like retail banking, insurance, telco, retail and industry. From a functional standpoint, I have an agile knowledge of ERP driven topics, processes and workflows in CRM, Finance, Procurement and Spend as Human Resources areas.



I am used to lead, train and mentor teams of 3 to 15 people, in international and virtual contexts, working in onshore, nearshore and offshore situations.





Since a year and half, I have started to develop my skills on Big Data and Data Discovery, focusing on Oracle Endeca Information Discovery (OEID) and the related awareness on R and no-sql databases.



============================================================================

PROFESSIONAL EXPERIENCE

============================================================================



June – now : Business Analytics Architect – BIAPPS – REDFOCUSED.



 February 2014 - now : Schneider Electric Global Services Department via WIPRO



o Designing and Prototyping a dedicated Global Services business intelligence solution with predictive analytics:

 Analysis of heterogeneous datasources including files, ERPs, SQL Server 2005 and 2012, MsAcess and Oracle 11g dumps.

 Design of a dedicated datamart on Oracle 11g database

Prototyping of the ETL load flows through Informatica Powercenter 9.5.1

 Development of a decicated OBIEE rpd and presentation catalog

 Embedding R with linear regression models for responsive buying approaches.



 June 2013 - December 2013 : TECHNIP GROUP - BIAPPS Architect



o Implementing BIAPPS Projects on top of e-Business Suite R12

o Design and development of Timecard Management extensions of the Project Analytics Module.



September 2004 – May 2013 : SIEBEL SYSTEMS / ORACLE (Colombes – France)





 August 2010 - May 2013 : Principal Sales Consultant – Business Analytics Practice



o MICHELIN HR ANALYTICS PRE-SALES ( PeopleSoft)

o TECHNIP HR ANALYTICS PRE-SALES ( Universal Adaptors)

o BIAPPS Champion for France

o BIAPPS Auditor

o BIAPPS Complex Selling

o Nominated for Oracle Excellence Awards Q3 FY12.

o Elected EMEA Pre-Sales for Q3 FY12 for Achievement on DNCS BIAPPS Deal.

o Main Deals:

o DNCS: BIAPPS Pre Sales Lead on a $1.5 Cross Lobs Deal

o TECHNIP: BIAPPS Pre Sales Lead on a $1.6 Cross Lobs Deal



o ENDECA Latitude/OEID Pre-Sales Evangelist



o EMEA and Oracle France Trainings followed in July 2012



o Oracle France BI and Big Data Events Speaker



o Customers’ presentations and product demos (Peugeot, Cap Gemini, Lagardère Interactive)



 August 2009 - August 2010 : SCHNEIDER-ELECTRIC (Paris - France)



o Technical lead – Implementation of the Phase 2 of Oracle Business Intelligence Application on top of PeopleSoft RH –. (Informatica ETL, OBIA).

o Oracle Database 10gR2, Sun Solaris.

o Industry.

o Oracle Open World Speaker for this successful project.



 June 2009 - August 2009 : SONATEL (Dakar - Senegal)



o Technical lead – Implementation of Oracle Business Intelligence Application on top of E-Business Suite 11.5.10.2 – Financial modules. (Informatica ETL, OBIA).

o Industry.





 March 2009 - May 2009 : BOUYGUES TELECOM (Vélizy - France)



o Technical designer– Implementation of Oracle Business Intelligence Application on top of Siebel CRM 8. – Traviata V2 . (Informatica ETL, OBIA).





 January 2009 - July 2009 : GRAS-SAVOYE (Paris - France)



o Technical lead – Implementation of Oracle Business Intelligence Enterprise Edition

o Oracle Database 10gR2, Windows.

o Near-shore based implementation with the Oracle Near-shored Center in Malaga

(Spain).

o Industry.





 June - September 2008 : SCHNEIDER-ELECTRIC (Paris - France)



o Technical lead – Implementation of Oracle Business Intelligence Application on top of PeopleSoft RH –. (Informatica ETL, OBIA).

o Oracle Database 10gR2, Sun Solaris.

o Industry.





 April 2008 - May 2008 : CREDIT SUISSE (London – UK / Zurich - Swizterland)



o Technical lead – Implementation of Oracle Business Intelligence Application on top of PeopleSoft RH –. (Informatica ETL, OBIA).

o Oracle Database 10gR2, AIX.

o Financial Sector



 February 2008 - July 2008 : PERNOD-RICARD ( Paris, France)



o Technical lead – Implementation of Oracle Business Intelligence Application on top of PeopleSoft 9 – (Informatica ETL, OBIA).

o Oracle Database 10gR2, Windows.

o Distribution



 January 2008 - June 2008 : ITV Channel (London - UK)



o Technical lead – Implementation of Oracle Business Intelligence Application on top of E-Business Suite 11.5.10.2 – Financial modules. (Informatica ETL, OBIA).

o Oracle Database 10gR2, AIX.

o Media Sector.







 Mid September 2007 - January 2008 : DALHOFF LARSEN HORNEMAN (Copenhagen - Denmark)



o Technical lead – Implementation of Oracle Business Intelligence Application on top of E-Business Suite 11.5.10.2 – Financial modules. (Informatica ETL, OBIA).

o Oracle Database 10gR2, Windows Server 2003 SP2 environment.

o Wholesaler.



 December 2007: GOVERNMENT OF ABU-DHABI – Department of Finance - (Abu-Dhabi – United Arab Emirates).



o Part-time with Dalhoff Larsen Horneman.

o Scoping and Implementation road map of Oracle Business Intelligence Application on top of E-Business Suite 11.5.10.2 – Financial modules.





 January 2007 - October 2007 : TELEFONICA (Prague- Czech Republic) – Alonso Project.



o Technical lead – Scoping, Gap Analysis, Design, Development , UAT and Roll-Out, on ETL, Metadata, Reports and Dashboards – Team Mentoring.

o Oracle Business Intelligence Application on top of Siebel CRM ( Informatica ETL, OBI –BIA).

o Oracle Database, Unix AIX System, SSL, Clustered environment.

o Telecommunication sector.



 October 2005 – December 2007 : FIRST NATIONAL BANK (Johannesburg- South-Africa)



o Technical lead – Scoping, Gap Analysis, Design, Development , UAT and Roll-Out on ETL, Metadata, Reports and Dashboards – Team Mentoring.

o Oracle Business Intelligence Application on top of Siebel CRM (Informatica ETL, OBI –BIA).

o DB2 and Sybase IQ Databases, Windows system.

o Corporate Banking sector



 April 2006 – August 2006 : STANDARD BANK (Johannesburg- South-Africa)



o Technical lead – Scoping, Gap Analysis, Design, Development, UAT and Roll-Out on ETL, Metadata, Reports and Dashboards – Partners’ team mentoring. Project run in parallell with First National Bank.

o Oracle Business Intelligence Application on top of Siebel CRM (Informatica ETL, OBI –BIA).

o DB2 and SQL Server Database, Windows System.

o Corporate Banking sector



 June 2005 – October 2005 : L’OREAL (Paris - France)



o Scoping, Gap Analysis, Design, Development and Roll-Out, UAT on ETL, Metadata, Reports and Dashboards on top of Siebel CRM.

o Virtual Team Context

o SQL Server Database, Windows System.

o Retail and Consumer Goods sector



 Mai 2005 : ITALGAZ (Turino, Italy)



o Expertise on Siebel Analytics and Informatica tuning

o Oracle Database and Unix environment.

o Energy sector.



 January 2005 – June 2005 : MOËT-HENNESSY (Paris - France)



o Technical lead – Scoping, Gap Analysis, Design, Development, UAT and Roll-Out on ETL, Metadata, Reports and Dashboards – Team Mentoring.

o Oracle Business Intelligence Application on top of Siebel CRM ( Informatica ETL, OBI –BIA).

o Oracle Database, Windows System.

o Retail and Consumer Goods sector



 January 2005 : SIMCORP (Copenhagen- Denmark)



o Expertise on Siebel Analytics Metadata, Reports and Dashboards optimization.

o Financial Securities sector.



 December 2004 : TOTAL (Paris - France)



o Expertise -

o Energy sector.





 December 2004 : MCI (Paris – France)



o Design and Build of Siebel Analytics Reports and Dashboards on top of Siebel CRM.

o Telecommunications sector





 November 2004 : ASTRA ZENECA (Oslo - Norway)



o Design and Build of Siebel Analytics Reports and Dashboards on top of Siebel CRM.

o Metadata implementation.

o Pharmaceutical sector.





March 2000 – Avril 2004: BUSINESS OBJECTS (Puteaux - Paris La Défense- France)



Project achieved as Project Manager :





 November 2002 - September 2003 Adycol project – ECUREUIL GESTION (Paris- France)



o Design, Build and Deployement of an internet portal dedicated to the analysis and the performance management for the sales follow-up of financial securities within the Caisses d’Epargne bank network.



o Two phases project : The first one, for both the functional and technical design over a three months period entirely leaded by the five Business Objects Team members; The second phase , over a seven months period, was dedicated to the build , testing and roll-out realized in partnership with Cap Gemini Ernst & Young , the Marketing and IT customer team.



o This project was the support of a communication plan within the Caisse d’Epargne banking group, and externaly with press articles published in the French edition of « Bank and Computer Science » magazine.



Functional skills : Finance and stock market, Sales network analysis, Project management.

Technical skills : Datamart modeling and data flows scripting, Business Objects Reporter, WebIntelligence and Broadcast Agent, Designer, Supervisor, Application foundation, Sales analytics, Set analyzer, Oracle, SQL, PL/SQL, Shell scripts, Unix Sun Solaris,Windows 2000, Apache, Internet Information Server (IIS).



September 2001 - August 2002 AIR FRANCE (Massy- France)



Management of the Business Objects projects within Air France

o Technical architecture

o Technical assistance



Functional skills : Project Management.

Technical skills : Datamart modeling, Business Objects Reporter, WebIntelligence

and Broadcast Agent scheduler and Publisher, Designer, Supervisor, Oracle, SQL, PL/SQL, Unix,

Windows NT.





 October 2001- March 2002 GENERALI FRANCE ASSURANCES (Paris- France )



o Implementation of an intranet application for the analysis and the performance management of the sales network for inner sales representatives and brokers as well as a profiling application for customers segmentation.



o Project leaded by Business Objects from the design to the build of the prototype.



o This project was the support of communication plan shared between Business Objects and the customer (Videos, Conference at the Paris La Defense Conference CNIT center, press articles, outlets)



Functional skills : Insurance and Finance, Sales network analysis, Project Management.

Technical skills : Datamart modeling, Business Objects Reporter, WebIntelligence and Broadcast Agent, Designer, Supervisor, Application foundation, Sales analytics, Set analyzer, Oracle, SQL, PL/SQL, Windows NT, Internet Information Server (IIS).





 October 2000 - January 2001 ABEILLE-VIE ASSURANCES (Paris- France)



o Management of the Business Objects projects within Abeille-Vie Assurances

o Drafting and implementation of the migration plans

o Management of the sustaining relationship and technical assistance



Functional skills : Insurance and Finance.

Technical skills : Datamart modeling, Business Objects Reporter, WebIntelligence and Broadcast Agent Designer, Supervisor, Oracle, SQL.



Projects related to operational and analytical reporting in ERP environment :



Modeling and set-up of the reporting universes and financial balance scorecard reports development for Oracle Applications ERP.



 June -October 2000 GTIE -Groupe VINCI (Suresnes- France)



 August 2000 PAGES JAUNES (Boulogne- France)



Projects related to Datamart / Datawarehouse Modeling and E-Business Intelligence :



 March 2004 : OMNIUM EDA-Groupe Total Elf Fina (Fontenay sous Bois - France)



For a Financial Performance management project and in preparation of a web portal dedicated to goal management :



o Datamart modeling

o Data flows specifications and design

o Data flows scripting with Data Integrator 6.1 ETL tool.



Technical skills : Windows 2000 Serveur, AS/400, SQL Server 2000, Data Integrator.



 February 2004 : MINISTERE DE L’AGRICULTURE ( Paris- France)



For a Financial Control project in preparation of a web portal dedicated to goal management :



o Technical architecture design

o Datamart modeling

o Data flows specifications and design



Technical skills : Windows 2000 Serveur, Oracle 8i.





 June - July 2001 : EUROPASSISTANCE (Gennevilliers - France)



Implemention of a performance management extranet portal for the insurance sinisters follow-up. Functional and technical design, data modeling , universe development.



 September - December 2000 : DEBITEL (Chaville - France)



Implemention of a performance management extranet portal for the analysis of distributors network sales activity. Functional and technical design, data modeling , universe development.





 May 2000 : FRANCE TELECOM Longue Distance (Noisy le Grand- France)



Technical architecture design in a Windows NT environment : WebIntelligence Set-up and optimization.





May 1998 -February 2000 : ORACLE ( Nanterre – France)



Consultant-Business Analyst Oracle Applications – Financial Modules.



 December 1999 - February 2000 : THOMSON VIDEOGLASS (France)



Functional design dedicated to the implementation of the Purchase Order, Acounts payables, and Inventory Management modules. Application of the Oracle AIM methodology.



 August 1999 - November 1999 : FRANCE TELECOM CABLES (France)



Functional migration plan design and execution, migration assistance, prototyping and test of the AP, AR,GL and AX modules. Application of the Oracle AIM methodology.



 July 1998 - June 1999 : FRANCE TELECOM SICOR (France)



Assistance to the U.A.T phase of the France Telecom BAC Project on Oracle Application General Ledger module.



March 1994 - September 1997 :



PRODIVIN (Bordeaux - France)



Company specialized in the wines and spirits brokerage to the export market .



Financial Controler



 Budgetary and logistics control

 Foreign exchange operations analysis and statistics

 Functional design of an inventory management and logistics flows optimization application





August 1991 - February 1994 :



SOBONECO (Bordeaux- France)



Company specialized in the wines and spirits brokerage to the export market .



Financial controler assistant



 Budgetary and logistics control



==========================================================================

ACADEMIC BACKGROUND

===========================================================================



 2004 Computer Science Audit. I.A.E –Paris1 - La Sorbonne University.

 1998 Master in Computer Science Applied to Management (M.I.A.G.E). Paris XII University.

 1991 Bachelor of Business Administration (B.B.A), Institut Franco - Américain de Management (I.F.A.M), Paris.

 1988 Baccalauréat B ( Level A equivalent ) , Economics option, Le Caousou, Toulouse .







===========================================================================

FOREIGN LANGUAGES

===========================================================================

 English : Fluent – Daily working language.