Project Experience Summary

Customer Period Tools
Engie 08/2019 – now Azure PAAS, Azure Data Factory, Azure Databricks, Power BI
Baloise 01/2019 – 07/2019 SQL 2017, SSIS, SSRS
Infront 12/2018 – 12/2018 Power BI
ILIAS 11/2018 – 12/2018 SQL 2017, SSIS, SSRS, C#
Microsoft Belux 11/2018 – 11/2018 Power BI, Azure Event Hub, Azure Streaming Analytics, C#
Farmad 09/2018 – 09/2018 Power BI
BASF 07/2018 – 12/2018 SQL 2016, SSIS, SSRS, MS Excel
Vandevelde 05/2018 – 06/2018 Power BI
Delta Light 02/2018 – 10/2018 SQL 2016, SSIS, SSAS, SSRS
Agentschap Natuur en Bos 07/2016 – 12/2016 SQL 2014, SSIS, SSRS, MS Excel, MS Access
Instituut voor Natuur en Bos 03/2016 – now SQL 2016, SSIS, SSRS, Power BI
Boss Paints 01/2016 – 02/2016 SQL 2008R2, SQL 2014, SSIS, SSRS
Keppel Seghers 11/2015 – 01/2016 SQL 2016, SSIS, .NET
Puratos 10/2015 – 01/2016 SQL 2012, SSIS, SSRS
Agentschap voor Geografische Informatie Vlaanderen 01/2015 – 06/2016 SQL 2012, SSIS, SSAS (Tabular), SSRS
Microsoft Belux 11/2014 – 01/2015 SQL 2016, MS Excel
Crosspoints Solutions 09/2014 – 10/2014 SQL 2012, SSIS, SSRS

Project Experience Details

Engie - August 2019 - now

  1. Tools: Azure PAAS, Azure Data Factory, Azure Databricks, Power BI
  2. Project Description

Developing a datastore for historical maintenance of data and improving the existing DWH using the Datastore as a main source keeping an aspect of separation an load principles between different Navision Sources. After the data was loaded we created PowerBI reports for business.

Baloise - January 2019 - August 2019

  1. Tools: SQL 2017, SQL Server Integration Services, SQL Reporting Services
  2. Project Description

Did multiple intern projects at Baloise. One was creating an ETL tool that extracts, transforms and loads Excel data to a PDF format. The transformed, validated and separated PDF file is used to load into Baloise's Customer Portal and link to the correct customer. On top of this project, Glenn build a reporting portal that manages the flow for the ETL so that Baloise personnel can executes runs themselves through the reporting portal.

INFRONT - December 2018

  1. Tools: PowerBI
  2. Project Description

Extracted data from Microsoft Dynamics 365 into Power BI. Created a report for Infront Management to track and filter the timesheets of their personnel.

ILIAS - November 2018 – December 2018

  1. Tools: SQL 2017, SQL Server Integration Services, SQL Reporting Services, C#
  2. Project Description

Work together with ILIAS to create a Reporting Framework for their reports. This also included programming in C# libraries and using Integration Services to move data from their Oracle database to an SQL 2017 database.

MICROSOFT BELUX - November 2018

  1. Tools: PowerBI, Azure Event Hub, Azure Stream Analytics, C#
  2. Project Description

For the new Nimbuz boot at Microsoft Glenn created a real-time data report. Integrating Azure Event Hub and Azure Stream Analytics with Power BI to create a real-time IOT sensor dashboard. He coded in C# to transfer data from IOT sensor to Azure.

FARMAD - September 2018

  1. Tools: PowerBI
  2. Project Description

Created a Power BI report that will be used on a convention as one of the primary pillars for selling the FARMAD software to clients. The Power BI had to meet the standards for best-practies in Power BI design as well as include all the newest technology available at September 2018.

BASF - July 2018 - December 2018

  1. Tools: SQL 2016, SQL Server Integration Services, SQL Reporting Services
  2. Project Description

Created an ETL tool that imports and transforms Excel data in SQL 2016 and then loads it back to Excel. The transformed, validated and aggregated excel file is used to load into Avisor, BASF’s billing software. The tool is used by BASF to make quotations for their contractors. On top of this project, Glenn build a reporting portal that manages the flow for the ETL so that BASF personnel can executes runs themselves through the reporting portal.

VANDEVELDE - May 2018 – June 2018

  1. Tools: PowerBI
  2. Project Description

Created a PowerBI report for the Digital department. This included data cleaning and transforming in PowerBI. Combined data from multiple sources and display the numbers visually. Making a comparison between ordered and invoiced data on a one page design. Worked with bookmarks and synced slicers for a fluent report.

DELTA LIGHT - February 2018 – October 2018

  1. Tools: SQL Server Integration Services, SQL Analysis Services Tabular and Multidimensional, SQL Reporting Services, DAX, MDX
  2. Project Description

Design & set-up of a new Data Warehouse solution on SQL Server 2016 and migration an existing Data Warehouse from multidimensional to Tabular. Also including a DataStore to track changes and keep history

Analysis, Design & Development SSIS procedures for the new Cube.
Analysis, Design & Development of the Tabular cube.
Analysis & Development of reports using SSRS and Excel on SSAS Tabular

ANB (AGENTSCHAP NATUUR EN BOS) - July 2016 – December 2016

  1. Tools: SQL Server, Integration Services & Reporting Services, MS Access, Toad, Data Quality
  2. Project Description

Involved in creating and upgrading existing Access Database to a transactional SQL Database. Glenn had to create and develop the transactional database as well as the ETL to get the old unstructured data into the newly designed SQL database.

INBO (INSTITUUT VOOR NATUUR EN BOS) - March 2016 – Now

  1. Tools: SQL Server 2016, Integration Services & Reporting Services, PowerBI
  2. Project Description

First few months Glenn was involved in creating the PowerBI reporting for existing Datawarehouses. The reports were used by business users as well as technical users.

Next Glenn was asked to create Datawarehouses from existing transactional databases. While doing this he learned to work closely with the business and create a DWH that meets business and technical demands but is also performant, following the best practices and according to the new standards. While doing this Glenn learned all kind of techniques like JSON, Rest API, Indexes, Temporal tables, …

BOSS PAINTS - January 2016 – February 2016

  1. Tools: SQL Server, Integration Services & Reporting Services
  2. Project Description

Involved in a SQL Server migration project, from version 2008R2 to 2014. His responsibility is to migrate the SSIS packages & validate the reports.

KEPPEL SEGHERS - November 2015 – January 2016

  1. Tools: SQL Server, Integration Services, Excel, .NET Development
  2. Project Description

Keppel Seghers needed a solution to load various filetypes into their database. Loading needed to be done on an ad hoc and daily basis. In this case we are talking about large data volumes, so performance was a top priority. Also reporting on these large datasets was important.

Glenn was part of the project team that installed a datawarehouse on SQL Server to perform mass data loads and process them in a self-made ETL tool. The purpose is to run reports in Excel.

PURATOS - October 2015 – January 2016

  1. Tools: SQL Server, Integration Services, Reporting Services, Excel
  2. Project Description

Involved in a BI project and prepares the data with MS SQL Server Integration Services to build reports.

He has also a first line support role in case of issues regarding the SQL environment.

AGIV (AGENTSCHAP VOOR GEOGRAFISCHE INFORMATIE VLAANDEREN) - January 2015 – June 2016

  1. Tools: Excel 2013, SQL Server 2012, Integration Services, Analysis Services Tabular, DAX, Reporting Services, T-SQL, XML
  2. Project Description

Involved in several MS BI projects at AGIV for the development of ETL flows, OLAP models and reports using the Microsoft BI stack.

  1. DWH KLIP: this is a new SQL Server 2012 data warehouse for reporting on all public requests regarding piping or telecom related road works in Flanders. The DWH captures all requests logged in the KLIP application to enable historic and current analysis on request status’ etc… Report development with Excel and SSRS.
  2. CRAB (Centraal Referentie Adressen Bestand): CRAB is a spatial database that contains all adresses and relevant sub-information to these adresses for the Flanders region. An ETL flow is developed using SSIS and T-SQL to maintain and track all changes made to CRAB.
  3. SSAS Tabular project GIPOD: The GIPOD SQL DWH captures all logging info of service requests regarding road works, street closing requests for carnavals etc… There is a daily delta load of about 100.000 records using SSIS, Excel 2013 and SSRS are used to develop reports on top of the Tabular SSAS model.

MICROSOFT BELUX - November 2014 – January 2015

  1. Tools: Excel 2013, Office 365 Power BI (Power Pivot, Power View, Power Query)
  2. Project Description

In order to facilitate the software asset management (SAM) audits of Microsoft, Microsoft wanted to invest in an Excel / Power BI based toolset to import the output of the SAM toolkit into Excel, modelling this data in Power BI to enable a comparable analysis with the listed Microsoft products in the different customer contracts.

CROSSPOINT SOLUTIONS - September 2014 – October 2014

  1. Tools: SQL Server 2012, Reporting Services, Integration Services, T-SQL
  2. Project Description

Extracting data from the Microsoft Dynamics CRM system and developing SSRS based reports and dashboards for sales follow-up.