In my 3rd role within Britvic, the leading supplier of branded still soft drinks and the 2nd biggest carbonated soft drinks supplier in GB, I was responsible for:• Producing & maintaining the full demand forecast in APO (0-18 Months).• Generating the statistical forecast based on cleansed historical patterns to produce a strong base line.• Analysing the statistical forecast & improving accuracy by ensuring to select the appropriate statistical algorithms.• Driving cross functional collaboration with BOP’s to incorporate the top down demand drivers for the 6-18 month horizon. • Preparing and facilitating the monthly Category Demand Review meetings. Where the full demand forecast is scrutinised before it is signed off. • Reporting on all Key KPI data to understand the drivers of forecast error and bias to provide corrective actions. • Ensuring SAP is kept up-to-date with the latest NPD products and cleansed of delists.

In my 2nd role within Britvic, I was responsible for:• Developing new and existing reporting tools to enable our forecasting managers to enhance their forecasting accuracy and improve operational efficiencies.• Coaching the forecast managers on best practices when forecasting and providing them support to drive a better forecast at not only a volume level but also at a SKU level.• Presenting key reports at a weekly logistic meeting to provide insight into how sales are performing weekly, how the forecast has changed and current results on KPIs.• Producing periodic reports for commercial to enable them to input their long-term forecast with the ability to see the impact on volume and provide a more stable forecast.• Creating new KPIs and scorecards in order to drive a more precise longer lead time forecast that reduces waste.• Providing support across functions by responding to ad-hoc data requests and presenting analysis in a timely manner.

In my first role within Britvic, I was responsible for:• Generating KPIs to monitor how accurate our forecasting managers have been by SKU & Volume in both the short term and the long-term forecasting window.• Maintaining the forecast data daily to ensure a robust dataset for all reports and tracking how the forecast has changed over time.• Producing and issuing a daily sales report to the wider business.• Chairing a mid-week call to gauge where we expect sales to finish in week and to challenge next week’s forecast before it is fixed.• Producing periodic reports for each forecast manager to highlight how each account they manage has performed over time by key metrics and what they are projecting to deliver going forward.

In my last role within Tarmac, the UK’s largest Aggregate & Asphalt suppliers, I was responsible for:• Ensuring that across all of the 30 sites, the required material(s) can be produced in order to cover sales expectations for the next 4-12 months and to highlight any potential stock outs.• By creating a monthly report, that overlaps the Operational production plan with Commercials sales strategy. Enabling management decisions to then be made to prevent any issue from arising.• Generating KPI's to monitor how accurate our sales forecasting has been by Area, Region, Key Sales Account Manager, Key Customers & by product stream on a weekly basis.• Chairing a monthly call on optimising our fleet by overlaying the sales forecast with our base trucks to highlight any potential logistical concerns with servicing the work.• Analysing key business performance metrics in order to reduce manageable costs such as the implications around Road Vs Rail and how many loads are completed at night.• Producing key executive reports to show third party forecasts, cross-regional forecasts, rail forecasts and recycling forecasts.• Attending management meetings to present monthly KPI’s and raise any potential concerns the forecast is showing.

In my second role within Tarmac I gained invaluable experience in:• Raising high profile Purchase Orders (PO’s) by creating purchase requisitions (usually in excess of a million pounds), through the SAP computer system.• Processing invoices for payment by goods receipting the gross amount of the invoice.• Ensuring records were kept up-to-date and complete, in case any invoices are queried for not being paid.• Providing the Finance department with monthly accruals, to make certain costs incurred in the month are captured.• Ran performance analysis on suppliers to see if they are matching our targets• Created a rail dashboard in Excel with the use of macros and pivot tables that auto populates KPI tables and graphs to show the number of trains that ran or were meant to run nationally.• From this dashboard I then generated a key monthly national report, that was sent out to the wider business.

During my first role at Tarmac I gained skills in:• Processing customer’s proof of deliveries (POD’s), by making sure they matched Tarmac’s standards (on average we received around a 100,000 a month).• Keying on additional data (add-ons) on SAP, ensuring the customer is charged correctly and the haulier is paid the correct amount for any additional waiting time incurred or for any returns.• Keying on manual orders to process quarry to quarry movements of material for large quantities, such as 200 tonnes.• Transferring data from SAP to external spreadsheets in order to create a summary for specific customers who then negotiate with Tarmac for the amount to be paid.• Used my skills in Excel to create a spreadsheet that logs which plant has sent in POD’s on each day of the week to show their frequency and highlight any that where infrequent.