Oualid AFFIF

At LabelVie (Carrefour Maroc), I served as Cloud Data Architect, driving the design and delivery of a next-generation Azure Data & AI platform. My role focused on establishing an enterprise-grade Lakehouse architecture, ensuring security, governance, scalability, and compliance in line with the company’s strategic transformation roadmap. Key Contributions: Defined and validated the target architecture (HLD/LLD) covering governance, resilience, and performance, fully aligned with the Azure Well-Architected Framework. Designed and implemented a multi-hop Databricks Lakehouse (Bronze → Silver → Gold) with Auto Loader, Delta Live Tables, and advanced optimizations (+65% performance). Industrialized Machine Learning pipelines using Databricks ML, MLflow, and Azure ML, integrated into a robust CI/CD & MLOps framework with automated retraining and monitoring. Established a Data Quality & Governance framework using Unity Catalog, ensuring lineage, RBAC, RLS, CLS, encryption, and compliance with GDPR/ISO 27001. Enforced a Zero Trust security model with Private Endpoints, Managed Identities, MFA, and Conditional Access, delivering RTO <15 min / RPO <5 min. Implemented CI/CD pipelines with Template Specs, Terraform, and Azure DevOps to support seamless multi-environment (DEV/REC/PROD) deployments. Provided technical leadership and coaching to a team of 8 engineers and architects, aligning technical execution with C-level business objectives. Results: ✔ Delivered a secure, compliant, and governed Lakehouse platform validated in HLD/LLD. ✔ Achieved +65% performance improvement across batch and streaming workloads. ✔ Enabled real-time ML deployment, powering advanced analytics in Power BI & Microsoft Fabric. ✔ Established a sustainable CI/CD & MLOps operating model with end-to-end automation and monitoring. Tech Stack: Azure Data Factory, Azure Databricks, Microsoft Fabric, Synapse Analytics, Unity Catalog, Power BI, ADLS Gen2, Event Grid, Key Vault.

At BPCE Groupe, I served as Tech Lead for Data Transformation, Machine Learning, and AI Automation, delivering predictive analytics, workflow automation, and enhanced business intelligence. I led the development of automated extraction and transformation workflows using Alteryx, SSIS, and PowerShell, integrating structured data from SharePoint, Business Central, NetSuite, and flat files into SQL Server. Leveraging Azure Analysis Services (AAS), I designed and deployed tabular cubes integrated with SQL Server to support advanced analytics and ML-driven forecasting. I built predictive models in Alteryx and Python for financial risk, ESG reporting, fraud detection, and energy efficiency, embedding results directly into Power BI dashboards to enable real-time decision-making. I also optimized SQL Server by refining Stored Procedures, Functions, Triggers, and Constraints, ensuring performance, scalability, and accuracy. To reduce manual processes, I implemented custom PowerShell automation for API and SharePoint data extraction, ensuring reliable integration with Azure. A strong focus was placed on ETL optimization, anomaly detection, time-series forecasting, and clustering models, delivering an AI-powered, scalable analytics environment. I also helped define governance standards and quality checks across data pipelines, reinforcing compliance and trust in analytics. Key Achievements ✔ Automated complex workflows, reducing manual effort and operational risk. ✔ Delivered scalable ML models, enabling predictive insights across finance, risk, and ESG. ✔ Enhanced business intelligence by integrating AI-driven analytics into Power BI. ✔ Improved SQL Server ETL performance, ensuring efficiency and scalability. ✔ Strengthened BPCE’s ability to make data-driven decisions, with automation and AI innovation. Tech Stack: Alteryx · SSIS · Power BI · Azure Analysis Services · SQL Server · PowerShell · Python (ML)

At BNP Paribas, I acted as Cloud & Security Architect, leading the Azure Hybrid Data Solution Architecture program to deliver a secure, scalable, and high-performance data platform. I designed and implemented a multi-hop Lakehouse (Bronze → Silver → Gold) on Azure Databricks with Delta Lake, integrated with Synapse Analytics and Power BI. This enabled real-time analytics, CI/CD automation, and on-prem ↔ cloud interoperability, aligned with enterprise governance and compliance standards. I built CI/CD pipelines for Databricks, Synapse SQL, and Power BI using Azure DevOps (Repos & Pipelines), embedding automated testing, quality checks, and controlled deployments. I also automated workflows with Databricks Jobs and Synapse Pipelines, ensuring reliable operations across environments. Security was a cornerstone: I enforced a Zero Trust model with RBAC, MFA, PIM, RLS, CLS, and encryption. I conducted cyberattack simulations (SQL Injection, Brute Force, DDoS), applying mitigations through Azure Sentinel, Defender for Cloud, and DDoS Protection. Secrets were centralized in Azure Key Vault and HashiCorp Vault, with automated credential rotation to strengthen compliance. On the analytics side, I enabled real-time insights with Synapse Link, Delta Tables, and Power BI DirectQuery, while boosting performance with Photon Engine, Auto-Scaling, Z-Ordering, and Bloom Filters. I optimized networking with VNets, ExpressRoute, VPN Gateway, NSGs, and Power BI Gateways. Key Achievements ✔ 40% faster Power BI queries via DAX and Synapse optimization ✔ 50% cost savings through Serverless SQL and caching strategies ✔ 65% faster queries and 60% faster ETL with Photon, DLT, and CDC ✔ 95% threat mitigation with Zero Trust and SIEM monitoring ✔ Architecture validated by Microsoft engineers for compliance and best practices Tech Stack: Azure Databricks · Delta Lake · Synapse Analytics · Power BI · Azure Key Vault · Terraform · Azure Repos · Azure DevOps · CI/CD · Security

At Albingia, I led the strategic migration from SQL Server 2008 to SQL Server 2019, modernizing database systems to significantly improve security, efficiency, and scalability. This project was critical for enhancing data integration, ETL performance, and reporting capabilities across the organization. I orchestrated the upgrade with minimal downtime, preserving business continuity and ensuring seamless adoption of SQL Server 2019. I optimized SSIS ETL processes, improving speed and reliability of data workflows, and introduced advanced methods for data consolidation, ensuring accuracy and quality across operational and analytical layers. To strengthen analytics, I leveraged SSRS and Power BI to deliver interactive reporting solutions that transformed complex datasets into actionable insights for business and risk management teams. I also developed and tuned T-SQL stored procedures to improve query performance and data retrieval, contributing to faster reporting and stronger decision support. Beyond delivery, I empowered teams by conducting SQL Server 2019 workshops, ensuring successful adoption of new features and reinforcing internal expertise. I also enforced strict security and compliance standards, guaranteeing regulatory alignment and data protection at all levels of the upgraded platform. Key Achievements ✔ Seamlessly migrated to SQL Server 2019 with minimal disruption ✔ Optimized SSIS workflows, increasing ETL efficiency and reliability ✔ Designed advanced SSRS & Power BI reports, enabling data-driven insights ✔ Strengthened compliance by enforcing enterprise-grade security standards ✔ Enhanced team capabilities through targeted SQL Server 2019 training Tech Stack: SQL Server 2019 · SSIS · SSRS · Power BI · T-SQL · Windows Server · Data Warehousing · Security & Compliance

At Orange, I enhanced the MSBI & Power BI Data Solution Architecture, delivering major improvements in data processing, analytics, and reporting across the enterprise. My role focused on optimizing SSIS ETL packages, developing SSAS multidimensional and tabular cubes, and creating interactive reporting solutions that empowered stakeholders with timely, actionable insights. I redesigned SSIS workflows, boosting efficiency and reliability, and engineered advanced SSAS cubes to support statistical and multidimensional analysis. I also developed SSRS and Power BI dashboards, improving usability and providing executives with clear visibility into business performance. To enrich analytics, I consolidated diverse sources including Hadoop, Teradata, and flat files, creating a more comprehensive data environment. I applied performance optimization techniques—query tuning, indexing strategies, and cube processing refinements—achieving faster data retrieval and reporting efficiency. Key Projects Customer Experience Management: Automated SSAS cubes and built SSIS pipelines, improving accuracy, timeliness, and consistency of reporting. Data Store Optimization: Enhanced scalability and reliability by refining SSIS packages and developing HQL-based data store processes. This role was pivotal in strengthening Orange’s data-driven decision-making framework, enabling faster insights, improved governance, and sustainable efficiency across business units. Key Achievements ✔ Increased ETL reliability and reduced processing times with optimized SSIS workflows ✔ Delivered advanced SSAS cubes for multidimensional and tabular analysis ✔ Built user-friendly SSRS and Power BI reports that guided strategic decisions ✔ Unified Hadoop, Teradata, and flat files into a richer analytical framework ✔ Accelerated reporting with query tuning and indexing improvements Tech Stack: SQL Server · SSIS · SSAS · SSRS · Power BI · Hadoop · Teradata · HQL · T-SQL · Data Warehousing

At LCL Banque et Assurance, I served as a Senior MSBI Consultant, leading the design and implementation of a decision-making solution for risk management (IRPAR & IRPRO). My role focused on delivering advanced analytics through SSAS cube development, SSRS reporting, and data warehouse design, enabling the bank to strengthen its risk assessment framework and improve strategic oversight. I engineered a risk management platform by integrating Excel with SSRS and SSAS, giving business teams a robust environment for statistical analysis and decision support. I developed and deployed SSAS tabular cubes, significantly improving data accessibility and usability for risk managers. To ensure timely reporting, I built interactive dashboards in Excel and SSRS, providing stakeholders with clear visibility into key metrics. As part of the CESAR Project, I applied performance tuning techniques to improve reporting efficiency and data handling, ensuring system responsiveness at scale. I also managed the development of Operational Data Stores (ODS), Data Warehousing (DWH), and Data Transformation Models (DTM), aligning architecture and integration with the bank’s broader data strategy. Key Achievements ✔ Delivered a risk management solution supporting IRPAR and IRPRO ✔ Enhanced statistical analysis with advanced SSAS tabular cubes ✔ Built dynamic Excel and SSRS reports, accelerating decision-making ✔ Improved data handling in the CESAR project with advanced tuning ✔ Streamlined ODS, DWH, and DTM processes in line with governance standards This role was instrumental in elevating LCL’s risk management capabilities, modernizing its data architecture, and building a stronger foundation for data-driven decision-making. Tech Stack: SQL Server · SSAS (Tabular) · SSRS · Excel · T-SQL · ODS · DWH · DTM · Data Modeling · Performance Tuning

At Bureau Veritas, I worked as a Senior MSBI Consultant, leading a major SAS to SSIS migration project that modernized the company’s data infrastructure and ensured seamless data consistency. This initiative also involved developing Operational Data Stores (ODS), Data Warehousing (DWH), and Data Transformation Models (DTM), providing a stronger foundation for advanced analytics and reporting. I orchestrated the complex migration from SAS Integration Studio to SSIS 2014, guaranteeing reliable data integration and high data integrity standards. To enhance analytical performance, I designed and implemented star schema data models, significantly improving warehouse efficiency and enabling more effective reporting. I focused on creating and optimizing SSIS packages to improve speed and reliability of ETL processes, ensuring smoother operations and faster data delivery. I also developed and fine-tuned T-SQL stored procedures, boosting query performance and accelerating reporting capabilities. To improve business adoption, I designed dynamic dashboards in Tableau 9.4, making data visualization more intuitive and helping stakeholders make informed strategic decisions. Key Achievements ✔ Directed the SAS → SSIS migration with flawless data consistency ✔ Improved warehouse performance with advanced star schema modeling ✔ Optimized ETL workflows, increasing data reliability and efficiency ✔ Accelerated SQL Server query performance through optimized T-SQL ✔ Delivered interactive Tableau dashboards, simplifying complex analytics This role was pivotal in modernizing Bureau Veritas’ data ecosystem, significantly increasing processing efficiency, and laying the groundwork for scalable analytics and data-driven decision-making. Tech Stack: SQL Server 2014 · SSIS · SSRS · SSAS · T-SQL · Tableau 9.4 · SAS Integration Studio · Star Schema Modeling · Data Warehousing

At Allianz, I worked as an MSBI Consultant, where I played a key role in the redevelopment of business indicators to improve the monitoring and management of insurance activities. My mission focused on designing a decision-support module dedicated to activity tracking, supported by optimized ETL processes and advanced reporting. I reengineered critical performance indicators, improving reliability and relevance for business stakeholders. I designed and delivered a comprehensive decision-making module, which provided managers with clearer insights into activity performance and supported faster, more informed decisions. To ensure robust data pipelines, I implemented SSIS workflows for seamless and accurate integration, consolidating data from multiple sources. I optimized ETL processes by refining SSIS packages, which boosted processing speed, improved reliability, and enhanced system efficiency. On the development side, I created and tuned T-SQL stored procedures and queries, significantly improving data retrieval and enabling more precise analytics. Key Achievements ✔ Redesigned insurance activity indicators to improve monitoring and reporting ✔ Delivered a robust decision-support module that enhanced activity tracking ✔ Built and optimized SSIS pipelines, improving ETL speed and reliability ✔ Developed and tuned T-SQL queries for stronger data processing performance ✔ Contributed to a more efficient, analytics-driven framework for decision-making This role was instrumental in strengthening Allianz’s insurance monitoring systems, enabling improved efficiency, stronger governance, and data-driven decision-making across business operations. Tech Stack: SQL Server · SSIS · SSRS · T-SQL · Data Warehousing · ETL Optimization · Decision-Support Systems