Merchandise System Specialist - Oracle Markdown Optimization
Shopko
Green Bay, Wisconsin Area
Managed Shopko’s Markdown Optimization (MDO) system, a highly customized Oracle product. MDO is a robust tool with dynamic forecasting incorporating seasonality, geography and price elasticity to recommend markdowns for product identified for clearance. Assumed responsibility for non MDO (Retek) clearance.• Maintain business rules, troubleshooting issues, reporting, merchant training and ongoing assistance, weekly reporting and monitoring of merchant markdowns to ensure compliance with corporate clearance objectives.• Contributed to a total clearance gross margin improvement of $42M for the past two fiscal years.• Managed two system enhancements involving detailed requirements and partnership with Oracle and IT, testing and go live implementation. Trained merchants on the changes.• Ongoing merchant involvement to follow up on their adherence to system recommendations (timely markdowns and appropriate depth) in order to sell more of the discontinued product, creating additional profit for the company.• Oversaw RETEK Clearance, a legacy system that allowed merchants to markdown product in select stores. Utilized reporting to delay scheduled markdowns when weeks of supply were low, directly generating $4M over the past three years.