North and Midwest Cement Shared Services

Payment of independent milk producers.Account reconciliation.Billing of milk sales to external customers.Tracking diversions of independent producer loads to external customers.Tracking and reporting milk components for Federal Milk Market reporting.Billing internal plants for direct shippers milk received.Automation of data entry by mining data from reports using Excel.Documentation of processes.

Analysis of operating results for plants in region including variance to plan and plan updates.Prepare annual operating plan and Quarterly business plan updates.Work with Dairy Plant Managers to identify areas of milk loss and improve results.Monitor raw material and manufactured product inventory loss and recommend process improvement.Perform business analytics including VMR analysis, data mining in Sales Data Warehouse, and Essbase.Monitored and analyzed volume, sales and margin activity and compared to plan for major customers.Measured and reported progress on sales initiatives for branded and private label products including sales velocity for new products.Measured and reported progress on sales initiatives for branded and private label products including sales velocity for new products.Developed Excel model that automated ordering process for McDonald’s orders reducing effort by 4 hours a week.Contributed to cost analysis of product to respond to bids from major customers.Designed and implemented Excel model that automated process of reconciling warehouse management system to OTC system reducing time from one week to two hours.Lead Houston team improved accuracy of production unit reporting. Reduced production recording errors by 36% by identifying transaction codes that were not mapping correctly and reduced warehouse loss by 56%.Teamed with Region procurement director to build purchasing schedules and automate ordering by pulling historical usage data from OTC and matching to vendor purchases.

Analyzed financial results and reviewed with management on a monthly basis.Prepared journal entries in JDE for monthly closing. Improved process by using JDE models, Excel models and importing OTC system reports to Excel using Monarch.Coordinated activities of a virtual team to develop procedures for monthly balancing of intercompany sales..Developed template for FNR.07 analysis to calculate price/volume variance explanations. Improved balance sheet reconciliation procedures, and increased speed of delivery by two weeks.

Managed Day to day accounting operations for $60 million annual revenue company including monthly closing, accounts receivable, accounts payable, inventory, government assessments, and financial reporting in the retail and wholesale electronics and cellular resale business.Coordinated audit requests and compiled audit memos, and responded to findings.Developed procedures to calculate deferred and unrecognized revenue under SAB 104 and net revenue reporting under EITF 99-19.Developed and implemented impairment testing procedures for intangible assets in accordance with FAS 144. Assisted in General Ledger conversion to Great Plains.

Assistant to Controller in retail/wholesale electronics and Cellular re-sale business, including monthly and year end close, reconciliation of balance sheet accounts, monthly accruals, process documentation, analysis of debt and preparation of financial statements. Performed Sarbanes/Oxley Audit tests for Payroll, Fixed Assets, Accounts Payable and bank reconciliations.Calculated tax depreciation for an acquired company and updated Fixed Asset Master in JD Edwards. Prepared schedule of investments for annual financial statements for a mutual fund company. Updated MS Access queries to extract new securities purchased for quarter.

General ledger, accounts payable, accounts receivable, including billing and collections for water utility, and managing City Hall office staff. Reported financial results and budget variance analysis to City Council and Mayor.Prepared $1.7 million budget for all city departments including public works, police department, water and sewer utilities, general administration staff, marina operation and city pool. Coordinated annual audit and prepared annual financial statements.Analyzed long-term debt alternatives for funding public works and water utility projects.

Supported major account teams for Bell South, Verizon, WorldCom and AT&T, including developing business cases for service offerings and calculating key figures of merit (NPV, IRR, pay-back). Developed business cases including financial models, sales training and customer presentations for On-site service provider (OSP) program and WorldCom channel partner program.Developed Excel models for business transformation program.

Negotiated and administered telecommunications carrier and equipment maintenance contracts.Developed lease vs. purchase analysis for telecom equipment acquisitions. Benchmarked best practices telecommunications key indicators of quality and used information in carrier negotiations.

Supervised six to seven accountants engaged in the verification of invoices for computer equipment, communications carriers, and contractors.Prepared expense forecasts and developed cost pools for Telecommunications ($20 million) and data center ($60 million) and prepared variance analysis for management.