Rapid application development of
business insight / merchandising systems

• Technical / functional lead for merchandise analysis database combining product sales, purchases and vendor agreements for Staples US, Canada and Europe (12 team members, 33 business units)
• Transformed one-time database into sustainable program including quarterly update process and training business / technical maintenance teams
• Customer analysis templates / processes using BRIO and Oracle SQL to reduce development time and increase analytical depth of ‘quick hit’ customer analyses
• “Jury Rigged” Canadian catalog pricing to allow customer specific price lists – approach was quickly adopted by US for preferred customer program ($1 billion revenue)
• ‘Slice’ model for customer analysis allowing structured reuse of queries, analysis templates, etc. as well as ‘Real-time’ data mining analysis by reducing drill down times from hours to minutes
• Access / VBA customer data profiling and testing tools to find and fix hundreds of issues with complex customer load
• SQL Recipe-Book for Customer List Pulls cutting processing time from weeks to hours by enabling business users to run their own extracts