Freelancer profile translated to English.

Back to original language

Description

Support entrepreneurs in their goal of Automating & Optimizing their data to increase Efficiency & Profitability

Background:

- 6 years of experience in FP&A

including

- 3 years at JCDecaux Africa, based in Johannesburg (World N°1)

- 3 years at World Kinect Energy (subsidiary of World Fuels Services, Fortune100 N°70)

My expertise:

- Audit of the use of existing data and databases

- Communication and sharing of best practices for Data management and use

- Automation and streamlining of business processes in the search for efficiency gains

- Initiation, Animation and Consolidation of budgeting/financial planning steps within the finance department

Automation, synthesis and flexibility

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Rennes (up to 50km), Paris (up to 50km)

World Kinect Energy Services
Data & Finance Analyst
ENERGY AND UTILITIES
December 2020 - November 2023 (2 years and 11 months)
Paris, France
- Initialization of the widespread and massive use of data in the warehouse - SQL
- optimization and automation of all ETL tasks and reporting tools
- creation and automation of Forecasting and Budgeting models - progression from static to rolling forecast
SQL Server Snowflake Oracle Dynamics AX Dynamics 365 Power BI Power Query Data Modeling Forecasting
JCDECAUX SA
Business & Finance Analyst (FP&A)
PRESS AND MEDIA
June 2017 - May 2020 (2 years and 11 months)
Johannesbourg, South Africa
JCDecaux Africa – Johannesburg, South Africa June 2017 – April 2020
Business Analyst for Sub-Saharan Africa (FP&A)
• Strategic Planning – Modeling and construction of the subsidiary's 5-year plan to double revenue in the 14 countries of the region through the consolidation of existing JVs, the opening of new countries via Tenders and the optimization of the existing advertising inventory
• Business Development – Support for Business Development in countries through the analysis of investment opportunities, modeling of CAPEX/Revenue/OPEX and key KPIs submitted for COMEX validation – Responsible for Business Plans in the region – Local support for the Corporate M&A team
• Productivity Gain – Creation and production of automated reports that allowed sales teams to focus on sales and minimize ancillary tasks
• Cost Optimization – Assistance in identifying unprofitable advertising assets and measuring achievable savings over a 24-month forecast period
• Financial Control – Supervision of financial reporting and analysis of investment opportunities for a joint venture – Steering towards a break-even objective within 12 months (JV created early 2019) – Use of SAP
Business Plan Development Responding to Tenders Financial Modeling