Database Tools: SQL Server (7, 2000, 2005), SQL Server Integration Services, mySQL (on personal projects)

Programming Languages: Visual Basic (3, 5, 6), C#, VBA, C, PHP (on personal projects)

Internet: ASP, ASP.NET, PHP (on personal projects), XHTML, XML, Javascript, CSS

Other skills: Business analysis, Database design, Solution design, automated unit testing (COMUnit, TSQLUnit), line management

 

 

Madgex, Brighton

May 2007 – date

Technologies: SQL Server 2005, ASP.NET, C#

 

Senior developer working on implementations of the Madgex job boards.

 

Developed and supervised the deployment of a suite of Haymarket job boards, including Brand Republic, PR Week, Horticulture Week, Childrens Jobs and others.

 

Developed a series of 9 sites presented in the Dutch language for RB.NL.

 

 

 

Glass’s Information Services, Crowborough

August 2003 – May 2007

Technologies: SQL Server 2000, SSIS, Windows.NET, ASP.NET, C#, VB 6, Access 2000, VBA

 

Lead developer for a team of developers working across 3 product areas, on client/server using SQL Server 2000, VB COM, .NET and C#, and web based solutions using ASP.NET with C#. Responsible for both developing and reviewing code, design, XML and DB schemas and technical architectures, leading design workshops and performing line management tasks to ensure timely, quality deliverables to the business by a motivated and supported development team. Attended a series of 6 internal one-day management training courses covering topics such as recruitment, selection, development, motivation, employment law and leadership.

 

Led the design and development of an eBay data export process using SQL Server Integration Services to export xml data with images in Zip files via HTTP POST.

 

Worked on the BodyMaster for Windows product to stabilise and enhance an acquired solution and make it a saleable Bodyshop Management System. Stability projects have involved upsizing the database to SQL Server 2000 from Access 2000 and introducing the concept of locking to prevent multiple users editing the same data. Enhancements have involved producing a consistent set of standard documents in a C# windows form based application launching crystal reports, producing a suite of management reports designed to answer typical bodyshop questions using crystal reports and VB COM and implementing a calculation engine written in VB COM, TSQL and DTS to calculate times for vehicle panel repairs using the Thatcham Times System. 

 

Introduced the concept of automated unit testing for both TSQL and COM Components to the BodyMaster project, and the IT department in general to ensure better quality code. 

 

 

Northern Atlas, Brighton

January 2002 – July 2003

Technologies: SQL Server 7/2000, VB COM, ASP, VBScript, JavaScript, IIS

 

Worked as an Implementation Project Manager for a client based part time on their site. This project involved liasing with key business areas, as well as managing an outsourced development team based in Pune, India to successfully move the project from a long development cycle through user testing and into the business.

 

Worked as technical architect and lead developer on a web deployed product focused on the retail industry to reduce the overheads of producing retail Point of Sale promotional material. This was written using VB Components, interfacing with SQL Server stored procedures, and utilising ASP, HTML and JavaScript.

 

Acted as technical authority, overseeing design decisions on other projects within the Northern Atlas portfolio.

 

 

Aspect Internet, Clerkenwell, London 

October 1999 – November 2001

Technologies: SQL Server 7/2000, VB COM, XML, XSLT, ASP, VBScript, JavaScript, IIS

 

Worked in a development team of senior developers to produce a new content management system to be used as the basis for the next generation of Aspect websites. This comprises of a framework and a set of expandable modules. This has been written using VB components outputting XML. XSLT is then applied to produce the presentation layer. I was responsible for the design, development and delivery of 3 of the more-involved modules.

 

Was one of a team of 4 Technical Consultants for a period of 6 months. My responsibilities were internal and I spent time mentoring less-experienced developers, reviewing code of developers across Aspect, helping lead developers to make more informed decisions and also doing Post Implementation Reviews on 2 projects to try and identify common downfalls.

 

Worked as sole developer on the first large-scale B2B Aspect site – www.asite.com. Asite are using the Commerce One suite of products to manage the procurement and supply of building goods to building contractors, engineers and architects. I was responsible for producing a portal linking to both the Commerce One modules and to external collaborative tools whilst maintaining a record of a user's progress.

 

Was team leader and technical lead for the development of www.theRumour.com (a portal for 18-24 year old girls). My involvement included designing the database, reviewing the specifications for practicality, helping a junior member of staff to familiarise himself with the pre-built modules within the Aspect toolkit, leading the development team and delivering the site and content management system in a timely manner. Similar responsibilities were performed for the development of www.decanter.com leading the same team of developers.

 

 

GlaxoWellcome, Greenford, Middlesex

September 1996 - September 1999

Technologies: Oracle 7, PL/SQL, Oracle Objects for OLE, Visual Basic 5, ASP, VBScript, JavaScript, Business Objects (Reporting tool), SQR Reporting

 

Worked on a system to manage the authorisations for the more than 1000 products GlaxoWellcome produce allowing visibility to over 1000 users in 140 countries. During the initial phase of this project I authored a functional design document and prototyped the data entry (VB5) and browsing (HTML) modules. As the project developed, I designed and implemented the Intranet solution to allow access to the database from any of the GlaxoWellcome Operating Companies. Additionally I implemented the reporting environment using the Business Objects product WebIntelligence.

 

Worked on the implementation of the Maximo asset management project into both the overall maintenance and laboratory equipment maintenance systems. During these projects I migrated the data from an existing system into the Maximo Oracle data structure. I analysed business processes and tailored current processes to work within the boundaries of the chosen product. Additionally I produced a comprehensive suite of reports using SQR

 

 

Speedwing International, Heathrow Airport, London

September 1993 - September 1996

Technologies: Oracle 7, PL/SQL, C, Pro*C, SQL*Forms, MMS, CMS, CA-OpenROAD, VB3, Crystal Reports, Access

 

Worked on site in a development team for Airport Coordination Limited. This entailed working mostly within a support environment using C, Oracle 7, Pro*C, SQL*Forms. My main responsibility was as build manager using MMS and CMS to control releases.

 

Worked on the development team for a Cargo Revenue Accounting System. This project involved maintaining the existing software and also developing the first phase of a replacement using Visual Basic 3, Crystal Reports and Access.

 

Assisted in the functional specification preparation, producing data flow diagrams and capturing data for the initiation phase of a Passenger Revenue Accounting system.

 

 

 

University of Newcastle Upon Tyne (1990 - 1993), Newcastle Upon Tyne
BSc Computer Science (2.1 Honours)

 

Wyke Sixth Form College (1988 - 1990), Hull, East Yorkshire
A Levels: Computer Science (A), Pure and Applied Mathematics with Statistics (D), French Language and Literature (E), General Studies (B)