Mouna El Bouardi

Migration and modernization of a legacy decision-making platform to a modern cloud architecture based on Google Cloud Platform (GCP), BigQuery, and DBT for a major player in the transport sector.

• Design and development of ELT pipelines on GCP and BigQuery.

• Data Warehouse modeling and implementation of DBT models (Bronze, Silver, Gold).

• Migration of legacy processes and integration of existing business rules.

• Optimization of BigQuery performance and costs through partitioning, clustering, and SQL optimization.

• Implementation of Infrastructure as Code with Terraform and industrialization of deployments.

• Industrialization and orchestration of processes via Cloud Run, Cloud Scheduler, and Artifact Registry to automate the execution and deployment of data pipelines.

• Migration of BI dashboards (Tableau) to the new platform.

• Support for business teams during functional acceptance testing and production deployment.

Environment: GCP (BigQuery, Cloud Run, Cloud Storage, Cloud Scheduler, Artifact Registry), DBT, Python, Terraform, SQL, Tableau, GitLab CI/CD, Docker.

Redesign and optimization of the Data Warehouse (DWH) for a major player in the transport sector in France, to improve data quality, process performance, and reliability of decision-making reporting.

• Design and evolution of the decision-making data model (facts, dimensions, aggregates) to meet analytical and business needs.

• Development and maintenance of integration pipelines under Talend for feeding the Data Warehouse from multiple data sources.

• Implementation of data control and validation mechanisms: anomaly detection, management of integration discrepancies, and automation of error data recycling.

• Optimization of ETL processes and SQL queries to improve the overall performance of the decision-making platform.

• Development and evolution of Tableau dashboards for activity monitoring and business indicator tracking.

• Participation in production deployments, user support, and incident resolution.

• Technical supervision of interns and onboarding of new team members.

Environment: Talend, SQL, PostgreSQL, Tableau, Data Warehouse, Decision modeling, Jira, Confluence.

Redesign of the reporting module for a call routing management solution for contact centers of a major player in the energy sector, with the goal of improving data exploitation and activity monitoring.

• Gathering and analysis of business needs through functional workshops with stakeholders.

• Definition and implementation of performance indicators (KPIs) and associated calculation rules.

• Design and development of reports and dashboards based on the platform's operational data.

• Optimization of processes and queries to improve performance and response times of restitutions.

• Participation in acceptance testing, production deployment, and post-deployment monitoring.

• Training and support for users in adopting new reporting.

Environment: JasperReports, MongoDB, SQL, Business Intelligence Reporting.