Fayssal Hammouch

📊 Corporate Financial Reporting: creation and maintenance of Power BI datasets and dashboards (P&L, R&D, Industry), automation of updates and migration of on-premise databases to GCP / Microsoft Fabric.

🔗 SAP S/4HANA Analytics: consolidation and valorization of data from OTC, P2P, and RTR processes for Finance & Operations departments.

🤖 AI Contribution: participation in the development of a Chat-to-SQL model enabling business users to query databases in natural language. Work on data structuring, knowledge graph generation, and training set optimization.

⚙️ Automation & Governance: implementation of ELT/ETL flows, data standardization, technical documentation, and quality monitoring.

👥 Business Support: collaboration with the Executive Committee and Finance/Procurement/ISD teams to define KPIs, accelerate decision-making, and improve steering.

🌍 International Consolidation: harmonization of multi-subsidiary data and integration into a consolidated group vision.

Results achieved: massive adoption of interactive reports, better visibility on financial cycles (O2C, P2P, R2R), reduction in reporting times, and launch of an experimental AI module paving the way for conversational analytics for business users.

Member of the Data Analytics team responsible for data steering, with a transversal role between BI and Data Engineering.

📊 HR & Sales Reporting: design of Power BI / SSRS dashboards for fleet and HR monitoring, automation of sending reports to managers.

⚙️ Pipelines & Integration: data ingestion and processing via Azure Data Factory, SSAS modeling, security, and scheduling of automated deliveries.

🔗 Migration: support for the transition of SAP Business Objects flows to SQL Server & Power BI.

🤖 AI Contribution: preparation and cleaning of datasets for predictive use cases (vehicle maintenance, fleet optimization), and automation based on decision trees.

👥 Business Collaboration: gathering requirements from HR & Sales departments, translating them into BI solutions, writing documentation, and user training.

Within the IT department, Data Analytics team, I contributed to the modernization of the Data platform and the industrialization of BI & AI uses for Finance, Marketing, and Customer Relations.

☁️ Azure Data Platform: design of a Data Lakehouse architecture (Bronze / Silver / Gold rule) on Azure Synapse Analytics, integration via Azure Data Factory and Databricks.

🔗 Cloud Migration: redesign of on-premise SQL Server & SSAS solutions to Azure Cloud, optimization of ELT/ETL pipelines, and implementation of data governance.

📊 Reporting & BI: creation of Power BI dashboards for Finance (P&L reporting) and Marketing (campaign monitoring, customer KPIs), automation of refreshes and multi-entity distribution.

🤖 AI Contribution: structuring and making data available for ML use cases (customer churn prediction, relationship monitoring), participation in RPA projects.

👥 Business Collaboration: gathering requirements from Finance, Marketing & Customer Relations departments, writing specifications, and user support.