Hamza Chraibi

• Supervision of a BI team (coordination, mentoring, skill development). • Participation in defining the overall BI architecture and structuring data models. • Optimization of advanced SQL queries to facilitate data integration into Power BI. • Creation of high-value-added BI applications (Finance, Sales, Stocks, Purchases, Production). • Budget planning of BI projects and monitoring in coordination with project management. • Design of complex data models at the corporate group level. • Development of advanced visualizations and dashboards (Charticulator, advanced DAX). • Implementation of access security through dynamic roles and quality control of deliverables. • Support for change management: DAX training, documentation, user workshops.

• Design of intuitive and user-friendly dashboards (UX/UI) • Restructuring of a complex data model (merging 5 fact tables into one) • Reduced report execution time from 2 minutes 30 seconds to less than one second • Audit of existing reports to ensure the reliability of data used by buyers • Training users in Power BI (Desktop & Service) and DAX language

• Design of reports for delivery tracking and monthly financial closing • Enrichment of Data Warehouse with fact and dimension tables • Data auditing to correct production anomalies • Automation of financial reporting using Power BI and Excel

• Development of advanced Power BI reports connected to Sage 100c and Sage X3 ERP systems. • Modeling of data from Sage, creation of fact and dimension tables. • Implementation of financial dashboards with advanced DAX. • Improvement of data reliability through auditing of flows between Sage and Power BI.- Identify development needs • Preparing reports based on Analysis and presenting to management

• Monthly production of Accounting and Analytical closures - By Activity - (D+5) • Monitoring of budgets, achievements and presentation of Forecasts scenarios • Implementation of reporting by department (Power BI) • Control and monitoring of OPEX and CAPEX by Business Unit • Inventory, Inventory Control and Valuation (D+2) • Monthly review of pricing policy • Monitoring, Cost Control and Variance Analysis • Waste management, monitoring and optimization

• Conducting financial statement audits for private companies. • Testing of internal controls to ensure the proper functioning of procedures. • Communicating audit issues with the team, management and line managers within Crowe. • Accounting and tax assistance.

• Management, Monitoring and Reporting of the progress of the different projects • Analysis and Explanation of Variances (Result vs. Budget per Project) • Design and implementation of dashboards and KPIs per project • Production of the PnL and the different Reportings (Ms Power BI, Excel) • Contribute to the evolutionary maintenance of information sources