Freelancer profile translated to English.

Description

ASBAI Samir, Freelance SAP BI technical-functional, I have worked on the integration of decision-making systems for various clients:

• Supporting clients in the scoping phase.

• Analysis of functional and technical needs.

• Facilitating design workshops.

• Development of functional and technical specifications.

• Solution modeling (Data Warehouse and Reporting platform).

• Design and implementation of the Data Warehouse and ETL flows.

• Design and implementation of reports, dashboards, and data exploration interfaces.

• Analyze and optimize queries running on BW on HANA / 4Hana.

• HANA database management, user management (DBCO, DBMS), security, and performance tuning.

• Development and implementation of analytical privileges in HANA Cloud.

• Development of reports on SAC.

• Configuration of rights and authorizations in BW and BO.

• User training.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

EQUANS
SAP BI Consultant
May 2025 - Today (1 year and 1 month)
The project mainly consists of integrating Bouygues data with Equans HR data in BW (INEO, AXIMA etc).
- Functional understanding of business needs (Workshops + analysis of Bouygues reports and dashboards)
- Development of BW HR flows for the BY part (headcount, joiners/leavers, and payroll).
- Integration of BY data with all Equans HR data for projection on Power BI dashboards.
- Automation of monthly BY data loads.
- Business acceptance testing and go-live.
SAP Source Systems Modules: SAP HR, CSV files.
Reporting: AFO, PowerBI.
CAPGEMINI
SAP BI Consultant
March 2024 - April 2025 (1 year and 1 month)
The One Finance project consists of SAC reports for financial data (P&L and commitments).
• Development of extraction flows from S4Hana (flowgraphs + delta procedures); mainly ACDOCA data, HR tables (PA*), and master data.
• Replication of raw data storage tables from (EXTRACT) to (EXPOSURE) for transformed and exposed data to SAC via synonyms.
• Development of different types of objects used in HANA Cloud: tables, procedures, calculation views, triggers, roles, analytical privileges..
• Implementation of data security (use of analytical privileges).
• Implementation of Workload classes for prioritizing HANA procedures used in SAC.
• Use of Github for transport and synchronization of development (DEV), unit testing (SIT), and business testing (UAT) environments.
• Optimization of calculation views.
• Development of reports on SAC.

SAP Source Systems Modules: SAP FI.
Reporting: SAC.
Enedis - Hanais Cœur pour les fonctions centrales
SAP BI Consultant
January 2023 - March 2024 (1 year and 2 months)
• Preparation of both Support / Project lines and use of retrofit to merge developments from different systems.
• Adaptation of BW design to the new immo v2 modeling.
• Development of BW4HANA flows for central functions from Hanais core and Hanais IMMO v2 data.
• Implementation of reports concerning different modules: core FI, FI immo v2, reconciliation of the two systems.
• Migration of financial CRAC (webdynpro, BPC embedded, FIORI).
• Redesign of authorizations: homogenize the design of different parts (Hanais immo v1, AEPR migration, and Hanais core).
• Virtual modeling in HANA:
◦ Materialization of HANA views, cardinality, input parameters, SQL scripts, stored procedures, Data pruning.
◦ Improvement of SAP HANA performance (performance traces, PlanviZ).
• HANA Administration:
◦ Management of BW4HANA users in HANA (DBCO, DBMS, and HANA privileges).
◦ Management of privileges and authorizations for BW objects in HANA (Authorizations for objects generated in HANA from BW).
◦ Monitoring of storage optimizations (Memory spaces occupied in HANA).
◦ Partitioning of tables (ADSO tables in HANA).
◦ Scheduling of housekeeping tasks.
◦ Optimization of Bex query executions in HANA (PlanViz…).