Paul Thompson

Data Migration Analyst (Douglas Stuart Contractor) 11/2021 – 07/2023
SpiraxSarco, Cheltenham
• Identify, clean (using BI) and extract data from legacy systems, enter into Excel for entry into new web-based self-service catalogue, 100,000+ records successfully uploaded into the new system
• Transform data to fit defined format and structure, improve accuracy by enriching data with file metadata using XLOOKUP thereby overcoming issues with broken or missing hyperlinks. Improved data upload success by 30%.
• Provide validation analysis of data, e.g., identified inconsistencies in underlying data and produced Analytic reports for Engineering teams to action. Produced 4 in-depth reports during the contract..

Identified, cleaned and extracted data from legacy systems into Excel for entry into a new web-based self-service catalogue.
Successfully uploaded 100,000+ records into the new system.
Transformed data to fit defined format and structure.
Improved accuracy by enriching data with file metadata using XLOOKUP.
Overcame issues with broken or missing hyperlinks.
Improved data upload success by 30%.
Provided validation analysis of data on own initiative.
Identified inconsistencies in underlying data.
Produced analytic reports for Engineering teams to action.
Produced 4 in-depth reports during the contract.

Answered applicant queries to the telephone hotline.
Entered updates to applicants' records.
Recorded call details.
Guided applicants through UCAS’ new online application process.
Reported snags and issues to the development teams.

Led the successful transition of three capability systems.
Transformed systems from unsupported prototypes into robust and fully supported engineered platforms.
Represented user-side input during the design phase of UI/UX.
Identified data that yielded optimal mapping at a minimal cost.
Collaborated closely with implementation teams to guarantee timely delivery of high-quality releases.
Supported senior decision making with concise data analysis and insight reporting.
Received 2 reports awards from department seniors.
Used Optical Character Recognition to automate ingest of data from legacy documents.
Used ETL to enrich raw data at source.
Used Excel pivots to provide impactful reporting.
Oversaw changes of data protection safeguards ensuring system compliance with GDPR.
Managed a team of five analysts.
Oversaw training and professional growth of data team members.

Pioneered implementation of open source Pentaho (Ventara) ETL based analytic platform.
Enabled inexperienced coders to innovate using block building methodologies to create analytic chains at speed and low cost.
Ensured data enrichment themes under responsibility were incorporated into departmental methodologies.
Worked with external data supplier to increase reliability and accuracy of a £750,000 enrichment data set.
Attained two Special Merit Awards from department seniors for influential analytic reporting.
Worked closely with an international partner agency.

Recorded data in a fast-paced environment.
Interpreted data in a fast-paced environment.
Analyzed data in a fast-paced environment.
Prepared detailed documents and reports.
Managed complex internal and external data analysis responsibilities.

Maintained awareness of new technologies.
Offered innovative solutions in line with strategic business needs.
Received departmental recognition and award for innovation shown to solve a long-standing technology challenge.