3.9 KiB
The HC Companies, Inc. Twinsburg Ohio 2012-Present $250 million manufacturer of plastic horticultural containers owned by Wingate Partners Corporate Pricing Manager (2019 – Present) Cost Manager (2012 – 2019) Accounting Accounting systems conversion, design & build chart of accounts, set functionality, load history, test & cutover Configure payroll system ledger interface and reconcile all compensation and benefits with disbursements Implement transfer pricing, handle currency translation, and facilitate intercompany activities Accuracy of balance sheet: cash, revolver, notes, intangibles, equity, payroll Accounting for business combination mixed share & asset sale with multi-source consideration Annual cost rolls for 60k part numbers across 4 plants Pricing Lead new pricing function for the company Develop, advocate, and execute price optimization strategy Build credibility & confidence with sales team through commitment, patience, and results Train staff to review all quoted business and apply current pricing guidance 70% price-based revenue growth over 3 years Database & Modeling Develop enhanced ledger to facilitate actionable reporting and clear paths between events and financial impact Build sales dataset and analytics merged with forecasts for the sales team - synced with financial statements Build production dataset and analytics merged with forecasts for the ops team - synced with financial statements Use enhanced ledger to feed material optimization effort generating over 2M in savings Develop Ad-Hoc consolidations and real-time financial statement logic used as the primary finance data in the company Contribute to development of web-based quoting tool that aids sales team in strategic pricing for different scenarios Forecasting Asset-based loan availability forecasting, transform forecasted income statements to detail balance sheet & cash flow forecasts Develop MRP environment for analyzing cost and sales price changes against years of activity forwards and backwards Lead sales, inventory, and operations planning for forecasting and budgeting cycles Develop forecasting tool for each salesperson to submit a full volume-based sales plan and extrapolate to full detail Furnish iterative sales planning model that breaks out all layers of assumption like pricing, mix changes, etc. Turn sales plan into production plan with inventory assumptions and create detail level forecasted transactions PPG Industries, Barberton Ohio 2010-2012 $1.5 billion Optical & Specialty Chemicals division of PPG Industries (NYSE-PPG) Cost Analyst Maintenance of standard costs, cost system, and all period end standard cost processing Annual operating plan coordination & consolidation Provide inventory & account accuracy plantwide (reconciliations, physical inventories, etc.) Mainframe data extraction & manipulation projects for streamlined reporting tasks Support (and implementation) of conversion from old proprietary COBOL system to SAP Ad-hoc and persistent metrics & analysis including customizable product structure explosion Masco Retail Cabinet Group, Waverly Ohio 2007-2010 $1 billion division of Masco (NYSE-MAS) manufacturing assembled and ready to assemble cabinetry Cost Analyst Compiled annual budgets and monthly forecasts for $300MM site Developed std. labor and overhead burden rates and explained subsequent variances Provided support for system conversion and standard cost system implementation Developed and maintained customized BOM explosion program & cost environment Maintained inventory accuracy through analyses and quarterly physicals Developed efficient reporting out of ultra-large databases (billions of records) Ad-hoc reporting of financial and other topics across departments.
The University of Akron BS in Accounting 2002-2006 Technical Experience
VS Code, git version control and collaborating on bitbucket/github, extensive use of VBA for Excel, extensive use of SQL
High level of familiarity with Db2, MS SQL Server, PostgreSQL, PowerBI