Freelancer profile translated to English.

Description

Passionate about data challenges and new technologies, I have had the pleasure of working with a large number of different domains (Industry, Insurance, Agri-food, Transport, Finance, Administration...) where data and the richness it represented were at the heart of the challenge.

My engineering background and my 10 years of experience have also allowed me to develop skills in project management, management, and data architecture.

My area of intervention begins with understanding needs, data exploration, and continues with the realization of proof of concepts, solution validation, development and creation of products (analysis scripts, ETL flows, reports and dashboards), and documentation writing.

I am particularly familiar with the SQL language and integration tools such as Informatica or Matillion as well as Power BI for reporting. However, I have broad knowledge that allows me to adapt very quickly to different infrastructure morphologies and needs.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Lyon (up to 50km)

Solution BI Canada
Senior Business Intelligence Consultant
DIGITAL AND IT
December 2017 - Today (8 years and 5 months)
Montréal, Canada
Senior Business Intelligence Consultant / Architect
SOLUTION BI > QUEBEC CANNABIS CORPORATION - Since June 2021 - Canada

Missions:
- Knowledge transfer
- Recommendation for improvement/optimization of data architecture
- Maintenance of existing reports in Cognos and Power BI
- Development of several Power BI and Cognos dashboards of varying complexity
- Analysis of data sources
- Analysis of the existing solution
- Facilitation of needs gathering workshops with business lines
- Creation, Development, and Maintenance of the Cloud Data Warehouse

Technical Environment:
Power BI, Cognos, Sqlserver, DB2 Blue, Matillion, Azure, Snowflake, Git

Senior Business Intelligence Consultant
SOLUTION BI > DANONE - February 2021 to June 2021

Context:
Migration from Informatica Power Center to Informatica Cloud Service

Missions:
- Testing
- Creation of technical documentation
- Realization of ICS mappings and workflows
- Writing specifications
- Analysis of the existing environment
- Needs gathering from the client

Technical Environment:
Informatica Cloud Service, Informatica Power Center, Snowflake, Azure

Senior Business Intelligence Consultant / Architect
SOLUTION BI > FICODIS - December 2020 to February 2021

Context:
Creation of a BI environment and integration of data from several ERPs

Missions:
- Creation of technical and functional documentation
- Extraction and transformation of data
- Definition and implementation of star modeling
- Understanding needs and analysis of different data sources

Technical Environment:
Matillion, Snowflake, Power BI, AWS

Senior Business Intelligence Consultant / Project Manager
SOLUTION BI > UBISOFT - November 2019 to November 2020 - Canada

Context:
Integration of a new dimension within the different Data Warehouses and Datamarts

Missions:
- Acceptance testing of developments
- Writing technical specifications
- Analysis, stabilization, and optimization of the existing system
- Analysis, design, and population of the Data Warehouse and Datamart
- Development of complex ETL flows

Technical Environment:
Informatica, Teradata, Snowflake, Stored Procedures, Jira

Senior Business Intelligence Consultant / Architect
SOLUTION BI > EDITEC - June 2019 to November 2019 - Canada

Context:
Development of the EDITEC Business Intelligence system redesign project

Missions:
- Analysis, Design of the new Data Warehouse
- Development and testing of the Data Warehouse and Datamarts
- Writing functional specifications
- Writing technical specifications
- Analysis, stabilization, and optimization of the existing system

Technical Environment:
SSIS SQL Server, MDS, Power BI, Office Suite

Senior Business Intelligence Consultant / Project Manager
SOLUTION BI > DANONE - January 2019 to November 2019 - Canada

Context:
Management and Development of the Dannon Argentina Perseus Project: Integration of Dannon Argentina into the Core Danone ERP & BI tools

Missions:
- Acceptance testing
- Client relationship management (weekly meetings, reports...)
- Writing functional specifications
- Writing technical specifications
- Analysis, stabilization, and optimization of the existing system
- Analysis, design, and development of new BI applications
- ETL analyst-programmer expert
- Management of a team of 3 people

Technical Environment:
Informatica Power Center 10.2, DB2, SQL Server, JIRA

Senior Business Intelligence Consultant
SOLUTION BI > DANONE - January 2018 to December 2018 - Canada

Context:
Participation in the Dannon North America Perseus Project: Integration of Dannon US into the Core

Missions:
- Acceptance testing
- Writing functional specifications
- Writing technical specifications
- Analysis, stabilization, and optimization of the existing system
- Design and development of new BI applications
- ETL analyst-programmer expert

Technical Environment:
Informatica Power Center 10.2, DB2, SQL Server, PowerShell
Snowflake SQL Informatica PowerCenter ICCS Matillion Microsoft Azure IBM Db2 Microsoft Power BI Cognos GitHub AWS Teradata Transact-SQL
Solution BI france
BI Consultant
DIGITAL AND IT
August 2015 - December 2017 (2 years and 4 months)
Paris, France
Client: Danone Group

- Responsible for the technical design of a set of ODS / DWH BI
- Technical lead of the Data Management team
- Participation in the deployment of the Perseus Projects for new Danone entities: Integration of their needs into the Core model
- Acceptance testing
- Writing functional specifications
- Writing technical specifications
- Analysis, stabilization, and optimization of the existing system
- Analysis, design, and development of new BI applications
- ETL analyst-programmer expert
SLT IBM Db2 Informatica PowerCenter UNIX SAP Powershell
CGI
Techno-Functional Consultant
DIGITAL AND IT
May 2012 - September 2015 (3 years and 4 months)
Paris, France
- Application Audit
- Writing and presentation of operating procedures, transport and management of transport orders
- Developments, configurations, test case preparation, integration tests
- Writing detailed design documents, writing technical documents
- Needs gathering, facilitating meetings, ticket estimations
- Participation in the deployment of a harmonized human resources system for the various French armies
Abap SAP HR