Gates Consulting, LLCSelf Employed
Nov. 2004 - Aug. 2021Needham, MAGATES CONSULTING, INC., Needham, MA Independent Financial Consultancy Self-employed full-charge finance professional for small to medium-sized clients reducing need for accounting staff. Responsible for all system implementations, AR, AP, Banking, Tax, Audit, Payroll, Financials, and Statutory reporting. • Managed multiple clients weekly across multiple industries on a wide variety of projects reducing overhead costs and eliminating need for full-time staff. • Supported Presidents/CEOs through financial audits, government audits/inquiries, tax audits/inquiries, and insurance/unemployment matters. • Provided Financial Consulting to the following large Pharmaceutical companies: Otsuka America Pharmaceuticals, Inc. Consultant, FP&A Prepared quarterly financial statement forecasts, annual budget, variance analyses, and explanations keeping leadership informed of required changes. Updated Chart of Accounts and cost allocation model to better suit business’ needs. Ensured accurate accounting of all departmental expenses and allocations. Established Cash Flow forecasts to support Line of Credit Requests. Consultant, Treasury (2012-2017) Directed administration and maintenance of cashflow model in HSF and replication of model in Excel used as a requirements document for future implementations. Updated HSF software for all cash impacts due to major business transitions. Prepared Cash Flow Variance Analysis and Explanation for four affiliates. • Assisted in delivery of cashflow expectations and Line of Credit requests to Board of Directors. Consultant, Financial Planning and Analysis (2008-2012) Provided Capital Expenditure planning including calculation of depreciation for four companies. Planned, implemented and executed creation of Balance Sheet and Cashflow in Essbase. Maintained Shared Services contracts. Consultant, Corporate Financial Systems (2005-2006) Designed and implemented Hyperion Essbase database for forecasting and annual budgeting.