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

Antoine Guibert

Management Controller - Automation - AI

€520/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Antoine

If you want to have a clear vision of your business's financial health and be able to manage it in real-time, if you are wasting time on complex Excel files, manual reporting, or difficult-to-use data, I can help you create, structure, automate, and analyze your management tools to make your business more readable, reliable, and easier to manage on a daily basis.

I work with entrepreneurs, VSEs, and SMEs to transform existing data (sales, finance, customers, operations, marketing) into automated and truly usable management tools. The goal is to enable managers and teams to save time, reduce manual tasks, and gain a clear view of their performance through relevant KPIs and reliable reporting.

My added value lies in both an operational and technical approach:
  • Financial analysis of variances, trends, profitability, customer dependency, and performance monitoring.
  • Structuring and validating databases,
  • Advanced automation in Excel using VBA,
  • Creation of dynamic dashboards and automated reporting,
  • Design of management tools on Excel and Power BI,
  • Implementation of performance indicators adapted to the business.

I work on projects such as:
  • Automation of monthly reporting,
  • Creation of financial and operational dashboards,
  • Tools for monitoring activity and KPIs,
  • Multi-year management files,
  • Exploitation of ERP/accounting data,
  • Reduction of processing time for recurring tasks,
  • Structuring and cleaning databases,
  • Financial and operational analyses.

Each solution is designed to be clear, scalable, and easily usable by teams, with a simple logic: to provide concrete tools for better decision-making and more effective business management.
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • SAFRAN
    Site Management Controller
    DEFENSE AND MILITARY
    October 2025 - Today (8 months)
    Massy, France
    Within site management control in a demanding industrial environment, I am involved in financial management, budget analysis, and reporting tool optimization for several operational and technical departments.

    Responsibilities: Financial and budget management of several departments through the production of financial analyses, monitoring of actual vs. budget variances, Forecast, Updates, MTP/ROFO and Budget exercises, as well as ensuring the reliability of data from SAP and BPC.

    I assist management controllers in improving management tools and financial processes.
    Responsibilities for cross-functional, high-stakes projects for various departments (Technical, Quality, R&T, Industrial Operations). I have designed and automated several reporting and analysis tools in Excel/VBA, Power BI, and BPC to improve data reliability and significantly reduce processing times.

    Redesign and security of a multi-departmental MTP file, automation of monthly financial reporting that reduced a process by 90% of its time, implementation of weekly monitoring of unassigned hours.

    I perform pre-go-live tests, data cleaning and security, flux validation, and operational support. In parallel, I work on internal control issues, cost center analysis, headcount monitoring, and the creation of SAP accounting views.

    This experience allows me to develop strong expertise in management control, data analysis, automation, and financial management in a large group environment with high operational demands.

    Skills used: Management Control • Budget Analysis • MTP / ROFO • Forecast • SAP • BPC • Advanced Excel • VBA • Power BI • Automation • Financial Reporting • Data Analysis • Internal Control • ERP • Project Management • Data Reliability • Performance Management
    Management Control Automation Reporting Budget Management Financial Analysis
  • Nexio
    Freelance Management Controller
    CONSULTING AND AUDITS
    March 2026 - Today (3 months)
    Créteil, France
    I help VSEs and SMEs structure, automate, and leverage their management data to transform often underutilized files into true management and decision-support tools.

    Using existing company data (sales, customers, finance, operations, marketing, operational reporting), I work to:
    • Structure and validate databases,
    • Automate recurring tasks in Excel via VBA,
    • Design clear, visual, and updatable management tools,
    • Build dynamic reports and dashboards on Excel and Power BI,
    • Define and implement truly relevant KPIs for the business,
    • Highlight concrete analyses: variances, trends, profitability, customer dependency, activity monitoring, optimization opportunities.

    The goal is to enable the manager or teams to have a clear and usable view of their business, without complex manual reclassifications or difficult-to-maintain files.

    The proposed solutions are designed to be automated, easy to use, and adapted to the company's actual operations.

    Examples of assignments:
    • Creation of an automated financial monitoring tool,
    • Automation of monthly reporting,
    • Reduction of processing time for recurring tasks,
    • Development of performance indicators and dashboards,
    • Analysis of commercial or marketing activity,
    • Implementation of multi-year management files,
    • Exploitation of ERP or accounting extracts,
    • Power BI reporting connected to Excel databases.
    Technical skills:
    Advanced Excel, VBA, Power Query, Power BI, automated reporting, database structuring, financial and operational data analysis.

    Each assignment is designed to understand real needs, identify useful indicators, and build reliable tools for clearer business management.
    Automation KPI Data Analysis Management Tools Personalized Support
  • VALPACO GOUP
    Management Control Assistant
    AVIATION AND AEROSPACE
    May 2025 - September 2025 (4 months)
    Rungis, France
    - Monthly analysis of economic performance: development of consolidated reports (revenue, margins, direct costs), creation of management indicators (KPIs: revenue/hour, profitability, productivity). Analysis of budget variances and reporting of results to management.
    - Ensuring billing accuracy through automated controls (Excel and VBA), contributing to monthly closings: revenue reconciliation, entry and justification of accounting entries, control of analytical allocations. Rigorous monitoring of multi-company collections and N vs. N-1 comparative analysis.
    - Redesign, automation, and digitalization of processes (expense reports, accounting extracts, tracking sheets) using Excel (VBA, Power Pivot) and Power BI (DAX modeling, dynamic dashboards), reducing manual tasks by up to 90%.
    - Audit and validation of tax returns (Italian taxes), processing of declaration variances and corrective calculations.
    - Monitoring of inventory/work-in-progress validity: valuation in value and volume.
    - HR Optimization: modeling of schedules for over 80 pilots under regulatory constraints, development of Power BI tools to anticipate over/understaffing. Participation in the continuous improvement of ERP systems (SAGE, AMOS, FL3XX, LUCCA, YOOZ).

    Skills:
    - Office Suite
    - Advanced Excel proficiency: VBA coding, Power Pivot, automation, VLOOKUP & HLOOKUP.
    - Microsoft Power BI: Power Query, dashboards, DAX formulas, real-time, automated financial and operational indicators.
    Management Control Microsoft Excel Financial Analysis and Reporting Microsoft Power BI Budget Management

Recommendations

Be the first to recommend Antoine

Help this freelancer shine by sharing your experience working together.

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

  • Grande Ecole Program, Master in Corporate Finance, Management Control, Accounting, Audit, Reporting
    Institut Supérieur de Gestion Paris
    2026

Skill set

Categories