JOAN GUEVARA ABELL CPA
SUNNYVALE, CA 94o086
Email: *********@***.***
Home 408-***-****
Cell 408-***-****
PROFESSIONAL
EXPERIENCE:
*/**-******* **** ***. - Foster City, CA
(Processing Transactions - $11 billion in Revenue)
Senior Financial Analyst-North America
. Prepared Contractor Reporting Package - by Vendor, Average
Hourly Rate and Headcount.
. Responsible for Account Analysis - Accrued Contractor
Liabilities - US and Canada Accrued Liabilities - US and
Canada.
. Responsible for Financial Review - Contracts over $500k -
Review Purchase Agreements/Statement of Work for purchases
over $500k.
. Prepared Deferred Revenue Analysis - US, Canada and CEMA by
Contract.
. Responsible for Canadian Financial Statements including
translation per FASB 52.
9/06-2/09 HITACHI GST - San Jose, CA
(Disc Drive Manufacturer - $1 billion in Revenue)
Lead Accountant-US
. Prepared Analytical Reporting Package.
. Responsible for FASB Interpretation and Research - Operating
vs. Leasing
. Responsible for Account Analysis.
. Prepared Consolidated Reporting Package.
. Assisted in Inventory Audits - Precious Metals.
. Responsible for SOX - Narratives, MRC, Flowcharts for the
following processes: Restructuring, Employee Payables and
Pension.
. Responsible for Intercompany Reconciliation.
. Prepared Balance Sheet Forecast/Budget.
. Responsible for Outsourced AP /AR - posting verification,
month end close (Singapore)
12/05-8/06 CONTRACTOR/FINANCIAL CONSULTANT - San Jose, CA
. SEC Restatement 10K and 10Q (MPS Jan - Feb 2006), Account
Reconciliations, Budgeting, Forecasting, Audit Support
Schedules (Encover March - June 2006, Consentry Networks July
- Aug 2006) and Deferred Revenue (Ebay June 2006).
11/02-11/05 SOLECTRON CORP., Milpitas, CA
(Contract Manufacturer - $11 billion in Revenue)
Senior General Ledger Supervisor - Americas Service & Repair
Division
. Month end close for 9 sites.
. Account reconciliation including intercompany.
. Audit support, sales use tax, and tax schedules.
. Ad hoc analysis.
. Forecasting for Service & Repair Headquarters Division
. Sox - Narratives and Flowcharts for the following processes:
General Ledger and Fixed Assets.
. Managed a staff of eight.
. Responsible for Outsourced AP - (Mexico)
12/01-10/02 FINANCIAL CONSULTANT - San Jose, CA
. Year-end audit support, account reconciliations, sales tax
returns, cash flow, ad hoc analysis. Assignments are as
follows: Trend Technologies (March 2002 - July 2002) Senior
Accountant - Year-end audit support, cash flow analysis, and
intercompany reconciliation. Kintana (July 2002 - Aug. 2002)
Senior Accountant - Account reconciliation, intercompany
consolidations cleanup issues, sales tax returns, and cash
flow. SS8 (July 2002) Senior Accountant - Cash flow, account
reconciliation, and year-end audit support.
9/96-11/01 SS8 NETWORKS, INC., San Jose, CA (Acquired ADC - ESD Division
10/01)
ADC TELECOMMUNICATIONS - ESD Division, San Jose, CA (Acquired
Centigram 8/00)
CENTIGRAM COMMUNICATIONS CORPORATION, San Jose, CA
(Manufacturer Voice Mail High Security Software - $100 million
in Revenue - SS8 Networks)
(Manufacturer Telecom Software and Equipment - $ 2 billion in Revenue
- ADC Telecommunications)
(Manufacturer Voice Mail Software and Hardware - $100 million in
Revenue - Centigram Communications)
Assistant Controller (11/98-11/01)
General Accounting Manager (11/97-11/98)
Page 2 Joan
Guevara Abell
General Ledger Manager (9/96-11/97)
. Ad hoc analysis.
. Cash flow forecast.
. Conversion from Askmanman Software to SAP (ADC).
. Mergers/Acquisitions - support schedules and analysis - due
diligence.
. Report directly to CFO (Centigram Communications), managed
staff of six.
. Manage the general ledger, accounts receivable, fixed assets,
cost accounting, accounts payable, payroll, commissions,
sales/use tax reporting multi-state (40 states) and property
tax reporting.
. Full responsibility for preparation of income statement,
balance sheet and cash flow statement.
. Responsible for COGS analysis, Product Lines analysis and
Inventory Trend and Reserves.
. Oversee currency conversion, analysis and consolidation for
four foreign subsidiaries' financial statements in accordance
with FASB 52.
. Coordinate and lead quarterly and year end audits.
. Responsible for cash management and investment reporting -
FASB 115 (Centigram Communications).
. Budgeting and forecasting including variance analysis.
. Assist CFO with SEC reporting including 10Q and 10K
(Centigram Communications).
. Responsible for revenue recognition in accordance with SOP 97-
2 (ADC).
8/94-9/96 BELL MICROPRODUCTS, INC., San Jose, CA
(Distributor - $500 million in Revenue)
General Accounting Supervisor
. Supervise monthly close that included consolidation for three
subsidiaries.
. Prepared monthly reporting package.
. Policies and Procedures - preparation for AR, AP and GL
. Prepared sales/use tax returns and property tax returns.
. Managed general ledger, accounts receivable, and fixed
assets.
. Responsible for cash flow analysis and line of credit.
. Developed travel expense reporting policy to be used company
wide.
. Assist with preparation of SEC filings.
. Coordinated quarterly and year end audit.
. Supervised and trained staff of four professional
accountants.
9/89-6/94 SANDOZ AGRO, INC., Palo Alto, CA
(Agro Biotech/Chemical Manufacturer - $500 million in Revenue)
Accounting Supervisor
. Responsible for monthly close and preparation of financial
statements and related reporting.
. Responsible for General Ledger, CIP and Fixed Asset
maintenance.
. Prepared sales/use tax reporting for California.
. Managed accounts payable and payroll.
. Responsible for budgeting and forecasting for financial
statements as well as preparation of capital budget.
. Supervised staff of three.
3/86-6/89 DSC/GRANGER ASSOCIATES, INC., Santa Clara, CA
(Telecom Manufacturer - $300 million in Revenue)
Senior Accountant
. Performed fixed asset maintenance and related
reconciliations.
. Coordinated and performed quarterly physical inventories.
. Reconciled physical inventory to the general ledger.
. Developed accounting procedures for Fixed Assets.
. Prepared monthly reporting schedules for capital
expenditures.
. Performed monthly/quarterly reporting and accounting for
property taxes.
6/84-9/85 ZILOG, INC., Campbell, CA
(Semiconductor Manufacturer - $500 million in Revenue)
Financial Accountant
. Prepared foreign currency translation of subsidiary income
statement and balance sheet.
Page 3 Joan Guevara
Abell
. Prepared a monthly reporting package including income
statement, product income statement and balance sheet.
. Performed Fixed Assets maintenance and monthly reporting.
. Researched accounts receivable issues related to
distributors' inventories, price protection, and commissions.
7/82-5/84 ACTIVISION, INC., Mountain View, CA
(Video Game Manufacturer - $400 million in Revenue)
Accountant
. Performed monthly reconciliations of various general ledger
accounts.
. Assisted with SEC reporting.
. Prepared sales/use and property tax returns.
Accounts Receivable Supervisor
. Devised and implemented procedures for the billing and credit
memo function.
. Performed monthly accounts receivable analysis.
Billing Specialist
. Implemented the billing function in the accounting
department.
. Established controls for the billing and credit memo
function.
EDUCATION:
San Jose State University, San Jose, CA
BS, Business/Accounting
CPA Exam: Passed 1992
SEC Reporting Seminar June 2000 & Dec 2002
Revenue Recognition Seminar Sept 2000, June 2008
PROFESSIONAL
AFFILIATIONS:
Member, American Institute of Certified Public Accountants
Member, Institute of Management Accountants
Member, Washington Society of CPAS
Certified & Licensed CPA-Washington State Certificate No.18064
Issue Date 11/13/95
Licensed CPA-California Certificate No. 103454
CALCPA Member
TECHNICAL
SKILLS:, Microsoft Word, Access, Excel, PowerPoint, ADP Payroll, Ask
Manman Software, Pro Business Payroll, Vertax,, CCH, SAP, BaaN, Oracle, Great Plains Hyperion, Business Objects, FAS,
QuickBooks, Essbase.