David - Architecte SIEBEL ANALYTICS
Ref : 090728L002-
52100 CHANCENAY
-
Architecte, Consultant technique (54 ans)
-
Freelance
PROFESSIONAL EXPERIENCE
September 2004 – now : SIEBEL SYSTEMS / ORACLE (Colombes - France)
August 2009 - now : 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.
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).
o Telco.
January 2009 - July 2009 : GRAS-SAVOYE (Paris - France)
o Technical lead – Implementation of Oracle Business Intelligence Enterprise Edition
o Oracle Database 10gR2, Windows.
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.
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.
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 2006 : 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.
o Telecommunications sector
November 2004 : ASTRA ZENECA (Oslo - Norway)
o Design and Build of Siebel Analytics Reports and Dashboards.
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)
o 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 .
PROFESSIONAL TRAININGS
2007
• Oracle training – E-Business Suite Financial Functional Foundation, Reading, U.K.
• Oracle training – E-Business Suite Financial Application overview, Reading, U.K.
• Oracle training – E-Business Suite Essentials for Implementers, Reading, U.K
• Oracle training – Oracle Business Intelligence Application for E-Business Suite, Reading, U.K.
2005 Siebel Analytics Master Certification.
2004
• Siebel Systems training – Siebel Analytics Data warehoiuse developper, Reston, U.S
• Siebel Systems training – Siebel Analytics Architect, Reston, U.S
• Siebel Systems training – Siebel Analytics Developper, Amsterdam, Netherlands.
• Siebel Systems training – Siebel CRM, Amsterdam, Netherlands.
• Training on the ETL software « Data Integrator », Business Objects, Paris
2003
• Project management and planning . PMI certification accredited training, Learning
Tree, Paris.
• Financial Securities Technical Analyst , «Market Traders Institute», U.S.
2001
• Business Objects Certification, Paris
• Training on the ETL software « PowerMart » and « PowerCenter », Informatica, Paris.
2000 Oracle Applications Business certification, Financial modules, Reading- U.K.
FOREIGN LANGUAGES
English : Fluent – Daily working language.