Peter Kremers

Responsible for BI backend Data Engineering in various projects within the airport. I design and maintain ETL processes over a DTP street in SQL using a dbt-framework. The data warehouse is designed as a lakehouse in Azure Databricks utilizing Delta Lake technology. My work supports the realization of management reports for stakeholders within the complex Schiphol infrastructure. CI/CD automation and code sourcing take place in Azure DevOps.

#azure #databricks #synapse #dbt #sql #python #dimensional-modelling #devops #cicd #agile

Responsible for building a new Azure Data warehouse with a DTP street. This involves a solution with a custom-designed Data warehouse framework in Azure Synapse Analytics. Besides implementing the framework, I also play a significant role in setting up the Azure architecture (resources and networking). The team's working method is Agile and utilizes Sprints on an Azure DevOps board. Release management of the environment is managed via CI/CD pipelines in Azure DevOps. Additionally, I have daily contact with Lekkerland business users for alignment regarding data engineering.

#azure #infra #bicep #synapse #sql #devops #cicd #agile #powerbi #dimensional-modelling #analysis-services #powershell

Responsible for creating reports and exports for stakeholders and customers of Vebego within various projects. My responsibilities include management (including 24/7 standby), development of the data warehouse, development of ETL processes, and creation of data models and reports. The environment includes Azure Synapse Analytics, ETL via Azure Data Factory, CI/CD pipelines in Azure DevOps, and models developed within Azure Analysis Services. Reports are created in Power BI. I also have daily contact with business stakeholders to clarify the various data needs within Vebego.

#azure #infra #data-factory #sql #devops #cicd #agile #powerbi #dimensional-modelling #analysis-services #powershell

Responsible for the management and development of the on-premises data warehouse on SQL Server managed instances. This involves managing databases and ETL packages in SSIS. Reports are internally managed by Munckhof. Additionally, I serve in an advisory role for migrating the on-premises data warehouse to the cloud (Azure).

#on-prem #ms-sql-server #ssis #ssas #devops #powerbi #dimensional-modelling

Responsible for delivering daily/weekly/monthly reports and ad-hoc requests to various stakeholders within Obvion using SQL queries on the data warehouse. I am also involved in advising on and improving internal data management and automation.

#on-prem #powershell #netezza-sql #devops #powershell

Responsible for describing and visually presenting the application landscape of SRK. The need was to clarify which applications serve what purpose and what interfaces exist between those applications.

My work involves analyzing and making data about healthcare providers transparent for the entire organization and the regional municipalities, using (T-)SQL and Power BI. I participated in the cost price research for purchasing in 2021 based on financial data and key figures from healthcare providers; assisted in setting up an on-premises database for information provision for the entire organization and the regional municipalities.

#on-prem #ms-sql #excel #betty-blocks #no-code #powerbi

Responsible for collecting, analyzing, cleaning, and visualizing quantitative and qualitative data on healthcare usage in the municipality. Also responsible for integrating systems within a broad application landscape using SQL (Oracle & MS) for the implementation of analysis methods and tools. Created an interactive dashboard in Power BI as an analysis tool in collaboration with the application manager, project leader, and information manager.

#on-prem #oracle-sql #ms-sql #excel #powerbi

Setting up, developing, and maintaining a Power BI dashboard using a custom-designed SQL database with an associated ETL process to make youth care indications transparent within the municipality.

#on-prem #ms-sql #excel #powerbi

I completed an in-depth T-SQL course successfully. Additionally, I completed the "Big Data Science Professional" (BDSCP) program from Arcitura and obtained various certifications (see Credly). My final project involved plotting traffic jams on a map of the Netherlands using Python and datasets provided by NDW (National Data Portal Traffic).

Responsible for maintaining/developing the data warehouse (PostgreSQL) and ETL processes (Apache NiFi). I also presented daily/monthly/annual reports to management, contributing to discussions about KPIs. I was responsible for setting up and maintaining dashboards that provide call center management and operations with guidance for controlling and monitoring KPIs, thus meeting both internal and external information needs. The BI department worked with a Scrum/Agile methodology.

#amazon-web-services #postgresql #apache-nifi

Scheduling call center employees based on a self-developed capacity planning tool that determines how many agents are needed at what time of day to achieve KPIs such as wait time and handling time of calls; serving as a supervisor in the call center: answering legal and technical questions from colleagues and monitoring wait time and handling time of calls.