This section contains a list of Grundsätzlich IT B.V. clients that are willing to act as reference. Further information is available upon request.
Immigratie- en Naturalisatie Dienst
During 2013 Grundsätzlich IT B.V. provided a requirements analyst and data modeller for a new attempt to build a datawarehouse. The main focus of the consultant was the design of the data model for the storage of data from the INDIGO system, and the corresponding information analysis. At the end of the year the solution was up and running. Since then, the IND has been able to report accurately on historical data, even in the light of continuous (political) change.
Key features: Power Designer, information analysis
Astellas Nederland
In 2012 Astellas, like many pharmaceutical companies, faced the challenge of complying with the EU legislation concerning the EudraVigilance Medicinal Product Dictionary (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. Grundsätzlich IT B.V. provided the Data Warehouse architect for the solution. At first it was designed as a standard DWH solution, but during the development process it ended up as an Oracle Apex solution, because this matched better with the requirements.
Key features: evMPD, information analysis, requirements analysis, global design
Vrije Universiteit Amsterdam
On the Vrije Universiteit Amsterdam a datawarehouse was built to complement the new Student Information System (NewSIS). This reporting system is the reporting system of choice for all of the reporting done on the Free University. The DWH consultant provided by Grundsätzlich IT B.V. 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 provided better insight than previous reports, had historical data for trend analysis and was up-to-date every day, without manual intervention. Total maintenance each year was 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.
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 a web application was built to support this process. The product was delivered by Grundsätzlich IT B.V. on a fixed price/fixed functionality basis.
Key features: requirements analysis, prototyping, web-based application, Visual Basic.Net, SQL Server
Mercedes-Benz Nederland
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.
ING (Card)
At ING Card (now absorbed into other branches), Grundsätzlich IT B.V. provided a BI consultant who implemented a combination of reports and ETL to support the internal processes.
Key features: financial transactions, lots of data.