Guillaume Tran

Financial Analyst at Fleet Complete
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Mississauga, Ontario, Canada, CA
Languages
  • English -
  • Vietnamese -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • 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

    • 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 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

    • 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
    2015 - 2019
  • St.Marcellinus Secondary School
    2011 - 2015

Community

You need to have a working account to view this content. Click here to join now