Data Warehouse Architect
StepChange Debt Charity
Keywords
Skills
SQL Database, Database, mainframe, OLTP, databases, SAP, data warehouse, XML source files, PEGA, SSIS, data handling, Teradata, API, database performance, Webtrends, analytics, REST API, SSIS packages, Oracle databases, RBS, SQL 2012 databases, lookup tables, data import, spreadsheets, extract, transform and load, multiple databases, stored procedures, SQL 2012, Agile, SQL 2008, SQL objects, database design, spreadsheet, SQL scripts, OLAP, SSAS, SQL Server Reporting Services reports, SSRS, SQL, Microsoft Dynamics AX, Cognos, quality assurance, data model, database schema, SQL 2005 Servers, Microsoft Office SharePoint, SQL Server 2005, UAT, SQL Server, SQL servers, SQL databases, SQL Server 2005 BI, Microsoft SQL, SQL Development and Admin
Project history
03/2019
-
05/2019
09/2018
-
03/2019
SQL Database Developer
Freeman Grattan Holding
* Database development on a Brexit project
* Working with internal customers to establish likely Business Requirements based on limited
knowledge of impending legislation changes
* Providing data handling and reporting under potential new legislation across FGH's business for
them to comply with changing import and export regulation between UK and EU
Key achievements
* Working with other developers to provide data to be consumed through Teradata and API's to a tight
deadline and within budget
* Working with internal customers to establish likely Business Requirements based on limited
knowledge of impending legislation changes
* Providing data handling and reporting under potential new legislation across FGH's business for
them to comply with changing import and export regulation between UK and EU
Key achievements
* Working with other developers to provide data to be consumed through Teradata and API's to a tight
deadline and within budget
04/2018
-
06/2018
SQL Database Developer
Assurant
* Database development on a GDPR project
* Stakeholder management of internal customers
* Maintaining data under GDPR legislation right across all aspects of Assurant's business (for
example, to purge data over a specified retention date, to restrict access to data on a
stakeholder's request) and to maintain an audit of those processes
Key achievements
* Hitting the go live date regarding GDPR deadlines
* Stakeholder management of internal customers
* Maintaining data under GDPR legislation right across all aspects of Assurant's business (for
example, to purge data over a specified retention date, to restrict access to data on a
stakeholder's request) and to maintain an audit of those processes
Key achievements
* Hitting the go live date regarding GDPR deadlines
11/2017
-
01/2018
SQL Database Developer
Welcome Software
* 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
* 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
05/2017
-
09/2017
SQL Database Developer
Emerald Publishing; Lloyds Bank
* 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
* 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
09/2016
-
03/2017
SQL Database Developer
Kingsland Drinks
11/2014
-
06/2016
SQL Database Developer
Royal Bank of Scotland
* 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
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
05/2014
-
11/2014
Senior Database Developer
X Channel Marketing
* Maximising the use of SQL 2012 to develop and maintain databases for marketing analysis
Key achievements
* Introducing Agile approaches to project management
Key achievements
* Introducing Agile approaches to project management
02/2014
-
05/2014
SQL Database Developer
Integrated Dental Holdings
* Successfully completing a short-term contract to migrate several databases from SQL 2008 to SQL
2012 using SSIS, functions and stored procedures
2012 using SSIS, functions and stored procedures
01/2012
-
12/2013
Senior Database Administrator and Business Intelligence Analyst
Mitchell Farrar Group
* 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
* 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
07/2013
-
10/2013
SQL Database Developer
CAP Automotive Ltd
* 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
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
01/2010
-
01/2012
SQL Database Developer and Administrator
Insight UK
* 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
Key achievements
* Facilitating the production of business intelligence reports by liaising with Business Analysts
and BI teams to create new objects and structures
01/2008
-
01/2010
SQL Database Developer
The Paper Company Ltd
* 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
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
01/2006
-
01/2008
SQL Database Developer
Strategic Systems Solutions
* 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
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
01/2004
-
12/2006
SQL Server Database Analyst
Eversheds LLP
* 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
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
02/2006
-
09/2006
SQL Server Database Administrator and Developer
Accenture
* 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
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
01/2003
-
01/2004
Database Administrator
Homeloan Management Ltd
01/2001
-
01/2003
Support Analyst
Genusxpress
01/1999
-
01/2001
Help Desk Analyst
SquareSum Plc
01/1997
-
01/1999
Accountant
SquareSum Plc
01/1996
-
01/1997
Systems Consultant
Robert Half Accountemps and Hays Accountancy Personnel
01/1996
-
01/1996
Office Manager
Corporate Financial Systems
01/1990
-
01/1993
Computer Services Manager
Tempest and Dibb Ltd
01/1983
-
01/1990
Technician
Biscor Ltd
Local Availability
Only available in these countries:
United Kingdom
