Software-Development

C# (.NET, .NET Core)

Project

Analysis, implementation, commissioning, and CSV (computer system verification) of an MSC (Medical Surface Center)

process control system with the following features:

Configurable process sequences

Monitoring of processes and personnel authorizations according to process sequences

Configurable, PLC-controlled processing stations

Reporting of all processes and customer orders

Archiving of all processing procedures

Integration of dynamically switchable user language (German, English, Chinese)

Support with certification (CSV)

Front end in VBA and C#

Back end and process processing with SqlServer 2016 AlwaysOn and T-Sql (Transact Sql)

Tools

SqlServer 2016 AlwaysOn, T-Sql, Access2010(VBA), C#, .Net 4.6, CLR-Interface

Project

Analysis, implementation, testing, and commissioning of components for an MES (Manufacturing Execution System) for the production of customer-specific sensors

MapSampleAutoGenerator:

A tool that automatically selects sensors from different process stages for test measurements

ReelApprovalTool:

A tool that verifies that all sensors selected for the reels (rolls equipped with sensors) are error-free.

ReelReportingTool:

A tool that generates a Q report for the reels in the final process.

Test chamber automation:

Creation of a DB client application for controlling, monitoring, and defining the parameters and test sequences of test chambers in which the sensors are measured during the production process.

Tools

C#, WinForms, LinqToSql, .Net 4.5, SqlServer 2008R2, T-Sql, Multithreading, SVN, CodeSmith, MES

Project

Analysis + implementation of an application for billing services + materials with variable detailed items and interfaces to the time recording system, accounting system (Abacus), and CRM system.

Tools

C#, WinForms, MVVM, .Net 4.61, SqlServer 2014

Project

Display of the order volume of a large production company in weekly and daily bar charts with configurable features:
Variable selection of the display area
Various filters for production groups
Display of the order number instead of the order value
Display of the customer name if there is space in the bar
Calculation of the minimum height of a bar with automatic scaling of all values
Color control of the bars based on the order status
Additional marking of the bar for fixed dates
Activation of a pop-up window via mouse event above the bar and display of detailed information

Tools

C#, WinForms, .Net 4.5, SqlServer 2008R2, MS-ChartControl

Project

Analysis of extensions and error messages, and correction and implementation of functions in accordance with JIRA entry
3D extension: Implementation of a new algorithm for marking 3D objects such as half-cylinder sections, half-sphere sections, truncated cones, inclined planes, and prisms

Tools

C++, Trumpf LaserCAD Libraries, TruMark7000 Serie, JIRA

VBA (MS Access, Excel)

Project

Generating orders from quotes with links to AVOR and SharePoint:
Analyzing data and interfaces
Implementing VBA functions
Testing interfaces together with the customer

Tools

Excel 365 (VBA)

Project

Analysis and implementation of an application for generating service invoices for a service provider in the security sector (access control) and key service.
Including component management.
Various reports.
Data transfer from a previous application.
Expansion with QR code.

Tools
MS-Access, Visual Basic (VBA)

Project

Automated plate ordering with Excel VBA with interface to the ERP system and generation of supplier orders
Analysis of data and interfaces
Implementation of VBA functions
Testing of interfaces together with the customer

Tools
Excel 365 (VBA)

Project

Analysis, implementation, and commissioning of a system for processing and managing quality inspections of gas turbine components, including preparation of reports and documents and publication on the Internet.
Analysis, data modeling, task descriptions, scheduling/resource planning, project monitoring, and team leadership
Design of various test scenarios, including data synchronization with Internet servers (data import/export), acceptance checklists (protocols), and test scripts
Conducting reviews and release approvals
Development of special functions (interfaces to Winword, document generation)
Porting to Winword2010
Algorithms for fast search mechanisms (SqlServer)
Performance improvements using stored procedures (SqlServer, T-Sql)
Support for SqlServer configuration (replication) and security aspects
Importing measurement data from Matlab
Evaluating measurement data (trend analysis with ExcelObject)
FTP server control for data transfer to Internet servers

Tools

MS Access (VBA), Excel (VBA), Winword 2010 (VBA), SqlServer, T-Sql, Replication, C/C++