Sales Manager

JOAN GUEVARA ABELL CPA, CGMA

*** ****** *****

SUNNYVALE, CA 94086

Email: *********@***.***

Home 408-***-****

Cell 408-***-****

PROFESSIONAL

EXPERIENCE:

*/**-******* ******* Valley Bank - Santa Clara, CA

Senior Accounting Analyst (Contractor)

. Responsible for International Accounting - India, China, UK -

which includes account reconciliation, month end close,

balance sheet, P&L, Cash Flow Analysis. Assist Controller

with forecast review for the respective international

subsidiaries. Software used: PeopleSoft, Essbase.

7-12-8/12` Wageworks, Inc. - San Mateo, CA

Manager-Accounting (Contractor)

. Account Reconciliations, Variance Analysis, Procedures, Month

end close. Software used: Great Plains.

2/11-6/12 CONTRACTOR-Crystal Dynamics - Redwood City (2/11-11/11), Solar

City - Foster City (1/12-5/12), City of San Carlos, San Carlos

(6/12)

Senior Accountant

. Account Reconciliations, Property Tax Returns Santa Clara and

San Mateo County, Audit Support Schedules, Accounts Payable,

ADP Payroll, Forecast, Budget, Variance Analysis, Procedures,

SOX (Narratives, RCM, Flowcharts, and Procedures), Balance

Sheet, P&L, Month end close. Fund Accounting, Bank

reconciliations, Accounts Receivable. Software used:

Agresso, Oracle, FRX, Expandable, Great Plains, Munis.

3/09-5/10 VISA INC. - Foster City, CA

(Processing Transactions - $2 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. SAB 101.

. Responsible for Canadian Financial Statements including

translation per FASB 52.

. Support documentation for SEC 10K reporting - Revenue.

. Software used: Oracle.

9/06-2/09 HITACHI GST - San Jose, CA

(Disc Drive Manufacturer - $1 billion in Revenue)

Lead Accountant-US

. Prepared Analytical Reporting Package submitted to Japan

Headquarters and all government surveys.

. Responsible for FASB Interpretation and Research - Operating

vs. Leasing.

. Responsible for FASB 146 reporting for US - these included

procedures narratives, MRC, flowcharts, reconciliation.

. Responsible for Account Analysis.

. Prepared Consolidated Reporting Package.

. Assisted in Inventory Audits - Precious Metals.

. Responsible for SOX - Narratives, MRC, Flowcharts. Procedures

for the following processes: Restructuring, Employee

Payables, Payroll, Travel Expense Reporting and Pension.

. Responsible for Intercompany Reconciliation.

. Prepared Balance Sheet Forecast/Budget.

. Responsible for Outsourced AP /AR - posting verification,

month end close (Singapore).

. Conversion from GAAP to International Financial Reporting

Standards for US financial statements submitted to Japan.

. Software used: SAP, Essbase, Business Objects.

12/05-8/06 CONTRACTOR/FINANCIAL CONSULTANT - San Jose, CA

. SEC Restatement 10K and 10Q - preparation and support

schedules (MPS Jan - Feb 2006), Account Reconciliations,

Budgeting, Forecasting, Equity - EPS and Weighted Average per

Share, Audit Support Schedules, Sales Use Tax, Property Tax

Santa Clara County (Encover March - June 2006, Consentry

Networks July - Aug 2006) and Deferred Revenue (Ebay June

2006). Software used: QuickBooks, SAP, Oracle.

(JOAN GUEVARA ABELL)

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.

. Responsible for FASB 146 reporting. This included

procedures, SOX -narratives, MRC, flowcharts.

. Sales Use Tax and Property Tax Santa Clara County. Audit

Sales Tax - Calif.

. Audit support .Ado 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.

. Budget and Forecast

. Responsible for Outsourced AP - (Mexico)

. Software used: Baan, SAP, Hyperion, Oracle, Essbase.

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, VAT returns

and cash flow. SS8 (July 2002) Senior Accountant - Cash

flow, account reconciliation, and year-end audit support.

Software used: Great Plains, SAP, Oracle, and Vertex.

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)

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, and

sales/use tax reporting multi-state (40 states), GST tax, VAT

tax and property tax reporting. Audit Sales Tax - Calif.,

Texas, and North Carolina.

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

. Responsible for 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.

. Equity - EPS and Weighted Average per shares calculation.

Stock administration using Equity Edge.

. Assist CFO with M,D&A and responsible for P&L, Balance Sheet,

Cash Flow - SEC reporting for 10Q,10K, 8K (Centigram

Communications). This included preparation and support

documentation.

. Responsible for revenue recognition in accordance with SOP 97-

2 (ADC, Centigram Communications).

. Software used: Askmanman, Oracle, Great Plains, Vertex, SAP.

8/94-9/96 BELL MICROPRODUCTS, INC., San Jose, CA

(Distributor - $500 million in Revenue)

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.

Audit - sales use tax Calif.

. Managed general ledger, accounts receivable, and fixed

assets.

. Responsible for cash flow analysis and line of credit.

(JOAN GUEVARA ABELL)

. Developed travel expense reporting policy to be used company

wide.

. Assist with preparation of SEC filings 10K and 10Q -

preparation and support documentation.

. Coordinated quarterly and year end audit.

. Supervised and trained staff of four professional

accountants.

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

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.

. 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 Seminars Sept 2000, June 2008, June 2011-

Five years' experience in 97.2 and 101.

IFFS Seminars May 2011, June 2012

PROFESSIONAL

AFFILIATIONS:

Member, American Institute of Certified Public Accountants

Member, Institute of Management Accountants

Member, Washington Society of CPAS

Licensed CPA-Washington State Certificate No.18064

Licensed CPA-California Certificate No. 103454

CALCPA Member

(JOAN GUEVARA ABELL)

TECHNICAL

SKILLS: Microsoft Word, Access, Excel, PowerPoint, ADP Payroll, Ask

Manman Software, Pro Business Payroll, Vertex, CCH, SAP, Baan,

Oracle, Great Plains, Hyperion, Business Objects, FAS,

QuickBooks, Essbase, Agresso, Expandable, FRX, PeopleSoft.

Contact this candidate