Experienced Technical Consultant in Merchandise Planning & Allocation Systems

David Schmitz has over 20 years’ experience delivering Merchandise Planning and Allocation systems. He has held many roles during that time including technical, functional, support, and training. Prior to joining Columbus Consulting, he has worked with JDA and held positions with other consulting firms.


  • Ralph Lauren – Allocation Technical Lead
    • North America Division: Modifications to existing process included database (tables/procedures), scripts, system integrations, application configuration, and scheduling were all part of the scope of this project. Additionally, working with various groups was necessary as the project impacted all systems that dealt with inventory
    • Europe Division: Allocation modifications to help support process enhancements. These changes required database changes (tables/procedures) and application configuration modifications
  • Dollar General – Merchandise Planning Technical Lead
    • Responsible for the migration of existing process in the Cloud (hosted by JDA). This also included a change to the application to support Attribute Planning, Key Item planning, as well as a more involved Merchandise Planning process. Additionally, end to end batch scripting was required
  • At Home – Merchandise Planning Technical Lead
    • This project was a new implementation of JDA Enterprise Planning in the cloud (hosted by JDA). This required a complete application configuration, database setup, and batch scripting


  • Systems Implementation
  • System Integration
  • System Architecture
  • JDA Enterprise Planning
  • JDA Allocation
  • Anaplan Model Builder


  • Oracle/PLSQL
  • Powershell/Kornshell
  • Visual/Basic/.Net
  • SQL Server
  • Excel Reporting/VBA
  • Retail Consultant


  • Ralph Lauren
  • Dollar General
  • At Home
  • J.Crew
  • Claire’s
  • Talbots

Connect with one of our experts