Github
LinkedIn
Twitter
YouTube
RSS

Banking Firm: Code Review & R Package Development

Banking Firm: Code Review & R Package Development
CLIENT

Banking Firm

SECTOR

Financial

The Challenge

The client came to Jumping Rivers having already written the code for their problem in VBA. They were trying to evaluate four measurements for agreements with their clients in the UK. Although they had technically solved the problem, VBA is limited in speed. Hence running it on a data set containing 3,000 agreements was taking twenty minutes. The end goal was to run it on 3,000,000 agreements. They estimated that for this data set, the code would take several days to run.

The Project

The client contacted Jumping Rivers looking to re-write and improve on their code. They had already evaluated that R was the tool for the job, and with Jumping Rivers knowledge and experience they decided we were the team for the job.

Our Results

Having looked at the problem, Jumping Rivers estimated that if written in R code, the code would take not days, but hours to run. We suggested a flexible solution that made use of R’s excellent functionality for performing a task iteratively. As a test, we had shortened the running time for the data set containing 3,000 agreements from 20 minutes to 30 seconds, over twenty times faster.

In the end, we had cut the total run time for the full 3,000,000 agreement down to seven hours meaning the client was able to evaluate their four measurements. In addition, Jumping Rivers has ensured the code was packaged as an R package, and was part of a reproducible workflow. This gives the clients the chance to inspect the code themselves, and use it for future problems.

Relevant Case Studies

Scottish Government: Fair Work Data Explorer - Shiny App

Fair Work Data Explorer

Jumping Rivers created a data pipeline and visualisation dashboard for public and policy maker consumption. The aim was to increase transparency and encourage positive change to the workplace environment. The application allows exploration of key performance indicators stratified by a host of protected characteristics.

Read more about Scottish Government
Banking Firm: Code Review & R Package Development

Banking Firm

The client came to Jumping Rivers having already written the code for their problem in VBA. They were trying to evaluate four measurements for agreements with their clients. However, VBA is limited in speed. Jumping Rivers were required to build a bespoke R package to replace and quicken the code.

Read more about Banking Firm
AGR TRACS International: Dashboard Development for Monte Carlo Simulation

AGR TRACS International

At the end of 2017, contacted Jumping Rivers. AGR TRACS International estimates the volumes of oil and gas in subsurface reservoirs. Their work involves combining a set of inputs for each reservoir layer (such as area, thickness, and up to five other inputs) – and then multiplying these inputs together.

Read more about AGR TRACS International
Electrics Company: Applying Machine Learning Tools to Highlight Anomalous Data

Electrics Company

Over the last two years, we have been working with a cutting edge electronics company to build advanced algorithms using R and Python. Since they are at the research & design stage of the development process, their data structure is unique and challenging.

Read more about Electrics Company
Environment Agency: Development & Deployment of 'Water Body Explorer' Shiny App

The Environment Agency

After winning a Water Hub Hackathon, Jumping Rivers were contracted to create a platform for the client using R Shiny, published on RStudio Connect. The platform aggregates raw data from many third party sources both internal and external to the EA, through bespoke APIs, commercial databases, and asset management systems.

Read more about Environment Agency
Financial Institution: Bespoke Report Generation using R Markdown

Financial Institution

The client wanted to assess the viability of R and R Markdown as a reporting tool for creating complex, bespoke documents. We recreated sample reports for them in R Markdown, showcasing that all of their specifications could be met, and provided them with example code and training.

Read more about A Financial Institution
Fujifilm: Shiny Dashboard Creation for Experimental Risk Assessments

Experimental Risk Assessments

Jumping Rivers built a tool for creation of experimental risk assessments via a centralised web application. The dashboard allows for collaborative working during the data entry and assessment formulation, report generation and tracks versions along iteration of the process.

Read more about Fujifilm
NHS Scotland: R Training

NHS Scotland

In the spring of 2018, NHS Scotland expressed a need to move from their existing software, SPSS and SAS, to using R. The difficulty they faced was that there are over two hundred data scientists in NHS Scotland, which made training everyone in the new software a logistical challenge.

Read more about NHS Scotland
Northumbrian Water: Interruption to Supply Risk Mapping using Spatial R Package

NWL Risk Mapping

In spring of 2020 Northumbrian water engaged with Jumping Rivers to build a modelling solution to better understand risks to the consumer within their network in order to provide a better service.

Read more about Northumbrian Water