Mellouk Ayoub

Collaboration with business and technical teams to identify needs and propose developments. Development of ETL processes for data extraction, transformation, and loading. Modeling of dimensions and measures to provide intuitive data navigation. Definition of attributes, hierarchies, and granularities. Design of OLAP cubes to meet multidimensional analysis needs. Development of dashboards and automated reporting for performance indicator tracking. Management of access rights and user roles to ensure data security and confidentiality. Writing technical and functional documentation. User training and support.

Development of a Business Intelligence tool dedicated to the financial monitoring of Transilien's digital expenses and budget. Automation of accounting flows with Power BI. Creation of automated flows with Power Automate. Preparation of actual and forecast financial data for the Transilien IT and telecom scope. Analysis of Transilien IT department's digital expenses. Consolidation of data from each central department, ensuring data consistency and quality. Control of intercompany transactions and external charges purchases. Administration of SNCF Transilien management tools (purchasing ERP - MO ERP). Performing management control tasks. Providing and consolidating budget models for all digital activities.

Data extraction, cleaning, transformation, and ingestion (ETL). Data source modeling to prepare for migration to Power BI. Data analysis and indicator development. Implementation of dashboards and reports with Power BI. Dissemination of results with the managers of SNCF FRET plants.