About us   contact us  our clients 

     Shand Online Solutions - Home Page Home
 
 Shand Online Solutions - Why a Website? Why a Website?
 Shand Online Solutions - Database Driven Websites Database Driven
 Shand Online Solutions - E-Commerce E-Commerce
 Shand Online Solutions - What Next? What Next?
 Shand Online Solutions - Support Support
 Shand Online Solutions - FAQs FAQs
 Shand Online Solutions - Training Training
 Shand Online Solutions - Costs Costs
 
  About Shand Online Solutions
 
  Lorna Wheelhouse
Address: Shand Online Solutions Ltd
Dunclutha
High Street
Ayton
Berwickshire
TD
14 5QR
Tel:
Email:

Nationality:

 

(018907) 81970
lorna@shand-online-solutions.co.uk
British

 
CURRENT SKILLS
Skilled in the use of web technologies for the design and development of Intranets, Extranets and public websites.  Main skills lie in the following areas:
ASP.NET (C#)
Active Server Pages
HTML & DHTML
XML
CSS
Javascript
VBScript
SQL Server 2000
T-SQL
Database Design
Visual Studio
MS Front Page
Adobe Photoshop 5.5
Project Management

 
PROJECTS

McLaren Plc
:
Developed a Web interface for an internet solution to allow quick, easy access for client personnel to a wide range of documents including technical documentation such as drawings stored on a document management system (Documentum 4i). This project has allowed me to further enhance my previous JavaScript skills by providing me with the challenge of replicating a current VB application on the web with the remit that it must work on both Internet Explorer and Netscape browsers.

As a consequence of working for McLaren and the variety of previous projects I have worked upon using JavaScript, ASPs and other web development tools, I have developed a good understanding of both the current limitations and potential of those tools and have had the opportunity to do a significant amount of problem solving and project management. Consequently, I am able to use this experience to help manage client expectations of what might be achievable on the Web.

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.

Sericol Incorporated (Extranet):
Developed and project managed a secure database-driven website for Sericol Inc (US) to enable Sericol to update their customers on new products and developments and at the same time enabling their customers to place orders online for screen-printing inks and technologies.  The site was developed using mainly asps and SQL server database and included a secure maintenance section to allow Sericol to maintain certain sections on a regular basis.

Public Websites:

Memory Corporation
Developed and project managed a public website for the Memory Corporation Group giving relevant and complete information about the Memory Group. The site was targeted at different types of customer, investors, press and other companies within the Memory Group - to act as a cohesive force within the organisation. DHTML was used on all the navigation pages to enhance the look and feel of the site without the need for users to download a plugin. A news, careers and products section were developed using asp pages as these sections are database driven. A secure, database driven maintenance section was also developed to allow Memory Corporation to maintain these sections on a regular basis.

Memory Corporation - MP3-Go
Developed a public website to promote Memory Corporation’s MP3-GO™ portable MusicStore™ concept. DHTML was used on all the navigation pages to enhance the look and feel of the site without the need for users to download a plugin. A news section was developed using asp pages for this database driven section. A secure, database driven maintenance section was also developed to allow Memory Corporation to maintain the News section on a regular basis.

Stortext Ltd
Developed a public website to promote Stortext’s product portfolio. Case studies were used to demonstrate the application of digital document management services (mainly internet-based) in different industry sectors. DHTML was used on the navigation bar to enhance the look and feel of the site without the need for users to download a plugin. A news, careers and products section were developed using asp pages as these sections are database driven. A secure, database driven maintenance section was also developed to allow Stortext to maintain these sections on a regular basis.

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

 
QUALIFICATIONS
1996-97
University of Glasgow
MSc in Information Technology (Software and Systems)
  Modules:
  • Programming & Problem Solving (“Pascal”)
  • Information Management
  • Computing Systems
  • Systems Analysis & Design
  • Numerical Scientific Computation (“C”)
  • Object Oriented Programming (“C++”)
  • Operating Systems
  • Networked Systems & Their Management (“Unix”)
  • Project Management
MSc Project: Designed and developed a small application to enable Geology (or other) personnel to create virtual field trips (to be implemented as a multi-media series of web pages) using Java and the Java Developer’s Kit V.1.1
1984-86
University of Paisley
BA Degree in Business Economics with Manpower Studies
1983-84
Reid Kerr College, Paisley
HNC in Business Studies

 
EMPLOYMENT HISTORY (since graduating with MSc in IT)
April 2001 - present Managing Director (Shand Online Solutions Ltd)
Currently design and develop solutions for small to medium sized businesses.  Have developed small sites using Photoshop and MS FrontPage to larger database-driven websites (including 2 e-commerce sites and websites for 2 car dealerships).  Please see the Our Clients section for more information.
March 2003 - April 2005 IEG Officer (part-time)
Responsible for redesigning the Tourism website using ASP and SQL Server 7 to provide a database-driven solution offering the ability to add/amend and delete accommodation details using online forms.  Also, added a search tool for quick accessing of information.  Also, designed and developed a website for the Crime & Disorder Reduction Partnership, Berwick-upon-Tweed using ASP and SQL Server for the News, Events and Forum sections and a Multiple Choice quiz with Q&As that can be modified by online forms.
18 Sept 2000 - April 2001
McLaren Plc
Senior Applications Developer
Responsible for developing web-based content management solutions using HTML, JavaScript and Documentum 4i. Main responsibilities include developing sophisticated search forms using JavaScript for Netscape and IE browsers.

 
Feb 2000 - August 2000
Stortext Ltd
Web Developer/Consultant
Responsible for the design and development of a public corporate website with a database driven Careers, News and Maintenance section. This involved the generation of a significant proportion of the marketing content for the site.

 
Nov 97 - Jan 2000
Company Net Ltd
Web Developer
Responsible for the development and project management of database driven Intranets, Extranets, and public websites as illustrated in the Projects section above.

 
ADDITIONAL INFORMATION
Also have experience of setting up a web server on an NT platform using NT 4.0 and MS IIS 4.0.
I have held a full driving licence (with no endorsements) for twelve years.
I enjoy keeping fit and enjoy weight-training and walking.  Am also interested in soft furnishings and genealogy.

 
REFERENCES available on request.