Employment and Key Projects

Major Projects

Three/Vodafone – Data Sharing Solution

My current main project involves the development of datasets to be shared with Vodafone that can be consumed into existing pipelines and reports to provide consolidated and source-company views, as well as cross-company reports, such as volumes of shared customers. This is a key enabler of a fifteen-billion pound merger, and involves cross-company and cross-department collaboration, on identifying common attributes, and  implementing transformations to synchronize attributes created under different business logic.

Three – OSS

I took the lead in multiple iterations of a peta-byte scale streaming data from Kafka (later Azure Event Hub) into Databricks medallion architecture and a Snowflake presentation layer.  This replaced a third-party implementation saving multiple hundreds-of-thousand pounds of compute cost.

Three – Databricks implementation of Unity Catalog

Planned and implemented the implementation of Unity Catalog over Three’s Databricks workspaces and datalake. This included creating Terraform modules to automated the infrastructure deployment, developing security and access policies, and carrying out data migration activities, and cut-over of streaming and batch processing jobs.

This greatly enhanced Three’s governance and accessibility and discoverability of data assets, enabling numerous new use cases including analytics and data science, as well as simplifying access request processes.

Three – Contract Centre Reporting Suit

A consolidated set of dashboards for contact centre reporting was created in Power BI with a SQL Server datawarehouse and data ingestion with Integration Services and custom Python jobs.

These combined call volumes by location and categorizations with elements such as network topology, planned and unplanned outages, crowd sourced performance data to identify and prioritize network and IT outages, supported product launches, highlight impact of incidents. This replaces days per week of manual reporting, and enabled a much deeper level of investigations.

Vodafone – Cloud and Hosting Lead Conversion Reporting

Following a series of mergers and acquisitions Vodafone Cloud and Hosting sales leads were split over three separate management systems. There was a requirement to be able to report a consolidated view that could be presented to Sales Directors, and discussed in weekly team meetings.

In addition to different terminology and processes within each tools set, this was complicated by poor data quality, especially completeness, due to incomplete reporting.

Ericsson - SQL Reporting Services ITSM Reporting Suit.

Following the deployment of a IT Service Management tool set for Incident, Problem, Change and Task management, I was required to develop a reporting environment (analytical database in SQL Server) and suit of reports in SQL Reporting Services. This required translating OTAP tables to reporting objects, prioritizing and translating requirements gathered from internal and external customers, and was delivered with aggressive timeline. Once delivered, an iterative approach was required to new and changing requirements and source system.

Ericsson – Off-shored Knowledge Transfer

I collected, reviewed and updated a set of work instructions and processes for service management reporting, and travelled to Bangalore to carry out in person knowledge transfer. Involved cross-cultural collaboration, and a focus on detail in creating a well working team that were able to carry out a seamless transition.

Employment History