I am developing and recently finished first prototype for an affordable home ECG monitor.

• Maintained the SQL 2008 solution and performed ETL in SSIS, whilst supporting and delivering changes.• Successfully implemented SQL Service Broker for ETL job orchestration, resulting in other asynchronous benefits for logging and auditing.• Delivered releases through CI / CD DevOps pipelines. • Aligned activities to established business processes, protocols and quality standards.I required more flexibility in remote working which was my reason for leaving this role. I am hoping to have surgery on my knee early in the new year but until shortly after then I am only considering roles with flexibility on remote working.

ACL / Meniscal tear injury

• Collaborate with analyst report writers to understand their reporting requirements and follow these through as change requests as required. The role required basic understanding of the business reporting tools which were SSRTS, Tableu and business objects. Understanding the data model setup for each tool helped in identifying some issues found; when examining QEP for example.• Development of custom .NET components to undertake special activities such as complex data formatting / cleansing that go beyond the best proactive scope of SSIS script tasks. These were registered in the GAC and easily referenced within SSIS scripts tasks.• Troubleshoot performance issues relating to IO, compression was introduced where possible with some tables migrated to column store format where significant performance gain was possible.• Work closely with the business users who had access to the data source via excel and tune the queries as appropriate. This would typically involve typical techniques such as indexing, temp table optimisation and caching (schedule query via agent to run less frequently).• Responsible for the daily checks and highlighting issues for further investigation as necessary. This was refined from a lengthy manual process spanning the various technologies used including MSMQ, to a more data driven automated solution.• Advise and implement changes to database security. For example, setting object permissions against database roles and grouping users within these roles as appropriate. SQL Logins would in future be replaced by AD logins or groups.• Introduce consistent and reliable database version control, through Visual Studio with all data migrations and schema changes stored appropriately as applicable within visual studio and built as part of the solution. SQLCmd variables were used.• Custom scripting to facilitate the build and deployment of both database and SSIS objects and any dependencies, such as jobs and environment variables.

- Implement change requests and enhance performance of SQL Server 2016 data warehouse.- SSIS package development and refactoring, introducing common .NET (C#) assemblies for large previous script components.- Perform troubleshooting including deadlock investigation, index tuning, SSIS package issues advising and implementing changes as necessary such as Colmnstore indexing.- Enable the solution for continuous integration of all database components, including database objects, jobs and SSIS packages including environment variable configuration.- Collaborate with other teams within organization collecting logs and traces as needed to resolve upstream issues relating to infrastructure hosted in Azure.- Provide best practice guidance on database security and permissions. Assisting as necessary to implement active directory-based security for database access over SQL logins.

• Help define and maintain database and code standards and naming conventions for the organisation to ensure consistency in database and code development. • Work with development team to establish structured release via DAC Packs, as well as reliable rollback scripts and how best to source control each component based on best practice.• Developed dynamic HTML emails for ETL processing that were also sent to clients • Introduce Continuous Integration principles. Custom components written to automate SSIS package deployment including associated environment configuration, custom MSBuild task written based on work already present on codeplex.• Implement and guide DBA team on how to effectively use Microsoft’s built in Management Data Warehouse Feature.• Adherence to coding standards and version control in TFS advising on further streamlining processes where necessary.• Implementation of encryption at rest and in transit to meet client requirements. Column level encryption, MSSQL server certificates and PGP used within SSIS tasks. Packaged in one scriptable solution to facilitate simple roll out to further clients as necessary.

• Introduce new SSIS package catalog concepts introduced in SQL Server 2014 with DBA and SQL developers to replace existing methods. For example, SSIS Projects and environment variables were grouped together now simplifying deployment between environments and packages were stored securely.• Assist SQL Developers / DBA with day to day performance tuning activities where needed. Offering advice on understanding the execution plan, to implement effective indexes and where appropriate make use of a particular feature such as CTEs, ColumnStore Indexing and table partitioning.• Advise and help develop a better monitoring solution to help understand server state at a given time using MDW.• Recommended and assisted in refactoring some reports to work instead by staging the data via a scheduled agent job and the report itself queries the cached data.• POC introduction of a star schema style data warehouse to replace analytical querying on operational data that was now many terabytes.• PowerBI was explored and introduced to the business as an alternative to Tableau, with its advantages of being more user friendly (self service enabling).

• Migration of SQL Server estate from versions 2000 – 2008 to 2012.• Identify, document and manage the migration of all SQL Server database dependencies. Including logins, domain names (to be changed), file system paths and encryption keys.• Refactor all legacy DTS and SSIS 2005 / 2008 packages to SSIS 2012 implementing the newer project-based deployment and configuration as appropriate.• Conversion of DTS packages to SSIS using automation tools where possible and careful management of script tasks.• T-SQL tuning Using DMVs, Windows Performance Counters, SQL Server Profiler and Database Engine Tuning Advisor(DTA).

• Working with existing .net 4 code base powering a large billing and collection solution, implementing several design patterns such as Command, Observer, Unit of Work / Repository and ORM via NHiberate.• MVC4 / AngularJS UI• WCF Service Layer• Production support involving performance tuning of SQL Server 2012.• Agile practices followed for new development work.• Mentoring of junior developers in regard to coding best practice both C# and SQL.

• Lead development of enterprise MDM solution built around BlackBerry Enterprise Service and Good for Enterprise. • Design including development of common code library including data access layer based on the generic unit of work and repository pattern.• Development of RESTful web services (WCF) used by web application (MVC4) to perform MDM functions such as Erase through down level SOAP api’s provided by BES and Good.• Development of routing logic to distribute device registrations and management evenly across servers within specified boundaries (Country). • Developed core architecture classes implementing generic unit of work repository pattern with Microsoft Enterprise Library and Entity Framework Code First.• Test Driven Development environment.• Respinsible for Continuous Integration driven by Hudson, MSBuild and Powershellt.

• Ongoing support of internal applications backed with various versions of SQL Server (2000 – 2012).• Development DBA duties for new solutions developed in-house. • Degree of C# coding namely around data access, entity framework 5 adopted.• Development of complex stored procedures where required for consumption by Entity Framework.• Various performance tuning responsibilities for both development and production including Implementation of horizontal partitioning and disk group optimization.• Installation, configuration and management of team using TFS 2012 including CI configuration.

• End to end development of middle office application to reconcile trade data from brokers with the internal accounting database.• Initial POC piece to trial the performance / benefits of Excel PowerPivot vs SSAS.• ETL of source data from flat files using SSIS.• Development of Kimball data warehouse.• Development of SSAS cubes with KPI’s. These were stored using SSAS MOLAP with Proactive Caching set up against the source data warehouse.• Performance tuning exercise including SSIS pipeline tuning.• Development of ASP.NET web application to manage the ETL process (execution scheduling and logging).• SQL Server 2008R2 / Visual Studio 2010 (.NET 4) environment.

• Troubleshooting tasks included resolving deadlocks, index tuning, and refinement of stored procedures.• SQL Server Profiler, PerfMon, DMV’s and Query Execution plans examined for resolution of performance issues.• Rollout of revised disaster recovery solution consisting of log shipping and database mirroring (including Snapshots for reporting).• Ongoing maintenance and creation of new of SQL Server clustered environments.• Migration of data from Oracle to SQL Server 2012 using SSMA.• Development of .NET MVC cross device mobile app.

DBA for a case management system for the Youth Justice Board. Responsibilities included design and development of database schema and database access layer code. Mentoring of developers regarding SQL Server best practices and efficient data access.

Administering and developing for several databases and data warehouses, key skills; SSRS, SSIS and SSAS

Core developer on a project to develop supporting services based on an Exchange based communications platform.

• Development of customer projects using Visual Studio 2005 (ASP.NET / C#).• Undertake various activities throughout the SDLC liaising with the Design and Test teams for example as appropriate.• Mentoring of junior developers and code review.• Development of data access and middle tier components using C#.NET and written using a TDD approach.• Responsible for all client application development, from analysis and design through to development, testing and production. This includes data storage (SQL Server 2005).

• Support and development of an industry leading web based mortgage application system; customers include Bear Stearns and Lloyds.• Many components developed for the application using technologies such as ASP, ASP.NET 2 (C#), VB 6, SQL Server 2000, XML and XSL.• Responsible for resolving all forms of SQL Server issues and provide DBA support both onsite and remotely.• Development of change requests using one of the above programming technologies.• Maintenance of all application code and source control databases (Sourcesafe and Subversion).

• Develop and support the internal business application software, supporting BAU and change requests as required.• Implementation of Citrix technology enabling remote access over low bandwidth connections.• Development of MIS application with Crystal Reports 9 (SDK). Service Orientated Architecture adopted using COM+.• Develop and maintain data warehouse based on Kimball methodology.• BASEL II compliance project; involving development of risk-based credit scoring feature.• IT infrastructure support.