Freelancer profile translated to English.

Description

Expert EPM Essbase and confirmed BI Consultant

With over 10 years of experience in EPM (Essbase) and BI environments, I support companies in their strategic projects related to multidimensional analysis, infrastructure migration, and process automation.

Languages

French
Native or bilingual
English
Conversational
Arabic
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Veolia
EPM & Data Consultant
ENVIRONMENTAL
January 2022 - April 2024 (2 years and 4 months)
Saint-Maurice, France
Finance & HR Project – EPM / Data Engineering & Analytics

🔹 SNI Application (Essbase / Hyperion Planning – Unpaid Dues Tracking)
Maintenance and evolution of an analytical Essbase cube for monthly tracking of unpaid dues, credit notes, non-recoverable amounts, RNI, recovery fees, and collection speed.
Quarterly calculation of provisions and automatic integration into SAP AGORA.
Optimization of closing workflows via Shell/SQL and One-Automation.
Automation of exports/imports of artifacts and data for testing environments.
Monitoring of data quality and validation of consistency checks with source systems.
Participation in technical and functional audits (KPMG, EY).
Evolution of provision calculation rules in conjunction with the accounting department.
Development of an analytical model for tracking unpaid dues by contract.
Administration of user rights and roles in Essbase.

🔹 HR Reporting – Business Objects (META4 & CHRONOGESTOR - IGT)
Management of authorizations and access rights (profiles, roles).
Optimization and industrialization of HR reports.
Monitoring of monthly flows between META4 and BO, proactive incident resolution.

🔹 Data Engineering – CDD Warehouse & One-Automation
Supervision of data flows between the CDD warehouse and 15 business applications.
Optimization of pipelines to improve data performance and availability.
Processing of production incidents and implementation of quality controls.

🔹 APPRO EPGL Project – Cloud Migration & Security
Migration to AWS (public network), configuration of access and hardening of WEB-RDS connections.
Implementation of a WAF and securing exchanges via certificates and security groups.
SSO integration with Keycloak in an ASP.NET application.
Performance tests, documentation (DAT, switchover plan), and team support.
STIME
BI Consultant Essbase / Hyperion Planning / Shell
January 2020 - January 2022 (2 years)
Ile-of-France, France
Budget Planning Project – Hyperion Planning / Essbase:

- Development and maintenance of feeding flows via FDMEE, with mapping of source files, management of loading rules, and automation of integrations to Planning cubes.
- Implementation and optimization of Business Rules, Calc Scripts, and Data Forms, adapted to business user needs.
- Supervision of batch processes via Automic, management of dependencies, and automatic retries in case of failure.
Monitoring of Essbase cube performance (BSO/ASO), restructuring, index optimization, and metadata management.
- Level 2/3 technical support: analysis of loading anomalies, session blocks, consolidation errors, and corrections in logs.
client Carrefour
Essbase / Shell / BI Consultant
January 2018 - January 2020 (2 years)
Ile-of-France, France
CG Project: decision-making application for steering and performance monitoring in the Management and Finance domain for Carrefour Gestion.

Mission
Carrefour Gestion & CABB (Essbase) MEVO & RUN: Evolution and Operational Maintenance
• Analysis of the specifications and functional specifications
• Design and development of technical specifications
• Development and execution of SH / PLSQL / MAXL / MDX processing scripts
• Multidimensional modeling of data warehouse and datamart.
• Evolution of DLR for loading dimension and data repository
• Evolution of MDX calculation scripts for consolidation and aggregation
• Evolution of automation scripts and Microsoft VBA reports and calculation formulas
• Correction and evolution of PLSQL procedures and functions
• Optimization of PL/SQL queries in ETL and REPORTING
• Analysis of problems and proposal of workarounds.
• Development of preventive/corrective measures for any detected anomalies.
• Participation in monthly on-call duties to ensure service continuity.
• Management of user connection incidents (security groups/filters)
• Manage performance issues – (Oracle index, RAM, and UNIX PROCESSES)
Technical Environment Hyperion Essbase V11, Oracle 12g, Red Hat Enterprise 7.2 (SQL*Loader - PL/SQL), GIT-SVN, UNIX SHELL, Smart view, Microsoft VBA, Jira and Confluence, Windows Server 2016