Mouna El Bouardi

Migration of the decision-making platform from legacy to a modern DBT + Google Cloud Platform (GCP) architecture for a major player in the mobility & transport sector.

Achievements:

• Design and development of DBT models (staging, intermediate, marts) with recovery, validation, and documentation of existing business rules

• Optimization of ELT pipelines (structuring dependencies, improvement of daily processing execution times)

• Implementation of GCP infrastructure as code with Terraform (BigQuery datasets, GCS buckets, external tables, access and security management)

• Industrialization & orchestration:

– Delivery of application images on Cloud Artifact Registry

– Orchestration of executions via Cloud Scheduler

– Triggering and execution of workloads via Cloud Run

• Migration of data sources and Tableau reports:

– Adaptation of connections to BigQuery

– Review of filters, KPIs, and business rules

– Management of historical data (import strategy and long-term storage)

• Management of business acceptance testing: validation of indicators, documentation of functional discrepancies, impact analysis, and implementation of corrective actions.

• Deployment of the new data platform.

Redesign and optimization of the Data Warehouse (DWH) for a major player in the mobility & transport sector in France, with challenges related to data reliability, processing performance, and BI reporting quality.

Achievements:

• DWH Redesign: business modeling, flow structuring, data quality improvement.

• Design and implementation of an advanced error management mechanism:

– Detection and categorization of anomalies (non-compliance with interface contracts)

– Implementation of an automatic reprocessing system for erroneous data

• BI Modeling: design of fact tables, dimensions, and aggregates to optimize the performance of dashboards and analytical queries

• Development of ELT pipelines using Talend for multi-source data processing and integration.

• Optimization of SQL queries and ETL processes to improve overall performance.

• Design of functional mock-ups and creation of interactive dashboards via Tableau Server.

• Tableau Server Administration: user management, access rights, and data security.

• Production deployment, monitoring of deployments, and incident management via Jira.

• Technical supervision of interns and onboarding of new employees.

Complete redesign of the reporting module for a call routing management solution for contact centers for a major player in the energy sector, with challenges in improving data presentation and user experience.

Achievements:

• Contribution to the BI redesign roadmap

• Facilitation of client workshops for gathering functional requirements and customizing reports.

• Definition of KPIs and performance indicators.

• Design and development of custom reports in JasperReports, connected to a MongoDB database.

• Creation and maintenance of data sources (queries, aggregations, views) optimized for performance.

• Deployment of updates and monitoring of deliverable quality (reliability, stability).

• Analysis and resolution of anomalies reported via Jira.

• Writing technical documentation and disseminating BI best practices.

• Training and support for end-users.