Tracey Mesarch Email & Phone Number

Naperville, Il

Provided process and analytical support for supply chain business applications systems, including Business Objects, SAP, SQL Server applications, SSIS packages, and mainframe applications. Gathered functional requirements and developed new reports / system enhancements, designed and tested process improvements, advised users on system use, and resolved production problems.• Managed all inventory management reporting requests for legacy OfficeMax which included new report creation and ad hoc reporting requests completed typically within 2 business days, ensuring information was placed into decision makers hands in a timely manner thus allowing for Supply Chain department to hit company goals.• Kept 150+ supply chain reports and processes running post-merger when many co-workers had left the company, allowing key reports to continue to be mailed out to management and planners so department could drive toward service level and inventory goals.• Re-engineered database application used by distribution centers to schedule appointments based on open purchase orders post SAP implementation, permitting efficient goods receipt.• Developed automated invoice matching process for a major vendor for custom print division, allowing for more accurate and timely invoice payments.

Oversaw computer modeling of business operations (over 7M tons of roll stock annually and 27 paper machines) to make recommendations on customer sourcing to maximize contribution for the company. Focus was on minimizing variable costs to achieve strategic objectives using Paper Plan’s linear programming model. Additional modeling responsibilities included analyzing proposed capital projects for return on investment, evaluating proposed containerboard trade agreements with other manufacturers in the industry, and analyzing potential asset management decisions.• Saved over $25M by moving customers to lower cost manufacturing locations based on model recommendations.• Acted as Business Lead on roll-out of centralized mill scheduling software, ensuring new software was implemented with little service interruption.

Maintained demand-supply balance model along with all inputs and analysis needed to ensure a balanced mill system. Duties included reporting to executive management the state of operations, data analysis, and various ad hoc data reporting of various supply chain computer systems.• Participated on linear programming implementation modeling team that was awarded the 2007 Performance Excellence Team Award, nominated by department VPs and C-level management reviewed and awarded annually.

Enabled e-sourcing events (RFI, RFP / RFQ, and reverse auctions) on behalf of corporate and mill procurement personnel. Implemented contract management software and developed and implemented database used for tracking and reporting department savings.• Presented training to suppliers and buyers, educated users on sourcing best practices, and worked with software provider to develop / test product enhancements, enabling buyers to weigh sections of the event such as payment terms, pricing, and service level to objectively select best overall package based on a buyer’s criteria.• Developed library of standard contract templates for contract generation and created electronic contract repository, managing contract expirations as well as easy retrieval of existing contracts.

Managed suppliers and content of company-wide e-procurement system.• Managed over 5K supplier catalogs with more than 450K items, ensuring items managed by corporate procurement were available to 200+ locations across the company and locations were using the corporate negotiated pricing.• Acted as member of team to transition content management to a 3rd-party vendor, creating portal to allow suppliers to update content.• Developed training programs on e-procurement processes, permitting users to create regional / local e-procurement catalogs. Allowed for data capture on areas corporate procurement could leverage volume discounts in the future.

Bachelor’S Degree, Chemistry

Master’S Degree, Information Sciences

Concentrations in Project Management and E-Business Systems. Graduated with a 4.0 GPA