Florian Doux

Florian Doux

Mentor
5.0
(10 reviews)
US$20.00
For every 15 mins
20
Sessions/Jobs
ABOUT ME
Finance Analyst & Engineer - Expert in Microsoft Office VBA automation
Finance Analyst & Engineer - Expert in Microsoft Office VBA automation

Hi there,

If you are looking for someone who can understand your business needs, your specific constraints and requirements and provide you with an effective solution, I may be an excellent fit.

#OfficeAutomation#Excel#VBA#GSheet#Javascript#Modelling#Reporting

My curiosity brought me into different professional and academic fields (Software Development Engineering, Corporate Real-Estate, Finance and Accounting) at different stages of my life.

As you may see on my LinkedIn Profile, I have demonstrated my ability to interact effectively with various stakeholders and provide them with cost-effective solutions in particular in the area of Excel VBA/SQL Automation.

Let's have a chat.

Melbourne (+11:00)
Joined March 2020
EXPERTISE
5 years experience | 3 endorsements
5 years experience | 3 endorsements
5 years experience | 1 endorsement

REVIEWS FROM CLIENTS

5.0
(10 reviews)
Lydia Rose
Lydia Rose
December 2021
I would highly recommend Florian to anyone looking for help with Excel VBA! He was very professional and delivered the work to a high standard in less than 24 hours.
Andre Pinho
Andre Pinho
November 2021
Really Helpful
Pierre Brunelle
Pierre Brunelle
October 2021
Florian was very helpful. He made the changes to my existing code that I was looking for. I look forward to working with him again in the future! Highly recommend.
rob
rob
October 2021
great!
Michael Newman
Michael Newman
March 2021
Great help working through my project, patient and very knowledgeable!!!
Mariano Hernandez
Mariano Hernandez
July 2020
Florian is an excellent mentor! He went above and beyond to make sure my requirements were met and my solution was complete. I 1000% recommend him, he was extremely professional and responded to all questions in a timely manor.
Justin Rennin
Justin Rennin
July 2020
Awesome coder. Fixed my hardwired POS VBA code and whipped me up a flexible macro (in no time flat) that did everything I asked and more, better than anything I could have asked for. Plus, he took the time to create a proof of concept video prior to job acceptance and explain how it worked (and was incredibly patient with my millions of questions). 10/10. would definitely hire again.
stuart Marshall
stuart Marshall
June 2020
Absolutely fantastic experience, Florian solved my issue quickly and efficiently
Josh Valenzuela
Josh Valenzuela
June 2020
Florian did an amazing job with my project and turned around a deliverable in < 48 hours. He hopped on multiple Zoom calls to work through some of questions/issues and the end result is a template that is going to save our business loads of time & dedication from internal resources. Anyone lucky enough to work with Florian will get a true expert who brings attention to detail, timeliness, and grade A deliverables. Work with Florian if you're looking for best-in-class service!
Jo Schmitz
Jo Schmitz
June 2020
Florian was absolutely a Godsend - got me the solution I needed within a couple minutes, while it's remained "unsolvable" in the web chat rooms for years. Pleasant and professional and absolutely top-notch expertise. Than you, Florian!
EMPLOYMENTS
FINANCE ANALYST: Finance Solutions Team - Automation + Reporting + Modelling
IRESS
2019-08-01-Present
IRESS is a technology company providing financial software and financial market data solutions to the financial services industry. • Bud...
IRESS is a technology company providing financial software and financial market data solutions to the financial services industry. • Budgeting/Forecasting: integration of external data from Netsuite, Workday or spreadsheets into Adaptive Insights • SQL/VBA automation of accounting processes and analytic reports using external files generated by Workday and Preeceda: Australian Payroll Salary Journal, Quarterly Wage Analysis report • Portfolio of Internal Finance Process Improvement projects: implementation of a Google Data Studio Dashboard to give a holistic view of the status of the projects to top management
MySQL
Excel VBA
Microsoft Excel
View more
MySQL
Excel VBA
Microsoft Excel
Google Data Studio
View more
FINANCE ANALYST: Excel/VBA Automation + Financial Reporting + Process Improvements
Ford Motor Company
2018-05-01-2019-08-01
As a Finance Analyst working in Product Development Finance for the Ford Ranger & Everest global product lines, my primary role is design...
As a Finance Analyst working in Product Development Finance for the Ford Ranger & Everest global product lines, my primary role is designing and maintaining the data collection and reporting systems required for the finance change management process. Essentially, this role involves tracking large amounts of financial data in a robust and error proof fashion and then consolidating it into readable and usable financial reports that call attention to major issues for visibility. This provides upper management with insight into the financial status of the vehicle development program and enables them to make strategic decisions for the business. KEY RESPONSIBILITIES • Improving Finance Processes and Reporting via Excel/Outlook VBA Automation • Controlling data integrity and completeness of data inputs used in the processes • Monitoring costs of ~20k vehicle’s parts: variance analysis by model, region and category. • Developing Excel tools and performing ad-hoc financial analysis (cost/revenues analysis) on request • Automating the generation of financial reports that consolidate data from ~ 1800 Excel files into meaningful financial reports (Material Costs, Investments and Finance BOM) for Management Reporting KEY ACHIEVEMENTS • Built from scratch a user-friendly EXCEL VBA tool generating automatically EXCEL reports in 3 clicks • Reduced a financial report generation process from ~2 days to ~20 minutes via proper VBA automation • Designed and implemented the email automation process required for data completeness checks • Designed and implemented the automation process selecting, highlighting and gathering the most important project's cost variances per category and region into the financial reports • Created, maintained and run the systems that use the historical data in the database to produce financial reports that slice the data by reporting function, change type, vehicle control models and average region cost impacts
MySQL
VBA
Microsoft Access
View more
MySQL
VBA
Microsoft Access
Excel VBA
Microsoft Excel
View more
ASSET MANAGER: Financial Excel/VBA Modelling + Project Management + Legal due diligence
PSA GROUP
2014-11-01-2017-11-01
Providing Real-Estate Asset Management services for Peugeot holding and its subsidiaries, establishing project schedules & budgets, makin...
Providing Real-Estate Asset Management services for Peugeot holding and its subsidiaries, establishing project schedules & budgets, making real-estate related deals, interacting with notaries, lawyers and accounting/finance/legal/tax departments’ teams, designing a tool to track projects in portfolio and financial metrics. KEY RESPONSIBILITIES • Identifying and managing legal, financial and operational risks • Writing real-estate contracts, tender processes and other legal documents • Designing and updating a tool with EXCEL/VBA to track projects in portfolio • Establishing financial forecasts, budgets, and other real-estate project planning • Modelling and presenting business plans to create value and enhance financial metrics • Planning, organizing, and coordinating different stakeholders for the real-estate projects KEY ACHIEVEMENTS • Contributed to 29 projects among which 9 asset disposals, 12 leases projects and 8 miscellaneous projects (20 projects completed) • Set up the organization of a 200 M€ corporate project: breaking down into sub-projects such as leases projects, set-up of the tender process for the on-sale property, preliminary legal transactions, creating and following ad-hoc working groups • Modelled exit scenarios for underperforming retail business subjected to non-breakable lease-contracts • Established strategies for asset disposals: DCF analysis and accounting impacts depending on different hypotheses of sales agreements terms • Built Excel VBA tools to manage projects in the portfolio with financial KPIs: - Automation of reporting dashboards, data management of the projects - Allocation of tasks to appropriate teams, consolidation by team and planning, following-up actions - Sorting projects by criteria such as project's NPV/EAA, Cash-Flows and Income statements forecasts - Tool allowing efficient monitoring of projects in portfolio with the ability to get into the details, while also keeping visualizations of the big picture
Excel VBA
Microsoft Excel
Microsoft Word
View more
Excel VBA
Microsoft Excel
Microsoft Word
View more
PROJECTS
Pareto Analysis: Add-In for Microsoft Excel + Website developmentView Project
ParetoAnalysis.Tools
2020
A Pareto Analysis is a simple yet powerful process derived from the 20/80 rule that optimizes scarce resources such as time and money by ...
A Pareto Analysis is a simple yet powerful process derived from the 20/80 rule that optimizes scarce resources such as time and money by focusing on what really matters. Excel Add-In: This Pareto Analysis Add-In developed by myself improves Excel users' experience with the benefits gained from automation in one-click: convenience, time savings and reliability. Website: Paretoanalysis.tools is an E-commerce website built by myself to promote the Pareto Analysis Add-In for Microsoft Excel that I also designed from the ground up.
WordPress
Excel VBA
WooCommerce
View more
WordPress
Excel VBA
WooCommerce
Microsoft Excel
View more
Increasing Real Estate Management Profits: Harnessing Data Analytics - Tableau DashboardView Project
2020
Specialization: Excel to MySQL: Analytic Techniques for Business Module: Increasing Real Estate Management Profits: Harnessing Data Analy...
Specialization: Excel to MySQL: Analytic Techniques for Business Module: Increasing Real Estate Management Profits: Harnessing Data Analytics
Microsoft Excel
Tableau
View more
Microsoft Excel
Tableau
View more