Fanzhou Liang

Previous Data Analyst, Now Solution Engineer at Connect Fibre Limited based in London, UK

Email: frank.liang@connectfibre.co.uk

Phone: (+44) available upon request

Address: available upon request

Education

2020 - 2021

University of Exeter
Exeter, England, UK

MSc Business Analytics
Merit

2018 - 2020

Cardiff Metropolitan University
Cardiff, Wales, UK

Bachelor - BA Business Management
First class/Distinction

2016 - 2018

Henan University of Technology
Zhengzhou, Henan, China

Bachelor - BA Human Resource Management
Merit

Professional Experience

Nov 2024 - present

Connect Fibre Limited
Solution Engineer

London/Remote, UK

Responsible for designing the fundational relational database for the company’s internal fibre planning system using SQL-Alchemy;
Design and implement to data pipeline to ingest large amount of data from files on sharepoint to properly managed PostgreSQL database;
  • I created my own implementation of S3 object storage system to load data into memory for verifying data assumptions;
  • For managing complex, trivial data tables and namespace, I created a data validation tool to streamline this process;
Design enterprise-level data warehouse for analytics and self-service reportings;
Developing tracing tool, network design automation based on graph theory for QGIS;

July 2022 - Oct 2024

Full Fibre Limited
Data Analyst

Exeter, UK

Responsible for leading and delivering technical project work for the Data and Analytics team;
Extensive use of PostgreSQL and PostGIS for data wrangling, visualisation and geospatial analysis;

Delivered Full Fibre’s data-driven financial reporting:

  • Wrangled and united several relational tables to form a single summarised view for the finance department. This product is key to financial reporting.
  • Extensive data cleaning, data validation and stakeholder engagement

Automation of reporting:

  • Automated the monthly service billing, annual carbon footprint, and weekly build reports.
  • This automation was primarily achieved through PostgreSQL and R-markdown
  • Implementation of strict unit tests to ensure accuracy and robustness of results.

Designed and implemented a fibreoptic network dynamic visualisation tool.

  • Applied graph theory and dynamic visualisations to create an interactive network interrogation tool.
  • This product allows fibre planners to see a schematic representation of the network – quickly highlighting poor design quality and disconnected apparatus.
Prototyped the company’s initial fibre routing report and data validation strategy.

Actively participated in internal code reviews to ensure accuracy of output and quality of coding in the team:

  • As part of this, co-piloted with colleagues on several high-impact projects

Designed and delivered a comprehensive introduction to SQL training course for non-technical colleagues throughout the business.

  • The course was extremely well received with attendees starting to use SQL for simple self-serve tasks.

Assisted in due diligence associated with software procurement.

  • Set up and tested a connection to an external API for data extraction and validation of a third-party software solution.

Mar 2022 - Jun 2022

Full Fibre Limited
Data Entry Admin

Exeter, UK

Transcribing data from fibre allocation sheet for OTDR (Optical Time Domain Reflectometer) testing – one of essential business operation for Data Department.

  • I automate this process by using VBA and R script.
  • Not only make the process three times faster, the control checks I placed also made sure high-quality data were produce for testing

Voluntary Experiences

Mar 2022 - May 2022

Exeter Green Party
Database Support

Exeter, UK

  • Generic ad-hoc requests and data transformations. Worked with MySQL workbench.

Jul 2018 - Aug 2018

Henan University of Technology
Student Interpretator

Zhengzhou, Henan, China

  • Student Interpreter, Volunteered as an interpreter for foreign teaching staff.