* Database developer and BI developer for one of the UK's largest newspaper publishers.
* Worked on all phases of a large print management project.
* Responsible for the design, build and programming of the OLTP database.
* Data Architect for the accompanying Data Warehouse and Business Intelligence elements.
* Created an ETL solution using SQL Server Integration Services (SSIS).
* Built a series of production reports and summary reports using SQL Server Reporting Services (SSRS).
* Involved in coding parts of the application middle tier and web front end using C# 2.0 and AJAX.
* Provided database support such as maintenance, monitoring and performance tuning.
* Provided SQL Server consultancy services for a number of other clients.

* Lead SQL Server 2005 and C# 2.0 development position within the Europe and North America (ENA) IT Development team.
* Responsible for delivering high-profile applications for the ENA Finance Team.
* Designed and delivered a reconciliation and reporting tool to aid Finance with their Regulatory Reporting requirements.
* Implemented a SQL Server 2005 Reporting Services suite that gave Finance on-demand visibility of all pertinent data.
* Worked alongside users and business analysts to ensure business requirements were met.
* Improved the performance and stability of an existing ASP.NET application by re-writing the middle-tier using C# 2.0.
* Installed and used TSQLUnit to unit test stored procedures.
* Developed a custom report generator using C# 2.0, which created entire suites of reports in seconds.
* Delivered all projects on time despite extremely tight deadlines being in place.

* Lead database and ASP.NET development position within the Corporate IT Application Development team.
* Involved mainly in the development of two high profile BASLE II related projects.
* Designed and built the SQL Server 2000 database for an ASP.NET-based Financial Risk Reconciliation system, which was used by the Finance and Planning team to reconcile billions of pounds worth of data, from numerous heterogenous streams and sources.
* Worked on the first two phases of a major Anti-Money Laundering application, which integrated with other in-house systems. Responsible for much of the core business logic and database code.
* Worked closely with accountants on a day-to-day basis on the Financial Risk Reconciliation project, to ensure user needs were being met.
* Heavily involved in the optimisation and refactoring of databases and applications, using tools such as SQL Profiler, FxCop, nprof and Application Center Test.
* Performed DBA tasks such as database backups/restores, creation of maintenance plans and deployments.
* Used a variety of tools during development including SQL Server Management Studio and Visual Studio.NET 2003/2005.

* Lead development role within the Business Intelligence Systems (BIS) team.
* Solely responsible for the analysis, design and development of an operational data store, forming one work stream of a major data migration from Cardpac to the TSYS card transaction processing system.
* Designed and built a SQL Server 2000 data mart from the 7 terabyte BIS data warehouse.
* Produced an intuitive user interface using ASP.NET, C# and VB.NET and using 3-tier architecture.
* Developed scheduled DTS packages to refresh data on a daily and monthly basis.
* Used a RAD approach and had regular meetings with the end user team to demonstrate the latest version of the application.
* Client-facing role, worked in conjunction with four teams during all phases of the development.
* Provided full documentation of the product to ensure a smooth hand-over to the permanent BIS team.

* Contract for a large financial organisation, my primary role was the design and development of the new company-wide intranet.
* Involved in building the intranet using ASP.NET and SQL Server 2000.
* Developed custom components using both VB.NET and C#, to provide the core functionality, such as security, data access and site administration
* Developed a document management system in C# and SQL Server 2000. Features included versioning and archiving. Replaced the outgoing Novell system.
* Planned the second phase of the intranet project, focusing on site content management.
* Built the CMS application, which integrated with a third party XHTML editor and SOAP web services.
* Involved in writing SQL Server DTS packages to transform and transfer financial data between organisations.

* Lead development position within a web/software solutions company.
* Responsible for producing web and database applications for various businesses.
* Senior client-facing role, involved in all phases of the development process.
* Met with clients to establish the requirements and problems
* Wrote response to tender documents, audit reports, requirements and functional specifications
* Determined the technologies to be employed and wrote the physical design specifications
* Designed and developed the applications. The main technologies used were .NET, SQL Server 2000 and ASP.
* Application deployment, testing and validation
* Liaised with clients to give project updates

* Lead development position which involved building database applications for the NHS Trust.
* Responsible for the implementation of the first solution to use the .NET Framework.
* Used SQL Server 2000, ASP.NET and XML Web Services to develop the main system.
* Upgraded MS Access databases to SQL Server 2000 and .NET.
* Worked with clients to establish requirements.
* Helped train the existing development team in SQL Server and web technologies.

* Lead development position within a clinical call centre.
* Involved in developing applications such as script-based patient recruitment services, patient/investigator questionnaires, drug distribution systems, patient randomisation systems and medical device knowledge-based applications.
* Produced functional and physical design specifications and software validation/verification test plans.
* Determined the technology and architecture to implemented (Client/server, 3-tier, multi-tier).
* Designed and developed front-end GUI's using ASP, VB6, DHTML and Visual Interdev 6.
* Database design and development.
* Created custom scheduled reports using VB6 or VBA, linked to MS Office applications.
* Provided technical and programming support and guidance to other members of the programming team
* Liaised with the project manager/client, and performed project management tasks

* Web and database development position that involved writing a new crime and incident reporting system for the local police force.
* Responsible for producing various components for the system, within tight deadlines.
* Used ASP, SQL Server 7, ADO and Dynamic HTML to build the application.
* Employed efficient programming techniques as the application was distributed to hundreds of users throughout the Dumfries and Galloway region and performance was a major concern.
* Produced documentation on an on-going basis using Visio.
* Provided programming support to other members of the development team.

* Lead position that involved the development and maintenance of applications and databases for a clinical call centre.
* Developed clinical support software using ASP, ADO, VBScript, JavaScript, DHTML, Oracle, MS Access, VBA and IIS.
* Applications included patient recruitment systems and drug resupply and distribution systems.
* Reduced processing time of manual transactions from minutes to seconds.
* Automated daily statistical reports.
* Employed full project life cycle methodologies.
* Produced software requirements specifications, functional and physical design specifications and test plans.