OptiStock is a cloud based inventory analytics software and consultancy service. Our software greatly assists a company to have the right quantities of the right products in the right place at the right time. We access a customer’s raw inventory data, analyse it and transform it into easy to understand reports to:- Improve customer service levels - Identifying upcoming out of stock events so that timely action can be taken- Significantly reduce average investment in inventory working capital- Increase inventory turnover by daily monitoring of SKU coverage levels- Identify slow and obsolete (SLOB) stock for removal- Greatly assist decision making for supply chain managers and inventory planners.

Management of the demand forecasting department at Countdown Supermarkets (Woolworths) New Zealand. We produced consistently high forecast accuracy results significantly above target, with responsibility for the demand of 30,000 SKUs in 186 retail stores and 3 DCs.Responsibilities included:• Building strong relationships with the merchandise teams to ensure demand forecasts aligned with current promotional activities. • Collaboration with supplier account managers ensuring the alignment of Countdown and supplier forecast information.• Manage a team of 4 analysts.• Develop MS/Excel, MS/Access, Power BI, Tableau tools with data import / export functionality to efficiently process vast volumes of data, and import resulting forecasts to SAP/JDA.• Excel / VBA macro training – preparation and deliveryReason for leaving: Family returned to Sydney

Contract role to develop automated demand planning processes. The focus was to improve the information flow from demand promotions to production planning dealing with very short FMCG lead times and shelf life coverage. Responsibilities:• Work hands-on in the demand planning role to experience current procedures.• Analyse / identify areas for improvement. Propose recommendations to management.• Project management of process improvement initiatives• Creation of bespoke Excel/VBA data insights models with SQL interfaces to the Movex database • Automation of data extraction methods to greatly improve speed and error reduction.• Excel / VBA macro training – preparation and delivery

Contract role to develop and implement Sales and Operations Planning (S&OP) at Champion Flour. This process resulted in achieving 98% plus DIFOT results with 14% reduction in average inventory investment.Responsibilities:• Development and project management of the Sales & Operations Planning process.• Creation of bespoke Excel / VBA based demand planning and analysis modules with automated SQL interfaces to SAP. • Development of data visulation tools for: - KPIs to monitor progress - Forecast reviews - Pre S&OP meetings - Executive S&OP signoff• Meet with: - Sales staff to review forecasts - Plant staff to review production / capacity plans v constraints (pre S&OP) - Executive team to review high level S&OP and obtain signoff. • Training of staff: - S&OP processes to transfer knowledge to permanent staff members - Advanced Excel techniques, e.g. Excel VBA macros, ODBC, SQL• Creation of documented procedures to enable a smooth transition to permanent staff

Contract role to design and develop a management reporting system using SQL, MS/Dynamics, Pronto and Excel / VBA to provide:• Sales and operations planning • Forward Cover / Inventory Forecast• Slow and obsolete inventory reporting• Optimum safety stock and reorder point levels• Forecasting• Order replenishment recommendations• ABC analysis

- Forecasting / MRP / Sales & Operations Planning- Continuous improvement / lean initiatives- E commerce- Project management- ERP system implementation Movex / M3 software- Solution design, analysis, testing- Preparation and delivery of training- Policy and procedure documentationReason for leaving: Move to Auckland

- ERP system implementation (supply chain/logistics modules) Australia and New Zealand- Convert from Movex ERP to Oracle / JDE software- Project management- Gap analysis- Solution analysis and design- Data migration from legacy system- Staff training: MRP, Forecasting, Excel - System documentation- System support

- Centralise inventory planning for ANZ region- Development of forecasting function- Sales & operations planning- Budget preparation - MRP II education- Project management- Database management- ERP system implementation- SAP, Mapics software