- Create and distribute US servicing guides displaying lead times and products details of 3 business units to the Sales team across various regions using Tableau.- Ensure product availability for expanding distribution centers for national customers by using Excel to combine various data sources in Oracle Business Intelligence.- Collaborate cross-departmentally with the customer service team to resolve order holds within one business day to ensure timely shipments to clients. Use Microsoft Access to run queries for order holds.- Distribute bimonthly/monthly inventory and performance reports to leadership and relevant stakeholders. The tables display inventory levels across 40+ production plants and graphs display the success metric of Ability to Ship by business unit.- Document standard procedures to facilitate coverage and aid in training of future team members.

– Enhanced reporting infrastructure using Power BI and Microsoft SQL queries to provide team real-time data with visuals from a variety of different sources of over 8 million+ rows to create a cohesive story.– Improved manual cost analysis by creating an automated cost report in Power BI allowing the team to view expenditures by products and vendors. This facilitated fiscal year budget planning and resulted in at least $2,000,000 saved.– Helped create a holistic strategic environment by tracking top, new, and lapsed donors in Power BI. Collaborated across departments resulting in reengaged monetary donors and strengthened partnerships resulting in over $100,000 of additional donated product.– Created a Purchasing Report in Power BI reflecting inventory movement, lead times, and inventory safety stock. This helps ensure supply meets demand by determining optimal quantities of food to be purchased and prevent excess inventory.– Generated a comprehensive inventory report in Power BI to allow the team to view receipts and distributions by SKUs helping save over $5,000 of storage cost.– Worked with stakeholders to understand their business needs and identify opportunities for analysis insight to make data-driven decisions.– Distributed monthly performance Jet report of receipts and distributions to leadership and relevant stakeholders to provide planning and forecasting support.– Organized data in Microsoft Dynamics NAV (Ceres) by updating over 1,000 SKU descriptions to optimize reporting and aid in strategic planning.

– Coordinated logistics to facilitate scheduling and delivery of over 6 million pounds of donated product.– Streamlined Food Rescue data entry process down from 10 to 4 hours by leveraging Excel with data manipulation and pivot tables.– Communicated cross-departmentally to allocate close-coded products and minimize food waste. – Served as the first point of contact for all industry product donation offers.– Documented standard operating procedures to facilitate coverage and aid in training of new team members. Helped onboard new team members.