John Rickatson

• Worked on a proof of concept project to advise on updating existing data into a new data warehouse using Azure.

• Modeled, designed, populated, and reported against a new data warehouse.
• Collaborated with stakeholders 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.

• Modeled, designed, populated, and reported against a new data warehouse.
• Collaborated with stakeholders 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.

• Developed database on a warehouse upgrade.
• Worked with stakeholders and consultants to migrate source mainframe data through OLTP databases into an SAP environment.

Key achievement:

• Improved daily data load into the warehouse from over 90 minutes down to 7 minutes.

• Developed database for a Brexit project.
• Collaborated with internal customers to establish business requirements based on impending legislation changes.
• Provided data handling and reporting under potential new legislation to comply with import/export regulations between UK and EU.

Key achievement:

• Provided data for consumption through Teradata and APIs to a tight deadline and budget.

• Troubleshot database performance on-site and off-site.
• Managed stakeholders.
• Introduced database performance, monitoring, and maintenance changes.

Key achievement:

• Resolved performance issues in reduced timescale.

• Facilitated migration of employee data from Oracle to a new Fusion HR and payroll system.
• Analyzed systems, mapped data to SQL 2012 databases, created data extracts.
• Generated GUID and lookup tables from multiple sources.
• Led reconciliation between systems and environments, including historic data porting.
• Created mail merge system for employee benefits data validation.
• Used SSIS to manage dependencies, validation, transformation, control, and error trapping.

Key achievements:

• Designed a primary SSIS package controlling ~400 smaller packages for ETL completed in 20 minutes.
• Created multiple databases and ~300 stored procedures.
• Managed all activities to meet strict regulator-imposed deadline.

• Migrated five databases from SQL 2008 to SQL 2012 using SSIS, functions, and stored procedures.

• Implemented SQL 2008 for ad hoc object creation, troubleshooting, and administration.
• Created and populated a dimensional data warehouse schema using SSIS, built OLAP cubes with SSAS, and developed reports using SSRS.

Key achievement:

• Amalgamated marketing data from 10 companies into one database to comply with FCA regulations on customer data usage.

• Designed a data warehouse solution for rollout across 25 companies to improve accuracy and efficiency and enable Cognos reporting.
• Created a proof of concept using SSIS reusable code and built QA into the process.
• Developed an ER Studio data model with 120 scripts for the new schema, basis for SSIS packages.
• Worked flexibly from home and international offices.

Key achievement:

• Created an end-to-end model of the new business data warehouse.

• Configured two SQL 2005 servers for the Universities Superannuation Scheme and supported a SharePoint installation.
• Liaised with Citigroup management to analyze server farm performance, design, and security.
• Wrote code for monitoring and reporting, redesigned legacy processes for data archiving and purging, prepared for SQL Server 2005 upgrade, and covered UAT roll-outs.