Application/Web developer (10 yrs) 5 years insurance
6 years banking sector 7 years Asp.Net 1 to 3.5, C#, WCF, VS 2008
Expert SQL Server (7 yrs) Extreme Programming (XP)
Strong software development lifecycle Strong design skills
Programming languages C#, VB.Net, ASP.NET, ADO.NET – 7 years
WPF, Silverlight – 2 Years
Microsoft Visual Basic 4.0, 5.0 & 6.0 (COM, COM+,
ADO 2.1 to 2.7.) - 5 years
Natural – 10 years
DotNetNuke module development – 3 years
Databases MS SQL Server (replication, complex stored procedures,
SQL XML, capacity planning, optimisation, Entity
Relationship Modelling, performance analysis.) - 7 years
ADABAS - 10 years
Testing NUnit, CruiseControl.Net, Mercury Test Director (Bug
and issue tracking tool), Visual Studio 2008 Team
Other Extreme Programming (XP / Agile) , Visual Studio
2008 Team Suite, WCF, SSIS, SSRS, TDD, JSON,
OO techniques, web services, MS Enterprise
Libraries, MS Access & Excel VBA, Ajax, Visual
Source Safe, DotNetNuke (CMS) module
development, Telerik Controls, ADOBE Flash CS3,
SSADM, UML, iTextSharp, ADABAS / Natural, IP
Monitor, JCL, DCL, IBM MVS, IBM DOS/VS, DEC
VMS, Adobe Photoshop, Cluster Administrator, GIT
6 years securities experience Controllers P&L, GL & Regulatory Reporting
Trade Settlement, Stock lending
5 years financial adviser experience CRM
5 years insurance experience Certificate of Insurance qualified
Led a team in the re-architecting and replacement of a monolithic windows app. Introduced PRISM (MS Composite
Application Library), WPF with MVVM, WCF and PLINQO. Introduced custom and off the shelf Codesmith templates,
installed and administered TFS and introduced XP (agile) working practices, including fortnightly release cycles, CI and
an enthusiasm for building great business software.
Designed, developed and delivered a .Net site used by all 26,000 U.K. schools to order key stage test materials using
Agile techniques and automated testing.
Designed built and implemented automated checking of Hansard data feeds from the House of Commons to very tight
Designed, built implemented and managed a scalable n-tier dating site to tight deadlines using latest MS technologies.
Designed, scripted and implemented easy to maintain transactional replication on SQL 2000 servers handling 150gb of
Designed built and implemented roll out of GL reconciliation software to 130 controllers for CSFB New York.
Aug 2009 to Now
Pentagon Freight Services, Aberdeen – Freelance Analyst Programmer / Team Lead
PFS are gas and oil freight forwarders based in Aberdeen
Built and implemented various DotNetNuke 5 modules including :
o DNN compliance module to search on the Office of Foreign Assets Control SDN
list for restricted people, companies and vessels.
o DNN SSRS interface for selecting and viewing reports
o DNN agent vetting module
Architected and led a team in implementing a WPF warehouse management and shipment
Built and implemented an SSIS solution for replicating data between SQL Express
Standardised SSRS development procedures for core reports.
Introduced the use of modular testable software using PRISM and Unity
Introduced, installed and administered Team Foundation Server
Introduced CI and agile working practices
Researched and scoped requirements for mobile device software
Nov 2008 to July 2009
Oakam Ltd, London – Freelance Analyst Programmer
Oakam are a small financial services company based in S.W. London
Extended Oakam’s Loans Servicing System using ASP/VB.Net 2008 & SQL 2005
Upgraded all Oakam’s key.Net software to the latest version of Visual Studio
Reorganised Oakam’s SourceSafe database to reduce risk of change.
Planned & managed the UAT for a large software release.
Supported financial controllers MS Access 2007 and Excel 2007 applications
May 2008 to October 2008
Euromoney PLC, London – Freelance Analyst Programmer
Part of the Daily Mail, EM is an international publishing, events and electronic information
Part of a team of 3 using .Net 3.5 to develop a loosely coupled SOA layer using WCF and
typed datasets, to abstract and standardize DB access for the 241 EM websites around
I set up the CI environment for the team using CruiseControl.Net & XUnit
I built and implemented a scalable management dashboard using ASP.Net, JSON, Telerik
Controls and FusionCharts.
Time & Leisure magazine, London – Freelance Analyst Programmer
http://www.plentyFish.net : Re-factored online dating site for Time and Leisure magazines.
Built using ASP.Net, custom web user controls ADO.Net, SQL Server 2005, AJAX,
DotNetNuke and Nant build tool.
Created a Silverlight page flip module for DotNetNuke.
December 2007 to January 2008
Olay Newspapers, London – Freelance Analyst Programmer
Olay Gazette is a Turkish language newspaper based in North London with a 60,000 per
week print run.
I designed, built and implemented http://www.olayonline.com using bought and custom
built DotNetNuke modules written in .Net and SQL 2005. The custom modules include
straight through classifieds functionality that allows registered users to add their own
adverts which branch off to unique advertisers’ pages and optional voucher pages.
August 2007 to November 2007
March 2006 to July 2007
The Stationary Office, London – Contract C#, SQL Server, Asp.Net Analyst Programmer
TSO is the largest publisher in the UK by volume.
Web service developer for http://www.gazettes-online.co.uk providing a C# bridge between
the company’s legacy document management system and the .Net2 web site. Designed
and built using test driven development with NUnit. Scalability tested using Visual Studio
2005 Team Test Load Agent. VSS used for code control. Heavily involved in RA, logical
and physical design and regular status updates to senior management. Peer reviewed and
provided optimisations for colleagues’ code.
Team, technical lead and lead developer for
http://orderline.qca.org.uk/international/2007/Login.aspx, a C#, ASP.Net, SQL Server 2005
site used by international schools to order educational material from the Qualifications and
Curriculum Authority. Heavily involved in RA and design using UML (use case, class &
activity diagrams) and ERM. Instigated pair programming and stand up meetings to spread
knowledge and maintain code standards. Designed HTML front end using w3c standards
Analyst, team leader and technical lead for the testing materials ordering section of
https://nctest.naa.org.uk/default.aspx, a C#, ASP.Net SQL Server 2005 site used by all
26,000 schools in the U.K. to order testing material for 2006/2007 from the QCA. Liaised
with and integrated solution with feeds from external software house. Peer reviewed
Technical lead and lead developer for http://www.tsoshop.co.uk/vertex/OrderForm.aspx, a
C#, ASP.Net site used by www.vertex.co.uk to order stationery.
Designed and built web services to retrieve product info for the TSO bookstore, designed
and built several WinForms applications using C# including a House of Commons XML
data feed parser and a SQL Server / C# / WinForms Flags application for the Ministry of
Defence. I designed, built and implemented a tool to convert http://www.opsi.gov.uk HTML
to XHTML and developed extensively with XML / XSL-FO to produce Association of Train
Operating Companies (ATOC) PDFs.
Debugged the company CMS (ActiveText) using C++
Plugged ASP.Net authentication into http://www.statutelaw.gov.uk
November 2005 to February 2006
Time & Leisure magazine, London – Freelance Analyst Programmer
http://www.plentyFish.net : n-tier dating site for Time and Leisure magazines. Built using
C#, ASP.Net, custom web user controls ADO.Net, SQL Server 2000 and CSS. All RA,
design, build and implementation done by Andy.
http://www.timeandleisure.co.uk/ : On line presence built using C#, ASP.Net, ADO.Net,
SQL Server 2000 and CSS. Includes a secure system to update a database of contact and
recruitment details over the web. All work done by Andy.
http://www.wimbledon-village.com/ : Business listing for Wimbledon Village Business
Association includes web based members admin functionality built using .Net technology
including custom server controls built in C# and web user controls. All work done by Andy.
November 2004 to October 2005
Millfield Group, Croydon, London - Analyst Programmer
Developed and maintained n-tier financial adviser web based application using C#,
ADO.Net, ASP.Net and SQL Server 2000.
Built FSA compliance functionality using C# for middle tier, SQL Server and ASP.Net
I designed, built and tested the migration for plans, clients,fees, retainers and splits, to
deadline and to a high standard.
I mentored and helped other migration team members with their work, coaching on SQL
design and strategy.
I involved and managed other team members not previously involved in the migration, to
help highlight problems downstream and hit deadlines.
I partitioned migration workload and provided critical path analysis for management.
Sept 2000 – to October 2004
Intelliflo PLC, Wimbledon, London - Senior Analyst Programmer / DBA
My responsibilities at Intelliflo included writing specifications, design, development, delivery and
maintenance of internet based solutions. This involved liaising with clients to ensure business
requirements were met, organising testing and ensuring the smooth delivery of the solution.
The following is a summary of some of the projects that I worked on:
Intelligent Office (IO) is the U.K’s largest Internet based front and back office application. Currently
the application is live to 5000+ active users from 25 IFA firms. My responsibilities in the project
o Porting IO to .NET using C#, ASP.NET, ADO.NET and SQL Server 2000.
o Built dynamic user defined search functionality using C# and ASP.NET
o Lead developer for the stakeholder module of Intelligent-Office. Responsible for
the design, development and delivery, ongoing enhancements and production
CSS. Adopted XP, specifically story boarding, daily stand up meetings and pair
o I designed and implemented the SQL 2000 reports server, using transactional
replication to transfer OLTP data to our OLAP servers using subscriber custom stored
procedures to denormalise data in real time. Architected the OLAP servers
o I monitored and performance tuned our SQL boxes using systems monitor, cluster
administrator, SQL profiler, traces and custom T-SQL scripts.
June 1999 – Feb 2000
Credit Suisse First Boston, City, London – Contract Analyst Programmer
I worked with CSFB financial controllers in New York to design and develop major
enhancements to their general ledger reconciliation application using MS Access 97, VB6
and Sybase 11.
Designed and built a GL warehouse de-normalised in real time for faster and more
I managed the role out of the GL reconciliation software to 130 New York account owners.
Feb 1999 – July 1999
Otis Elevators plc, Clapham, London - Contract Analyst Programmer
Support and enhancement of MS Access service monitoring application using VBA and
BILLING REPORTS: Wrote Unix shell scripts and ADABAS/Natural programs to enable
reporting of branch billing levels.Developed an in house application that recorded time
sheets for employees and produced weekly and monthly reports. Technologies used:
Visual Basic, SQL Server and Seagate Crystal Reports.
Sept 1998 – Jan 1999
Morgan Stanley, Frankfurt, Germany - Contract Analyst Programmer
REGULATORY REPORTING: I had sole responsibility for the requirements’ analysis,
logical and physical designs, build, test and implementation of an Natural ADABAS /
Access ’97 multi-user book-costs system used to produce regulatory reports and track
unrealised profit. Worked closely with Frankfurt controllers and reported directly to
European senior management.
DEPOT RECONCILIATION: Enhanced and maintained the operations’ Access ’97 multi-
user depot reconciliation system. Implemented archiving facilities and optimised Jet 3.5
accesses using VBA, table redesign & SQL. Dramatically reduced data integrity errors and
improved response times by 75%. I worked closely with the head of Frankfurt operations
and others in the operations team.
June 1995 to Aug 1998
Royal Bank of Scotland Trust Bank, City, London - Contract Analyst Programmer
Contract A/P using Visual Basic (V4), MS Access (V2), VBA, SQL, Crystal Reports
(V3), PC Anywhere, Visio (V4), ADABAS 6.2.1, CONSTRUCT 3.3.1, Oracle 7.1.4,
VBA, NATURAL (V2.2.8.), PL/SQL, Windows 3.1, Windows NT4, HP Unix 9000,
IBMOS/390, IBM DOS/LAN.
LATE SETTLEMENTS SYSTEM: Enhanced and Maintained a MS Access (V2)
application producing claims for settlement amounts and interest on failed trades.
Enhanced the professional presentation of letters with signatures & provided an easy
to use monitoring tool for senior management using OLE 2 technology & VB4/Crystal
WORK MANAGEMENT: Developed a MS Office application to aid in the production
and monitoring of tenders for work. Using Visual Basic, OLE 2, MS Project, VBA and
Word Basic I produced an integrated tool for the quick and easy production and
monitoring of project proposals.
CLIENT MIGRATION and COMPANY MERGING: Designed and specified the
processes necessary to enable the merging of data following a company take over.
Led a team of five people in the build & QA phase of the project and produced regular
status reports for senior management. The team created over 80 new Natural modules
& made extensive JCL & schedule changes.
MAINFRAME PERFORMANCE: Designed & delegated mainframe Natural program &
batch schedule optimisation changes resulting in a 15% reduction in computer
resource usage. Built a PC tool to monitor mainframe CPU usage & I/O using Visual
CREST SUPPORT: One of a four person team supporting the software and users
dedicated to the electronic settlement of UK trades. Provided quick solutions to back
office business and technical problems for all U.K. stock market trade types.
BARGAIN PROCESSING SUPPORT: One of a nine person team supporting the back
office bargain processing system; a rapid action team dedicated to maintaining a wide
range of back office functions, from the inputting of deals and instructions to the
printing of contract letters and the transmission of electronic messages using SWIFT
June 1994 to May 1995
SBC Warburg/Mercury Asset Management, City, London - Contract Analyst
BOOKCOSTS SYSTEM: Sole responsibility for analysing, designing, building and
implementing extensive enhancements to the book-cost’s system. Acted as first point
of contact for MAM portfolio services staff with book-costs problems.
VALUATIONS TEAM: Worked in a team of eight people supporting and enhancing the
production of customers’ valuations. This is predominantly a batch system, collating
and downloading holdings and trade information to an electronic publishing package.
July 1990 to May1994
Minet Holdings Limited (Lloyd’s broker), City, London - Contract Analyst Programmer
Analyst Programmer using LBMS’ Systems Engineering, NATURAL V2.2, ADABAS
5.1.8, CONSTRUCT 3.1, IBM 3081, DEC MicroVAX 3100-90, DOS/VS, VAX/VMS, MS
Office, Talking Windows.
NEW BROKING TEAM: Using Learmonth and Burchett’s Systems Engineer Analysis
and Design Methodology, and NATURAL CONSTRUCT, I completed tasks across the
lifecycle of this project from requirements’ analysis through file normalisation, test
scripting, building, implementation, and post implementation reviewing. Using Talking
Windows scripts and Word Basic, helped in the build of PC document production using
June 1988 to June 1990
Cornhill Insurance, Guildford, Surrey. - Contract Analyst Programmer
Programmer using NATURAL V2.1, ADABAS, PREDICT, TSO/ISPF, CONNECT, IBM
MVS, IBM 3090.
ENGINEER SURVEYING TEAM: This system linked up surveyors with Cornhill
branches and head office, enabling on-line entry of surveyor reports via laptop
computers. Liaised with surveyors to establish requirements and built and maintained
parts of the system using ADABAS/NATURAL.
Address 57, Voltaire Road, Clapham, London, SW4
Phone 07932 637 287
Web http://www.aKBox.net [get the latest version of this CV here ]