Senior BI Consultant | Architect

freiberufler Senior BI Consultant | Architect auf
Verfügbarkeit einsehen
fr  |  en  |  es
auf Anfrage
1000 Bruxelles


AVAILABLE FROM 15/08/2018.
Holding a Master's Degree in Business Intelligence and Statistics in Lyon (France), I have acquired 6 years of professional experience on complex BI international projects (ETL, Reporting, Data Visualization).

Ich biete

IT, Entwicklung
  • Business Intelligence (BI)
  • ETL
  • Oracle Database
Forschung, Wissenschaft, Bildung
  • Data Science

  • Project Management
  • Data Reporting
  • Visualization

Projekt‐ & Berufserfahrung

BI Functional Analyst
BNP Paribas Fortis, Brussels
8/2017 – 8/2018 (1 Jahr, 1 Monat)

8/2017 – 8/2018


BI Consultant inside the MiFID Reporting Squad (TRIBE BI), I am responsible of the delivery of the product MiFID Reporting – Audimart. The objective is analyze functionally the solution, design, implement and load the datamart that contains MiFID Regulatory Reporting data and that enable to stakeholders to control banking transactions.
 Turn the product backlog in sprint backlogs (user stories, acceptance criteria, estimate, definition of done...)
 Write-up workshops minutes of meetings, traceability matrix of functional points, agendas, functional documents  Design (model) datamart: conceptual, logical and physical models (SAP Power Designer)
 Develop SQL scripts to create the datamart structure in DEV, TEST, QA environments (Oracle 11g)
 Develop ETL flows (mappings, workflows...), execute with Unix scrips, integrations, tests (Informatica)

Eingesetzte Qualifikationen

SAP BusinessObjects (BO), SAP Crystal Reports, Informatica, Agile Entwicklung, Jira

BI Project Manager
Amazon Services, San Jose
9/2016 – 6/2018 (1 Jahr, 10 Monate)

9/2016 – 6/2018


Integrated in the department Cloud Analytics of Amazon Services (entity Costa Rica), sub-contracted by a consultancy company, my role of project manager is to manage two (2) Agile teams about the development of BI analytics solutions and reports delivered for banking end users located in Central America and Caribbean market (Wealth Management); and report the team performances + results to the Sr Project Manager. From Sept 2016 until May 2017, work on site and work in remote (50% - night hours) from June 2017.
Tasks – Management Role
 Follow-up advancement of the teams and performance reporting with JIRA
 Generate project follow up advancement KPIs – Drive the project between the business and internal teams
 Built monthly reports about the squad teams performances and sent to the general directions.Tasks - Product
Owner Role
 Define the product vision with the stakeholders
 Build and update the products backlogs with the stakeholders and development teams’ items
 Assign estimates (in terms of effort, charge, complexity) in collaboration with the development teams
 Prioritize the stakeholders’ product backlog items (PBI) aligned to the up-to-date requirements. (each sprint)
 Build the products release/sprint burndown(up) charts for presentation at the sprint review meetings (in Spanish)
Tasks – Technical Role
 Business Intelligence solution applicative management (maintenance): DB (Sybase IQ), ETL (Informatica)  Develop complex SQL scripts (packages PL-SQL), Procedures, Trigger, CREATE, UPDATE + test
 Develop/update of the Informatica/Datastage dataflows on the BI architecture + test
 Develop and update SAP Business Objects universes (30) with associated specification + test
 Develop and update SAP Business Objects Webi documents (55) with associated specification + test
o Creation of the new reports: blocks, sections, entry controls, documents and reports filters
o Webi complex queries: sub-queries, operators of joins, queries crossing, union, intersections...
o Management of the user’s right accesses (LDAP / Universes access / Mode Full, Semi and Reader)
Technical Environment
JIRA, IBM Datastage PX, Informatica Power Center, SAP Business Objects 4.1 (Crystal Report, Web Intelligence, Design Studio, Lumira), HP Quality Center

Eingesetzte Qualifikationen

Business Intelligence (BI), Datawarehouse / DWH, SAP BusinessObjects (BO)

BI Consultant
Accenture, Paris
9/2014 – 9/2016 (2 Jahre, 1 Monat)

9/2014 – 9/2016


BI Consultant, Accenture / Client: AFD - Paris, France. Aug 14 – Aug 15 (12 months) Tasks – Functional Role
 Defined and discussed with the business about technical solutions and detailed costings of each technical task
 Wrote-up functional and technical specifications of Informatica dataflows, BO universes, BO documents/reports
 Updated functional and technical specifications of Informatica dataflows, BO universes, BO documents/reports
Tasks – Technical Role (all these tasks were done on four development environments)
 Designed logical and physical BI datawarehouses and datamarts models with Oracle Data Modeler
 Generated SQL scripts for execution and creation of the datawarehouses / datamarts structure (new projects)  Developed SQL scripts queries for evolution or correction of the datawarehouses / datamarts structures + test  Developed data flows (mapplets, mappings, workflow...) with Informatica Power Center + integration + test
 Designed the BusinessObjects universes (linked to DMA) with classes, sub-classes, objects, contexts...
 Developed or updated BusinessObjects Web Intelligence documents and reports aligned to the requirements
Technical Environment
Informatica Power Center (Designer, Monitor, Repository, Manager), Oracle 11g, Microsoft SQL Server 2012, SAP Business Objects XI R3 3.1 (Web Intelligence, Desktop Intelligence)

Confirmed BI Consultant, Accenture / Client: Indosuez - Lausanne, Switzerland. Aug 15 – Aug 16 (12 months) (with monthly travels in Dubai (UAE) for the CA Private Banking Middle East agency)
Such as a BI Consultant and Confirmed BI Consultant (2nd year) at ATS (Accenture Technology Solution) in Paris (France), I have worked for two clients in France and Switzerland (Finance and Banking). My role (inside 4-8 people teams) was to analyze functionally and technically and develop Business Intelligence solutions (ETL, Reporting, Data Visualization)
Tasks – Business Analyst Role (All these tasks concern deliveries such as DB/ETL/Universes/Reports deliveries)  Received the requirements of the worldwide agencies on Lotus platform (new projects, correction, evolutions...)  Analyzed and described the potential viable technical solution to implement
 Defined detailed costings depending of the technical solution and the available resources (in d/m)
 Wrote-up or updated functional and technical specification that explained the new/corrected/evolved solution
Tasks – Technical Role
 Developed and tested SQL scripts for creation or updates of datawarehouses / datamarts structures (in DEV)  Executed the SQL queries in Integration environment for replication of the ODS/DWH/DMA structure.
 Sent requests (via Lotus Notes, ticket) to execute the queries in the production environment (PRD)

Confirmed BI Consultant, Accenture / Client: Indosuez - Lausanne, Switzerland. Aug 15 – Aug 16 (12 months)
 Developed and updated Datastage ETL data flows (jobs servers, parallel, sequence) and tested (in DEV)
 Integrated Datastage deliveries in the Integration and Pre-Production environment to execute and test
 Designed and updated Business Objects universes (linked to DMA) (star schemas) in development environment  Integrated the new or up-to-date BusinessObjects universes / reports in integration environment + test
Technical Environment
IBM Lotus Notes, IBM DB2, IBM Datastage PX 9.1, SAP Business Objects 4.1 (Web Intelligence, Crystal Reports, Design Studio, Lumira), JIRA Confluence

Eingesetzte Qualifikationen

Business Intelligence (BI), Datawarehouse / DWH, SAP BusinessObjects (BO), ETL, Informatica, Oracle Database

BI Consultant
Capgemini, Marseille
9/2013 – 9/2014 (1 Jahr, 1 Monat)

9/2013 – 9/2014


 Managed data with MySQL and data quality with Talend for Data Quality
 Designed BI models with MySQL Designer and extracted, transformed, loaded data with Talend DI
 Developed Qlikview dashboarding applications: dashboards with Qlikview 11.0  Integrated data from MySQL into Qlikview 11.0 for analysis and visualization
 Wrote-up and updated technical specifications
Technical Environment
Qlikview 11.0, Talend Data Integration, Talend for Data Quality, MySQL, Microsoft Office 2011 (Vision, Word, Power Point, Access)

Eingesetzte Qualifikationen

Business Intelligence (BI), QlikView, ETL

BI Consultant Assistant / Statistician Methodologist
Statistics Canada, Ottawa
9/2012 – 9/2013 (1 Jahr, 1 Monat)

9/2012 – 9/2013


Such as a BI Specialist Assistant in the division Business Survey Methods and Analytics (project team of 20 people), my role was to participate to a project about the Statistics Canada survey decision making, strategic decision, in order to reduce the global cost of the project.
 Extracted, transformed and loaded complex SAS data with macros developed on SAS Base
 Applied a ‘RAKING’ process (iterative process) to manage data quality and get estimated data  Data Analysis – OLAP: compared the produced data with the estimated data
 Intensive Learning in the Statistics Canada Institute + Seminars / Conferences Organization
o SAS Beginner and Advanced Levels o Big Data For New Analytics View
Technical Environment
SAS Base, SAS Enterprise Guide, SAS Graph, Oracle 11g

Eingesetzte Qualifikationen

SAS Business Intelligence (BI)


Business Intelligence & Statistics
Jahr: 2014
Ort: Lyon, France


SQL,SAP Business Objects,ETL,Business Intelligence,Informatica,Datastage,IBM DB2,Oracle,Microsoft,Qlikview,Tableau,Data,Management,Reporting,Visualization

Persönliche Daten

  • Französisch (Muttersprache)
  • Englisch (Fließend)
  • Spanisch (Fließend)
  • Europäische Union
9 Jahre und 1 Monat (seit 04/2011)
6 Jahre


Nur registrierte PREMIUM-Mitglieder von können Kontaktdaten einsehen.

Jetzt Mitglied werden »