at CHI plc
York, United Kingdom
- Current
-
- Business Analyst at CHI plc
- Computer Consultant at The Netfolk Limited
- Past
-
- 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
- Education
-
- The University of Hull
- Connections
-
50
connections
- Industry
- Computer Software
- Websites
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
-
Business Analyst
CHI plc
(Hospital & Health Care industry)
January 2010 — Present (2 months)
-
Computer Consultant
The Netfolk Limited
(Computer Software industry)
April 1994 — Present (15 years 11 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 employee overlap between the jobs in each division!
-
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:
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
David Dixon’s Contact Settings
Interested In:
- consulting offers
- new ventures
- job inquiries
- expertise requests
- business deals
- reference requests
- getting back in touch
