Christian H.

Further Development of Excel Templates

Munich, Germany

Experience

Apr 2025 - Apr 2025
1 month
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, development
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Feb 2025 - Feb 2025
1 month

Software Enhancement

CRM for Insurance Agencies

  • Design, consulting, development, quality assurance
  • New features for the existing program
  • Migration of individual modules to .NET 9.0
  • Technology: .NET Core, C#, Blazor, WPF, VB.NET, SQL Server 2019 (SSRS, SSDT), Azure, EF, LinqToSQL, List & Label
Aug 2024 - Aug 2024
1 month

Maintenance and Enhancement of Various Internal Applications and Databases; Migration VBA (Excel, Access) to Windows 11

Bavarian Insurance Chamber

  • Design, development
  • Technology: C#, SQL Server, Entity Framework, Access, Excel, VBA
Apr 2024 - Dec 2024
9 months
Vienna, Austria

Import and Management of Data from Various Studies; Migration to WebApp, Various Extensions

University of Vienna

  • Design, development
  • Developed an application to manage studies
  • Technology: C#, .NET Core, Blazor, JavaScript, SQL Server, Entity Framework
Mar 2024 - May 2024
3 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, development
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Nov 2023 - Apr 2025
1 year 6 months
Vienna, Austria

Data Maintenance and Reporting for Maintenance Center

Octapharma

  • Design, development, quality assurance, support
  • Changes and enhancements to the reporting tool and dashboard
  • Creation of macros and integration with SharePoint
  • Error tracing in metrics and reports
  • Maintenance and extension of SQL database
  • Technology: C#/ASP.NET Core, Blazor, EF, JavaScript, SQL Server, SharePoint, Excel
Aug 2023 - Dec 2023
5 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, development
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Jun 2023 - Dec 2023
7 months
Germany

Statewide Software Solutions for Daily Operations

Bavarian Police

  • Design, development, quality assurance, second-level support
  • Enhancement of existing programs
  • Design of a modern architecture
  • Planning for migration to .NET Core
  • Improvement of SQL database
  • Technology: C#/ASP.NET, EF, JavaScript, .NET Core, Oracle
Mar 2023 - Apr 2023
2 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, development
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Jan 2023 - Apr 2023
4 months
Vienna, Austria

Import and Management of Data from Various Studies

University of Vienna

  • Design, programming
  • Created a concept
  • Database design
  • Data import
  • Technology: Excel, VBA, C#, .NET Core, SQL Server, Entity Framework
Jan 2023 - Mar 2023
3 months

Software Enhancement

CRM for Insurance Agencies

  • Design, development, quality assurance
  • New features for the existing program
  • Migration of individual modules to .NET 7.0
  • Technology: VB.NET, C#, WPF, SQL Server 2019 (SSRS, SSDT), Azure, EF, LinqToSQL, .NET Core, Angular, List & Label
Jul 2022 - Dec 2022
6 months

MESAP

EnBW

  • Design, programming, testing
  • Creation, adaptation, or extension of functions/components for the “Mesap” project based on user stories
  • Integration of various data sources (WebService, CSV, etc.) to transform data into the Mesap system
  • Writing required source code and test routines according to guidelines
  • Creating DevOps pipelines with SonarQube integration
  • Monitoring of live systems
  • Technology: C#, .NET Core, XML, Scrum, DevOps, MSTest, Azure Service Fabric, SonarQube
May 2022 - Oct 2022
6 months

SPA Enhancement

PASM

  • Design, programming, testing
  • Support for backend development in MS Azure
  • Enhancement of the SQL Server database (Azure SQL)
  • Integration of Dynamics and SAP systems and Azure services
  • Creation of unit and integration tests
  • Support of requirements management
  • Writing required source code and test routines according to guidelines
  • Delivery of results to customer’s source control (commented code)
  • Technology: C#, ASP.NET Core, Scrum, DevOps, xUnit, StyleCop, Sonar
Jan 2022 - Apr 2022
4 months

Development of Microservices to Connect an Electronic Booking System to an Existing ERP System

dbh Logistic

  • Design, documentation, programming
  • Define interfaces, create services for various queries, embed web pages into the ERP tool
  • Technology: C#, Microservice, Docker, Web API, WebView2, DevOps
Oct 2021 - Dec 2021
3 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, development
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
May 2021 - Dec 2021
8 months

Software Enhancement

CRM for Insurance Agencies

  • Design, development, quality assurance
  • New features for the existing program
  • Upgrade of SQL Server to version 2019
  • Administration of two network environments (Windows Server 2016, SQL Server, Windows clients)
  • Maintenance of an intranet based on MS SharePoint 2016
  • Support of management software for insurance agencies
  • Online claims entry
  • Technology: VB.NET, C#, WPF, SQL Server 2019 (SSRS, SSDT), Azure, EF, LinqToSQL, .NET Core, Angular, List & Label
May 2021 - Sep 2021
5 months

Azure DevOps, SQL Server, Tools

Hessian State Bank

  • Various tasks for optimization and migration
  • Creating tasks for Azure DevOps build pipeline
  • Planning and executing migration from SQL Server 2002 to 2016
  • Programming various tools
  • Technology: C#, SQL Server (SSRS, SSIS), PowerShell, Azure DevOps, CI/CD
Jan 2021 - May 2021
5 months
Vienna, Austria

Design/Capture and Management of Patient Data

University of Vienna

  • Design
  • Created a concept for capturing patient data, examinations, and diagnoses for reporting
  • Application, database design
  • Developed a prototype as a web front end with microservices
  • Technology: C#, .NET Core, SQL Server, Entity Framework
Aug 2019 - Oct 2019
3 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, development
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Oct 2018 - May 2020
1 year 8 months
Munich, Germany

Enhancement and Maintenance of Middleware for Controlling Installation and Setup Processes and User Management

Munich Utilities

  • Design, documentation, programming
  • Enhancement of the CCM client: bug fixes and new features
  • Technology: C#, SQL Server 2012/2016, WCF, Web Service, Microsoft SCCM, Active Directory, DHCP Server, Cisco 802.1x system, OmniTracker
Oct 2018 - May 2020
1 year 8 months
Munich, Germany

Enhancement and Maintenance of an Office Add-in for Document Management

Munich Utilities

  • Design, documentation, programming
  • The add-in is used in every Office application at SWM for distributing forms, documents, and media
  • Adaptation for Windows 10 and Office 2016, plus bug fixes and new features
  • Technology: VSTO, C#, VB.NET, SQL Server 2012/2016, ADO DB
Oct 2018 - Apr 2019
7 months
Munich, Germany

Analysis and Documentation of Middleware for Controlling Installation and Setup Processes and User Management

Munich Utilities

  • Documentation, development
  • CCM is a service on Windows Server that handles user, permission, client, and software install commands and distributes tasks to servers. It sends callbacks to the admin tool. Communication to the admin tool is via SOAP/REST; to servers via API or web service. With no documentation, the source code had to be analyzed and documented.
  • Technology: C#, SQL Server 2012/2016, WCF, Web Service, Microsoft SCCM, Active Directory, DHCP Server, Cisco 802.1x system, OmniTracker
Jul 2018 - Nov 2018
5 months
Cham, Germany

Various Tools in the Disruptive Cloud Connector Production Process

Zollner AG

  • Design, development
  • Developed programs to support production and automatic registration of parts in the cloud
  • Labeling tool: prints labels and lasers parts with unique XIDs registered in a database
  • Test tool: after automated testing, parts are registered in customer cloud and test reports are uploaded
  • Assembly tool: assembles parts into the CloudConnector and registers them in customer cloud
  • Technology: C#, WPF, SQL Server, Entity Framework, Web Services, Google Cloud Services, Swagger
Mar 2018 - Jun 2018
4 months
Munich, Germany

Enhancement and Maintenance of an Office Add-in for Document Management

Munich Utilities

  • Design, development
  • The add-in is used in every Office application at SWM for distributing forms, documents, and media
  • Adaptation for Windows 10 and Office 2016, plus bug fixes and new features
  • Technology: VSTO, C#, VB.NET, SQL Server 2012/2016
Sep 2016 - Dec 2016
4 months

VETAS Software for Creating Vehicle Inspection Reports

TÜV Süd

  • Programming
  • Software for creating vehicle inspection reports, master data maintenance, and sync with central database
  • Technology: C#, WPF, Prism, Unity, Oracle
Jul 2016 - Dec 2016
6 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, programming
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Nov 2015 - Nov 2015
1 month
Munich, Germany

Automation of Existing Excel Files for In-house Controlling

Prose GmbH

  • Programming
  • Created various Excel files for controlling (e.g., cash flow planning, budget planning) across company divisions; files can be created, merged, and evaluated
  • Technology: Excel, VBA
Sep 2015 - Sep 2015
1 month
Munich, Germany

Preparation of Data from Various DBs in Excel

Wealth Management Capitol Holding

  • Design, programming
  • Prepped data from various databases and dynamically created an Excel sheet snapshot for a given date
  • Technology: Excel, VBA
May 2015 - Dec 2017
2 years 8 months
Munich, Germany

Tool for Collecting and Preparing Data from Multiple Sources; Excel Macro Development

Prose GmbH

  • Design, development
  • Developed a program to support in-house controlling. Data from accounting, project planning, budget planning, cash flow planning, etc., from various sources (Excel, CSV, databases, web services) for about 20 business units across countries are collected, saved in a DB, and output to various Excel reports.
  • Maintenance and enhancement of Excel files (VBA, macro programming)
  • Technology: C#, WPF, SQL Server 2014 (SSRS, SSDT), Entity Framework, Excel-VBA, Web Services, Azure
Apr 2015 - Feb 2013
-3 years -1 months

Software Enhancement

CRM for Insurance Agencies

  • Design, development, quality assurance
  • New features for the existing program
  • Technology: VB.NET, C#, WPF, SQL Server 2012, LinqToSQL
Mar 2015 - Oct 2015
8 months

Software Enhancement

CRM for Insurance Agencies

  • Design, development, quality assurance
  • New features for the existing program
  • Technology: VB.NET, C#, WPF, SQL Server 2012, LinqToSQL
Dec 2014 - Jun 2015
7 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, programming
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Oct 2014 - May 2015
8 months

PS Explorer: Software for Capturing and Managing Product Reports

TÜV Süd

  • Programming
  • Software for creating vehicle inspection reports, master data maintenance, and sync with central database
  • Technology: C#, Windows Forms, SQL Server, Entity Framework
Jul 2014 - Oct 2014
4 months

VETAS Software for Creating Vehicle Inspection Reports

TÜV Süd

  • Programming
  • Software for creating vehicle inspection reports, master data maintenance, and sync with central database
  • Technology: C#, WPF, Prism, Unity, Oracle
May 2014 - May 2014
1 month
Frankfurt, Germany

Expansion of Briefing Mailing Tool

PWC - PricewaterhouseCoopers AG

  • Design, programming
  • Added new functions to the tool
  • Technology: VB.NET (.NET 4.0), WPF, SQL Server Compact 3.5, SQL Server 2012
Mar 2014 - Oct 2014
8 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, programming
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Nov 2013 - Dec 2013
2 months
Frankfurt, Germany

Further Development of Excel Templates

ZVEI - Zentralverband der Elektroindustrie

  • Design, programming
  • Extension of Excel templates for data evaluation in the electrical industry
  • Technology: Excel, VBA
Aug 2013 - Oct 2013
3 months
Ingolstadt, Germany

Tool Development in the SVM-Codes Project

Audi AG

  • Design, programming
  • Program to manage software and hardware updates for Audi AG infotainment. Developed in Excel VBA with custom dialogs. XML import/export
  • Technology: Excel, VBA, XML
May 2013 - Jul 2013
3 months
Frankfurt, Germany

Expansion of Briefing Mailing Tool

PWC - PricewaterhouseCoopers AG

  • Design, programming
  • Added new functions to the tool
  • Migration from SQL Server Compact to SQL Server 2008
  • Technology: VB.NET (.NET 4.0), WPF, SQL Server Compact 3.5, SQL Server 2012
Mar 2013 - Jun 2013
4 months
Munich, Germany

Development of Tools to Control Windows Media Encoder

Online Congress GmbH

  • Design, programming
  • Developed a multi-instance wrapper for Windows Media Encoder and a program to control it
  • Technology: C#, Windows Media Controller
Mar 2012 - Mar 2012
1 month
Frankfurt, Germany

Excel Macros for Report Functions of the Briefing Mailing Tool

PWC - PricewaterhouseCoopers AG

  • Design, programming, quality assurance
  • Generated Excel lists from the mailing tool and processed them with macros
  • Technology: VB.NET, VBA
Sep 2011 - Feb 2012
6 months
Frankfurt, Germany

Development of a Briefing Mailing Tool

PWC - PricewaterhouseCoopers AG

  • Design, programming
  • Added new functions to the tool
  • Technology: VB.NET (.NET 4.0), WPF, SQL Server Compact 3.5
Aug 2010 - Aug 2011
1 year 1 month

New Development of Management Software for Insurance Agencies

CRM for Insurance Agencies

  • Design, development, quality assurance
  • Complete redevelopment of the original VB multi-user program for managing customers, contracts, appointments, documents
  • Technology: VB.NET, C#, WPF, SQL Server 2008, LinqToSQL
Mar 2010 - Aug 2011
1 year 6 months
Munich, Germany

Online Webshops

PGM – Poster Gallery Munich

  • Design, development, quality assurance
  • Developed a webshop
  • Technology: ASP.NET, C#, SQL Server 2008, AS/400 integration
Apr 2009 - Feb 2010
11 months

New Development of Management Software for Insurance Agencies

CRM for Insurance Agencies

  • Design, development, quality assurance
  • Complete redevelopment of the original VB multi-user program for managing customers, contracts, appointments, documents
  • Technology: VB.NET, C#, WPF, SQL Server 2008, LinqToSQL
Mar 2008 - Mar 2009
1 year 1 month
Munich, Germany

Enhancement and Maintenance of Medical Software

Sorin Group AG

  • Design, programming, quality assurance
  • Optimization and extension of an existing DMS (Data Management Software) for capturing, storing, and analyzing data from a heart-lung machine during surgery. Software includes client and server. Client runs in the OR and receives data via serial interface from the heart-lung machine.
  • Technology: Centura SQLWindows Version 2.0
Mar 2008 - Apr 2008
2 months
Munich, Germany

Consulting for the New Development of Medical Software

Sorin Group AG

  • Design
  • Alongside DMS maintenance, conducted feasibility study for complete redevelopment
Jun 2007 - Jan 2008
8 months

Development and Configuration of an Integration Platform

  • Design, programming
  • Analysis and modeling of business processes, setup of BizTalk environment, development
  • Technology: BizTalk 2004/2006
Jun 2007 - Jun 2007
1 month

Network Infrastructure Planning

  • Planning, execution
  • Designed and installed a network environment for an insurance agency with ~15 internal and 20 external workstations
  • Technology: SBS 2003/2008, ISA 2004/2006
Sep 2006 - Feb 2008
1 year 6 months
Bonn, Germany

Parts Management

Gutsche GmbH VW Ersatzteildienst

  • Design, programming, quality assurance
  • Multi-user program for warehouse, customer, order, and invoicing management
  • Technology: VB.NET, C#, SQL Server 2005
Jun 2005 - May 2025
20 years
Johanniskirchen, Germany

Firewall Installation and Setup

WVF GmbH

  • Design, execution, support
  • Installed, configured, and maintained firewall (ongoing support)
  • Technology: MS ISA Server 2004/2006, Forefront TMG
Feb 2003 - Oct 2007
4 years 9 months

Electronic Procedures for Justice in Bavaria (BajTech)

  • Design, test procedures, quality assurance
  • BajTech by Siemens SBS. Task: design and supervise development and testing of cost area billing, court-assigned counsel, legal aid, and new interface to state treasury. (with interruption)
  • Technology: UML modeling, Innovator, Java, Oracle

EQA - a Program to Support Self-Assessments in Companies for Total Quality Management

  • Design and development
  • Based on an Access database. Tool used by Telekom and Siemens
  • Project size: 10 MM
  • Technology: VB5, VBA

Electronic Land Registry SolumStar

  • Design, programming
  • Developed an editor as a Word replacement for SolumStar. Includes its own macro language and mail merge function.
  • Project size: 6 MM
  • Technology: C++

Websites and Small Web Applications Development

  • Technology: VB.NET, C#, ASP.NET, HTML, JavaScript, CSS

Warehouse Management

  • Design and development
  • Specialized warehouse management for an auto parts dealer
  • Project size: 5 MM
  • Technology: Access, VBA

Management Program for Insurance Agencies

  • Design, programming, quality assurance
  • In-house multi-user program to manage customers, follow-ups, contracts
  • Project size: 24 MM
  • Technology: VB6, VBA, Access, SQL Server

Imaging Client

Debis

  • Development
  • Client for viewing, editing, and archiving scanned documents
  • Project size: 9 MM
  • Technology: VB6, C++

Research Client and Viewer

FHG

  • Design and development
  • Research client querying an Oracle DB. Retrieved documents for editing. Viewer for image files.
  • Project size: 6 MM
  • Technology: VB6

Setup for Telephone Systems

Siemens Hicom

  • Design and development
  • Complex setup with multiple client tools for configuring and maintaining large Siemens Hicom telephone systems
  • Project size: 3 MM
  • Technology: InstallShield

Electronic Trade Register RegisStar

Siemens SBS

  • Design, development, quality assurance
  • RegisStar by Siemens SBS
  • Subprojects: billing, interface to state treasury; web query client
  • Project size: 36 MM
  • Technology: VB6, C++, Oracle

Client for a Data Warehouse Project

Siemens-Nixdorf

  • Design and development
  • Windows client for a Siemens-Nixdorf data warehouse project
  • Project size: 6 MM
  • Technology: VB6, C++, Informix, ODBC

Summary

  • Software development
  • Organization
  • Coordination
  • Quality assurance
  • Testing
  • Documentation

Languages

German
Native
English
Advanced
Italian
Advanced

Education

Lorem ipsum dolor sit amet

Computer Science

Certifications & licenses

BizTalk Server

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions