An analyst with experience working closely with accounting, sales and operations managers performing a broad range of analytic reporting (ad hoc and deadline driven), optimization of organization and accounting needs.Driven with knowledge and experience in accounting, constant exposure and adaptability to new software, advanced use of Excel (VBA, macro, formulas, functions, and pivot tables) to design, optimize and maintain effective analysis reporting structures that are easy, quick and extremely efficient to use.
Mar 2011 - Present
Analysis responsibilities include monitoring stores category sales, supervising physical inventory, identifying trends, and monitoring the timing and scope of seasonal changes. Maintain desired inventory levels and assortments, oversee warehousing of merchandise.• Identified and corrected inventory categorization and coding structure• Reorganized and structured inventory storage and organization to utilize space and ease access to products• Performed physical inventory to recapture lost, and dated inventory
Dec 2008 - Mar 2011
Finance / Bookkeeping / Payroll
Responsible for directing the organization’s accounting and bookkeeping functions, financial policies as well as providing analytical reporting and support to both our management and sales team.• Establishing and maintaining accounting principles, practices, procedures• Implementing internal control features• Maintaining all records of business transactions including general ledger and financial reporting.
Apr 2008 - Dec 2008
Accounts Payable Clerk
• Review and processing of vendor invoices, wires, pre-authorized payments, cheque requisitions and petty cash fund.• Additional responsibility of ensuring all clerks provide copies of monthly void cheques as well as processing of employee recognition awards.• Ensure proper invoice documentation is attached as per Finance policies.• Timely processing of utilities, GST, property taxes• Created spreadsheets to track payment progress and timeline from invoice to cheque.• Created department templates.
Apr 2007 - Oct 2007
Accounts Payable Clerk
• Review and process vendor invoices.• Ensure proper invoice documentation is attached as per Finance policies.• Designed spreadsheets to facilitate accuracy and efficiency for cheque approval and matching as well as strengthening visibility prior to cheque approval.
Oct 2005 - May 2006
Cost and Payroll Analyst
• Providing financial support to non-financial manager.• Monthly financial reporting and analysis of all stores costs and payroll.• Monthly cost reviews with senior head office managers.• Assisted in monthly reforecast of central cost base.• Assisted in annual budgeting.• Set monthly sales team incentive bonus targets.• Built and developed forecasting tools for non-financial managers.