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

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Pierre

🎯 Financial controller for nearly 6 years, I now work as a freelancer to help companies create customized Excel tools: dashboards, forecasts, budget tracking, pricing, and automated reporting.

💼 My experience has led me to work in various environments: construction, industry, public service, large corporations. I have built reliable models for projects worth €70 million, multi-entity forecasts, and sales management tools used in the field.

🧰 I deliver clear, structured files designed for decision-making and adapted to real needs (no unnecessary formulas or gratuitous complexity).

✅ Goal: to save you time, improve clarity, and increase impact.
  • French

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • Bouygues Energies et Services
    Financial Controller
    CIVIL ENGINEERING
    August 2024 - Today (1 year and 10 months)
    Montigny-le-Bretonneux, France
    Responsible for the financial consolidation of 3 entities (annual revenue: €50 million).

    • Tracking expenses, hours, subcontractors
    • Facilitating operational meetings with account managers
    • Building monthly, quarterly, and multi-year forecasts
    • Developing 6-year forecast portfolios and budgets
    • Monitoring budget trajectories and managing variances
    Advanced Excel Automated Reporting Project Tracking
  • Hilti
    Finance Business Partner
    RETAIL (SMALL BUSINESS)
    March 2023 - August 2024 (1 year and 5 months)
    Boulogne-Billancourt, France
    Responsible for the financial analysis of regional and national sales performance.
    • Building and delivering Excel pricing tools for the sales force (margin simulators, adjustment matrices)
    • Analyzing the impact of price/volume on operating margin
    • Creating consolidated sales tracking dashboards (revenue, market penetration, profitability)
    • Forecasting monthly/annual outcomes (revenue & margin)
    • Training the sales force on tool usage and indicator interpretation
    Pricing Sales Strategy Dashboard Creation Financial Modeling
  • Léon Grosse
    Operational Management Controller
    CIVIL ENGINEERING
    March 2022 - March 2023 (1 year)
    Colombes, France
    Financial management of a €70 million construction project in the Paris region.
    • Budget tracking for the operation: variance analysis, consolidation
    • Forecasting costs and margins based on raw material prices (BT index)
    • Building budgets, forecasts, and decision-support tools
    • Assisting management in the economic oversight of the project
    Project Tracking Budget Tracking Variance Analysis Financial Modeling

Recommendations

Be the first to recommend Pierre

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

  • Master 2 Management Control and Organizational Audit
    ISM IAE Paris Saclay
  • Master 1 - Management of Organizations
    ISM IAE Paris Saclay

Skill set

Categories