Jörg Trappschuh
Database Expert and Software Developer
Experience
Database Expert and Software Developer
Public sector
- An old software has no documentation and the developers are not available. The data needs to be prepared for a new system. A long transition phase must be ensured.
- Create the database relationship diagram
- Develop a service for file exchange
- Prepare structures for new requirements
- Revise the old building authority program in Delphi
- Secure documents in the DMS
- Ensure parallel operation through data exchange via ETL processes
- C#, Visual Studio 2022, Git, Delphi, MS SQL 2022, T-SQL, DataGrip
Software Architect, Software Developer and Database Developer
Healthcare
- The goal is to enable automated billing for hospitals. Rules from the EBM catalog are processed to automatically bill them with records from the HIS (Hospital Information System). Users should be able to set and adjust rules themselves.
- Set up the architecture
- Build the rules engine
- Import and export data with Excel
- Connect data with Dedalus
- Build the interface in a prototype
- Integrate different sources via ETL processes
- Tests with Visual Studio and NUnit
- C#, Visual Studio 2022, NUnit, Git, Excel, MariaDB, DataGrip, Docker, PowerShell, Windows
Software Developer and Database Developer
Logistics
- Extend the application for tracking promotional items - across Europe
- Expand the interface for new modules
- Extend the database
- Coordinate with stakeholders, self-organized work
- C#, .NET Core, WPF, MVC, Visual Studio 2022, Git, MS SQL 2022, T-SQL, Azure, Entity Framework
Software Developer and Database Developer
Industry
- Distribute machine parameter data and firmware across Europe via a web interface
- Gather requirements from stakeholders
- Analyze the current situation and create a concept
- Develop the selection interface
- Replicate data to local databases
- Performance optimization, normalization of database tables
- .NET Core, WPF, Visual Studio 2022, Git, MS SQL, T-SQL, Windows 10, Azure
Lecturer in 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
Software Developer
Mechanical Engineering
- Retrofit of legacy systems in medical technology
- Adjusting the HMI resolution
- Integrating new hardware components
- Creating a service to monitor the database server
- TCP/IP communication between HMI and service
- Unit tests with Visual Studio built-in tools
- vb.net, C#, WinForms 3.5 & 5, Visual Studio 2005, 2008, 2012, SVN, VisiWin 6.5, VMware with Windows XP, Win7, Win10, MS SQL Express
Product Owner – SaaS Development
MeQuEn GmbH
- Software solution for accrediting meeting participants and voting software for various clients
- Requirement analysis, developing a target vision together with the client
- Creating use cases
- Interface to stakeholders and development
- Considering cryptographic procedures, including BSI standard TR 02102-1 and Common Criteria (CC)
- Supporting the definition of interfaces and documentation using Swagger/OpenAPI for an API-first approach
- Testing and commissioning the solution in the cloud
- Swagger, MariaDB, GitHub, Kubernetes, Docker
Software Developer and Database Developer
KSB
- Controlling a nameplate stamping 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 Visual Studio built-in tools
- Transferring data to the stamping machine
- C# 4.7.2, WinForms, Visual Studio 2019, Git, MS SQL Express, Windows 10
Database Expert
BELECTRIC
- Implementing a clustered database solution based on MariaDB
- Analyzing requirements
- Creating and applying installation scripts
- Testing and commissioning the solution
- Documenting the solution
- Administering the solution right after deployment
- MariaDB, MaxScale, Git, Docker, Windows
Software Architect, Software Developer, and Database Expert
Phoenix Contact
- New development of a project management system in the energy sector for planning and managing power plants and large projects. Replacing an object-oriented database.
- Requirement analysis, developing a target vision together with the client
- Designing the architecture with stakeholders
- Developing the data layer
- Providing custom interfaces for the client
- Creating a digital twin
- Simulating 10,000 devices for bulk data processing
- Developing tools for hardware simulation
- Planning and creating tests with Visual Studio built-in 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
Software Developer
Mode
- Supporting a data migration from Navision to SAP. Creating data exporters.
- Processing tickets from Jira
- C# 4.7.2, Angular, Blazor, Console, Visual Studio 2019, Git, Jira, Confluence, MS SQL 2016, T-SQL, SSRS, Windows 10
iIoT Consultant, Software Architect, Database Developer
SPAIIS
- Supporting a software vendor in a research project. Machine data is interpreted by AI and saved in a database.
- Building the software architecture for large-scale data processing
- Designing the database
- Creating concepts and implementing machine data integration through REST interfaces
- Planning and developing tests with Visual Studio, unit testing
- Creating a plant simulation
- C# 4.7.2, Rest#, WinForms, ReSharper, Visual Studio 2017, Java, Linux, MQTT, REST, Swagger, JSON, HupSpot, Git, SourceTree, MariaDB, PostgreSQL, Windows 10, Linux, Docker, Kubernetis
Software Developer and Consultant
City of Cologne
- The goal is to develop a system where decision-makers can set system administration requirements without admin intervention.
- Developing a solution with all stakeholders
- Preparing internal stakeholder requirements and monitoring compliance
- Creating concepts and implementing migration SQL scripts
- Building a console application to process bulk requests
- Creating an Excel form for CSV export
- Planning and developing tests with Visual Studio
- Technical documentation, coordination with stakeholders, self-directed work
- C# 4.7.2, VB.NET, WinForms, ReSharper, Visual Studio 2017, XML, Git, SourceTree, MS SQL 2016, MS SQL 2010, T-SQL, SSIS, PostgreSQL, Excel 2016, VBA, VB6, PowerShell, Windows 10, EcoNet
Data Analyst
Public Prosecutor's Office Frankfurt
- Supporting efforts against billing fraud in healthcare
- Examining data sets based on specifications
- Creating an investigation report
- Optimizing Excel templates
- Providing online files from the Association of Statutory Health Insurance Physicians
- Importing billing data from the Association of Statutory Health Insurance Physicians
- Data migration from Oracle to MS SQL
- Jira, Confluence, Oracle 12, Excel 2016, VBA, Windows 10
Software Developer
CAS
- Extending a WPF component for displaying and editing any input files
- Developing components with WPF
- Writing black box tests in Visual Studio 2017
- C# 4.7.2, WPF, Visual Studio 2017, Git, SourceTree, Windows 10
Consultant, Software Architect and Development Engineer
Wöhr
- Creation of a concept for connecting the globally distributed systems in the IIoT field
- Designing the software, including security concepts with microservices
- Coordinating the project participants
- Building client prototypes in WPF
- Analysis of legacy data
- Writing a service to import the old messages into the new system
- Tests 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
Software Architect and Development Engineer
Bosch
- Development of add-on modules for assembly software that is used in 50 sites worldwide. The software is part of a shopfloor system in the MES environment.
- Software error analysis
- Further development of an administration tool and the electronic shift log
- Integration with REST interfaces
- Component development in WinForms and distribution via NuGet packages
- Unit testing of the REST interfaces
- Extending web interfaces on .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
Software developer and database developer
brown IPOSS
- Data analysis of geodata in the mobile sector
- Adapting ASN.1 converters into the end clients' system landscape
- Data analysis for sector swapping of base stations
- Analysis of SwissQual data
- C#, Visual Studio 2017, MS SQL 2016, Windows 10
Software expert, coach
GVS
- Support during the rollout of software in the gas and electricity billing area
- Vulnerability analysis
- Introduction of SignalR
- Extending web interfaces on .NET Core
- Tests 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
Database, backend and MES expert
Kannegiesser
- Standardizing production databases and system interfaces in the MES environment
- Database analysis and support for project management
- Creating and implementing database concepts, including replication
- Setting up ETL pipelines
- Testing the concepts during commissioning
- Designing UIs for master data
- Software development of services in C#
- Adapting low-level machine 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
Database and MES Expert
Osram
- Database analysis in the MES environment to reduce downtime
- Developing a monitoring tool for shopfloor oversight
- Creating and implementing database and communication concepts
- Software development in C#
- Planning and executing automated and manual tests
- MS SQL 2008 R2 replication and setting up ETL processes
- C#, MVC, VB6, Visual Studio 2010, MS SQL 2008 R2, TFS 15, Tortoise SVN, XML
Software Architect
Siemens
- Extending the help system for a major client
- Creating a fallback system for help requests
- Implementing multilingual support for views using WPF
- Migrating export-import conventions for a new release with MS SQL 2012
- Designing an ergonomic maintenance application for managing help entry points
- Coordinating the involved team members
- Developing automated and manual tests
- Writing the SQL scripts for the migration
- C# 4.5, Visual Studio 2012, WPF, MVC, Winforms, Infragistics, TFS 15, MS SQL 2012, PostgreSQL, XQuery, PowerShell, working in Scrum
Software Architect and Development Engineer
BorgWarner Turbo Systems
- Developing a permission system for 12 global sites and over 1000 assembly stations
- Developing the workflow for an ergonomic interface
- Planning the architecture and deployment of the permission system
- Developing a validation concept to migrate legacy data
- Introducing documentation with Doc-To-Help
- Implementing a ticket system with OTRS
- Testing with Visual Studio
- VB.net, VBA, ASP.Net, MS SQL 2012, DocToHelp, Visual Studio 2010, TFS
Software Architect
Innojet
- Restructuring and visualizing plants for the pharmaceuticals and food industries
- Replacing VisiWin components with C# components
- Visualizing process actions on the plant
- Planning the architecture and customizing the software
- Commissioning at client sites
- C# 4.0, OPC Server INAT for S7, MS SQL 2005, MS Excel 2010, Visual Studio 2010, VisiWinNet 6.5
SQL Database Developer
Insurance
- Data migration 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
Software Developer / Subproject Lead
Airbus
- Migration of management software for cabin equipment 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 permissions management
- SAP R3 – RFC integration
- Delphi 5, Delphi XE2, FireBird, MS SQL 2008, DOORS, working according to Scrum
Software Developer
Automation industry
- Planning and implementation of an editorial 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
Software Developer
Rosebrock Software
- Implementation of central base packages for tax advisor software
- Planning the new architecture with ModelMaker
- Performance optimization for calculation modules and SQL queries
- Executing automated tests in Delphi
- Maintenance of non-tax-specific software parts (trade tax, wage tax, etc.)
- Interface maintenance and second-level support
- Coaching of new staff and support personnel
- Delphi XE, C# .net 3.5, ADS, ModelMaker 11, Subversion, Windows 7, Vista, XP, XML / XSL
Software Developer / IT Project Lead
Symestic GmbH
- Project work in industrial controls and MES
- IT project lead for wood processing plants and automotive suppliers
- Planning and development of Windows services for controlling industrial plants
- New development and standardization of services for data exchange between PLC and database 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
Project Engineer / Project Lead
VSK Technik Kübler GmbH
- Project lead in the industrial sector for software product planning and development
- Control of industrial plants with image processing and sensor integration
- Task-based sensor evaluation, remote maintenance and data acquisition
- Renewal of PC software for calendering machines and punch tool management
- Extension of the HMI for hardness testing machines and process data archiving
- Software support for packaging lines in pharmaceuticals (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
Consultant Professional Services
ATOSS Software AG
- Consulting and support in the area of work time management and staff scheduling
- Configuration of the software solution and setup of terminals
- Sales support in presales
- Windows, AS/400, MS-SQL, Oracle, DB400, XML
Consultant / Leadership and Coaching
LogicaCMG GmbH & Co.KG
- Leadership and coaching of 40 developers at 3 locations
- Implementation of custom client/server software solutions
- Specialist for user interface ergonomics and instructor for PowerBuilder class libraries
- Development of a customer reporting system for Deutsche Bank (C++, UML, Linux)
- Building technical know-how and project management for BlackBerry handhelds
- Evaluation of new development environments (J2EE, .NET) for international trade finance products
- Creation of a quality assurance tool for the Hessen State Welfare Association
- Implementation of an invoicing system with SAP-FI interface for Axel Springer Publishing
- Development of a standard software for asset management at SER (SunGard)
- Development of a sales system for Woelm AG
- MS-Project, OOA / OOD / OOP, PowerBuilder 5.0 – 7.0, Oracle, MS-SQL, ClearCase, XML, C++, Java, J2EE
Software Developer
EVO Bus GmbH
- Development of software for managing electrical plans in bus manufacturing
- Excel, Access
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Manufacturing, Banking and Finance, Media and Entertainment, Automotive, and Healthcare.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Product Development, Project Management, Quality Assurance, Customer Service, and Business Intelligence.
Summary
Added value through digitalization and software development - from the first idea to the finished solution.
“Finding the right solutions for my clients is fun!”
“I enjoy building interfaces that truly meet the requirements. Databases are another one of my pillars.”
“In IT, I feel at home in multiple roles.”
Skills
Focus Areas
- Software Developer & Architect
- Consultant
- Product Owner
- Project Manager
Industries
- Industry
- Plant Engineering And Packaging Industry
- Public Sector
- Financial Sector
- Pharmaceutical And Food Industry
- Critical Infrastructure
Tools And Frameworks – Software Development
- C# (20 Years)
- Vb.net (10 Years)
- Winforms (20 Years)
- Wpf (10 Years)
- Blazor (2 Years)
- Vb6 (5 Years)
- Visiwinnet (5 Years)
- Nuget (10 Years)
- Delphi (10 Years)
Databases
- Ms Sql, T-sql (20 Years)
- Ssis (10 Years)
- Ssrs (20 Years)
- Wcf (5 Years)
- .Net Core (5 Years)
- Asp.net (5 Years)
- Postgresql (5 Years)
- Mariadb (5 Years)
- Maxscale (5 Years)
- Mysql (5 Years)
- Vba (5 Years)
- Oracle, Pl/sql (5 Years)
- Etl Processes (10 Years)
- Replication
- Geo Data
- Design And Optimization Of Large Databases
- Automated Testing With Visual Studio
- Nunit
Interfaces
- Rest
- Restsharp
- Swagger
- Opc
- Rpc
Reporting
- Reporting Services
- Crystal Reports
- Power Bi
Other Tools & Technologies
- Docker
- Powershell
- Mqtt
- Directory Ldap
- Tfs
- Sourcetree
- Tortoisesvn
- Git
- Jira
- Confluence
- Polarion
- Visio
- Legacy Experience With C#, Delphi
Operating Systems
- Windows
- Linux
Methodologies
- Scrum
- V-model
- Kanban
- Rad
Languages
Education
Darmstadt University of Applied Sciences
Diploma in Computer Science (FH) · Computer Science · Darmstadt, Germany
Darmstadt University of Applied Sciences
Diploma in Engineering (FH) · Electrical Engineering · Darmstadt, Germany
Certifications & licenses
IHK Certified Trainer
Certified Data Protection Officer (TÜV Süd)
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Jörg based?
What languages does Jörg speak?
How many years of experience does Jörg have?
What roles would Jörg be best suited for?
What is Jörg's latest experience?
What companies has Jörg worked for in recent years?
Which industries is Jörg most experienced in?
Which business areas is Jörg most experienced in?
Which industries has Jörg worked in recently?
Which business areas has Jörg worked in recently?
What is Jörg's education?
Does Jörg have any certificates?
What is the availability of Jörg?
What is the rate of Jörg?
How to hire Jörg?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Database Expert and Software Developer
Nearby freelancers
Professionals working in or nearby Lampertheim, Germany