Experience
Financial Analyst
• Use and create pivot tables to analyze data in various ways
• Use VLOOKUP to transfer information from a large set of raw data into an organized database for financial reporting and analysis purposes
• Use IFERROR in Excel to perform variance analysis such as comparing different periods and fiscal year
• Use advanced filter options and conditional formatting to view data sets in various dynamic ways based on management needs
• Analyze and update the accuracy and reliability of the information to meet financial reporting requirements, such as the departmental management report (DMR), cost accounting tool, accrual budgeting and ITPPM for Treasury Board submissions
• Assists in reviewing and revising documentation for users, such as the chart of accounts, the coding manual, etc., by getting familiar with the chart of accounts and coding block
• Utilize SAP to perform various financial transactions (create fund commitments, purchase orders, service entry sheets, post fund commitments, create reports, analyze data, process payments, enter salary recoveries, create interdepartmental settlements)
• Help develop strategies and participate in maintaining existing application such as ITPPM and GCDocs, while ensuring data integrity and accuracy
• Analyze, research and process various types of financial transactions and expenditures pertaining to section 32 and section 34 approvals to ensure appropriate accounting methodology are applied
• Provide financial coding for transactions, prepare section 34 and request for acquisition services (RAS)
• Document various accounting processes in accordance to the proper internal control and financial policies
Staff Accountant
• Performed audits for public corporations with multiple subsidiaries and not-for-profit organizations
• Used pivot tables to analyze, manage, sort and organize large sets of data
• Extracted reports from Blackline
• Met with clients to perform walkthroughs
• Performed inventory counts at different client site
• Conducted overall analytical review of financial statements
• Assisted in the planning and execution of financial statement audits
• Rolled-forward workbooks during interim to ensure a smooth transition for year-end audits
• Tested multiple accounts to ensure completeness and accuracy
• Used advanced excel functions to aid in completing tasks more effectively
• Effectively communicated with team members and clients regarding progress updates and issues on an ongoing basis
Financial Analyst
• Contributed to finalizing presentation on initial budget and quarterly financial updates to be delivered to Executive Committee
• Contributed to the annual budget exercise to help define spending parameters for the organization
• Performed quality control check on financial statements and quarterly financial reports to be available to the public
• Assisted in the budget meetings to ensure staffing position list and operations and management detailed workplan are updated accordingly
• Confirmed financial coding for salary recovery
• Processed and review commitments to identify spending trends and financial pressures
• Prepared section 34 checklists for payment processing (invoices, salary recovery)
• Contributed to the translation of French documents for alternative text
Bookkeeper
• Provide bookkeeping services to a restaurant and property management company
• Use Yardi Breeze to set-up charts of accounts, and enter invoices, payments, vendors, and suppliers
• Use Sage 50 to perform bank reconciliations, set-up charts of accounts, enter journal entries, payments, invoices and set up recurring transactions
• Provide training to clients and other bookkeepers on how to use the accounting software as well as perform related tasks
• Work in liaison with different business owners to facilitate the completion of the books
Accounting Coordinator
• Introduced Interac e-Transfers as a new method of payment, which made it more convenient for customers to pay and in turn it reduced accounts receivable by approximately 10%
• Reconciled various bank accounts, Insurance Funded Trust Statement, Trust reports, credit cards and PayPal accounts for multiple inter-companies with QuickBooks desktop and online
• Prepared monthly statement of account to analyze aging accounts, called customers to follow-up on late payments, made payment arrangements and sent delinquent accounts to collection agencies
• Prepared monthly government returns, such as GST/HST and T5 returns
• Entered multi-currency transactions in Quickbooks online and desktop (invoices, sales receipt, refunds, bank deposits, payments, bills, transfers, adjusting entries, journal entries)
• Analyzed 150+ accounting records to identify issues, ensured timely investigation and adjusted entries
• Provided support and prepared documentation for external auditors during quarters and year-end
Accounts Payable Coordinator
• Closely worked with the Finance team to ensure a good flow of completed tasks
• Entered approximately 150 invoices monthly in Microsoft Dynamics and verified them by ensuring proper extensions, taxes, discounts, coding, and approval matches levels of authority matrix
• Matched invoices to purchase orders and/or proper approval for invoice accuracy
• Received project related invoices and entered mark-up in accounting; processed accounts payable month-end accruals and reversed accruals
Accounting Clerk
• Implemented a new filing system that was still used years after leaving the company
• Performed the full accounting cycle with Simply Accounting and Quickbooks
• Ensured appropriate taxes on invoices, while dealing with multi-currency
• Confirmed the receipt of goods and services through documentation and calling customers
Accounts Payable Clerk
• Paid and authorized payments by following the company’s guidelines
• Matched invoices with packing slips and purchase orders
• Managed the employees’ budgets to ensure they had enough cash on hand to complete upcoming projects
• Prepared documents in English and French
Customer Service Advisor
• Continuously meet weekly targets, such as exceeding customer satisfaction scores based on the level of customer service provided
• Received incoming calls from customers by providing guidance, recommendations, answering questions, up selling and other types of value-added information to meet or exceed client expectations
• Handled unusual requests or difficult customer interactions by showing empathy and building trust
Education
College Diploma in Business and Administration with a concentration in Accounting and Management Technology
Graduated as an Honored student
Bachelor of Commerce, major in Accounting
Graduated with Distinction
Master of Accounting
In progress - I will be writing the CPA Canada Common Final Examination in September 2024