Allan M. French

Sunnyvale, CA • (408) 745-0918 • CloseTheBooks@earthlink.net

Staff Accountant

Skills Overview

Well-rounded mid-level accountant with experience in the Software Development, Semiconductor,
Medical Devices, and Financial Services industries. MS Excel certified. Knowledge of at least
seven different accounting systems. Communicates effectively with MIS and technical personnel.
Readily adapts to changing business requirements and enjoys learning new protocols.

Accounting and Finance

Asset depreciation	Fixed assets ‡	Personal income tax preparation
Bank reconciliation ‡	Forms W2, 1099, 571-L	(unlicensed)
Cash forecasting	Invoicing/Billing	Quarterly payroll filings
Cost accounting	Journal entries ‡	Sales commissions
Credit and collections (B-to-B)	Mutual fund portfolio accounting	Sales/Use tax returns
Expense reports	Payables (incl. A/P auditing) ‡	Surety credit review
Financial ratio analysis		Timecard processing ‡

Resources, Tools, and Software

Access	Lotus Notes / 1-2-3 / Symphony	Quicken ‡
ADP Pay eXpert (“Payex”) ‡	Macros (Excel, Lotus, Word) ‡	SAP R/3 Financials
ASK Manman	MAS-90 (6 years)	Solomon
Bloomberg terminals	Microtique Class	SuperCalc
Dun & Bradstreet CreditWatch	MYOB	VBA scripting language ‡
Excel (8+ years)	Outlook ‡	Windows (3.x thru Win XP) ‡
Internet search engines ‡	PowerPoint ‡	Word ‡
Kleinrock's TaxExpert	QuickBooks (Pro 2002, Premier ’03,	WordPerfect
Lacerte	Enterprise 2004) ‡

‡ Recent experience or advanced capabilities.

Career Highlights

Accounting / Payroll / Special Projects – Encover, Inc., 2005 Mountain View, CA

· Fixed Assets: Implemented procedures for use of QuickBooks’ “Fixed Asset Manager” feature. Trained
accounting staff to use this “new to us” feature.

· HRIS: Made enhancements to company’s “employee information spreadsheet.” This became the primary data
source when the company adopted a database-style HRIS solution.

· Payroll: Handled all aspects of payroll for 70 employees in two offices, using ADP’s Pay eXpert (“Payex”)
online software. Input payroll journal entries into QuickBooks.

· Departed upon completion of assigned projects.

Accounting / Customer Service – C.J. Olson, 2004-2005 Sunnyvale, CA

· Accounting: Computed inventory costs, proposed sales prices for new merchandise, and revised prices for
existing items. Prepared custom reports by exporting standard QuickBooks reports to Excel, then manipulating
them to display desired information. Applied customer payments against open balances.

· Customer Service: Input customer telephone orders, generated invoices, and prepared shipping labels.

· Hired for “winter holiday help.” Was asked to stay through the summer.

Tax Preparer’s Assistant – Tax Office of Thomas L. Kearns, CPA, 2004 Santa Clara, CA

· Prepared client write-ups and preliminary financial statements. Entered clients’ income/expense and payroll
tax data into Lacerte, and generated “preparer’s review copy” of federal/state income tax returns.

· Created full-year bank recs for clients whose checking account records were incomplete or rarely reconciled.

· Updated fixed asset records and prepared Form 571-L property declaration for small-business clients.

Spreadsheet Design Consultant – Project Hired, 2003-2004 Santa Clara, CA

· Created a set of menu-driven and macro-assisted Excel worksheets to benefit this nonprofit organization.

· These tools now track client status and services rendered, help meet the reporting requirements of funding
grantors, and allow staff to focus on providing value-added services by reducing “paperwork time.”

Finance Coordinator – Applied Materials, Inc., 2000-2001 Santa Clara, CA

· Served as the “primary point of contact” between the Accounts Payable and Legal departments. Routed
invoices to attorneys for payment approval. Answered payment status inquiries from outside law firms.

· Created a spreadsheet to efficiently assigned items to the G/L accounts of each business unit. Also developed
a tool to help forecast cash reserves and minimize uninvested funds.

· Employment contract was extended twice (reaching maximum duration allowed by company policy).

Payables Auditor – Guidant Corp. and U.S. Surgical Corp., 1999 Menlo Park, CA

· Investigated discrepancies in raw materials inventory records and associated payments to vendors. Prepared
transaction audit trails, to support vendor refund requests and/or corrections to the G/L.

· Served as a backup whenever A/P staff was short-staffed.

· Offered a second contract when Guidant employment ended (after sale of business unit to U.S. Surgical).

Research Specialist (Tax Dept.) – Hewlett-Packard Company, 1997-1998 Palo Alto, CA

· Extracted fixed asset data from microfiche records, using a spreadsheet to accumulate several thousand
figures. Compiled results were used to compute annual depreciation expenses for all corporate divisions.

· Examined historical sales/use tax returns to obtain figures needed for an internal report.

Portfolio Accountant – American Century Investments, 1989-1996 Mountain View, CA

· Computed share prices (NAVs) for several mutual fund portfolios. Trained new hires in these procedures.

· Served as a liaison between the Portfolio Accounting and MIS departments, enabling coworkers to solve
problems more quickly than by using formal channels to request help.

· Modified formulas and macros to accommodate requirements of each new mutual fund. Verified integrity of
macros used to export journal entries from spreadsheets to the G/L software.

· Reported fund performance and liquidity metrics to investment rating services, trade associations, and SEC.

Education and Honors

BS Degree: Finance / Business Administration, California State University, Chico

Certification: Certified “Microsoft Office Excel Specialist”

Professional Development: Several courses toward a Masters degree. Also, classroom training
in federal income taxation, Oracle Financials, and Microsoft Access

Honors: Three letters of recommendation. An employer’s “Special Achievement Award”

(Updated: September 2005)