Ernst H.
Support/Development/Consulting – Process development, E-Invoicing, XRechnung, ZUGFeRD
Experience
Jan 2025 - Jun 2025
6 monthsSupport/Development/Consulting – Process development, E-Invoicing, XRechnung, ZUGFeRD
- Support and further development of a complex process for generating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD)
- Automation of operational workflows, process development and optimization, SQL Server database administration
- OS: Windows 10, Windows Server
- DB: MS SQL Server, MS Access
Mar 2024 - Jun 2025
1 year 4 monthsConcept/Development/Consulting – Digital print products, configuration and calculation
- Concept/development/further development of custom software (backend) for an online portal for configuration and calculation of digital print products
- Review and extension of the database structure, implementation of a new configuration and calculation process, optimization/automation of workflows, performance analysis, database tuning
- Concept and development of an admin client (MS Access) for maintaining and managing master data, configuration and calculation of digital print products, data provisioning for the web frontend
- Project management with Taiga
- OS: Windows 10, Windows Server
- DB: MS SQL Server 2016/2019, MS Access 365
Nov 2023 - Mar 2024
5 monthsConcept/Development/Consulting – Calculation of sales prices
- Further development of an application for calculating sales prices for any items
- Integration of an existing inventory data system (MS SQL Server)
- OS: Windows 11
- DB: MS SQL Server, MS Access 365
Sep 2023 - Dec 2024
1 year 4 monthsConcept/Development/Consulting – Process development, E-Invoicing, XRechnung, ZUGFeRD
- Concept/development/further development of various routines for handling business processes using suitable technologies (SQL Server, MS Access, MS Outlook)
- Automation of operational workflows (office automation, electronic invoices / E-Invoicing, XRechnung, ZUGFeRD)
- OS: Windows 11, Windows Server
- DB: MS SQL Server, MS Access 365
Feb 2022 - Jul 2023
1 year 6 monthsConcept/Development/Consulting – Process development, E-Invoicing, XRechnung, ZUGFeRD
- Concept/development/further development of custom software to handle and optimize business processes using suitable technologies (SQL Server, MS Access, MS Outlook)
- Concept/development/further development of a process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD), SQL Server database administration, support and further development of a data warehouse, automation of operational workflows, process development and optimization, configuration of web applications, administration and monitoring of a CRM application, performance analysis, database tuning
- Porting SQL Server 2014 to SQL Server 2019
- OS: Windows 10, Windows Server
- DB: MS SQL Server, MS Access
Mar 2021 - Jun 2021
4 monthsDesign/Development/Consulting – Sales Commission Management
- Design, development and enhancement of an application for capturing, maintaining and analyzing commission data for sales staff
- Connecting an existing warehouse data system via ODBC
- OS: Windows 10, Windows Server
- DB: MS Access 2013
Oct 2019 - Dec 2020
1 year 3 monthsDesign/Development/Consulting – E-Commerce, Big Data
- Application development for a complex e-commerce system (coupon system, online shops, campaign automation) to meet the requirements of the General Data Protection Regulation (GDPR)
- Implementation of a complex concept for deleting personal data in a Big Data environment, creation of tools for process optimization and automation (Unix, Oracle), development of interfaces for monitoring tools and processes
- OS: Windows 10, Unix/Solaris
- DB: Oracle 11/12
Apr 2018 - Feb 2023
4 years 11 monthsDesign/Development/Consulting – Process Development and Optimization, Database Administration
- Design, development and enhancement of custom software for database management and support using suitable technologies (SQL Server, MySQL, MS Access, MS Outlook)
- Design, development and enhancement of an existing Access application (client-server) for capturing, maintaining and analyzing database administration data
- Optimization of database operations (Oracle, MS SQL Server, MySQL, PostgreSQL), SharePoint integration to provide database administration data, automation of operational processes, process development and optimization, planning and implementation of a patch strategy, expansion of database monitoring with SCOM and OEM, design and setup of a monitoring solution for MySQL databases, performance analysis, database tuning
- Design and redevelopment of an Access application (client-server) for capturing, maintaining and analyzing asset information for MySQL databases
- OS: Windows 7/10, Unix/Solaris
- DB: Oracle, MS SQL Server, MySQL, PostgreSQL, MS Access
Apr 2018 - Nov 2021
3 years 8 monthsDesign/Development/Consulting – Kopano Mail Server
- Design, installation and configuration of a Kopano mail server (with Postfix and Fetchmail) including WebApp, operation and support
- OS: Ubuntu 10.04
- DB: MySQL
Mar 2018 - Feb 2023
5 yearsDesign/Development/Consulting – Event Management
- Design, development and enhancement of an existing application for capturing, maintaining and analyzing event management data
- Installation and configuration of SQL Server 2017, porting the database and backend application from SQL Server 2008 to SQL Server 2017, performance tuning, porting the frontend application from Windows 7/MS Office 2010 to Windows 10/MS Office 2016, integration of new features, connection to a media database, incident and change request management with SharePoint, project management
- OS: Windows 10, Windows Server
- DB: MS Access 2016, SQL Server 2017
Apr 2016 - Jun 2016
3 monthsConcept/Development/Consulting – Sales Price Calculation
- Further development of an application for calculating sales prices for any items
- Connection of an existing inventory data system via ODBC
- OS: Windows 7
- DB: MS Access 2010
Feb 2015 - Nov 2015
10 monthsConcept/Development/Consulting – Hospitality, Fully Automatic Cocktail Machine
- Further development of an existing application to control a fully automatic cocktail machine, as well as for capturing, maintaining and analyzing master and transaction data
- General overhaul of the application, performance tuning, internationalization, integration of new features, project management
- OS: Windows XP/7
- DB: MS Access 2003 and 2010
Jul 2014 - Feb 2018
3 years 8 monthsConcept/Development/Consulting – E-Commerce, Business Process Management
- Partner and application support for a complex e-commerce system (couponing system, online shops)
- Online quality management, business process management, process support and optimization for promotion and coupon processing, development of tools for process automation (Unix, Oracle), implementation of various modules and reports for data analysis and evaluation (Oracle), creation of monitoring tools and processes, third-level support for various applications
- OS: Windows 7, Unix/Solaris
- DB: Oracle 11/12
Feb 2014 - Jan 2015
1 yearConcept/Development/Consulting – SharePoint Server
- Design, installation and configuration of a SharePoint server (user management, web content management, collaboration, Access deployment)
- Operation and support
- OS: Windows Server 2012
- DB: SQL Server 2012, MS Access 2013
Dec 2013 - Jun 2015
1 year 7 monthsConcept/Development/Consulting – Price Comparison Data Management
- Design and implementation of an application for capturing, maintaining and analyzing price comparison data
- Connection of an existing inventory data system via ODBC, Excel export from MS Access
- OS: Windows 7
- DB: MS Access 2010
Mar 2012 - Jan 2014
1 year 11 monthsConcept/Development/Consulting – Supply Chain Management
- Developed and enhanced various backend components of an application for master data management and maintenance in supply chain management
- Created and optimized queries, implemented various reports and exports (e.g., Access, Excel, SharePoint), built interface components (Data Warehouse, SAP), handled rollout management and incident management
- OS: Windows 7
- DB: SQL Server 2008, MS Access 2010
Mar 2011 - Feb 2018
7 yearsConcept/Development/Consulting – Event Management
- Enhanced an existing application for capturing, maintaining, and analyzing event management data, migrated backend to SQL Server, performed performance tuning, integrated new features, managed incidents and change requests with SharePoint, led the project
- OS: Windows XP/7/10
- DB: MS Access 2010, SQL Server 2008
Sep 2010 - Dec 2017
7 years 4 monthsConcept/Development/Consulting – Zarafa Mail Server
- Designed, installed, and configured a Zarafa mail server (with Postfix and Fetchmail), including the web app; handled operations and support
- OS: Ubuntu 10.04
- DB: MySQL
Jul 2005 - Jul 2014
9 years 1 monthConcept/Development/Consulting – Construction Industry, Custom Software (ERP System)
- Implemented various modules for an existing system for central company accounting / result reporting, cost tracking, financial analysis, cost accounting, time tracking, equity management, subcontractor/supplier management, guarantee management, and flat tax recording
- Extended existing interfaces to various connected systems (SAP, Dynamics, Navision); developed administration tools; created complex reporting tools; managed processes; provided third-level support for all applications; migrated multiple databases from MS SQL Server 2000 to 2008
- OS: Windows 2000/XP/7, Windows Server
- DB: SQL Server 2000/2008, MS Access 2003/2010
Languages
German
NativeEnglish
AdvancedEducation
Oct 1984 - Jun 1988
Munich University of Applied Sciences
Business Informatics · Munich, Germany
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.