Responsible of reporting platform for all sodexo departments, collecting/documenting business requirements.
Maintenance of current reporting environment in Cognos 7.4.4, development for new reports and cube 7.
Maintenance and development of reports in SQL (Oracle),
Maintenance of current cubes and handles daily cube production,
Support to BI user
Migration Cognos 7 to Cognos 10.1, Cognos 10.2
Installation and Configuration of Cognos 10 BI (Stand-alone)
Analyze and Design of Datamart for each department
Development and Maintenance of Framework Manager (Query Subject, DMR).
Development and Maintenance of Cubes (Transformer & Dynamic Cube)
Development for Reports with Report Studio/Business Insights Advanced/Active Report (Relationnel,Dimensionnel Data)
Training Business Insights Advanced
Technical background: Business Insights Advanced, Cognos 10, Cognos Impromptu, Cognos Powerplay, Cognos Transformer, Cognos Dynamic Cube
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.
Technical background: Cognos Connection, Cognos Query Studio, Cognos Report Studio, Cognos Analysis Studio, Transformer, Oracle 10.
Goal of the project: develop a new marketing-oriented reporting environment for the Asian Market
Study the customer's needs, Creation of the framework multi data source
Creation of reports: , Creation of reports based on the standard audit framework model Customization & security of Cognos connection,
Optimizing existing Cognos reports for the European market
The goal of this project is to develop a reporting environment for the Travel and Transaction department.
Analyse the user’s 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.
ETL development and reporting for financial department
I had to analyse the needs for the ETL solution, create Integration Services package for data transfer from SAP to SQL Server 2008 (create stored procedure and Function) 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.
Development of financial reports under Report Studio and Analysis Studio.
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
Cognos BI (Decision Stream, Impromptu, Transformer, Powerplay, ReportNet)In this project, I have the role to Create reports in the areas of production and sales in Upfront, modification and improvement of Transformer models.
Cognos 7 (Impromptu, Transformer, PowerPlay, PowerPlay web)