Peter De Graaf Email & Phone Number

Amsterdam Area

At ING worked as a developer/scrum master working on a dynamic ETL implementation to feed the QRM risk application. The main components for the ETL application were a file loader, database statement generator and processor. After setting up the mapping in the database the file could be loaded independent of the format in the file, only pre-condition was that it needs to be either a xml/excel/textbased input file. File loader : C# based load application that worked on a low level loading algorithm for text based files with loading speeds similar to SSIS.DataSPA: T-Sql / SSIS application for mapping ETL from input data from multiple source systems to our consumer QRMDataSAP GUI: ASP.Net Core MVC application for maintaining ETL mappings and monitoring ETL progress.Q3 : C# WPF DSL for unlocking the QRM API to business analysts and make automation of their daily work possible.

Sandviken, Sweden

Contracted as a business intelligence architect with strong focus on the Microsoft SQL Server platform. Current assignment includes database tasks such as dimensional modeling, T-SQL programming, ETL development using Integration Services, XML with XSD validation in C#, creating xml form source data and more. The goal for the project was to implement a forecasting system, from Logility called Voyager. During the project my responsiblilities frequently to accomodate the project's needs. First implemting the DataWareHouse and optimizing loading data into it, later working with a business process manager to specify and realize the ETL process into the planning tool.Specialties:Databases / BI / Microsoft SQL Server- Integration Services - Reporting Services - Database engine / Transact SQL

For the Dutch Belastingdienst responsible for developing a wide range of data conversion tools in SSIS and .Net. The assignment for the BD was to migrate the data of the Dutch population from 4 systems into a newly developed system (NTS). This system would become responsible for validating and granting healthcare / childcare / rental aid. To accommodate this we build SSIS components with .Net assemblies with helper functionality. Our software existed of 3 main parts, loading and validation of data, Automated and manual data correction and finally exporting to the NTS.Loading and validation are build in SSIS 2005 and later migrated to 2008. This part extracted data from text files and after validation inserted into a database. Also cross reference checks about family composition and income statements are included in this part. All data that is not valid is exported to text files for further processing.In the data correction software automated checks with SSIS components are implemented and beside this a website with manual correction options was also implentented. This website was build with ASP.NET, C#, Nhibernate with an underlaying MVP architecture.The last part of the application was implemented in C# and was responsible for creating XML-messages and offering them to the NTS. This was done by using a generic function to validate XML-messages against the one offered by the NTS bizztalk service bus. Besides this validating design documents and estimating development time where also a important part of my role.C#, VB.Net, ASP.NET, SSIS, TFS VS2005, VS2010, NHibernate, UML, RUP, MVP.

Apeldoorn Area, Netherlands

SSIS project for Belastingdienst as described at CAP-Gemini.

The Hague Area, Netherlands

NetEconomy is owner and developer of Erase. Erase is a software application that assesses the risk of financial transactions. Bases for this assessment is an library of rules stored in an SQL-server database. This risk-assessment is mandatory for all financial institutions since the terrorist attacks on New-York. My main responsibilities we're bug fixing and implementing new functionality. C#, VB.Net, ASP.Net, XML.

Tele2 Video Solutions is a supplier of Digital Television in the Netherlands. For this department responsible for development and maintenance of some tools. An xml parser tool alongside the XSLT transformation of XML data is responsible for the provision of media files to the IPTV middle-ware.A publisher tool that translates xml-data about media into manageable categories and media descriptions. This data would than be presented in the Video On Demand functionality.In a team building a user interface prototype to demonstrate the capabilities of the Tele2 set-top box. The main goal for this development was to prove that the current hardware could in-fact preform better, due to optimized code. Beside development also helped to set-up a new standard for documentation, and specified requirements for new development.

This project was for development of an Portal for administration of Digital Paper users. With “Anoto”-technology users could fill-in a document which would be analysed and send to a central server. Via our portal this documents where digitally stored and could be accessed to be processed further. The Portal was build in Macromedia Flex, realized in the Cairngorm framework. This is an Flex framework somewhat like MVC. Back-end services are realized in VB.Net.Beside development i've been 6 weeks to India to instruct our Offshore colleagues in Macromedia Flex. After 2 weeks of giving Flex course we helped them 4 weeks to startup.

Amersfoort

Multiple projects with .Net Compactframework. 1. CBR, building application for PDA to assist drivers licence exterminators during the driving exam.2. Healthcare application to support Home care nurses, Mobile Care Assistant . This application is for registration of given care, and planning of their workday. The back end application for this PDA application was developed using Java.Multiple Web applications realized with ASP.Net.1. EvBoxx, this application supports shareholders with voting on shareholders meetings. If an shareholder would not be able to attend to a meeting his vote could be transferred to a proxy, whom represents his point of view. Application was developed together with an Offshore partner in VB.Net.2. Pro-rail, dutch rail infrastructure manager. With our application Pro-rail could plan maintenance of the rail infrastructure. This application would create and manage all permits and work instructions needed. The application was realized in a 3 layer web application.3. Nuon ÉSS is the department of NUON that supplies heating or cooling to companies and buys back the energy that is created. To give customers insight in their costs and profit we developed a 4 tier web application. A service layer, to accommodate proprietary development, and a web-layer to give default functionality. Both using BL and DL to get their data.A Maintenance project where we worked with ASL to get a uniform customer experience. After implementation of ASL cost of maintenance decreased and customer satisfaction got better. Personally responsible for 3 MS Access applications for KPN and an internal Project management application (VB6 / VB.Net). VB.NET, VB6, MS SQL server DTS, MS Access 2.0 / 97 / 2000

Amersfoort

Multiple .Net projects1. Siemens NV, for 2 years as consultant worked for siemens, developing VB 6 and .Net applications. Also specified and supported the developement of a new product to plan the realisation of SDH implementations.2. Siemens & NS GSM-R vof, as consultant realized a planning tool to plan and manage the implementation of GSM-R network. With this tool realisation time decreased from 26 weeks to 21. Multiple VB6 and MS Access projects1. SNT- conferencing services, this call-center company needed a interview application. So in a team developed a question-driven application that guided the employee trough the interview. This is a MS Access 97 application with a SQL-server 2000 back end.2. For KPN reverse engineered a call-center application that planned call's to former customers to offer them new phone-contracts. Also business logic was implemented to select the customers that would give the highest ROI. Most important preqiusit for this application was that it should be developed MS-access 2.0, with a interface to an mainframe data-service and a SQL server 6.5 database.3. Stichting Aboma, Design and program an application for registration of vehicles in the Netherlands. Besides this design and implement tests to prove program compliance with customer requirements.

Havo

It