Stuart Dunlap Email & Phone Number

Work closely with business stakeholders to understand current operating constraints, developing analytics solutions that address key opportunities.

Key Accomplishments:• Analyzed financial impact associated with key distribution initiatives such as, expanding the footprint of a 16 Distribution Center grocery network, increasing freezer capacity, lowering transportation cost and improving warehouse efficiency.• Automated P&L management processes to improve budget quality, providing a more equitable plan in a shorter time frame. Improved the efficiency of P&L variance analysis and provided actionable insights relating to key cost drivers.• Prioritized opportunities to reduce landed cost as part of an overall initiative to increase control of inbound freight.• Designed report dashboard using Tableau that covered all aspects of distribution operations.

Key Accomplishments:• Developed pricing structure for all verticals in the verifications business line. Applied value pricing concepts that enhanced revenue performance for all distribution channels.• Designed pricing governance structure to ensure the implementation of strategic pricing objectives. • Created a revenue reporting system that improved insight into the effectiveness of pricing initiatives.

Key Accomplishments:• Created Retail Planning & Analysis tool to manage department store channel business. In first year of use, allowance payments to retailers decreased $3.0M. National Accounts Manager commented to me: “you played a key role in enabling us to reduce our allowance payments”. In second year, allowance payments declined another $1.7M and margins increased 1.6 points.• Standardized blended margin forecasting process for branded wholesale divisions, providing visibility to planned line profitability and raw material requirements. • Developed system to make purchase recommendations based on POS forecast, inventory policy and pipeline supply. Designed needs-based sizing algorithm to facilitate more precise requirements at the sku level.• Partnered with Merchandising and Far East Supply Planning teams to create a capacity planning system used to reserve factory space for wholesale divisions.• Coordinated legacy to SAP data migration efforts for SAP Vendor Master, Purchase Info Record and Customer Sales Order objects.

Key Accomplishments:• Managed route planning for Delta’s Cincinnati hub and Shuttle operations; revenue for both entities was $2.4BIL. Performed financial analysis to drive aircraft allocation decisions.• Invented summer season premium product designed to shift volume to a more lucrative product class, generating revenue of $2.75MM. Success of this product led to expansion into other seasons/channels.• Established rapport with sales department and outlined a framework for incorporating pricing objectives in the sales planning process. Worked with Sales Team to create a profitable product targeted at New York City International business travelers.• Led Delta’s Network Analysis departmental efforts to implement Sabre's state-of-the-art fleet assignment optimization model.• Analyzed the financial impact of multiple scenarios to restructure the schedule at Delta’s Dallas-Fort Worth and Salt Lake City hubs. Both restructures combined generated a savings of $300MM annually.

• Analyzed network-wide sales volume and reassigned production requirements to free up 1.4MM barrels of packaging capacity (3.2% annual increase), enabling deferment of $30MM capital investment.• Ran material requirements planning optimization model used to manage $100M annual transfer expense budget. Evaluated cost savings associated with inventory policy adjustments. • Administered focus factory initiative for network of 12 breweries. Used ABC inventory analysis to drive sourcing decisions. Prioritized packaging projects to ensure appropriate levels of production flexibility; capital expenditures ranged from $30M to just over $35MM.• Outlined innovative inventory strategy for CEO.• Analyzed product supply for over 900 products for 16 wholesalerships. Earned “Best Forecaster” award first year on the job.• Designed initial MRP system for brewery in Wuhan, China.• Initiated product portfolio rationalization. Proposed brand/package substitutions, leading to the elimination of 57 slow-moving products while increasing service levels.

Mba, General Business - Finance Emphasis

Neuwoehner Prize recipient - Awarded by faculty to one student for classroom contributions and excellence in preparing written papers.

Bs, General Management

Activities and Societies: Undergraduate Teaching Assistant - EconomicsGraduated with Distinction

Bs, Restaurant-Hotel Management

Activities and Societies: President - Eta Sigma Delta Honorary SocietyGraduated with Distinction