Guillaume Tran
Financial Analyst at Fleet Complete- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Vietnamese -
Topline Score
Bio
Experience
-
Fleet Complete
-
Canada
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Financial Analyst
-
Apr 2022 - Present
- Reconciling and cleaning monthly subscriber data to form accurate revenue reporting- Constructing Excel templates/models to further improve process efficiency- Performing variance analysis on Revenue and COGS, presenting to upper management to assist with KPIs- Reconciling and manipulating large financial data sets and collaborating with the Data Systems team to resolve data misalignment- Collaborating with key stakeholders on a monthly basis to discuss revenue streams
-
-
Junior Financial Analyst
-
Nov 2021 - Apr 2022
- Reconciling and analyzing monthly subscriber revenue and collaborating with stakeholders to form accurate billing- Restructured the monthly reconciliation process to boost efficiency- Reconciled COGS accounts and performed adjusting Journal Entries using Microsoft Finance & Operations- Reviewing GL account distributions and posting sales orders
-
-
-
Compass Group Canada
-
Canada
-
Food and Beverage Services
-
700 & Above Employee
-
Senior Accountant
-
Mar 2021 - Oct 2021
-Accurately forming sales reports for AR invoicing and commissions payable, using SAP, Excel, and Quickbooks-Precisely reconciling sales, intercompany transactions, and bank GL accounts, using Excel and Oracle JDE-Working with the FP&A Manager to form KPIs to efficiently monitor sales performance across Canada-Analyzing Proformas and tracking Capital Expenditures
-
-
District Accountant
-
Jan 2020 - Mar 2021
- Generating sales and commissions reports using Excel and Pivot Tables- Collaborating with Senior Analysts to form expense KPIs to efficiently monitor COGS- Reconciling prior period expenses and creating adjusting journal entries- Forming accurate month-end accrual reports for P&L analysis- Submitting Fixed Asset purchase requests and tracking Fixed Asset expenses- Efficiently reconciling and processing AP statements/invoices using Oracle JDE
-
-
-
United Construction & Forestry
-
United States
-
Construction
-
200 - 300 Employee
-
Accounts Payable Coordinator
-
Sep 2019 - Dec 2019
- AP Invoice reconciliation - Month-end closing of Purchase Orders - AP accounts analysis for divestiture - Assisted in creating financial reports of supplier accounts for divestiture - AP Invoice reconciliation - Month-end closing of Purchase Orders - AP accounts analysis for divestiture - Assisted in creating financial reports of supplier accounts for divestiture
-
-
-
Toromont Cat
-
Canada
-
Machinery Manufacturing
-
700 & Above Employee
-
Finance Student Intern
-
May 2018 - Aug 2018
-Provided timely results for financial statement consolidation by efficiently entering account data within data systems using Excel and BPC FSA software (SAP) -Analyzed and clarified invoices by retrieving and organizing data into PivotTables -Processed A/R payments from international customers using Excel and BPC FSA software (SAP) -Kept accurate records for daily transactions -Provided timely results for financial statement consolidation by efficiently entering account data within data systems using Excel and BPC FSA software (SAP) -Analyzed and clarified invoices by retrieving and organizing data into PivotTables -Processed A/R payments from international customers using Excel and BPC FSA software (SAP) -Kept accurate records for daily transactions
-
-
Education
-
University of Toronto Mississauga
Bachelor of Commerce - BCom, Business Commerce & Finance Specialist, Economics Major -
St.Marcellinus Secondary School