This section contains a list of Grundsätzlich IT clients that are willing to act as reference. Further information is available upon request.
Immigratie- en Naturalisatie Dienst
During 2013 I worked the entire year on the new attempt to build a datawarehouse. My main focus was the design of the data model for the historical storage (Data Vault), and the information analysis to determine what was what, as well as determining how to map the Indigo source system to the historical storage. At the end of the year the solution was up and running. The data marts were very fast and the IND was able to report accurately on historical data, even in the light of continuous change.
Key features: Power Designer, information analysis
In 2012 Astellas, like many pharmaceutical companies, faced the challenge of complying with the EU legislation concerning the evMPD. All information regarding authorized medicines distributed by Astellas was to be sent to the EU before a certain deadline, and all changes to the authorizations had to be provided afterwards within a short timeframe. At first this was designed as a DWH solution, but it ended up as an Oracle Apex solution.
Key features: information analysis, requirements analysis, global design, PowerPoint, Word
Vrije Universiteit Amsterdam
On the Vrije Universiteit Amsterdam a datawarehouse was built to complement the new Student Information System (NewSIS). This reporting system will become the reporting system of choice for all of the reporting done on the Free University. Grundsätzlich IT built most of the ETL and the process control for the ETL, as well as a lot of the datamodel for the storage area.
Key features: Layered architecture (staging, storage, reporting), Data Vault model for storage, DWH automation based on templated BODS workflows, full lineage from source to report. The source is a heavily modified SLcM module in SAP. The supervising architect was Ronald Damhof.
Nijmegen City Council
In Nijmegen a datawarehouse was built for reporting on the benefits for people that qualify for support under the WMO (Law for Society Support). This provides better insight than previous reports, has historical data for trend analysis and is up-to-date every day, without manual intervention. Total maintenance each year is several days of work.
Key features: Layered architecture (staging, storage, reporting), Data Vault model for storage, DWH automation based on PL/SQL and fully metadata-driven, data marts using OWB.
Genexis B.V. is a fast-growing company in The Netherlands that provides a large amount of the FTTH market with smart modulair FTTH-modems. To keep up with the rapid growth they needed to improve the management of their Return Material Authorization process. This also meant managing the masterdata for (potential) customers as well as the delivered products. In order to do this, requirements were analysed, a design was approved and building commenced on a web application that could do this. The system has been fully operational for more than a year without a single incident.
Key features: requirements analysis, prototyping, web-based application, Visual Basic.Net, SQL Server
Ronald Kunenborg worked at Mercedes-Benz Nederland B.V. for almost ten years and was hired several times for extending the existing business intelligence databases.
Key features: Visual C#, Oracle API-calls, parameter-binding.
At ING Card (now absorbed into other branches), Ronald Kunenborg implemented a combination of reports and ETL to support the internal processes.
Key features: financial transactions, lots of data.