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 creating 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 Pricing
- Design, development and enhancement of custom software (backend) for an online portal to configure and price digital print products
- Review and extension of the database schema, implementation of a new configuration and pricing process, optimization/automation of workflows, performance analysis, database tuning
- Design and development of an admin client (MS Access) for maintaining and managing master data, configuring and pricing digital print products, and supplying data to 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 – Sales Price Calculation
- Enhancement 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
- Design, development and enhancement 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
- Design, development and enhancement of custom software for executing and optimizing business processes using suitable technologies (SQL Server, MS Access, MS Outlook)
- Design, development and enhancement of a process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD), SQL Server database administration, maintenance and development of 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 monthsConcept/Design/Development/Consulting – Sales Commission Management
- Conceptualizing/Designing/Developing/Enhancing 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 monthsConcept/Design/Development/Consulting – E-Commerce, Big Data
- Application development for a complex e-commerce system (couponing system, online shops, campaign automation) to meet GDPR requirements
- Implementing a complex concept for deleting personal data in a big data environment, creating tools for process optimization and automation (Unix, Oracle), developing interfaces for monitoring tools and processes
- OS: Windows 10, Unix/Solaris
- DB: Oracle 11/12
Apr 2018 - Feb 2023
4 years 11 monthsConcept/Design/Development/Consulting – Process Development and Optimization, DB Management
- Conceptualizing/Designing/Developing/Enhancing custom software for database management and support using technologies like SQL Server, MySQL, MS Access, MS Outlook
- Conceptualizing/Designing/Developing/Enhancing an existing Access application (client-server) for capturing, maintaining and analyzing database management data
- Optimizing database operations (Oracle, MS SQL Server, MySQL, PostgreSQL), integrating SharePoint to provide DB management data, automating operational processes, process development and optimization, planning and implementing a patch strategy, extending database monitoring with SCOM and OEM, designing and building a monitoring solution for MySQL databases, performance analysis, database tuning
- Conceptualizing and redeveloping 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 monthsConcept/Design/Development/Consulting – Kopano Mail Server
- Designing, installing and configuring a Kopano mail server (with Postfix and Fetchmail) including WebApp, operation and support
- OS: Ubuntu 10.04
- DB: MySQL
Mar 2018 - Feb 2023
5 yearsConcept/Design/Development/Consulting – Event Management
- Conceptualizing/Designing/Developing/Enhancing an existing application for capturing, maintaining and analyzing event management data
- Installing and configuring 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, integrating new features, connecting a media database, incident and change management with SharePoint, project leadership
- OS: Windows 10, Windows Server
- DB: MS Access 2016, SQL Server 2017
Apr 2016 - Jun 2016
3 monthsDesign/Development/Consulting – Sales Price Calculation
- Further development of an application for calculating sales prices for any items
- Connecting an existing warehouse data system via ODBC
- OS: Windows 7
- DB: MS Access 2010
Feb 2015 - Nov 2015
10 monthsDesign/Development/Consulting – Gastronomy, fully automated cocktail machine
- Further development of an existing application to control a fully automated 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 leadership
- OS: Windows XP/7
- DB: MS Access 2003 and 2010
Jul 2014 - Feb 2018
3 years 8 monthsDesign/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 promotions and coupon processing, creation of tools for process automation (Unix, Oracle), implementation of various modules and reports for data analysis and evaluation (Oracle), development 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 yearDesign/Development/Consulting – SharePoint Server
- Designing, installing, and configuring 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 monthsDesign/Development/Consulting – Price Comparison Data Management
- Designing and implementing an application for capturing, maintaining, and analyzing price comparison data
- Connecting an existing warehouse data system via ODBC, Excel export from MS Access
- OS: Windows 7
- DB: MS Access 2010
Mar 2012 - Jan 2014
1 year 11 monthsDesign/Development/Consulting – Supply Chain Management
- Development and enhancement of various back-end components of an application for master data management and maintenance in Supply Chain Management
- Creating and optimizing queries, implementing various reports and exports (e.g. Access, Excel, SharePoint), building several interface components (Data Warehouse, SAP), rollout management, incident management
- OS: Windows 7
- DB: SQL Server 2008, MS Access 2010
Mar 2011 - Feb 2018
7 yearsDesign/Development/Consulting – Event Management
- Further development of an existing application for capturing, maintaining and analyzing event management data, migrating to SQL Server as the backend database, performance tuning, integrating new features, incident and change request management with SharePoint, project management
- OS: Windows XP/7/10
- DB: MS Access 2010, SQL Server 2008
Sep 2010 - Dec 2017
7 years 4 monthsDesign/Development/Consulting – Zarafa Mail Server
- Designing, installing and configuring a Zarafa mail server (with Postfix and Fetchmail) including the web app, operation and support
- OS: Ubuntu 10.04
- DB: MySQL
Jul 2005 - Jul 2014
9 years 1 monthDesign/Development/Consulting – Construction Industry, Custom Software (ERP System)
- Implementing various modules for an existing system for central billing/result accounting, cost tracking, financial analysis, cost accounting, time tracking, participation management, subcontractor/supplier management, guarantee management, flat-rate tax tracking
- Extending existing interfaces to various connection systems (SAP, Dynamics, Navision); developing various admin tools; creating complex reporting tools; process administration; third-level support for all applications; migrating 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.