Jörg Trappschuh - Database Expert and Software Developer

Recommended expert

Lampertheim, Germany

Experience

Dec 2024 - Jul 2025

8 months

Database Expert and Software Developer

Public Sector

There is no documentation for the legacy software and the original developers are not available. The data needs to be prepared for a new system. A long transition phase must be ensured.
Creating the database relationship diagram
Developing a service for file exchange
Preparing the structures for new requirements
Updating the old building authority application in Delphi
Securing documents in the DMS
Ensuring parallel operation through data exchange using ETL processes
C#, Visual Studio 2022, Git, Delphi, MS SQL 2022, T-SQL, DataGrip

Oct 2024 - Jun 2025

9 months

Software Architect, Software Developer and Database Developer

Healthcare

The goal is to enable automated billing for hospitals. Rules from the EBM catalog are prepared to be automatically billed with data sets from the hospital information system (KIS). Users should be able to set and adjust rules themselves.
Building the architecture
Creating the rule engine
Importing and exporting data with Excel
Connecting data with Dedalus
Building the UI prototype
Integrating different sources using ETL processes
Testing with Visual Studio and NUnit
C#, Visual Studio 2022, NUnit, Git, Excel, MariaDB, DataGrip, Docker, PowerShell, Windows

Jun 2024 - Oct 2024

5 months

Software Developer and Database Developer

Logistics

Extending the application for recording promotional items - Europe-wide
Extending the UI for new modules
Extending the database
Coordination with stakeholders, self-organized work
C#, .NET Core, WPF, MVC, Visual Studio 2022, Git, MS SQL 2022, T-SQL, Azure, Entity Framework

Feb 2024 - Jul 2024

6 months

Software Developer and Database Developer

Industry

Distributing machine parameter data and firmware across Europe through a web interface
Gathering requirements from stakeholders
Analyzing the current state and creating a concept
Developing the selection interface
Replicating data to local databases
Performance optimization, normalization of database tables
.NET Core, WPF, Visual Studio 2022, Git, MS SQL, T-SQL, Windows 10, Azure

Jan 2024 - Sep 2024

9 months

Heidelberg, Germany

Lecturer for Databases and Software Engineering

SRH Private University

Introduction to databases, SQL, normalization, procedures and functions in databases
Conducting client meetings, methodologies, change management, communication issues
MariaDB, HeidiDB

Sep 2023 - Jan 2024

5 months

Software Developer

Mechanical Engineering

Retrofit of legacy systems in the medical technology sector
Adjusting the resolution of the HMI
Integrating new hardware components
Creating a service to monitor the database server
TCP/IP communication between HMI and service
Unit tests with built-in Visual Studio tools
vb.net, C#, WinForm 3.5 & 5, Visual Studio 2005, 2008, 2012, SVN, VisiWin 6.5, VMware with Windows XP, Win7, Win10, MS SQL Express

Aug 2022 - Sep 2023

1 year 2 months

Mannheim, Germany

Product Owner – SaaS Development

MeQuEn GmbH

Software solution for accrediting meeting participants and voting software for various end customers
Requirements analysis, working with the client to develop a target vision
Creating use cases
Acting as the interface to stakeholders and development
Considering cryptographic methods, including BSI standard TR 02102-1 and Common Criteria (CC)
Assisting in defining interfaces and documenting using Swagger/OpenAPI for an API-first approach
Testing and commissioning the solution in the cloud
Swagger, MariaDB, GitHub, Kubernetes, Docker

Feb 2022 - Sep 2022

8 months

Frankenthal, Germany

Software Developer and Database Developer

KSB

Controlling a nameplate embossing machine using SAP data and simulating the system
Preparing customer requirements and monitoring compliance
Analyzing data for plausibility
Creating a digital twin for hardware simulation
Displaying a preview of the nameplates
Tests with built-in Visual Studio tools
Transferring data to the embossing machine
C# 4.7.2, WinForms, Visual Studio 2019, Git, MS SQL Express, Windows 10

Oct 2021 - Mar 2022

6 months

Database Expert

BELECTRIC

Implementing a clustered database solution based on MariaDB
Analyzing requirements
Creating and running installation scripts
Testing and commissioning the solution
Documenting the solution
Administering the solution right after rollout
MariaDB, MaxScale, Git, Docker, Windows

Mar 2021 - Dec 2023

2 years 10 months

Software Architect, Software Developer and Database Expert

Phoenix-Contact

Developing a new project management tool for the energy industry to plan and manage power plants and large-scale projects, replacing an object-oriented database.
Requirements analysis, working with the client to develop a target vision
Defining the architecture with stakeholders
Developing the data persistence layer
Providing custom interfaces for end customers
Creating a digital twin
Simulating 10,000 devices for mass data processing
Developing tools to simulate the hardware
Planning and creating tests with built-in VS tools
Technical documentation, internal support, Scrum coordination with stakeholders, self-organized work
C# 4.8.2, vb.Net, WPF, Visual Studio 2019, .NET, WebServer, REST, Blazor, JSON, GitHub, Polarion, Windows 10, Linux, MariaDB, PostgreSQL, Docker, PowerShell

Oct 2020 - Feb 2021

5 months

Software Developer

Mode

Supported a data migration from Navision to SAP. Created data exporters.
Worked on tickets from Jira
C# 4.7.2, Angular, Blazor, Console, Visual Studio 2019, Git, Jira, Confluence, MS SQL 2016, TSQL, SSRS, Windows 10

Sep 2020 - Jan 2021

5 months

IoT Consultant, Software Architect, Database Developer

SPAIIS

Supported a software vendor on a research project. Machine data was interpreted by AI and saved in a database.
Set up software architecture for big data processing
Designed the database
Planned and implemented machine data integration via REST interfaces
Planned and developed tests using Visual Studio, unit testing
Created a plant simulation
C# 4.7.2, Rest#, WinForms, ReSharper, Visual Studio 2017, Java, Linux, MQTT, REST, Swagger, JSON, HubSpot, Git, SourceTree, MariaDB, PostgreSQL, Windows 10, Linux, Docker, Kubernetes

Aug 2019 - Feb 2021

1 year 7 months

Cologne, Germany

Software Developer and Consultant

City of Cologne

The goal was to develop a system where decision makers can set system administration requirements without needing an administrator to intervene.
Developed a solution with all stakeholders
Gathered requirements from internal stakeholders and monitored compliance
Planned and implemented migration SQL scripts
Built a console application for processing bulk requests
Created an Excel form to generate CSV files
Planned and developed tests using Visual Studio
Technical documentation, coordination with stakeholders, self-organized work
C# 4.7.2, VB.NET, WinForms, ReSharper, Visual Studio 2017, XML, Git, SourceTree, MS SQL 2016, MS SQL 2010, TSQL, SSIS, PostgreSQL, Excel 2016, VBA, VB6, PowerShell, Windows 10, EcoNet

May 2019 - Jul 2020

1 year 3 months

Frankfurt, Germany

Data Analyst

Frankfurt Public Prosecutor's Office

Assisted in health care billing fraud investigations
Analyzed datasets according to guidelines
Prepared an investigation report
Optimized Excel templates
Provided online files from the associations of statutory health insurance physicians
Imported billing data from the associations of statutory health insurance physicians
Migrated data from Oracle to MS SQL
Jira, Confluence, Oracle 12, Excel 2016, VBA, Windows 10

May 2019 - Jun 2019

2 months

Karlsruhe, Germany

Software Developer

CAS

Extended a WPF component to display and edit various input files
Developed components using WPF
Wrote black-box tests using Visual Studio 2017
C# 4.7.2, WPF, Visual Studio 2017, Git, SourceTree, Windows 10

Mar 2019 - Mar 2020

1 year 1 month

Germany

Consultant, Software Architect, and Development Engineer

Wöhr

Developing a concept to connect the globally distributed plants in the IIoT area
Creating the software design, including security concepts with microservices
Coordinating the project participants
Building client prototypes in WPF
Analyzing legacy data
Writing a service to import legacy messages into the new system
Testing with Visual Studio and NUnit
C# 4.7.2, WinForms, Blazor, ReSharper, Visual Studio 2017, Git, SourceTree, MS SQL 2016, MariaDB, REST, Swagger, Docker, Windows 10, Siemens, Beckhoff, EVON-Router

Jun 2018 - Mar 2019

10 months

Stuttgart, Germany

Software Architect and Development Engineer

Bosch

Developing add-on modules for assembly software that is used at 50 sites worldwide. The software is part of a shop floor system in an MES environment.
Debugging the software
Enhancing an administration tool and the electronic shift log
Connecting to REST interfaces
Developing components in WinForms and distributing them via NuGet packages
Unit testing the REST interfaces
Extending web interfaces with .NET Core
Working with ClearCase
C# 4.7.2, WinForms, WCF, RestSharp, .NET Core 2.0, Visual Studio 2017, IIS, TFS 2017, Git, SourceTree, MS SQL 2016, Oracle 12.0, REST, Swagger, Windows 10

Feb 2018 - May 2018

4 months

Bonn, Germany

Software Developer and Database Developer

brown IPOSS

Analyzing geodata in the mobile sector
Adapting ASN.1 converters to the customers' system landscape
Data analysis for sector swapping of base stations
Analyzing SwissQual data
C#, Visual Studio 2017, MS SQL 2016, Windows 10

Dec 2017 - Mar 2018

4 months

Stuttgart, Germany

Software Expert, Coach

GVS

Supporting the rollout of software in the gas and electricity billing area
Vulnerability analysis
Introducing SignalR
Extending web interfaces with .NET Core
Testing with Visual Studio and NUnit
WPF, VB.NET, .NET 4.5, .NET Core 2.0, ASP.NET, SignalR, JavaScript, Visual Studio 2017, IIS, Oracle 12.1, Oracle SQL Developer 3.1, Windows 10

Nov 2016 - Nov 2017

1 year 1 month

Vlotho, Germany

Database, Backend, MES Expert

Kannegiesser

Standardizing production databases and system interfaces in the MES environment
Database analysis and supporting project management
Creating and implementing database concepts, including replication
Building ETL processes
Testing the concepts during commissioning
Designing interfaces for master data
Developing services in C#
Adapting machine-level software in VB6
Creating a digital twin for hardware simulation
MS SQL 2012, Visual Studio 2015, C# .NET 4.5, VB6, VBA, Angular, GIT, Redmine, SourceTree, Windows

Jun 2016 - Sep 2016

4 months

Augsburg, Germany

Database and MES expert

Osram

Database analysis in the MES environment to reduce downtime
Writing a monitoring tool for shop floor monitoring
Creating and implementing database and communication concepts
Software development in C#
Designing and running automated and manual tests
MS SQL 2008 R2 replication and setup of ETL processes
C#, MVC, VB6, Visual Studio 2010, MS SQL 2008 R2, TFS 15, Tortoise SVN, XML

Oct 2015 - Apr 2016

7 months

Göppingen, Germany

Software architect

Siemens

Extending the help system for a major customer
Creating a fallback system for help calls
Adding multilingual support for views with WPF
Migrating export-import conventions for a new release with MS SQL 2012
Designing ergonomic maintenance software to manage help entry points
Coordinating the team members involved
Developing automated and manual tests
Writing SQL scripts for the migration
C# 4.5, Visual Studio 2012, WPF, MVC, WinForms, Infragistics, TFS 15, MS SQL 2012, PostgreSQL, XQuery, PowerShell, Scrum

Nov 2014 - Dec 2015

1 year 2 months

Software architect and development engineer

BorgWarner Turbo Systems

Developing a rights system for 12 sites worldwide and over 1000 assembly stations
Building the workflow for an ergonomic interface
Planning the architecture and delivering the rights system
Developing a validation concept for migrating legacy data
Introducing documentation with DocToHelp
Setting up a ticketing system with OTRS
Testing with Visual Studio
VB.NET, VBA, ASP.NET, MS SQL 2012, DocToHelp, Visual Studio 2010, TFS

Feb 2014 - Oct 2014

9 months

Steinen, Germany

Software architect

Innojet

Restructuring and visualizing plants for the pharmaceutical and food industries
Replacing VisiWin components with C# components
Visualizing actions in the plant
Planning the architecture and adapting the software
Commissioning at the customer site
C# 4.0, OPC Server INAT for S7, MS SQL 2005, MS Excel 2010, Visual Studio 2010, VisiWinNet 6.5

Nov 2013 - Dec 2013

2 months

SQL database developer

Insurance

Migrating data from MS SQL 2005 to MS SQL 2008 for 300 million records
Optimizing processing speed
MS SQL 2005, MS SQL 2008 R2, MS SQL Management Studio

Jun 2013 - Nov 2013

6 months

Software Developer / Subproject Lead

Airbus

Migration of a management software for cabin fit-out design plans
Planning and execution of the workflow
Writing specifications and architecture
Database migration from FireBird to MS SQL 2008
Integration with Active Directory and permission management
SAP R3 – RFC integration
Delphi 5, Delphi XE2, FireBird, MS SQL 2008, DOORS, working according to Scrum

Mar 2013 - May 2013

3 months

Software Developer

Automation Industry

Planning and implementation of a content management system for the engineering department
Planning and implementation of software tools for GMP5 support
Support in building the internal class library
C#, VS 2008, Windows 7, XML, OPC / S7, MS SQL 2005

Oct 2009 - Dec 2012

3 years 3 months

Frankenthal, Germany

Software Developer

Rosebrock Software

Implementation of the central base packages for tax consultant software
Planning the new architecture with ModelMaker
Performance optimization for calculation modules and SQL queries
Conducting automated tests in Delphi
Maintenance of non-tax-related software modules (trade tax, payroll tax, etc.)
Interface support and second-level support
Coaching new employees and support staff
Delphi XE, C# .net 3.5, ADS, ModelMaker 11, Subversion, Windows 7, Vista, XP, XML / XSL

Dec 2007 - Sep 2009

1 year 10 months

Dossenheim, Germany

Software Developer / IT Project Lead

Symestic GmbH

Project work in the field of industrial controls and MES
IT project management for wood-processing plants and automotive suppliers
Planning and development of Windows services for controlling industrial equipment
Development and standardization of services for data exchange between PLCs and databases via OPC
Setup of a system for JIT / JIS production including database development
Coaching employees on the DataBridge product
VS 2005 .net 2.0, C#, VB.net, MS-SQL 2005, OPC, TFS, SharePoint 2005, IIS, Profinet, Ethernet/IP, S7

Jan 2006 - Nov 2007

1 year 11 months

Worms, Germany

Project Engineer / Project Lead

VSK Technik Kübler GmbH

Project management in the industrial sector for software product planning and development
Control of industrial equipment with image processing and sensor integration
Task-based sensor evaluation, remote maintenance, and data acquisition
Renewal of PC software for calendering machines and tool management
Extension of the HMI for hardening machines and process value archiving
Software maintenance of packaging lines in the pharmaceutical industry (FDA-compliant)
Setup of a label inspection station and conversion of print files
Delphi 7.0, Windows XP, MS-SQL 2005, Softing / INAT OPC, Profinet, Ethernet/IP

Feb 2005 - Jun 2005

5 months

Munich, Germany

Consultant Professional Services

ATOSS Software AG

Consulting and support in work time management and staff scheduling
Configuring the software solution and commissioning terminals
Presales support
Windows, AS/400, MS-SQL, Oracle, DB400, XML

Dec 1996 - Dec 2004

8 years 1 month

Eschborn, Germany

Consultant / Leadership and Coaching

LogicaCMG GmbH & Co.KG

Leading and coaching 40 developers at 3 locations
Implementing custom client/server software solutions
UI ergonomics specialist and trainer for PowerBuilder class libraries
Developing a customer reporting system for Deutsche Bank (C++, UML, Linux)
Developing technical know-how and managing projects for BlackBerry handhelds
Evaluating new development environments (J2EE, .net) for foreign trade finance products
Creating a quality assurance tool for the Hesse State Welfare Association
Building an invoicing system with SAP-FI interface for Axel Springer Publishing House
Creating standard software for asset management at SER (SunGuard)
Developing a sales system for Woelm AG
MS-Project, OOA / OOD / OOP, PowerBuilder 5.0 – 7.0, Oracle, MS-SQL, ClearCase, XML, C++, Java, J2EE