Freelancer profile translated to English.

Description

MSBI and Power BI consultant, certified in SSIS, SQL Server, Azure fundamentals and Power BI Data Analyst Associate.

As a BI data engineer, my mission is to help organizations get the best out of their data through my expertise across the MSBI suite.

In my previous assignments, I was able to take responsibility and participate in the design and creation of dashboards with Power BI.

Throughout my career, I have contributed as a developer/consultant on numerous projects related to different business sectors, most of which have been conducted in an agile manner.

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Can work on-site

Sèvres (up to 50km)

RIMOWA GmbH
Power BI Data Analyst
LUXURY GOODS
March 2022 - November 2022 (9 months)
• Administration and monitoring of the Reporting platform - Power BI Service:
 Ensure the migration of PBI Pro to PBI Premium
 Schedule report updates
 Manage access rights
 Maintain the platform
 Performance monitoring
 Monitor usage metrics in workspaces
• Correction and evolution of existing reports: adding new KPIs, correcting anomalies, optimizing energy-intensive reports
• Participating in needs expression workshops with the business team and data teams
• Modeling star schemas for Sales and Supply Chain data marts
• Managing the quality of data feeding the Data Warehouse and the Sales data mart under BigQuery:
o Preparation and execution of test and validation scenarios.
o Creation of a convergent model for the master dimension of articles
• Creation of datasets with Google Big Query
• Development of KPIs, with DAX, inherent to the Sales and Supply Chain component:
 Revenue growth rate by region, zone and over time
 Total repairs by model and product category
 Product availability rate
 Number of products in transit between warehouse hubs and stores…
• Creation and formatting of dashboards, under Power BI Desktop: presentation and visualization of data according to the types of graphs
• Production of dashboards
• Writing documentation and preparing deliverables
Microsoft Power BI Big Query Google Data Studio Microsoft Azure
EDF
Power BI Consultant
ENERGY AND UTILITIES
October 2021 - March 2022 (5 months)
Nanterre, France
Project context: Design and development with Power BI of dashboards for monitoring and managing business and projects
Tasks performed:
• Facilitating needs expression workshops with the business team and writing functional requirements specification documents
• Facilitating workshops with the Data team and writing technical specification documents
• Modeling with Power Pivot, a star schema based on multiple data sources: SQL Server database, Excel files under SharePoint, and the MS Project Online database via the API.
• Creation of datasets in the form of views, with T-SQL
• Data transformation with Power Query: unification of formats, correction of erroneous data...
• Development of KPIs, with DAX, inherent to the business and project management component: processing rate of business and projects on time, rate of active business without documentary quality errors
• Creation and formatting of dashboards, under Power BI Desktop: presentation and visualization of data according to the types of graphs
• Production of dashboards
• Writing documentation and preparing deliverables
Technical environment:
Power BI Report Server, T-SQL, SQL Server 2016, JIRA, Windows 10, DAX Studio, JIRA
Microsoft Power BI SQL Server Microsoft Sharepoint Microsoft Project DAX