Robbin Herst

ASML

Apr 2022 - now

At ASML, Robbin had multiple responsibilities. Robbin developed parsers in Python to parse XML files towards Delta (bronze layer). This was done inside a generic framework within ASML. To parse the data towards a silver layer, Robbin had set up its own framework in Databricks. The first part was the deployment of Azure resources using Terraform (Databricks, ADLS, Event Hub, Log Analytics Workspace). Second part was the development of a framework to be able to run parsers towards the silver layer. This framework is built in PySpark and uses YAML configuration files to release and deploy jobs in Databricks (using Terraform). This framework enables us to stream (Spark Streaming) or batch process data by executing parsers. To build and deploy code, Robbin developed build and release pipelines in Azure DevOps using YAML.

Close Window

Provincie Noord-Brabant

Dec 2020 - Apr 2022

Robbin upgraded the Azure data platform to a newer version, moving from the SQL servers in Azure and Data Flows in Azure Data Factory towards an Databricks Lakehouse structure. Similar to the Gemeente Tilburg, responsible for developing build and release pipelines in Azure Devops using YAML, extract data from different source (e.g. NDW, KNMI, etc.) using Azure Data Factory and parse that data from bronze towards silver and gold layer. Implemented a similar framework in PySpark to enable other developers to parse data more easily using metadata.

Close Window

Gemeente Tilburg

Jun 2020 - Jan 2022

Robbin was responsible for setting up an Azure data platform (Lakehouse) (ADF, ADLS, Databricks, KeyVault, Log Analytics Workspace) using ARM templates. Developed build and release pipelines in Azure Devops using YAML to deploy the resources and ELT pipelines for data processing. To get data in the Azure Data Platform, Robbin extracted different sources (e.g. KNMI, CBS) using Azure Data Factory. Robbin built a generic framework in PySpark to enable other developers to parse data more easily using metadata using the bronze, silver and gold structure. This framework consists of functions like readers and writers, functions to convert geo data automatically and so on.

Close Window

Spierings Mobile Cranes

Sep 2020 - Nov 2022

Project to stream data coming from mobile cranes in Azure. Providing data for analysis in Power BI by using IoT Hub, Stream Analytics and Azure SQL server. Robbin was responsible for deploying Azure Resources (ADLS, IoT Hub, Stream Analytics, SQL Server) using ARM templates. Next to that, parsing data coming from the IoT hub using Stream Analytics towards ADLS (for historic analysis) and SQL server (for real-time reporting in Power BI). Created a dashboard on top of the data to display the status of mobile cranes.

Close Window

Philips

Sep 2018 - May 2020

Develop and maintain ETL processes using SQL Server Integration Services (SSIS). Database administrator of SQL Server. Create reports using QlikView and administer the QlikView server, QMC and AccessPoint. Interact with users, gather requirements.

Close Window

Vesting Finance

Feb 2018 - Aug 2018

Building a data control monitor and calculating KPIs using T-SQL (dynamic SQL, stored procedures). Creating models in Master Data Services and Azure Analysis Services that are used in creating Power BI reports.

Close Window