Salaheddine Mrabet

Implementation of a unique person master data management (MDM) repository to feed business systems (CRM) from heterogeneous sources, with normalization and "golden record" generation.

Achievements:

• Development and optimization of +40 SSIS flows for MDM data loading (volume: over 3 million consolidated individuals).

• Writing and optimizing complex stored procedures for data quality control, deduplication, and reliability.

• Implementation of matching/deduplication rules improving repository quality by 35% (duplicate reduction).

• Creation of Power BI dashboards for monitoring completeness and performance (daily refresh, +15 KPIs tracked).

• Participation in target model design and data dictionary writing.

Key results:

◦ - Duplicate rate reduced by 35%

◦ - Daily processing time halved

◦ - Consolidated repository of 3+ million individuals

Environment: Azure DevOps, SQL Server 2019, Visual Studio Code, Power BI

Project team: 1 Project Manager, 3 Developers, and Business Experts

Optimization of the existing architecture for processing reliability and performance.

Achievements:

• Optimization of 15 critical SSIS flows, reducing processing time by 40% and meeting an SLA of < 15 minutes per execution.

• Archiving of large tables (200+ million rows) with optimized incremental tracking.

• Performance improvement of 12 SSRS reports (average execution time reduced by 70%).

• Facilitating workshops with business stakeholders to present optimization results and validate deliverables.

Key results:

• - Overall performance improved by +60%

• - No production regressions

• - Exhaustive technical documentation validated by the team

Environment: SQL Server 2016, Studio 2017, Jira

Migration of existing SSIS flows to the GCP platform as part of the "Move to Cloud" project.

Work performed:

• Creation of SSIS flows for migrating data sources from SQL Server to GCP.

• Non-regression testing (Legacy VS GCP).

• Maintenance of SSIS flows before migration (Dual Run).

• Creation of SSIS flows for extracting data from Microsoft Teams.

• Creation of the continuous deployment pipeline with GIT (CI/CD).

Environment: SQL Server 2018, Visual Studio 2019 with migration to BigQuery (GCP), Azure DevOps, Confluence. Project team: 1 Project Manager, 1 Tech Lead, 5 Developers, and Business Experts