Oussama A.

Expert Data Analyst,

Expert Data Visualization,

• Liaise with business stakeholders and gather requirements.

• Integration, Extraction, Transformation, Loading, Modeling, Analysis, and Reporting.

Work on Data/BI projects for various entities (CWS/DSIT) from end-to-end:

• Liaise with business stakeholders and gather requirements.

• Integration, Extraction, Transformation, Loading, Modeling, Analysis, and Reporting.

• Automate data source feeding from Microsoft Azure cloud via (Power Automate Flows) and (PowerShell Scripts) using Microsoft Graph API.

• Load data in ETL (Power Query, M Script) by automating data error handling (types, formats…).

• Data modeling for decision-making (Snowflake Schema, Data Warehouse), and data volume optimization (hundreds of millions of rows per table).

• Create charts and visuals to display various metrics and KPIs created with (DAX).

• Create filters, parameters, and fields (measures, calculated columns and tables, Time Intelligence), data hierarchies.

• Analyze query performance on Power BI.

• Secure data access (RLS) static and dynamic, access by entity, group mailbox, and individual.

• Power BI Service Management: Workspace management, reporting sharing and access, dataset refresh automation, data access (Row Level Security).

Technical Environment:

Tools: Power BI, Power Query (M), Power Pivot (DAX), Power View, Python, (Flow) Power Automate, DAX Studio, Tabular Editor, AAS, Data Factory, Synapse, SharePoint Online, Power Platform, PowerShell Script, Figma, VS Code, Jira, Azure Cloud, Microsoft 365, Power Platform, Graph API.

Method: Agile

Provide the Directorate of Customer Experience and Organization (La DECO) of Cofidis with a steering tool based on a decision-making system for monitoring the directorate's activity:

• Build a Data Repository composed of raw elementary data from system actors and complex data for analytical purposes.

• Identify and collect Master and Reference Data.

• Relational and decision-making modeling of the database (Snowflake Schema), and creation of links between different tables (Primary and Foreign Keys).

• Automate data loading and import, (filter and combine data from multiple sources). (Power Query, M).

• Develop an error management system and create Data Quality controls (Power Query, 'M' script).

• Create calculated tables of data from other tables and functions (Power Pivot, DAX).

• Create Date Tables for historization management (Time Intelligence).

• Hierarchize data at multiple levels for analytical needs.

• Use advanced DAX functions for creating complex measures.

• Develop Reporting for company and group instances with the correct level of information granularity.

• Create complex charts with Python (Matplotlib, Seaborn, Pandas).

• Create visuals using different Power BI models.

• Develop interactive dashboards allowing authorized actors to search for information in the data repository.

• Design and implement data flows (Integration, data migration, history recovery).

• Automate data export via Power Automate (from Power BI to Excel).

• Automate the movement of exported files to a directory for archiving purposes via a PowerShell script.

• Publish and administer reports on Power BI Service (access, workspace management, security).