Nick du Chatinier

Development - Data - Integration - Optimization - Business Intelligence

Male

January 31th, 1995

See contact form

Frequent Drone Flyer

Casual Gaming

EXPERIENCE

ilionx

Fulltime since March 2020

Posted at clients
Led 'Power Bi in a Day' training workshops for external stakeholders, effectively sharing knowledge and generating potential leads, contributing to the company's business development efforts.

Rabobank

Posted Oct 2021 - present

Designed and implemented GUI components with Angular for seamless interaction with the API of a Self-service integration solution
Collaborated within a DevOps team to develop and implement custom components tailored to stakeholder requirements in a self-serviced dynamic integration solution using Java Spring and Apache camel
Developed an automated solution for application access requests, reducing manual intervention and enhancing efficiency by streamlining the user onboarding process.
Created a comprehensive Power Bi Dashboard to visualize migration and application data.
Automated data retrieval from a database using Powershell in an Azure Pipeline, storing data in Blob storage and setting up automatic refresh schedule for ingestion by Power Bi
Contributed to the successful migration process from Java Spring to Java Quarkus, enabling the development of native applications tailored for efficient deployment and scalability within the Openshift environment.
Developed an automated solution in Microsoft Power Automate to create Product Backlog Items in Azure DevOps on submission of a Microsoft Form, reducing manual intervention and enhancing operational efficiency in the DevOps team.

Slimmer - Kiezen

https://www.slimmer-kiezen.nl

Designed a voting guide based on the voting behaviour of political parties in the Dutch House of Representatives.
Designed and developed a Java Spring Boot solution to retrieve political documents from the Opendata Portaal and scrape data from the website of the Tweede Kamer (Dutch house of Representatives).
Developed and designed a Java Spring Boot solution leveraging ChatGPT implementation to streamline and simplify the contents of extensive political documents.

Define - Function

Creative Endeavors

Utilising provocative prototypes, led interactive design sessions to develop a website incorporated with a management system to facilitate dynamic content creation and theme customization for the local Brass band, employing Bootstrap, Javascript and PHP. (https://www.stmartin.nl)
Developed a website for a local association using JavaScript and PHP, streamlining the registration process for seasonal activities and enhancing user experience.
Successfully engineered a self-service File-Transfer solution leveraging Apache Camel within Java Spring Boot, integrating Bootstrap and Javascript to enhance the user interface. Using Docker for seamless containerisation, facilitating efficient deployment and scalability. Orchestrated data exchange through a reverse proxy on a separate Docker network, ensuring robust security and optimised performance. (Github)

Trespa

Graduation Feb 2021 - Jul 2021

Conducted thorough research to identify areas for improvement in the Customer Special Request process, resulting in the development of a new, optimised design aimed at streamlining operations.
Performed in-depth analysis and evaluation of various low-code platforms to determine the optimal choice for developing a solution tailored to support the new process. Emphasis was placed on selecting a platform that enables easy customisation and modification by non-technical personnel within the company, ensuring long-term flexibility and scalability.

ilionx

Internship Sep 2019 - Jan 2020

Performed comprehensive data analysis to identify the specific data necessary for addressing a Sales unit case, while also addressing the availability and accessibility of existing data sources.
Developed a Power BI Dashboard using an iterative approach, leveraging a functional prototype to progressively align with stakeholder requirements and steer towards the desired end-result.

Edutel B.V.

Helpdesk Oct 2015 - Dec 2018

Delivered comprehensive technical support to OnsBrabantNet customers, resolving issues and inquiries related to TV, telephone and internet services over Fiber Optic products.

"It always seems imposible until it's done."

- Nelson Mandela

Versatile DevOps Engineer Excels in Analytics

As a dedicated and accomplished Java DevOps developer and Business Intelligence specialist, I bring a comprehensive skill set and a proven track record of contributing to impactful projects. My expertise in containerization with Docker, dynamic integration solutions using Java Spring Boot, and developing user-centric interfaces with Bootstrap and JavaScript enables me to deliver robust and scalable solutions. Graduating Cum Laude in Business Intelligence, I possess strong analytical capabilities that complement my technical proficiency.

Key strenghts

Technical Expertise: Proficient in Java Spring Boot, Angular, Docker, Apache Camel, Bootstrap, JavaScript, and PHP, ensuring the development of efficient, secure, and scalable solutions.
Process Optimization: Automated key processes such as access requests and customer special requests, significantly improving operational efficiency and user experience.
Training and Development: Conducted comprehensive "Power BI in a Day" training sessions, enhancing client capabilities and driving business growth through knowledge sharing.
Collaboration and Contribution: Played a role in developing a self-service file-transfer solution, demonstrating strong teamwork and problem-solving abilities.
Data Quality and Presentation: Automate processes to ensure data quality and visualize valuable business information based on stakeholder requirements.

Value Proposition:
By leveraging my diverse technical skills and business intelligence background, I can contribute to your company's success by developing innovative solutions, optimizing processes, and enhancing team capabilities. My ability to translate complex requirements into practical applications ensures that I can deliver results that align with your strategic objectives.

Business Intelligence

Discover my business intelligence skills to gain insight into your business processes and systems to improve your operations.

Development

Describes my skills in developing back-end solutions in programming languages like Java Spring boot and/or Quarkus and front-end in Angular, Javascript and html/css.

Data Engineering

Describes my skills in developing solutions to extract data from one or more sources, transform it to a usable format and load it to a storage solution.

Slimmer - Kiezen

As owner of Slimmer-Kiezen I'm proudly describing this project to illustrate my skills in setting up an extensive back- and front-end solution to support political voting.

Project Management

While being posted at various clients, I've always worked in Scum team structures and therefore learned a lot on the different roles. I gained PSPO and PSM 1.

Business intelligence

As a business, it is important to use IT to help your organization operate as efficiently as possible and create maximum value. As a BI consultant, I find it just as challenging and exciting to examine your processes and help you with issues of automation and optimization, as it is to provide insight and develop solutions.

Transform data into clear and practical insights critical to decision making in your organization. This portfolio focuses exclusively on data visualization, as well as the skills to analyze and improve processes using Process Mining.

Power Bi Data Analyst Associate (PL-300)
Dashboard In A Day - Power Bi Instructer
ChartJS - Create dashboards on websites.
Process Mining in Disco and Celonis certification.

Power Bi

I hold Microsoft's prestigious Power BI Data Analyst Certificate, proving that I have the necessary skills and knowledge to analyze and visualize complex data sets. I have also taught “Dashboard in a day” classes on using Power BI as an instructor, teaching others how to harness the full power of this platform.

What sets me apart is my ability to transform data into clear dashboards that truly impact decision-making within your organization. I understand that no one has time to flip through endless spreadsheets or interpret complicated reports. That's why I strive to present information in a clear and visually appealing way so that important insights become immediately apparent.With my help, you can make more informed decisions, identify trends and discover growth opportunities that would otherwise remain hidden. Whether you need one-time advice or long-term support with your data analysis projects, I am ready to take your business to new heights.

With my help, you can make more informed decisions, identify trends and discover growth opportunities that would otherwise remain hidden. Whether you need one-time advice or long-term support with your data analysis projects, I am ready to take your business to new heights.

Process Mining in Power Bi

More and more companies are using Process Mining to visualize and analyze the processes in their systems. This allows them to explore where improvements can be made and waste can be eliminated. To explore the possibilities of Process Mining in Power Bi, the dashboard below was created. This dashboard shows fictional data from a call center and displays not only general Key Performance Indicators, but also the processes of the underlying registration system such as TopDesk.

ChartJs Dashboard

Chart.JS is a fantastic Javascript Library used to provide websites with engaging and understandable visualizations. We recently deployed this library to add a complete dashboard to Slimmer-kiezen.nl. Over the past few months we have been working hard to improve this solution. Below you will find a glimpse of the possibilities of ChartJs and what I have created with it. Thanks to clever use of ChartJs, it is even possible to create dynamic visualizations and work with drilldowns. Moreover, you can also easily change the datasets of a visualization based on actions on the website.

Development

This part involves developing business solutions in different development environments, languages and or programs. Given my passion for IT, I prefer not to stay tied to a single specialty. Thus, I get passion from discovering a new language or programming solution with which I can broaden my horizon. In the past I have frequently developed (complex) websites, automated tasks and written integration solutions.

As one of the founders of Slimmer-Kiezen, I am responsible for developing the website, setting up the underlying systems, and managing/keeping the system running in Docker. Be sure to take a look at Slimmer-Kiezen.nl

See below my skills related to developing beautiful solutions that can help businesses move forward.

Power Apps

Power Apps, part of Microsoft's Power Platform, is currently widely used for automating simple tasks. It is a low-code application with benefits. I have experience setting up solutions in Power Apps and automating tasks with Power Automate, such as converting form requests to concrete tasks in Azure Dev Ops.

Javascript

With my expertise in Javascript, I develop websites that are interactive and feature dynamic functionality. My goal is to improve the user experience by making the website more user-friendly and ensuring that it can interact with back-end services. I have already gained extensive experience with Javascript, including on projects such as Slimmer-kiezen.nl, as well as other websites I have created for satisfied clients.

Jquery

In the past, jQuery has been used to improve and simplify tasks such as traversing and customizing HTML documents. I have successfully applied this library to developing Ajax requests, implementing events in the Document Object Model (DOM) and customizing the display of Web pages.

HTML/CSS

All websites previously created by me have HTML/CSS as their foundation. When designing a website I prefer to use Bootstrap, but I am equally capable of doing so without using the framework. Check out my portfolio at define-function.com

PHP

In the past, I have used PHP to write and retrieve data to a MySQL database. The retrieved data is processed and then displayed on the website, or user input is processed and stored in the database. This has allowed me to develop several websites that have permission to process user activity or retrieve data, with or without the use of personal information.

Java/springboot/Quarkus

Took several courses on programming with Java in Springboot and Quarkus. During this learning process I enjoyed working with Java a lot. I already apply this knowledge when developing and maintaining a dynamic integration solution in Apache Camel in Spring and Quarkus. I also use Java when developing APIs, such as those of Smarter Choices. Here I use Java to retrieve, clean and process data from public sources, then simplify it using ChatGPT.

Apache Camel

Apache Camel is widely used in enterprise environments where complex systems and applications need to be integrated. It provides a solution for reducing the complexity of integration projects through reusable patterns and components. As a Java developer, I gained experience working on the development and maintenance of Apache Camel solutions, using standardized dynamic routes by overriding different classes of the library. In addition, adding Custom components that are not offered by default, defining filters that files must meet and setting up a variety of Shutdown and/or Idempotent and/or In-progress strategies. This also allows setting up multiple environments that have identical operations but do not interfere with each other.

Angular / Typescript

Managed and developed the GUI of a Self-Service Integration solution for a client. Implemented several automations in the context of usability and in this way gained experience in working with Angular. Also took into account the connectivity with back-end services and MFA authentication via the Microsoft Msal libraries.

Last-but-not-least, within my education was mainly programming in C#. So I have some knowledge of the language, however, experience in programming with Java, among others. Which makes a refresher course an option for service.

Goals to improve my development skills.

As a goal for further development of my knowledge and skills, I would like to do more with Openshift and working with Microservices in container environments.

data engineering

The quality of Bi solutions are inextricably linked to both the processes responsible for processing the data in business applications and also the conversion of this data to a central data warehouse in which the quality of the data is guaranteed.

I can access, transform and load data from different data sources using the ETL/ELT (Extract, Transform, Load) method. Currently, I also apply this in retrieving data from different sources for the Smarter Choices project. This data is edited and enriched and processed in a database after retrieval.

For data retrieval, transformation and/or far-reaching, I have experience with the following techniques:

Python

Using Python scripts in the past, I have brought in data from various sources, enriched and transformed it and then stored it in a MySQL database. I have used Python scripts to provide solutions at customer sites, as well as in the Smarter Choices project as a precursor to the Java Spring Boot solution.

Powershell

Using Powershell, I wrote a script that retrieves data from a database, then does multiple checks and enrichments on the data and then stores CSV files in an Azure Blob Storage.

Microsoft Power Platform DataFlows

Using Microsoft's dataflows, I enriched the aforementioned CSV files with data from other data sources, then processed it into a star model for reporting in Power Bi.

SQL Service Integration Services

I had to work with SSIS during my training as a BI - engineer. I have experience with it, but not yet in the field.

Azure Data Factory

Azure Data Factory I applied during internships in the BI - engineer training. I have experience with it, but not yet in the field.

Java

With a Java Spring Boot application, it is also possible to fabricate an ETL tooling. I am currently using this as a solution within the Slimmer-Kiezen project. It retrieves data from different APIs and websites through Scraping, after which these data are combined and processed in a database. Using AI, complex texts are provided with a simple summary.

For processing data in a data source, I have experience with the following techniques:

SQL/MySQL

During training had to solve complex cases in SQL frequently. In my opinion, SQL is the backbone of a good data analyst and I apply it very often. I often use SQL and/or MySQL as a data source and always fall back on it when checking/manually retrieving data.

NEO4J (GRAPH)

NEO4J was used in a study of the best data source for Smarter Choices. The study involved automations and the use of Cypher.

In the future, I would like to do more with the Azure Platform and work with Azure Synapse Analytics. Would like to further explore the possibilities of Data processing in the cloud.

Slimmer - Kiezen

Slimmer-Kiezen is a handy tool that gives visitors the chance to vote like a full-fledged member of parliament. This is achieved by offering the same documents used in the House of Representatives, which can then be voted on. Users can even select their own files through a Filter function, so that they only receive relevant information. In addition, the dashboard provides insight into the voting behavior of different political parties relative to each other and/or specific political issues/files. Using a database, documents can be easily searched and analyzed on their own initiative. The project consists of a solid back-end application (Spring boot) that retrieves all votes from the web and APIs, as well as a user-friendly website (Javascript) that users interact with. So, whether you want to experience what it feels like to be a real member of the House of Representatives or just want to get a little more insight into the political landscape, Slimmer-Kiezen is for you!

Slimmer-Kiezen was in eerste instantie en project dat is ontstaan tijdens de Minor Data Driven Business Lab op het Fontys Hogescholen IT & Business. Het idee is ontstaan door de toenemende onvrede van de burgers over de politiek, de achterblijvende of complexe transparantie en het geven van openheid in zaken. Met Slimmer-Kiezen moesten gebruikers in staat gesteld worden te stemmen zoals de kamerleden dat in de tweede kamer doen, waarna het stemgedrag vergeleken wordt met die van de partijen.

Slimmer-Kiezen was initially and project that originated during the Data Driven Business Lab Minor at the Fontys Colleges IT & Business. The idea came about because of the growing public dissatisfaction with politics, the lagging or complex transparency and disclosure. With Slimmer-Kiezen, users were to be enabled to vote as the members of parliament do in the second chamber, after which their voting behavior is compared to that of the parties.

First, work was done to set up a mechanism for bringing in the data from the second room, stretching it where necessary and storing it in a database. This was initially carried out using Python scripts. Because the Opendata portal was not operational at the time, it was necessary to resort to WebScraping. At that time, all information was extracted from various websites and processed in a MySQL database.

When setting up the scripts, the setup was used as shown below. 2 scripts were created for document retrieval and vote and result retrieval. The scripts ran on a Linux server and were started according to and fixed schedule.

After the back-end was operational, we also created a front-end using HTML, CSS, Javascript and PHP. This led to the creation of Slimmer-Kiezen.nl, a website that is still under development. We had interviews with various media, including the Eindhovens Dagblad, and articles were published in the Algemeen Dagblad and other news websites. During the March 2021 elections, many visitors used Slimmer-Kiezen.

Slimmer-Kiezen completely revamped

In the fall of 2022, Slimmer-Kiezen took on a new life as a hobby project. First of all, it investigated how data could be brought in more efficiently. This is because the disadvantage of Web scraping is that Web sites change, after which the entire script no longer works. Research showed that the Opendata portal was operational again. Having chosen a new setup with Java Springboot, data is now retrieved from the Opendata portal and verified against website data. The application is hosted in a Docker environment, with a breakdown between acceptance and production.

In addition to the back-end, the front-end has also been redesigned. User feedback showed that the GUI was too complex, so it was completely redesigned. In addition, the OpenAI chat API has been integrated to simplify and summarize the complex texts from the parliamentary documents. The front-end also includes a dashboard and database in which various elements of parties in the second chamber can be analyzed.

With the new base and new elections coming up earlier than usual, Slimmer-Kiezen was once again widely used. Visitor numbers were higher than in the 2021 elections.

Slimmer - Kiezen

Slimmer - Kiezen is een handige tool waarmee bezoekers de kans krijgen om te stemmen als een volwaardig kamerlid. Dit wordt bereikt door dezelfde documenten aan te bieden die ook in de Tweede Kamer worden gebruikt, waarop vervolgens gestemd kan worden. Gebruikers kunnen zelfs hun eigen dossiers selecteren via een Filter-functie, zodat ze alleen relevante informatie krijgen. Bovendien biedt het dashboard inzicht in het stemgedrag van verschillende politieke partijen ten opzichte van elkaar en/of specifieke politieke onderwerpen/dossiers. Met behulp van een databank kunnen documenten eenvoudig worden gezocht en op eigen initiatief geanalyseerd. Het project bestaat uit een solide back-end applicatie (Spring boot) die alle stemmen ophaalt van het web en API's, evenals een gebruiksvriendelijke website (Javascript) waarmee gebruikers interactie hebben. Dus, of je nu wilt ervaren hoe het voelt om een echt lid van de Tweede Kamer te zijn of gewoon wat meer inzicht wilt krijgen in het politieke landschap, Slimmer - Kiezen staat voor je klaar!

In de jaren die volgde is Slimmer-Kiezen uitgegroeid tot een stemmentracker die hedendaags al bij 2 verkiezingen dienst heeft gedaan. Met vermeldingen in verschillende nieuwsartikelen een een groeiend bezoekers aantal blijft het een leuk en leerzaam hobby project. In deze sectie van mijn C.V. wil ik graag uitweiden over de opzet van het project.

Allereerst is er gewerkt aan het opzetten van een mechanisme voor het binnenhalen van de gegevens van de tweede kamer, deze te verreiken waar nodig en op te slaan in een database. Dit is in eerste instantie uitgevoerd met behulp van Python scripts. Doordat het Opendata portaal destijds nog niet operationeel was, moest uitgeweken worden naar WebScraping. Alle informatie is destijds van verschillende websites gehaald en verwerkt in een MySQL database.

Bij het opzetten van de scripts is gewerkt met de opzet zoals hieronder weergegeven. Er zijn 2 scripts gemaakt voor het ophalen van documenten en het ophalen van de stemmen en resultaten. De scripts hebben gedraaid op een Linux server en zijn volgens en vast schema gestart.

Nadat de back-end operationeel was, hebben we ook een front-end gemaakt met behulp van HTML, CSS, Javascript en PHP. Dit leidde tot de creatie van Slimmer-Kiezen.nl, een website die nog steeds in ontwikkeling is. We hebben interviews gehad met verschillende media, waaronder het Eindhovens Dagblad, en artikelen zijn gepubliceerd in het Algemeen Dagblad en andere nieuwswebsites. Tijdens de verkiezingen in maart 2021 waren er veel bezoekers die gebruik maakten van Slimmer-Kiezen.

Vernieuwing in opzet

In het najaar van 2022 heeft Slimmer-Kiezen een nieuw leven gekregen als een hobbyproject. Allereerst is onderzocht hoe gegevens efficienter binnengehaald konden worden. Het nadeel van webscraping is namelijk dat websites veranderen, waarna het gehele script niet meer werkt. Uit onderzoek bleek dat het Opendata portaal weer operationeel was. Na gekozen te hebben voor een nieuwe opzet met Java Springboot worden gegevens nu opgehaald uit het Opendata portaal en geverifieerd aan de hand van de gegevens van websites. De applicatie wordt gehost in een Docker omgeving, waarbij een onderverdeling is gemaakt tussen acceptatie en productie.

Naast de back-end is ook de front-end voorzien van een nieuw design. Uit gebruikers feedback kwam naar voren dat de GUI te complex was, hierdoor is deze helemaal omgegooid naar het huidige ontwerp. Daarnaast is de OpenAI chat API geintegreerd voor het simplificeren en samenvatten van de complexe teksten uit de kamerstukken. Ook bevat de front-end een dashboard en databank waarin verschillende elementen van partijen in de tweede kamer geanalyseerd kunnen worden.

Met de nieuwe basis en de nieuwe verkiezingen die eerder dan normaal voor de deur stonden is Slimmer-Kiezen wederom veelvoudig gebruikt. De bezoekersaantallen lagen hoger dan bij de verkiezingen in 2021.

Nick du Chatinier

Development - Data - Integration - Optimization - Business Intelligence

EXPERIENCE

ilionx

Fulltime since March 2020

Rabobank

Posted Oct 2021 - present

Slimmer - Kiezen

https://www.slimmer-kiezen.nl

Define - Function

Creative Endeavors

Trespa

Graduation Feb 2021 - Jul 2021

ilionx

Internship Sep 2019 - Jan 2020

Edutel B.V.

Helpdesk Oct 2015 - Dec 2018

Versatile DevOps Engineer Excels in Analytics

Business Intelligence

Development

Data Engineering

Slimmer - Kiezen

Project Management

Contact me.