04/24/2024 updated

**** ******** ****
100 % available

Solutions Architect | EPM Board Expert

Bagneux, France
Worldwide
Computer Science | Finance
Bagneux, France
Worldwide
Computer Science | Finance

Profile attachments

CV - Fethi Zerara

Java (Programming Language)JavaScriptArtificial IntelligenceData AnalysisMicrosoft AzureBig DataC Sharp (Programming Language)Cloud ComputingDatabasesData CleansingData GovernanceData IntegrationData IntegrityExtract Transform Load (ETL)Data ManagementData TransformationData MiningData WarehousingEclipse (Software)ElasticsearchApache HadoopApache HiveIntegrated Development EnvironmentsPython (Programming Language)Unix ShellMicrosoft SQL ServersAzure SQLNoSQLScrum MethodologyRStudioMicrosoft Power BITensorFlowSAP ApplicationsSAS (Software)SQL DatabasesSQL Server Integration ServicesSQL Server Analysis ServicesData StreamingSalesforce TableauTalendIBM Cognos TM1Transact-SQLJupyter NotebookSupervised LearningGoogle CloudApache SparkGitKubernetesCassandraApache KafkaAdaptive InsightsDockerDatabricksProgramming Languages
Adaptive Insights, Hadoop, Hive, Kafka, Spark, Artificial Intelligence, Big Data, C#, Cassandra, Cloud, Analytics, Data Cleansing, Data Governance, Data Integration, data integrity, data management, Data warehouse management, Data Mining, data flow, Data transformation, data warehouse architecture, Data Warehouse, Datawarehouse, Database, databases, Databricks, Docker, Eclipse, Elasticsearch, ETL, data loading, Git, GCP, TM1, Computer Science, DEVELOPMENT ENVIRONMENT, JAVA, JAVA Script, Jupyter notebook, Kubernetes, AZURE, Azure Storage, SQL SERVER, NoSQL, Power BI, PROGRAMMING LANGUAGES, PYTHON, RStudio, SAP, SAS, Azure SQL Server, SQL, SSAS, SSIS, Scrum Master, Supervised Learning, Tableau, Talend, Tensorflow, TRANSACT SQL, SHELL

Experience

Professional experience5 - 10 years
Freelancer since2024

Languages

EnglishFluentFrenchNative speakerSpanishBasic knowledge

Project history

BI & EPM CONSULTANT

AVEA_ LA POSTE
( INDUSTRY : TOURISM)
BI & EPM CONSULTANT

PROJECT : As a senior consultant and product owner, I spearheaded the implementation of
Board (EPM) within the Tourism department, encompassing sales planning, performance
management, and database administration. Taking a holistic approach, I leveraged my
expertise to ensure seamless integration and optimal functionality of the solution. In
addition to simulations and advanced processes, I focused on data integrity and security,
administering the underlying databases to guarantee reliable and efficient data
management. By aligning sales strategies, optimizing performance, and overseeing
database administration, I facilitated informed decision-making and empowered the
Tourism department to drive revenue growth and deliver exceptional customer
experiences.

INTERVENTION SCOPE
* Datawarehouse modeling and design
* Creation and development of a data
transformation pipeline
* Data mining process optimization for
segmentation (Parallelism, Partitioning,
Broadcast)

TECHNICAL ENVIRONMENT
* BOARD
* SQL Server
* SSIS
* TRANSACT SQL
* SHELL
* BATCH

DATA INTEGRATION CONSULTANT

MITSUBISHI
( INDUSTRY : MANUFACTURING)
DATA INTEGRATION CONSULTANT



PROJECT : During my assignment, I undertook the administration of the Data Warehouse
(DWH) on Sql Server, along with data management and data governance responsibilities.
I also played a crucial role in the ETL (Extract-Transform-Load) process, transferring data
from SAP to various solutions through the DWH. To accomplish this, I utilized Theobald
connector for SAP integration and KingswaySoft for Dynamics 365 integration. Through

my efforts, a seamless data flow was established between systems, ensuring data
integrity and quality throughout the process.


INTERVENTION SCOPE
* Data integration
* Use of Theobald and Kingswaysoft
connectors
* Data warehouse management and flow
control

TECHNICAL ENVIRONMENT
* SSIS
* THEOBALD
* KINGSWAYSOFT
* SAP
* DYNAMICS 365
* C#

FP&A CONSULTANT

BPCE PAYMENTS
( INDUSTRY : FINANCIAL SERVICES)
FP&A CONSULTANT

PROJECT : As a senior consultant, I led the implementation of Board (EPM) within the
financial services sector, specifically for BPCE Payments. Focusing on strategic planning
and performance management, I customized the solution to address the unique
requirements of the financial services industry. Leveraging simulations and advanced
processes, I empowered BPCE Payments to model various scenarios, streamline
operations, and make data-driven decisions. By optimizing financial performance,
aligning strategic goals, and ensuring regulatory compliance, the organization gained a
competitive edge in the dynamic landscape of financial services.

INTERVENTION SCOPE TECHNICAL ENVIRONMENT
* Datawarehouse modeling and design * Board
* Creation and development of a data * SQL Server
transformation pipeline
* Data mining process optimization for
segmentation (Parallelism, Partitioning,
Broadcast)

EPM SENIOR CONSULTANT

Board International KRYS
( INDUSTRY : RETAIL)
EPM SENIOR CONSULTANT

PROJECT : In my role as a senior consultant, I specialized in the implementation of Board
(EPM) for clients. I provided expert guidance in performance management, security
management, process optimization, and scope and accessibility management. By
leveraging my skills and knowledge, I successfully assisted clients in harnessing the full
potential of Board as a robust performance management solution. I streamlined
processes, enhanced security measures, and ensured improved accessibility for
stakeholders, empowering them to make more informed and efficient decisions.


INTERVENTION SCOPE TECHNICAL ENVIRONMENT
* Data transformation with SSI * SQL Server
* Financial consolidation and reporting * ETL SSIS
* Automated data loading (Batch) * SHELL
* Board International

EPM CONSULTANT

ELKEM
( INDUSTRY : CHEMICALS)
EPM CONSULTANT

PROJECT : In my assignment, I was responsible for deploying an advanced budget tracking
application that incorporated simulation features and a streamlined approval workflow
across the Finance, Sales, and HR departments. My primary goal involved designing and
implementing Extract-Transform-Load (ETL) processes to seamlessly integrate and
manage data from these departments. The resulting application empowers the
departments to effectively monitor budgets, conduct scenario simulations, and efficiently
navigate the approval process. Through my efforts, the organization has witnessed
significant enhancements in transparency and operational efficiency pertaining to
budgetary management.


INTERVENTION SCOPE TECHNICAL ENVIRONMENT
* Datawarehouse modeling and design * BOARD
* Creation and development of a data * BATCH
transformation pipeline
* Data mining process optimization for
segmentation (Parallelism, Partitioning,
Broadcast)

BI & EPM CONSULTANT

NOVAMEX
( INDUSTRY : PERSONAL CARE)
BI & EPM CONSULTANT

PROJECT : As a senior consultant, I spearheaded the implementation of Board (EPM) within
the Sales department, with a specific focus on sales planning. Drawing on my expertise
in performance management, security management, and process optimization, I tailored
the solution to meet the unique needs of sales planning and forecasting. By incorporating
simulations and advanced processes, I empowered the Sales team to model different
sales scenarios, optimize their resource allocation, and make data-driven decisions to
drive revenue growth. This comprehensive approach enabled the organization to align
sales strategies, enhance sales performance, and achieve their sales targets effectively in

INTERVENTION SCOPE
* Datawarehouse modeling and design
* Creation and development of a data
transformation pipeline
* Data mining process optimization for
segmentation (Parallelism, Partitioning, Broadcast)

a competitive market.


TECHNICAL ENVIRONMENT
* Board
* SQL Server
* SSIS
* Transact SQL
* SHELL
* BATCH

EPM CONSULTANT

ECONOMAT DES ARMÉES
( INDUSTRY : DEFENSE)
EPM CONSULTANT

PROJECT : As an EPM consultant, I spearheaded the implementation of Board (EPM) within
the Finance department, specifically focusing on strategic planning. Drawing on my
expertise in performance management, security management, and process optimization,
I tailored the solution to meet the unique needs of financial strategic planning. By
incorporating simulations and advanced processes, I enabled the Finance team to model
different scenarios, streamline their operations, and make data-driven decisions. This
comprehensive approach empowered the organization to optimize their financial
performance, align their strategic goals, and drive sustainable growth in the competitive
landscape.


INTERVENTION SCOPE TECHNICAL ENVIRONMENT
* Datawarehouse modeling and design Board
* Creation and development of a data *
transformation pipeline * SQL Server

* Data mining process optimization for
segmentation (Parallelism, Partitioning,
Broadcast)

BI & EPM CONSULTANT

GROUPE GUILLIN
( INDUSTRY : PACKAGING)
BI & EPM CONSULTANT

PROJECT : During my mission, I was tasked with implementing a budget tracking
application with simulation capabilities and an approval cycle for the Finance, Sales, and
HR departments. My main objective was to develop ETLs (Extract-Transform-Load) to
gather, transform, and load data from these departments. The application now enables
them to manage budgets, simulate different scenarios, and track approvals throughout
the process. My work has significantly improved transparency and efficiency in budget

management within the organization.


INTERVENTION SCOPE
* Data transformation with SSI
* Automated data loading (Batch)
* Financial Consolidation and Reporting

TECHNICAL ENVIRONMENT
* SQL Server
* ETL SSIS
* SHELL

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in