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

Olivier Jin

FP&A Senior | Excel/VBA & SAP BFC Automation

€780/day
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Olivier

I spent 12 years in the finance departments of large corporations, in management control, FP&A, and consolidation, and I ended up developing a small obsession: eliminating the manual work that wastes so much time for finance teams. End-of-month closings that drag on, Excel files that are filled out by hand every month, reporting that is constantly rebuilt... these are exactly the things I love to dismantle.

Specifically, I design tools that run almost by themselves: VBA macros, Power Query, dashboards, so that your closings, budgets, and reports are produced quickly and without errors. And speed isn't everything: I integrate automatic consistency checks at every stage, because in finance, incorrect data that goes unnoticed means a decision that goes in the wrong direction. It's better for the file to detect the anomaly itself before it spreads.

With my previous employers, this resulted in things like a reporting tool that reduced production time by a factor of 10, 35 performance presentations generated in an hour and a half where it used to take a full day, or a redesign of the consolidation process that cut closing times by 40%.

What sets me apart from a pure Excel developer is that I understand the finance behind your files. Before automating anything, I first seek to understand the real need: what you really want to monitor, what decisions are based on this data, what deserves to be automated, and what is no longer useful. Only then do I look at how it's structured, because a well-thought-out process upstream is what makes automation truly sustainable rather than just another workaround.

If you have processes that are weighing you down or a finance function to modernize, let's talk. I like to understand a concrete need before proposing anything.
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 20km)

Experience

  • Dassault Systèmes
    Financial Planning & Analysis – R&D (Meotec Consultant)
    TECH
    July 2025 - May 2026 (10 months)
    France
    Financial co-pilot for two brands in the R&D division, focusing on three pillars: business partnering, FP&A management, and automation. Backing up the manager on corporate and R&D consolidation topics.

    • Led the complete forecasting and budget construction process for two R&D entities on TM1, in strict alignment with Group financial objectives.
    • Managed quarterly closings, operational expense (OpEx) analyses, and comprehensive headcount tracking across the entire R&D perimeter.
    • Consolidated financial data from R&D service providers and tracked third-party costs.
    • Designed "zero-touch" reporting tools (VBA, Power Query): revamped the OpEx/Headcount tracking file, adopted as the sole reporting tool by FP&A in other entities (files reduced by 80%), automated travel expense tracking distributed in one click to 30 financial directors (35 customized files generated and sent in 30 minutes, compared to a previously abandoned process due to its excessive complexity).

    Tools: TM1, Excel VBA, Power Query
    Power Query Excel VBA Macros TM1 Multi-entity Consolidation & Reporting Finance Business Partner
  • Portefeuille Personnel
    Independent Financial Markets Analyst
    September 2023 - Today (2 years and 10 months)
    Entrepreneurial endeavor in managing a personal portfolio through a low-frequency systematic investment strategy that requires no monitoring during market hours.

    • Self-taught development of a breakout strategy on daily/weekly timeframes (Price Action, OBV).
    • Weekly analysis of 100 US stocks (market capitalization > $10 billion, volume > 1 billion) to ensure optimal liquidity and avoid slippage.
    • Risk management: each position sized to aim for a gain 2.5 times the risk taken, with a focus on capital preservation.
    • Configuration of custom indicators on TradingView.

    Tools: TradingView
  • Mobilize Financial Services (Groupe Renault)
    Management Controller (FP&A)
    BANKING AND INSURANCE
    July 2019 - August 2023 (4 years and 1 month)
    France
    Business Partner for the French subsidiary's financial department (DIAC SA), responsible for managing the Network (dealerships) activity and the main point of contact for the IT department regarding management control.

    • Managed a network portfolio of €3 to 4 billion in outstanding loans, with complete responsibility for the income statement (Net Banking Income, OpEx, Cost of Risk).
    • Project manager for the deployment of Alteryx and Anaplan in the subsidiary as part of the Group's digital transformation.
    • Monitored IT expenses with the IT department: annual validation of 100+ projects with ROI analysis, budget adherence, and Group recharges tracking; developed IT and Network budget forecasts under Anaplan.
    • Automated reporting and improved database reliability using Alteryx, SQL, and Excel (macros).
    • Contributed to strategic initiatives: commercial coordination of resources with Nissan, construction of the Mitsubishi integration business plan (tool reusable for monthly closings).

    Tools: Anaplan, Alteryx, SQL, Excel VBA, SAP BFC

Recommendations

Be the first to recommend Olivier

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's in Banking and Finance
    Université d'Évry Paris-Saclay
    2012
    Master Banque et Finance

Categories