Personal Details

Date of Birth:       

Sex:                      Male 

Please use email address for contact

Experience

December 2003 – Present         [snip]    Glasgow

IT Consultant (Developer)

       This position is my first role as a self employed IT Consultant and involves me creating, project managing, and supporting database systems for various internal departments and external areas within the [snip] and for some of our 3^rd party customers. I work within the Management Information department so I do get an insight into the products offered by this division of [snip] namely credit cards and loans. As part of the small MI team I also help produce the MI reporting on a daily basis as well as design many of the systems that produce the reporting.

Systems are developed using Access 97/2002 and SQL Server 2000.

I have been involved in each of these projects throughout the full development life cycle, from sitting with the customers to define their requirements to training and continued support of the systems.        

July 2000 -  December 2003      [snip]                      Edinburgh

IT Asset Management

IT Asset Analyst                                                             

        This position involves administering all IT and telecomms assets within the company. This includes processing customer requests for software, PCs, servers and telephony equipment and also raising jobs for analysts to install them. We are involved from the initial request for the asset, through ordering from a supplier, to the eventual installation. Software licensing and maintenance of both software and hardware assets is also handled by our department.  

Half of my work is also spent developing and supporting the companies Asset Inventory MS Access database. This database stores information on jobs raised for analysts, orders sent to suppliers and also an extensive asset inventory. The upkeep of this database has required me to add extra functionality when required and also keep it running smoothly for the large number of people in IT Service Management that use it.

June 2000- July 2000             Scottish Power                              Glasgow

Developer (Contractor) 

       This position involved writing Visual Basic programs to help bring data from one mainframe system to another. This was done by using OLE commands in the VB applications to copy information from mainframe screens into an Access database which then used this info to paste into another mainframe session.

May 2000 – June 2000   United Distillers & Vintners                   Glasgow

IT Support (Contractor) 

       This position mainly involves the support of a number of UDV’s Oracle based systems. Much of my work is checking that data is transferring between the various systems correctly and that the data being entered is valid.

       As it is an Oracle system, some of my work involves the use of SQL through Oracle’s SQL Plus.

June ’99 – Dec ’99         Buchanan Clark + Wells plc.                  Glasgow

Developer

       Developed and maintained applications using Access, Visual Basic and SQL Server 7. Involved at the beginning of the development life cycle by designing Entity Relationships Diagrams, table structures and other forms of documentation. As I designed and implemented the systems, I also documented training manuals for their use. I was also involved in consulting clients on how they wanted the system to look, constant client interaction after application was completed. Used VB Front End for some applications, making use of ADO code rather than ADO controls. Attended 2 Microsoft SQL Server 7 courses – SQL Server Design and SQL Server Admin.

       I was also responsible for allowing data to be imported from a clients AS400 system onto to our SQL Server. This involved a great deal of data alteration using SQL queries.

       As I was working in a small department I was also responsible for other duties such as general system maintenance and working as part of an IT Helpdesk. I also worked closely with my manager when suggesting new hardware and software for the company.

Jan ’98 – Sep ‘98           Barclays Stockbrokers Ltd.                   Glasgow

Office Junior (Finance)

§     Part of my University placement year.

§     Responsible for checking all invoices coming into the company.

§     Developed a spreadsheet to keep track of payments.

§     Acted as a way for the Finance Department to communicate with other departments.

§     Handled any queries from suppliers.

Sept ’97 – Oct ‘97          National Australia Group                        Glasgow

Computer Operator (I.T. Security)

§     Company that owns banks such as the Clydesdale and Yorkshire banks.

§     Part of my University placement year.

§     Entailed setting passwords and authority levels for bank staff.

Professional Certifications

October 2004

§     Microsoft Certified Professional

Passed Exams:

·         Developing and Implementing Windows Based Applications with Microsoft Visual Basic .Net and Microsoft Studio .Net

·         Developing and Implementing Web Based Applications with Microsoft Visual Basic .Net and Microsoft Studio .Net

Education

96 – 99                     Glasgow Caledonian University                          

§     B.A., Business & Information Management

Subjects (Year 3)

·         Marketing

·         Business Information Technology III

·         Database Design & Development

·         European Marketing

·         Business Administration

·         Financial Studies III

Subjects (Year 2)

·         Organisational Psychology

·         Business Information Technology II

·         Financial Studies II

·         Business Practice & Communication*

·         Database Management*

·         Economics II*

·         Cross Cultural Communication*

·         Communication in Danish

* These subjects were sat during an ERASMUS student exchange programme with the Herning Institute Of Business & Technology in Denmark. This was undertaken during my second semester. 

95 – 96                              Stow College                                              Glasgow

§     HNC Information Technology & Business Administration

Subjects

·         Basic Communication in French

·         Document Processing

·         Structure of Business Organisations

·         Systems Development 1 – Tools & Techniques

·         Software Engineering Development Life Cycle

·         Introduction to Database Management Systems

·         Analysis of Financial Data for Control & Appraisal

·         The Economic Environment

·         Collection & Analysis of Numerical Data

·         Communication: Selecting & Presenting Complex Information

·         Numerical Processing Using Spreadsheets

·         Utilising the Computer Resource

81 – 95                              The High School Of Glasgow

Training

·         Attended 7 Day Accelerated MCAD Training (October 2004)

·         Attended Advanced VB6 Enterprise Edition Course (Jan 2003)

-          ActiveX Components

-          ActiveX Controls

-          COM Overview

-          ActiveX Component Design

-          Scalability and Distributed Objects

-          Remote Data Access Overview

-          ADO Fundamentals

-          Advanced ADO

-          The Data Environment

-          ADO Data Tools

-          Multi-User Considerations (in ADO 2.0)

-          Internet Features

·         Attended training course on SQL Server Design

·         Attended training course on SQL Server Admin

·         Extensive knowledge of Visual Basic 6.0 & .Net, MS Access and SQL Server

Achievements

·         The project I undertook at Buchanan Clark + Wells was carried out mostly on my own and required me to work to a very tight schedule while also learning fast.

·         I was given the award for “Outstanding performance in HNC Information Technology & Business Administration.

Interests

·         Sailing (Gained my Competent Crew sailing award)

·         Music (Guitar)

References

On Request