Hi, I am

Bill Strachan

Contact me

About Me

hero

Let Me Introduce Myself

I am Bill Strachan. I'm a Full Stack Developer specialising in MS SQL Server and ASP.Net & VB.Net development with over 20 years experience working with MS SQL Server.

Recent commercial projects have predominately been large scale data migrations in the financial sector using Microsoft stack but I've also been involved with integration projects and general SQL Server development and administration in telecoms, legal and digital marketing sectors.

My current personal projects include the development of a SQL Server Data Visualisation & Column Level Lineage tool.

Skills

Database Skills

Data Migration

Design & Development

SSIS & SSRS

Coding Skills

VB.net

ASP.net

HTML/JavaScript

Services

Data Migration

Full end-to-end data migration design, plan & execute.

Database Design & Development

Creation of databases and required objects.

Data Analysis

Analysis and profiling of existing data to provide insights to support business decisions.

Windows Application Development

WinForms, WebForms, custom user controls & console applications.

Web Development

Web applications for data operations, dashboards, reporting, etc.

Technical Documentation

Analysis, reverse engineering and documenting of existing systems.

CV

Work History

June 2021 - Present
Full Stack Developer (VP)

Barclays

November 2020 - June 2021
Migration Analyst (contract)

Barclays

January 2020 - November 2020
Neo4J Analyst (contract)

Inawisdom

  • Migration of large database to Neo4J including translation to Cypher queries.
April 2019 - January 2020
Data Analyst (contract)

RBS

  • Big data migration from on-premise to AWS data lake.
  • Data analysis and profiling of Teradata, SQL Server, Hadoop, Oracle & Mainframe systems.
January 2019 - March 2019
SQL Developer (contract)

Inisoft Limited

  • Creation of stored procedures to support call centre dashboard reports.
  • Performance optimisation of existing stored procedures.
  • Creation of database maintenance scripts.
July 2015 - November 2018
Data Migration Analyst (contract)

Barclays Wealth Management

  • Part of a small ETL data migration team responsible for the transfer of approximately 300,000 customers from Bank of New York and Stockbrokers legacy platforms to a new target platform with approximately £1.2bn & £14bn of assets under management.
  • Created a bespoke, web-based dashboard for migration orchestration providing full control over the launching of each ETL step with real-time feedback, auditing, logging & exception reporting.
  • Managed the codebase deployment and synchronisation of the SQL databases and ancilliary components through development, testing and production environments.
August 2014 - June 2015
SQL Developer - Associate

JP Morgan

  • This section is intentionally vague to comply with JP Morgan non-disclosure requirements.
  • Legacy system migration projects.
  • Stored procedure performance optimisation.
  • Creation of bespoke system performance analysis tools and reports.
September 2010 - August 2014
SQL DBA/Developer

Endat Standard Indexes

  • Design & development of online content management system databases.
  • CLR integration for remote XML web service consumption.
  • Bespoke, disconnected synchronisation framework for replication between MS SQL and 4D databases.
  • Creation of centralised, internal administration & reporting web application.
  • Performance tuning of SQL stored procedures.
  • Design & implementation of Endec Enterprise Search pipelines to facilitate advanced online search capabilities.
October 2007 - September 2010
Senior Developer

Antony Hodari & Co. Solicitors

  • Led the project for integrating CRIF/IDSL Low Value RTA PI A2A portal into LawSoft CMS as part of the MoJ reforms implementation.
  • Development of SQL databases including stored procedures, user-defined functions, triggers & views..
  • Report creation using SSRS including SharePoint integration.

Education History

2020
Neo4j GraphAcademy (Online)

Neo4j Certfied Professional

2015
Sybase ASE - Performance Tuning & Optimisation

QA IT Training - Glasgow

2006
Microsoft Technical Training

Remarc Technologies - Manchester

  • Developing & Implementing Windows Applications with VB.net and VS.net
  • Microsoft SQL Server 2000 System Administration
  • Implementing & Administering a Windows 2000 Directory Services Infrastructure
March 2000 - March 2002
Microsoft Office and VB6 Programming

National IT Learning Centre

Home study course

1985 - 1986
City & Guilds 726-100 in Information Technology

Dundee & Tayside iTec

1981 - 1985
'O' Grade passes in English, Maths, Arithmetic, Chemistry & Art

Kirkton High School, Dundee


Personal Projects

SQL Server - Lineage & Visualisation

Graphical tool to visualise SQL Server object dependencies and produce attribute level lineage.

Bulk Data Transfer

Fully configurable application for transferring large amounts of data between MS SQL databases without using SSIS. WinForm application but can also be launched from batch file passing in command-line parameters for source & target selection.

Stored Procedure Exporter

Command line tool for extracting result sets from stored procedures into separated value files. Useful for building extracts and reports. Fully configurable using command-line parameters. Operations can be called from a batch file.


 

Contact Me