Fouad Rekkab

• Assisted in the design of Medallion architecture (ADLS Gen2), mainly the redesign of the company's former Financial Cube.
• Supported migration of financial reports of companies recently acquired by Telecon.
• Developed BI model for work vehicle geolocation system ‘FleetComplète’. Defined KPIs (Idle time,fuel consumption, GSE/GHG,...).
• Developed many new analytical reports for Design/Infra/Connectivity/Turnkey divisions.
• Supported migration of all legacy SSIS to Azure Data Warehouse or Azure Data Lakehouse databases using ADLS Gen2/Synapse pipelines
• Collaborated with cross-functional teams (Business analysts & End User) to refine data collection methods and improve Report Design Document RDD.

• Responsible for implementing the RTL data warehouse (75% completed) - Kimball approach :

- Planning: over 80%. In production: ridership, punctuality, travel time, estimated ridership
- Operations: over 60%. In production: service delivery rate, driver performance
- Human Resources: over 30%. In production: absenteeism rate / absenteeism cost
- Over 60%: Shared taxi and paratransit
- Other: Environment (RTL energy consumption and pollution control).

• Developed Corporate reports for the management committee (80% completed)
• Analyzed complex data sets to identify trends and support passenger traffic decision-making processes.
• Trained and assisted users in Power BI workshops in creating their reports according to their needs. Created Power BI templates to facilitate data modeling for users.

• Consultant as a BI analyst/developer for clients (Port de MTL, Hydro, Telecon, RTL, …)
• Developed and implemented data visualization solutions using Power BI after analyzing customer needs.
• coded VBA/Excel applications for specific customer needs.
• Led training sessions for stakeholders on BI tools, enhancing user proficiency and maximizing tool adoption rates.

• Collection of needs (for a licensed insolvency trustees office) and functional analysis.
• Automation of the workflow, customize Excel and create solutions for document management of customer files implemented around the company's FTP site.

• Ensures the integrity of SAP Master Data by implementing and maintaining tools and processes for collecting, mapping and validating data (item/supplier data) for automatic integration into tables linked to SAP MM and SD modules.
• Design of a Sales Profit Visualization tool "Profit Template" for the analysis and simulation of profitability margins, retail and wholesale, based on sales of the last 52 weeks as well as promotional themes, which allows to analyze sales (margins, cost and net prices, promotional prices, etc.) at the highest level of synthesis down to the details of an item's performance over time and through its prices and promotions. Designed with Bex Query Designer/Bex Analyser/VBA Excel.
• Self-motivated, with a strong sense of personal responsibility.
• Worked effectively in fast-paced environments.
• Skilled at working independently and collaboratively in a team environment.
• Proven ability to learn quickly and adapt to new situations.
•