Houssam RAOUI

– Overview: Migration from MSTR to PBI and data consolidation of ERP systems (SAP, Exact, QAD). – Advanced SQL development on raw SAP tables (FI/CO, SD, MM, PP), optimizing complex queries for accurate and high-performance data extraction. – End-to-end data validation and reconciliation between SAP source systems and BI reporting layers to guarantee accuracy, consistency, and auditability. – Facilitation of cross-functional workshops with Finance, Supply Chain, Commercial, and Operations stakeholders to translate business requirements into actionable data models. – Define, standardize, and harmonize KPIs across business units, incorporating data mapping to ensure consistent and aligned performance measurement. – Comprehensive documentation of business rules, transformation logic, and calculation methodologies to ensure transparency and maintainability. – Analysis and reverse engineering of Talend ETL jobs to understand existing data flows, transformation logic, dependencies, and business rules for redesign and migration purposes. – Migration of complex reports from MSTR to Power BI while ensuring data integrity and accuracy. – Design and implement automated ETL dataflows to extract and transform marketing benchmark data from Open Data APIs, ensuring data quality and secure API handling. – Implementation of Row-Level Security (RLS) and user access management for secure data access. – Development of a structured training program for end-users and power users. – Develop and maintain Azure Synapse ETL pipelines to orchestrate data ingestion, transformation, and integration across multiple sources.

– Overview: Self Service BI program. – Setup of the Power BI on Premise Architecture. – Establishment of the Power BI Self-service governance. – Automation of the role access process.

– Overview: Restructuring of Tableau® Server dashboards; development of executive dashboards – Implementation of automated data collection from Jira via REST APIs (issues, status history, SLA, assignees, priorities, queues) to centralize operational KPIs. – Optimization of the extractions task (Tableau®). – Functional organization of the reporting system. – Automation of the reporting broadcast (Tableau®, PowerPoint). – Enhancement of DataMart model for Tableau® Advanced User (Web portal edit mode). – Realization of dashboards to monitor the Billing, consumption, top et flop. – Achievements of Churns' predictive model on a scoring system. – Automate Tableau® Server backup strategies. – Automation of cleaning of unused reports. – Accompaniment in the automation of data quality verification tests in the BSS transformation project – Advanced user training: Web Portal edit mode, creation of visuals, parameters and calculated fields. – Support of the IT team on installation and upgrade operations for the Tableau® solution.

– Overview: POC migration from Power Bi Server to Power Bi Services – Presenting the differences between Power Bi Server and Power Bi Services. – Presenting the differences between Import Data and Direct Query. – Installing and configuring Data Gateway. – Experimenting the new development methodology. – Power Bi Services functionalities. – Use-Case: Migration of different types of report from multiples data sources types. – Customization of the audit logs (Report access by user by dates).

– Overview: Wholesale International Information – Responsible of technical upgrade from SQL SERVER 2008 to 2014. – (Upgrade of SSIS, SSRS, SSAS and Database) – Coordination between Development teams, functional team and project management. – Responsible of Deliveries and Releases. – Impact study for production deliveries. – Sizing of the servers in different environment Dev, SIT, UAT, OAT and PROD. – Database optimization. – Technical architecture Design.

– Animation of the workshops to specify the needs of the client. – Implementation of the technical architecture of the evolutions. – Analysis of the impact of developments on integration flows, SSRS reports and the SSAS cube. – Coordination between the Paris and Morocco team on technical aspects. – Coordination with the various stakeholders on the project (Web Team, SharePoint Team). – Technical referent for the launching of new developments. – Realization of the evolutions and technical remodeling of the different systems. – Resolution of production incidents. – Assessment of load / delays (needs, resources), quantification of developments. – Management of the DWH team. – Code Review. – SharePoint User Administration and Support (Powerview / Powerpivot, SSRS).

– Workflow and Process development. – Establishment of functional specifications and parameterization. – Establishment of test plans and balance sheets. – Impact study on versioning of applications. – Realization of the dashboards, weekly and monthly reports for the management of the operational teams on the Workflow, under SSAS, SSIS (ETL). – Design and production of InfoPath forms.

– Analysis of existing data (job specifications, job descriptions, evaluation of functions, organizational flow chart...) – Interviews with individuals involved. – Analysis of data and information received. – Production of a summary report. – Presentation of solutions to improve organization and functioning.