Ewan Smith Email and Phone Number

ResponsibilitiesManagement of a team of commercial, insight and product data analysts.Creating a full suite of performance reports for buyers, analysts, customers and suppliers.Revolutionising the focus on product data to allow data to be one of the company's biggest selling points.Strategic planning of negotiations and commercial propositions to both suppliers and customers.Company-wide analytical expert; giving reporting, Excel and commercial advice throughout the business and leading training sessions in order to up-skill employees.AchievementsOver £7m of real term savings delivered consistently over 5 years by the effective process of strategic planning, intelligent insight and commercially savvy execution of supplier negotiations whilst creating value adding partnerships.Rationalisation of both products (42,000 to 19,000) and suppliers (2,500 to 800) whilst creating an intelligent product introduction process to prevent future proliferation. Thus allowing huge efficiency and focus gains.The creation, negotiation and maintenance of a national framework pricing structure which currently delivers £15m worth of sales per year and is fundamental to the customer proposition.Delivery of pivotal digital projects from conception which enabled Bunzl to gain a competitive advantage in several areas in terms of data and its commercial use:A comprehensive cost to serve model based on weights and dimensions of products.Product categorisation and an alternative dashboard in order to provide easy product comparisons in the difficult sector of medical products.Marketing data from photos to usable descriptions in order to provide a digital platform for sales.Legal compliance and business future-proofing through GS1 and product licence data gathering and systemising.

Managed a team of analysts to drive efficiencies and revenue growth in a rapidly expanding vending machine company.Playing a pivotal role in modernising the company by providing effective use for the mass of data being provided by new systems.Creating tailor made analytical models in operations, purchasing, sales and marketing to provide solutions to business problems, maximise efficiencies and report performance.Increased the department from 1 to 5 people as a result of the high returns delivered by the team.

Provided costing, pricing and financial analysis for product opportunities for a successful insurance company. Working with a diverse range of departments in order to provide enlightening reports of past performance plus relevant and flexible models for the future.