SQL Database Developer, Data Warehouse Architect, Power BI, Business Intelligence

* Database performance troubleshooting
* Stakeholder management of customer on and off site
* Introducing changes to database performance, monitoring and maintenance

Key achievements
* Troubleshooting and correcting database performance problems at a client site in a reduced
timescale

* Data warehouse development
* Extracting Webtrends analytics through a REST API
* Covering for DBA when absent

Key achievements
* Developing the data warehouse to include sales pipeline data Sep 2016 - Mar 2017

SQL Database Developer (contract)
Lloyds Bank, Halifax



* Converting existing SSIS packages to run in a highly structured job control environment
* Designing report extract routines
* Designing unit test routines

Key achievements
* Migrating large numbers of Fact tables to Dimension tables thus de-duplicating data and saving
space

* Facilitating the migration of employee data from two existing Oracle databases to a new Fusion HR
and payroll system when RBS created a new bank
* Analysing existing systems, mapping data to new SQL 2012 databases and creating data extracts to
import into the new system
* Generating globally unique identifier and lookup tables to support the data import, using
multiple data sources including databases, flat files and spreadsheets
* Leading the reconciliation between systems and between multiple testing and live environments,
and porting historic data
* Generating a mail merge system to enable employees to elect benefits under the new payroll system
and to ensure their existing data was correct
* Using SSIS to manage multiple dependencies in source data and the need for data validation,
transformation, control and error trapping

Key achievements
* Designing a master SSIS package to control around 400 smaller SSIS packages to handle the
extract, transform and load process, which was completed in 20 minutes
* Creating multiple databases and around 300 stored procedures
* Managing all activities to keep the project on track for completion within a strict deadline
imposed by financial regulators

* Maximising the use of SQL 2012 to develop and maintain databases for marketing analysis

Key achievements
* Introducing Agile approaches to project management

* Successfully completing a short-term contract to migrate several databases from SQL 2008 to SQL
2012 using SSIS, functions and stored procedures

* Implementing SQL 2008 for ad hoc object creation, troubleshooting and administration
* Creating and populating a dimensional data warehouse schema using SSIS, OLAP cubes using SSAS and
SQL Server Reporting Services reports using SSRS

Key achievements
* Tackling complaints received from the Financial Conduct Authority regarding the misuse of
customer data by amalgamating marketing data from 10 companies into one database, thereby
enabling calls to be regulated in line with contractual agreements

* Collaborating with a team of .Net Developers to create SQL objects and a database design to
provide data to the front end of a software package
* Developing objects including tables, views, functions and stored procedures to manipulate raw
data and provide forecast values
* Converting spreadsheet analysis into formulae to apply to underlying data and incorporate into
SQL scripts

Key achievements
* Enabling users to forecast future vehicle valuations online and understand the calculations
involved

* Optimising SQL 2008 Business Intelligence during the roll-out of Microsoft Dynamics AX

Key achievements
* Facilitating the production of business intelligence reports by liaising with Business Analysts
and BI teams to create new objects and structures

* Designing a new data warehouse solution for roll-out across 25 companies, to overcome problems
with inaccuracies and inefficiencies in the existing solution and also to enable use of Cognos
for reporting
* Creating a proof of concept using SSIS reusable code and building quality assurance into the
process
* Developing a data model in ER Studio, with 120 scripts to create the new database schema, which
were used as a basis for SSIS packages
* Working effectively and flexibly both from home and from national and international offices

Key achievements
* Creating an end-to-end model of the new business data warehouse

* Configuring two SQL 2005 Servers on site for the Universities Superannuation Scheme,
collaborating with internal and external development teams to support a Microsoft Office
SharePoint installation
* Liaising remotely with the management at Citigroup to analyse the current server farm and
recommend changes to performance, design and security, writing code for monitoring and reporting,
redesigning legacy processes to archive and purge unnecessary data, prepare for an upgrade to SQL
Server 2005 and cover UAT roll-outs

* Developing SQL databases and ad hoc objects to support Developers in a .Net environment, across
multiple projects
* Designing and implementing a job monitoring system working across several servers, with
functionality to raise alerts and send text messages to On Call personnel
* Contributing to performance tuning and archive routines, supporting existing packages and
successfully troubleshooting technical issues

* Playing an integral role in a £30billlion NHS modernisation project as part of a team of 12
Database Administrators overseeing 4,000 SQL servers
* Completing a secondment as an Ab Initio Developer on a Barclays engagement to enable the company
to meet Basel II reporting standards, with responsibility for designing data transforms for the
mainframe systems to new output formats