CURRICULUM VITAE.

 

 

Dr. David Gee, B.Sc., B.A., Ph.D., MBCS, M.Inst.P., C.Sci., C.I.T.P., C.Phys., C.Eng.

 

 

Consultant for Tokentime Ltd,

Birmingham.

 

Telephone: 0121 777 3107 (answerphone)

Mobile: 07976 422 429

 

Email: davegee@tokentime.com

Website: http://davidgee.com/

Download latest CV from: http://davidgee.com/download/

 

 

 

 

 

 

 

Level

Livelink Consultant, Data Migration and Analysis expert, Database Administrator, Designer/Programmer, Web Author.

 

 

Skills  

ORACLE 7, 8i & 9i, Forms 4.5, Developer 6i & 9i, JDeveloper (Java), SQL, XML, Pro*C, C, MS-Access 97-2007, Visual Basic 4.0 & 6.0, SQL Server 7.0-2005, MySQL 4.0.24, PHP, VBScript.

 

MIMS 4.3.1, MintScript, BOC, ReportLink, Livelink 9.2.0,9.5,9.7.

 

Website Design and Development, MS FrontPage and Visual Interdev 6.0, (HTML, JavaScript and VBScript), Netobjects Fusion.

 

 

Operating Systems

Windows XP Workstations and Servers, Vista, UNIX SVR4, AIX, SunOS, Solaris, X-WINDOWS, LINUX, VMS and OpenVMS.

 

 

Hardware   

SUN, IBM, HP and DEC Unix servers. Various PCs and servers. Various VAX systems.

 

 

Availability

November 2009.

 

 


SKILLS SUMMARY

 

SKILLS

EXPERIENCE

 

 

Livelink 9.2.0 & 9.5.0.1 & 9.7

5 years

Livelink Workflows

3 years

MySQL

6 months

PHP

6 months

Oracle Developer 9i

1 year

MS Access (all versions)

9 years

MIMS 4.3.1

4 years

Oracle 6, 7, 8i & 9i

10 years

Developer 6.0 & 6i

2 years

SQL Server 2000 & 2005

4 years

Web Site Design & development

5 years

HTML

3 years

Java

1 year

Visual Basic 4.0 & 6.0

4 years

Visual Interdev 6.0 & FrontPage

6 months

Pro*C,

2 years

Pro*COBOL,

1 year

C

3 years

COBOL

2 years

BASIC

6 years

 

 

OPERATING SYSTEM

PLATFORM

EXPERIENCE

 

 

 

WINDOWS Vista

Various PCs

1 year

WINDOWS XP

Various PCs

4 years

WINDOWS 2000

Various PCs

5 years

Red Hat Linux 6.1

PCs

1 year

UNIX

Various platforms (see below)

6 years

DEC UNIX

DEC Alpha

2 years

AIX 3.1,3.2, X-WINDOWS

IBM RS6000

3 years

HP/UX

HP 9000

6 months

SunOS 4.1.1, Solaris 2.

SUN SPARCStation

9 months

VMS 4.7 - 5.4.

Various VAX

5 years

 

 

EDUCATION

 

ESTABLISHMENT

DATE

QUALIFICATIONS

 

 

 

Open University

2000

B.A. (2.2) in Pure Mathematics.

Birmingham Polytechnic

1987

Polytechnic Certificate in Computer Studies

Aston University

1981

Ph.D. in Medical Physics

 

 

(Computing and electronics)

Aston University

1977

B.Sc. (2.1) in Physics

Waverley Grammar School

1974

4  "A" levels

 

1972

10 "O" levels

 

 

 

PERSONAL DETAILS

 

Marital Status

Married.

Nationality

British.

Car Licence

Full and clean.


EXPERIENCE IN DETAIL

 

National Health Service,

 

Database Designer/Builder

Birmingham.                       

 

August 2009 to Present.

                                                                                                                                   

Hardware

Operating System

Languages

Dell Workstations

Windows XP, Vista

MS-Access 2007

HP Servers

Windows 2003 server

SQL Server 2005

 

I am currently designing a database in MS-Access and SQL Server to capture audit data for the Cardiac and Stroke  Network, collecting data from several NHS Trusts across the Network.

________________________

 

National Grid Company plc.

 

Contract Data Migration expert/Business Analyst/Livelink Consultant.

Coventry and Solihull.

 

September 2003 to August 2009.

                                                                                                                                   

Hardware

Operating System

Languages

PC’s

Windows XP, Vista

MIMS 4.3.1, LiveLink 9.2.0 & 9.5.0.1 & 9.7

 

Windows 2003 Server

Oracle 7.3.4, 8.1.7 & 9.2.0.1.

 

AIX 3.2.

MS-Access, SQL Server2000 - 2005.

 

 

Developer 9i & TOAD 7.5.

 

I was part of the team migrating a Drawings database called EDDIS (Oracle 7.3.4) into LiveLink, a web-based repository that uses an Oracle 9i database, including data from MIMS (Oracle 8i), the asset register. My remit was to configure the environments, write the specification of the data migrations, write the migration project and test plans, create the database extracts, and perform the data loads. I then moved onto designing, building and administering our own hosted Livelink system (SQL Server 2005). This included developing extensive workflows in Livelink, with supporting Java and LAPI code to automate various processes.

________________________

 

Register for Chinese Herbal Medicine

 

Contract Database Designer/Web Author.

Alcester Road South, Birmingham.

 

December 2004 to August 2005

                                                                                                                                   

Hardware

Operating System

Languages

PC’s

Windows XP

NetObjects Fusion 7.5

Webserver

Linux

MySQL 4.0.24

 

 

PHP 4.3.11.

 

 

phpMyAdmin 2.6.0-pl3.

 

I was commissioned to design and create a Web database to gather comments about particular Chinese Herbal Medicine treatments. A database was required rather than a simple blog as the data was to be used for subsequent analysis and research. The database was written in MySQL, and PHP was used on the site to access it, and to provide security to the site to prevent unauthorised access.

________________________

 

Lane Associates.

 

Contract Developer.

Painscastle, Powys.

 

January to February 2004.

                                                                                                                                   

Hardware

Operating System

Languages

PC’s

Windows 2000 and XP.

Developer 9i, TOAD 7.5,

 

 

Oracle 9.2.0.1.

 

I was developing Forms and Reports for a new build of an Order and Fault tracking system for a Telecommunications company. All of the work was completed off-site at Tokentime’s offices.


 

EXPERIENCE IN DETAIL

 

CPD Logistics,

 

Contract Data Analyst/Designer/Builder

Wellesbourne, Warwickshire.

 

July to August 2003.

                                                                                                                                   

Hardware

Operating System

Languages

PC’s,

Windows 2000 & XP

MS Access 2000, DAO,

PC Fileservers

Windows 2000 Server.

SQL Server 2000

 

I was commissioned to perform a data migration of a number of mission-critical databases from Microsoft Access to SQL Server 2000. This also involved the rewriting of a number of code modules in DAO to improve the performance of the applications.

________________________

 

AMT-SYBEX,

 

Consultant Data Migration and Analysis

Letchworth, Herts.

 

December 2002 to June 2003.

                                                                                                                                   

Hardware

Operating System

Languages

PC’s,

Windows NT 4 and. 2000

MS Access 97 and 2000,

 

MIMS 4.3.1

Visual Basic 6,

 

 

Oracle 8.1.7,

 

 

MINT Script,

 

 

Business Object Connector.

 

I was working as a MIMS consultant for AMT-SYBEX at Network Rail, Glasgow. The main areas have included data analysis, manipulation and data migration of legacy data to an Oracle database using a scripting language called MINT Script, and a Visual Basic API called Business Object Connector.

________________

 

BMW Moteren GmbH

 

Contract Database Designer/Builder

Hams Hall, West Midlands.

 

January to April 2003.

                                               

Hardware

Operating System

Languages

PC’s

Windows NT 40 and. 2000

MS Access 2000,

IBM RS6000

AIX

Oracle 9.2.0.1.

 

I was commissioned to design and build a database with an Access frontend and an Oracle backend to handle Material Analysis data for the laboratories at BMW. The work involved the full development cycle, from tendering against opposition such as Oracle and CSC, through specification and design of the user interfaces and reporting, to implementation, database set-up and tuning, training and documentation.

________________________

 

National Grid Company plc.

 

Contract Database Designer/Builder

Wolverhampton.

 

March 2001 to November 2002.

                                                                                                                                   

Hardware

Operating System

Languages

IBM PC’s,

Windows NT 4.0 and 2000

MIMS 4.3.1, BOC, ReportLink

Gateway Pentium Pros

Workstation and Server

Oracle 7.3.4, 8i, 9i.

IBM RS/6000 servers.

AIX 3.2.

Visual Basic 6.0 MS-Access 97

 

 

Developer 6i, JDeveloper.

 

 

SQL Server 7.

 

I have been writing Visual Basic programs to migrate data from an Oracle 7.3.4 legacy system into an Oracle 8i system through a MIMS API. I have also completed several short-term consultancies for other departments of National Grid in work on JDeveloper Oracle frontends, database upgrades to Microsoft Access 97 and developing an Intranet site using Visual Basic 6.0 linking to a SQL Server 7.0 database.

 


 

EXPERIENCE IN DETAIL

 

National Health Service,

 

Web Author, Database Designer/Builder

Birmingham.                       

 

October 1995 to October 2002.

                                                                                                                                   

Hardware

Operating System

Languages

Gateway & Dell

Windows NT 4.0

MS-Access 97 & 2000,

Pentiums

Windows 2000 server

SQL Server 7.0 ,

 

 

NetObjects Fusion 7.0.

 

I have developed several PC user interfaces in Microsoft Access to SQL Server 7.0 databases for Thrombolysis and CardioPulmonary Resuscitation clinical audit packages. I have also developed three Microsoft Access databases for nursing research into Elements of Care and Patient Satisfaction Surveys. All of these I have sold to the Health Service (see reference 3).  More recently, I was commissioned to develop a complete website for research into Crohn’s Disease (see http://www.crohnscolon.co.uk), and further databases for Waiting List management, a Rapid Access Chest Pain Clinic and Independent Care Pathways. All of this has been off-site work for the NHS.

________________________

 

Austen Consultancy Ltd.,

 

Contract Designer/Builder

Aldershot, Hampshire

 

December 2000 to March 2001

                                                                                                                                   

Hardware

Operating System

Languages

Various PC’s,

Windows 2000 and NT 4.0

Oracle 8.0.5, 8i

 

 

Developer 6.0 & 6I, JDeveloper.

                                                                 

I was part of a team developing a performance monitoring system for Merseyside Police. My part of the work involved developing forms and reports, and creating HTML pages in which to run them. As the whole system was to be deployed on the web, I had to ensure that all of the forms would work in a browser.  I had to be security cleared for this post. All of the work was carried out at Tokentime’s offices.

________________________

 

FI Group plc.,

 

Contract Designer/Builder

Birmingham.

 

June 2000 to October 2000

                                                                                                                                   

Hardware

Operating System

Languages

Compaq PC’s

Windows 95 and NT 4.0   

Oracle 8.0.5, 8i

IBM RS/6000

AIX 4.3.2.

Developer 6.0 & 6i.

                                                                 

I was part of a team designing, building and testing a telex billing system for British Telecom. My part of the work involved being the Oracle expert, designing a forms template for the other developers to use, and writing specifications for forms, reports, pl/sql packages and Unix shell scripts. I also developed forms, packages and shell scripts, and took part in supporting system testing.

________________________

                                                                 

National Grid Company plc.,

 

Contract Designer/Builder

Sutton Coldfield, West Midlands.

 

November 1994 to June 2000.

                                                                                                                                   

Hardware

Operating System

Languages

IBM PC’s,

MS-DOS 6.2, Windows 3.11

Forms 3.0 & 4.5,

Elonex Pentiums,

Novell NetWare, TCP/IP

Oracle 6.0.37 & 7.3.3,

IBM RS/6000 servers.

AIX 3.2.

Visual Basic 3

 

 

MS-Access 97 & 2000

                                                                 

I designed, built and implemented a client/server Fault and Defect reporting system using Forms 4.5, Visual Basic 3, Microsoft Access and Oracle 7.3. The system has been rolled out across the whole of National Grid, fully supported and documented. The work required quite involved tuning of the Oracle database and ODBC links through to Access as well as writing database triggers and procedures.

On the project before this, I designed, built and implemented Forms 3.0 software and associated reports for a Contract Management System. Most of the work was unsupervised, only subject to review once complete.


 

EXPERIENCE IN DETAIL

 

A.F. Blakemore and Son Ltd.,

 

Contract Consultant/ Database Administrator.

Willenhall, West Midlands.

 

September 1994 to November 1994

                                                                                                                                   

Hardware

Operating System

Languages

SUN SPARCservers.

SunOS 4.1.1                         

Oracle 6.0.34,

 

Solaris 2.

Forms 3.0,

 

 

SQL*DBA.

 

I was a Database Administrator for a number of mission-critical Oracle databases in this large retail company.

 ________________________

                                                                 

SpecPro Systems Ltd.,

 

Contract Consultant

London.

 

July 1994 to September 1994

                                                                                                                                   

Hardware

Operating System

Languages

Various PC’s and

MS-DOS 6.2, Windows 3.11,

MS-Access 2.0,

networked fileservers

Novell NetWare, TCP/IP.

Visual Basic 3.0.

 

I developed a Housing Management System for a systems house. The post involved recruitment and supervision of one other programmer, project management, database design, coding and implementation.

________________________

 

Lucas Aerospace Ltd.,

 

Contract Analyst/Designer

Birmingham.                       

 

September 1993 to July 1994.

                                                                                                                                   

Hardware

Operating System

Languages

IBM RS/6000 server

AIX 3.1, X-WINDOWS     

ORACLE v 6 & 7,

and X terminals.            

 

Forms 3.0 &4.0, Pro*C.

 

I was the Oracle 'guru' in a four-man team developing a Drawing Management Control System. The post included mainly Database Administration, but also Forms and Pro*C programming, and planning an Oracle 6 to 7 migration.

________________________

                                                                                                                                   

Rank Xerox Ltd.,

 

Contract Analyst/Designer

Mitcheldean, Gloucestershire

 

March 1992 to September 1993.

                                                                                                                                   

Hardware

Operating System

Languages

VAX 8650

VMS v 5.4,

ORACLE v 6.0, Forms 3.0

SUN SPARCStation

SunOS 4.1.1 (UNIX SVR4)

Pro*C, Pro*COBOL.

 

I was part of a team designing, building, testing and implementing an ORACLE system for EDI (Electronic Data Interchange). I have also been responsible, in a DBA capacity, for developing Forms 3.0 programming standards for the organisation, using an advanced technique to incorporate menu bars in forms, similar to the Forms 3.0 designer interface.

________________________

 

Medical Portfolio Ltd.,

 

Contract Analyst/Designer.

Tipton, West Midlands.

 

January to March 1992.

                                                                                                                                   

Hardware

Operating System

Languages

ICL DRS6000.

DRS/NX

C

Various 386 PC’s

MSDOS 5.0, WINDOWS 3.1

 

 

This post involved analysis and design of a communications link between Hospital Administration Systems and Healthcare Pathology Laboratory systems.


EXPERIENCE IN DETAIL

 

CSL Group Ltd.,

 

Contract Analyst/Designer

Edgbaston, Birmingham.

 

September 1991 to January 1992.

                                                                                                                                   

Hardware

Operating System

Languages

IBM RS6000,

AIX v 3.0,

ORACLE v 6.0,

HP 9000.

HP /UX.

SQL*FORMS 3.0,

 

 

SQL*MENU 5.0,

 

 

Report Writer,

 

 

Pro*C.

                                                                 

I was involved in analysis and design of Healthcare systems, using a beta test version of ORACLE. I designed reports, menus, forms and Pro*C programs, developing techniques to implement Dynamic SQL.

________________________

 

Brann Direct Marketing,

 

Data Analyst.

Cirencester.

 

July 1991 to August 1991.

                                                                                                                                   

Hardware

Operating System

Languages

VAX 8500

VMS v 5.3.

Powerhouse,

 

 

CMS, COBOL.

                                                                 

This post mainly involved data analysis of coding systems for a large database, in the order of 2Gbytes, for the North West Bank direct mailing system.

________________________

 

Barclays Bank Plc.,

 

Contract Systems Manager/Programmer.

Radbroke Hall, Knutsford

 

December 1990 to June 1991.

                                                                                                                                   

Hardware

Operating System

Languages

IBM RS6000,

AIX v.3.0

C, DECnet,

VAX 6310 cluster,

VMS v 5.3,

Microsoft C.

IBM PS2,

MSDOS 3.3.

 

NCR AT 80286.

 

 

                                                                 

This contract covered systems programming functions on PC's and VAXes and systems support for RS6000's and a VAXcluster-based sub-system.  More importantly, systems management work on the VAXes included sole responsibility for backups and deputy-managing the network.

________________________

 

ITT World Directories Ltd,

 

Contract Analyst/Programmer

Birmingham .

 

June 1990 to November 1990

                                                                                                                                   

Hardware

Operating System

Languages

VAX 8600 cluster

VMS v 5.3.

VAXBASIC,

DELL 325

MS-DOS v 4.01.

FMS,

 

 

All-in-1,

 

 

PC ORACLE v.6.

 

My work at ITT involved the complete development cycle, from functional and technical specs, through design to coding and testing, ending in quality reviews.  The work was contracted to ITT from British Telecom Yellow Pages, so required analysis, programming and documentation standards to be of the highest calibre.


EXPERIENCE IN DETAIL

 

Rank Xerox Ltd,

 

Contract Analyst/Programmer

Mitcheldean, Gloucestershire.

 

November 1989 to May 1990.

                                                                                                                                   

Hardware

Operating System

Languages

VAX 8650

VMS v 4.7

ORACLE v 6.0,

 

 

SQL*FORMS 2.3,

 

 

Pro*C, Pro*COBOL

 

I was part of a team designing, coding, testing and implementing an ORACLE version 6 system for a process control concept called JIT, or Just-In-Time. The system was a showcase of both ORACLE and JIT for the Rank Xerox organisation worldwide. The post involved the design of the database, and design to implementation of the forms and user exits to link to the resident COBOL-based Materials Control System.

________________________

 

HR Systems Ltd,

 

Contract Analyst/Programmer.

Leicester.

 

September to November 1989.

                                                                                                                                   

Hardware

Operating System

Languages

MicroVAX

VMS v 5.1

BASIC, DECnet.

 

This post involved maintaining and enhancing the "Textel" system, which is a fax and telex message communications system for VAXes and PC's. The post particularly required analysis skills and knowledge of communications.

_________________________

                                                                                                       

AT & T Istel Ltd,

 

Contract Analyst/Programmer

Redditch.

 

May to August 1989.

                                                                                                                                   

Hardware

Operating System

Languages

VAX 8300,

VMS v 5.0,

VAXBASIC,

VAX 750.

VMS v 4.3.

TDMS,

 

 

CDD,

 

 

DECnet.

 

I was part of a team involved with the enhancement of an automated Paint Shop Management System at the Land Rover Works, Solihull. My duties involved program maintenance and development, and systems analysis. I performed an upgrade of the system from a VAX 750 to VAX 8300, going from version 4.3 to 5.0 of VMS.

________________________

 

Norris Computing Ltd,

 

Contract Analyst/Programmer

Erdington, Birmingham.

 

February to May 1989.

                                                                                                                                   

Hardware

Operating System

Languages

DELL 80386 AT

MSDOS

C

 

I was developing and maintaining software in C for a British Telecom Z80-based parallel processing system used to test multiple telephone exchanges.

________________________

 

Tarmac Roadstone,

 

Contract Analyst/Programmer

Ettingshall, Wolverhampton

 

May 1988 to February 1989.

                                                                                                                                   

Hardware

Operating System

Languages

VAX 750

VMS

VAXBASIC

PDP 11/73

RSX11M+

BASIC + 2

 

At Tarmac, I was part of a team of 10 designing, coding and implementing a fully automated Quarry System, the most advanced in Europe. This involved working to tight specifications and timescales.

EXPERIENCE IN DETAIL

 

Datachecker Systems

 

Contract Analyst/Programmer.

Maidenhead, Berks

 

February to May 1988

                                                                                                                                   

Hardware

Operating System

Languages

DEC PDP 11/73

RSX11M+

COBOL, FMS.

 

I was in charge of software design and development of an electronic point of sale (EPOS) query and reporting system. This involved maintenance of some existing software, and design and implementation of new software to suit customer specifications for Gateway and W.H. Smith chain stores. The project was completed and implemented on schedule.

________________________

                                                                                                       

United Health Systems,

 

Contract Analyst/Programmer.

Victoria, London.

 

February to December 1987.

                                                                                                                                   

Hardware

Operating System

Languages

Jarogate Sprite 80286 AT

UNIX

C.

 

In this spare-time contracting post, I designed and coded Pathology Laboratory communications, applications and utilities using Jackson Structured Design Methodology. I also installed the systems at NHS and Army sites.

________________________

 

Sandwell General Hospital,

 

Basic, then Senior Grade

West Bromwich,

 

Physicist/Computer Scientist

West Midlands.

 

1982 to 1987.

                                                                                                                                   

Hardware

Operating System

Languages

DEC PDP 11/23,

RSX11M

BASIC  + 2,

DEC PDP 11/34

 

PASCAL,

 

 

MACRO-11,

 

 

DATATRIEVE.

 

At the Basic Grade, I was System Manager in a project to computerise a Pathology Laboratory, specifying, designing and implementing both communications and data processing software.

 

At the Senior Grade, I was in charge of the analysis, design and development of a computerised Intensive Care System, acting as both Project and System Manager. The work involved applications and communications software to obtain data from monitoring equipment, and load it onto the system database.

_________________________

 

GEC Telecommunications,

 

Digital Electronics Development Engineer.

Coventry.

 

1981 to 1982.

                                                                                                                                   

Hardware

Operating System

Languages

IBM 360

MVS, TSO

FORTRAN 77

 

 

PASCAL

 

Apart from designing digital fibre optic telecomms systems, I developed a method of computing waveform attenuation in fibre optic transmission lines, using Fast Fourier Transform techniques.

_________________________

                                               


EXPERIENCE IN DETAIL

 

University of Aston in Birmingham,

 

Ph.D. Research Student.

Birmingham B4 7ET.

 

1977 to 1981

                                                                                                                                   

Hardware

Operating System

Languages

ICL 1904s

GEORGE 3, MOP

ALGOL-60, 68R,

 

 

FORTRAN 77,

 

 

GINO-F, GINOSURF.

 

The major part of my research was a theoretical investigation of ultrasonic diffraction, involving Physics, Maths, and Computing. I designed and coded software that produced the first ever three-dimensional surface maps of diffraction fields, resulting in two published papers.

 

PUBLISHED PAPERS

 

1.       Archer-Hall, J.A., Gee, D., "A Single Integral Computer Method for Axisymmetric Transducers with Various Boundary Conditions", NDT Int., 13(3), 1980, 95-105.

 

2.       Archer-Hall, J.A., Gee, D., "Computing Particle Velocity and Intensity in Diffracting Systems", Ultrasonics, September 1982, 224-230.

 

3.       Gee, C.E., Gee, D., "Audit Analysis of Cardiopulmonary Resuscitation Events", Conference proceedings, November 1992, BJHC Books.

 

4.       J.M.Thompson, M.Evans, K.Gee, D.Gee & E.Aspinwall, "Reliability and maintainability engineering studies of defibrillators undergoing two different planned maintenance patterns", Oral presentation in Session on Quality at the 1st Joint Annual Scientific Meeting of The Institute of Physical Sciences in Medicine and the Biological Engineering Society, University of Keele, Sept. 14-16 1994. Abstract published in conference proceedings.

 

HOME OFFICE DEVELOPMENT SETUP

 

Hardware

Dell Precision workstation T7400

2 x Dell Precision workstation 670

Dell Precision laptop M90

Dell Inspiron laptop 1525

Acer Aspire netbook

Dell multifunction laser printer

Fasthosts hosted server running SQL Server 2005 Workgroup, IIS, Tomcat, Livelink.

1TB SAN automated backup

 

Network

50Mbps Virgin cable internet connection unlimited up/download

8Mbps BT ADSL connection for backup

1Gbps wired LAN

54Mbps WiFi

 

Software

MS Visual Studio .net 2003 Ent Developer

Eclipse Classic 3.5.0

SQL Server 2005 Workgroup

Oracle 9i and Developer

Textpad!