Summary
Overview
Work History
Education
Skills
Timeline
Generic

Alison Sommers

Kitchener,Canada

Summary

Proficient in Microsoft Word, Excel, PowerPoint, Vailtech, Great Plains and Outlook, as well as GIS Mapping System, AMANDA, Maximo and Lotus Notes Familiar with a wide variety of financial and accounting software packages, including SAP, Simply Accounting, ACCPAC, MYOB, CMiC, FMW, Quick Books, Sage and Quick Tax Above average data entry skills with heightened attention to detail Excellent organizational, time management, and communication skills Comfortable working independently and as part of a team Ability to learn new tasks quickly and effectively Comfortable working in stressful situations and adapting to new and unique challenges under strict deadlines

Overview

21
21
years of professional experience

Work History

Water/Waste Water Billing Analyst

City of Cambridge
11.2014 - Current
  • Generates water and/or waste water billings using the utility billing software;
  • Analyzes water billing section for high reads, stopped or malfunctioning meters;
  • Arranges for final reads and billings for customers when vacating their property;
  • Investigates billing errors and issues with water accounts
  • Manually prepares water bills, re-bills due to corrections, responds to customers whose concerns may have escalated from Mayor, Council, CAO and senior management
  • Prepares and inputs water adjustments, i.e
  • Charge back NSF, reverse charges, interest payments, etc., including a monthly Journal entry to record water & waste water costs associated with City owned properties
  • Complete account reconciliations and process adjustments to accounts when necessary
  • Collections on overdue water accounts including adding interest, sending reminder notices and processing adjustment to transfer to taxes for non-payment
  • Bill accounts receivable invoice requests to customers, along with collections on outstanding invoices
  • Coordination with project management team and City contractor for implementation of City-wide Advanced Metering Infrastructure (AMI) program
  • Maintain pre-authorized payments on water accounts as per requests received from customers

Accounts receivable clerk

Excalibur Crossbow Canada Inc.
02.2014 - 11.2014
  • Manage all accounts receivable and related transactions on a daily basis including collections
  • Process cash receipts and reconcile bank on a daily basis
  • Compile necessary information to complete credit checks for customer accounts
  • Prepare financial reports when required
  • Responsible for analyzing and reconciling customer accounts on a monthly basis
  • Assist with accounts payable responsibilities when needed

Accounts Receivable Analyst

Rebellion Media
06.2009 - 01.2014
  • Gather, reconcile and record all revenues on a monthly basis for parent as well as subsidiary companies
  • Post all accounts receivable entries to Great Plains and reconcile all related general ledger accounts in preparation for month end
  • Prepare any necessary documentation for yearly audit and liaise with auditors when needed
  • Responsible for preparing and analyzing income statement variance reports on a monthly basis for all companies
  • Preparing ad hoc reports and analysis when requested

Development Administrator

Town of Milton
06.2008 - 06.2009
  • Calculate and authorize amount of development charges to be collected at building permit issuance
  • Reconcile various accounts on a periodic basis and perform analysis pertaining to development charge exemptions for comparison between estimated and actual expenses
  • Prepare monthly journal entries for development engineering inspectors to re-allocate hours to the corresponding subdivisions
  • Assisted with the Town of Milton annual budget including compiling information and proofreading draft copies

Billing Analyst

Manulife Financial
09.2005 - 06.2008
  • Responsible for reviewing and validating client premium statements received, and allocating premiums accurately
  • Completing overdue report and preparing and sending overdue letters to outstanding clients every month
  • Confirming premiums for underwriters as well as the commissions department in preparation for client renewals

Development Finance Clerk

Town of Oakville
08.2003 - 02.2004
  • Maintained all securities (Letters of Credit) on behalf of the Town
  • Provided information to developers, builders, solicitors, and ratepayers relating to securities held, compliance, development charges and other development/finance related issues
  • Calculated, collected, recorded and signed off development charges ensuring compliance with Town by-laws

Education

City of Cambridge Certificate of Project Management - Introduction to Project Management, Project Management Essentials - Stakeholder and Communications Management, Project Management Essentials - Change and Risk Management

City of Cambridge
Cambridge, Ontario
11.2019

Diploma of Business Administration - Accounting

Sheridan College
Oakville, Ontario
04.2003

Skills

    Financial analysis and reconciliations

    Excel and Spreadsheet Management

    Accountability and Responsibility

    Accuracy and Precision

    Audit and Compliance

    Attention to Detail

Timeline

Water/Waste Water Billing Analyst

City of Cambridge
11.2014 - Current

Accounts receivable clerk

Excalibur Crossbow Canada Inc.
02.2014 - 11.2014

Accounts Receivable Analyst

Rebellion Media
06.2009 - 01.2014

Development Administrator

Town of Milton
06.2008 - 06.2009

Billing Analyst

Manulife Financial
09.2005 - 06.2008

Development Finance Clerk

Town of Oakville
08.2003 - 02.2004

Diploma of Business Administration - Accounting

Sheridan College

City of Cambridge Certificate of Project Management - Introduction to Project Management, Project Management Essentials - Stakeholder and Communications Management, Project Management Essentials - Change and Risk Management

City of Cambridge
Alison Sommers