Working on the London Cycle Hire Scheme (Santander Cycles) within the Forecast & Planning teamDesigned and maintained forecasting models to understand to plan the on-street requirement Developed optimal route planning tools to increase operational efficiency of redistribution drivers and mobile operativesCreated part usage models to forecast demand for inventory to ensure minimum stock levels

Role encompassed the responsibilities of Performance Data ManagerDesigned business processes for new contact delivery and optimised existing operational proceduresFacilitated the design and delivery of a tailored CRM system used to facilitate a nationwide contract from end to endCoordinated training of frontline delivery staff ahead of go-live of CRM system

Managing two Data Analysts within the Data TeamLiaised with Finance and Operations departments to regularly reconcile performance and revenue on more than 20 programmes each with separate and varying datasetsImplemented consistent MI reporting across all contracts to enable comparative performance to identified and analysedBuilt Excel models to aid in project planning and financial viabilityManaged external stakeholder data requirements and attended monthly and quarterly contract review meetings on behalf of the company

Analysed contract performance through standardised and Ad Hoc MI reports as per the business requirementFacilitated monthly KPI reporting of delivery staff for use by Operation ManagersProduced monthly reports for Directors on contract performanceData mining through extensive use of Excel including use of advanced formulae, Power Pivot and VBA