June. 2017– Aug. 2018: The Clients Generator - Digital Marketing Agency – London
Operated a Full-service Digital advertising agency which purpose is to help SMEs increase Sales and acquire new clients
Clients Requirements Gathering
Sales Funnels, Lead Generation
Ecommerce Data Analytics
PPC Marketing
Dec. 2016 – Jul. 2017: BI Consultant – Board MIT – London, UK
Developed business solutions with BOARD MIT toolkit:
(Clear Channel, Close Brothers Group, Sportpursuit and Jaeger)
Analysis of corporate data
Modelling of key corporate processes and MOLAP cubes creation.
Designing and building Dashboards
Involvement in pre-sales activities and Clients trainings.
Environment: BOARD MIT toolkit, Multi-dimensional (MOLAP) databases
Apr. 2016 – Oct.2016: Freelance Consultant – Humanis- Insy2s IT Consulting– Lille, France
Within several development projects related to the Information Systems Department particularly in the area of "Complementary Pensions - Social Action - Savings - International"
Captured the client's requirements and drafting the General Specification and the modelling of the solution
Drafted the Technical Specification (specifying the technical solution that describes the processes, services, reports) and test cases
Development of ODI interfaces
Development of Cognos reports using relational data sources
Preparation, assembling and delivering programs, components and modules in stage and production environment
Assisted business users with the issues encountered
Environment: ODI 11g / COGNOS BI 10.2.1 / COGNOS Analytics 11/ Sybase IQ / SQL / UNIX
Feb. 2016 - Apr. 2016: IBM – Analyst - Client EDF – Lille, France
Within the development of several EDF applications:
Challenged the ETL development costs proposed by the integrator
Functional and technical impact analysis of potential changes to the ETL environment
Participated in UAT cycle for monthly releases. Monitored and fixed regression defects
Handled production issues
Environment: Informatica PowerCenter / COGNOS BI 10.2.1 /Oracle / SQL
Nov. – Dec. 2015: IBM – Expertise in Cognos BI intervention - Client Veolia – Nice, France
Resolved issues related to data and performance on Cognos Report studio
Reviewed the design of the model developed on Framework Manager
Enhanced Cognos reports performance
Environment: COGNOS BI 10.2.1 Framework Manager, Report Studio and Query Studio
Apr. 2015 – Apr. 2016: IBM – Team leader - Client BNP Paribas – Paris, France
Within the BI Migration project from BO to Cognos for several BNP applications:
Analysed the client requirements and drew the corresponding specifications
Management of a team of 3 Cognos testers
Integration tests of complex reports developed on Cognos report studio
Responsible of deliveries to the client
Assisted business users with the issues encountered
Support
Environment: Business Object v5.0 / COGNOS BI 10.2.1 / SQL SERVER / SQL / UNIX / ALM
Jul. 2014 – Mar. 2015: IBM – Analyst / Developer - Client ProBTP – Lille, France
Within the leading SOLON cloud business solution designed to fight healthcare insurance fraud:
Analysed client requirements
Participated to the creation of the Data Warehouse on DB2
Implemented financial indicators on Datastage
Created the model in Cognos Framework Manager
Created reports applying calculations, drill behaviours, filters, prompts, conditional formatting, bursting
Responsible of deploying deliverables on different environments (INT, UAT, PRD)
Environment: DATASTAGE / COGNOS BI 8 / DB2 / SQL / UNIX
Sep. 2013 - June 2014: IBM - Data Analyst - Client UNMS-NVSM – Brussels, Belgium
Within a Data Migration Project between two major Belgian insurances:
Reviewed and approved the functional design documents along with the business analyst
Designed Data flow diagrams according to ETL DataStage
Transmitted the client requirements to developers through Data flow diagrams (6 developers)
Performed integration tests of developed jobs
Environment: DATASTAGE / DB2 / Visio / IPWC
Feb. – Aug. 2013: CSC- BI Consultant - Client LVMH – Paris, France
Within the roll out of the core model BI of Moët Hennessy entity in Russia and Taiwan:
Drawing up Functional and technical specifications
Participated to the Design and creation of the Data Warehouse on Oracle.
Designed and created ETL Datastage jobs
Created cubes and developed reports using relational and multi-dimensional data sources Environment: Datastage PX / Cognos BI 8 Transformer and Framework Manager / Oracle / SQL
June. – Sep. 2012: Bi Developer -Cofidis Participations– Lille, France
Implemented different data management tools in the litigation department to gain in productivity and reduce management costs.
Environment: SAS 9.1 / Visual Basic / Business Object
EDUCATION
2011-2013: Master degree in Business Intelligence Lille 1 University, Lille France
2008-2011: Bachelor degree in Business Intelligence Lille 1 University, Lille France
BI SKLLS
Data Visualisation
Cognos BI
Business Object
Tableau-Qlikview
ETL
• DataWahouse
• Datastage
• ODI
• Talend
CERTIFICATIONS
• Cognos BI: ‘IBM Certified Designer - Cognos 10 BI Reports’
• Toastmasters International:‘Competent Communicator’