Sandy Macpherson Email & Phone Number

Edinburgh, Scotland, United Kingdom

Brasília Area, Brazil

Edinburgh, Scotland, United Kingdom

Edinburgh, Scotland, United Kingdom

Edinburgh, United Kingdom

Brasília Area, Brazil

I began at Monumental in early 2008 as a programmer on the Football Superstars (MMO football game) team and was soon promoted to the position of lead on the same team. During my time on the project we saw it launched and maintained, as well as developing a constant stream of patches and improvements to the game. We also managed to get an established player base which will hopefully be the groundwork for future success.

Designed and developed the Firebird databaseTranslated the software design documents into object models and database structureDeveloped the multi-tier core application in Delphi 2005 and 2006Wrote the business rules tier as a COM objectWrote several tools to facilitate the communication between the tiersResponsible for dividing up the work and delegating to other programmersDivided the core application into various modules that could be used, installed, uninstalled and updated independently providing easier maintenance and a more secure systemImplemented a role- and task-based user rights management system to provide fine control over access and modifications to dataUsed the DeveloperExpress suite of grid controls to provide highly-customisable sorting, filtering, grouping and searchingDeveloped a custom reporting system to convert application grid data or a datastream from the server into a fully customised Microsoft Excel reportDeveloped a range of unique custom controls for use in the application, in particular a control that displays and controls employee scheduling on tasks

Designed and wrote a full 3D PC game from scratch with a friendUtilised OpenGL for graphics and DirectX for networking, input devices and soundDeveloped in Microsoft Visual Studio with C++ making heavy use of the STLDeveloped our own algorithms for artificial intelligence and graphical optimisationUsed a variety of classic gaming algorithms for pathfinding, model interpretation and animationUsed Delphi and C++ to develop a range of tools used for designing in-game objectsDeveloped an OpenGL user interfaceDeveloped a fully-compiled particle engine

Taught a first-year level programming course in Delphi 7 and 2005Covered programming fundamentals of syntax, algorithms, design and testing

Redesign and further development of the existing Firebird databaseManagement of the Firebird database hosted on both Windows and Linux serversReplaced large quantities of redundant code with triggers and stored proceduresMaintained and developed the core application in Delphi for managing courier companiesDeveloped a system for SMS text messages between the software and couriersDealt directly with the clients to monitor recent changes and deal with bugs and feature requestsVisited client sites to see the software in action and talk to employees about their experiences with various aspects of the software

Designed and developed a variety of music tuition toolsCreated an internal webserver to provide HTML data to the packagesWrote a C++ tool to generate all scales in all keys as MIDI filesWrote a suite of visual components using custom interfaces