Highly-Adaptive Planning Solution Architect & Business Process Designer
Justin is a Principal with Columbus Consulting specializing in merchandise, assortment and location planning. His technical expertise is in the development and automation of highly customized Excel analytical tools and Anaplan models. A highly detail-oriented individual who prides himself on being resourceful and having the desire to challenge the status quo. Justin’s skill with data manipulation, system testing and data validation, alongside his 15+ years of retail business experience and keen eye for business process optimization make him an invaluable resource on any project, particularly when it requires a technical developer’s mindset with a business-focused lens.
Experience
Excel Automation
Designed, developed and implemented dozens of bespoke automated Excel solutions such as:
Assortment Planning solutions with automated ‘roll-up’ functionality for reporting & review
Merchandise Planning solutions including Open-To-Buy tools and automated order creation
Location planning solutions including in-season trending and regional planning tools
Responsible for building and deploying custom Excel reporting solutions utilizing VBA automation with a variety of data sources (e.g., flat files, SQL databases, cloud-based data warehouses, etc.)
Anaplan Model Builder
Designed, developed and implemented a 5-year long range financial planning solution
Designed and built a Labor Planning Model Demo as a proof-of-concept for a multi-brand retailer
QA Testing & Data Validation
Designed process, wrote test scripts and lead the unit testing, data validation and system integration testing effort for an Enterprise Planning implementation
Created spreadsheets and processes for hierarchy-reorganization and master data management projects for multi-brand clients
Solutions Expertise: Microsoft Excel, Anaplan, Blue Yonder