Profile            

Professionally minded, European Project Manager, Consultant and hands-on developer, who is a punctual, motivated, highly skilled, organised and competent individual. 

IT Languages:

·         VBA – Office Applications Access, Excel (10 Years)

·         Visual Basic - Microsoft Certified Professional Version 1 to .NET (8 Years)

·         SQL Server TSQL – Completed MOC (6 Years)

·         ASP, JavaScript, DHTML (6 Years)

·         DTS, SPROCS, TRIGGERS (4 years)

·         XML, XSL ( 2 years)

·         Crystal Reports \ Business Objects Business Intelligence. 

Skills

·         Client Facing \ Presentation skills

·         Deadline focussed

·         Hands on team management

·         Project Management (studying for Prince II Practitioner)

·         Conversant in German, Good Basic French and very basic Dutch! 

Achievements

·         Multiple projects with Professional Services Companies including Avanade\ Accenture, IBM\PWC and Temposoft.

·         Sucessfully designed and implemented Technical Solutions across Industries sectors within Energy, Retail, Manufacturing, Financial, HealthCare, Education and Service Industry.

·         7 years repeated projects for global blue chip clients (Bp\Mobil\Exxon).

·         Conception, development and implementation of quality management system for National Health care organisations.

·         Implementation of pan-European analysis system and data cleansing system across 14 sites in 12 countries. 

Experience

11 years professional experience across the full system lifecycle.  This has included work for Blue Chip companies in the oil and software industries, consultancy in healthcare and education and training for charity and commercial training bodies 

Ongoing            [snip]

Quality management system ----- Under review for adoption as National Standard Application (12 months). SQL Server, TSQL, DTS, VB, FTP, ASP, OLAP, XML

Aug04-Nov04     [snip]

Analysis \ Design and Implementation of Global Product and marketing system. Requiring consultation with End Customers in rationalising multiple systems and Data Sources. Involved development of reusable VB and Lotus Script Objects Library for use across Microsoft and Lotus Applications in a network and Web Environment.

Lotus Script, Vb, OO Design OO Analysis, XML, BO (BODI) (12 weeks)

May- July04       [snip]

Analysis \ Design and Implementation of Flexible Enterprise Reporting Solution for £2bn NHS LSP Programme. Involved bespoke development of VB objects and ASP code to provide a ‘broker’ approach. with SQL backend.  Development of OLAP cubes for PWA and allow offline processing,   with DTS scripting to minimise effect on Transactional Systems.  Requiring consultation with End Customers in provision of data for Partner’s from a variety of existing data sources including MS Project Server, SQL Server, TSQL, OLAP Excel, Access, XML(9 weeks).

July 03- Mar04   [snip] – Technical Consultant

Analysis, Design and Implementation (including Architecture) of Interfaces between Oracle HR, Oracle Payroll and 2 third Parties products for Greenfield Group Application Team.  Bespoke development of high-volume, high security interface to be scheduled using DTS with standard objects and bespoke VB 6 dll’s with facility to run manual interface on desktop.  Requiring close operation and consultation with the end Customer and IBM\PWC Oracle implementation team to ensure consistency of stable, efficient daily and weekly interfaces(9 months). SQL Server, TSQL, DTS, VB, FTP, ASP, OLAP,XML

Sep 01-June 04 [snip] – Technical Consultant

Multiple projects for Downstream digital business unit of Bp.  Specialising in the integration of data between Oracle based Enterprise Systems and desktop MIS requirements, Including

·         ePM System for cleansing and rationalising of Customer Product Alchemy prior to loading into Oracle Data Warehouse. 

·         BOM explosion system to use internal logistics systems for Production plants.

·         Systems implemented in 10 countries globally.

Responsible for analysis, design and implementation (including localised training) of Analysis and Reporting Systems for all European Countries.  Required extensive consultation with Local BSG’s, Business Owners and System Users to ensure successful implementation and integration into new European Standard model.  Involved extensive periods at local sites across Europe to interact with Business personnel. (3 years) SQL Server, TSQL, DTS, VB, FTP, ASP, OLAP TOAD, ORACLE, XML, Business Objects (Universe Generation and Data Integrator)

Jan 02 – May 02 Convergys EMEA

Online marketing workflow management and reporting system for. Greenfield development of system and ongoing client support and training.  Developed in SQL with ASP front end and VB6 Object Library.   System and implementation delivered in agreed timeframe of 4.5 months. 

Oct 02 -Dec 02   William Reed publishing

Event management and operation system for.  Greenfield development of system from initial client brief, handling multiple change requests throughout development and implementation including last minute integration with CRM system.  Delivered within agreed timeframe of 4 months.

Sep 01 – Jan02 Exxon / Mobil

Implementation of mission critical legal interfaces. (3 months) Included interfaces between corporate systems using Notes (Domino) SQLserver, Oracle and SAP data feeds using VB applications run as scheduled services or self executing apps.

Career Summary

12/2001 - Present          Director Five Whys Ltd (Europe)

Set up and run software consultancy.  Pan-European projects for variety of clients, in cross section of industries. Individual project budgets range from £5K to £150K+. 

10/1997 - 11/2001         Senior Groupware Consultant BMN Ltd (Europe)

Initially a consultant and progressed to Project Lead for blue chip clients on pan-European and global systems, running team of 6 consultants.  Budgets of up to £1.3M 

7/1996 – 7/1997            QA Consultant Exact Software (Netherlands)

Quality analyst and product specialist for Central Systems.   Responsible for: Lotus123 \ Excel Add-in; all areas of application release including Documentation design to batch scheduling including Communication to Central QA team; 3^rd Line support for Application for Global support team;  creation of test scripts, test matrices to ensure compatibility across platforms

11/1995 – 3/1996           Desktop to Enterprise Interface Developer Cable & Wireless (Australia)

Analyst / developer of interfaces to support SAP implementation for Corporate Finance department 

8/1994 – 5/1995            ICT Trainer Y-Training (UK)

Adult ICT educator for training body of YMCA

Education
 

2/2005              Studying for Prince II Certification.

11/2001            MCP VB;   Microsoft,

                        Microsoft Certified Professional Visual Basic for distributed apps

01/1995            TDLB D32,33,34,36;   Y Training Services, Liverpool

Training and Development Lead Body Tutor, Assessor and Internal Verifier.

06/1994            BSc. (Hons) Business Information Technology;   University of Northumbria at Newcastle

                        Sandwich course with 12 months placement year in Stuttgart, Germany.           

Personal summary

My personal interests and hobbies include:

·         Website development for local schools to aid compliance with Ofsted.

·         Clean driving licence, excellent health

·         DIY

References

Available on request

Problem 

Within a multibillion project across a 10 year time period, a multitude of Key Milestones exist within a Multinational Professional Services Organisation.  Payment for Services is heavily based on the completion of these milestones on a regular cycle.  Reporting of these milestones and their status is the lifeblood of the PMO. 

Product 

• The project data will be stored and monitored using Microsoft Project 2003.
• Other sources of data exist locally which is maintained locally through Active Directory.
• Data must be secured for internal purposes, however final reports must be available in hard and soft formats for processing.
• The manipulation for some of the reports must be available for drilling down and slicing and dicing across the organization.
• Other Reports require the data to be filtered for fields within the data itself.  This is very hierarchical and speed is of high importance. * Microsoft recommended that for filtering and sorting of data in such an instance performance is improved by use of SQL in a flat file structure

People

The Current staff

• Will be spread across a wide geographical area with access to internal infrastructure through Severs or VPN.
• Will grow to a large number as more projects included and stakeholder numbers increase.
• Require local adhoc reporting tool
• have no knowledge of Project Server but training will be provided form an ab-initio basis, which will be rolled out in staggered approach over a longer period.
• have a great deal of experience and confidence in the use and manipulating data (sort, filter) in Excel.

Solution 

A bespoke reporting system to be developed which provides secured data for consumption by multiple brokers. 

SQL

• A view to be created in SQL to allow cross views joins while restricting the data available.
• Look-ups to field values included in view to add sense to data.
• Security can be attached to the use of this view and internal support can amend this view when required.
• DTS used to create staging table to provide data for Offline processing during out of hours periods while minimizing affect on live Transactional Processing.
• Scheduled Creation of OLAP cubes to allow offline slicing and dicing of data where required, within Analysis Services.

ASP

·         A simple agent will allow the provision of the contents of the view across HTTP to provide a broker to be connected.  This can be a web method for delivery of data but ASP selected to allow some formatting and viewing of data in a raw format.

·         ASP page allows the passing of parameters to filter the data as required.

·         Stored on Project Server with access allowed through Project Security.

·         Central Control of view allows inclusion of business rules and consistency of reporting.

·         Access, Excel or any other tool can be allowed access to view securely and easily through ODBC. 

Excel

• Excel template created to include standard formatting.
• VB script used to allow provision of filter fields.
• VB script provides Single click downloading of filtered and sorted data to local staging table and provision of standard reports.
• Allows the local users to integrate reports in any required documents, Word, Excel etc.
• Standard reporting can be filtered and amended for localized needs quickly and easily by confident users.
• Template Secured, stored and Controlled through Sharepoint Portal Server.
• Automatic removal of scripting allows distribution of snapshot reports in Excel.

PWA

• Custom report in PWA allows use of OLAP cube with Pivot table functionality out of the box.

ROI 

• Reports can be produced by all staff members in a consistent manner.
• Report Creation has been reduced from 3 days to 3 minutes (at high server demand period). (.002% of time)
• Consistent reporting is available to all staff irrelevant of location.
• Data is controlled, secured by central support team and appropriate SLA.
• Formatting and Adhoc reporting facilities are maintained locally with the user.
• The immediate need for training yesterday is removed and can be focused on Use of Project application, instead of reporting.
• Future development using the data can use the infrastructure in place to extract the data from the ASP Page or View.