Adil - Consultant COGNOS TM1

Ref : 220614T001

Domicile

NR8 5FD NORWICH (Royaume-Uni)
Profil

Consultant, Consultant technique (44 ans)
Mobilité

Totalement mobile
Statut

Mandataire social de sa structure Freelance (SARL, SAS, EURL, etc)

Compétences

COGNOS TM1

SQL SERVER

Microsoft Power BI

SSIS

COGNOS BI

COGNOS REPORT STUDIO

Expériences professionnelles

Business intelligence system analyst

Kettle Foods Limited, Norwich, United Kingdom
Jan 2013 - aujourd'hui
Key responsibilities:
â Support the Finance and Planning team in providing concise and relevant monthly
management information to stakeholders by creating and maintaining Dashboards and KPI’s.
â Support business strategy & Identify process improvement opportunities
â Leading data migration projects during the integration process with new companies.
â Development of a wide application Using IBM Cognos Cognos TM1 to manage:
â Input sales promotions
â Manage promotion workflow with TM1 processes
â Calculate promotion data and integrate external data to generate budget and Forecast
â Train system TM1 end-users on TM1 functionality, models, and report development utilizing
best practices
â Identify the risk assessments for the new system functionalities and enhancements
â Support software upgrades, software documentation.
â Create and maintain reporting using IBM Cognos BI Reporting and Microsoft Power BI
â Maintain data transfer between IBM Cognos TM1, SQL Server and Oracle (using Microsoft SSIS
Packages and TM1 Turbo integrator)
Technical platform
â Cognos Planning Analytics (TM1) 10.2.x
o TM1 Development/ Administration (Cubes, Dimensions, Rules, Feeders, TI
processes…)
o TM1 Optimisation (Security, Feeders, Data consolidation, hierarchies, Subsets, MDX
queries...)
o Xcelerator via Excel (Active forms, Input screens, …)
â IBM Cognos Business Analytics (B)I 11.2.x
o Report Studio (Active Reports, Dashboards, …)
o Framework Manager
o Security, Jobs
â SQL Server 2012/ Oracle 10.x (Toad for Oracle)
o Microsoft SSIS Packages development / Data integration (ETL) / automated Jobs
o Database development (Transact SQL, Tables, Stored procedures, Views,...)
â Cubewise Canvas software for Cognos TM1
o Web development (HTML/CSS, Angular-Js, Bootstrap, Javascript)
3
Senior Consultant

AEXIS, France Cognos BI/TM1
Jan 2006 - Jan 2013
AEXIS is a French Consultancy firm which distributes and integrates business intelligence solutions for
companies. AEXIS has more than fifteen years experience in the integration of TM1 solution in Europe.
Key responsibilities at AEXIS:
â Project management (Cost, resources, timeline and deliveries)
â Writing business specifications
â Understand the business requirements and design the business intelligence solution.
â Design and develop the reporting for business intelligence solution.
â Manage performance, Security and data backups
â Training
Consultancy experience:
â EXPANSCIENCE (medical Laboratory )
o Development of a new TM1 application for purchasing department using :
o Cognos Express platform (TM1, Reports Studio, FrameWork Manager…)
o ETL (SSIS packages) with SQL Server Data Warehouse
â M6 Group (Energy), maintaining an existing TM1 Solution.
â EDF (Energy), design and development of a new Cognos TM1 solution.
â ALMA Consulting (Operational Consulting), designing and developing a Cognos TM1 solution
â OBERTHURES Technologies (Electronic) designing and developing a Cognos TM1 solution
â TOSHIBA (Electronic), development of a new Cognos TM1 solution for Finance department
â SNCF (Transport), designing and implementing an INFOR PM solution
â VEOLIA Propreté (Environment), designing and developing a Reporting solution with SSRS.
â VEOLIA Propreté (Environment), designing and developing a INFOR PM solution
â ANSALDO STS (Transport), designing and developing a INFOR PM solution
â IEDOM (Banking), designing and developing a Workflow solution with Beacon Bids (Australian
product)
Microsoft Software Engineer

SOCIETE GENERAL (Banking) Union Technologies, France
Jan 2001 - Jan 2006
Key responsibilities:
â Analysis of costumer need.
â Development of client-server application
â Development of web-based application
Consultancy Experience:
â FILTRAUTO (Industry), Developing and implementing a web base application
â MIZUHO Financial Group (Banking), designing and developing client server application
â GENERAL D'OPTIQUE (Industry) designing and developing client server application
â SINOPIA ASSET MANAGEMENT (Banking), designing and developing client server application