Fatou C

I supported the PRO/PME Business Unit and Management Control in data reliability, reporting automation, and BI tool modernization (Tableau → Power BI).

Creation of a Tableau Dashboard for the Management Committee to track subsidized terminal volumes.

Transition from manual reporting by Management Control to an automated, reliable, and easy-to-update report.

Contribution: Consolidated vision essential for commercial and financial management.

Development of code to ensure correct distribution of credits between GC, E, and PRO/PME entities.

Strict application of management rules requested by Management Control.

Impact: Fair allocation of amounts during monthly closing.

Analysis and identification of discrepancies between Management Control data and Data department data.

Correction of error sources and complete migration from Management Control to Data figures.

Result: Significant operational gain, closing time reduced from 5 days to 3 days, eliminating manual processing.

One-off analyses, data extraction, and exploration based on business needs.

Adaptation of code and dashboards following changes in management rules or scope.

Migration of about fifteen Tableau Dashboards to Power BI as part of decommissioning.

Visual redesign, modeling optimization, and KPI harmonization.

Design of a Power BI report based on a PowerPoint mockup provided by the teams.

Implementation of fully automated updates to replace manual reporting.

Analysis of churn and optimization of the Darty Max loyalty program

Comprehensive review of the Darty Max program since its launch.

Behavioral and transactional analysis of churned vs. active customers: purchases, frequency, basket size, lifecycle, socio-demographic profile.

Identification of churn-predictive variables for predictive score construction by the Data Science team.

🔹 Measurement of the program's value impact and loyalty effect

Identification of 3 types of Darty Max customers.

Construction of comparison populations from a sample of 100,000 non-subscribers, based on RFM segmentation.

Analysis of purchasing behavior 12 months before / 12 months after program subscription.

Study of socio-demographic profiles and inter-population differences.

🔹 Data Migration: Hadoop/R → GCP / BigQuery

Migration of multiple analytical reports to BigQuery as part of the GCP cloud transition.

Implementation of a dual run R vs. BigQuery to ensure data consistency and quality.

🔹 Harmonization of Fnac & Darty Databases

Testing and validation of the new Group sales table.

Detailed comparison of KPIs between the old and new databases (Revenue, volumes, etc.) and investigation of discrepancies to identify their source.

🔹 Development of Analytics & CRM Tools

Design of a Targeting Assistant for sales & CRM teams, enabling self-service targeting and significantly reducing recurring requests to the Customer Knowledge team.

Creation of a dedicated report for tracking Darty customer contactability.

Production of target extractions for marketing campaigns and post-operation performance reviews.

Design of dataviz and dashboards on Looker (Looker Studio & Looker BI).

Creation of a specific report tracking customer activation post Black Friday.

Design and development of dashboards for monitoring real estate alerts.

Data extraction and preparation using SQL & Python.

Processing and orchestration in AWS, followed by visualization in Tableau Software.

Objective: Provide a reliable and up-to-date view of user performance and behavior.

Creation of dashboards to monitor the activity and effectiveness of outbound call campaigns.

Data structuring, workflow automation, and provision of operational and strategic indicators.

Development of Python scripts for complete automation of marketing targeting.

Standardization of business rules and reduction of production time for distribution lists.

Direct contribution to the reliability and acceleration of CRM processes.

Preparation of audiences for email communication distribution via Adobe Campaign.

Segmentation, extraction, and quality control of lists before marketing push.

Ensuring precise distribution in line with CRM and marketing team needs.