Gustavo Sarmiento

A result oriented professional with comprehensive strength in the field of treasury, financial accounting, customer services and client relations. Financial skills include treasury cash forecasting and debt interest expense, securitization (HSBC Bank), accounts payable and receivable. Strong leadership, Interpersonal and analytical skills.

Excellent written and oral communications skills. Well organized with the ability to work in a fast-paced environment. Highly motivated self-starter with an aptitude to learn new tasks quickly. Well versed in the use of personal computer applications including, JDEdwards, ECAP, Treasury Management System, proficient with excel (macros) and data base administration

Treasury Database Administrator - Martinrea International Inc.

(2022-06 - 2024-12)

• Responsible to verify and re-set all electronic payments suppliers in the all-banking platforms in Canada and North America including Mexico, and Europe.
• Create reports and macros in excel to track all payments issued on a biweekly basis to report volume amount and type of payment.
• Streamlining the use of the vendor authorization form (VAF) to make sure all divisions comply with the verification and appropriate approvals for the setup in the banking system by Head Office of new suppliers
• Develop the use of electronic system approvals to be able to trace back approvals for new and old suppliers
• With the use of power pivot tables and the positive pay files from all divisions create a master list of suppliers being paid by cheque in order to transition them to an EFT format to eliminate duplicates.

Treasury Analyst - Extendicare Canada Inc

(2020-11 - 2021-09)

• Responsible for the setup of the all-banking module in the new ERP system being implemented (Workday)
• Set up of all bank accounts
• Set up of payment methods
• Setup of primary use of bank accounts
• Setup of BAI codes in workday to automate booking of interest income, interest expense, bank charges
• Set up of auto bank reconciliations
• Setup all suppliers for electronic payments across Canadian legal entities
• Weekly verification of all EFT payments before being transmitted to the bank
• Streamlining the use of the vendor authorization form (VAF) to make sure all divisions comply with the verification and appropriate approvals for the setup in the banking system by Head Office.

Treasury Analyst - Martinrea International Inc.

(2019-05 - 2020-07)

• Responsible to verify and re-set all electronic payments suppliers in the all-banking platforms in Canada and North America including Mexico for wire transfers
• Streamlining the use of the vendor authorization form (VAF) to make sure all divisions comply with the verification and appropriate approvals for the setup in the banking system by Head Office of new suppliers
• Develop the use of electronic system approvals to be able to trace back approvals for new and old suppliers
• With the use of power pivot tables and the positive pay files from all divisions create a master list of suppliers being paid by cheque in order to transition them to an EFT format to eliminate duplicates.

Treasury Analyst - Red Apple Stores Inc

(2018-06 - 2019-03)

• Preparation of daily cash position and transfer log ensuring funding is achieved in a timely manner on a daily basis and reduce borrowing co
• Prepare bank reconciliations and book all treasury related entries.
• Analyze liquidity trends and sales to model weekly and monthly cash forecasts based on historical information
• Monitor and respond to day to day banking requests including the Master Card credit card program
• Preparation of all wire transfers to pay vendors with in Canada and overseas
• Calculation and booking of interest expense of all credit facilities
• Support and coordinate all banking needs for all 150 stores across Canada
• Assist with external audits

Cash Specialist - Lafargeholcim Canada

(2017-09 - 2018-03)

• Applying cash receipts and process account adjustments in an accurate and timely manner
• Process cash adjustments and applications
• Process general ledger write offs
• Post cash receipts in AR system

Treasury Analyst - Aecon Construction Group Inc

(2017-03 - 2017-07)

• Daily downloads of bank activity and daily upload of electronic bank statements into SAP
• Preparation of daily cash package and cash balance analysis for senior management
• Investigate and coordinate daily bank account inquiries
• Daily Bank Reconciliation of Bank Balances
• Set up of WSIB payments in online banking systems
• Approval of tax payments in online banking systems
• Analysis of SG&A expenses for month, coordination with divisions for the pulling of funds and completion of journal entries to record transactions
• Confirmation of foreign exchange spot purchases, forwards, swaps and hedges
• Bank fee analysis
• Outstanding cheque analysis
• Developed Microsoft Access data base to track and keep control of all bank signatories and online users and the level of access granted to each user.

Accounting Finance - Toronto Community Housing

(2015-03 - 2017-01)

• Processing of Utilities invoice in a timely manner to avoid incurring late charges
• Preparing monthly reconciliation for the utilities accounts
• Preparing month end accruals
• Work in collaboration with Toronto Hydro and TCHC on closing accounts for sold properties as well as demolished sites
• Ensuring invoices are entered in ECAP (energy system) to track, consumptions, price, and variances
• Generates and review monthly reports for energy management team
• Work in collaboration with energy management team and Toronto Hydro resolving issues and variances
• Maintain Ecap database – ensure activation and deactivation
• Manage petty cash, staff and residence cash advances.
• Provide guidance and policy of petty cash and staff/resident's advance
• Preparing monthly reconciliation for petty cash and cash advances
• Processing invoices and reconciliation of vendors invoices for asset management
• Preparing monthly vendor reconciliation by review vendor statement as well as accounts payable sub-ledgers

Senior Treasury Analyst - Rexel Canada Electrical Inc. - Toronto

(2005-02 - 2014-01)

• Detail preparation of the daily, weekly, monthly and quarterly cash flow position to determine investment and borrowing activity for the day.
• Accounting and Reporting - preparation of interest accruals to reconcile with Accounting; A/R securitization ratios
• Budgets and forecasting - prepare budgets and forecasts
• 3 Yr. Financial Plan - maintenance and updating of financial model closely working with the Director of planning
• Preparation of monthly Treasury Report for Management, detailing cash position, investment and borrowing activities and weighted interest rate for the month
• Responsible for timely settlement of interest payments on loans and accruals
• Analyzed bank and credit card fees for 220+ retail stores
• Administration of banking platforms with Scotia Bank, HSBC and RBC, adding and deletion of users, setting up access levels according to clearance rank, and all electronic payments, including wires and EFTs payments
• Lead the preparation of the securitization program sellers report for review by the VP of Treasury ensuring low cost borrowing in excess of CAD190M
• Administration of treasury work station (Treasura) and reporting for Management purposes
• Responsible for the coordination and setup of all intercompany payments of all 9 divisions within Rexel, freeing time for all accounting groups and the reduction of bank reconciling items
• Participate in the monthly credit meeting to analyze trends and follow up on specific customers
• Responsible for the setup of wire transfers and EFT payments –Payments totaling $95M monthly
• Assist with the annual securitization Audit

Treasury Analyst - Tibbett and Britten Group - Toronto

(2002-01 - 2005-12)

• Prepared cash flow reports on a weekly basis for our Head office in the UK
• Follow up on currency exposure (USD/CAD) and covered positions as requires
• Prepared and follow up of consolidated cash flow
• Maintained records and provide the accounting department with all documentation regarding wire transfers
• Bank Reconciliations
• Support the Finance Department (collections department) with timely and accurate cash applications to the various accounts. Manage all banking portals and prepare all bank reconciliations at month end.

Finance Support Officer - Deluxe Laboratories - Toronto

(2001-01 - 2002-12)

• Prepared and booked on a daily basis all cash book entries for all banks (Bank of America, Royal Bank of Canada and Harris Bank) including incoming and outgoing wire transfers and interest payments on loan
• Prepared bank reconciliations at month end
• Prepared and issued daily an open items report for cash flow purposes
• Processed daily cash applications and work with the credit department to follow up on specific and significant open invoices
• Streamlined the cash processing cycle improving efficiency and enabling real time information to be delivered to management
• Support global managers with the full accounting procedures. Implementation of new procedures to reduce credit card chargebacks on purchases.

Cash and Banking Accountant - Tricon Global Restaurants - Toronto

(1998-01 - 2001-12)

• Processed invoice for Pizza Hut stores for all province
• Prepared daily and monthly journal entries
• Prepared month-end accruals
• Reduced credit card charges by over 8% by implementing a new tracking system
• Preparation of exception reports for