Ian Andrews Email & Phone Number

Columbus, OH, US

Columbus, Ohio Metropolitan Area

• Developed & owned $15m inventory strategy for omni-channel Health & Wellness and Consumables categories, ensuring appropriate inventory levels to achieve company goals by balancing forecasted demand, disposal risks.
• Planned & executed a migration of all inventory operations away from a 3PL partner and into a first-party fulfillment facility, developing SKU-level transfer timelines, communicated cost, and provided ongoing.

• Owned S&OP (Sales and Operations Planning) process with inter-departmental participation from Marketing, Supply Chain, Product Development, Customer Service, and Finance to gather inputs, analyze performance metrics.
• Led all data & analytics initiatives for omni-channel category planning needs. Writing SQL queries, building demand, churn, capacity, production, and inventory models, creating BI dashboards, and creating visual.

• Developed a complex bulk assignment tool, using PostgreSQL and Google Sheets, allowing a previously manual process to scale to 10,000+ simultaneous assignments, alleviating capacity constraints and expanding.
• Developed and maintained 50+ SQL queries to drive a comprehensive BI dashboard in Periscope, tracking program performance for our automated assignment & fulfillment platform, providing crucial insight for operational.
• Combined distributed forecasts with current and planned inventory to establish rolling days-of-supply measure and ensure >99% order fill-rate.

Columbus, Ohio Area

• Wrote SQL queries that fed into an MS Excel-based ‘solver’ model, optimizing the usage of over 10,000 component SKUs into the production of over 2,000 BoM assemblies, prioritizing cost, margin, product-fit, product.
• Automated company-wide component & BoM COGS reporting by partnering with the Data team to design and implement an ETL-flow from ERP (NetSuite), to a Google Sheets model, to the relevant product & financial tables in.

Columbus, Ohio Area

• Developed, implemented, and maintained a complete system of quantitative assessment of associate and team performance, highlighting all KPIs, driving 11% YoY improvement to team-wide contact-per-hour rate.
• Developed and utilized detailed forecasts of inbound customer contacts for support center receiving 100k+ contacts per month.

Columbus, Ohio Area

• Partnered with multiple third-party event producers to plan and execute some of the largest events in the endurance athletics industry, including: Pelotonia, The Boston Marathon, and the UCI Cycling World Championships.
• Developed technical manuals to provide detailed instruction and demonstration of expected deployment of physical assets.
• Managed administrative and operational duties to ensure accurate and on-time delivery of all functions of event.
• Provided leadership, direction, and accountability to teams of 5-50 people.