Mitchell Zavaleta Email & Phone Number

San Jose, California, United States

San Francisco, California

• Received and gained valuable experience on Oracle Cloud Fusion and EBS R12 implementation for modules: General Ledger, Accounts Payable, and Accounts Receivable.• Gathered and write business requirement documents for reports and interacted with business partners and project team members for developing reports.• Developed and delivered end-user documentation and training materials for OTBI and BI Publisher.• Knowledge on Order-To-Cash, Procure-To-Pay and Record-To-Report functional and implementation on EBS and Oracle Cloud (SaaS)

San Jose, Ca

• Support and delivered Quarterly Business Review packages for review by senior management in the Operation organization.• Interacted with Operations organization and FP&A team about monthly/quarterly budget, forecasts and variance analysis on OpEx and CapEx.• Developed and executed automate weekly reports related to inventory, receipts, and open POs against the Ending Inventory and Envelope budget; including estimated cash flow based on receipts and open POs.• Support and delivered department spending QBR and forecast process working directly with Operation organization to review and finalize the assumptions for headcount, CapEx, travel and other spending items. • Assist and prepare Gross Margin bridge analysis and QBR forecast for Controller’s meeting. • Developed and maintained monthly/quarterly Standard and Gross Margin Model and reporting that delivered key insight into the business organization.• Provided slide and attended Operations organization staff meeting and review weekly operations package for QTD inventory and total projected receipts vs. the Approved purchase envelope.• Managed approvals on department expenses, Capital Expenditure, Headcounts and Inventory purchases; including reviewing the product codes on the POs to ensure they are correct.

San Francisco Bay Area

•Lead and managed a team of Business Analysts for raising productivity standards to new levels.•Ability to manage a number of simultaneous projects, demonstrate a sense of urgency and ownership to drive projects to completion and be successful in a collaborative environment.•Functional knowledge of Oracle EBS R12 and Oracle database functionality. •Manage R12 reporting project and participate other projects related to Oracle R12 implementation. •Code, test, debug, and document complex programs to ensure data processing production continue to meet user needs through review, analysis, and modifications.•Function as a mentor to team members and provide guidance and training to less-experienced programmers in order to improve productivity.•Worked closely with the business and assist them in investigations and consuming analytic report metrics on a regular basis using Oracle R12 and OBIEE.•Develop actionable insights from analysis to make recommendations on key business strategies.

San Francisco Bay Area

•Managed team of Business Analysts for raising productivity standards to new levels.•Responsible for creating, and publishing standard and customized reports for Revenue forecast, Order Management, and Supply Chain for Operations team.•Worked with the Executive VP on revenue forecasting and ‘What-if’ scenarios for key revenue assumptions and complex forecasting. •Collaborates with work teams to deliver end-to-end solutions.•Help define and implement new and improved processes.•Work with cross functional organization to provide information and automation (Reports and Dashboards).•Worked with the executive and management to determine reporting requirements on Oracle BI and Business Objects.•Design, develop and implement various business analyses and reporting automation tool.•Help manage the process flows and build capabilities between Order Management, Logistics, and other teams.•Work on the various requirements with OM and IT testing the scenarios and manage the roll out to production.•Provide the necessary support to Fulfillment Managers on their daily and monthly reporting needs by utilizing SQL/VBA/EXCEL.•Documented workflow, dataflow, and process flow by utilizing Vision for flowcharting and diagramming.•Created custom sites in SharePoint for leveraging database information and collaboration solution.•Assist on developing capabilities on operations performance, service, and quality metrics to executive-level management.•Collaborate with cross-functional team to conduct data integrity and documentation in UAT.

•Responsible for Fixed Assets management, including disposals, acquisitions and depreciation.•Prepare Capital Expenditure report, Depreciation Flux and Fixed Assets reconciliations.•Participate with Purchasing and Inventory on the manual process for Capital Expenditure request to automated process.•Responsible for intercompany accounts and reconciliation for Latin America.•Interact with external/internal auditors and provide audit responses as required during the quarterly reviews and year-end audit.•Assist and help finance department on depreciation forecasting, Capital Expenditure, Accruals, and journal entries.•Worked with corporate managers to ensure project accounting business expectations.•Involved with the AP and PO integration of PeopleSoft Financial.

•Responsible for Fixed Assets management, including disposals, acquisitions and depreciation.•Answering questions relating to Fixed Asset & General Ledger policies and procedures.•Prepare Fixed Asset analysis, Depreciation reasonableness & Fixed Asset roll-forward.•Responsible for cash reconciliation and cash forecasting. •Monitor and analyze bank accounts to ensure accurate financial information.•Responsible for maintain and analyze restricted cash and provide detail support for investments purchased and sold during the current quarter for SEC reporting.•Provide reconciliation from broker statement to classification of investments (CE, ST, or LT).•Assist and help monitor intercompany transactions for foreign offices.•Responsible for preparation of property tax reports.•Creation of queries for Accounting and Finance use.•Prepares journal entries and balance sheet account reconciliations.•Maintain Balance Sheet and Audit Schedule login binder.•Responsible for reviewing reconciliation and processing expense reports. •Responsible for AP management, including AP aging report and reconcile various balance sheet accounts.•Review of employee expense report for compliance with company guidelines.•Generate and maintain reports for AP and expense reports. •Provide guidance to other A/P specialists, including system troubleshooting.•Responsible for consultants assisting with expense report processing.