Imogen Brannigan
Supply planner, consumer products, SAP IBP, SQL and Power BI
Cincinnati, OHimogen.brannigan@example.com(555) 630-4187
Summary
Supply planner with two years at a household products company, planning 340 SKUs across 2 co-manufacturers in SAP IBP. Supply chain management graduate with a co-op in supplier performance and a record of clearing excess inventory.
Experience
Supply planner
Jul 2024 – Present
Mill Creek Consumer Brands · Cincinnati, OH
- Planned supply for 340 SKUs across 2 co-manufacturers in SAP IBP, setting safety stock to hold a 97.6% case fill rate.
- Improved forecast accuracy for 90 laundry SKUs from 68% to 76% by adding promotion lifts to the baseline.
- Reduced excess and obsolete inventory by $310,000 in 9 months by routing SKUs over 20 weeks of supply to clearance.
- Built a Power BI dashboard of days of supply and backorders for 340 SKUs, used weekly in S&OP by 14 planners and buyers.
Supply chain co-op
May 2023 – Dec 2023
Licking River Industrial · Covington, KY
- Automated the weekly supplier on-time report with SQL and Excel, cutting preparation from 6 hours to 40 minutes.
Projects
Capstone: safety stock redesign for a regional food distributor
Excel, SQL
- Modeled safety stock for 600 SKUs by demand variability, showing a 14% inventory cut at the same service target, presented to the distributor's planning team.
Education
Bachelor of Science in Business Administration in Supply Chain Management
Aug 2020 – May 2024
Kenwood State University · Cincinnati, OH · GPA 3.6
Skills
- Planning
- Supply planning, Demand planning, S&OP, Safety stock
- Inventory
- Inventory management, Excess and obsolete inventory, Forecasting, Supplier performance management
- Tools
- SAP IBP, SQL, Excel, Power BI





