Erwin is available for hire
Hire ErwinErwin van Avendonk
Verified Expert in Engineering
Software Developer
Eersel, Netherlands
Toptal member since June 18, 2020
Bio
Erwin is a software developer with more than 20 years of experience and more than 15 years of experience in T-SQL development. He has worked over the past 15 years on an ERP system developed in a company owned together with a business partner. Erwin also completed several BI-related consultancy assignments at large companies in the Netherlands.
Portfolio
Applify BV
XSLT, XML, VBScript, VB, C#, SQL Server Integration Services (SSIS)...
Dela
SQL Server Integration Services (SSIS), T-SQL (Transact-SQL)
ROC de Leijgraaf
SharePoint, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL)
Experience
- T-SQL (Transact-SQL) - 15 years
- Database Modeling - 15 years
- VB - 15 years
- Microsoft SQL Server - 15 years
- SQL Server Reporting Services (SSRS) - 12 years
- XSLT - 10 years
- SQL Server Integration Services (SSIS) - 10 years
- C#.NET - 5 years
Availability
Part-time
Preferred Environment
VBScript, VB, XSLT, XML, C#, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL (Transact-SQL)
The most amazing...
...achievement I've had is a performance improvement of the order intake of our ERP system by a factor of 10, resulting in a throughput of 13,500 orders per hour.
Work Experience
Co-owner
2006 - PRESENT
Applify BV
- Developed various extensions and improvements to our ERP system called Flowsuite with VB/C# in combination with T-SQL.
- Created multiple implementations of our ERP system. The work Includes SQL reporting and DAT conversions on both SQL as XML level.
- Completed various SQL consultancy jobs at large companies in the Netherlands mainly focusing on reporting, datawarehousing, and T-SQL development.
- Designed and built a generic reporting portal for our ERP system. Used T-SQL views and stored procedures to prepare the data. Used SSRS for the reports and C# for the GUI. The user can create one filter and apply it to multiple reports.
- Converted SAP data to AX in a three-week project. Used SSIS to import the SAP data into the staging database and T-SQL views to map data to the AX import format.
- Aligned a data model of the reporting tool and updated the import scripts (T-SQL).
- Developed ETL tools for various banks worldwide to comply with the new standards for risk management from the ECB.
- Improved the performance of the ERP system's order intake by a factor of 10. This was achieved by converting the Visual Basic code to stored procedures that parse XML files and create the orders directly in the database.
- Improved the performance of a management information system processing thousands of orders per day. Improved the way the application was dealing with the database using the SQL Server Profiler and clear trace.
- Designed and built a self-service portal for customers of proefschriftmaken.nl. Used ASP.Net Core MVC for the portal and T-SQL to read and write data to the ERP system.
Technologies: XSLT, XML, VBScript, VB, C#, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL
Senior Solution Engineer
2016 - 2019
Dela
- Designed and built a SQL database on top of their source datawarehouse, which allows them to query about facts and behavior of their customers. This database is fundamental to their predictive models.
- Built an application (DIM) based on the marketing database that allows marketing intelligence specialists to automatically target their audience very precisely. It does that by separating the decision from the content.
- Built an application to support Dela's bulk communication needs. The difference between this and the DIM is that this communication is in bulk; there is a need to throttle this to make sure that the customer support center can handle the response.
- Designed a solution to centralize out-management for DELA. The goal of DELA was to decouple the generation of output from their verticals. In the new solution, users can select events from the vertical applications and create output using templates.
Technologies: SQL Server Integration Services (SSIS), T-SQL (Transact-SQL)
BI Developer
2016 - 2016
ROC de Leijgraaf
- Built a datawarehouse based on data coming from student administration, student progress monitor systems, and centralized test results published by the government.
- Build an ETL layer which was orchestrated using SharePoint tables; this enabled their own people to maintain the ETL layer.
- Designed and build a KPI dashboard in SSRS based on the new datawarehouse.
Technologies: SharePoint, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL)
Senior BI Developer
2015 - 2016
Staatsbosbeheer
- Made an analysis of the impact on their DWH and KPI Dashboard.
- Wrote a piece of advice to support the decision whether to use the reporting functionality from the new HRM application or to keep an independent DWH.
- Made a prototype of a new ETL layer that could load and transform the data from the new HRM system to their existing DWH.
Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL)
BI Developer
2013 - 2013
ABN Amro
- Designed and created an SSAS cube to support the month closure process of ABN Amro.
- Created an ETL layer that loads CSV files into the Datawarehouse using T-SQL and SSIS.
- Created some templates/examples in Excel (Pivot tables) to enable the business to make their own views on the SSAS cube.
Technologies: Microsoft Excel, SSAS, SQL Server Integration Services (SSIS), T-SQL (Transact-SQL)
Senior Software Engineer
1996 - 2006
Applidata
- Converted an customer specific application into an application that could be sold out of the box.
- Led a team with between three and six developers and created an application which was sold to multiple large companies in the Netherlands.
- Led multiple implementations of the software over the years.
- Planned the move of employees and equipment using our management software.
- Prepared and executed the move of equipment and employees for another client using our software. Main activities included data conversion and creating orders for IT.
- Converted information from installation companies and imported them into a management system. People used this to plan changes in their infrastructure.
- Built a new version of a marketing tool using the CD indexing software of C-Content and Visual Studio.
Technologies: Object-oriented Databases, C++, SQL
Experience
Dela Intelligence Manager
https://www.youtube.com/watch?v=PaZWjmT3cXoA SQL Server-based marketing automation tool that enables marketeers to set up, automate, and monitor their marketing campains. Dela had a goal to make their marketing and email marketing more one-to-one. To achieve this, we made an application which was fed from their datawarehouse that can select (very small audiences) and send very precise messages, import and track response, and act on the result. The solution was nominated for the Data-driven Marketing Association (DDMA) Customer Data Award in 2019.
Education
1992 - 1996
Bachelor of Information and Communication Technology Degree in Computer Science
Fontys Hogeschool - Eindhoven
Skills
Tools
SQL Management Studio, SQL Server Profiler, SSAS, Microsoft Excel, Jira
Languages
SQL, T-SQL (Transact-SQL), XSLT, VBScript, VB, XML, C#, C++, C#.NET
Storage
SQL Server 2016, SQL Server 2012, SQL Stored Procedures, SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Server Integration Services (SSIS), Database Modeling, SQL Server Analysis Services (SSAS)
Paradigms
ETL
Industry Expertise
Project Management
Platforms
SharePoint
Other
Reporting, BI Reporting, Microsoft 365, Object-oriented Databases
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring