Specializing in Business Intelligence - BusinessObjects Certified
Paris - Clean Driving license B

Career summary

I am a BusinessIntelligence architect and technical expert with 20 years of experience. I have taken part in several large BusinessIntelligence system deployments in banking and insurance companies. In addition, I am proficient in modeling, data extraction, transformation, loading and reporting design.

Technical Skill Summary

Tools
 

Oracle, Sybase, Microsoft SQL Server, IBM DB2

Work experience

BNP Paribas Cardif - (Since Dec. 2013)

Role : Business Intelligence & SAP BusinessObjects Expert
Context : In the "Architecture, SI versioning and engineering development" department (60 peoples) and in the "Support, tools and technology" team (12 peoples), expertise around SAP BusinessObjects solutions.
 

• Technological watch around Business Intelligence and Big Data

• Level 3 support, expertise and help to Business Intelligence projects

• Managed development's norms and standards, updated SAP BusinessObjects wiki and documents.

• BusinessObjects administration : Managed users, groups and rights, set up access.

• SAP BusinessObjects process equipment and industrialization (upgrade, delivery and licensing management)

Technical environment : Oracle, BusinessObjects 5.1.9, SAP BusinessObjects XI 3.1, Crystal Reports 2008, AIX, IBM Websphere, Informatica 9.1
Functional environment : people insurance

Softeam - (Jun to Nov. 2013 - 6 months)

  Role : Redactor

• Authored a book dedicated to SAP BusinessObjects BI 4.1 administration. This book is edited since March 2014 at ENI Editions.

  Technical Environment : SQL Server 2008, SAP BusinessObjects BI 4.1 SP1, Windows 2008

Société Générale Corporate & Investment Bank - (Oct. 2012 to May 2013 - 8 months)

• Managed the upgrade of 30 universe and 200 reports used in leasing activities from BusinessObjects XIR2 to SAP BusinessObjects BI 4.0 SP4.
• Set up security for LDAP authentication and rights management.
• Designed and edited reports linked to the Cassiopae application.

Crédit Agricole Corporate & Investment Bank - (Feb. 2012 to Sept. 2012 - 7 months)

• Using SAP BusinessObjects Data Services XI, developed and maintained jobs, workflows, dataflows and functions.
• Wrote SQL scripts to generate database structures (tables, views, constraints, indexes).
• Designed FMD universe files.
• Designed scheduled tasks and advanced dynamic publications using SAP BusinessObjects Enterprise XI3 SP1.
• Designed two Proofs of Concept for SAP BusinessObjects Enterprise XI3 SP5 and BusinessObjects Enterprise MetaData Management XI products.
   

Axa Investment Managers - (Feb. 2010 to Oct. 2011 - 20 months)

Context : In the AXA-IL Trading & Securities Financing (TSF) department dedicated to management operations financing
 

• Developed and maintained BusinessObjects universe files and reports dedicated to the trading and securities finance department.
• Designed scheduled tasks and advanced dynamic publications for external counterparty margin calls.
• Managed the redesign of 400 former Desktop Intelligence reports to a new Web Intelligence format with an English partner.
• Designed a Proof of Concept of the new SAP BusinessObjects BI 4.0 platform.
   

HSBC France - (March 2009 to Dec. 2009 - 10 months)

Role : SAP BusinessObjects Administrator (Administration and expertise around HSBC France BusinessObjects 6.5 (1500 users) and SAP BusinessObjects XI 3.0 (1000+ users) shared platforms.)

Context : In the HTS (HSBC Technologies Services) Business Intelligence department.
 

• Delivered UAT, OAT and PRD projects (universe files, reports) from the former v6 platform. Initial setup of environment and security.
• Redesigned security management (use of access level, setting up of technical and functional profiles, root folders rights improvement).
• Provided advanced support and help for users. Solved BusinessObjects platform incidents and issues based on official support and other forums.
• Used SDK to design CMS inventory reports (users, reports, universe file lists).
   

Axa Investment Managers - (Oct. 2005 - Dec. 2008 - 3 years+ )

Context : In the Data & Messaging department

• Set up the entire hardware and software infrastructure for the new BusinessObjects XI3.1 platform.
• Implemented an architecture file with the help of the official SAP BusinessObjects consulting department.
• Wrote the set-up procedure for Web Intelligence servers and full-client tools on Citrix servers.
• Studied and set up the single-sign-on mechanism (SSO).
• Set up 4 environments (Windows 2003, Web Logic 10).
• Designed scripts for platform administrative tasks. Wrote the corresponding orders for the command center.
• Set up access, folders and user-group security in all environments.
• Studied and set up the fail-over switch scenario (disaster recovery constraints) and performed annual AXA-IM BCP (Backup Continuity Plan) tests.

 Context : In the Dev & Tools department 

• BusinessObjects 6.5 Administration: Managed users, groups and rights, set up access, wrote reports and delivered to UAT and Production.
• Provided advanced support and help for about 550 users.
• Set up a Proof Of Concept (POC) for Crystal Xcelsius 2008 software.

Context : In the Data & Messaging department

• Studied and was involved in the 4.1.7 to 6.5.2 BusinessObjects upgrade.
• Inventoried universe files and reports to be migrated (80 and 700, respectively).
• Studied upgrade workflows for universe files and reports. Used SDK to automate upgrade tasks.
• Performed the technical upgrade of universe files and reports, non-regression tests.
• Installed Web Intelligence and scheduler servers (Unix Sun Solaris and Windows 2003 environments)
• Designed Unix KSH scripts for platform monitoring.
• Designed VBA applications using BusinessObjects SDK for on-demand refresh and email delivery of BusinessObjects reports using Broadcast Agent and Control-M.
   

Crédit du Nord - June to Sept. 2005 - 4 months)

Context : In the Business Intelligence department

• Studied the BusinessObjects upgrade from 5.1.3 to 5.1.9 and impacts analysis and developed the upgrade scenario.
• Set up and validated Web Intelligence 2.7.5 platforms on Windows and Unix servers.
• Studied OLAP cube access using the dedicated BusinessObjects Universe Builder module.
   

Sungard Finance - (May to June 2005 - 1 month)

Context: Inside the NTIC department

• As part of the Global Portfolio 3 software performance optimization program, designed an Oracle data warehouse for logs.
• Wrote requirements, designed and ran database creation scripts.
• Wrote loading scripts using Python / Eclipse.
• Filled a table using batches and previous Python scripts (more than 10 million lines)
   

Volkswagen - Gedas - (Nov. 2004 to March 2005 - 5 months)

Context: In the Gedas France Business Intelligence department (Volkswagen information systems management)

• Designed and created datamarts
• Created loading process using Genio 5 ETL
• Designed and edited Brio Query reports
   

Leasecom - (Aug. to Oct. 2004 - 3 months)

Context : Inside the IT department, designed reporting and data warehouse (sales data perimeter)

• Set up and deployed BusinessObjects client tools and a new repository on Microsoft SQL Server.
• Designed a universe file and a set of 12 reports.
   

Caisse des Dépôts et Consignations - (April 2003 to July 2004 - 15 months)

Context: In the Business Intelligence department of the "Architecture, Development and Support" department

• Upgraded several BusinessObjects applications (15 universe files and 50 reports) from release 4 to release 5.
• Studied Web Intelligence 2.7.3 and Broadcast Agent 5.1.7 setup on Windows NT and Unix.
• Provided BusinessObjects technical support and help for about 300 users.
• Managed BusinessObjects repositories and environments.
• Studied the release 4 to release 6 BusinessObjects upgrade for the Bordeaux business unit
   

CNP Assurances - (March 2002 to Feb. 2003 - 1 year)

Context : Inside the IT approval department:

• Set up integration platforms, installed and approved procedures for Set Analyser, Auditor, Broadcast Agent and Web Intelligence products.
• Participated in the go-live for a new Web Intelligence 2.7 and Broadcast Agent 5.1 platform in a Sun Solaris / Web Logic 6.1 environment as part of an HR-Access human resources portal setup.
• Audited BusinessObjects repositories and deployments.

Context : In the accounting and financial department:

• Performed a data warehouse daily coherence follow-up. Designed and edited BusinessObjects universe files and reports, and provided help and support for about 150 users.

Ondeo / Suez / Lyonnaise des eaux - (Feb. 2001 to Feb. 2002 - 1 year )

Context : In the data warehouse development team (accounting and financial data fed by Oracle Application) and in collaboration with the ERP implementation team

• Designed and loaded new data warehouse tables using Informatica ETL, and created and edited universe files and reports.
   

French Navy - (Nov. 1999 to Sept. 2000 - 10 months)

• In a research center, studied a reporting system using BusinessObjects 5.0

Foreign languages

• Leisure : Reading, jogging, swimming, and rock and roll dancing.
• Artistic activities : Creative writing (4 books published in 2009, 2010, 2013 and 2014), webmaster of several websites, 2D & 3D computing graphics.
• Other activities : Member and volunteer in the French charity organization, La Mie de Pain. Also volunteer to socially engage the homeless.