Some of the projects I was involved with whilst working with Company Net, Edinburgh:

Bank of Scotland (Intranet):
Developed and project managed a secure, database-driven intranet for the Bank of Scotland's Legal Services Department (now UK group Risk & Compliance Division) in order to pool the large amount of legal, regulatory and administrative data and information which employees require access to on a daily basis. Prior to implementing the intranet, the Division had only fragmented access to various information sources, many held in paper form. Powerful search facilities were incorporated into the intranet to make it easy for employees to find detailed information quickly and efficiently – this was done using SQL queries to search the database content together with MS Index Server to search through all the HTML pages. Active X controls were also used for the browsing, viewing and editing of MS Office files.

Morton Fraser Relocations (Extranet):
Developed a website for Morton Fraser and their customers to regularly monitor the management of employee relocations. Complex calculations and SQL queries were used to produce financial reports for each customer providing details on outstanding relocations, previous completed relocations and all relocations within any time period. An intuitive navigation bar was developed using DHTML. This site was predominantly database driven (using SQL server) populated with data daily from Morton Fraser’s systems. A trigger was written on one of the database tables to launch an email to Morton Fraser upon the addition of a new relocation case.

Scottish Fire Service (Extranet):
Developed an internet based fire safety teaching programme for the Scottish Fire Service. The project was the first of its kind and was led by Lothian and Borders Fire Brigade whose mobile classroom – although successful - had high running costs and was unable to reach all schools. This site was developed as a secure database-driven website providing interactive, fun and structured fire safety education (mainly using multiple choice questions). The site is database-driven, to facilitate the monitoring of results, trends and success of the fire safety education both by teachers and ‘mentor’ fire brigades. Sections of the site incorporate ‘clickable’ photographs and interactive graphics (developed using Macromedia Flash) with all the pages of information and tests being illustrated with bright and lively images.

Please see www.shand-online-solutions.co.uk for examples of other websites I have designed and developed.