John Rickatson

Contract Developer

Rawdon, Vereinigtes Königreich

Erfahrungen

Apr. 2024 - Mai 2024
2 Monaten

ERP Data Migration Analyst

Compleat Food

Consolidating, cleaning, deduplicating legacy source data with a view to populating a new ERP system.

Feb. 2024 - Apr. 2024
3 Monaten

Senior Data Engineer

Davies Group

Working on a "Proof of Concept" project to advise on update of existing data into a new data warehouse using Azure.

Sept. 2023 - Dez. 2023
4 Monaten
Nottingham, Vereinigtes Königreich

SQL Database Developer

Futures Advice, Skills and Employment Limited

Rewriting existing views, stored procedures, and functions from an on-premises host to incorporate in a few hundred SSRS reports to point at a new Azure SQL database.

Dez. 2022 - Mai 2023
6 Monaten
Darlington, Vereinigtes Königreich

SQL Database Developer

HC One Ltd

Working on a new data warehouse and BI / MI Reporting, SQL coding new and amending existing stored procedures, other db objects, ETL using SSSIS, SSRS, Power BI, SQL Server 2016, Visual Studio 2019/2022, TFS, SSDT, SSMS, MS Office 365, Teams, Solarwinds.

Jan. 2021 - Sept. 2022
9 Monaten
Oldham, Vereinigtes Königreich

Database Developer

The Guinness Partnership

I introduced Azure DevOps, Agile sprints and scrums and the use of Git for version control and to break down large projects into smaller, manageable chunks and to be overt in project planning, management, and progress reporting. Database development, performance tuning, ETL work - all using the MS stack (SSSIS, SSAS, SSRS), Power BI, SQL Server 2019, Visual Studio, Git, SSDT, SSMS, MS Office 365, Teams.

Juni 2021 - Dez. 2021
7 Monaten
Reading, Vereinigtes Königreich

Consultant Data Warehouse Developer

Aldermore Bank Plc

Aldermore Bank is moving their data warehouse application from an internal datacentre to one provided by a third party.

  • SQL development services in support of the DWH move project
  • SQL application development service to support the project team and ensure that all existing coding can be operated in the new environment and produce similar output
  • Work with the DWH1.5 project team to move DWH code from existing instance to new datacentre instance, including migration of databases, SSIS packages, SSRS reports and SQL config
  • Ensure ETL jobs are operational providing the same outputs as current instance
  • System test new instance

Using GitHub, Visual Studio 2019, SQL Server 2019, SSIS, SSRS, Power BI.

Jan. 2020 - Apr. 2020
4 Monaten
Horsforth, Vereinigtes Königreich

BI Developer

Tenet Group Ltd

Modelling, designing, populating, and reporting against a new data warehouse.

Collaborating with internal stakeholders and a development team to cleanse, deduplicate and map source data from multiple OLTP databases into a new dimensional data warehouse. Used Gitlab, Visual Studio, T-SQL, SSIS, SSRS, Power BI.

Key achievements: Building a data warehouse from scratch in 3 months.

Mai 2019 - Juli 2019
3 Monaten
Irlam, Vereinigtes Königreich

SQL Database Developer

Kingsland Drinks

Database development on a warehouse upgrade. Working with internal stakeholders and consultants to migrate source mainframe data through OLTP databases into an SAP software environment.

Key achievements: Improving daily data load into the data warehouse from over 90 down to just 7 minutes.

März 2019 - Mai 2019
3 Monaten
Leeds, Vereinigtes Königreich

Data Warehouse Architect

StepChange Debt Charity

Database development on the Diamond data warehouse project. Participating in daily Agile scrums. Designing new and improving existing data warehouse data loads from XML source files from PEGA app.

Key achievements: Updating SSIS routines to improve speed of daily loads from initial 19 hours to 90 minutes

Sept. 2018 - März 2019
7 Monaten
Bradford, Vereinigtes Königreich

SQL Database Developer

Freeman Grattan Holding

Database development on a Brexit project. Collaborating 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

Apr. 2018 - Juni 2018
3 Monaten
Crewe, Vereinigtes Königreich

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

Nov. 2017 - Jan. 2018
3 Monaten
Harrogate, Vereinigtes Königreich

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

Mai 2017 - Sept. 2017
5 Monaten
Bingley, Vereinigtes Königreich

SQL Database Developer

Emerald Publishing

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

Sept. 2016 - März 2017
7 Monaten
Halifax, Vereinigtes Königreich

SQL Database Developer

Lloyds Bank

  • 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

Nov. 2014 - Juni 2016
1 Jahr 8 Monaten

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 primary 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
Mai 2014 - Nov. 2014
7 Monaten

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

Feb. 2014 - Mai 2014
4 Monaten

SQL Database Developer

Integrated Dental Holdings

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

Juli 2013 - Okt. 2013
4 Monaten

SQL Database Developer

CAP Automotive Ltd

  • Collaborating with a team of .Net Developers to create SQL objects and a database design to supply 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

Jan. 2011 - Dez. 2014
2 Jahren

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

Jan. 2009 - Dez. 2013
3 Jahren
Vereinigtes Königreich

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

Jan. 2008 - Dez. 2010
3 Jahren

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

Feb. 2006 - Sept. 2006
8 Monaten

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
Jan. 2005 - Dez. 2009
3 Jahren
Vor Ort

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
Jan. 2004 - Dez. 2006
3 Jahren

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
Jan. 2003 - Dez. 2004
2 Jahren

Database Administrator

Homeloan Management Ltd

Jan. 2001 - Dez. 2004
3 Jahren

Support Analyst

Genusxpress

Jan. 1998 - Dez. 2002
3 Jahren

Help Desk Analyst

SquareSum Plc

Jan. 1997 - Dez. 1999
3 Jahren

Accountant

SquareSum Plc

Jan. 1996 - Dez. 1998
2 Jahren

Systems Consultant

Robert Half Accountemps and Hays Accountancy Personnel

Jan. 1996 - Dez. 1997
1 Jahr

Office Manager

Corporate Financial Systems

Jan. 1992 - Dez. 1997
4 Jahren

Financial Director's Assistant

Arthur Walton Ltd

Jan. 1990 - Dez. 1993
4 Jahren

Computer Services Manager

Tempest and Dibb Ltd

Jan. 1982 - Dez. 1991
8 Jahren
Lorem ipsum dolor sit amet

Biscor Ltd

Jan. 1979 - Dez. 1983
5 Jahren

Technician

Jan. 1977 - Dez. 1980
2 Jahren
Norwegen
Lorem ipsum dolor sit amet

Alcoa Møsjoen Aluminiumverk

Zusammenfassung

I would like to introduce myself as a Microsoft Partner, working as an experienced contract Microsoft SQL database / data warehouse / BI developer and DBA. I maintain my skills through installing SQL Server instances and continually training in SQL, Power BI, Azure, and related areas.

Sprachen

Englisch
Muttersprache
Deutsch
Grundkenntnisse
Französisch
Grundkenntnisse

Ausbildung

Okt. 1990 - Juni 1993

Tempest and Dibb Ltd

Okt. 1988 - Juni 1988
Lorem ipsum dolor sit amet

DMS · Management Studies

Okt. 1977 - Juni 1977
Lorem ipsum dolor sit amet

A-levels · Mathematics, Physics, Chemistry and General Studies

Zertifikate & Bescheinigungen

Microsoft Certified Technical Specialist (SQL Server 2005 BI)

Microsoft

Microsoft Certified Technical Specialist (SQL Server 2005)

Microsoft

Microsoft Certified Database Administrator

Microsoft

Microsoft Certified Systems Engineer

Microsoft

Microsoft Certified Professional

Microsoft