CCL Computers is one of the UK’s leading manufacturers of bespoke PCs and Workstations for Business and Entertainment purposes. As part of a small agile team, my role was to support the business with their Core ERP system (Avante/UniBasic/UniData), which handled the business logic for all across the company, from order processing, shipping and receiving, to managing work orders in our factory floor and testing the built systems. My projects typically involved working with various departments to fulfil their data access requests, having built a framework to streamline the exporting of data through various means. As well as creating/modifying screens to suit their needs. This framework became a core part of our bespoke data pipeline process, we had multiple pipelines which fed into our new Analytical Data Warehouse (Azure SQL). I was the main person responsible for the creation and upkeep of both the pipelines and the Data Warehouse, frequently working with our Data Analytics team. Other common tasks included working with the Web Team to support our data syncing process between the ERP system and Web Database (T-SQL). Integrating several external APIs (SOAP & REST) into our ERP systems to interact with shipping companies, payment providers, and other services. And various other development tasks on the ERP system to support the wider business. I was also the main maintainer of our web scraper, which was used to monitor the pricing of our various competitors.

Vanquis Bank | Oct 2019 - Apr 2020

Junior Data Engineer

Part of a project which converted Mainframe data to ingress into Azure Data Lakes. The project used BDD/TDD and C# code to generate, based on schema files, tests and Python notebooks, which would run in Azure Databricks as part of a Datafactory pipeline. My role was to create/update the schema files based on vender specs, and add new functionality such as handling new date formats. I also created a solution to semi-automate the creation of these schema files. My biggest win at Vanquis was spotting that new fields in updated test files often had null data, which prompted me to ask if the new fields were needed, and suggested a way of blanking out these unneeded parts of the records. This allowed us to not always have to go through the full lengthy approval process for changes to the schema if the fields were unneeded.

Energy Assets | Jul 2017 - Sep 2018

System Administrator

IT Administrator for an SME. Supporting the servers, VoIP systems and general IT support. Assisted in the development of the company’s database programs, projects include an IT ticketing system, a visitor entry screen, and a vehicle information database.

Primary Technology Ltd | Jan 2014 - Jul 2017

Mobile Support Engineer

MSP in the Education sector, field/site based role. Provided generalised IT support for my assigned clients, supporting: servers, endpoints, mobile devices, users, audio visual equipment, photocopiers, networking equipment. Implemented automation techniques to reduce time requirements for repetitive tasks.

My Education

Take a look at my formal education

Data Engineering in Software DevelopmentDataCamp | 2022

Level 5 Diploma, Fullstack Software Development (Django)Code Institute | 2020

AVCE, Information TechnologyBradford College | 2005

About Me

Andrew hasn't filled in a bio text

Create Your Data Portfolio for Free

Andrew Kenworthy

Developer

CCL Computers | Bradford, West Yorkshire, UK

Python Developer

Snowflake Foundations

Professional Data Engineer

Python Developer

Analytical storyteller, weaving captivating narratives with the threads of data.

My Work

Project: Building a Retail Inventory Management System

Power BI Fundamentals

Professional Data Engineer

Project: Building a Demand Forecasting Model

Project: Analyzing Crime in Los Angeles

Project: Visualizing the History of Nobel Prize Winners

Project: Cleaning an Orders Dataset with PySpark

Project: Finding Exchange Rates for International Sales

Project: Building a Retail Data Pipeline

Project: Building a Retail Inventory Management System

DataCamp Course Completion

Courses

Courses

Tracks

Projects

My Work Experience

CCL Computers Ltd | Jul 2021 - Nov 2024

Software Developer (Data)