Dieter Samel

From November 2021 to March 2024, I provided 100% support and extensions for the old portal system of the company GULP. MS-VB6, Oracle V11g, MS-SQL-Srv 12, HTML 5, CSS 3, Apache-Srv. were used, among others. This portal is being replaced, which is why my services are no longer needed there. The preparation for the replacement, including the necessary data interfaces and evaluations, also fell within my area of responsibility.

From October 2018 to September 2021, I had a 100% engagement at Paki (Enepetal). In this logistics company operating throughout Europe, projects for data warehousing, filling the data lake, reporting, and data transformation for the management and billing of pallet movements are realized.

Concept development takes place in a small team, and the implementation is then carried out by the team members. MS-SSMS, MS-SSRS, MS-SSIS, TSQL, Excel-Powerpivot, VBA, VB.NET were used.

A gradual conversion of the server landscape to MS-SQL-2016 and the use of new change tracking functions were part of this task. The development of complex procedures and views for the SQL server and the optimization of existing processes for runtime were another focus.

As a freelance developer, I have created a complete system (user interface, BI, backend) for planning hospital interior fittings since 1997. This is comparable to an ERP. The company HospitalTechnik in Krefeld has been using this system since 1998 and has grown into a significant provider in the industry. It has undergone re-engineering twice since then.

This product, as well as the tree protection statutes of the cities of Düsseldorf/Meerbusch, are purely in-house developments that I also market and for which I have utilized all aspects of an MS-SQL database.