Rene van Kooten
Data Warehouse Architect at MUFG Bank (Europe) N.V.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Dutch -
-
English -
Topline Score
Bio
Credentials
-
Querying Data with Transact-SQL (70-761)
MicrosoftJul, 2019- Nov, 2024
Experience
-
MUFG Bank (Europe) N.V.
-
Netherlands
-
Banking
-
1 - 100 Employee
-
Data Warehouse Architect
-
Oct 2021 - Present
MUFG Bank Europe designed and developed a table-based historical data layer as a starting point to service the information provisioning both internal and external. Activities: 1. Design and presentation Enterprise Data Warehouse Architecture 2. Setup Enterprise Data Warehouse Principles & Guidelines 3. Exploration, identification and classification of the nature of source data 4. Knowledge sharing sessions with team members 5. Member of scrum team, participating in scrum ceremonies 6. Exploring functionalities of Snowflake 7. Analysis of TOGAF (The Open Group Architecture Framework) 8. Analysis of implementation of Microsoft Master Data Services 9. Prototype dimensional modeled Enterprise Data Warehouse 9.1. Data Warehouse methodology applied: Dimensional Modeling by Ralph Kimball 9.2. Design BUS Matrix and derived Star (Data) Models 9.3. Implementation Data Reconciliation 9.4. Implementation Concept of Transaction Dimensions 9.5. Technology stack: Microsoft SQL Server, SSIS 9.6. Design and development Control & Logging functionality 9.7. Design and development Building Blocks 9.8. Design and implementation of Retention Based Processing method 9.9. Design and implementation processing solution to convert data from historical data layer into “Type 2” format by efficient process 9.10. Design and development Load Process “Landing Zone —> Core Zone” by SQL stored procedures 9.11. Design and development Load Process “Core Zone —> Dimensions” by SQL stored procedures 9.12. Design and development Load Process “Core Zone —> First Level Facts” by SQL stored procedures
-
-
-
Data Management Operations
-
Badhoevedorp, North Holland, Netherlands
-
Company Owner
-
Oct 2021 - Present
Contact information: E-mail: rvankooten@datamanagementoperations.nl Expertise on Architecture, Design and Build of solutions regarding Data Management functional areas: Data Warehousing & Business Intelligence, Reference & Master Data management, Data Quality Management, Metadata Management, Data Development, Data Governance, Data Architecture Management Contact information: E-mail: rvankooten@datamanagementoperations.nl Expertise on Architecture, Design and Build of solutions regarding Data Management functional areas: Data Warehousing & Business Intelligence, Reference & Master Data management, Data Quality Management, Metadata Management, Data Development, Data Governance, Data Architecture Management
-
-
-
Red Data
-
Netherlands
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Business Intelligence Consultant
-
Jun 2019 - Sep 2021
René has expertise regarding Data Management functional areas: Data Warehousing & Business Intelligence, Reference & Master Data management, Data Quality Management, Metadata Management, Data Development, Data Governance, Data Architecture Management For Red Data consultancy and detachment activities are performed at customer organizations René has expertise regarding Data Management functional areas: Data Warehousing & Business Intelligence, Reference & Master Data management, Data Quality Management, Metadata Management, Data Development, Data Governance, Data Architecture Management For Red Data consultancy and detachment activities are performed at customer organizations
-
-
-
Smallsteps kinderopvang
-
Netherlands
-
Individual and Family Services
-
300 - 400 Employee
-
Data Architect
-
Dec 2020 - Aug 2021
As a first initiative for a Master Data Management solution Smallsteps has implemented a subset of a generic data model based on Len Silverston's "The Data Model Resource Book" and using Microsoft Master Data Services (MDS) to maintain the data. In response to experiences with this first initiative for a Master Data Management solution chosen is to design and to develop a new more robust Master Data Management solution to maintain and to manage the data less cumbersome and time consuming. Activities: 1. The design, build and implementation of a dynamic configured ADF Pipeline solution to extract data collections from data sources to the new Master Data Management solution 2. The design, build and implementation of an Automated Test Solution to integral test the technical and functional working of the DAL stored procedures automatically. 939 testscenarios are now part of the solution 3. The design, build and implementation of a new Master Data Management solution (MDM2.0). Starting point is the data reality of the source data. The physical data model of the new Master Data Management solution, implemented on a Microsoft Azure SQL database, contains parts of a generic data model (Party Management) and organisation specific entity types like CostCenter and Service. A Data Access Layer (DAL) existing of 89 stored procedures has been built to maintain and to manage the Reference and Master Data by executing SQL scripts 4. To maintain and to manage the Reference and Master Data stored in Microsoft Data Services. Instead of using Excel a number of SQL scripts has been developed, which adds data to the MDS "Leaf" tables and which executes MDS stored procedures to process the data stored in these "Leaf" tables into the MDS target tables
-
-
-
Rabobank
-
Netherlands
-
Banking
-
700 & Above Employee
-
Software Engineer Data Warehouse
-
Jul 2019 - Oct 2020
Activities: 1. The design and implementation of a new solution to accept data from a database table based instead of a file based data distribution solution 2. The design and development of a historical data layer (HDL) based on the tables of the Landing Zone of two Data Warehouse solutions (LICWID en SAFE) 3. The design and development of a Landing Zone for two Data Warehouse solutions (LICWID en SAFE) Server migration two Data Warehouse solutions (LICWID en SAFE) 4. Server migration two Data Warehouse solutions (LICWID en SAFE)
-
-
-
HypoCasso
-
Amersfoort
-
Senior Datawarehouse Specialist
-
Jan 2018 - May 2019
Hypocasso is an independent serviceprovider regarding arrears management. René worked on the following projects and delivered the following products: • Project BI Modernization (preparation phase). Objective is to migrate current Data Warehouse from SQL Server to Hadoop o Point of contact for external parties o Data Modeling & Design (Dimensional Modeling) data source independent Hypocasso Information Model o Define Template formats o Design and realisation data supply conform defined Template formats • Design and realisation Data Reconciliation solution • Project Decommissioning OnGuard Data Warehouse o Reverse Engineering OnGuard Data Warehouse ETL solution and Report Scripts o Design and realisation of the dimensional modeled reportlayer • Performed Datawarehouse Assessment Hypocasso Data Warehouse (HCDWH): check current Data Warehouse solution with a set of vendor platform and tooling independent quality criterion for Enterprise Data Warehouses • Project Europese Privacy Verordening (EPV) / General Data Protection Regulation (GDPR)) o Making appointments setup procedures regarding the anonymization of privacy sensitive attributes throughout the Development, Test and Acceptance environments • Upgrading Disk I/O Hypocasso Data Warehouse in cooperation with Stater IAAS • Resizing Storage Capacity Hypocasso Data Warehouse • Performed QuickScan Tallyman Datavault: Data Modeling & Design dimensional datamodel in BUS Matrix format Tools / Applications / Methodologies: SQL Server 2014, SSIS, Metadata Management, Reference & Master Data Management, Data Quality Management, Agile, SCRUM, Data Vault 2.0
-
-
-
OceanBI
-
Netherlands
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior BI Consultant / Chief Technical Officer
-
Jan 2014 - May 2019
Ocean BI is a Dutch consultancy organization specialized in Business Intelligence, Data Warehousing and Data Warehouse Automation, Data Integration, Data Migration, Metadata Management, Master Data and Reference Data Management, Data Quality and Data Modeling.As CTO at Ocean BI I am responsible for the design of the DDM Studio Datawarehouse Automation Tool and I coordinate the design and development team of DDM Studio.Achievements and activities as CTO:- Formalized activities in Data Warehouse building process into DDM Studio Work method- Co-Architect, Designer and Developer of DDM Studio- Design and development DDM Studio metadata repository- Design and development metadata fed automated generic ETL process for Dimensions, First Level Facts and Second Level Facts (Aggregated Facts, KPI Facts, Combined Transaction Facts, Report Datasets en Export Datasets)- Design and development automated test solution to test the functionalities of a Dimensional Modeled Datawarehouse- Design and development metadata fed automated generic ETL process for Datavault 1.0 (both Natural Key and Surrogate Key options), including test scripts to test the functionalities of a Datavault Modeled Historical Datalayer- Technical Documentation related DDM Studio engine- Coordinating development activities DDM Studio Web User InterfaceAchievements and activities as Business Intelligence Consultant:- Being a coach and sparring partner on the mentioned focus areas for other Business Intelligence employees (internal and external) at customer's site- Giving presentations DDM Studio- Giving classes DDM Studio- Writing articles related to the mentioned focus areasToolset, Techniques and Methodologies:- Microsoft SQL Server 2005, 2008, 2008R2, 2012, 2014 and 2016- T-SQL, Integration Services, Reporting Services and Analysis Services- Systems Analysis, Data Analysis and Data Modeling- Scrum- Agile- Dimensional Modeling, Datavault (1.0, 2.0) and Anchor Modeling
-
-
Chief Technical Officer
-
Jan 2014 - Dec 2017
* CTO- Setup Design of DDM Studio 500- Development of the Metadata Driven execution of the ETL process- Development of the Data Access Layer- Implementation Visual Studio Team Services- Coordination Development Team (3 members)- Coordination Test Team (3 members)- Train colleagues in Master & Reference Data Management, Data Quality Management, Data Warehousing (Information Vault, Dimensional Modeling)* Development DDM Studio 5001. Implementation EnterpriseRun - Setup EnterpriseRun before actual processing - Dependency Tree as starting point to process the DataObjects (SAD, Dimension, Fact) - ETL Process Optimizer - EnterpriseRunMonitor2. Implementation EnterpriseRunTactics - Async processing with OLE Automation - Async processing with SQL Server Agent - Sync processing per DataObjectType (SAD, Dimension, Fact) - Disable Async processing with SSIS3. Implementation EnterpriseRunExecutionScenario - Integrated Information Vault and Dimensional Modeling - Only Information Vault - Dimensional Modeling from Information Vault; this option is also used in case of a Reload of the Dimensional Modeled Data Warehouse from Information Vault4. User Interface - Role Manager functionality to support a variety of area of authorization types - SAD . Redesign of the Grid containing the collection of SADs . Implementation of Action Menus; content based on the properties of individual SAD - BUS Matrix . Implementation of Semantic Data Mart Layer to service the needs having the names of attributes of Dimensions and Facts in different language or in different vocabulaire used by the Business . Implementation of Generic Bus Matrix Entity Type to service a quick start of the development of the Data Warehouse - Enhanced Business Contact Management - Enhanced Business Data Management5. Setup design and building new Demo Data Warehouse (datasource AdventureWorks)
-
-
-
ENTSO-E
-
Belgium
-
Utilities
-
100 - 200 Employee
-
Data Management Consultant
-
May 2015 - Mar 2017
* Migration of Building Block solutions - Data migration from IT Infrastructure former Hosting Provider to IT Infrastructure current Hosting Provider * ENTSO-E TP Vision / Developer, Coach - Solution which Transforms and Loads Data - provided by 50+ data providers by more than one communication channel - into Report database - Provided Foundation and Guideliness (setup database / Physical Data Model, system design and stored procedures) to build solution * Data Management Training (4 participants) / Coach - Dimensional Modeling High Lights (BUS Matrix, Star Diagrams, Data Marts) - SSIS - DDM Studio 401 * ENTSO-E Awareness Systems (EAS) / Teamleader, Coach - CSV File processing solution --> CSV files with flexible number of columns and in random order - Design BUS Matrix and Star Diagram - Build Data Warehouse Data Objects with DDM Studio 401 * Statistical Reporting / Analyst - Analysis Phase * CHILON (Master & Reference Data solution) / Analyst, Data Modeler, Designer - Setup Physical Data Model
-
-
-
GroupM
-
United States
-
Advertising Services
-
700 & Above Employee
-
Data Warehouse Consultant
-
May 2015 - Feb 2016
Analysis & Design Dimensional Modeled Enterprise Data Warehouse Implement Information Vault Methodology Build Data Warehouse Data Objects with DDM Studio 401 Analysis & Design Dimensional Modeled Enterprise Data Warehouse Implement Information Vault Methodology Build Data Warehouse Data Objects with DDM Studio 401
-
-
-
Priox
-
Netherlands
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Warehouse Analyst
-
Aug 2015 - Aug 2015
BI Assessment Priox BI Module BI Assessment Priox BI Module
-
-
-
IKNL (Integraal Kankercentrum Nederland)
-
Netherlands
-
Hospitals and Health Care
-
300 - 400 Employee
-
Etl Specialist
-
Apr 2015 - Jun 2015
IKNL Data Warehouse Bevolkingsonderzoek: 1. Processing iBob data 2. Advice Data Warehouse Maintenance 3. Support ETL Design and Maintenance IKNL Data Warehouse Bevolkingsonderzoek: 1. Processing iBob data 2. Advice Data Warehouse Maintenance 3. Support ETL Design and Maintenance
-
-
-
HEYDAY Facility Management
-
Netherlands
-
Facilities Services
-
400 - 500 Employee
-
Data Warehouse Architect
-
Mar 2015 - Mar 2015
Migration DDM Studio 331 to DDM Studio 344 Migration DDM Studio 331 to DDM Studio 344
-
-
-
FCA BANK
-
Italy
-
Financial Services
-
400 - 500 Employee
-
Data Warehouse Analyst
-
Feb 2015 - Mar 2015
BI Assessment RDC Application BI Assessment RDC Application
-
-
-
ENTSO-E
-
Belgium
-
Utilities
-
100 - 200 Employee
-
Designer and Advisor Market Model BI Solution
-
Oct 2014 - Feb 2015
ENTSO-E collects Market Model data from 41 data providers. These data providers provide the Market Model data by Excel files. A solution has been designed:- To upload and process these Excel files- To extract data from these Excel files- To put the extracted Excel data in an Open Interface Format (which is a requirement to provide data by other file types than Excel)- To upload and process files of the Open Interface Format- To extract data from these Open Interface Format files- To match / validate the extracted data against Master and Reference data- To store the extracted data in a central (dimensionally modelled) data storeAnother party is building the solution. OceanBI gives advice and performs additional analysis in the building of this ETL solution.
-
-
Designer Master Data Portal and Teamleader
-
Jul 2014 - Oct 2014
For a Proof of Concept a Master Data Portal is developed. Activities performed / products delivered:- Leader of the Design Team- System Design- Physical Data Model Design and implementation on SQL Server 2014- Stored Procedures built on SQL Server 2014- Importing Excel files, CSV files and XML files- Monitoring building process User Interface- Producing analysis document containing areas of improvement to realize in follow-up project. These areas relate to Master Data Portal and Import functionalities
-
-
-
Onderlinge 's-Gravenhage
-
Netherlands
-
Insurance
-
100 - 200 Employee
-
Datawarehouse Designer
-
Jun 2014 - Jun 2014
Onderlinge 's Gravenhage is a Dutch insurance company. Onderlinge 's Gravenhage wishes to improve the fulfillment of their information needs. By performing a Datawarehouse Quick Scan information is collected about the subjects, which occur in the business processes and a Bus Matrix (based on the Dimensional Modeling Methodology) is designed. Achievements and activities: - Held interviews with Onderlinge 's Gravenhage Business Analyst and Database Administrator - Produced document containing the results of the performed analysis Toolset, Techniques and Methodologies: - Data Analysis and Data Modeling - Dimensional Modeling
-
-
-
ABN AMRO Bank N.V.
-
Netherlands
-
Banking
-
700 & Above Employee
-
Business Intelligence Consultant
-
May 2014 - May 2014
Ocean BI markets the Datawarehouse Automation tool DDM Studio. To make use of the latest improvements and new functionalities customers migrate to the latest version. ABN AMRO Hypotheken Groep migrated from DDM Studio 311 to DDM Studio 342. Achievements and activities: - Building Migration Scripts - Executing Migration Scripts Toolset, Techniques and Methodologies: - Microsoft SQL Server 2012 - T-SQL Ocean BI markets the Datawarehouse Automation tool DDM Studio. To make use of the latest improvements and new functionalities customers migrate to the latest version. ABN AMRO Hypotheken Groep migrated from DDM Studio 311 to DDM Studio 342. Achievements and activities: - Building Migration Scripts - Executing Migration Scripts Toolset, Techniques and Methodologies: - Microsoft SQL Server 2012 - T-SQL
-
-
-
IKNL (Integraal Kankercentrum Nederland)
-
Netherlands
-
Hospitals and Health Care
-
300 - 400 Employee
-
Data Analyst and Data Profiler
-
Apr 2014 - Apr 2014
IKNL is a Dutch company, which collects cancer related research results. The execution of the business processes is supported by an ERP system. Before one can build a Datawarehouse on data in source systems having insight in the underlying data model and the content is required. Analysis activities have been performed to get more insight in the underlying data model of the ERP system and the content of the tables in the database. Achievements and activities: - Held interviews with Functional Application Manager - Analyzed ERP system's data model and the content of the tables in the database Toolset, Techniques and Methodologies: - Data Analysis and Data Profiling
-
-
-
PwC
-
Professional Services
-
700 & Above Employee
-
Business Intelligence Consultant
-
Apr 2014 - Apr 2014
Ocean BI markets the Datawarehouse Automation tool DDM Studio. To make use of the latest improvements and new functionalities customers migrate to the latest version. PwC migrated from DDM Studio 250 to DDM Studio 341. Achievements and activities: - Building Migration Scripts - Executing Migration Scripts Toolset, Techniques and Methodologies: - Microsoft SQL Server 2008R2 - T-SQL Ocean BI markets the Datawarehouse Automation tool DDM Studio. To make use of the latest improvements and new functionalities customers migrate to the latest version. PwC migrated from DDM Studio 250 to DDM Studio 341. Achievements and activities: - Building Migration Scripts - Executing Migration Scripts Toolset, Techniques and Methodologies: - Microsoft SQL Server 2008R2 - T-SQL
-
-
-
DSB Bank
-
Netherlands
-
Banking
-
1 - 100 Employee
-
DBA / Business Intelligence Consultant
-
Jun 2011 - Mar 2014
Since October 19th, 2009 DSB bank is in a process of bankruptcy. A number of curators has been assigned to manage the process of bankruptcy. To support this process people are needed, also on the IT department. A sub department is the team Data Management & Business Intelligence. This team performs activities regarding Database Administrating, Data Integration, Data Quality and Business Intelligence. Achievements and activities: - Design and build report layer on the database of a transactional Work Flow Management System (Pallas), which supported the business process of the department Complain Management - Design and build report layer on the database of a transactional Work Flow Management System (Anago), which supported the business process of the department Complain Management - Building reports with SQL Server Reporting Services - Fulfill ad/hoc information requests - Daily check of the execution of SQL Server Agent Jobs and perform corrective activities - Documenting Reportlayer Solution Toolset, Techniques and Methodologies: - Microsoft SQL Server 2005 + 2012 - T-SQL, Integration Services and Reporting Services - Dimensional Modeling - Datavault
-
-
-
KVL
-
Netherlands
-
Information Technology & Services
-
1 - 100 Employee
-
Senior BI Consultant
-
May 2007 - Dec 2013
KVL Inspiratie Technologie is a Dutch consultancy organization specialized in Business Intelligence, Data Warehousing, Data Integration and Data Quality. After working for Cordaan Thuiszorg for nineteen years KVL Inspiratie Technologie offered me the possibility to work on projects related to Datawarehouses, Data Integration and Business Intelligence. Achievements and activities: - Being a coach and sparring partner on the mentioned focus areas for other Business Intelligence Consultants and Business Intelligence employees at customer's site - Giving presentations DDM Studio - Giving courses DDM Studio - Writing articles related to the mentioned focus areas Toolset, Techniques and Methodologies: - Microsoft SQL Server 2005, 2008, 2008R2 and 2012 - T-SQL, Integration Services, Reporting Services and Analysis Services - Systems Analysis, Data Analysis and Data Modeling - Scrum - Agile - Dimensional Modeling, Datavault and Anchor Modeling
-
-
-
HDI Global SE
-
Germany
-
Insurance
-
700 & Above Employee
-
Datawarehouse Architect, Designer and Teamleader
-
May 2013 - May 2013
HDI-Gerling is a Dutch insurance company. HDI-Gerling wishes to improve the fulfillment of their information needs by building a Datawarehouse with a Datawarehouse Automation Tool. In a Proof of Concept (PoC) it has been proven that within a limited timeframe a Datawarehouse based on provided source data could be built with DDM Studio. Achievements and activities: - Analysis of the source data - Designed BUS Matrix - Coordinated the development activities Toolset, Techniques and Methodologies: - Data Analysis and Data Modeling - Dimensional Modeling - DDM Studio - SQL Server 2008R2
-
-
-
Bank of Scotland
-
United Kingdom
-
Banking
-
700 & Above Employee
-
SQL Programmer
-
Mar 2011 - Mar 2011
Bank of Scotland had outsourced the maintenance of a development environment. This outsourcement was turned back. Between the production environment and the development environment a number of differences existed in the design of the databases. These differences had to be eliminated. SQL Compare of RedGate is used to analyze these differences. To eliminate these differences was a prerequisite to build a new interface between BoS Netherlands and Bos UK. At the same time a study to build the interface was performed. I have supported the designer of this interface solution. Achievements and activities: - Analysis of the differences between production and development environment - Equalized the development environment with the production environment - Giving support to interface designer Toolset, Techniques and Methodologies: - SQL Server 2005 - SQL Compare of Redgate - TortoiseSVN
-
-
-
Stichting Bibliotheek.nl
-
Libraries
-
1 - 100 Employee
-
Datawarehouse Analyst, Datawarehouse Designer and Builder
-
Jul 2009 - Mar 2011
An objective the Ministry of Education, Culture and Science wants to achieve in 2012 is a digital infrastructure for libraries, where data coming from operational OLTP systems and other (external) data sources are transformed into one homogeneous data source: the Digital Library Service. One component of this service is a National Datawarehouse. Achievements and activities: - Data source analysis - Performing Data Profiling activities - Design and build ETL process based on Flat Files Template Formats - Being sparring partner for Datawarehouse Architect - Coaching Datawarehouse Builders - Documenting Datawarehouse Solution Toolset, Techniques and Methodologies: - Dimensional Modeling - DDM Studio version 2 - SQL Server 2008 - T-SQL and SISS
-
-
-
IBN
-
Netherlands
-
Civic and Social Organizations
-
400 - 500 Employee
-
Datawarehouse Analyst
-
Dec 2010 - Dec 2010
IBN has implemented an ERP system to support the business processes. After the implementation of the ERP system a Datawarehouse based on this ERP system has been built. IBN wanted to check this Datawarehouse by a Datawarehouse professional of another organization. Two assessments had to be performed: - One assessment with the perspective ‘Fit for Best Practice’ - One assessment with the perspective ‘Fit for Future’ I have performed the assessment with the perspective ‘Fit for Future’. The attention was on the following items: - Database setup (MS SQL2008) - System capacity - ETL process - Data model (Facts and Dimensions) Achievements and activities: - Analysis of the components of the Datawarehouse - Tested these components on quality criteria Controllability, Maintainability, Learnability, Transferability, Extensibility, Traceability and Scalability - Tested the Datawarehouse on criteria of the Dimensional Modeling Methodology - Written document containing the findings and advice Toolset, Techniques and Methodologies: - Dimensional Modeling
-
-
-
PwC
-
Professional Services
-
700 & Above Employee
-
Business Intelligence Consultant
-
Oct 2009 - Dec 2010
PwC had built a Datawarehouse (Metis1) based on data in their transactional systems. This Datawarehouse solution was tested on criteria like Controllability, Maintainability and Extensibility. The outcome of these tests resulted in building a new Datawarehouse (Metis2) using the Datawarehouse Automation Tool DDM Studio. In this phase (from October 2009 until February 2010) I advised the Datawarehouse Architect of PwC. When the Datawarehouse had been built, then the Datawarehouse Architect left the organization in February 2010. From February/March 2010 until December 2010 I have been hired by PwC to assist the implementation of the new Datawarehouse and to assist the members of PwC's BI Team. The advice to improve the quality of the new Datawarehouse to meet criteria like Controllability, Maintainability, Learnability, Transferability, Extensibility, Traceability and Scalability was honored. Achievements and activities: - Redesigned the Transform and Load solution - Training and Coaching members of the BI Team - Give advice to IT Management Team related to Datawarehouses and Business Intelligence - Documenting Datawarehouse Solution Toolset, Techniques and Methodologies: - Dimensional Modeling - DDM Studio version 2 - SQL Server 2008 - T-SQL, SISS, SSAS and SSRS
-
-
-
Openbaar Ministerie
-
Netherlands
-
Law Enforcement
-
700 & Above Employee
-
Data Profiler
-
Apr 2009 - Apr 2009
Openbaar Ministerie in Rotterdam wanted to have more insight in the Data Quality of the data stored in the legacy system before migrating these data to a new system. By using IBM Information Analyzer the data stored in the Oracle database of the legacy system has been profiled. Achievements and activities: - Performing Data Profiling activities - Report about the findings Toolset, Techniques and Methodologies: - IBM Information Analyzer Openbaar Ministerie in Rotterdam wanted to have more insight in the Data Quality of the data stored in the legacy system before migrating these data to a new system. By using IBM Information Analyzer the data stored in the Oracle database of the legacy system has been profiled. Achievements and activities: - Performing Data Profiling activities - Report about the findings Toolset, Techniques and Methodologies: - IBM Information Analyzer
-
-
-
KBM Affilips group
-
Netherlands
-
Mining
-
1 - 100 Employee
-
Datawarehouse Designer
-
Mar 2009 - Mar 2009
KBM Affilips is a global supplier of Master Alloys. KBM Affilips wanted to improve the support of the information needs. By performing a Datawarehouse Quick Scan information is collected about the subjects, which occur in the business processes and a Bus Matrix (based on the Dimensional Modeling Methodology) is designed. Achievements and activities: - Held interviews with KBM Affilips Head of Finance and Business Analyst - Produced document containing the results of the performed analysis Toolset, Techniques and Methodologies: - Data Analysis and Data Modeling - Dimensional Modeling
-
-
-
Quion
-
Financial Services
-
300 - 400 Employee
-
Datawarehouse Builder
-
Mar 2009 - Mar 2009
Quion is a Finance company, which provides administration services to mortgage providers. In a Proof of Concept (PoC) it has been proven that within a limited timeframe a Datawarehouse based on a new to be implemented system could be built with DDM Studio. Achievements and activities: - Building Extraction solutions with SSIS - Building dimensions and facts by storing metadata into the DDM Studio Repository. Toolset, Techniques and Methodologies: - Microsoft SQL Server 2005 - T-SQL and Integration Services - DDM Studio version 1 - Dimensional Modeling
-
-
-
People Partners
-
Rotterdam Area, Netherlands
-
Datawarehouse Builder
-
Mar 2009 - Mar 2009
People Partners was a Software company, which marketed HR systems. In a Proof of Concept (PoC) it has been proven that within a limited timeframe a Datawarehouse based on People Partners' HR system could be built with DDM Studio. Achievements and activities: - Building Extraction solutions with SSIS - Building dimensions and facts by entering metadata into the DDM Studio Repository Toolset, Techniques and Methodologies: - Microsoft SQL Server 2005 - T-SQL and Integration Services - DDM Studio version 1 - Dimensional Modeling
-
-
-
Time Inc. International Fulfilment Services
-
Netherlands
-
Book and Periodical Publishing
-
1 - 100 Employee
-
Interface Designer and Interface Developer
-
May 2007 - Feb 2009
TW4 stores the data of its customers and subscriptions in mainframe systems. TW4 uses a number of (scan) systems to process the data changes of all customers outside the US with high speed. Before this data is stored in the mainframe systems it has to be transformed to a format the mainframe systems can handle. The solution which performed this transformation had to be replaced by a solution built with SQL Server Integration Services (SSIS) 2005. The name Opus had been given to this solution. Achievements and activities: - Designing and building the interface solution with SSIS 2005 - Documenting the interface solution - Given advice to improve business processes - Given advice to improve Master Data Management Toolset, Techniques and Methodologies: - Microsoft SQL Server 2005, 2008 - T-SQL and Integration Services - Data Analysis and Data Modeling - Scrum - Agile
-
-
-
LeasePlan
-
Netherlands
-
Financial Services
-
700 & Above Employee
-
Datawarehouse Builder and Team leader
-
Jul 2008 - Sep 2008
Leaseplan is an international car lease company. Leaseplan wished to improve the fulfillment of their information needs by building a Datawarehouse with a Datawarehouse Automation Tool. In a Proof of Concept (PoC) - Project Next Shift - it has been proven that within a limited timeframe a Datawarehouse based on provided source data (Excel files) could be built with DDM Studio. But only when data was successfully extracted from these Excel files. The data from these Excel files were extracted with DataDefractor. This data extraction was however not always successful caused by differences in style between versions of Excel files. Achievements and activities: - Analysis of the source data - Designed BUS Matrix - Coordinated the development activities Toolset, Techniques and Methodologies: - Data Analysis and Data Modeling - Dimensional Modeling - DataDefractor - DDM Studio version 1 - SQL Server 2005
-
-
-
SDF Tuinbouwautomatisering BV
-
IJsselstein
-
Datawarehouse Designer
-
Jun 2008 - Jun 2008
SDF Tuinbouwautomatisering builds software for the horticultural industry. With this software all growth stadia of plants can be monitored. A customer of SDF Tuinbouwautomatisering had additional requirements related to the support of the business processes and the information needs. By performing a Datawarehouse Quick Scan information is collected about the subjects, which occur in the business processes and a Bus Matrix (based on the Dimensional Modeling Methodology) is designed. Achievements and activities: - Held interviews with SDF's Functional Application Manager and System Designer - Produced document containing the results of the performed analysis Toolset, Techniques and Methodologies: - Data Analysis and Data Modeling - Dimensional Modeling
-
-
-
DSB Bank
-
Netherlands
-
Banking
-
1 - 100 Employee
-
Datawarehouse Builder
-
Nov 2007 - Jan 2008
DSB Bank applied Six Sigma quality checks to its business processes. Regarding the process of applications for credits DSB Bank defined a number of milestones. DSB Bank wanted to have insights in the volume and progress of the credit applications. Within six weeks’ time a Data Warehouse consisting of 6 facts has been built with DDM Studio. Two of these facts contained the Six Sigma Key Performance Indicators. Achievements and activities: - Analyzing Data Sources - Analyzing SQL scripts containing Six Sigma Key Performance Indicators built by DSB Bank (which have been substituted by the Data Warehouse) - Designed and built a solution which automated the execution of SQL scripts (by using CURSOR functionality of T-SQL) as part of the ETL process. Toolset, Techniques and Methodologies: - Microsoft SQL Server 2005 - T-SQL and Integration Services - DDM Studio version 1 - Dimensional Modeling
-
-
-
Cordaan Thuiszorg
-
Amsterdam Area, Netherlands
-
Systems analyst, Programmer, AO/IC, Senior Functional Application management, System Administrator
-
Apr 1988 - Apr 2007
* The First BI Solution In a period of 19 years I have fulfilled six disciplines in IT and Financial Control at a large homecare organization in Amsterdam. My first programmer task was to build an HR report based on the registration of sickness notices. Data Quality issues of all kinds were encountered during this project :-)! With thanks to the HR manager these data quality issues were finally managed at the source: the HR system which supported the business process of the registration of sickness notices. * The Second BI Solution As a System Administrator in 1989 I setted up a new maintenance organization. Also I improved / redesigned the report processes, which resulted in a reduction of the time to produce the Annual reports with 75% (2 weeks instead of 8 weeks). * Management Information Systems / Data Warehouse / Agile In 1991 I became a System Analyst / Programmer. From 1991 until 1999 I have designed and built a number of Transactional Systems and a number of Management Information Systems and Data Warehouses. The method I applied was prototyping: building systems together with business users. In my opinion this is agile :-)! * Administrative Organization and Internal Control After having designed, built and implemented a Dimensionally Modeled Datawarehouse in the first half of 1999, I joined the Financial Control department. The reason for the switch was that I got the opportunity to analyze business processes from another perspective. * Data Warehouse Implementation In 2003 I switched back to IT as a Senior Functional Application Manager. In this discipline I was part of the team, that was responsible for the implementation of an enterprise wide Data Warehouse (2006-2007). After this implementation for me it was time to focus 100% on Data Warehousing.
-
-
Education
-
1988 - 1993
EXIN
AMBI, Informatica -
1987 - 1988
ECABO
Applicatie Programmeur COBOL, Computer Programming -
1978 - 1984
Pius X Lyceum Amsterdam
HAVO, Economics -
2012 - 2012
Kimball University
Dimensional Modeling in Depth -
2011 - 2011
Human Difference
Open Commercial Training -
2010 - 2010
Kimball University
Microsoft Data Warehouse in Depth -
2009 - 2009
InfoSupport
.NET for Architects and Project Managers -
2008 - 2008
InfoSupport
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services 2793 -
2008 - 2008
InfoSupport
Technical Specialist Performance Point Server 2007 -
2007 - 2007
InfoSupport
Designing a Reporting Solution Architecture using SQL Server 2005 2797A -
2007 - 2007
InfoSupport
Designing an OLAP Solution Architecture using SQL Server 2005 2796A -
2007 - 2007
InfoSupport
Implementing and Maintaining Microsoft SQL Server 2005 Integration Services 2792 -
2007 - 2007
InfoSupport
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services 2791 -
2006 - 2006
Infor
MPC Budgeting -
2006 - 2006
Infor
Decision -
2005 - 2005
Schuijt Opleidingen
Customer Direct Correspondence -
2004 - 2004
DBS
Business Objects Designer -
2004 - 2004
Tot Z
ITIL Foundation -
2003 - 2003
DBS
Business Objects Supervisor -
2002 - 2002
DBS
Business Objects Full-End User -
2002 - 2002
Xploit
Microsoft SQL Server – Analysis server 2000 -
2002 - 2002
Xploit
Microsoft SQL Server 2000 -
2001 - 2001
Cognos
Cognos PowerPlay -
1999 - 1999
OS Solutions International
Showme/400 -
1996 - 1996
Excellent Commerciële trainingen
Excellent Negotiation -
1994 - 1994
Silvac
RPG/400 -
1994 - 1994
Silvac
Database Implementation/400 -
1992 - 1992
Silvac
System Administrator AS/400 -
1992 - 1992
Silvac
Query/400 -
1991 - 1991
Advanced Computing Management (ACM)
Xbase programming -
1991 - 1991
RAET
Network / System Administrator Novell -
1991 - 1991
RAET
Focus
Community
