Simple is best alex mackey

Current

Eye Hospital (Dubai, UAE)

Lead developer designing and developing a system for a new hospital in Dubai. We were chosen to provide the infrastructure and develop a system to manage all aspects of patient care from patient registration & reporting to clinical management and interfacing with state of the art ophthalmic devices. I spent much time in Dubai with the client analysing their requirements and designing the application. We selected an ASP.net/SQL server with Microsoft Great Plains to cater for the financial requirements. Due to the sensitive nature of the data smart cards are used to provide authentication and authorization. Smart cards are read direct from the browser using an embedded Windows forms control and Javascript. The smart cards are used to turn on and off lights above patient examination rooms and also provide a graphical representation on a map of the location of patients and clinical staff. Heavy use was made throughout the application of AJAX to update the user in real time of various alerts & system messages and also to provide an easy to use and intuitive experience for the user.

Eye hospital

Paediatric hospital (Dublin, South Ireland)

Project to provide a diabetes information system. The system is written using ASP.net and SQL server. The system is integrated with the hospitals PAS (Patient information system) and Pathology (lab test) system via a number of listening services. The services listen on a port for HL7 (a common healthcare hospital & patient information protocol) messages. The system provides an easy to use interface allowing the user to create their own letters online, pull up various reports such as patient growth charts and various blood measurements.

Paediatric hospital

Diabetes hospital Abu Dhabi

New diabetes centre setup in Abu Dhabi. I was involved with developing a number of .net services integrating medical devices into the SQL server application. Interfaces were developed for a number of devices such as collecting information simultaneously from over 30 blood pressure devices, and various other devices such as retinal cameras, pathology machines and urine sample devices. In order to ensure the reliability and availability of services each individual service provides a heart beat pulse to a central monitoring application that upon failure sends warning Email and SMS.

Internal security libraries

I have always been interested in security and before my present position had some experience of working with OWASP (Open Web Application Security Project) where I developed an asp.net vulnerability scanner which would check for common issues such as XSS and SQL injection. Given my experience and interest in security I was chosen to develop security libraries for our applications. Our security libraries are used in all our .net clinical systems and also a number of high security applications in our sister company that provide information to the police & local authorities.

Internal Libraries

Silverbear

Campaign Manager

Campaign manager is an electronic survey and marketing tool. Written in ASP.net with a SQL server backend campaign manager distributes and processes hundreds of thousands of messages and surveys from permission based marketing to internal health and safety systems. I was primarily involved with making the application more user friendly by utilizing AJAX techniques and developing a report and query interface.

Campaign Manager

Event Manager

Event manager is an ASP.net/SQL server application which manages all aspects of events management from advertising and booking to delegate lists and online payments.

Event Manager

Portal implementations

Design and development of a number of website portals and applications based on the Microsoft Ibuyspy portal framework. Silverbear further developed the sample code and developed a number of customizatations such as the ability to categorize content.

Abu Dhabi

Windows network setup

Due to staff shortage I designed and setup the companies 20 windows client XP/2003 server network with Exchange when Silverbear relocated offices.

Windows Network

Silverbear Common Libraries

Libraries for data access, security, serialization and javascript.

Common Libraries

Freelance

ElearningAge CMS

Website built on top of SiteFinity content management system and maintained by staff.

Bizmedia

Peter Charles Website

Online opportunity management system written in ASP.net and SQL Server. Application to process incoming Outlook mail written using VBScript. Website maintenance (http://www.petercharles.co.uk)

PCL

Deverall Consulting Website

ASP.net sql server application for referencing airside crew CSS for existing website design (http://www.deverallconsulting.co.uk)

Deverall

Vunerability scanner and source control

Open source project for OWASP to develop a web application security scanner and online source control system written using ASP.net, SQL server and XML. Availabile on downloads section.

OWASP

SCCP Website

Maintenance of website for a psycho therapy training busiess. Online course booking and contact form written in ASP.net. Integrated with existing forums application. (http://www.sccphypnosis.co.uk)

SCCP

Hosting Services & VPN Implementation

Currently provide website & email hosting on dedicated server for a number of small companies. Setup of a number of hardware VPN solutions.

Hosting Services

Absolute Computer Solutions

Integration of CRM System with Email Marketing Application

Integration of two existing applications. Data transferred and services initiated between the two systems through SOAP/XML and ASP. Synchronisation service written in Visual Basic and administration screens displayed through COM component.

CRM

Project Management System

A system to manage all aspects of project management from assigning tasks to users, managing expense claims, viewing crystal reports of task progress to exporting project data to MS Project. Written using Crystal Reports, SalesLogix, SQL Server, VBA and Visual Basic.

Project Management System

Resource System (VB, MS Project, SQL Server, Crystal Reports, SalesLogix)

Application to keep track of software and hardware resources. Written in SalesLogix & Visual Basic.

Resource System

Accounting System

An internal system written in Visual Basic and SalesLogix to manage billing of projects. Invoices produced in crystal reports and exported to PDF. Later further developed into Project Management system (see above).

Accounting

Company Website

Maintenance and development of company website. (http://www.absolute-cs.co.uk) Company Website

MP3 Jukebox

Development of Mp3 Juke Box for the office. VB application indexes MP3s and inserts details into SQL Server Database. Mp3s selected through ASP pages and played by VB server application. MP3

Assetdisk

Holiday Back Office System

Application written in ASP and Access to handle the booking, sales and rental of holiday villas and manage prospective sales.

Holiday back office

Crew Clothing (http://www.crewclothing.co.uk)

Shopping cart engine for a clothing firm written in ASP and Visual Basic. A COM component was written in Visual Basic making use of a windows API call to generate a globally unique ID used for the users shopping basket. An administration interface written in ASP to manage products and shopping categories.

Crew Clothing

Online Crystal Reports for Gas and electrical safety company

An online system written in ASP utilizing Crystal Reports SDK to produce and display reports of jobs carried out by safety engineers.

Online report

Franchise Sales System

Application for holiday franchise business. Franchisees entered data into Visual Basic client application that transmitted encrypted XML data as packet over SMTP. Data imported by server application into Access database. Application supported automatic update installing a newer version by FTP when new features added. Re-written in ASP due to a requirements change.

Clearsky Online

Asset Forum

An online discussion forum written in ASP and Access. Allowed complex searching, statistic retrieval of posters and uploading and attachment of files to posts. Moorfields eye hospital

Assetdisk Web Site

Designed and developed Assetdisks own website. Log in interface written in ASP to commonly used documents and applications for Assetdisk support engineers. Assetdisk web site

Various Websites

I designed and maintained a number of small company web sites. Various

Tags