Sofiane B.

Within the Data Performance department at Leroy Merlin, I work on cross-functional projects with high added value to drive company performance through complex data modeling and Data Storytelling.

🚀 Major Achievements:

Leader Performance Dashboard: Design and deployment of the company's most consulted dashboard (+25,000 views), centralizing over 150 strategic KPIs to facilitate decision-making for business units.

Cross-functional & Mobile Projects: Analysis, structuring, and provision of data for monitoring the performance of the brand's mobile applications.

Architecture & Modeling: Cross-referencing complex multi-source data sources (SQL) to create robust, optimized, and scalable data models.

🎯 Key Missions & Activities:

Requirements Gathering & Scoping: Supporting business teams (Finance, Performance, Product) in defining their key indicators (360° KPIs).

Data Storytelling & Data UX: Presenting data in the form of highly visual, interactive, and user-experience-oriented Power BI dashboards to maximize adoption.

Industrialization & Quality: Writing functional and technical documentation, automating data flows, and administering data sources.

Change Management: Supporting and training end-users in adopting decision-support tools.

Project: As part of the release of an application under Appsheet (Magasin Platform), I am involved in incident management (RUN) as well as the maintenance and development of the application through SQL queries.

Context: As part of optimizing the management of Auchan's store network, an application was developed to help them better manage orders and deliveries between hypermarkets and supermarkets. It is in this context that I joined this mission to oversee and contribute to the application's development.

Run:

● Receiving various needs (EasyVista)

● Estimating deliverables

● Collecting necessary information for execution

● Problem resolution

Development:

● Collecting business requests via Jira

● Planning deliverables

● Developing various application evolutions in SQL

● Testing phase

● Deployment

Application Analysis:

● Receiving data via Postgresql

● Creating reports in Looker

● Activity rate of stores using the application across the entire Auchan network, active/inactive stores, etc.

Flow Analysis:

● Receiving appsheet flows in various buckets on Google Cloud Platform (Prod and staging)

● Analyzing successful routing to the data repository via Cortex

● Querying the data repository with BigQuery to verify data consistency between the repository and appsheet

● Resolving flow-related issues

Project: In direct contact with the teams in England, I was responsible for creating visual and relevant dashboards regarding the company's activity. Howdens Cuisine had recently established itself in France, and the challenge was to provide precise reports to assist the company in strategic and marketing decision-making.

Context: Due to strong business growth. The analysis of different kitchen ranges, new products, and various categories was an essential factor in making decisions about their marketing strategy.

● Receiving various needs

● Estimating deliverables

● Collecting necessary information (BO Universe)

● SQL querying for indicator design

● Creating various dashboards

● Automating these dashboards

● Analyzing results (inconsistencies) and providing solutions

SEO Traffic Analysis

Context: Following their strong growth, Howdens Cuisine launched a new website for artisans (professional site) in addition to their consumer site (private individual site). I therefore worked on analyzing the SEO traffic of these 2 sites as well as their performance:

● Receiving data via Google Analytics

● Creating reports in Data Studio

● Bounce rate, number of sessions, catalog requests, number of users, etc...

● Referrals (organic, referral, direct, Social Media)

● Number of conversions (Objective achievement)

● Site performance (404 errors, most clicked pages, most searched terms, page loading)