Profileimage by John Rickatson SQL Database Developer, Data Warehouse Architect, Power BI, Business Intelligence from Bradford

John Rickatson

available
Contact

Last update: 30.10.2019

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

Company: High Ideals Ltd
Graduation: not provided
Hourly-/Daily rates: show
Languages: German (Limited professional) | French (Limited professional)

Attachments

116229.docx
John Rickatson CV Concise 20201031.docx
John Rickatson CV Detailed 20201031.docx
John Rickatson References 20201031.docx

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
Data Warehouse Architect
StepChange Debt Charity

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Contact form

Contact details