|
|
| |
About Shand Online Solutions
|
|
| |
Lorna
Wheelhouse
|
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. |
|
|
| |
|
|
|