Solution Architect & Technical Design Lead

Fred is an execution focused leader who brings together extensive programming experience with an understanding of omnichannel business and processes for custom value-added solutions. Over his 43-year career he has served Tier 1 retailers and wholesalers in apparel and accessories, sporting goods and footwear with high response time solutions.

Experience

  • Nike – Functional Designer and Solution Architect
    • Led the design and delivery of MFP, Line Architecture and Assortment Planning solutions
  • Tuesday Morning – Solution Architect
    • Developed a custom real time planning system using Excel for the UI, .NET web service for middle ware, SQL Server for the database and MicroStrategy for the reporting system
  • Big Lots – Project Lead and Solution Architect
    • Developed an automated store dashboard using Excel that parsed their information by district and emailed the stores and districts.  Developed a near real time process for loading trickle feed POS data into a Teradata warehouse using Perl and Teradata utilities. 
  • FullBeauty Brands – Project Lead and Solution Architect
    • Led the design and delivery of Front End OTB, Assortment Planning and Demand Forecast with a SQL Backend
  • Ralph Lauren – Solution Architect
    • Developed an automated buy tool and distro tool to maximize buyer and assortment planner productivity using VBA/Excel. Developed a rollup to aggregate all the buy tool workbooks into one projection workbook for management
  • Ross Stores –  Solution Architect
    • Developed a high-performance Trend Sheets for the planners using VBA/Excel. The redesign cut the calculation times from 30 minutes to less than 1 minute and streamlined the process for the planners
  • dds Stores – Solution Architect
    • Developed Region Trendsheets in VBA/Excel that taking days to create and format to be done in seconds using a single format worksheet. The worksheet was modifiable by the user and exploded to do all regions and store groups including totals. Developed Distortion Tool using VBA/Excel that could not handle the current volume. Using the same type technology done in the Region tool made the performance to handle quadruple the volume with fast response time

Specialization

  • SQL Backend with Excel Frontend Automations
  • Merchandising & Buying
  • OTB, AP, Demand Forecast

Expertise

  • Solution Arch. & Implementation
  • Web Services
  • SQL, VBA, JSON
  • Digital Transformation
  • Web, Mobile App Design & Dev
  • Retail Consultant

Companies

  • Nike
  • Tuesday Mornings
  • Big Lots
  • Ross/dds Stores
  • FullBeauty Brands
  • Ralph Lauren

Connect with one of our experts