• Lead Data analyst / Financial analyst (within Finance dept.) responsible for:o Procurement of client data, processing, mining and production of volume forecastso Revenue & costs forecastingo Financial, Planning & Analysiso Product pricing models (Costs, Revenue & Gross Margin)o Bid/tender submission models with price optimization mechanicso Supply chain logistical planning models /Stock management modelso Overhaul of all Business Information / Management… Show more • Lead Data analyst / Financial analyst (within Finance dept.) responsible for:o Procurement of client data, processing, mining and production of volume forecastso Revenue & costs forecastingo Financial, Planning & Analysiso Product pricing models (Costs, Revenue & Gross Margin)o Bid/tender submission models with price optimization mechanicso Supply chain logistical planning models /Stock management modelso Overhaul of all Business Information / Management Information, consolidation, visualization and presentation in automated KPI reports• Lead Systems analyst overseeing the development of new processes to improve company efficiency that involved:o Project management o Flow mapping / workshops and stakeholder managemento Developing new tools (with Excel and VBA) to automate and simplify complex activities• Lead Data analyst / Financial analyst (within Finance dept.) responsible for:o Procurement of client data, processing, mining and production of volume forecastso Revenue & costs forecastingo Financial, Planning & Analysiso Product pricing models (Costs, Revenue & Gross Margin)o Bid/tender submission models with price optimization mechanicso Supply chain logistical planning models /Stock management modelso Overhaul of all Business Information / Management Information, consolidation, visualization and presentation in automated KPI reports• Lead Systems analyst overseeing the development of new processes to improve company efficiency that involved:o Project management o Flow mapping / workshops and stakeholder managemento Developing new tools (with Excel and VBA) to automate and simplify complex activities Show less

Project Manager Pricing InfrastructureManaging coordinated approach to the execution of pricing related tasks including the delivery of the annual tariff change across all Royal Mail business units. Also responsible for managing and implementing IT/SAP changes that impact on pricing as well as leading the development of new pricing systems/infrastructure across all Royal Mail business units.

October 2012 to June 2013, AIG InsuranceSix month contract as technical lead hired to develop new Excel tools drawing together complex and poor data sets from different sources to match them and bring them onto a common platform through automatic and semi-automatic VBA driven processes. The successful contract involved:- Analysis of client data problem;- Analysis of process efficiency;- Liaison with business mangers- Design of new process and… Show more October 2012 to June 2013, AIG InsuranceSix month contract as technical lead hired to develop new Excel tools drawing together complex and poor data sets from different sources to match them and bring them onto a common platform through automatic and semi-automatic VBA driven processes. The successful contract involved:- Analysis of client data problem;- Analysis of process efficiency;- Liaison with business mangers- Design of new process and specification of supporting tools;- Development of VBA powered Excel spreadsheets to manage data processing and dynamic interface with SAP;- Test new platform and develop further during parallel running;- Subject to continual improvement;- Successful delivery of final versions;- Delivery of staff training; and- Production of supporting documentation.I enjoyed this so much I am now preparing the tools I developed for application to other entities and contracts. Show less

Supporting a specialist team bringing the company business intelligence systems into Hyperion Financial Management software. Good fun. It was great to deploy my dormant VBA to good effect.I worked with Excel, VBA, SmartView, Hyperion. I would've loved to have done more but the resident PWC guys were keen on keeping ownership.

Making sense of business intelligence systems of colliding leviathans. Fun, for awhile. I couldn't turn down M&C though.

lead the Steer Davies Gleave demand modelling team and my portfolio of work includes:- Major Scheme Submissions (LRT in particular)- Transport Innovation Fund submissions- Local Development Frameworks- Model development and application- Procurement / bid evaluation

Primarily a public transport and highways modeller.