SYSTEMS DEVELOPMENTS

Automated Management Reporting Tool
The assignment involved the build of an automated and flexible management reporting model for the museum. This included scoping, specification and user documentation, handover and training. The model included excel visual basic macro logic. There was the requirement to interface the management reporting model with the accounting system (“Agresso”) and the budgeting and forecasting models.

Automated Promotional Planning And Evaluation Tool
lmplemented excel based trade promotional expenditure evaluation and control tools across major accounts for Walkers, Tropicana and Quakers Brands for a £80 million promotions budget in the UK. The tool was highly visual basic programmed. The assignment included best practice implementation and build standards (scoping, specify, design, build, document, test and training phases). The tools provided the business with enhanced visibility in terms of the profitability of promotional decisions and control. The tools were rolled out to over 100 users mainly National Account Managers. This included both 2006 and the 2007 update versions.

An Award Was Presented By Pepsico’s Senior Management For The Success Implementation of Leading Edge Business Tools.

NHS Trust Systems Risk and Strategy
Reviewed the financial systems risk and procedures for a number of income activities and improved systems automation, quality assurance levels and information timescales