• Improved use of the Cognos TM1 OLAP system by the Finance team to reduce the effort required to produce monthly figures and plans.
• Liaison with TM1 supplier (infocat) to achieve system improvements and provide training for Working Links staff.
• User interface for a system interfacing with Sun accounts.
• Usability investigation and report for main data entry system.
• Created a Data Warehouse to form the basis for a Corporate Reporting Database and OLAP reporting together with Business Intelligence
o Prepared the project Business Case
o Created PowerPoint presentations to present to the Executive board and senior managers
o Gathered requirements and produced the Requirements Definition
o Identified and verified data sources
o Specified the ETL processes and requirements
o Created the solution’s logical design; logical data model, use cases and process diagrams
o Introduced a CASE tool, Visual Paradigm, to manage the project definition from analysis through design and build.
• Project management of system enhancements following Prince2 principles

• Feasibility study and implementation of an Ordnance Survey map licence management system, using the Business Collaborator product for use in Public Sector projects
• Feasibility study for railway examination records system (SAM), holding details of trackside furniture inspections, including photographs. The system was for input to and linking with the Network Rail CARRS system.
• Implemented a highways network access system for Transport for London (TfL)
• Implemented an invoicing interface between Mouchel Parkman’s finance system and Wiltshire County Council’s Exor roads management system (BA and PM roles).
• Identified initial requirements for an office move.
• IT Governance
o Helped to develop the IT Governance processes.
o Helped to set up the Project Office using Prince 2 principles
o Developed Access database and reports to monitor projects.
o Developed a Project Change Control process and Access database to manage project change requests.
o Developed an Access database to record and monitor on-going project costs.
• Developed a method and database for recharging hardware and service costs back to the business driven by Supportworks and MS Exchange data.
• Implemented a corporate re-branding exercise covering all electronic media
• Mentoring of junior Business Analysts
• Systems developed using UML Use Cases, Activity, Class and Process Diagrams

Project management for a joint venture between BBC and Woolworth covering
• Business continuity and disaster recovery
• Macintosh upgrades
• Enhancements to contract management system

• Package selection for satellite vehicle tracking system
• Potential savings of £3.3m over 5 years
• Supplier interviews, product workshops
• Generation of the Business Case, UML Use Cases, Business Requirements and Project Plan
• Package implementation planning
• Prince 2

• Covered the full project lifecycle, from identifying initial business requirements and creating functional specifications, to system testing, running UAT and implementation
• Ran project to redevelop corporate Intranet, replacing a static text based product and liaising with graphic designers, Avis training department and the content owners. Evaluated and implemented new intranet Content Management System (Immediacy). Ran workshops to deliver the best menu structure and interface.
• Investigated use of an internet-based vehicle satellite tracking system for high-value rental cars; e.g. Mercedes, to prevent vehicle thefts.
• Developed an online shop for corporate gifts
• Developed and implemented vehicle damage recording and reporting
• Re-developed the Avis UK data warehouse
• Implemented OLAP based reporting using Analysis Services with Reporting Services, Hyperion Performance Suite (Brio) and Excel front ends
• Implemented fuel management system by VBI Triscan
• Developed and implemented system to monitor in-life vehicle repairs and costs, liaising with dealers and suppliers, saving Avis at least £50,000 per annum
• Developed and implemented operational fleet forecasting and allocation system incorporating basic rostering facility enabling closer control of the company’s fleet and staff movements. Estimated minimum cost savings of £30,000 per annum plus manpower savings. System requirements identified via workshops, 1-to-1 interviews and prototyping.
• Ran project to move corporate fleet system from Novell to Windows servers
• Represented the IT function on a number of strategic project groups
• Investigated an HR system upgrade from Personnel Director to HR.Net
• Quality auditor
• Implemented project management methodology and ethos using MS Project and Prince2 principles
• Evaluated staff rostering packages
• Introduced UML and Use Cases to IT development. Systems developed using UML Use Cases, Activity, Class and Process Diagrams
• Initial investigations for Applications Rationalisation project
• Developed Business Cases for a number of projects
• Systems developed using UML Use Cases, Activity, Class and Process Diagrams
• All projects controlled with MS Project, producing Earned Value Analyses for tracking purposes

• Reviewed and tested an extension to the Global Successor e-Recruitment product implemented in an earlier assignment at KPMG, covering agency temps and contract staff
• Re-designed the business processes to handle agency temps recruitment, timesheets and billing within HR, the business and accounts

• Led Programme Study Phase for a Strategic Venture Internet based credit card launch using Lloyds TSB’s structured methodologies
• Project budget £1.7m
• Managed 6 Business Analysts covering user base of 90 stakeholders
• Member of the working group involved in purchasing the card product owner
• Liaised with FDE, the bank’s card processor, to resolve issues around the new card and the migration of existing cards
• BIC
• Identified and documented the business requirements and processes related to the new credit cards via workshops and 1-to-1 interviews
• Created a Benefits Realisation model for the programme
• Followed the bank’s Prince2-based methodology

• Handled the disaster recovery area of data migration from NatWest to the Royal Bank of Scotland
• Identified the business requirements
• Tested the process using Mercury Test director
• Member of the Back-out Working group (Disaster Recovery)
• Followed the bank’s Prince2-based methodology

• Researched and implemented Corporate e-Recruitment systems for Graduate and Experienced Hires
• Identified the Business Requirements
• Member of the Project Steering Group
• Developed the Business Case
• Re-engineered the business processes, using targeted workshops to identify the required process changes.
• Package evaluation
• Nationwide implementation of the selected product, including training over 450 HR staff and 180 Agencies
• Change management
• Managed UAT nationwide
• Project delivered on time and under budget (12 months, <£700,000)
• Specifying, managing and testing package upgrades
• Supplier liaison and management
• Followed the firm’s Prince2-based methodology