Senior BI Consultant | Architect

Profil Foto
Verfügbarkeit einsehen
  Weltweit
fr  |  en  |  es
  auf Anfrage
  1000 Bruxelles
 02.08.2018

Kurzvorstellung

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)
    4 Jahre, 10 Monate Erfahrung
  • ETL
    3 Jahre, 1 Monat Erfahrung
  • Oracle Database
    2 Jahre, 1 Monat Erfahrung
Forschung, Wissenschaft, Bildung
  • Data Science

Fokus
  • Project Management
  • Data Reporting
  • Visualization

Projekt‐ & Berufserfahrung

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

8/2017 – 8/2018

Tätigkeitsbeschreibung

Context
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)
Banken
Tätigkeitszeitraum

9/2016 – 6/2018

Tätigkeitsbeschreibung

Context
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)
Telekommunikation
Tätigkeitszeitraum

9/2014 – 9/2016

Tätigkeitsbeschreibung

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)
Context
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)
Telekommunikation
Tätigkeitszeitraum

9/2013 – 9/2014

Tätigkeitsbeschreibung

Tasks
 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)
Banken
Tätigkeitszeitraum

9/2012 – 9/2013

Tätigkeitsbeschreibung

Context
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.
Tasks
 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)


Ausbildung

Business Intelligence & Statistics
(Master)
Jahr: 2014
Ort: Lyon, France

Qualifikationen

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

Persönliche Daten

Sprache
  • Französisch (Muttersprache)
  • Englisch (Fließend)
  • Spanisch (Fließend)
Reisebereitschaft
Weltweit
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
42
Alter
28
Berufserfahrung
7 Jahre und 4 Monate (seit 04/2011)
Projektleitung
6 Jahre

Kontaktdaten

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

Jetzt Mitglied werden »