Educational Qualifications

·         PRINCE2
Foundation (2006)
Practitioner (2006)

·         Open University
M873 User Interface Design and Evaluation (2004) Merit

·         Hull University
BSc Hons Computer Science (1992)

Skills

·       Specialist Skills

Microsoft Access 1.0 - 2003

§         Access Basic (DOA, ADO), Macros & Queries

§         Reports, Graphs, Import/Exports

§         MS Office integration

§         Data Transfers (databases/text and data structures)

§         Front End to SQL Server and legacy databases (linked tables, pass through queries and server-side stored procedures)

§         Security (MS Access and form/function based), Multi-User/Networked applications

§         Run Time applications and deployment of applications

·       Programming Languages

    MS Access Basic (Visual Basic for Applications), queries, forms, reports versions 1.0, 2.0, 95,98, 2000 & XP, 2003
    MS SQL Server 6.0 – 2000 (As a backend to MS Access)

    Work Experience

 ·       January 2007 – Present (Working Remotely) Consultant

Contracted to An NHS Third Party Services Supplier

·       September 2006 – December 2006  and Part-time since October 1997 Owner

The Netfysh, York, North Yorkshire UK
Internet Instant Pet and Toy mail order retailer

Managing cost effective redesigning of the company's website with a solution that includes stock control and VAT invoice production freeing up man-hours through automation.  

·       February 2006 – September 2006 Database Analyst and Trainer

Contracted to Constellation Europe, Guildford, Surrey, UK
UK division of the largest wine & drinks company in the world and a leading producer and exporter of wine

 Working within the finance department to assist with the creation of a handful of stand-alone MS Access applications that provide off-line management of promotion sales data from JD Edwards.  The flexibility and rapid application design of MS Access allowed us to work with financial analysts to provide solutions without any VBA coding that were then handed over to them for use and future development.  Also held a series of introduction to MS Access training courses to increase the department's overall knowledge of MS Access.

·       September 1999 – February 2006 (Working Remotely) Product Development Manager

Contracted to An NHS Third Party Services Supplier

I worked very closely with NHS administration, doctors and nursing staff at a NHS Hospital on a very limited time scale project to a definite deadline. I produced and supported (both on and off site) a year 2000 contingency application, required to replace an existing system (Di-Proton). I developed an MS Access 2000/XP client-server database that manages and monitors the day-to-day administration of kidney dialysis patients.  Existing patient data held in the old application was converted into the new MS SQL Sever 2000 back end database.  The application has since been expanded and extra functionality developed.  Managed at Indian outsource team to re-write the application into .NET.  It is now used as their permanent live system and has also been taken on by other NHS Trusts to manage their Renal patients.

·       November  2001 – December 2001 Trouble Shooter

Celebrity Speakers, Burnham, Bucks, UK
Agency providing after-dinner and corporate speakers
 

Successful data retrieval of MS Access databases worldwide that were failing to communicate via direct replication. 

·       December 1999 (Working Remotely) Consultant

Equant, Paris, France
Was part of the SITA group providing network services to the air transport industry

MS Access Millennium Incident Bulletin System

·       January 1999 – August 1999                        Consultant

Contracted to Hertfordshire County Council, Hertford, Herts, UK.

Further Development and redesign of an existing Rights of Way application whilst converting it from MS Access 2.0 into 97.  Complying to both a detailed specifications from the internal users and the British Standards.  The database is a tool that ensures the County Council’s legal responsibilities are met as well as maintaining the detailed information of changes, complaints and descriptions of the Rights of Way of Hertfordshire.  I also developed Driver Training Course (scheduling), Environmental Pledge (data storage), and Heritage Site (historical data maintenance) databases. 

·       February 1999 – June 1999 Consultant

Tetra Pak UK, Stockley Park, UK
Worlds largest and leading provider of carton packaging

MS Access Timesheet and client invoicing for off-site machine maintenance engineers.

·       October 1998 – December 1998                   Software Consultant

Telecommuting to Estimate Department, MW Kellogg Limited, Greenford, Middlesex, UK
JGC Corp/Halliburton owned engineering contractor serving the oil and gas markets

Using MS Access 97 to produce a system that will be used by the company to estimate the total cost, material quantities and man-hours involved for their large-scale construction projects.  With the ability to compare an estimate against both revised estimates of the same project and other project estimates. 

·       May 1998 -July 1998

CDMaestro Limited, South Harrow, Middlesex, UK
On-line Classical CD Retailer

MS Access 97 database for managing an on-line classical CD shop.  Required a lot of data manipulation from the various data source of CD listings (Word documents, Web pages, text files) to produce a full referential database.  The resulting catalogue was then exported as SQL statements to populate a MySQL database on a Unix Web Server. 

·       May 1998 –May  1999 (Working Remotely)

Concentric Credit Services, San Diego, California, USA
JGC Corp/Halliburton owned engineering contractor serving the oil and gas markets 

Worked in a team to provide an MS Access 97 database to administrate a debt consolidation charitable organisation.  Designed the system from specification sent via email.  The system produces letters, statements, and reports and prints the Bank of America cheques.

·       November 1997 - January 1998

Staples UK Limited, High Wycombe, Bucks, UK
Office Supplies Retailer

Documented and appraising the existing Visual Basic 4.0 customer service application with ODBC connectivity to an AS/400 using 'ACE' Visual Basic Add-In.

·       October 1997 – October 1998                       Analyst Programmer

Contracted to KUP Project, MW Kellogg Limited, Greenford, Middlesex, UK
JGC Corp/Halliburton owned engineering contractor serving the oil and gas markets

MW Kellogg Limited are a construction company with large-scale projects around the world. While contracted, I produced MS Access databases to provide cost tracking, forecasting and actual man-hours/cost of the project, vendor equipment data collection, material distribution, equipment tracking, overall project erection and fabrication man-hours and material cost estimation as well as general MS Access support for the company.  Connection to legacy Oracle databases achieved via ODBC.  Importing, verifying and reporting of data into MS Access from Excel, Fox Pro, VAX reports produced as unformatted text files. 

·       December 1996 – April 1997                        Analyst Programmer

Contracted to Mentor Computer Services, Uxbridge and also Borehamwood, UK
Software House

Continued development of an existing MS Access application to manage customer selection/sales of tailor made holidays in America.  Bug fixing, advice and assistance given on other similar live projects. 

OTHER CLIENTS

-Mentor Computer Services   

-Accenture                               

-Grass Roots Group

-Natwest Bank                     

-FI Group                                  

-GAN Life                     

-Dreamlight Systems

·       Other Employment

     Shop Security Guard, Leaflet Distributor, Santa Claus (Voluntary) and Kitchen Assistant.

References :  Available only by request