Michael Valenzuela Email & Phone Number

Plano, Texas, United States

I help my clients reach their goals, streamline operations and solve problems.

Dallas, Texas, United States

I help my clients reach their goals, streamline operations and solve problems.Client #1 - Backfilling for the Assistant Controller, reporting to the VP/Controller. Preparing for & supporting the external audit. Investigating and "cleaning-up" for various key balance sheet account reconciliations. Completing the backlog of US Government reporting. Assisting with the re-implementation of Blackline, to monitor the completion of Account Reconciliations.

Frisco, Texas, United States

I help my clients reach their goals, streamline operations and solve problems.Client #1 - Project to recalculate COGS & validating Net Sales for a 2-year time span, preparing the client for an ERP implementation.Client #2 - Supplemental staffing for a multinational medical device corporation, as a Senior Financial Analyst. Created documentation (desktop procedures) for daily, monthly, quarterly & annual tasks. Identified procedural gaps and provided long-term solutions. Also assisted in hiring & training new staff members.

Grand Prairie, Tx

Assisting with the migration from Pollock’s SAP to Orora’s SAP, as Pollock was purchased by Orora Limited in November 2018.Independently prepare daily revenue & production reports, all period-end journal entries, financial & KPI reports for Packaging Division. In addition to correcting AP invoices with GR/IR issues.Review, analyze and update the standard costing for manufactured items on a daily basis.Troubleshoot production order issues in SAP’s Production Planning (PP) module and review all manufacturing orders to ensure they are processed correctly.Leading the implementation of the inventory cycle count process. Working to achieve 98% accuracy.IT Business Process Champion (BPC) for Pollock Packaging Division

Irving, Texas

* Leading the transition of Prime’s Pharmacy Accounting during the formation of the Joint Venture with Walgreens.* Managing a six-month project to retire members’ Account Receivable accounts, hiring and supervising twelve contractors and establishing the template to review all 200,000+ member accounts.* Awarded Employee of the Quarter for successfully addressing Internal Audit findings regarding inventory controls and accounts payable.* Collaborated with Pharmacy Operations Director to create an inventory cycle count process, which improved the accuracy of cycle counts from 81% to 98% within six months, and eliminated KPMG’s need for a full year-end physical inventory.* Standardized Balance Sheet reconciliations, which led to the elimination of aged items, identified $0.5mil of missing revenue and a multi-million dollar Payables adjustment.

Irving, Texas

*Accounting Business Lead on SAP Wave 2 Implementation Project, which focused on Inventory and Accounts Receivable.* Project cancelled in order to concentrate on other strategic initiatives.

Dallas/Fort Worth Area

* Created templates for Balance Sheet Account Reconciliations to accommodate the recent SAP implementation.* Worked with IT to make improvements to the SAP Financial Accounting reports and Fixed Assets operations.* Provided SAP end-user training & documentation to offshore Accounting staff.

Irving, Texas

Accomplishments:* Collaborated on various cross-functional projects that improved Key Performance Indicators (KPI’s)* Managed the Accounting Team and provided continuous feedback & developed staff for their career development.* Implemented various process improvements that addressed deficiencies noted by Internal Audit as the Account Reconciliation Global Process Owner. * Created the Global Peer Review process for Balance Sheet Account Reconciliations to address quality issues across 3 accounting centers globally.Overall:* Managed the financial reporting for 19 US based Legal Entities, 10 production facilities, and reviewed over $1.5 billion in annual 3rd Party sales and $550 million Plant, Sales & Administrative and R&D expenses.* Directed and coordinated the daily activities of 12 Inventory, G/L and Plant Accountants and coached staff to perform variance analysis that provided meaningful explanations of financial results.* Improved department expense reporting & analysis by using SAP’s Business Intelligence (BI) solution, which reduced the preparation time of the monthly forecasts and annual budget.* Supervised transition of the Fixed Asset and Intercompany accounting functions to offices in Budapest & Shanghai.* Developed procedures to disclose aged items on reconciliations and supervised the implementation of Trintech's AssureNET software to provide further controls over the Balance Sheet Account Reconciliation process.* Applied the Root Cause Analysis (RCA) process to recurring month-end issues and expanded corrective action plans to become more sustainable; one example is the creation of Accounting Quick Guides for common transactions.* Coordinated the college recruiting effort at UT Arlington and participated in the career fairs at University of North Texas and University of Texas at Dallas.

Dallas, Texas

* Collaborated with Internal Audit to develop a Corrective Action Plan for material weaknesses identified in the Account Reconciliation process. Accepted the role of the Account Reconciliation Global Process Owner (GPO). Oversaw the reconciliation of over 2,200 account reconciliations monthly, utilizing the tools from Trintech's AssureNET software.* Coordinated the Year-end external audit PBC’s for the US and Canada accounting operations.* Supervised Inventory, G/L and Plant Accountants to ensure month end closing deadlines were met.* Performed variance analysis of the P&L reports with Business Line & Site Controllers during month end close to ensure accuracy.* Continuously evaluated job performance of accounting staff for process improvement opportunities.* Utilized Microsoft OneNotes to create desk procedure manuals.

Dallas, Texas

* Prepared the Fixed & Variable cost budgets & forecasts for multiple manufacturing facilities.* Reviewed and analyzed moving average inventory cost to ensure accuracy.* Analyzed actual results versus forecasts and prepared the monthly reporting packages for senior management.* Standardized the reporting process for manufacturing sites using SAP’s Business Intelligence module. This reduced the preparation time of the management reports from 2 days to 1 day after financial close.* Organized all relevant data for the preparation of the Monthly Forecast and Annual Budget for the Plant and Energy costs for the manufacturing facilities, in addition to the SG&A and R&D costs.

Dallas, Texas

* Prepared journal entries and reports to be reviewed by management.* Prepared Balance Sheet account reconciliations with variance analysis of key items.* Improved reporting to plant personnel by reducing non-value added reports and creating new reports in SAP. These improvements led to efficiencies in the monthly forecast process, as well as the annual budget process.* Collaborated with Site Controller and Project Managers to reduce month-end closing process from 5 to 3 days.* Became the SAP Subject Matter Expert (SME) for Cost Center Allocations and provided training to other departments.* Created an SAP Beginner’s Manual to help expand the SAP knowledge of the department.

Irving, Texas

* Recruited to provide functional SAP Inventory & Accounting expertise. * Collaborated with Logistics Operations and IT Programmers to prepare the implementation blueprint documentation, but the project was cancelled.

Richardson, Texas

* Eliminated the need for annual physical inventory (2-day warehouse shutdown) by demonstrating how the Cycle Count process in SAP’s Warehouse Management (WM) sub-module would provide continuous updated inventory balances to the Logistics & Warehouse management team. PricewaterhouseCoopers (PwC) reviewed and approved method. * Reduced the turn-around time to create various inventory reports from 2 days to 1 day by utilizing SAP’s Business Warehouse (BW) reporting. These reports also assisted the Planning Department in determining the proper course of action for aged inventory.* Tracked aged inventory, identified concerns, and worked with Supply Chain and Product Managers to resolve issues.* Managed the Moving Average Costing function of SAP to value inventory.* Coordinated the physical inventory count at 3rd party distribution centers.* Participated in many special projects that focused on process improvements to streamline inventory controls, using SAP.* Received Warehouse Management Certification and became the SME for Business Warehouse Reporting.

Irving, Texas

* Calculated manufactured and purchased inventory using Standard Costing.* Selected to be a member of the SAP Implementation team, concentrating on Purchase to Pay, including Inventory Management. This cross-functional team upgraded the Finance & Controlling modules from 3.0 to 4.6 and implemented the Sales Distribution & Inventory modules in 1999 at all of the DFW & Houston production and warehouse facilities. In 2001, expanded SAP into the newly acquired San Antonio operations.* Prior to these SAP projects, the preparation of month end reporting for all product inventories at the two production and eight distribution facilities in Texas were performed by 3 staff members over 3 days. Utilizing the new functionality allowed the completion of all the inventory & analysis reporting in 1 day.

El Paso, Texas

* Maintained standard product cost using JD Edwards ERP* Organized annual physical inventory at the 5 production facilities in Mexico* Prepared monthly financial statements for the regional President’s Monthly Report