Christopher Williams Email & Phone Number

Cheltenham, England, United Kingdom

Building and owning responsibility of the reference data service as first point of contact at admin level. The project aims to unify various legacy source systems reference data into one unified, centralised platform; where all the data is in the same format and data types which enables easier querying for data scientists, analysts and data engineers across the business.Reference data service is a platform for managing and mastering reference data which will be used as the single source of truth to back up analysis when completed, currently there is no single source of truth for reference data- this will allow for accurate reporting and standardisation using data across the business for all. Creating documentation of this process for everyone to understand how to ingest and manage the data in the system to a high standard and consistency.Automated various manual processes such as data cleansing and encryption of files en masse via python.- Reduced reference data copies ahead of target by 2 months.- Created single source of truth for reliable analysis- Administrated changes and created reference data lists- Point of contact for Reference data, answering questions and helping others, including knowledge sharing across the business via presentations and demos. -Taking responsibility for governance and administration of reference data, making crucial business decisions regarding reference data.-Taking initiative to setup meetings with clear agendas and liaising with technical and non technical stakeholders to deliver a functioning product. Oracle DB SQL developerPostgres admin (pg admin)Excel Data Grip RACI documents and stakeholder managementApgar reference data service - admin level VSCode - development of python scripts for automation using various libraries such as pandas and os

Stroud, England, United Kingdom

I provided insights and solutions backed by data that drive change and improve the customer's experience through locating weaknesses and innovating processes, improving our quality of service overall.I generated custom SQL queries; leveraging Salesforce CRM, SAP and Junifer billing system's source data, through use of SSMS and Azure Databricks to support business insights and perform root cause analysis. I Developed and maintained PowerBI dashboards, ensuring data accuracy and reporting for decision-making up to the CEO level.Special/Noteworthy Projects:•Aided the reduction of outstanding customer unbilled value by £4.8M through providing bespoke investigative insights into billing failures with root causes.•Created an end-to-end process with technical documentation for a government RFI, streamlining data collection for low technical level users to complete the quarterly report in my absence, this included apeer review process.•Developed custom SQL scripts to rapidly aggregate data for end users, resulting in a major data collection speedup. Including price change quarterly project and on demmand queries.•Implemented a custom model to evaluate daily billing shortfall, identifying differences in billing forecast and actual outcome. Also, various other apprenticeship projects with real business value.•Migration of PowerBI dashboard's datasources to new instance of databricks and rebuilding dashboards for accurate reporting.•In charge of data governance for continuous improvement and billing departments; championing best practices, such as source control and agreed best data sources.

Cheltenham, England, United Kingdom

Worked across multiple departments during education and gap year; from taking deliveries from trucks, to warehouse and checkouts. With focus on team work and working in a fast paced environment.