Dave Watson Email & Phone Number

St Albans, Gb

London, England, United Kingdom

Working on a huge scale project of Legacy system SAS Data and Credit Scoring processing to Google Cloud Platform SQL (Big Query) and Python Migration. Extensive Data Auditing, Quality Checks, ETL, Standardisation and conversion of processing to GCP and Python. Data formats included JSON, XML, Google Cloud, complex SQL structures, SAS, CSV, TXT with DBCS & MBCS character complications.Analysis of CATO, and CAIS data to improve accuracy loading and data of products.

Welwyn Garden City, England, United Kingdom

Tesco Operations Development & People Transformation departments. Concurrent with Tesco.com Finance work.Covid-19 Modelling, ETL of 250k records per day via SAS, linking with Covid data from gov.uk, ECDC, ONS, etc. Extensive data analysis to predict absence & recruitment requirements. Automated emailing of reports to business partners.Excel / VBA Store rostering tool ; Job Family Structure Chart Tool ; Absence reporting.

Welwyn Garden City, England, United Kingdom

Tesco .com Finance : Concurrent with work in many other departments.Development & maintenance of Staffing Targets and Payroll Model (£300M of payroll). KPI report & Dashboards using SAS, Hadoop & Teradata extracted via SQL, ETL. Payroll modelling.

Welwyn Garden City, England, United Kingdom

Tesco People Operations ; Distribution Finance ; Tesco ROI People Operations. Concurrent with Tesco Operations FInance and Tesco .com Finance work.Absence Reports & Dashboards covering over 400k employees. SAS & Excel VBA, with ODBC.

Cheshunt, England, United Kingdom

Operations Finance ; Concurrent with Tesco.com contract.Retail Payroll Model (£3bn of payroll), and Payroll flexing system (both SAS) and converted to MS/Access with VBA. Created an MIS to summarise and report payroll actual data. Excel productivity tools through Excel Add-ins used extensively by colleagues.

Hemel Hempstead, England, United Kingdom

Data Cleansing, ETL, from huge databases to support the marketing team, and building big- data extracts to supply their data mining database. Improved extract times by 40%.

Welwyn Garden City, England, United Kingdom

Creation of SAS data cubes for a bespoke SAS based MIS. Each database was unique to each area of the business. Worked on big data analysis from the Tesco clubcard and One percent basket database, such as propensity to buy analysis, market segmentation, and branch multi-ranging analysis. Also specialized in SAS extract efficiency improvements for the team.

London, England, United Kingdom

Analyst Programmer through to Team Leader and Project Manager in the Sales Analysis and Billing Systems Team, responsible for billing databases and reports for all main company data, and client access systems (all SAS based). Led a worldwide project to convert their billing principles from resourced based to value based pricing using regression analysis to model client charges to their current levels. Demonstrated SAS modelling techniques used for pharmaceutical clinical trials. Process Improvement Group lead, and was involved in teams looking to get European Quality Award, BS5750 and ISO9001 accreditation.

Amsterdam-Centrum, North Holland, Netherlands

A sabbatical following my degree, this was a really interesting time, learning new languages and meeting people from all over the world !

Redcar, England, United Kingdom

Completed the installation of MICS Systems Performance Analysis & Capacity planning tool, replaced all CLIST & ISPF reports with SAS based reports, and set up a custom built front end SAS/AF menu system and report creation tool.

Bachelor Of Science - Bs, Computer Science, 2:1

Activities and Societies: Athletics Club, Cross Country Majoring in Artificial Intelligence, Real Time Systems, Languages & Compilers

A-Levels

Computer Science, Mathematics (Applied) ; Physics