Jonathan Fong Email & Phone Number

California, United States

Dublin , Ca, Us

Dalton, Georgia, Us

Milpitas, Ca, Us

Pleasanton, California, Us

Work with scrum team to bring about customer solutions for cloud based financial software.Special FINCLS Assignments include Roll Forward Year-End Balances Transaction Matching and Account Certification.

Mountain View, California, Us

Allocate Amazon Web Services (AWS) expenses across all Intuit Business Units on a monthly basis and reconcile allocations against accounting close. Update forecasts and actuals for Internal Hosting Platform and AWS expenses for all business units using Hyperion Planning.Capture all CAPEX spending and depreciation expenses using month-end transactions files, add forecast spending via purchase requisitions, and assign all spend to appropriate business projects to compare actuals and forecasts to plan.

Austin, Texas, Us

• Manage a team of 5 project analysts to work with Revenue Assurance, Treasury, and Operations Management to forecast $80M+ quarterly global revenue and corresponding gross margin guidance to Executive Leadership Team on a weekly basis. Accomplishments include average quarterly forecast accuracy of +/- 2%, identifying new book-to-ship and unscheduled backlog revenue opportunities, and preventing $3M+ potential revenue erosion on high risk transactions each quarter.• Consolidate and identify the business opportunities from $150M+ backlog from Order Management, Project Accounting Module, and Maintenance and Support Services. Accomplishments in backlog reporting include writing Excel codes/formulas to accelerate backlog data analytics reporting, working with Regional Directors to review and update backlog data in Oracle to eliminate inflated backlog, and collaborating with MIS to improve Noetix reports when Noetix fails to yield accurate data.• Investigate the historical trends on bookings, revenue, and conversion rates for largest Mobile Operators (ex TMO and VZN) and Private Networks (large municipalities) customers to understand their relationships with respect to past and present industry environments across global sectors.

Guelph, Ontario, Ca

• Evaluate investment returns competitiveness for solar project acquisitions through financial modeling of project costs, deferred tax assets (MACRS depreciation), and discount cash flow analysis to determine whether project IRR meets Investment Committee hurdle rate.• Introduce construction term loans or other project finance debt into financial model to optimize financing impact on cash flow waterfall, cash distributions and project returns on equity.• Understand tax equity partnership flip financial model impact on project and cash returns and present findings to project development team.

Jiangsu, Changzhou, Cn

• Create solar project energy revenue financial model using PVSYS energy output for 8760 hours of the year and PG&E Time of Day payment allocation factor to calculate energy yields and revenue for the Utility Scale Project Development team. My energy model accurately predicts the energy yields and pro forma revenue for the consideration of new projects for development or for acquisition.• Manage and successfully obtain $1M reimbursement from US Treasury for Trina’s Section 1603 Cash Grant application for a utility scale project using the Look Through Tax Rule.• Manage the Annual Operating Plans by consolidating departmental budgets into US entity master budget and using the final plan to build budget to actual variance analysis model that reduces production time from one week to less than a day. • Partner with the Project Development team to understand Project Financing and to forecast business unit quarterly projections using the cash flow, balance sheet, and profit and loss models for quarterly project financing and headcount planning.• Lead 2 staff accountants and 1 analyst on US GAAP compliance including calculation of interest on delinquent AR balances, recognition of revenue using SAB 104, estimation of bad debt expense, and booking complex journal entries related to project impairments.• Manage the organization of project documents such as power purchase agreements, conditional use permits, LLC formation, interconnection and EPC agreements for potential project buyers..

Tempe, Arizona, Us

.• Prepare monthly accounting close for Utility Systems Business Group of $300 million in solar projects through proper classification of capital assets and expenses, reclassification of project spend into appropriate general ledger accounts, and reconciliation of project costs to general ledger balances.• Review and determine the appropriate cost element assignments for permitting, legal, engineering, and consulting expenditures related to utility system project developments.• Validate integrity of project data migration from ERP Microsoft Dynamics to SAP and test various SAP project cost plan implementation, taxable income calculations on project sales, and revenue recognition using the percentage of completion method.• Prepare quarterly board slide presentations identifying the top 10 solar utility systems projects on the basis of construction and development costs, land values, and intangible assets via the use of financial models consolidating all First Solar project general ledger spends.• Collaborate with Financial Planning & Analysis to compare project actual costs to budget and investigate outstanding discrepancies for resolution.• Record accruals for Project Management, invoice, and legal spends, expense capitalized assets on impaired projects, and record top side adjusting entries for project and non-project related transactions for reconciliations.

Fremont, California, Us

• Partner with Outside Sales to win business opportunities through competitive pricing and gross profit margin analysis on Document Camera and Interactive Pen sales.• Create sales performance metrics to track product average selling prices, to identify regional sales trends and revenue growth rates, and to compare sell-through revenue relative to quarterly and annual targets.• Forecast monthly revenues via top channel resellers and the probabilities for achieving their revenue forecast targets via financial modeling.• Design methods for accruing approximately $200K in monthly channel partners’ SPIFF, VIR, and MDF expenses, train junior level accountants to perform monthly accruals, and review accrual estimates for submission to the Controller. • Create invoice review process for over $300K in monthly CDW reseller invoices on channel sales back-end rebates and save the company thousands of dollars by identifying erroneous billed expenses in rebate invoice datasets.• Design and update financial models that analyze Document Camera bid success rates by geographical region, by key channel resellers and by sales account managers.• Revise rolling three month revenues and budget expenses forecasts in Taiwan headquarter SAP system to analyze US operational profitability. • Implement price floors in SAP software for internal controls over inside sales operations.

Scottsdale, Az, Us

• Analyze customer sales orders and distribute total sales revenue among product licenses, product maintenances, and professional services in accordance with SOP 97-2 revenue recognition standards. • Investigate complex issues relating to customer product license and maintenance purchases and resolve them after comprehensive discussions with Revenue Manager and business sales representatives.• Analyze channel sales partners’ contracts to determine their effective dates and termination clauses and implement a pricing discount matrix based on all channel partners’ discount terms.• Responsible for booking approximately $13 million in revenue each quarter with attention to sales order details including appropriate sales representatives, product SKU codes, foreign exchange rates, revenue allocations, VSOE list prices, and customer industries for VSOE compliance analysis, sales commissions payable calculations, and sales revenue forecasts.

Chicago, Il, Us

• Performed audits of semiconductor equipment manufacturing SEC registrant’s year-end balance sheet with $212 million in total assets, including confirmation of cash balance, search for potential unrecorded liabilities, verification of fixed assets valuations, and analytic review of accounts payable in conformity with US GAAP standards.• Examined $96 million of revenues recognized in 2006 for a high technology SEC client to determine whether product revenues were properly recognized in accordance with SAB 104 standards.• Analyzed semiconductor equipment manufacturing client’s valuation of $2.6 million in accruals for future warranty expenses on existing product sales and determine whether separately priced warranty service revenues are properly valued in accordance with SFAS 5. • Re-performed, documented, and tested internal controls for Order to Cash, Procure to Pay, External Reporting, Taxation, and Entity Level cycles in accordance with Sarbanes-Oxley Section 404 requirements.

San Francisco, Ca, Us

• Audited quarterly calculations of loss factors for the bank’s allowance for credit losses to provide reasonable estimates for reserves against future loan losses.• Managed the KMV Credit Monitoring System and credit quality reporting and worked with vendors to resolve Credit Monitor software problems that existed throughout the entire organization. • Improved credit analysis of publicly traded borrowers within the bank’s commercial loan portfolio, tracked adverse changes in customers’ expected default frequency scores, and provided guidance to senior executive management on changes within lending segments based on the KMV financial model via internal memos on a monthly basis.• Measured, organized, and recorded the inflows and outflows of criticized credits, net charge-offs, loan growth, and nonperforming assets for submission to the board of directors and senior management.

Ba, Economics

Accounting

Education record