Consultant

[

Freelance Consultant Ashford, Kent, UK

Gain the combined benefits of a Qualified Management Accountant and Microsoft Professional in Access and Excel and VBA with ten years plus I.T. banking experience in the City.
MsAccess Planning

Click for info about QR Codes + enlarged view

Rating:	Unrated (New)
Hourly Rate / Cost:	£30.30 per hour (ex. VAT)
Daily Rate / Cost:	£242.40 per day (ex. VAT)
Available From:	Now
Seller ID:	253644
	: Offers a discounted hourly rate to registered charities

About QR Codes

people4 is the first employment business to generate QR codes.

Now users with a smart-phone scanning app can store this information - including job title, brief description and a link to this page - to use when ready to shortlist or set up a contract.

For more information, see the wikipedia article on QR Codes

Close this window

[ Top | Ratings | CV | Skills ]

CV (Curriculum Vitae) / Résumé

I am now in France but I am still willing to work in the UK (cheap 1.5 hours flights into Standsted).

As a highly skilled Microsoft Office Professional in Access and Excel with in excess of ten years experience developing solutions in Microsoft Access and Excel including VBA and SQL.

I have wide range of experience from industry to the banking environment including contracts for National Westminster Bank and Chase Manhattan.

I am also a qualified management accountant, with accountancy experience to financial director level; this is invaluable as it means I can quickly understand the business requirements of any project.

Finally I am also a fully trained qualified consultant on Business objects Planning and have configured and installed the planning software version 11 for a food warehouse company.

Employment History

(Apr 2000 & ongoing)

Consultant

Ashford, Kent

Own company developing and marketing two software products based around Microsoft Access

First product developed was a database development tool that documents Access database design using Microsoft Word. Software makes extensive use of custom controls and API calls

The second product is a timetable modelling software that allows complete flexibility using drops and drags features to allocate resources.

(Apr 2007 to Sep 2007)

Business Object Planning consultant

London

Professional consultant trained in Business Object Planning system:

The software used Microsoft Excel to analyse data held in a SQL Server database. Knowledge gained includes Advance use of Excel including VBA and database design in SQL Severs 2003 and 2005.

In addition to planning software, I also designed and successfully implemented a Front Running Trade Analysis system for a major investment bank using Excel VBA.

(Feb 2000 to Aug 2000)

Access developer

Chase Manhattan Bank, London

Design of Access database to generate daily market valuations for equities held

Requirement was to analyse manual Excel system and produce new system in Microsoft Access. This included linking to legacy system and valuation systems in Oracle database. VBA code used to convert data collected in report text layout into database structure.

Work included designing views in Oracle database system to calculate equities positions.

(Sep 1998 to Dec 1999)

Rad developer

National Westminster Global Financial Markets,, London

Design of RAD systems within the Finance Department based around Microsoft Access and Excel

Major requirement was the ability to respond rapidly to changes in front office systems to ensuring continuity of data.

Projects completed include:
• Derivatives reporting system
• Graphical modelling of trading systems
• Access database on Futures reconciliation
• Improved Foreign Exchange data reporting system

(Dec 1997 to Sep 1998)

Access Developer

Century Life Insurance, London

Access Database system to extract equity data from legacy system into new investment accounting software

Supervised two analysis programmers and devised solutions to extract data from legacy software and formatting into new system.

Design of database system to reconcile data during parallel running of new software.

(Dec 1996 to Dec 1997)

Access/Excel developer

Yamaichi International Bank, London

Development of RAD systems based on Microsoft Excel and Access within the Finance Department

Projects completed include:
• System combining trading data from new and legacy data sources including recruitment of two programmers.
• Designed cost allocation model, allowing flexible allocation and reporting of overhead costs.
• Excel training to users to improve usage within the department.

(Sep 1995 to Dec 1996)

Consultant

Ethical Holdings, Cambridge

Design Microsoft Access Database on medical research

System covered storing patients details from questionnaire and linking data collected from x-ray analysis. Major requirement was the ability to analyse the data for possible trends and causes.

(Jul 1995 to Sep 1995)

Access Developer

Lloyds of London, London

Database modelling on re-financing of the Lloyds Names

Redesign of Access database allocations funds to Lloyds Names. Reduced calculation times from two days to under one hour allowing greater flexibility.

(Jun 1994 to Jul 1995)

Access Developer

London Electricity, London

Access database concerning electric meter installations

New Access system covering order processing; registration and invoicing. System included fast processing of large text files on meter registration.

(Jul 1994 to Sep 1990)