MICHAEL G. JOHNSON
San Jose, California
**********@*****.***
SUMMARY:
• Drive process improvements to improve efficiencies & controls.
• Strong grasp of GAAP accounting principles
• Ability to professionally respond effectively to inquiries or complaints
• Ability to work in a fast-pace, rapidly growing company COMPUTER SKILLS:
• NetSuite, Oracle 11i, SAP, Quickbooks, Concur, Expensify, Microsoft Word, Excel
PROFESSIONAL EXPERIENCE:
2017-Current PsiQuantum Corp-Palo Alto-(Netsuite) – AP Manager, Accountant
• Process vendor bills P-Z. Usage of 3-way match process. Responsible to resolve all invoice discrepancies. Reconcile vendor statements.
• Prepared AP activities reports, created spreadsheets and distributed to Management.. Heavy excel use, vLookup, Charts, etc
• Address issues with Purchase Orders including Price Variances, Quantity match holds, Approvals, etc.
• Reconcile 10 monthly credit card transactions and create related journal entries for csv upload.
• Prepare manual monthly Accrual file & scrub all outstanding charges for duplications, errors,etc
• Process all Expense Reports submitted in Concur Exp Management system. Update changes with employee departments, projects, location, etc. Average 175-200 expense reports monthly.
• Ensure clear and updated communications with all departments regarding AP policies and procedures, work with managers to make processes efficient
• Assist with yearly audit. Work to respond to Auditor requests, pull of backup, coordination with vendors.
• Run weekly check & wire transfer payments during Manager absence. (Identified available unapplied credit memo’ & worked to have all applied or refund provided).
• Create Supplier sites for new Domestic & International vendors/employees,etc. Maintain sites.
• Work with vendors regarding Stop Payments, Bank Notification and issuance of replacement check.
• Ensured compliance with all internal processes and procedures according to SOX requirements.
• Review AP Desktop procedures to ensure accuracy.
• Prepared AP activities reports, created spreadsheets and distributed to internal Executives;
Oct 2016 APPDYNAMICS– San Francisco, CA – (NetSuite) –Contracting as AP Supervisor during March 2017. Implementation of new Financial system. Manager (PO/Vendor Management)
• Review and process expense reports & address all employee inquires
• Supervise (3) AP Specialists and provide guidance on AP processes
• Monitor and reconcile AP transactions. Address issues with Purchase Orders including Price
-Variances, Quantity match holds, Approvals, etc.
• Reconcile monthly credit card transactions and create Journal Entries. Heavy excel use.
• Review monthly GL reconciliations
• Reviewed, verified and processed purchase order related invoices.
• Responsible to resolve all invoice discrepancies.
• Prepared supporting documentation and posted journal entries in Netsuite application.
• Prepare monthly reports for management
June 2016- OPORTUN – Redwood City, CA. – (NAV) – Temporary Contractor July 2016 A/P Manager
• Responsible for processing payables for multiple departments
• Maintain vendor relationships through timely payments and excellent service
• Ensure clear and updated communications with all departments regarding AP policies and procedures, work with managers to make processes efficient
• Assisted accounts payable in purchase order (PO) and invoice reconciliation.
• Resolve invoice discrepancies, prepare weekly check run & assist with the AP month end close
• Oversee the employee expense reimbursement and reporting process
• Reconcile AP, Prepaids and Accruals
• Advanced data analyzing and monitoring using live queries and Microsoft Excel Spreadsheets.
• Based upon trend & invoices received, record accruals to achieve a proper cut-off of cost recognition
• Supervise (3) Accounts Payable Clerks, provide training and monitor performance
• Problem solved purchase order issues on pending invoices
• Prepare schedules and reports as needed for Accounting Operations such as Vendor Analysis Report showing the trend of expenses by vendor and provide comments on variances
• Assist Accounting Manager in various projects & external audits as needed Sept 2015 –
BNBT BUILDERS CONSTRUCTION – Redwood Shores, CA. – (Sage) – Temporary Contractor Dec 2015 Project Accountant
• Effectively communicate with Project Managers (PM) and Project Executives (PX), regarding contract documents, change orders and other contract modifications, approvals, and any additional services- related to billing. Create project accounts in the accounting system
• Maintain project-related records, including billings, expenses, sub-contracts and other documents (in an electronic format whenever possible)
• Work with PMs to review and approve sub-contractor pay applications related to a project
• Process sub-contractor check payments and post all cash receipts from owners
• Upon direction of PMs or Accounting Manager, process the transfer of expenses into and out of project- related account
• Investigate project variances and submit variance reports to management
• external auditors, as required
• Perform additional assignments, as directed by the Accounting Manager
• Communicate and coordinate with the Corporate and Field offices
March 2010 - ERICSSON TELECOM– Pleasanton, CA. – (SAP) – Layoff due to removal of scheduled 2015 CX sites. January 2015 Project Accountant – LTE, 2C, 3C, NSB & ETTCS, NTP Auditor & LTE Implementation Manager
• Invoicing ATT for completed constructed Cell sites. Revenue generation by coordinating actualization of milestone dates for cell integrations.
• Verify and maintain accuracy of EF&I project trackers identifying standard costs for materials, labor, overhead and change order costs in response to SOW adjustments. Create Purchase Order requests for ASP bids & cell site inventory.
• Drive financial reporting to ATT Project Managers & Ericsson management for billing of construction completed telecom sites. Heavy usage of excel to provide daily reporting of milestones completed.
• Provided detailed analysis of issues preventing CX completion.
• Created Purchase Orders for cell site SOW including inventory, services, licenses, etc.
• Hold meetings with client to discuss & review outstanding PO’s, ASP change orders & resolution of pending disputed cost variances regarding rescoping of cell sites & consideration of contract agreements.
• Analyze actual SOW and other related costs & prepared requests comparing actual production costs to billing price.
• Solely responsible for ordering of LTE site Scripts, identification of issues, pursuit of resolutions either internally or involvement of customer War Room.
• Development & documentation of cell integration processes, controls, policies and procedures. Sept. 2006 – CISCO SYSTEMS INC. – San Jose, CA. (Oracle 11i) - Temporary Contractor Feb. 2007 Accounts Payable Accountant
• Responsible for resolution/problem solving of over 90 days old Vendor invoices. Identify items requiring application of Credit Memos,etc. Resolve issues with: Manual holds, Price Variances, Approval required holds, Distribution Variance Holds, etc. Correct EDI errors for summary invoices. Previous companies:
ADOBE SYSTEMS, INC. - San Jose, CA. (SAP)
Accounts Payable Specialist
• Responsible for inputting, editing & posting invoices for vendors, (M – R)
• Reconciled vendor statements and brought majority of accounts to current status.
• Maintained Petty Cash accounts for (8) separate sites including auditing receipts, reconciling to Balance Sheet and downloading to General Ledger.
EDUCATION:
College of San Mateo
San Francisco State University
Major – Marketing