Border Force

2013

Border Force Data Warehouse

The Home Office Border Force is responsible for securing the UK border; it uses various large datasets to analyse cross-border activity and continuously seeks to improve its analysts’ efficiency. Capgemini tasked Unusual Systems staff to prototype a data warehouse based on Palantir’s distributed database.
During the project staff cleansed, normalised and fused (“ETL”) the datasets; wrote Java plugins for analytical toolset Palantir to query the shared dataset; designed models; explained different approaches to stakeholders; demonstrated prototype; advised analysts on search techniques; and wrote technical sections for the following winning bid.
Search times improved in some cases from weeks to a few seconds, and the demonstrator underpinned the winning bid for the following multi-million-pound project.