▪ Design and development of applications covering a range of the bank’s activities (mainly Middle-Back Office e.g. HR, Accounting, Audit). C#, VB.Net, ASP.Net, Web Services, Winforms onto SQL Server (mainly 2005, some 2000), Sybase.
▪ Some conversion/enhancement of legacy VB6 apps.
▪ Enhancements and bugfixing on a range of existing applications.

▪ Design and development of the DTCC Trade Warehouse Reconciliation application. This enables daily comparison of trades held on BOAs reporting systems with that held in the centralised database at DTCC (used by 17 investment banks) via a daily file load. (SQL Server, Excel, Winforms, C#)
▪ Upgrade of existing reports management website (ASP.NET, C#, Excel, Microsoft Enterprise Library [Application Blocks]) to .NET 2.0.
▪ Extension and redesign of the current bulk upload process to the main reporting database (SQL Server, Excel, ASP.Net, C#, Microsoft Enterprise Library [Application Blocks])
▪ Redesign and development of the trade upload/backload to DTCC from BOAs databases (DTS, Sybase, Access, SQL Server).

▪ Design and development for the Gen2 Kiosk Project. . The Gen2 Kiosk runs in .NET 2.0, C#, SQL Server 2005. I was heavily involved with the middle layer and supporting frameworks linking the front and back end components, designing and writing the majority of the code. I wrote the (quite complex) pricing engine and associated pricing editor, the image handling and editing framework, the order export from the database to XML, device detection as well as various data conversion/import utilities. I also created web services for remote data access and upgraded the data access layer generation application and its associated XSLT templates. The Gen2 Kiosk software runs on the photo printing kiosks found in Tescos, Asda, Jessops, Costco (and many others). This is a high performance, multithreaded, intricately complex and highly flexible Winforms application (making extensive use of generics), and allowing the clients the ability to specify and alter their workflows and screen layouts. Much of the front end is highly custom, using controls created in-house to provide functionality not available with standard Windows controls - allowing clients the ability to easily brand their kiosk with their own styles, wording and to easily change languages. The code libraries are also being used as a basis for the above companies’ photo and photo gift printing websites. Development is run to tight deadlines using an Agile/XP type methodology.
▪ Design and development of SQL Stored procedures, views, tables, queries etc.
▪ C# Winforms development under .Net 2.0.
▪ Design and development of simple SSIS packages.
▪ Use of NUnit for unit testing.
▪ Writing data conversion utilities work to port data from the existing systems into the new kiosk data structure.

▪ Design and development for the strategic reporting application. In C#, .Net 1.1, ASP.Net, XML, VBA, ASP with database back ends in SQL Server 2000/Oracle.
▪ Ad hoc data conversion work to load data from various sources in varying formats (XML, Excel, CSV etc.) into the systems.
▪ Design and development of DTS packages.
▪ Writing SQL Stored procedures, views, queries etc.
▪ Use of Rational Clearcase for source control.

▪ Design and development of Winforms and web applications to report upon, extend, compliment and facilitate communications between the existing off the shelf CRM (Ascent), Accounting (Sage), stock control, call handling and field unit automatic reporting systems.
▪ Development is in C#, Winforms, ASP.Net, VBA (Word, Excel, third party VBA compliant applications), ASP with database back ends in SQL Server 2000.
▪ Ad hoc data conversion work to load data from various sources in varying formats (XML, Excel, CSV etc.) into the CRM and other systems.
▪ Development of middleware systems that link the CRM, Sage and call handling system. E.g. so that completion of an order on Sage leads to a call being raised for the engineer to install the system and the relevant emails sent out. This work is mainly in SQL, utilising replication, stored procedures and triggers.
▪ Design of Management Information reports and their underlying queries across the varying systems. The reports are produced in Crystal reports (10).
▪ Design and development of end user tools (web pages) to enable users to load data ad hoc onto the underlying databases of the CRM, call handling and Sage systems, to load regular updates (e.g price book), and to report upon it from those databases.
▪ Production of data to support marketing campaigns.
▪ Database design and advice (SQL server 2000).
▪ Ongoing production and revision of development standards.
▪ Database administration – setting up users, roles, new databases, replication, DTS packages etc.

Professional Crew and Skipper training course at the United Kingdom Sailing Academy

▪ Design and development of new functionality for the VB6/SQL Server application.
▪ Data conversion work from existing payroll systems to new system.
▪ Design of Crystal reports.
▪ Database design and advice (SQL server 2000).
▪ Design and maintenance on ASP/XML/XSLT on company intranet site mainly for the application’s central error logging facility.
▪ .NET conversion work.

▪ Design and development of VB6 applications, including tools to create Windows installer packages via Install Shield Developer (7) automation.
▪ Database design and advice (SQL server 2000/Access).
▪ Writing of software development manuals, detailing strict coding and specification standards aimed at gaining ISO certification.
▪ Interviewing and assessment of development staff.
▪ Research into .NET.

▪ Design and creation of SQL Server 2000 database for the Futures reconciliation application.
▪ Design and creation of the Daily Futures Reconciliation application. This application produces various reports enabling the back office to do P&L justification between a front office system and a back office system. The data for this application was obtained from Sybase and Oracle databases into the application’s SQL Server 2000 database via a scheduled DTS package. Crystal Reports 8 was used, via automation from VB, to produce the reports in both HTML and Excel formats. The front end, which enables inspection, manual matching and maintenance, was written in VB 6.
▪ Support of the tactical groups existing apps (mainly Access).
▪ SQL/Access advice to users and other developers.

▪ Specification and development of new, and maintenance and expansion of existing, back and front office trading support applications. Development tools include Visual Basic (6), Access, communicating with SQL Server 6.5/7 database back end. The applications run on PCs under Windows NT Workstation 4, connected to servers running NT 4.
▪ Design, creation and maintenance of Microsoft SQL Server tables, triggers and stored procedures to support the applications.
▪ Research into all aspects of design and development methodologies and tools used in of these kinds of systems.
▪ Development of application development and documentation framework and standards.
▪ Large scale application architecture design for the complete overhaul and re-design/re-write of all the trading systems, including the move to ADO and SQL Server 7.
▪ Redesign and conversion of back office systems from Access to SQL Server 7, including co-ordinating such changes with the rest of the back office programming team and the New Jersey office.
▪ Mentoring junior development staff and general advice on analysis and development methods and practices to them and to the back office development team.