liberTECHS

  • About
  • Contact
  • Portfolio
  • Home

Quantifying Compliance in the FTSE 100 Company

Goal

Develop a platform for gauging data BMS compliance across the company’s data landscape (1000+ of data nodes and 5000+ of data flows between them) in real time. Establish, centralise and create organisation-wide transparency by enabling the business to continuously manage the data about data (eg. information on data ownership, business purpose, data related obligations, state of their data controls, state of their data quality). Also, identify and profile data related risks, drive remedial actions.

Role

  • I have led the development of key components within the compliance apps ecosystem, which powers the creation, measurement, and automation of data management standards compliance for the UK’s electricity system operator, National Grid ESO.
  • I proposed and implemented various automated workflows (e.g., QuickBase native API, Python API, Power BI UI) to identify gaps, track progress, report findings, and initiate personalized remedial actions across over 60 business teams.
  • I translated the standards into more than 30 custom-coded KPIs, including procedures for strengthening data controls across thousands of the company’s critical and operationally critical data nodes and flows using the QuickBase native API.
  • I simplified and streamlined the user experience (UX) and user interface (UI) of the National Grid ESO’s “Data Management Library” app to ensure it aligns seamlessly with evolving business needs.
  • Despite a 2x reduction in my team’s headcount, my achievements were crucial in maintaining and improving our team’s service levels (annual NPS score up from 53 to 65).

Capability

The main app in the ecosystem – the National Grid ESO “Data Management Library” (DML) featuring:

  • 30+ live custom coded KPIs measuring compliance against
  • Data BMS standards in
  • 65 business teams owning
  • 1000+ data nodes and
  • 5000+ data flows

Skills

QuickBase native API, Python Pandas, Python Selenium, Power BI, HTML5, SQL.

Year

2021

Filed Under: Apps & Websites, Data Engineering & BI

Text Processor

Goal

Automatically recognise, process and evaluate structured text data. Tool builds up an integrity score (0-100 score) for a professional advisor based on the attributes of the reviews they receive.

Role

I developed a python tool to recognise, process and evaluate structured text data.

Capability

Python tool reads input text data line by line and calculates an integrity score based on a number of factors:

  • Lots to say: Genuine reviewers tend to say less – knock 0.5% points off for each review that contains more than 100 words.
  • Burst: If a number of reviews come in within the same time frame – knock 40% points off if 2 or more come through in the same minute, 20% points if they come through in the same hour.
  • Same Device: We have a system that forms a readable tag (e.g. LB4-6WR) based on the browser/device/location. If we are seeing multiple reviews coming from the same device knock 30% points off each time.
  • All-Star: Non-genuine reviews are likely to have a five-star rating take 2% points off the integrity score for each review that has 5 stars; quadruple the penalty if the average is under 3.5 stars.
  • Solicited: If the review was left by someone who was invited by the professional then add 3% points to the integrity score.

Skills

Python, API development

Year

2020

Filed Under: Data Engineering & BI

Automated Trading

Goal

Coming soon.

Role

Coming soon.

Capability

Coming soon.

Skills

MQL4 (scripting language for automated FX trading via MetaTrader 4 platform)

Filed Under: Data Engineering & BI

  • « Previous Page
  • 1
  • 2

CONTACT

To get in touch, please fill out a contact form or give me a call at +44 7854 878 140.

 

SOCIALIZE

  • LinkedIn

JUMP TO

About
Portfolio
Home

© Copyright 2020 · LIBERTECHS · All Rights Reserved

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.
You can revoke your consent any time using the Revoke consent button.