Kaptein has assisted over twenty organisations in her work as consultant for PwC Data Analytics. The reference projects below are an illustration of the projects in which Kaptein engaged over the past five years. Data Insights was founded by Kaptein in November 2016 and has already assisted two clients: the Business Control division of the Public Prosecutor’s Office and the Performance & Risk division of Blue Sky Group. Both projects required a combination of project management, data management and financial modelling.
A Dutch bank had lost oversight of their world-wide projects and needed an overview of all projects to see if they could reallocate their projects budgets. Using a combination of VBA, Excel and Powerpoint we were able to make an insightful report that showed basic statistics of the projects. Based on the report the bank stopped some redundant projects. Also, the bank realised that it was necessary to start some new projects.
A foreign bank needed to search their data for illegal transactions. By text mining and smart data conversion we were able to identify suspicious transactions that could be reviewed manually by the bank’s lawyers.
As a result, a lot of time was saved by automising the data proces instead of reviewing transactions manually.
A human rights organisation needed to determine the amount of buffer capital that they needed to keep to have a probability of default of 0,1%.
We have hosted a few workshops in which the risk department summarised and quantified its risks (minimum, maximum and most likely). Afterwards we applied Monte Carlo simulation to determine the aggregated loss probability distribution. We have used this probability distribution to compute the probability of default for the current reserves and the necessary buffer capital for the risk profile of choice.
The analysis showed that the municipality had a higher risk than 0,1%. As a result they have increased their reserves.
A public organisation spent a lot of time in assembling monthly reports on KPIs. We adviced them to use an interactive dashboard in Qlikview, which automatically computed KPIs for every subdivision.
The improved transparency helped the management team to improve their organisation’s results in terms of quality and productivity.