Ali - Consultant COGNOS

6/5/2011 – 31/01/2014 Sodexo
Role: Cognos Lead / Technical Business Analyst

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

25/01/2011 – 02/05/2011 Carlson Wagonlit Travel Belgium
Role: Technical and Functional Analyst

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.

01/9/2009 – 24/01/2011 ETO France
Role: Technical and Functional Analyst

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

Technical background: Cognos Connection, Cognos Query Studio, Cognos Report Studio, Cognos Framework Manager, Sybase, SQL Serveur 2005

01/04/2009 – 25/08/2009 Carlson Wagonlit Travel Belgium
Role: Developer and Functional Analyst

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.

Technical background: Cognos Connection, Cognos Query Studio, Cognos Report Studio, Cognos Analysis Studio

01/9/2008 - 27/03/2009 Mecar Belgium
Role: Developer and Functional Analyst

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.

Technical background: Cognos Report Studio, Cognos Framework Manager, Transformer, Integration Services SSIS, SAP, PL/SQL

01/04/2008 – 29/08/2008 TOKHIEM
Role: Technical and Functional Analyst

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

Technical background: BI Microsoft (Integration Services, Reporting Services, Analysis Services, SQL Server 2008, PL/SQL.

18/06/2007 - 21/03/2008 Carlson Wagonlit Travel Belgium
Role: Developer

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

Technical background: BI Microsoft (Integration Services, Reporting Services, Analysis Services, SQL Server 2005, PL/SQL.

04/09/2006 - 02/04/2007 Xplorium France
Role: Functional Analyst

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

Technical background: Cognos BI (Decision Stream, Impromptu, Transformer, Powerplay, ReportNet)

27/03/2006 - 17/08/2006 Banque Populaire France
Role: Functional Analyst

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.

Technical background: Cognos 7 (Impromptu, Transformer, PowerPlay, PowerPlay web)