David Dixon

Current

• Lead Developer at CHI PLC
• Developer at Orange Personal Communications Services Limited
• Buyer at The Netfysh

• Computer Consultant at The Netfolk Limited

see less...

1 more...

Past

• Business Analyst at CHI plc
• Migration Analyst at Orange Personal Communications Services Limited
• MI Analyst at Hitachi Capital

• Developer at CHI plc
• Database Analyst and Trainer at Constellation Europe
• Product Development Manager at CHI PLC
• Trouble Shooter at Celebrity Speakers
• Off shore Consultant at Equant
• Developer at Hertfordshire County Council
• Consultant at Tetra Pak UK
• Product Developer at Concentric Credit Services
• Software Consultant at MW Kellogg
• Analyst Programmer at MW Kellogg
• Data Analyst at CDMaestro Limited
• Office Supplies Retailer at Staples UK Limited
• Software Consultant at Mothercare
• Software House at Mentor Computer Services
• Analyst Programmer at Accenture
• Analyst Programmer at Mothercare
• Analyst Programmer at Grass Roots Group PLC
• Developer at NatWest
• Analyst Programmer at Liberty Life
• Programmer / Database Administrator at GAN
• Software Developer at Dreamlight Systems Limited

see less...

21 more...

Education

• The University of Hull

Connections

68 connections

Industry

Computer Software

Websites

• My Website
• My Company

David Dixon’s Summary

With a proven track record in designing, managing and implementing IT solutions within the public and private sectors (Including NHS, Hertfordshire County Council, Natwest Bank, Accenture, Mothercare, TetraPak, Staples). Proven expertise in MS Access VBA (from 1994), MS SQL (from 1996), C programming (1993-94) combined with commercial acumen, excellent understanding of business models and client requirements. Superb analytical, organisational and interpersonal skills. Commitment to excellence demonstrated by successful completion of Prince2 Foundation and Practitioner courses.
Seeking Design, Development, Maintenance, Mentoring, Training and Troubleshooting Challenges within Yorkshire.

David Dixon’s Specialties:

.net, ado, application design, automation, client/server, consulting, council, customer relations, customer service, data collection, database administration, development, finance, financial, forecasting, forms, graphs, invoicing, macros, management, access, access 2000, access 97, excel, office, office 98, word, ms access 2.0, mysql, networking, nhs, odbc, programming, reports, sales, scheduling, specification, sql, stock control, tables, user interface design, vba, visual basic

David Dixon’s Experience

• Lead Developer

  CHI PLC

  (Hospital & Health Care industry)

  August 2010 — Present (2 months)

• Developer

  Orange Personal Communications Services Limited

  (Privately Held; Telecommunications industry)

  May 2010 — Present (5 months)

• Buyer

  The Netfysh

  (Retail industry)

  October 1997 — Present (13 years )

  An independent Internet toy store specialising in the more unusual, fun and the old fashioned toys that you wont find stacked high on the shelves in your local supermarket or high street.

• Computer Consultant

  The Netfolk Limited

  (Computer Software industry)

  April 1994 — Present (16 years 6 months)

  The Netfolk Limited is a family run business with divisions in Software Consultancy, Mail Order Toys and Complementary Therapies. Don't worry there's not much overlap between each division!

• Business Analyst

  CHI plc

  (Hospital & Health Care industry)

  January 2010 — July 2010 (7 months)

  I was requested by client to assist development to the Renal Care system that I developed originally ten years ago. I elicited functionality specifications from medically oriented business requirements. Provided screen mock-ups and use case walk-throughs were used as the primary method of design verification with medical and health care professionals. Provided support and front/back end design knowledge transfer to a new sub contracted development team

• Migration Analyst

  Orange Personal Communications Services Limited

  (Privately Held; Telecommunications industry)

  September 2008 — November 2009 (1 year 3 months)

  Migration of 15 year old Telecom legacy billing/discounting system via human readable meta-data extracts. Documented the legacy system technical low-level functionality from the end user documentation, user workshops and inspection of the original C application coding. The resultant documentation pack is now given to new IT&N staff. Used rapid application design (RAD) Modelling to indentify data trends, confirm data assumptions. Rationalised existing data whilst removing redundant data. Retaining but captured any data inconsistencies to ensure an unchanged customer experience. Produced domain reports to provide high level views to the Teleco's own data previously hidden in the details. A new role is to be created in Orange to provide this service on an on-going basis. Verification of the 3rd party off shore design for the “business as usual” processes during operation of the two billing systems

• MI Analyst

  Hitachi Capital

  (Public Company; Financial Services industry)

  March 2007 — August 2008 (1 year 6 months)

  Assumed ownership of a suite of MI reports with very little handover and no documentation. Stabilised generation of data for daily, weekly, monthly reports then added full audit trails. Standardised data requirements and extract/report layouts. Data required for report generation placed into data repositories thus eliminated duplication of calculations. Automated data extracts from third parties into Oracle system for new customer accounts. Extracted customer payment data for Experian data feeds. Developed a Customer Complaints Application for internal use and industry statistical reporting. Migrated the four division’s customer relationship management data into Salesforce.com. Created Ad hoc reports as requested by the sales and marketing teams.

• Developer

  CHI plc

  (Health, Wellness and Fitness industry)

  January 2007 — February 2007 (2 months)

  Application Development work tailoring bespoke system for new hospital use.

• Database Analyst and Trainer

  Constellation Europe

  (Public Company; 1001-5000 employees; Wine and Spirits industry)

  February 2006 — September 2006 (8 months)

  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.

• Product Development Manager

  CHI PLC

  (Health, Wellness and Fitness industry)

  September 1999 — February 2006 (6 years 6 months)

  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.

• Trouble Shooter

  Celebrity Speakers

  (Computer Software industry)

  November 2001 — December 2001 (2 months)

  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.

• Off shore Consultant

  Equant

  (Public Company; 10,001 or more employees; ENT; Telecommunications industry)

  December 1999 — December 1999 (1 month)

  Was part of the SITA group providing network services to the air transport industry
  
  MS Access Millennium Incident Bulletin System

• Developer

  Hertfordshire County Council

  (Government Agency; 10,001 or more employees; Government Administration industry)

  January 1999 — August 1999 (8 months)

  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.

• Consultant

  Tetra Pak UK

  (Computer Software industry)

  February 1999 — June 1999 (5 months)

  Worlds largest and leading provider of carton packaging
  
  MS Access Timesheet and client invoicing for off-site machine maintenance engineers.

• Product Developer

  Concentric Credit Services

  (Computer Software industry)

  May 1998 — May 1999 (1 year 1 month)

  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.

• Software Consultant

  MW Kellogg

  (Public Company; Oil & Energy industry)

  October 1998 — December 1998 (3 months)

  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.

• Analyst Programmer

  MW Kellogg

  (Public Company; Oil & Energy industry)

  October 1997 — October 1998 (1 year 1 month)

  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.

• Data Analyst

  CDMaestro Limited

  (Computer Software industry)

  May 1998 — July 1998 (3 months)

  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.

• Office Supplies Retailer

  Staples UK Limited

  (Computer Software industry)

  November 1997 — January 1998 (3 months)

  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.

• Software Consultant

  Mothercare

  (Public Company; Retail industry)

  April 1997 — September 1997 (6 months)

  Producing time critical MIS reports from multiple sources (including batched AS400 downloads and Lotus 1-2-3 spreadsheets) using a Visual Basic 4.0 front end, MS Access 2.0 to manage the data and Excel 5.0 spreadsheets for the user updateable output via OLE from Visual Basic. Also conversions from Word Perfect to Word 6.0 and Lotus 1-2-3 to Excel 6.0 utilising Visual Basic for Applications. Upgrading the sales/floor space analysis database that I developed the year before for Mothercare to be used by the Store House group.

• Software House

  Mentor Computer Services

  (Computer Software industry)

  December 1996 — April 1997 (5 months)

  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.

• Analyst Programmer

  Accenture

  (Public Company; ACN; Management Consulting industry)

  October 1996 — December 1996 (3 months)

  Contracted to Andersen Consulting, Maltravers Street, London, UK
  
  Using Access 95 and SQL Server 6.0 connecting through ODBC on a Windows 95 platform to produce a number of internal personnel and skills reports for Andersen Consulting sites around the world. The work included further development and documentation of an existing application to strict standards and conversions due to restrictions of WANs and the development of smaller LAN based applications for various internal departments.

• Analyst Programmer

  Mothercare

  (Public Company; Retail industry)

  August 1996 — September 1996 (2 months)

  Working closely with the client to determine the business requirements and implementation of a sales/floor space analysis database using MS Access 2.0. Comparing sales figures, density and footage for each of the Mothercare stores to produce specific reports for various departments at head office.

• Analyst Programmer

  Grass Roots Group PLC

  (Privately Held; Market Research industry)

  November 1994 — August 1996 (1 year 10 months)

  Working in a team of MS Access and AS400 programmers to the specifications of the campaign managers for Britain’s largest multinational promotion and incentives company. Designing and implementing bespoke systems producing reports, graphs and summaries for the Company’s numerous incentive programmes for blue-chip clients.

• Developer

  NatWest

  (Public Company; Banking industry)

  October 1994 — November 1994 (2 months)

  Working on a one-to-one basis with the client with tight deadlines, to produce first the prototype for demonstration purposes, then the functional application to specification. The application, a Financial Management System was written using MS Access 2.0 and incorporated an existing time recording database (written in MS Access 1.0).

• Analyst Programmer

  Liberty Life

  (Public Company; Insurance industry)

  May 1994 — October 1994 (6 months)

  Under contract with F I Group to Liberty Life.
  
  Using Microsoft C with C-TREE and PANEL under MS-DOS, worked to put into place procedures and the development environment required to bring the existing quotes and recommendation system up to BS5750 standard.

• Programmer / Database Administrator

  GAN

  (Public Company; Insurance industry)

  August 1993 — May 1994 (10 months)

  Intensive C programming (development, maintenance, bug fixing) and database administration using both Borland & Watcom C under MS-DOS.

• Software Developer

  Dreamlight Systems Limited

  (Computer Software industry)

  March 1993 — August 1993 (6 months)

  Implemented database, screen handling and text processing libraries for a run-time object oriented prototyping development environment in Borland C under MS-DOS

David Dixon’s Education

• The University of Hull

  Computer Science , Computers , 1989 — 1992

Additional Information

David Dixon’s Websites:

• My Website
• My Company

David Dixon’s Groups:

•    Database Experts
•    University of Hull Alumni
•    Scoring and Analyses
•    MOBILE & WIRELESS
•    Professional Microsoft Access Developers' Network (PMADN)
•    Telecom Industry Jobs
•    The IT Job Board
•    NHS Contract Professionals
•    Strategic Alliances Group
•    IT Professionals in the UK

David Dixon’s Contact Settings

Interested In:

• consulting offers
• new ventures
• job inquiries
• expertise requests
• business deals
• reference requests
• getting back in touch