Wajih Outal

•Designed and implemented a Medallion architecture (Bronze, Silver, Gold) within Microsoft Fabric Lakehouse,Warehouse, optimizing data storage, transformation, and governance. • Developed advanced Fabric Notebooks leveraging PySpark to handle Schema Drift, ensuring seamless processing of evolving data structures in a Medallion architecture (Bronze, Silver, Gold). • Designed dynamic Data Pipelines in Microsoft Fabric, implementing Upsert (MERGE) and Updelete (soft/hard delete) strategies for efficient data integration and consistency in Lakehouse / Warehouse. • Integrated real-time Event Stream processing using KQL queries in Fabric Real-Time Analytics, enabling lowlatency data ingestion and transformation. • Designed and deployed Lakehouse Warehouse solutions, providing a centralized, high-performance analytics layer for business insights. • Created datasets and reports for data insights and visualization. • Acted as a technical lead, mentoring team members on Microsoft Fabric best practices, Medallion architecture design, and advanced analytics.

--> Collaborated in client requirement workshops to gather and define project needs. --> Designed and deployed ETL packages (SSIS) for data extraction, transformation, and loading from diverse data sources to various data repositories (Staging / ODS / DWH). --> Developed and maintained stored procedures, functions, and views to support data transformation. --> Constructed multidimensional models, including Dimensions and fact tables, to enhance data analysis. --> Created datasets and reports for data insights and visualization. --> Established a versioning system for reports to ensure data traceability and historical analysis. --> Implemented dynamic language translations in Power BI reports to cater to diverse end-user cultures. --> Took a leadership role as a technical reference within the team, fostering knowledge sharing and skill development. --> Successfully implemented CI/CD processes using Azure Pipelines for streamlined development and deployment. --> Led the transition from SSIS to Azure Data Factory for improved data integration and processing capabilities. --> Developed efficient data flows using Power Automate to automate tasks and workflows. --> Developed an SSIS workflow to retrieve data from a REST API. --> Used a C# script in a Script Task to send HTTP requests via HttpClient.

--> Acted as a mentor and technical reference in Azure Data and Power BI. --> Led the Microsoft Morocco team, driving skill enhancement and ensuring the delivery of high-quality solutions. --> Guided team members through technical challenges and fostered a culture of continuous learning.

- Designed and deployed ETL / ELT Data Pipelines. - Build data lakes - Collect and prepare data from different sources. - Data Masking of sensitive data - Cleaning data - Processing data - Designed custom Dimensions and Facts Tables - Developed data flows using Power Automate - Created Datasets and reports for improved data analysis.

--> Led the team in delivering data migration and integration projects, ensuring timely and high-quality delivery. --> Acted as a technical reference, providing guidance and support to team members on complex challenges. --> Fostered knowledge-sharing within the team to enhance technical skills and project efficiency. Key Achievements: --> Directed the migration from SQL Server 2012 to 2019, improving data infrastructure scalability and performance. --> Developed and optimized ETL pipelines using SSIS and enhanced legacy data pipelines. --> Automated SSAS cube partitioning and notification processes using PowerShell. --> Guided the transition from MSBI to GCP, converting SSIS packages to Apache Beam jobs and migrating data to BigQuery.

--> Developed multidimensional models (Dimensions and fact tables). --> Created Datasets and reports. --> Designed Role-Level Security (RLS) in Power BI. --> Implemented Report Versioning. --> Served as a technical reference within the team.

--> Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources into Azure Synapse. --> Automation: table creation, Metadata change (Schema drift), .... --> RLS development at the Azure Synapse database level (Predicate Function) --> Data Masking of sensitive data on our DWH. --> Using Azure Logic Apps to set up data streams, Refreshing PBI Reports, and Reporting BKP. --> Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, to support business applications in Azure Synapse. --> Develop a PowerShell script that allows you to back up all reports by Workspace and also datasets separately to ADLS / SharePoint. --> Used Azure Devops to automate Azure deployment of CI/CD process. --> Develop multidimensional models (Dimensions and fact tables). --> Design of a Global Model for all Markets on Power BI --> Creation of Datasets and reports. --> Maintained different levels of Data Security in Power BI Using Row Level Security (RLS) when needed. --> Design of the Versioning of the Reports. --> Represent a technical reference in the team.

--> Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client Team and Development team. --> Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources into Azure Synapse. --> Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored --> Procedures, and Triggers to support business applications in Azure Synapse (DWH). --> Used Azure Devops to automate Azure deployment of CI/CD process --> Merging code to GIT repository to maintain on distributed server --> Building Tabular SSAS Cubes (Tabular SSAS 2016, DAX, MDX) --> Experienced in using Data Analysis Expressions DAX to creating custom calculations in SSAS tabular model. --> Designing and Developing the Dashboard Reports in power BI using DAX.

--> Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client Team and Development team --> Created SSIS Packages to get data from different sources (Flat Files, Tables) consolidated and merged into one single source --> Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored --> --> --> Procedures, and Triggers to support business applications --> Designed custom Dimensions and Facts Tables to extend data warehouse. --> Building Tabular SSAS Cubes (Tabular SSAS 2016, DAX, MDX) --> Take in charge the technical management of the migration --> Experienced in using Data Analysis Expressions DAX to creating custom calculations in SSAS tabular model. --> Develop reports using complex formulas with (DAX /MDX) query to generate different types of ad-hoc reports using SSRS. --> Distribution of SSRS reports with Data driven Subscriptions, both email and Windows file sharing. --> Designing and Developing the Dashboard Reports in power BI using DAX. --> Played an active role during the requirements gathering, analyzing and designing of the business needs. --> Design and development of QlikView dashboards --> Created Pixel Perfect reports, Excel reports and Word Reports using NPrinting tool. --> Expertise in NPrinting Creating Apps, Connections, task, Users, generating reports and publishing. --> Scheduled Data Extractions, Data Model and Dashboard Reloads using Qlik Management Console (QMC). --> Optimize the report distribution process from NPrinting with the Recipient List. --> Used Section access and Sheet access to make the application available to desired users. --> Developed QlikView Dashboards using various Charts with added functionality like Drill Down, Drill up & Cyclic Grouping, Pivot Table, Input Field, Table Box

--> Test the processing time of data loading on ADF. --> Development of a dynamic workflow for data loading on ADF --> Use of Azure Logic Apps to set up data flows. --> Design of Dynamic Storage procedures to apply Data Quality rules on Azure Synapse --> Design of Power BI Reports --> Set up workload management on Azure Synapse. --> Assist end users on all Azure data platform.

Création et réalisation d’un system BI pour le suivie des Agents Commerciaux et la gestion des appels effectués : - Analyser les tables Générés par Genesys et définir les corrélations. - Extraction des données et conception des schémas multidimensionnels et tables de faits. - Création de rapports et tableaux de bord sous Power BI . Environnement: Power BI , SSIS , SSAS , Genesys , DAX , T-SQL , SSMS , SQL Server.