You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Sofiane FraguaSF

Sofiane Fragua

Finance | Management Control | Excel VBA | SAP

€450/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Sofiane

Management controller focused on financial steering and structuring of reporting, I support finance teams in budget monitoring, variance analysis, and financial data validation.

I have operational experience with finance ERPs such as SAP and HIVE, used for tracking expenses, commitments, orders, and invoicing, in line with budgetary and analytical rules.

In addition to ERPs, I extensively use advanced Excel to consolidate data, analyze variances, and build financial dashboards tailored to team needs. I have also developed tools and automations (Excel/VBA) to improve reporting reliability and reduce manual tasks.

Accustomed to complex and multi-project environments, I quickly adapt to existing tools and processes, with the goal of providing financial visibility, clear guidance, and concrete decision-making support.
  • English

    Fluent

  • Spanish

    Conversational

  • French

    Native or bilingual

Can work on-site
Paris (up to 40km), Paris (up to 40km)

Experience

  • CNRS
    Management Controller
    RESEARCH
    November 2025 - February 2026 (3 months)
    Aix-en-Provence, France
    • Support for budget steering of funded research projects (ANR, Region, etc.) with expense tracking and financial analysis of project portfolios.
    • Production of dashboards and financial reports from internal tools to improve budget visibility and activity monitoring.
    • Structuring, consolidation, and analysis of accounting and financial data to facilitate steering and decision-making.
    • Design of monitoring tools and performance indicators adapted to the needs of management and research teams.
    • Optimization of financial processes and improvement of data organization to validate analyses and reduce manual processing.
    • Ability to work in complex environments requiring rigor, multi-project management, and coordination with multiple stakeholders.
    VBA Dashboards
  • ENGAGE Projet ITER
    Management Controller
    CIVIL ENGINEERING
    June 2025 - September 2025 (3 months)
    Saint-Paul-lès-Dax, France
    • Development of custom Excel/VBA solutions to automate, centralize, and validate financial data from ERPs, business tools, and non-interconnected files.
    • Creation of data gateways between multiple systems to simplify information flows and reduce manual processing.
    • Automation of reporting, consolidations, and financial controls to improve productivity and secure budget analyses.
    • Preparation, structuring, and quality control of data before integration into Hive to ensure the consistency and reliability of exploited information.
    • Execution of ERP mappings and budget line analyses to identify sources of expenditure and improve financial flow visibility.
    • Optimization of financial monitoring and budget steering processes in complex, multi-actor technical environments.
    • Ability to intervene quickly on issues related to data structuring, Excel/VBA automation, financial reporting, and process improvement.
    Budget Management Budget VBA Mapping Excel VBA Macro
  • CEA
    Management Controller
    BIOTECH
    November 2023 - June 2025 (1 year and 7 months)
    Saint-Paul-lès-Durance, France
    • Development of custom Excel/VBA solutions to automate and secure purchasing and financial monitoring processes.
    • Design of an intelligent purchase form to standardize requests, reduce manual errors, and automate the generation of tracking files and administrative workflows.
    • Automation of financial processing from SPI exports connected to SAP to effectively centralize, clean, and utilize budget data.
    • Creation of consolidation and analysis tools in Excel/VBA to accelerate reporting and improve the reliability of financial data.
    • Development of KPI dashboards focused on cost management and decision support: budget monitoring, cost centers, expenses, contracts, and performance indicators.
    • Structuring and harmonization of financial data to provide a clear and usable view for operational teams and management.
    • Analysis of cost centers and identification of financial optimization levers in complex technical environments.
    • Ability to transform manual and time-consuming Excel processes into automated, reliable tools adapted to business needs.
    • Intervention on issues related to automation, financial reporting, data structuring, and process optimization using Excel/VBA and SAP.
    Automation VBA SAP SQL

Recommendations

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master in Finance and Management Control
    ISCOD
    2024
    Master Finance et Contrôle de Gestion
  • Bachelor's degree in Economics and Management
    University of Franche-comte
    2022
    Licence économie et gestion

Skill set

Categories