AKAbout Aurelien
Experienced Finance, ERP, and BI professional with over 7 years of experience working in Canada as a freelance consultant and financial analyst. Skilled in ERP implementation, BI reporting, and financial control with a strong track record of supporting enterprise digital transformation projects.
English
Native or bilingual
French
Native or bilingual
Can work on-site
Suresnes (up to 50km)
Experience
- McKesson CanadaSenior Business Process FP&ANovember 2021 - Today (4 years and 7 months)Canada• Partner cross-functionally with the FP&A, Accounting, IT, and Operations teams to generate accurate financial and business reporting for executive management.• Collaborate with FP&A leadership to generate global reporting, presentation creation, and supplemental backup materials to provide valuable reporting content for senior leadership (weekly subscriber reporting, monthly business reviews, etc.)• Ensure business KPIs and data are accurate and effectively socialized with key stakeholders, while also working with business partners on process automation• Provide support to the FP&A team's strategic priorities and initiatives, including assistance with the evaluation, selection, implementation, and ownership of automated reporting, budgeting, and forecasting tool(s)• Oversees Design, build and deploy powerful BI solutions as per business requirements.• Build FP&A facing BI reports and dashboards with Row level security.• Conduct requirements analysis and translate data into informative reports, dashboards and KPI's.• Connect to data sources, import data, and transform data for Business Intelligence.• Create DAX queries in Power BI desktop.• Support and enhance existing reports and dashboards based on evolving business needs.• Maintain and develop new approaches to automate internal and external data retrieval, client reporting and operational process. Interface with cross-functional teams to build centralized/custom data analytics tools to enhance the business process.• Own and develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests andprojects. Create exploratory data analysis, reports, dashboards to surface data for different stakeholders.
- Innovaderm - IntegraMED MontréalProject Financial AnalystApril 2019 - October 2021 (2 years and 6 months)Canada• Prepare monthly ETC, EAC's and analyse profitability of the project.• Prepare and review financial variances between Actual/Budget/Forecast financial results.• Prepare weekly/monthly/quarterly financial analyses on business performance.• Perform strategic and scenario analysis to determine present and future financial performance.• Lead initiatives to continuously improve, automate, and scale forecasting and reporting tools.• Assist in developing, communicating, and managing requirements for reporting and financial reporting enhancements and serve as point person to facilitate business support throughout the organization.• Monitor all subcontractor and vendors contracts and work as contact point for external and internal resource providers.• Evaluate all contracts to identify important terms and prepare report for management and mange accounts receivables.• Prepare project invoicing in accordance with the terms & conditions of the contract.• Revenue analysis, project maintenance, month end accounting tasks, and account reconciliations•
- freelanceFreelanceApril 2018 - August 2025 (7 years and 4 months)Toronto, CanadaFreelance ERP, BI & Finance ConsultantCanada (2018 – 2025)Trolec Canada – Finance Key User, ERP ImplementationSupported ERP system rollout, optimized finance workflows, and trained key users.Belron Canada – BI AnalystDesigned and developed BI dashboards and reporting tools, improving business decision-making.4CAD Group – ERP & BI Business AnalystCollaborated on ERP and BI integration projects, ensuring seamless data flows between departments.Colas Rail Canada – Financial ControllerManaged financial reporting, cost analysis, and budgeting to support project profitability.
Recommendations
Be the first to recommend Aurelien
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- MBA2016MBA
- Master's degreeBank and Finance University of Paris-Nanterre2012Master's degree