Sana Saffar

Mission:

Analyze data and create reports to support production operations within EDF. Key Skills: Power BI, Data Analysis, Jira, Gitlab, Confluence.

Key Achievements:

Power BI:

Developed interactive dashboards for monitoring operational KPIs, enabling teams to visualize real-time production data and optimize decision-making processes.

• Gathered and analyzed requirements (Wrote functional and technical specifications)

• Organized and led meetings with various business teams

• Estimated tasks and costed projects

• Planned and updated report delivery (Power BI Report Server, Power BI Report Builder)

• Implemented Row-Level Security (RLS)

• Trained users on Power BI

• Deployed reports on Power BI Report Server.

• Tested and validated data models

• Managed incidents via ServiceNow

Supervised local development teams

• Migrated Hive SQL views to PostgreSQL

• Maintained and monitored the RUN part

• Deployed views on DBT

Technical Environment:

Power BI, Jira, SQL, DAX, Hive, Airflow, Dbeaver, OpenMetadata, DBT, Gitlab, Superset, Confluence, ServiceNow

SUEZ FLO: Implemented a Power BI application to track intervention files for Suez Eau France.

• Analyzed data from web forms

• Direct liaison with the business

• Managed significant data flows and large volumes

• Modeled the data warehouse (star schema design)

• Populated the DWH using Azure Data Factory

• Wrote documentation (DAT, DIN, DEX)

• Created the Power BI application in DirectQuery mode (KPIs, Forecasts…)

• Managed access to the Power BI application

• Trained users

Technical Environment: Azure Data Factory, Power BI, Azure SQL Server

SUEZ ELT/ON PREMISE: Set up a DWH and dashboards to monitor smart meter consumption, customer meter anomalies, CMMS, and On Connect (Receiver and Sender).

• Wrote documentation (DAT, DIN, DEX)

• Analyzed source files via FTP

• Populated the OLAP multidimensional cube

• Populated the DWH using the Data Vault approach.

• Monitored, maintained, and tracked production

• Migrated servers

• Created Power BI dashboards in Import mode (gateway)

• Managed access to Power BI dashboards

Technical Environment: SSIS, SSMS, SSAS, OLAP CUBE, Power BI

POC – Proof of Concept for smart meter consumption cube on Azure

Migrated the smart meter consumption cube from On-premise to Azure Cloud (SSIS -> Azure Data Factory, SQL Server -> Azure SQL Server, SSAS -> AAS, Power BI)

FRENCH REAL ESTATE AGENCY NETWORKS: Implemented an accounting dashboard.

• Analyzed accounting entry files (FEC) provided by the client

• Modeled the data warehouse

• Prepared measures, calculated tables, calculated columns (DAX, Power Query, M language)

• Automated FEC file processing

• Provided a standard for restitution reports (CR, BALANCE SHEET, INCOME STATEMENT, Break-even point…)

• Developed a cash flow forecast (Forecast for the 12 months following the last day of the fiscal year)

• Trained users

Technical Environment: Power BI, DAX, M language, Power