Ernst Höfler
Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD
Experience
Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD
- Support and enhancement of a complex process for creating XML documents for electronic invoices / e-invoicing (XRechnung, ZUGFeRD)
- Automation of operational processes, process development and optimization
- Development of frontend applications with MS Power Apps
- Porting SQL Server 2016 to SQL Server 2022
- Database administration for SQL Server
Design/Development/Consulting – Digital Print Products, Configuration and Pricing
- Design, development and further development of custom software (backend) for an online portal for configuring and pricing digital print products
- Review and extension of the database structure
- Implementation of a new configuration and pricing process
- Optimization/automation of process flows
- Performance analysis and database tuning
- Design and development of an admin client (MS Access) for maintaining and managing master data
- Data provisioning for the web frontend
- Project management with Taiga
Design/Development/Consulting – Calculation of Sales Prices
- Further development of an application for calculating sales prices for any items
- Connection of an existing warehouse data system (MS SQL Server)
Design/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD
- Design, development and further development of various routines for handling business processes with SQL Server, MS Access and MS Outlook
- Automation of operational processes (office automation, electronic invoices / e-invoicing, XRechnung, ZUGFeRD)
Design/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD
- Design, development and further development of custom software for handling and optimizing business processes with SQL Server, MS Access and MS Outlook
- Design and further development of a process for creating XML documents for electronic invoices (XRechnung, ZUGFeRD)
- SQL Server database administration
- Support and further development of the data warehouse
- Automation of operational processes, process development and optimization
- Configuration of web applications
- Administration and monitoring of a CRM application
- Performance analysis and database tuning
- Porting SQL Server 2014 to SQL Server 2019
Concept/Development/Consulting – Sales commission management
- Concept, development and further development of an application to record, maintain and analyze commission data for sales staff
- Connection of an existing warehouse data system via ODBC
Concept/Development/Consulting – E-Commerce, Big Data
- Application development for a complex e-commerce system (couponing system, online shops, campaign automation) to implement GDPR requirements
- 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
Concept/Development/Consulting – Process development and optimization, database administration
Concept, development and further development of custom software to manage and maintain databases with SQL Server, MySQL, MS Access and MS Outlook
Concept and further development 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 operations, process development and optimization
Planning and implementation of a patch strategy
Expansion of database monitoring with SCOM and OEM
Concept and setup of a monitoring solution for MySQL databases
Performance analysis and database tuning
Concept and new development of an Access application (client-server) for capturing, maintaining and analyzing asset information for MySQL databases
Concept/Development/Consulting – Kopano mail server
- Designing, installing and configuring a Kopano mail server (with Postfix and Fetchmail) including WebApp
- Operation and support
Concept/Development/Consulting – Event management
- Design, development and further development of an existing application for capturing, maintaining and analyzing event management data
- Installation and configuration of SQL Server 2017
- Migration of database and backend application from SQL Server 2008 to SQL Server 2017
- Performance tuning
- Migration of 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
Concept/Development/Consulting – Calculation of Sales Prices
- Further development of an application for calculating sales prices for any items
- Connection to an existing inventory data system via ODBC
Concept/Development/Consulting – Hospitality, Fully Automated Cocktail Machine
- Further development of an existing application for controlling a fully automated cocktail machine and for capturing, maintaining, and analyzing master and transaction data
- General overhaul of the application
- Performance tuning
- Internationalization
- Integration of new features
- Project management
Concept/Development/Consulting – E-commerce, Business Process Management
- Partner and Application Support for a complex e-commerce system (couponing system, online shops)
- Online Quality Management and 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
Concept/Development/Consulting – SharePoint Server
- Design, installation, and configuration of a SharePoint server (user management, web content management, collaboration, access deployment)
- Operation and support
Concept/Development/Consulting – Management of Price Comparison Data
- Design and implementation of an application for capturing, maintaining, and analyzing price comparison data
- Connection to an existing inventory data system via ODBC
- Excel export from MS Access
Concept/Development/Consulting – Supply Chain Management
- Development and enhancement of various backend components of an application for master data management and maintenance in Supply Chain Management
- Creation and optimization of queries, implementation of various reports and exports (Access, Excel, SharePoint)
- Development of various interface components (Data Warehouse, SAP)
- Rollout management and incident management
Concept/Development/Consulting – Event Management
- Further development of an existing application for capturing, maintaining, and analyzing event management data
- Migration to SQL Server as the backend database
- Performance tuning
- Integration of new features
- Incident and change request management with SharePoint
- Project lead
Concept/Development/Consulting – Zarafa Mail Server
- Designing, installing, and configuring a Zarafa mail server (with Postfix and Fetchmail), including the WebApp
- Operation and support
Concept/Development/Consulting – Construction Industry, Custom Software (ERP System)
- Implementation of various modules for a system for central operational accounting / profit calculation, cost tracking, financial analysis, cost accounting, time tracking, participation management, subcontractor and supplier management, guarantee management, and flat-rate tax recording
- Enhancement of existing interfaces to SAP, Dynamics, and Navision
- Development of administration tools and complex analysis tools
- Process administration
- Third-level support for all applications
- Porting multiple databases from MS SQL Server 2000 to 2008
Skills
Special Expertise
- Design, Programming And Deployment Of Relational Databases
- Application Development For Relational Databases
- Business Process Optimization
- E-invoicing / Electronic Invoices (Xml, Xrechnung, Zugferd)
- Design And Implementation Of Interface Programs
- Performance Tuning For Relational Databases
- Migration And Software Porting
- Client-server Solutions
- Application Development (Design And Implementation)
- Crm Systems (Customer Relationship Management)
- Solaris/unix/sinix Shell Programming
- Sharepoint / Sharepoint Server
- Mail Servers (Kopano, Zarafa)
- Design, Programming And Deployment Of Websites
Key Focus Of Recent Projects
- Agile Software Development
- Development Of Various Applications In The Sql Server And Windows Environment
- Development Of Business Processes For E-invoicing (Electronic Invoices)
- Implementation Of Custom Software (Windows, Ms Access, Vba, Sharepoint)
- Further Development/migration Of Access Databases (Various Use Cases)
- Design And Implementation Of Interfaces (Oracle / Sql Server)
- Business Process Optimization
- Project Leadership / Project Management
- Process Optimization / Monitoring In An E-commerce Environment
- Development Of Various Applications In The Oracle And Unix/solaris Environment
- Customer Relationship Management
- Online Quality Management / Business Process Management
- Data Deletion (Big Data)
Databases
- Ms Sql Server (Transact-sql)
- Oracle (Pl/sql, Sql*plus)
- Ms Access
- Mysql
- Postgresql
- Informix (Sql, Esql/c, 4gl Under Online And Se)
Operating Systems
- Windows / Windows Server
- Sunos (Solaris), Unix, Ubuntu
- Ms-dos
Programming Languages
- Transact-sql (Ms Sql Server)
- Pl/sql, Sql*plus (Oracle)
- Visual Basic (Vba, Ms Access, Ms Word, Ms Excel, Ms Outlook)
- Sql, Esql/c, 4gl (Informix)
- Shell (Solaris, Unix, Sinix, Ubuntu)
- Ms-dos Batch, Windows Powershell
- Html
- Python
- C
Tools
- Sql Server Enterprise Manager, Sql Query Analyzer, Ssms
- Sql Server Integrated Services (Ssis), Sql Server Report Services (Ssrs)
- Ms Visual Studio
- Ms Power Apps
- Toad, Pl/sql-developer, Oracle Sql Developer
- Red Gate Sql (Data) Compare
- Mysql Workbench
- Confluence Wiki Software (Atlassian)
- Sharepoint, Sharepoint Designer
- Servicenow, Iet Itsm (Integrated Service Level Management)
- Svn (Subversion), Tortoisesvn, Visualsvn Server
- Rcs, Cvs, Wincvs
- Control-m
- Joomla (Cms)
- Nextcloud
- Taiga (Project Management)
- Idoc (Sap)
- Webmethods
- Awk / Sed
Areas Of Work / Methods
- Accounting / Electronic Invoices
- Agile Software Development / Prototyping / Scrum
- Application Development / Custom Software Development
- Order Processing
- Business Process Management
- Controlling
- Customer Relationship Management
- Database Administration
- Database Design / Data Modeling / Relational Databases
- Devops / Continuous Delivery
- E-commerce (Couponing, Online Shops, Promotions, Online Quality Management)
- E-invoicing / Electronic Invoices (Xml, Xrechnung, Zugferd)
- Full Stack Development
- Business Process Optimization
- Incident Management
- Internet/intranet Development
- Design And Implementation
- Mail Servers, Messaging
- Marketing / Sales
- Migration / Porting
- Monitoring (Processes, Databases)
- Project Leadership / Project Management / Project Controlling
- Rollout
- Interfaces
- Supply Chain Management
- Support
- System Administration
- Tuning
- Workflow
Languages
Education
Munich University of Applied Sciences
Business Informatics · Munich, Germany
Similar Freelancers
Discover other experts with similar qualifications and experience