Drifa Zouaoui

•Implementation of a production (PROD) environment mirroring the development (DEV) environment under Microsoft Fabric, including the Bronze, Silver, and Gold Lakehouse architecture.

•Deployment and management of semantic models and associated Power BI reports across different environments, ensuring data consistency and reliability between DEV and PROD.

•Design of a Power BI report for refresh monitoring, allowing tracking of refresh statuses for Lakehouses, environments (DEV/PROD), and Power BI reports.

•Automation of the generation and sending of HR files using Fabric notebooks, ensuring reliability, traceability, and scheduling of processes.

•Development of the HR report: integration and consolidation of data from multiple countries, application of specific rules for each national legislation, and correction of anomalies in the Data Lake.

🔹 Maintain and optimize existing Power BI dashboards related to security.

🔹 Create new reports for monitoring server status, vulnerabilities, and threats.

🔹 Connect and integrate data from multiple sources (e.g., SIEM, vulnerability scanners, Active Directory).

🔹 Develop DAX measures and data models tailored to cybersecurity needs.

🔹 Automate data refreshes and ensure report reliability.

🔹 Collaborate with security teams to define key performance indicators (KPIs) and reporting requirements.

🔹 Ensure data accuracy, visual clarity, and compliance with internal security standards.

🔹 Document report logic, data sources, and transformation processes to ensure traceability during audits.

• Ensure data integration from various sources and implement processes for cleaning and transforming raw data.

• Design and develop custom reports for different group entities.

• Automate report generation and ensure that changes in tools and processes are reflected in the reports.

• Participate in budget analysis and the production of reports containing various KPIs for group CIOs.

• Develop budget monitoring reports, comparing budgets allocated by each partner and CIO with projected budget data contained in the group's centralized management tool for the 2024 and 2025 fiscal years.

• Ensure data quality and provide portfolio managers with specific reports to help them track key indicators.

• Ensure the proper functioning of tools used by the team and actively participate in testing new versions and updates of the tools.

Technical environment: Excel, Power BI, Power Query, SQL Server