Matthew Rodrigues

Summary

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.

Work History

Work History
Mar 2011 - Present

Financial Analyst

2nd Time Around Tire Sales

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

2nd Time Around Tire Sales

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

Oxford Properties Group

• 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

Town Shoes

• 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

Selfridges

• 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.

Education

Education

Skills

Skills

Accounting Programs

ACCPAC, Great Plains, JD Edwards, Business Vision, Simply Accounting, ERP, SAP

Microsoft Excel

Excel Specialist  Maintains, manipulates and troubleshoots excel spreadsheets containing complex formulas and macros used to support planning. Responsible for manipulating data within spreadsheets to create reports, analysis, graphs, charts in excel. Develops new features, pivot tables, formulas, charts, graphs within spreadsheets. Has ability to identify and resolve formula/data issues within tight timeframe with 100% accuracy. Using functionality of extracting data to be used in spreadsheets for analysis and reporting.   - 7-9 years of experience with complex excel formulas; experience with excel version 2010 required  - Experience with excel macros, excel formulas, VB coding, pivot tables, charts, graphs and conditional formatting  - SAP and Cognos experience  - Experience working with complex data sequences