Achraf Ougdal

- Conducted a comprehensive audit of existing Power BI reports to assess data quality, KPI consistency, and alignment with business requirements. - Restructured and cleaned up the Power BI platform and workspaces, proposing a new architecture to improve user experience and enable a more efficient development process. - Designed and developed new interactive dashboards for the Executive Committee and various business departments. - Implemented best practices for performance optimization, version management, and ongoing workspace maintenance.

- Ensured the migration and reliability of data between legacy systems and the Insurance Analytics PASS (RGI) platform, guaranteeing operational continuity and data quality within the new system. - Led the complete redesign, development and deployment of a new Data Warehouse architecture for commercial administration, aligned with new business rules and Saham Group standards.

• Designing decision-making system architectures and improvement of existing systems. • Designing, developing, and optimizing ETL processes. • Deploying, monitoring, and maintaining BI platforms. • Drafting documentation related to the various implemented decision-making systems. • Benchmarking On-Premises and Cloud BI tools. • Auditing existing Power BI platforms with identification of weaknesses in management, collaboration, and security. • Optimizing Power BI data models and reduction of data refresh time by over 50%. • Optimizing DAX measures and reduction of Power BI report rendering time by 60%. • Restructuring of the Power BI platform and implementation of a new architecture to better organize and manage platform components. • Developing Power BI reports to monitor all platform components (Users, Workspaces, Datasets, Dataflows, Semantic Model Refresh, Dataflows Refresh, etc.). • Designed and developed multilingual Power BI reports that automatically adapt to the user’s browser language. • Defined and implemented new standards for developing semantic models and Power BI reports. • Conducted in-depth study to identify the most efficient data integration approach, comparing solutions such as ADF with Synapse, standalone Synapse, or Azure Logic Apps. • Designed and implemented data integration pipelines using Azure Data Factory (ADF), enabling integration from multiple data sources. • Used Azure Data Lake Storage Gen2 and Delta Lake files for optimized and scalable data warehouse storage. • Performed analytical processing and complex calculations with Azure Synapse Analytics, ensuring high performance and scalability tailored to business needs. • Worked closely with business teams for data validation, ensuring data accuracy and compliance with operational requirements. • Clients : Bank Of Africa, CDG, Marjane Holding, TAQA Morocco • Tools : Power BI (Cloud & OnPrem), Azure Data Factory, Azure Synapse Analytics, Azure DevOps, Azure Logic Apps, Talend, SSIS, SSAS

- Conducted workshops with clients to understand and define the scope of the project. - Conducted a comprehensive assessment of existing decision-making systems, utilizing data analysis and root-cause identification to identify inefficiencies and roadblocks; recommended and implemented a new system that improved efficiency and reduced error rate - Design and implementation of decision-making systems to reduce data loading time by 75%. - Creation of decision-making system architectures. - Design of data models for data warehouses and definition of historical strategy based on client needs. - Creation of detailed functional specifications documents and other deliverables. - Structuring, preparation, and delivery of training on data integration using Talend Open Studio for clients. - Design, development, and optimization of ETL workflows and dashboards. - Testing of BI solutions and results with clients through multiple workshops and documentation of results. - Deployment, monitoring, and maintenance of BI solutions. - Benchmarking of BI tools (ETL & Data Viz) to assist clients in choosing the most suitable tool for their needs and budgets • Clients : Attijariwafa Bank, La Marocaine Vie, Managem, Office des Changes, Orange, SNTL • BI Tools : Talend, SSIS, Power BI, Qlik Sense, Qlik NPrinting, SAS Visual Analytics (SAS 9.4)