Personal information for consultant computer programmer Duncan McNeill

 Name:  Duncan McNeill                 Date of birth:  04-21-56

Telephone:  541 771 6446

A responsive self-motivated team player with a proven ability to meet deadlines. Able to work independently or as a contributing player in a group project.

 

Educational background

University of St. Andrews,  Scotland:  B.Sc. Honours degree Physics.

 Heriot-Watt University, Scotland:  M.Sc. Opto-electronic and Laser Devices.

Napier College of Technology:  "C" Programming Certificate

  

Programming language and development environment experience

Microsoft Visual Basic Professional and Enterprise Editions versions 3, 4, 5, 6, 7 (vb.net)

Microsoft Visual SourceSafe source code control

Microsoft SQL Server v7, SQL Server2000

Microsoft Jet database engine

Microsoft Visual Basic for Applications using Access, Excel and Word (Office 95, 97 and 2000)

SQL

Html

Javascript

C language

8086 Assembler language

Pascal

Clipper database development language

Dbase v3 and v4

Paradox

  

General computer background

 

A computer programmer and consultant with 13 years of professional experience, 8 years of which were as the owner and CEO of Advanced Computer Technologies, a small software development company based in Scotland.

Although a specialist in computer programming, I have assembled over 50 computers, installed several different computer networks, conducted computer training, developed web sites and have a thorough knowledge at all levels of the Microsoft Office applications. I am well versed in systems analysis and program design/specification as well as in application documentation preparation.

 In the course of my work I have also been responsible for data conversion from legacy systems to modern database environments.

 

Other relevant skills

 As a result of designing and programming several accounting and order processing systems, as well as running my own company for 8 years, I have a detailed knowledge of accounts and general workflow in a company environment.  I am also a proficient user of several standard applications used in business and design environments e.g. Microsoft Project, Adobe Photoshop, Microsoft Frontpage, Microsoft Outlook,  Search engine submission software, FTP file transfer programs.

  

Operating systems experience

 I have installed and have a thorough knowledge of the following operating systems.

Windows XP 

Windows2000

WindowsNT 4

Windows ME

Windows98

Windows95

Windows 3.1

MSDOS versions 3 to 6

  

Internet development

 Designed, coded and graphic work for several web sites, including the implementation of a shopping basket based site.

 

Relevant career history

1989-1997

Owner, programmer and consultant. Advanced Computer Technologies, Scotland

1998-2004

Freelance computer programmer and web site designer.

Most recent employment March 2000 – September 2000 

Conversion of large Access based GL Suite application (32 basic code modules, more than 50 Visual Basic for Applications forms, and 112 data tables) to Visual Basic v6 multi-tier architecture application with Visual Basic MTS components for the business logic layer, Access Visual Basic for Applications user interface and Microsoft SQL Server 7 data layer.

The following list is a sample of some of the projects which I have undertaken. More details available on request.

Windows Projects

Modernization of GL Suite application (Microsoft Access, Visual Basic Enterprise Edition v6, Microsoft SQL Server 7, MTS component development)

Conversion of an extensive Access program with over 30 code modules to a Visual Basic MTS component based 3 tier network program.

Use of SQL Server 7, Access and SQL as an aid in data conversion tasks converting data from legacy systems to SQL Server 7 database.

Microsoft SQL Server 7

Create and administer databases from legacy database systems.

TSQL programming of stored procedures and triggers.

Extensive and complex SQL code as the data access layer in multi-tier application development 

Invest/o real time investment portfolio and risk management system (Visual Basic v5 / v6)

Automated analysis of stock data for the preparation of daily statistics and a stock information newsletter. 

Natural Areas Association database management system (Visual Basic v5/v6)

A database system for maintaining marketing, membership and payment data. Used to automate the generation of member subscription renewal notices and member mailings.

Horticultural Management system (Visual basic v5/v6)

Complete accounting system for horticultural nursery management. Bar-code label printing, reports, financial analysis, integration with bar-code scanning hand held programmer and many other features were available in this multi-user application.

 

Visual Basic for Applications – Excel programming

Provision of extensive Excel Visual Basic for Applications programs to aid in the analysis and presentation of stock information.

 

Viewit real estate listing web page generating system (Visual Basic v5)

An Access database was used as the source data for the provision of html pages for viewing from client internet web sites. The Visual Basic program generated the html pages which included listing details and photographic images of real estate listings based on the stored data in the Access database.

 

Learning Disabilities Patient Management System (Visual Basic v3)

An extensive and configurable system with over 50 child windows for the maintenance and automatic scheduling of all patient information relating to patients with learning disabilities. The system included a screen designer which allowed the user to configure the layout of the individual windows.

 

Integrated customer sales tracking system (ACT, Word, Excel)

An integrated system using Word, ACT Contact management program and Excel for the complete control of work-flow for a garage door installation company. The system automatically brought the client information on-screen when a telephone call was received.

  

Web Projects

www.dshobbies.net

Shopping basket web site for the sale of children’s fleece outerwear

www.pccraft.com

 

MSDOS Projects

 Database management system for the collection of data from heart pacemaker units from patients.

This system took data from and supplied control data to a Tectronics hand held heart pacemaker control unit. The system provided a PC interface for the control of this unit as well as the collection and management of data from this unit, thereby allowing the collection of statistical data for heart patients. This project was conducted in collaboration with the cardiac unit at Newcastle Hospital.

Real time interrogation of data stream from PC games port (8086 Assembler)

This project required analysis of the data stream arriving at the games port using an oscilloscope and then the provision of an assembler routine for the real time collection of data. A database management system, using Clipper was written to maintain the collected data.

 File backup and deletion utility for MSDOS (C)

A file backup utility which updates destination file copies and removes redundant files from the copy destination when these redundant files are no longer part of the backup file set. This was an MSDOS command prompt style utility.

Sales order processing, purchase order processing, general ledger system (Clipper)

This system forms a complete workflow management system with integrated accounts all the way from initial order entry to general ledger maintenance. A full reporting module, inventory control, and multi-user operation.

 

Symbol Technologies hand held programmer bar code scanner program

The provision of an inventory bar code reading program for a Symbol Technologies hand held laser bar-code scanner in order to read inventory bar-code labels for the purpose of order, invoice  and inventory level management. Symbol hand held programmer language.

 

Nurseryman database management system (Clipper)

A complete accounting system (sales ledger, purchase ledger and general ledger) for the management of large horticultural nurseries. This program was a market leader in the UK. The program maintained inventory, printed plant labels, processed orders and integrated to a word processor.

Networking

Windows XP

Windows 2000

Windows NT v4

Windows ME, 98 and 95

Windows for Workgroups v3.11

Novell Network v3.11 and v4

Lantastic network

 

Hardware Projects

PC construction (about 50 units)