Billing, Payroll

Internationally Certified Les Mills Instructor - certified in six group fitness formats including BodyCombat, BodyFlow, BodyPump, CXWORX, RPM, BodyStep. Also certified TRX instructor.

Support or lead initiatives for special projects and adhoc analysis, developing greater understanding of system and environmental issues in the process. Currently utilize data sources such as IBM Mainframe, Oracle tables, SQL, Access and Excel (incl. pivots, vlookups, links, etc.) to analyze and manipulate large volumes of data for adhoc projects.Support 150+ customized and scheduled report processes for over 30 Supply Chain locations nationwide using a variety of software. Daily support requires familiarity with the following:1. Design and link complex SQL Views/SQL tables/Oracle tables to Access or Excel for further “what if” analysis or rendering (i.e., Hurricane/flood contingency plans).2. Support or adapt existing SSIS, SSRS, T-SQL, Access, Excel, and VBA applications, tools and reporting.3. Manage all processes hosted by Datapump (text editing and scheduling software, replaces custom solutions like WINBATCH).4. Support or adapt SQL tables and Views that update Region Intranet Report/Adhoc pages used by hundreds of users across Supply Chain.Develop custom IT programs to support user system requirements across Supply Chain; perform full system testing and training prior to implementation.Pre-analyze deliverables to anticipate and address negative impacts prior to implementation (push to “Get It Right The First Time”).Provide project vision, and act as liaison to manage and drive project translation to action, either individually or as part of project team. Identify, record, and communicate project team activities, resources and deliverables necessary to meet the business objective.Act as a subject matter lead on projects, providing accurate and timely analysis, design, validation, and documentation of complex systems tasks. Readily share technical and application expertise with others (coach); always looking to learn from others as well to promote creative collaboration.

As Cost Accounting Financial Analyst, provided customer and product profitability analysis for Finance Analysis Department; monitored complex Activity Based Pricing components for six Distribution Centers, recommending improvements / changes as needed. Provided special project analysis for Finance Dept. as needed. In role as Budgets/Strategic Planning Financial Analyst, provided support for development and analysis of Supply Chain Midwest Region's annual budget for income, expenses, and sales ($3.3B wholesale business). Prepared on-going region forecasts and analysis as well as special projects.

Responsible for the systems application development, training, support, management and review of various computer functions and automation projects for both Sales & Marketing and Division including:1. Profitability, Deviation, Sales vs. Plan & MRP reporting abilities for $150MM Surfactants Business2. PPG Surfactants Profit Plan3. Customer / Distributor Pricing4. Cognos Data Warehousing TeamInterface with consultants, programmers, IT and internal departments to devise solutions for internal / external customer concerns and to identify opportunities for maximizing efficiency:1. Realized reduction in customer billing errors by 75% through modification of computer processes2. Increased quality and reduced implementation time of mass customer price increases from 240 man-hours to 203. Created ability to monitor $16MM Distributor Program, and reduced administration time from 35 hrs/wk to 15