Overview of projects:+ Design & develop 2 layer WCF Web Services in C# - External facing web service to receive XML orders from web site host, pre-process and pass to SOP web service - Internal SOP web service to submit orders to legacy SOP system - Develop suite of unit tests & black box test for use with MS Test+ Jointly design & develop a reporting database and data warehouse - relational database holding cleansed data from legacy SOP DataFlex db - data warehouse (Kimball method) and ETL - team of two developers using Visual Studio 2012 with SSDT - suite of SSIS packages & SSRS reports delivered+ Design & develop a product scanning application - capture book front covers to use on the company web site - VB6 application using Windows Image Acquisition v2+ Pilot an ASP.Net MVC based intranet - Order tracking & lookup site for Customer Services+ Enhance & support a number of in-house legacy VB6 applications & classic ASP web siteTechnical Summary:C#, WCF Web Services (SOAP), .Net 4.0, ADO.Net, ASP.Net MVC, TFS 2013, SQL Server 2012, T-SQL, SSIS, SSRS, SSDT, XML, regular expressions, layered architecture, Windows Image Acquisition v2, VB6, VBA, classic ASP, classic ADO, Access, Excel, Outlook, Project, Visio

Provide data analysis and development service to the Accessories department creating and supporting a suite of applications, databases and data warehouses.Overview of projects:- Accessory product tracking and approval application- Product Sales Data Warehouse and application- Predicted Product Sales data capture Excel application & data warehouse- Future workload planning application- Departmental Product part numbering application- Warranty Analysis Data Warehouse and application- Future Product quality assurance application- Migration of all applications from Office 2003 to Office 2010, and databases to SQL 2008R2Responsibilities:- Gather requirements and document business processes & workflows- Data analysis, database design, data warehouse design (Kimball), security & DBA functions- Screen & report design, object oriented code design & programming- Plan, code and test data conversion process- Plan user testing, write test scripts, oversee user testing- Create help files and perform user training- Remotely provide day to day support of all applications, while working from homeTechnical Summary:SQL Server (2000, 2008R2), T-SQL, Access, Excel, Excel User Forms, VBA, VB6, interface classes, OO Design, layered architecture, ADO (classic), DAO, XML Dom, CodeSmith Generator, Outlook, Project, Powerpoint, Visio, MS Graph, Office automation, regular expressions, MSFlexgrid control, Google Mail, HTML Help

Lead a team of 3 developers providing data analysis and development skills to create an intranet applicationResponsibilities:- Gather requirements and document business processes, gaining approval from all parties- Liaise with project manager and plan development activity- Page design, object oriented code design & programming- Plan and design XML data export to SAP- Plan migration and user trainingTechnical Summary:SQL Server 7, T-SQL, Classis ASP, VB Script, Javascript, VB6, ADO (classic), XML

Create a Product tracking and approval applicationSummary of project:- Replace 3 excel spread sheets with a single application- Provide data validation of user input- Restrict access to areas of the application, depending on user type- Automatically generate output documentation and attach to an email- Provide automated data feeds to other departments- Provide searching capabilities of existing product informationResponsibilities:- Gather requirements and document business processes & workflows- Data analysis and database design- Screen & report design, object oriented code design & programming- Plan, code and test data conversion process- Plan user testing, write test scripts, oversee user testing- Create help file, perform user training and provide day to day supportTechnical Summary:Access, Excel, Outlook, VBA, ADO (classic), XML Dom, HTML Help

Provide data analysis and development skills to the Small Business/Business Direct unitSummary of projects:- Create a Sales & Prospect tracking application- Create a data capture Excel application and summary databaseResponsibilities:- Gather requirements and document business processes & workflows- Data analysis and database design- Screen & report design, object oriented code design & programming- Plan, code and test data conversion process- Plan user testing, write test scripts, oversee user testingTechnical Summary:Access, Excel, Excel User Forms, VBA, VB6, ADO (classic), HTML Help

Provide data analysis and development skills to the Information Services Dept.Summary of projects:- Create a Local News Archiving intranet application- Create a Trading Standards application- Support and enhance an existing suite of database applications across the whole councilResponsibilities:- Gather requirements, data analysis and database design- Page, screen & report design, object oriented code design & programming- Handle complete data conversion process, testing and user trainingTechnical Summary:SQL Server 7, T-SQL, Classis ASP, VB Script, Javascript, Access, Excel, VBA, VB6, ADO (classic), ODBC

Join a small team providing data analysis and application skills to the unitSummary of projects:- Create an interim ‘Sales Force’ application for a data cleansing & validation exercise- Assist with the testing of the main ‘Sales Force’ application- Plan the testing of the ‘Sales Force Performance’ applicationResponsibilities:- Provide support for managers and agency data entry staff- Liaise with in-house development team during development and testing- Oversee test script writing by bank staff- Write test scripts and prepare indicative data for use during testingTechnical Summary:Access, Excel, VBA, VB6, ADO (classic), HTML Help

Responsibilities:- Maintain and develop customer's bespoke information system- Write specifications for new functionality or modifications- Develop, test and install modifications to customer’s sitesTechnical Summary:UniData, DataBasic, Access, Excel

On completion of a technician apprenticeship, employment commenced as a Product Design Engineer. The role expanded into writing Pick database systems for the Engineering department, which grew further into information systems at a divisional level