Jean-Philippe TOMBO
Financial Controller | FP&A | Power BI expert
Salaire / Taux journalier
Clamart, France
Mobilité : Paris, Lyon
Freelance
Peut venir sur site
Expertises
Langues
À propos
Introduction
Financial controller with 15+ years experience in financial planning, budgeting, and business intelligence across banking, media, and manufacturing sectors. Microsoft certified Power BI Data Analyst with proven expertise managing €50M+ budgets and creating advanced Power BI data models for financial reporting. Expert in financial analysis, SAP, and Power BI solutions that drive strategic decision-making.
Expérience de travail
Finance & Power BI Data Analyst for Intercompany financial flows
OpellaFreelance
juin 2024 - Présent
2 ans 5 mois
Paris, France
- Creation, optimization and maintenance of Power BI data models and reportings on the topics of: *Royalties calculation and invoicing by the head office to subsidiaries *Head office central costs recharges to subsidiaries *for Intercompany Residual profit retrocessions to the main "entrepreneur" entity of Opella group - Performance audit & diagnostic of Power BI reporting files - Data cleaning, Data Modelling, Creation of visuals and management of reports distribution in Power BI workspaces - Analysis of Royalties amounts, consistency with Licensing agreements and residual profit retrocessions
PMO Budget & IT Reporting for Technology Services Dpt
ING FranceFreelance
juin 2021 - mai 2024
3 ans
Paris, France
- Ensuring coordination of budget, forecasts and reporting tasks for IT areas of the bank (Wholesale Banking, Daily Banking, Save & Invest, Lending) totalling a budget of around 50M€ for build and run activities - Coordination and follow-up of budget, forecasts of External IT consultants costs (man-days), IT headcount - Creation of IT purchase orders in Peoplesoft ERP for IT consulting, Software Licensing, Hardware acquisition and maintenance, Service Subscription, outsourcing, telecommunications and miscellaneous expenses. - Monitoring and reporting of staff budget (headcount, variances, duration for contractors), operating costs (OPEX) and the level of capitalization of development costs. - Creation and follow-up of excel templates for IT projects costing (mandays, other third party services) - Drafting, coordination and monthly reporting of IT operational key indicators to ING Headquarters in the Netherlands
Business Controller for IT Department
CANAL+ GroupFreelance
févr. 2021 - mai 2021
4 mois
92130 Issy-les-Moulineaux, France
- Ensuring coordination of budget and forecasts tasks for the functional areas of the IT department (Digital, Data, Operation, Product management) for an OPEX budget of around 25M€. - Monitoring of staff budget (headcount, variances, duration for contractors), operating costs (OPEX) and the level of capitalization of development costs. - Calculation of accruals (FNP, FAR and CCA) and cost re-invoicing of Group IT services to subsidiaries. - Maintenance of cost center structure of the IT department according to changes in the organization.
Groupe SEB
mai 2011 - déc. 2020
9 ans 8 mois
Lyon Area, France
Business Controller for Europe Supply Chain Department
nov. 2015 - déc. 2020
5 ans 2 mois
Lyon Area, France
- Ensuring coordination of budget and forecasts tasks for two warehouses and an export department back office (sales administration, transport and customs) with a total budget of € 14M. - Ensuring monthly accounting closing (calculation of provisions, cost re-invoicing, general ledger bookings, sales cut-off of GS Export export subsidiary). - Monitoring and providing budget variances analysis for GS Export's sales (approximately € 600M), warehouses costs and the export department. - Providing operational managers with costs / budget analysis reports for monthly business reviews. - Calculation and follow-up along with logistic director of the inventory devaluation provision for central stock in the EMEA area (annual average for the provision of € 300K) . - Calculation of transfer prices for specific sales flow between Groupe SEB companies. - Ensuring credit management tasks related to the release of orders upon payment confirmation from accounting and initiating coverage request to COFACE. - Preparation of investments budget for logistics warehouses in my perimeter, creation of investment orders in SAP, activation of assets amortization in SAP. - Production of Insee declarations, Eco-packaging and Eco-systems for GS Export.
Financial Reporting Controller
mai 2011 - oct. 2015
4 ans 6 mois
Lyon Area, France
- Drawing of reporting planning and execution of monthly closing tasks with accounting team - Ensured monthly reporting for the following financial flows: sales & cost of sales, inventory, expenses and variances from standard costs - Ensured the construction of the P&L statement on a monthly basis for legal entity Groupe SEB France (GSF), Groupe SEB Belgium (GSB) and Groupe SEB Netherlands (GS NL) - Participated to budget construction and actualization - Maintaining the analytical structure (Cost centers) in SAP for GSF, GSB and GS NL - Checking the correctness of data (standard prices, sales figures, etc.) in financial systems (SAP applications) - Provided analysis insights on financial figures of GSF, GSB and GS NL - Communicated with external auditors for issues related to legal entity GSF - Monitored and checked the compliance of accounting entries with Groupe SEB reporting guidelines
Financial Reporting Controller
Canal+
juil. 2010 - janv. 2011
7 mois
Paris Area, France
- Budget construction, control and actualization - Monthly financial reporting - Analysis of P&L statements - Preparation of financial reports for the board of directors meetings - Improvements of financial reporting tools
Europe Internal Controller
Rhodia
juil. 2009 - mars 2010
9 mois
Lyon Area, France
- Testing of SOX controls effectiveness performed in differents Rhodia locations across Europe (England, France, Germany, and Italy) - Follow-up and reporting of the implementation of items in the audit remediation plan - Assistance for training of operational staff on best practices in Sarbanes-Oxley controls
Accounts Payable Team Leader
Shell Oil Company
févr. 2007 - oct. 2008
1 an 9 mois
Douala, Cameroun
- Accounts analysis - Analysis of shell intra group accounts - Accurate and on-time payments of vendors invoices - Cash forecasts - Filing room management
Costs & Revenues Controller
Maersk Group
févr. 2004 - oct. 2006
2 ans 9 mois
Douala, Cameroun
- Costs and revenues control - Data quality control - Demurrage and Detention revenue analysis - Costs monitoring and reporting
Formation
emlyon business school
MSc
2008 - 2011
3 ans 1 mois
Catholic University of Central Africa
Master
1999 - 2003
4 ans 1 mois
College Jean Tabi
High School Diploma
1993 - 1999
6 ans 1 mois
Licences et certifications
Microsoft Certified: Power BI Data Analyst Associate, PL-300
Délivré le : avr. 2024