Juan Carlos Zorrilla, M.S. Email & Phone Number

Smithfield, Virginia, Us

Boca Raton, Florida, Us

- Created comprehensive cost model for all products moving through the Supply Chain using LLamasoft Supply Chain Guru. - Used SQL and PowerBI to report on cost model and help drive appropriate product pricing and bottom line results.- Created pricing structure for external customers as part of Supply Chain Services contracts- Collaborate with merchants and demand planners to have the best possible assortment at the DCs while minimizing inventory and transportation costs

Foster City, California, Us

- Coaching. Managed consulting engagements with large customer for solutions of complex supply chain network design problems using LLamasoft’s Supply Chain Guru software. This involved coaching both the customer and the internal analyst working on the tool.- Training. Delivered multi-day supply chain design training to our customers.

Boca Raton, Florida, Us

-Development of stocking strategy for Distribution Centers.-Collaborate with merchants and demand planners to have the best possible assortment at the DCs

Boca Raton, Florida, Us

Provided analytics & reporting support to the Pricing and Merchandising functions. Model and analyze different business processes (Pricing, Promotions, Clearance, Assortment...) to provide business intelligence and recommendations for improving sales and margin.- Developed methodology for forecasting base sales and lifts as a result of promotions.- Generated reports explaining YOY differences in sales including, promotions, clearance, weather, ad circulation, and other factors- Tracked excess inventory risk in retail stores as a result of quarterly promotional activity

Boca Raton, Florida, Us

Worked with a team in the development of a process to consolidate last mile deliveries between Office Depot and Office Max after the merger of the two companies. Process included development of cost model for private fleet, definition of delivery areas, carrier RFP, and final mode selection.

Boca Raton, Florida, Us

- Worked in inventory management, primarily tracking excess inventory and developing strategy to reduce it.- Worked in development of a new approach to stock balance product in retail supplies by executing transfers between stores and saving the company an estimated $5 Million dollars of average on hand inventory annually.

Medford, Ma, Us

- Consultant working on economic evaluation of freight transportation projects.- Multimodal traffic flow forecasting

Medford, Ma, Us

Ms, Transportation Engineering/Economics

Ba, Mathematics, Business Management

High School

Certified Professional In Supply Management

Gaming The Supply Chain Program