Hamza ALBOUZIDI

OGF Project Manager / Tech Lead Project: Implementation of dashboards on .NET APP using POWER BI EMBEDDED. Technical Environment: SQL Server Data Tools - Azure SQL DB - Power BI EMBEDDED, APIs (Data Sources), Azure SQL DB, Git OECD Project Manager / Tech Lead Project: Implementation of a Modern Data Platform on Azure for monitoring statistics on the use of OECD documentation published on the various Web channels (Usage Stat). Technical Environment: Azure Data Factory V2 - SQL Server Data Tools (SSIS) - Azure Analysis Services - Azure SQL DB - Power BI, APIs (Data Sources), Azure SQL DB, Git Project: Implementation of Embedded reporting in Dynamics 365 - Collection of needs, drafting of technical specifications and costing of the project. - List and prioritize the actions to be done. - Progress monitoring of tasks. - Project follow-up with the client (weekly meeting) - Connection to Microsoft Dynamics Entities Model via Odata - Connection to the AXDW data model - Design of the report data model. - Design of Power BI dashboards - POWER BI EMBEDDED Technical environment: Microsoft Dynamics - Power BI Embedded - Azure SQL DB EIFFAGE Project Manager / Tech Lead Project: Establishment of a Data platform for the management of prevention data and accident monitoring for EIFFAGE WorldWide. Technical Environment: Azure Data Factory V2 - SQL Server Data Tools (SSIS) - Azure Analysis Services -Azure SQL DB - Power BI

Context : As part of a reorganization of Market Sales functions, impacts to be managed on the BI Reporting solution composed of an SSAS cube and SSRS reports. Mission: Modification of SSRS reports. Modification of the SSAS cube. Modification of stored procedures intended for automatic generation of reports Technical environment : SQL Server 2008 - SSIS - Visual Studio - Transact-SQL

Context : Overhaul of the Mc Donalds sales database and modifications to the processing for data recovery. Achievements: Framing and Optimization of the sales chain. Optimization of stored procedures. Standardization of SSIS packages. Standardization documentation. Updating SSIS packages Technical environment : SQL Server 2008 - SSIS - Visual Studio - Transact-SQL

MS BI Consultant Context : Implementation of a decision-making solution for the management control of the data necessary for monitoring and analyzing turnover. Achievements: Lot 1 : Scoping and specification of indicators Collection of needs with the MOA on behalf of end users. Writing of functional specifications and translation into technical specifications. Design of multidimensional models under SSAS to allow manipulation of data cubes in a dynamic way Data recovery under SSRS Reception and correction of incidents at Cube and Report level Unit testing, validation testing, and integration testing. Delivery of evolutions in production server. Lot 2: Migration of ETL from Lawson BPW designer to SSIS Modeling of the DataWarehouse under SQL server 2008 and integration of the model multidimensional Extracting data from the M3 database Creation of new cubes under SSAS Creation of reports in SSRS Unit testing, validation testing, and integration testing. Drafting of training documents for the project. Training of end users. Technical environment : SQL Server 2008 - SSIS - SSAS - SSRS - Visual Studio - Transact-SQL