Jorick van der Hoeven

CAREER

Director People Analytics (Data Science), Gartner

Stamford, CT July 2020 – Present

Manager Analytic and Forensic Technology, Deloitte

New York, NY June 2017 – July 2020

Assistant Manager, Deloitte

Geneva, Switzerland September 2014 – May 2017 (Seconded USA 2015-2017)

Senior Consultant, Deloitte

Geneva, Switzerland January 2014 – August 2014

Consultant, Deloitte

Geneva, Switzerland March 2012 – December 2013

SKILLS

SQL Programming — Built automated analysis models to parse financial institution client data to identify key risk indicators, built models to examine file metadata to find potential issues in forensic investigation. Build custom analysis dlls to speed up text processing in mssql server.

Python Programming — Architected and built a cloud application leveraging microservices and multi-threaded distributed processes, additionally leveraged asynchronous methods to speed up the application to beat systems on the market by 50x in head to head tests. Oversaw Machine Learning models built using PySpark to process terabytes of data.

Amazon Web Services (AWS) — Leveraged automated creation of specially configured EC2 and EMR instances as well as configured massive data transfers to AWS Snowballs. Established and maintained a VPC used as a project environment to analyse terabytes of unstructured data and natural language text.

PowerShell Scripting — Used PowerShell to create automated verification scripts to confirm that structured data provided by clients in various formats was correctly loaded into analysis databases.

ElasticSearch — Built a multi-level file index which allows for rapid record retrieval as well as simple analysis of complex file structures. Architected data access methods to leverage multi-core and multi-node ElasticSearch cluster properties to speed up document retrieval and updates.

Data Visualization — Regularly presented data analyses to the C-suite of my clients. Breaking down the complexity of the analysis into ways that can be easily understood.

EDUCATION

Oxford University, United Kingdom

2010 Master in Computer Science – First class honors (summa cum laude) Specialization in wireless sensor networks working with an interdisciplinary Oxford-Cambridge research group “Sensor Networking Group: WildSensing”

Oxford University, United Kingdom

2008 Bachelor in Computer Science – Second class honors; division 1

PROJECTS

Project DRACS:

  • Built a distributed framework using Python to scan, index, and categorize unstructured data in NTFS file stores.
  • Coordinated with a development team to design and build a graphical user interface on top of the distributed system allowing clients to quickly and easily segment data in NTFS file stores.
  • Integrated a microservice framework into Kubernetes for quick establishment of new environments.

Project Wi:

  • Led a team of consultants to help a pharmaceutical client to identify redundant and obsolete data in their systems triaging 170 TB of data and deleting 40 TB of unnecessary data.
  • Oversaw the development of analytical models using PySpark to classify 15 TB of documents into a records retention schedule.
  • Designed distributed processes to integrate client stakeholder feedback into the developed taxonomies.

Project E:

  • Led the discovery and analytics aspects of an investigation into a global fashion company focused on licensing and royalty reporting.
  • Analyzed one custom ERP system to restore fraudulently misreported sales which were deleted in the active system using SQL Server.
  • Analyzed a different custom ERP system to identify misclassified sales using Oracle and SQL Server.
  • Reconciled transactions from customers, providers, and licensors to accurately determine the actual number of mis-reported and misclassified sales.

Project W:

  • Assisted the leadership of a global professional services firm in responding to an intrusion. Built a C# tool to quickly and efficiently split email inboxes based on email recipients.
  • Assisted with the planning for and coordination between technical investigation teams.
  • Visualized the timeline of events for leadership in a simple and understandable way, allowing them to share the incident response team’s insights with others.

Project T:

  • Led a team in an investigation to help the executive committee of an offshore Private bank. Chaired weekly meetings with the bank’s executive committee and international regulators.
  • Designed the analysis and investigation methodology respecting limitations on the bank infrastructure.
  • Used VBA to create tools allowing non-technical team members to interact with structured data.
  • Used SQL Server to build a risk model identifying key risk areas for the bank.

Project C:

  • Built a relational database model supported by SQL analysis scripts to automate identification of key evidence.
  • Created Python scripts to extract artifacts identifying which locations on the network were accessed by specific users.

Project S:

  • Key point of contact for a large hospitality firm needing forensic analysis of evidence.
  • Managed multiple small projects to assist the client with data exfiltration and data deletion issues.

Project V:

  • Led a team of technical consultants to support an investigation into a top tier financial institution facing international regulatory pressures.
  • Liaised with international legal teams to assist them with their negotiations with regulatory bodies.
  • Built analyses in SQL to calculate potential financial penalties.
  • Maintained and modified tools written in C#.
  • Performed Quality Assurance reviews of technical work products.

Project B:

  • Provided forensic insight and assistance in the acquisition of a large Swiss Private Bank.
  • Learned, implemented, and administered a sanctions screening tool to identify at-risk clients using the - Factiva and WorldCheck databases.

Project M:

  • Key point of contact for the financial institution, assisting their steering committee in responding to regulator requests.
  • Assisted, and subsequently led an investigation at a top tier financial institution facing international regulatory pressures.
  • Implemented a modular, transferable, risk indicator search program which I built using SQL Server scripts to assist financial institutions with their obligations to overseas regulatory authorities.
  • Retained the business of a client who was looking to change vendors by addressing their concerns quickly and efficiently using agile project management methods.

Project L:

  • Designed and built a prototype of a risk indicator search program using SQL Server to assist financial institutions with their obligations to overseas regulatory authorities.
  • Designed and implemented the e-Discovery process involving two review locations and two processing locations in different countries based on a Nuix and Relativity stack.
  • Built the technical infrastructure on which the e-Discovery platforms ran using Windows Server and Windows SQL Server.
  • Built Python tools to parse data and manipulate PDFs. Built Ruby tools to automate Nuix processing tasks.
  • Converted multi-dimensional data from Temenos T24 to two-dimensional data for ingestion into SQL Server.

Project H:

  • Maintained the code for C# programs handling PDF files used to prepare documents for regulators.
  • Designed MS Office based tools (Access and Excel) to allow stakeholders both to manage a call center and to review work performed by attorneys on the project.

LANGUAGES

Native:

English French

Fluent:

German Dutch

Conversational:

Spanish