Sales Accounting
Resume:
Mark Ferguson
Simi Valley, CA 93065
E-mail: *****************@*****.***
Profile
____________________________________________________________________________
__
Experience includes financial statement reporting within GAAP guidelines,
SEC 10-Q and 10-K reports, and month-end and year-end closings. Held
comprehensive field experiences with several companies, including
government accounting using CAS and FAR. Assisted external auditors with
year-end financial issues. Analytical, organized, and thoroughgoing
professional with an enthusiasm for accounting.
Key Accomplishments
_______________________________________________________________
. Recommended discontinuation of investment in outsourcing IT functions
for Pratt Whitney Rocketdyne due to cost study comparing before and
after effects of outsourcing IT functions. The result was the
discovery of $21,000,000 of potential cost savings.
. Completed a closeout on a delinquent government contract. The missing
documents were obtained, verified, and corrected which enabled Boeing
to recover over $400,000 in overdue accounts just before the
expiration deadline.
. Reconciled out-of-balance cash accounts to the general ledger for MAI
Systems Corporation, which were previously several months behind. The
general ledger accounts were updated in time for the year-end close
for the first time in three years. Audit time was reduced by 10%,
leading to a direct cost savings of several thousand dollars in audit
costs.
Professional Experience
___________________________________________________________________________
Accounting Experience
. Prepared journal vouchers and used queries on SAP as part of monthly
closing cycle. Also used Business Objects Live, VLookup, SUMIF, and
Pivot Tables in preparing monthly closing reports and schedules.
. Implemented process improvements to improve monthly close. Developed
Business Objects Live queries and pivot tables on three different job
tasks to reduce processing time by at least one day during our monthly
closing week. This amounted to a ten to twenty percent time
reduction.
. Prepared business analysis model to calculate company's valuation
using Harvard Business School prototype. Calculated key financial
ratios such as Return on Assets, Return on Equity, and Costs of Sales.
. Used Access queries to extract booking and billing data from MAS90
accounting system to determine quarter-end and year-end revenue
recognition. Interpreted data from sales contracts and sales orders
to determine period of performance related to revenue. Apprised
management of any data gaps. This information was later transferred
into an Excel spreadsheet for the final version.
. Prepared overhead cost claims for submittal to DCAA auditors.
. Prepared GAAP financial statements, general ledger entries, and year-
end audit responses on a timely basis. Answered management questions
as to income statement expense variances. Helped meet reporting due
dates in a timely manner.
. Analyzed moving average calculations to prepare cash collection
forecasts of A/R customers.
. Drew up AR and collection procedure flowcharts using MS PowerPoint and
MS Excel, to illustrate technical workflow report.
. Rated consultant's accuracy in forecasting future sales bookings by
using Access queries to pull records from MAS90 sales order
information.
Mark Ferguson (Continued)
. Tagged, labeled, and reconciled fixed assets to general ledger.
. Assisted Vice-President of Finance and Controller in preparation of
two consecutive annual budget presentations for company managers.
Added new accounts to the chart of accounts when necessary to input
budgeted amounts into the financial statements. Input and reviewed
revenue contracts on SAP system.
. Audited inventory cycle counts to assist in reconciling differences
between physical and perpetual inventory.
. Translated foreign branch financial statements and completed foreign
branch bank reconciliations using foreign currency exchange rates.
. Visited with clients and used e-mails, scans, and faxes to collect
$2,500,000 in Accounts Receivable in a 30 day period to bring the A/R
balance to a near current status. Set up A/R accounts on MAS90.
. Allocated cost to work orders for final billing and shipping using
average costing method on AS400 system. Also trained an accountant
and a clerk to allocate cost. Booked purchased inventory into stock.
. Ensured that Accounts Payable suppliers were paid on a current basis.
. Implemented a conversion of the check and credit card payment system
to the "Eclipse" terminal from TeleCheck. This conversion speeded up
the availability of cash, minimized exposure to NSF checks, and
allowed for sales of $160,000 related to the addition of AMEX and
Discover cards. Produced job cost postings, A/P, A/R, deposits, and
billings.
. Supervised 3 inventory clerks in project to determine inventory order
quantities to submit to corporate headquarters.
Contract Analyst Experience
. Processed contract closeouts on completed projects.
. Assisted with physical inventory count related to aerospace parts.
. Performed burden rate analysis and used FAR guidelines as applicable
to contracts.
. Input contract revenue and reviewed contracts on SAP system.
. Set up gas contracts in AS400 system as new business developed with
oil and gas suppliers.
. Updated gas temperature measurement (BTU's) as they were supplied by
gas field meter reports.
. Corrected contract payment rates where appropriate.
Employment History
____________________________________________________________________________
___
. Pratt & Whitney, Accounting Analyst (Contractor), Canoga Park, CA
2009 to 2010.
. Robert Half/Ajilon, Sr. Accountant/Financial Analyst, Orange and
Ventura County, CA 2005-2008
. Brussel Consulting, Controller, Costa Mesa, CA 2005
. Porcelanosa, Staff Accountant, Anaheim, CA 2004-2005
. Used Car Restoration, Self-employed, Garden Grove, CA 2002-2004
. Consulting Engagements, Staff Accountant/Analyst, Los Angeles and
Orange County, CA 1993-2002
Education
________________________________________________________________________
Bachelor of Science in Accounting, William Jewell College, Liberty, MO, May
1981 Major: Accounting
Computer Skills
______________________________________________________________________
SAP, MS Office, Windows, Excel, Access, Word, PowerPoint, Outlook, Mas90,
Business Objects, Hyperion Financial Management, and Great Plains
Contact this candidate