Post Job Free

Resume

Sign in

Accounting Financial Analyst

Location:
Berkeley, CA
Salary:
120k
Posted:
February 24, 2017

Contact this candidate

Resume:

Amro Zidan MBA

**** ******** ***. #**, ********, CA 94705

Mobile 510-***-****

acyzox@r.postjobfree.com

PRINCIPAL AREAS OF EXPERTISE

Senior accounting & financial management professional who has successfully re-tooled & managed processes in cross functional environments as the Operations Manager, or Controller. Technical competency in all areas of project management, strategic planning, accounting & financial management, including: establishing, directing, & managing multiple disciplines and personnel in finance, accounting, operations, auditing, financial reporting, and budgeting, forecasting and financial analysis.

Experienced Finance and Accounting Professional with advanced Navision, SAP, Oracle, Essbase, Hyperion Financial Management applications, QuickBooks, Acc Pac, Excel and Visual Basic programming, modeling, data and variance analysis experience as well as accomplished accounting skills.

PROFESSIONAL EXPERIENCE:

Tesla Inc, San Mateo, CA 12/16-Current

Senior Accountant

Calculated the Most-Used Functional currencies for 70 entities based on examining and analyzing the GLS of Sales, COGS, OPEX, Capital Share, Intercompany, Cash Flow, and Salaries.

Assist in the testing and implementation of new automated intercompany accounting solutions.

Confirm transaction level detail matches between entity pairs for 60+ legal entities.

Classify the intercompany transaction types based on transaction level data, JE types, etc.

Draft Journal Entries to net intercompany payable/receivable balances where possible or write off intercompany balances relating to amounts that cannot be settled due to local regulatory requirements.

Support the Treasury team with cash flow reporting for the global intercompany settlement process.

Execute monthly accounting and internal control procedures surrounding intercompany accounts.

Core-Mark International Inc., South San Francisco, CA

Senior Accountant 06/16-11/16

Generated financial reports using Hyperion and performed Flux analysis to study the fluctuations between periods.

Monitored the accuracy of inventory valuation by reviewing daily reports, monthly analysis, SAP journal entries, and prepared monthly inventory file and comparative inventory report.

Oversee monthly close, AR, AP, and the reconciliation of bank accounts.

Prepared and reviewed monthly account analysis, reconciliation of accounts and posted various journal entries to SAP.

Prepared and reviewed quarterly schedules for consolidations, tax schedules and audit schedules.

Reviewed the monthly operating expenses and allocated the expenses to the right cost centers.

Performed various financial analysis to identify any unusual balances across all entities (US & Canada) and to update the entity controller to adjust the balance of his or her entity.

Adjusted the intracompany balances to ensure the accuracy of the reclassifications.

Helped the auditors by generating needed Ad Hoc reports and conducted bank reconciliations.

Santen Inc., Emeryville, CA (Contract Role) 02/16-5/16

Senior Accountant

Worked with SAP consultants and accounting department to convert the accounting system from Microsoft NAV to SAP.

Reviewing the posting of the account payable invoice into Navision and Following up on invoice approvals.

Approving and auditing the P.Os to ensure the conversion process from Microsoft NAV to SAP.

Helping in the month end close and account reconciliations & roll forwards.

Reviewed & confirmed appropriate approvals for Corporate American Express invoices and ensured the accuracy and integrity of the conversion from Navision to SAP system.

Conducted bank reconciliations and reviewed posting of both AR and AP

IQ Biosciences, Berkeley, CA 05/13-02/16

Controller/ Financial Analyst

Established the chart of accounts and created the applicable GLs for assets, liabilities, equities, income, and suspense accounts based on accrual base.

Monitoring and analyzing monthly operating results against budget.

Analyzing potential areas of revenue, COGS, expenses, and liabilities to establish the break-even point.

Completing monthly forecast and accrual documents for Finance Dep.

Controlling the A/R, A/P, month closing, and processed various Journal Entries.

Using analysis results to make recommendations to improve efficiencies related to business team support.

Conducting the Actual to Budget/forecast variance analysis

Plan, assign and check work assignments

Work directly with vendors to negotiate pricing and maintenance contracts

Softonic Inc., San Francisco, CA 04/12-05/13

Controller/ Financial Analyst

Supervised the company’s accounting and financial reports.

Established analyses tools to manage operating and capital expense actuals vs. forecast and Budgeting.

Conducted month end close, re-classing entries, and accounting adjustments.

Compiled and reviewed budgets for the organizational units using actual performance, previous budget figures, estimated revenue, and expense reports.

Matched the calculated balance against the balance on the Trial Balance.

Simplified the financial reporting package distributed to corporate & external auditors.

Implemented new internal controls over the division’s cost accounting system.

Supervised and calculated the accruals, the commissions on the salaries and medical expenses to charge back the intercompany with those amounts.

Supported and enhanced Essbase Applications for budgeting/forecasting and reporting financials to internal/external company sources.

CompuStar, Santa Clara, CA 04/09-04/12

Controller/ Financial Analyst

Responsible for all accounting activities & financial reporting of this semi-conductor tooling company.

Re-vamped month end close and implemented accounting procedures of close schedule.

Developed cost estimates for programs requiring inputs from various sources and pulling them together in a coherent and logical manner budget development

Monitored and analyzing monthly operating results against budgets.

Participated in pricing proposals for our largest clients, billing and competitive analyses.

Revamped internal control, streamlined the annual budgeting and forecasting process, and carried out the annual budget and related analysis.

Generating Cash Flow Analysis, Present-Value calculations and generating Pro-Forma Income Statements.

Conducting Strategic Management Research and recommending strategies to high tech companies

Cantaloupe Systems Inc., Berkeley, CA 01/08-03/09

Controller

Supervised and conducted all accounting activities including A/R, A/P, payroll, monthly billings, and month closing.

Managed company financial planning and budget management and enforcement.

Monitored and analyzed monthly operating results against budgets.

Direct and coordinated debt financing with outsides companies.

Managed and created time expense policies.

Managed and direct overall company financial obligations to state and federal agencies.

Managed and conducted commission calculations, cash flow reports, and budgeting.

Supervised and monitored the company PO, SO, and inventory shipping & receiving logs.

Generated P&L balance sheet, cash flow and all related reports.

Established the foundations and the tools to enable the finance department conduct all finance analysis and ad hoc reports using Navision.

Prepared financial statements and tax returns including the filing of the monthly sales and Use Tax.

Reduced 20% of the finance department expense by automating and developing complex templates that

Xerox & Various, Inc., Palo Alto, CA (Contract Role - By Spherion) 02/07- 12/07

Financial Analyst/ senior Accountant (contract)

Calculated the prepaid affiliate expenses and the commissions for all 5-company entities including adjustments and accruals of the intercompany expenses.

Serving as the Unit Financial Liaison for departments.

Calculated depreciation for fixed asset and amortization for the capitalized software.

Supervised the merchant bank transactions including debits, credits, charge backs, accruals, merchant fees, declined transactions, and gateway fees

Enabled the company to change the accounting system from cash base to accrual base.

Supervised merchant bank transactions including DR, CR, accruals, merchant fees, declined transactions.

Generated analysis, reports, and entries for capital assets.

Performed consolidations of financials across 5entities with total revenues in excess of 1 billion using Oracle.

Pasta Pomodoro, San Francisco, CA (Contract Role - By AOC- Ajilon) 11/06-2/07

Financial Analyst (contract)

Prepared budgets for the companies’ Bay Area branches

Calculated the financial status for each branch and performed market analysis to determine the strategic placement and timing of new openings or closings

State Board of Equalization, Oakland, CA 10/05 -11/06

Tax Auditor

Calculated percentage of error to establish Taxable Measures

Conducted purchase segregation test to establish the Mark Up % & sales taxable %

Submitted AWP to the State, CPAs, accountants, and taxpayer s to show the audit results

Praxar, Berkeley, CA 7/01- 10/05

Senior Financial Analyst

Prepared and analyzed financial performance reports including Income Statement, Cash flow statement and Balance Sheet. Consolidate operating and capital budgets.

Provided Ad-hoc reports for senior management on issues such as variance analysis, purchase vs. lease analysis and price forecasting models.

Participated in pricing proposals for our largest clients, billing and competitive analyses.

Revamped internal control, streamlined the annual budgeting and forecasting process, and carried out the annual budget and related analysis.

Monitored working capital requirements and collections

Blue Shield of California, San Francisco, CA 06/98-6/01

Financial Analyst

Calculated final Settlements for assigned IPAs and medical groups, sent Positive Settlements to the Accounting Dept., and tracked the Negative Settlements for future evaluations and course of action.

Generated the monthly Capitation Adjustments for both HMO and POS, and produced Reports such as: Stop Loss, Pay For Performance, Settlement Report, and Patient Profile

Reviewed contracts and created Rate Allocation Tables by auditing proposed rate changes in contracts.

Prepared final Wire-Transfer Log and Electronic-Transfer Report for the Accounting Department.

Developed a macro for the company that accurately calculated the 90-day retroactive-payment calculations for both HMO and POS, reducing this monthly procedure averaging 15 hours to less than 5 minutes and protecting the company from potential large financial losses caused through human error.

NEL Inc., Oakland, CA (Contract Role - By AOC- Ajilon) 05/94- 05/98

Accountant/ Financial Analyst

Oversight of accounting & finance organization, which included managing all accounting controls/initiatives, analyzing key business trends/results & establishing the company's financial goals.

Developed the organization budgets and submitted to Alameda County to get the final approval.

EDUCATION

Armstrong University, Berkeley, CA

M.B.A Master of Business Administration - Concentration: Finance /Accounting/ Management

G.P.A 3.65 / 4.0 Dean’s List

Cairo University, Cairo, Egypt

Bachelor of Business Administration

Goethe Institute

Zeugnis Zentrale Mittelstfenprüfung

COMPUTER SKILLS

Navision, Hyperion, Oracle, Essbase, Acc Pac, QuickBooks, Peachtree, FoxPro, Lacerte, and Visual Basic. Advanced Excel. in Excel (including pivot tables, defined names, defined ranges, vlookups, if functions, and sumif functions)

LANGUAGES

Fluent in German, and Arabic,

HONORS

The Hans-Seidel Stiftung Scholarship to study MBA at Dortmund University in Germany

Certificate of proficiency in German-Egyptian commercial studies awarded by the German-Egyptian chamber of commerce



Contact this candidate