Michael Schick - Logistics System Conversion

Ludwigsburg, Germany

Experience

Jul 2023 - Jan 2024

7 months

Logistics System Conversion

Industry

Converted a logistics system based on Access, VB6, etc. to .Net and new developments.
Technologies:
Visual Studio .Net 2022
VB6
Access
SQL Server

Feb 2023 - May 2023

4 months

Appointment and Task Management

Mainly technology consulting and prototype creation.
Modernization in phase 2 (Windows 11).
Technologies:
Visual Studio .Net 2022
Android
Various CRM systems
Outlook
Thunderbird

Jun 2022 - Nov 2022

6 months

Appointment and Task Management

Mainly technology consulting and prototype creation.
Modernization in phase 2 (Windows 11).
Technologies:
Visual Studio .Net 2022
Android
Various CRM systems
Outlook
Thunderbird

Apr 2022 - May 2022

2 months

SQL Server Programming and Optimization

Health Insurance Service Provider

SQL Server programming and optimization.
Technologies:
Visual Studio .Net 2022
WPF
Windows Forms
ADO.Net
SQL Server 2019
SSMS
T-SQL
Jira
CVS

Nov 2021 - Dec 2021

2 months

Word Template Automation

Government Agency

Automated Word templates.
Technologies:
Word 2016 VBA
Visual Studio .Net 2019 and 2022
C#
Windows Forms
Visual Basic 6
MZ-Tools

Jan 2020 - Sep 2021

9 months

Modules to Connect a Raspberry PI-Based Device

Medical Technology, Lab Networking

Modules to connect a Raspberry PI-based device to (S)FTP, SMB, and other servers and to web services.
Technologies:
Linux
Visual Studio 2019
.Net Core 3.1 and .Net 5
Entity Framework
Azure Cloud Services
Bitbucket
WinSCP

Feb 2020 - Nov 2020

10 months

Customer Management System - Evaluation of New Web Technologies

Evaluated new web technologies with Visual Studio 2019, C#, F#.
Technologies:
Visual Studio 2019
SQL Server

Apr 2019 - Sep 2020

1 year 6 months

Web Applications

Various Clients

Various database-driven web apps:
Reporting software connected to the webshop database for a textile retailer.
Data entry for quality management with error-tracking workflow and analysis/reports (automotive sector).
Technologies:
Visual Studio 2018, 2019 Preview
C#
.Net Core
ASP.Net MVC
Razor
Blazor
Web API
jQuery
Angular 8
SQL Server
Entity Framework (EF Core)
Office 365

Jan 2016 - Jan 2021

4 years 1 month

Android App Development

Various Clients (Public Water Supplier, Metal Manufacturing)

Developed various Android apps, e.g.:
An emergency-call app for a public water supplier to notify staff of incidents (workflow to resolution).
Using smartphones as scanners in the production process, linked to the ERP system (metal manufacturing).
Technologies:
Android Studio
Visual Studio

Jan 2015 - May 2017

1 year 5 months

Planning Systems - Legacy Integration

Industry (Aluminum Plant)

Connected legacy systems to a new planning system.
Technologies:
Visual Studio 2015
ADO.Net
Oracle 11

Jul 2015 - Jan 2016

7 months

VS Upgrades

Various Projects

Upgraded various projects from Visual Studio 2005,2008,2012 to 2015.
Technologies:
Visual Studio 2015
ADO.Net
SQL Server etc.

Mar 2014 - Feb 2015

1 year

Pocket PC Software for PSIpenta ERP

Industry (Production and Materials Management)

Developed Pocket PC software, integrated with ERP.
Technologies:
Windows CE
Pocket PC
Visual Studio 2008
C#
Windows Forms
.Net Compact Framework
SQL Server 2012
ERP PSIpenta

Jan 2014 - May 2019

5 years 5 months

Productivity Tools - Web Application

Web app for contact management, scheduling, etc.
Technologies:
SQL Server
Visual Studio 2013
WCF
WPF
XAML

Nov 2013 - Mar 2020

6 years 5 months

.Net Tools - Data Import and Custom Development

Data import, small .Net custom developments.
Technologies:
SQL Server 2008-10
Office 2013
Visual Studio 2013

Jan 2013 - Aug 2013

8 months

Data Import and DB Maintenance

SantaFeTex (E-Commerce)

DB maintenance, data import for ERP and web shop.
Technologies:
SQL Server 2008
Office 2013

Sep 2012 - Sep 2013

1 year 1 month

Software Troubleshooting for Diagnostic Device

Roche Diagnostics (Medical Technology)

Software troubleshooting of a diagnostic device.
Defined bug-handling process and managed it.
Bug fixing, internal tool creation.
SCRUM team, process definition for troubleshooting.
Technologies:
Windows 7
Visual Studio 2010,2012
TFS
C#
Silverlight
WPF
XAML
Windows Forms
ReSharper
Oracle DB
HP QC
Linux (Ubuntu)
Eclipse
C++

Jun 2012 - Jun 2012

1 month

Remote Camera Control

MHW Expert Office

Technology and hardware selection, evaluation, implementation (project in progress).
Technologies:
Wireless USB
Visual Studio 2012

Mar 2012 - Jun 2012

4 months

eCommerce System Architecture

Netrada (E-Commerce)

Designed technical system architecture, guided business analysts in capturing as-is and to-be processes in a carve-out project.
Technologies:
Borland C++ 2000
Visual Studio .Net 2010
Visual Paradigm Suite (VP-UML)
BPMN 2.0

Feb 2012 - Feb 2012

1 month

Further Training Mobile Applications

Private

Self-study of mobile development technologies.
Technologies:
Galaxy S2
Android

Sep 2011 - Oct 2011

2 months

Website Design

Kasler (Hospitality)

Designed and maintained websites.
Technologies:
Typo3

Aug 2011 - Jan 2012

6 months

ERP Integration with Credit Card Provider

Lindy (E-Commerce)

Designed and implemented interfaces for credit card payments via online shop.
Connected to the provider's XML APIs.
Technologies:
Access
VBA
Sage Office Line
SQL Server
HeidelPay payment system
XML

Feb 2011 - Jul 2011

6 months

Geomatics Solution Modernization

Leica Geosystems (Industry)

Strategy and concept for migrating unmanaged C++ to .Net, implementation.
Started from a monolithic C++ app over 10 years old.
Split into layers (measurement flow, data layer, GUI).
New code used the .Net framework.
Prototypes addressed which parts stay in C++, how C++/.Net communicate, and the migration path (COM, C++/CLI, WCF, etc.), and the legacy app was adapted.
Technologies:
Visual Studio 2005
C++
SQL Server 2005-2008
Win XP,Vista,7
Visual Studio 2010
C#
Windows Forms
WPF
WCF
C++/CLI
Perforce SCM
Boost Library

Nov 2010 - Dec 2010

2 months

UI Development Planning Tool

IT/Software Development

Designed and implemented various modules in cooperation with the client.
For the planning tool, implemented WPF grids, putting shared functionality in a base grid.
Saving/restoring user-specific configs and layouts.
Technologies:
Visual Studio 2010
C#
Windows Forms
WPF
ADO.Net
DevXPress Controls
Access
SQL Server

May 2010 - Oct 2011

1 year 6 months

Integration of Debt Collection System with Accounting

Tess (Telecommunications)

Designed and implemented XML interface between debt collection and accounting; extended Sage ERP with custom input forms and reports.
Created an importer (C#) using WCF web services to connect to the debt collection system (input interface).
Output side wrote data to the ERP DB via ADO.Net/Datasets/DataAdapters.
Technologies:
Sage Office Line (Accounting)
Customer PHP debt collection system (Telco)
Visual Studio 2010
C#
ADO.Net

Oct 2009 - Dec 2010

1 year 3 months

Custom ERP Adjustments and Interfaces

Various SMEs

Detailed design, coding.
Workflow solutions for orders, inventory management, data import/export, product variants management.
Technologies:
Sage Office Line Evolution 2010/2011
Visual Studio 2008
C#
DevXPress and LogiSoft Task Center
XML Web Services
VB6
VBA
ADO.Net
LINQ
SQL Server
Access 2007

Jun 2009 - Jun 2012

3 years 1 month

Data Import

SantaFeTex (E-Commerce)

Query design and Excel export/import.
Data transformations between CSV files, Excel, and SQL Server.
Technologies:
Excel 2010
SQL Server
Sage OfficeLine

Jan 2009 - Apr 2024

15 years 4 months

Consultant, Architect, Developer

Freelancer

Jan 2007 - Dec 2009

2 years

Microsoft CRM Projects

AMC (Marketing)

Conception, installation, customization, programming, data migration.
Technologies:
MS CRM 1.2
Excel
SQL Server
Outlook 2000/2003

Dec 2006 - Sep 2007

10 months

Printer Driver Adjustment

Leica M. (Medical Technology)

Programming, testing.
Ported a user-mode driver for a cassette printer from NT4.0 to XP and Vista, fixed bugs and instability.
Technologies:
Visual Studio 2005
C++
Windows DDKs
Windows NT,XP,Vista
VMWare Workstation

Nov 2006 - Nov 2006

1 month

SharePoint Portal Server Installation and Configuration

IBJ (Consulting)

Installed and configured SharePoint 2003.
Technologies:
SharePoint 2003

Oct 2006 - Oct 2006

1 month

Software Evaluation for Business Scorecards

Mann+Hummel (Automotive)

Evaluated various technologies including Microsoft Business Scorecard Manager.
Technologies:
Microsoft Business Scorecard Manager

Jul 2006 - Sep 2009

3 years 3 months

Module Development for Tissue Processor

Leica Microsystems (Medical Technology)

Programming, partial design, evaluation.
XML log files, sample safety improvement, MFC dialog programming, wax station optimization.
Technologies:
Windows XP
Visual Studio 2005
C++
Windows DDK

May 2006 - Aug 2006

4 months

Kernel-Mode Driver Development

Medical Technology

Technology selection, programming.
Controlled an FPGA, wrote ISA-BUS driver, adapted old driver C code and rewrote in C++.
Technologies:
Visual Studio 2005
C++
Windows DDK
WinDbg, Debugging Tools for Windows, Windows XP Checked/Debug Build, VMWare Workstation

Jan 2005 - Mar 2009

3 years 3 months

Technical Project Management, Fuel and Operating Materials Management System

Energy Provider GKM

Requirements analysis, spec creation, technology selection, implementation, QA, training new staff in .Net, technical project lead.
Windows Forms app, data layer with ADO.Net partly auto-generated by MyGeneration.
80 tables, ~120 entry and report forms.
Non-modal GUI, XML exports, Excel reports with pivot tables.
SAP integration via WCF.
Technologies:
Visual Studio 2005/2008
C#
Windows Forms
WCF Web Services
SAP NetWeaver
UML
MyGeneration
MS Office and SharePoint 2007 intranet integration
VMWare Workstation

Jan 2005 - Apr 2006

4 months

Embedded Software Porting from NT to XP

Leica M. (Medical Technology)

Technology consulting and programming.
Ported all device software from Visual C++ 6.0 to Visual Studio 2002, then 2005.
Upgraded from Windows NT 4.0 to Windows XP.
Technologies:
Visual Studio 2005
C++
Windows DDK

May 2004 - Dec 2004

8 months

Environmental Management System/Tracking Obligations

Energy Provider GKM

Concept, DB design, implementation.
Technologies:
Visual Studio .Net 2005
Windows Forms
SQL Server 2000/2005

Dec 2003 - Jul 2009

5 years 8 months

Field Service Information System

Fontargen (Metal Processing)

Concept, DB design, implementation.
Technologies:
Visual Studio .Net 2002/2005
Windows Forms
MSDE 2000
MS Office
MyGeneration

Jan 2003 - Jan 2004

1 year 1 month

Various SharePoint Projects

Various SMEs

Design, programming.
Technologies:
SharePoint Portal Server
WSS
MS Office (mainly InfoPath and Excel)
ASP.Net

Jul 2002 - Nov 2004

2 years 5 months

Patient Management/Medical Database

Energy Provider GKM

Spec, proposal, design, programming.
UI with ~25 Windows Forms, SQL DB with custom data layer, all data encrypted for privacy.
Deployed at multiple sites.
Reports via Excel/Word export.
Custom user management for security.
Connected several lab devices, including Cobas Integra 400.
Under .Net 1.1 had to implement serial port access classes.
Developed and tested on two VMWare images with virtual serial ports (dev machines had no physical ports).
Technologies:
Windows 2000
Visual Studio .Net 2002–2005
SQL Server 2000
Word+Excel
ComponentOne Studio for .Net
VMWare Workstation
COSIM simulation software

May 2002 - Jul 2002

3 months

Office Automation Tools

DIS (Recruitment)

Design and implementation.
Technologies:
Excel/Word 2000
VBA
Active Directory

May 2002 - May 2002

1 month

Holiday Home Management

Energy Provider GKM

Design, implementation.
Technologies:
SQL Server 7.0
Visual Basic 6
Excel/Word 97

Jan 2002 - Jun 2002

6 months

Customer Care System with Product Sample Management

Benckiser Detergents

Spec, design, programming.
Technologies:
Visual Basic
SQL Server
ActiveX
Excel and Word

Aug 2001 - Dec 2002

5 months

Product Sample Management

Benckiser Detergents

Spec, design, programming.
Technologies:
Visual Basic
SQL Server

Apr 2001 - Jun 2002

1 year 3 months

OLAP Data Warehouse for Material Flow

Mann+Hummel (Automotive)

Designed and built OLAP cubes and Excel pivot tables for reporting.
Technologies:
SQL Server 7.0 + Analysis Services
Excel 7.0/2000/2003

Aug 2000 - Jan 2001

6 months

Retrofit Application

Energy Provider GKM

Design, implementation.
Technologies:
MSDE/SQL Server 7.0
Visual Basic 6
APEX TrueDBGrid

Jan 1998 - Dec 2009

11 years

Mannheim, Germany

Consultant, Architect, Developer

Cairo Consulting

Internal project (06/1999–09/1999): Developed standards for the software team. Participation.
Technologies: Various Microsoft, Java, databases, MSF.
Internal project (06/1999–09/2000): Migrated Access to SQL Server. Design and execution.
Technologies: Access 97, SQL Server 7.0.
Internal project (09/2000–12/2000): Migrated SQL Server 7.0 to 2000. Planning and execution.
Technologies: SQL Server 7.0/2000, DTS.
Internal project (09/1999–02/2000): Built intranet. Classification concept, evaluation, implementation.
Technologies: SharePoint Portal Server, MS Exchange 97, DMX and WFX, AutoStore.
Internal project (01/2001–07/2004): Project management. Design, programming.
Technologies: Outlook 2000/2003 Add-Ins, Visual Basic, SQL Server, ASP, ASP.Net, Java.
Internal project (12/2003–12/2004): Media management system. Design, DB design, implementation.
Technologies: Visual Studio 2005, ASP.Net 2.0, SQL Server 2000.
Internal project (06/2006–07/2006): Created intranet web parts. Evaluation, design, implementation.
Technologies: ASP.Net, Visual Studio .Net 2005, various frameworks.
Internal project (07/2006–09/2006): Time entry app. Design, DB design, implementation.
Technologies: SQL Server 2005, Visual Studio .Net 2005, Windows Forms.
Internal project (08/2006): Info management workshop. Preparation and presentation.

Jan 1998 - Apr 2000

1 year 4 months

Short Term Planning System for Business Figures

York (Industry, Refrigeration)

Design, programming.
Technologies:
Visual Basic
SQL Server 7.0

Jan 1996 - Dec 1999

4 years

Mannheim, Germany

Developer

Cairo Consulting

Project for energy provider GKM (01/1996–06/1999): Lab information management for coal analytics (LIMS coal), predecessor of the fuel management system 2008, No. 34. Detailed design, programming, 24MM+.
Technologies: Windows NT, Visual Basic 3.0–6.0, Excel, Word, Access 2.0/97, SQL Server 7.0, Crystal Reports, SAP R/2 and R/3 integration (RFC).
Project for energy provider GKM (01/1998–03/1998): Workflow solution for suggestions scheme. Design and implementation.
Technologies: Excel/Word 97, VBA, MAPI.

Jan 1990 - Dec 1997

7 years

Neustadt, Germany

Developer

ICR Data Center

Project for BASF (Industry, Chemistry, 06/1990–08/1993): Implemented base classes for calculations (vectors, matrices, Gozinto schema), reports, data layer.
Technologies: OS/2, DB/2, C++.
Project for Fulda and Goodyear (Automotive, 10/1993–11/1994): Implemented modules, PC↔Host transfer (AS/400), UI, optimizations.
Technologies: DOS, Borland C++ with TurboVision, Occelot SQL DB.
Project for auto dealers (E-Commerce, 01/1995–03/1995): DB and application design and implementation.
Technologies: DOS, Borland C++ with TurboVision, CTree-ISAM.
Project for Citibank (Banking, 04/1995–04/1996): MDI UI for loan contracts, flow control, credit check via BTX.
Technologies: Windows 3.1, MS Visual C++, ISDN, BTX.

Summary

My main area of work is developing custom individual solutions. This covers the entire development cycle, from requirements analysis through technology selection, architecture, design, and finally implementation and enhancement.

On the technology side, since 2002 I’ve mainly used .Net, C#, C++, Visual Studio, SQL Server, and MS Office in the Windows environment. However, this can vary depending on requirements. Since 2017 I’ve also worked on Android apps (Visual Studio / Xamarin), and since 2021 I’ve done Linux development with .Net/Visual Studio.

Many of my past projects were classic client/server desktop systems; more recent ones are mostly web applications. Since 2011 I’ve gained extensive experience migrating complex unmanaged code to managed code (VC++ to .Net, C++/CLI). I’ve also done porting of older VB6 applications to .Net and full rewrites. With .Net Core, .Net 5, and now .Net 6, migrations remain a constant theme.

I’ve also worked on hardware-level projects under Windows (printer driver, kernel-mode driver) and Linux (diagnostics device, Project No. 46, IoT Box No. 55).