Context

• About 20 years of experience across many biotech and healthcare projects
  • .NET 1 - 3.5 / 4.7.2 / .NET Core 2.1 - 8.0
  • ASP.NET 2.1/3.1/5.0
  • Implementation of various integrations
  • Implementation of various generic solutions
  • Worked in teams using Scrum organizational framework

Development

• BLOB Storage/Event Hub/IoT Hub
• Microservices (Azure Functions)
• Windows Services on .NET Core
• ASP.NET Core REST Services
• Razor/Blazor (Server & WebAssembly)
• DevOps / GitHub
• Client/Server Applications...
• NUnit Testing
• Various 3rd Party Components
• Typemock Isolator
• Class & Application Design
• WCF

Context

Development

• HTML Reporting Framework
• LIMS Basic Code Comparison / Code Review
• Microsoft Word DOCX Generator

Packages & Components

• node-oracledb
• Express HTTP(S) Server
• Office.JS
• Node-Oracledb
• PapaParse
• Passport - Authentication
• Mammooth

Client

• jQuery
• jQuery UI
• Bootstrap
• DataTable
• FancyTree
• D3.js, plot.ly, EJS Charting

Context

Projects

• Data query SIMCA Online / B2B interface
• API Walker:
  • REST API queries of hierarchical structures
  • Generate object templates from dynamically determined structures
  • Generate XML and CSV files from objects
  • File transfer

Context

Tasks

• SQL/DDL
• Views
• Stored Procedures PL/SQL
• Packages
• XMLTABLE/JSON/HTML
• Java Bindings

Context

Similar to Oracle as a DB backend, I master all developer-relevant techniques on MSSQL Server.

Microsoft SQL Server 7, 2000, 2005, 2008 R2, 2012, 2017, 2019

Skills

• Stored Procedures, Functions, Triggers / T-SQL
• Table & Database Design
• Views
• Profiling & Tuning

Context

Labware LIMS provides various programming possibilities, creating an environment where a software developer can have impact, even though LIMS Basic cannot be directly compared with other programming languages.

In interface development with LIMS Basic, my long-standing experience with integrating other systems comes into play.

Besides implementing requirements within the required context (LIMS Basic), one of my strengths as a consultant is to propose alternative approaches, offer other technologies and perspectives, turning a Labware project into a Software project.

Development work

• System migration from Labware v6 to Labware v7
• Generic CSV/Excel import interface
• Customer-specific AutoCalc framework
• Subroutines, (DB) Event triggers, Info Rules, Automation Scripts, Component Macros, Format Calculations...
• ProdSpec2Result Framework
• HTML Reporting Frameworks
• Barcode labels for Zebra, Toshiba, Epson Color Printer TM-C340
• Crystal Reports integration
• Various instrument integrations
  • AMBR 15/250
  • Siemens BGA 248/348 Series, Rapidlab
  • TECAN

Modules

• Crystal Folder Manager
• Visual Workflows
• Prod Spec Editor
• Genealogy Tree
• Project Manager
• Plate Manager

Context

Tasks

• Requirements Engineering
• Application Design
• Application Programming
• Backend Programming, Oracle Packages

Developments

• Release Tracking (Oracle JET, Gantt Chart)
• ccEdit - Mini-LIMS
• Capacity Planning

Packages & Components

• D3.js
• AnyChart GANTT (.js library)
• Oracle JET
• Marvin.js

I have been using Java since around 2003 for smaller projects, especially when developing non-visual applications.

I enjoy the language itself, its cross-platform capabilities, and the robust exception handling.

The architecture of classes and the ease of connecting components due to their solid design always impress me.

Another highlight of Java is its strong community and the wealth of interesting open-source projects.

Application Areas

• J2SE/J2EE
• Service Programming
• Socket Programming
• SSL Programming
• XML Processing
• JDBC

My roots are in Turbo Pascal, which led to Delphi being my favorite programming language for many years.

I loved Delphi's component-based development approach.

The infrastructure of community-available and 3rd-party components was pioneering for software development and enabled me to implement complex applications solo or in small teams.

I would be excited to work with Delphi in its current version and participate in a Delphi project again.

Tasks

• Client/Server Programming, N-Tier Programming in Biotech Lab Environment
• VCL + Component Development
• Windows NT Services
• COM/COM+ including Office Automation

3rd Party Component Experience

• Delphi Profiler
• ASTA N-Tier Components
• MemChecker
• Exception Magic
• Eureka Log
• ProDelphi (Profiler)
• Developer Express Components
• Dream Company Components
• DUnit (Framework for automated testing)
• Philo Open XML
• ND IntraWeb
• PDF OutOfTheBox
• ...

I gained 2 years of professional experience in a telecommunications project.

Coming from the Delphi world, it was relatively easy for me to achieve satisfying results in C++ as well.

C++ is, of course, a great language, and the Microsoft compiler with its many configuration options always fascinated me.

The Visual Studio environment and the way components were developed there felt rather rustic at the time.

Development

• OOA / OOD
• MFC (Microsoft Foundation Classes)
• STL (Standard Template Library)
• OO4O (Ole Objects 4 Oracle)
• ADO
• Cantata++ Instrumentation
• Multithreaded Programming (Semaphores, Critical Sections…)
• Application Development