Searchable public resume
View resume details

Lena Ortiz

Supply Chain Analyst
Columbus, OH, United States

Professional Summary

Supply chain analyst with 5+ years optimizing inventory, demand planning, and vendor performance for mid-market manufacturers and distributors. Turns messy ERP data into clear reorder policies, cuts stockouts without bloating working capital, and partners cross-functionally to improve service levels. Experienced in S&OP forecasting, inventory optimization, supplier scorecards, and KPI dashboards.

Employment History

Supply Chain Analyst
Midland Forge Components · Columbus, OH
Mar, 2022 · Present
Built weekly S&OP demand forecasts that cut forecast error 18% and reduced expedited freight spend approximately $240K/year. Redesigned safety-stock rules across 1,200 SKUs; stockouts down 27% while inventory turns improved from 5.1 to 6.4. Led supplier scorecard program for 40+ vendors; on-time delivery rose from 86% to 94%. Partnered with finance and operations to align working-capital targets with service-level goals.
Inventory Planning Specialist
Scioto River Distributing · Columbus, OH
Jun, 2019 · Feb, 2022
Owned replenishment for 3 distribution centers and approximately 18K SKUs; cut excess aged inventory 22% in 14 months. Automated slow-mover exception reports in Excel and Power Query; planners saved approximately 6 hours per week. Coordinated seasonal inbound capacity with warehouse operations ahead of Q4 peak; overtime hours decreased 15%. Maintained item parameters, lead times, MOQ settings, and vendor calendars across the planning system.
Supply Chain Coordinator
Buckeye Industrial Supply · Dayton, OH
Aug, 2017 · May, 2019
Tracked purchase orders and ASNs for MRO parts; reduced average PO cycle time from 9 to 6 days. Supported cycle-count accuracy improvement from 91% to 97% with floor leads. Reconciled supplier confirmations and escalated shortages to protect production schedules.

Education

B.S. Supply Chain Management
The Ohio State University · Columbus, OH
2013 · 2017

Skills

Analytical Thinking Skills
Project Management Skills
Interpersonal Communication Skills
Ability to Multitask
Good time management

Courses

APICS CSCP — In progress
ASCM (APICS)