Business Intelligence Community Leader
sodexo
Total years of experience :17 years, 3 Months
Developing and maintaining Sodexo BI strategy
Establishing and executing the BI vision for the delivery of information and analytics platforms and solutions to the business’s key stakeholders, including, internal staff, partners and clients.
Managing the day to day tactical operation of the BI Resources (5 peoples) :
DWH Design within the BI Architect
Development and Maintenance of Framework Manager (Query Subject, DMR).
Development and Maintenance of Cubes (Transformer & Dynamic Cube)
Business training & knowledge management for BI tools & other material such as new reports, cube...
The link between the business units and the technology teams for operational matters
Collaborate with the Test team to define, plan and execute verification and validation tests for all BI projects.
Sodexo Motivation Solutions
Privately Held, Recreational Facilities and Services industry.
develop and maintain existing B.I. platforms ( Cognos, Oracle, Sql Server, ... ) within team which gives users support on these applications.
·Maintenance of current reporting environment in Cognos 7.4.4 for all Sodexo department (Finance, Sales, Marketing, Affiliate, ..)
·Development for new reports (Impromptu) and cube (Transformer) for the new product "E-Lunch Pass"
·Maintenance and development of reports in SQL (Oracle)
·Maintenance of current cubes and handle daily cube production
·Support to BI user
.Installation and Configuration of Cognos 10 BI (Stand alone)
.Analyse and Design of Datamart for each departement
.Development and Maintenance of Framework Manager
.Development and Maintenance of Cubes (Transformer)
.Development for Reports with Report Studio/Business Insights/Active Report (Relationnel, Dimensionnel Data)
Carlson Wagonlit Travel (CWT) is a global leader specializing in business travel management.
Carlson still works with two environments Cognos 7.3 and Cognos 8.
In this context, my first role is to provide them with support to supervise the cubes production and handle monthly production
issues.
My second role in this project is to optimize the cube production (more than 700 cubes monthly) and optimize the reports
execution and complex reports replaced by a native SQL using Report Studio.
ETO is a marketing agency, combining marketing and technology, ETO designs and implements relational platforms to their
clients.
The goal of the project is to develop a new marketing-oriented reporting environment for the Asian Market
(Korea, China, Taiwan...)
My role was to study the customer's needs, creation of the framework Manager multi data source (Sybase IQ, SQL Server 2005),
creation of reports: 50 reports per country using Report Studio, creation of reports based on the standard audit framework
Manager model, customization & security of Cognos connection,
Optimizing existing Cognos reports for the European market by modifying the existent framework Manager model,
creation of a new data-mart, change of reporting layout, optimization of the prompt pages
Carlson Wagonlit Travel (CWT) is a global leader specializing in business travel management.
The goal of this project is to develop a reporting environment for the Travel and Transaction department.
In this context, I analyse the users needs, write the technical and functional specifications, development of optimized reports in Report Studio, maintenance and administration of the portal Cognos 8.4, maintenance and adaptation of dimensional models in Framework Manager
Mecar supplies high caliber ammunition and grenades to defense establishments (including NATO) throughout the world.
ETL development and reporting for the financial department
I had to analyse the needs for the ETL solution.
- Create Integration Services package (SSIS) for data transfer from SAP to SQL Server 2008 feeding the Data Warehouse
consulting, technical and operational recommendations. Support for the IT department of the company.
- Development of multidimensional models in Framework Manager and Transformer (Cognos 8)
- Development of financial reports under Report Studio and Analysis Studio(Cognos 8)
Tokheim, a specialist in equipment for fuel distribution, wanted to establish a reporting tool for monitoring interventions in their clients.
In this project, my responsibility was to create a data mart to response to their needs(SSIS, stored procedure), create reports under MS Reporting Services, create and secure a cube Analysis Services
CWT world leader in travel management business is facing many changes in reservations of its customers, particularly at the airline side.
In an international environment, the project involved the implementation of a solution for recording these changes in order to charge these changes to different customers.
The goal of this project is to load data from GDS (Global Distribution System) into a temporary database and then into a Data Warehouse by using SSIS and stored procedure, create cubes (Analysis Services), production of reports (Reporting Services), creation of an application log, installation, documentation, quality assurance
Xplorium is an international VOIP carrier committed to provide new telecommunication solutions by supplying stat-of-the art services to its clients.
The project involved the Creation of new datamart and optimization of Cubes in Cognos BI solution
IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.1)
IBM COGNOS 10 BI AUTHOR
Certification Microsoft, designing a BI solution by using SQL Server 2005
Cognos Education: Comprehensive Technical Overview (8.3)