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.
• 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.
• 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.
• 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.
• 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.
• 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.

Mba, General Business - Finance Emphasis

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

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