Adil - Consultant COGNOS TM1

Ref : 220614T001

NR8 5FD NORWICH (Royaume-Uni)
Consultant, Consultant technique (43 ans)
Totalement mobile
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

Études et formations

CERTIFICATES

IBM Certified Specialist - Cognos TM1 Data Analysis
IBM Certified Developer - Cognos TM1
IBM Certified Designer - Cognos BI Reports
Microsoft Certified Professional - SQL SEducation
2019-2022 Master’s degree (MSc L7 Digital and Technology Solutions Specialist)
(Nottingham Trent University), UK.
Data Analytics Modules:
Big Data and Its Infrastructure
Statistical Approaches to Data Analysis
Practical Machine Learning Methods for Data Mining
Business Modules:
Delivering Value Creation
Effective Change Management
Projects:
Project Conceptualisation and Planning
Work-based Project
1998-2000: Bachelor of Engineering in Information System
EMSI (Moroccan school of engineering)
1995-1997: Associate Degree
ISGI (Higher Institute of Management and information systems)
1995 High School Graduation (Al Khawarizmi)
(Mathematics)erver

Personal Details
Date of Birth : 19/07/1976
Language:
▪ English (Fluent)
▪ French (Fluent)
▪ Arabic (Fluent)
Nationality: French
Married (3 children)

KEY TECHNICAL SKILLS / EXPERTISE
Very Good Finance and Management Skills
IBM Cognos Planning Analytics (TM1 Cubes)
(10.2.x)
IBM Cognos Business Analytics BI 11.x suite:
✓ Cognos Report Studio
✓ Cognos Framework
✓ Cognos Administration
Microsoft Power BI (Dashboarding/KPI’s)
IBM SPSS statistics
Microsoft SQL SERVER 2008/2012
✓ SSIS (Microsoft data integration)
✓ SSRS (Microsoft Reporting services)
ORACLE 10 (Toad for oracle)
Web Development: (HTML/CSS/Angular Js/Bootstrap/Javascript)
Infor MPC Relationnel / Infor MPC AS
Infor Decision Web

Autres compétences

CERTIFICATES

IBM Certified Specialist - Cognos TM1 Data Analysis
IBM Certified Developer - Cognos TM1
IBM Certified Designer - Cognos BI Reports
Microsoft Certified Professional - SQL SEducation
2019-2022 Master’s degree (MSc L7 Digital and Technology Solutions Specialist)
(Nottingham Trent University), UK.
Data Analytics Modules:
Big Data and Its Infrastructure
Statistical Approaches to Data Analysis
Practical Machine Learning Methods for Data Mining
Business Modules:
Delivering Value Creation
Effective Change Management
Projects:
Project Conceptualisation and Planning
Work-based Project
1998-2000: Bachelor of Engineering in Information System
EMSI (Moroccan school of engineering)
1995-1997: Associate Degree
ISGI (Higher Institute of Management and information systems)
1995 High School Graduation (Al Khawarizmi)
(Mathematics)erver

Personal Details
Date of Birth : 19/07/1976
Language:
▪ English (Fluent)
▪ French (Fluent)
▪ Arabic (Fluent)
Nationality: French
Married (3 children)

KEY TECHNICAL SKILLS / EXPERTISE
Very Good Finance and Management Skills
IBM Cognos Planning Analytics (TM1 Cubes)
(10.2.x)
IBM Cognos Business Analytics BI 11.x suite:
✓ Cognos Report Studio
✓ Cognos Framework
✓ Cognos Administration
Microsoft Power BI (Dashboarding/KPI’s)
IBM SPSS statistics
Microsoft SQL SERVER 2008/2012
✓ SSIS (Microsoft data integration)
✓ SSRS (Microsoft Reporting services)
ORACLE 10 (Toad for oracle)
Web Development: (HTML/CSS/Angular Js/Bootstrap/Javascript)
Infor MPC Relationnel / Infor MPC AS
Infor Decision Web