Email Verified Lilian A
0/5 (0 Feedback)
Member since September 28, 2022
Profile health 80%

Accounting Professional

• Have 12 years of experience in financial management working in different organizations (public ccounting firm, government, and corporations), and in different industries
• Make positive impact in the workplace by implementing efficient processes as demonstrated at current and previous positions
• Manage competing priorities such as a challenging course load while achieving A grades, leading to effective time management, and delivering a high level of accuracy within short deadlines
• Solid analytical and problem-solving skills demonstrated through quick learning of new software and diagnosis of accounting issues
• Leadership skills developed through MindTrust Leadership Development Program
• Delivered excellent customer service and exceeded expectations in a front-line role
• Experience with different accounting and taxation software, such as SAP, Quickbooks (desktop and
online), Sage 50, Yardi Breeze, Microsoft Dynamics AX, Sage Accpac and TurboTax, UFile
• Advanced Excel skills using VLOOKUP, pivot tables, IFERROR (for variance analysis), SUMIF,
conditional formatting, advanced filter functions, creation of tables and graphs
• Bilingual in English and French


Financial Analyst

  •  Public Services and Procurement Canada
  •  Jul 2022 - Jul 2023

• 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

  •  Ernst & Young LLP
  •  Feb 2022 - Mar 2022

• 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

  •  Accessibility Standards Canada
  •  Dec 2020 - Mar 2021

• 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


  •  Sinai Accounting Services
  •  Nov 2018 - Sep 2022

• 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

  •  Hulse, Playfair & McGarry Inc.
  •  Feb 2016 - Feb 2017

• 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

  •  Smith Co
  •  Sep 2015 - Dec 2015

• 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

  •  I.C.S Petroleum Montreal Ltd.
  •  Aug 2013 - Sep 2014

• 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

  •  Praxair Canada Inc.
  •  Jul 2012 - Aug 2013

• 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

  •  Emerge Work at Home, LLC
  •  Dec 2018 - Aug 2019

• 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


College Diploma in Business and Administration with a concentration in Accounting and Management Technology

  •  Vanier College
  •  Aug 2008 - Jun 2013

Graduated as an Honored student

Bachelor of Commerce, major in Accounting

  •  Carleton University
  •  Sep 2019 - Oct 2021

Graduated with Distinction

Master of Accounting

  •  Carleton University
  •  Sep 2022 - Oct 2022

In progress - I will be writing the CPA Canada Common Final Examination in September 2024