Ernst Hoefler

Senior Consultant

Ernst Hoefler
München, Germany

Experience

Feb 2022 - Jul 2023
1 year 6 months

Software Developer

Design/development/further development of custom software for handling business processes with suitable technologies (SQL Server, MS Access, MS Outlook), SQL Server database administration, support and further development of data warehouse, design/development/further development of a process for creating XML documents for electronic invoices / e-invoicing (XRechnung, ZUGFeRD), automation of operational processes, process development and optimization, configuration of web applications, administration and monitoring of a CRM

Mar 2021 - Jun 2021
4 months

Software Developer

Design/development/further development of an application for recording, maintaining and evaluating commission data for sales employees; connection to an existing inventory data system via ODBC

BS: Windows 10 P: Visual Basic, ODBC DB: MS Access 2013

Oct 2019 - Dec 2020
1 year 3 months

Software Developer

Application development for a complex e-commerce system (couponing system, online shops, campaign automation) to implement the requirements from the General Data Protection Regulation (GDPR), implementation of a complex concept for deleting personal data in the 'Big Data' environment, creation of tools for process optimization and automation (Unix, Oracle), creation of interfaces for monitoring tools and processes

BS: Windows 10, Unix/Solaris P: PL/SQL, SQL*Plus, Unix-/Solaris-Shell, SVN DB: Oracle 11/12

Apr 2018 - Feb 2023
4 years 11 months

Software Developer

Optimization of database operations (Oracle, MS SQL Server, MySQL , PostgreSQL), design/development/further development of custom software for managing and supporting databases with suitable technologies (SQL Server, mySQL, MS Access, MS Outlook), SharePoint integration for providing DB management data, automation of operational processes, process development and optimization, planning and implementation of a patch strategy, extension of database monitoring with SCOM and OEM, design and setup of a monitoring solution for MySQL databases, performance analyses, database tuning, Design/development/further development of an existing Access application (client-server) for recording, maintaining and evaluating database management data Design and new development of an Access application (client-server) for recording, maintaining and evaluating system information for MySQL databases

BS: Windows 7/10, Unix/Solaris DB: Oracle, MS SQL Server, MySQL, PostgreSQL, MS Access

Apr 2018 - Nov 2021
3 years 8 months

Software Developer

Design, installation and configuration of a Kopano mail server (with Postfix and Fetchmail) including WebApp, operation and support

BS: Ubuntu 10.04 DB: MySQL

Mar 2018 - Feb 2023
5 years

Software Developer

Design/development/further development of an existing application for recording, maintaining and evaluating event management data, installation and configuration SQL Server 2017, porting database and backend application from SQL Server 2008 to SQL Server 2017, performance tuning, porting frontend application from Windows 7/MS Office 2010 to Windows 10/MS Office 2016, integration of new functionalities, connection of a media database, incident and CR management with SharePoint, project management

BS: Windows 10 P: MS Access Basic, Transact-SQL, ODBC, Red Gate, SharePoint DB: MS Access 2016, SQL Server 2017

Apr 2016 - Jun 2016
3 months

Software Developer

Further development of an application for calculating sales prices for any articles; connection to an existing inventory data system via ODBC

BS: Windows 7 P: Visual Basic, ODBC DB: MS Access 2010

Feb 2015 - Nov 2015
10 months

Software Developer

Further development of an existing application for controlling a fully automatic cocktail machine, as well as for recording, maintaining and evaluating master and transaction data, general revision of the application, performance tuning, internationalization, integration of new functionalities, project management

BS: Windows XP/7 P: MS Visual Basic DB: MS Access 2003 and 2010

Jul 2014 - Feb 2018
3 years 8 months

Software Developer

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, creation 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

BS: Windows 7, Unix/Solaris P: PL/SQL, SQL*Plus, Unix-/Solaris-Shell, Control-M DB: Oracle 11/12

Feb 2014 - Jan 2015
1 year

Software Developer

Design, installation and configuration of a Sharepoint server (user management, web content management, collaboration, Access deployment), operation and support

BS: Windows Server 2012 DB: SQL Server 2012, MS Access 2013 P: SharePoint 2013

Dec 2013 - Jun 2015
1 year 7 months

Software Developer

Design and implementation of an application for recording, maintaining and evaluating price comparison data; connection to an existing inventory data system via ODBC; Excel export from MS Access

BS: Windows 7 P: Visual Basic, ODBC DB: MS Access 2010

Mar 2012 - Jan 2014
1 year 11 months

Software Developer

Creation and further development 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 evaluations and exports (including Access, Excel, SharePoint), creation of various interface components (Data Warehouse, SAP), rollout management, incident management

BS: Windows 7 P: Transact-SQL, ODBC, MS Access Basic, Red Gate, SharePoint DB: SQL Server 2008, MS Access 2010

Feb 2012 - Dec 2013
11 months

Software Developer

Creation of various interface components for automated data transmission between an application for master data management and maintenance in Supply Chain Management and a data warehouse database for data analysis (OLAP), creation and optimization of queries

BS: Windows 7 P: Transact-SQL, PL/SQL, SQL*Plus DB: SQL Server 2008, Oracle 10/11

Jul 2011 - Dec 2011
6 months

Software Developer

Further development of a cross-reference database for product comparison in Supply Chain Management, optimization of queries, implementation of various evaluations and further development of a product database in Supply Chain Management for creating load data for SQL Server, optimization of queries, implementation of various evaluations and exports (including Excel)

BS: Windows 7 P: MS Access Basic, Transact-SQL, ODBC DB: MS Access 2010, SQL Server 2008

Mar 2011 - Feb 2018
7 years

Software Developer

Further development of an existing application for recording, maintaining and evaluating event management data, conversion to SQL Server as backend DB, performance tuning, integration of new functionalities, incident and CR management with SharePoint, project management

BS: Windows XP/7/10 P: MS Access Basic, Transact-SQL, ODBC, Red Gate, SharePoint DB: MS Access 2010, SQL Server 2008

Dec 2010 - Apr 2011
5 months

Software Developer

Further development of an application for recording, maintaining and evaluating commission data for sales employees; connection to an existing inventory data system via ODBC

BS: Windows XP P: Visual Basic, ODBC DB: MS Access 2003

Sep 2010 - Dec 2017
7 years 4 months

Software Developer

Design, installation and configuration of a Zarafa mail server (with Postfix and Fetchmail) including WebAccess, operation and support

BS: Ubuntu 10.04 DB: MySQL

Jul 2010 - Dec 2013
2 years 6 months

Software Developer

Regional customer support as a specialist trade partner for the product family 'Beverage Industry / Beverage Cash Register / Inventory Management' (Windows-based inventory management system for the beverage wholesale trade), installation, configuration, operation and support

BS: Windows 2000/XP/7 DB: Paradox

Aug 2008 - Nov 2010
2 years 4 months

Software Developer

Design and implementation of a system for central management and execution of flash operations for memory components of various hardware (boards, displays) Setup of a suitable relational database; development of an administration tool; creation of complex evaluation tools

BS: Windows 2000/XP P: Transact-SQL, Visual Basic, ODBC DB: SQL Server 2000, MS Access

Mar 2008 - Dec 2010
2 years 10 months

Software Developer

Further development of an application to support marketing and sales processes; automated processing of standardized emails with transfer of customer master data to a marketing database, further development of modules for sending serial emails, for managing user access data and for dialog-controlled maintenance of customer master data; third level support

BS: Windows 2000/XP, Unix P: Visual Basic, ODBC DB: MS Access 2003

Feb 2008 - Jul 2008
6 months

Software Developer

Further development of an application for calculating sales prices for any articles; connection to an existing inventory data system via ODBC

BS: Windows 2000/XP P: Visual Basic, ODBC DB: MS Access 2003

Dec 2007 - Jan 2008
2 months

Software Developer

Design and implementation of an application for administrative monitoring of user accounts and data in Vault Stores under Exchange Server; validation via Active Directory among others

BS: Windows 2000/XP (Exchange Server, Active Directory) P: Visual Basic, ODBC DB: MS Access 2003, SQL Server 2000

Apr 2007 - Dec 2008
9 months

Software Developer

Design and implementation of an application to support marketing and sales processes; development of database design, automated processing of standardized emails with transfer of customer master data to a marketing database, implementation of modules for sending serial emails, for managing user access data and for dialog-controlled maintenance of customer master data

BS: Windows 2000/XP, Unix P: Visual Basic, ODBC DB: MS Access 2003

Dec 2006 - Dec 2008
1 year 1 month

Software Developer

Design and implementation of a program system for monitoring data transfer (monitoring) when exchanging customer master data between an Oracle DB and SAP R/3; development of database design, implementation of shell routines for loading SAP R/3 data, implementation of a module for detailed data analysis with recording of statistical information

BS: Sun-OS, Windows 2000 P: PL/ SQL, SQL*Plus, Shell DB: Oracle 8/9.x/10.x, SAP R/3

Jul 2006 - Jan 2007
7 months

Software Developer

Design and implementation of a program system for process and workflow support in recording customer master data; development of database design, implementation of supporting server routines

BS: Sun-OS, Windows 2000 P: PL/ SQL, SQL*Plus, Shell DB: Oracle 8/9.x/10.x, SAP R/3

Jul 2005 - Jul 2014
9 years 1 month

Software Developer

Implementation of various modules for an existing system for central operating accounting / profit and loss accounting, cost recording, financial analysis, cost accounting, time recording, investment management, subcontractor/supplier management, guarantee management, lump-sum tax recording; extension of existing interfaces to various connected systems (SAP, Dynamics, Navision); development of various administration tools; creation of complex evaluation tools; process administration; third level support for all applications; porting of several databases from MS SQL Server 2000 to 2008

BS: Windows 2000/XP/7 P: Transact-SQL, Visual Basic, ODBC, VSReport Designer DB: SQL Server 2000/2008, MS Access 2003/2010

May 2004 - Apr 2005
1 year

Software Developer

Implementation of various modules for consolidating a central system for managing customer master data; migration of complex data structures; distribution of customer master data (automated distribution to various connected systems); optimization of logging functions; data exchange with SAP R/3 via webMethods; creation of complex reports

BS: Sun-OS, Windows 2000 P: PL/ SQL, SQL*Plus, Shell DB: Oracle 8/9.x, SAP R/3

Mar 2004 - Jul 2004
5 months

Software Developer

Design and implementation of an application for calculating sales prices for any articles; connection to an existing inventory data system via ODBC

BS: Windows 2000/XP P: Visual Basic, ODBC DB: MS Access 2002

Dec 2003 - Apr 2004
5 months

Software Developer

Implementation of various modules for an existing system for central management of customer master data; extension of existing interfaces to various connected systems; optimization of logging functions

BS: Sun-OS, Windows 2000 P: PL/ SQL, SQL*Plus, Shell DB: Oracle 8/9.x

Nov 2003 - Nov 2003
1 month

Software Developer

Further development of a processing system for conducting the annual inventory based on an MS Access database; data exchange with an existing inventory data system via ODBC

BS: Windows 2000 P: Visual Basic, ODBC DB: MS Access 2002

May 2003 - Dec 2004
8 months

Software Developer

Implementation of various modules for a Supply Chain Management system for forecasting, planning and controlling the manufacturing process of memory components (chips, memory products); Implementation of an automated interface between Oracle DB and Business Objects to support a complex reporting system; optimization of frontend and backend modules

BS: Sun-OS 5.6, Windows 2000 P: PL/ SQL, SQL*Plus, Shell, Access Basic, VBA DB: Oracle 8.x, MS Access 2002, Business Objects

Feb 2003 - Apr 2003
3 months

Software Developer

Design and development of a demonstration application for a CRM system based on an existing sales information and sales processing system; design and creation of various sales and distribution documents (flyers, demo CD, description)

BS: Windows 2000/XP P: VBA, Access Basic DB: MS Access 2000

Jan 2003 - Apr 2003
4 months

Software Developer

Further development of a client management system for tax and law firms; automated data exchange with MS Word and MS Outlook; creation of a complex reporting system

BS: Windows 2000/XP P: MS Access Basic, Visual Basic (Word, Outlook) DB: MS Access 2000

Jan 2003 - Jan 2003
1 month

Software Developer

Design, design and further development of a website for an IT company (areas: consulting, CRM, etc.); use of a complex menu system, document management, forum, etc.

BS: Windows 2000/XP P: HTML, Siteforum DB: -

Oct 2002 - Dec 2003
3 months

Software Developer

Further development of a processing system for conducting the annual inventory based on an MS Access database; data exchange with an existing inventory data system via ODBC

BS: Windows 2000 P: Visual Basic, ODBC DB: MS Access 2002

Feb 2002 - Jul 2002
6 months

Software Developer

Design and implementation of an application for recording, maintaining and evaluating commission data for sales employees; connection to an existing inventory data system via ODBC

BS: Windows 2000 P: Visual Basic, ODBC DB: MS Access 2000

Sep 2001 - Sep 2002
1 year 1 month

Software Developer

Design and further development of existing interface modules for a sales information and sales processing system, data transfer in the network, data exchange with SAP R/3 Further development of a program for recording, maintaining and distributing master data for product configuration Project management for frontend development (multiple program versions) Creation of setup and installation routines Planning and execution of rollout (backend/frontend)

BS: Sun-OS 5.6, Windows 2000 P: PL/ SQL, SQL*Plus, Shell, Access Basic, VBA DB: Oracle 8.x, MS Access 2000, SAP R/3

Jul 2001 - Jul 2001
1 month

Software Developer

Further development of a processing system for conducting the annual inventory based on an MS Access database; connection to an existing inventory data system via ODBC

BS: Windows 2000 P: Visual Basic, ODBC DB: MS Access 2000

Mar 2001 - Aug 2001
6 months

Software Developer

Further development of existing interface modules for a sales information and sales processing system for regular data exchange between frontend and backend application Design and implementation of a program for recording, maintaining and distributing master data for product configuration

BS: Sun-OS 5.6, Windows 2000 P: PL/ SQL, SQL*Plus, Shell, Access Basic, VBA DB: Oracle 8.x, MS Access 2000, SAP R/3

May 2000 - Sep 2000
5 months

Software Developer

Further development of an existing Internet/Intranet application for recording and maintaining personnel data, Connection to MS Outlook

BS: Windows NT P: HTML, VBA DB: MS SQL-Server

Feb 2000 - Feb 2001
1 year 1 month

Software Developer

Design and implementation of an interface program for a sales information and sales processing system for regular data exchange between frontend and backend application, data transfer in the network, dynamic source code generation based on the current database model Further development of existing interface modules for a sales information and sales processing system, data transfer in the network, data exchange with SAP R/3 Further development of administration tools for controlling the data exchange with SAP R/3 Design and implementation of tools for software archiving and distribution Design and implementation of migration programs for database and computer merging Design and implementation of programs for process parallelization

BS: Sun-OS 5.6, Windows 95 P: PL/ SQL, SQL*Plus, Shell, Access Basic, VBA DB: Oracle 7.2 and 7.3, MS Access 2000, SAP R/3

Jan 1999 - Apr 2002
2 years 4 months

Software Developer

Further development of a client management system for tax and law firms; automated data exchange with Word; multi-user environment

HW: IBM-compatible PCs BS: Windows 2000 P: MS Access Basic, Word Basic, Visual Basic DB: MS Access 2000

Mar 1999 - Jan 2000
11 months

Software Developer

Further development of existing interface modules for a sales information and sales processing system, data transfer in the network, data exchange with SAP R/3 Design and implementation of controlling tools for monitoring the interfaces between Oracle DB and SAP R/3 Design and implementation of administration tools for controlling the data exchange with SAP R/3 Tuning and process parallelization, HW centralization Maintenance, error correction and further development of a sales information and sales processing system based on an MS Access database

BS: Windows 95, SINIX 5.4x P: Access Basic, PL/ SQL, SQL*Plus, Shell DB: MS Access 2.0, Oracle 7.2 and 7.3, SAP R/3

Jan 1998 - Jul 1999
7 months

Software Developer

Design and implementation of various maintenance and evaluation programs for an existing MS Access database for managing personnel data

BS: Windows NT P: Visual Basic, ODBC DB: MS Access 7.0

Dec 1998 - Dec 1998
1 month

Software Developer

Design and implementation of a processing system for conducting the annual inventory based on an MS Access database; connection to an existing inventory data system via ODBC

BS: Windows 95 P: Visual Basic, ODBC DB: MS Access 7.0

May 1998 - Feb 1999
10 months

Software Developer

Design and implementation of several interface modules for a sales information and sales processing system, database processing and merging, data transfer in the network, data exchange with SAP R/3

BS: SINIX 5.4x P: PL/ SQL, SQL*Plus, Shell DB: Oracle 7.2 and 7.3, SAP R/3

Apr 1998 - Apr 1998
1 month

Software Developer

Further development of an application for creating complex health insurance annual business reports under MS Excel based on an Informix database

HW: IBM-compatible PCs BS: Windows 95, SINIX 5.4x P: Visual Basic, SINIX-Shell DB: Informix 7.22

May 1997 - Mar 1998
11 months

Software Developer

Creation of various hotline tools for maintaining and managing user and printer data in the operating system as well as in various health insurance database systems

BS: SINIX 5.4x P: Shell, C, SQL, ESQL/C DB: Informix 7.14 and 7.22

May 1997 - Jan 1998
9 months

Software Developer

Design and implementation of a management system for questions and answers based on an MS Access database; dialog interface for conducting specific surveys of individual credit institutions

HW: IBM-compatible PCs BS: Windows 95 P: Visual Basic DB: MS Access 7.0

Feb 1997 - Apr 1998
1 year 3 months

Software Developer

Design and implementation of an information system for inventory master data; interface program for automatic data provision; design and implementation of an evaluation system for analyzing financial accounting data based on an MS Access database

BS: MS-DOS 6.0, Windows 3.1, Windows 95 P: MS Access Basic, Word Basic, Visual Basic DB: MS Access 2.0 and 7.0

Feb 1997 - Apr 1997
3 months

Software Developer

Design and implementation of a management system for project progress tracking; connection to Word; multi-user environment

BS: MS-DOS 6.0, Windows 3.1, Windows 95 P: MS Access Basic, Word Basic, Visual Basic DB: MS Access 2.0 and 7.0

Feb 1997 - Apr 1997
3 months

Software Developer

Design and implementation of various routines for connecting a personnel data information system (based on an MS Access database) to a BS2000 personnel data system (based on an Oracle database)

BS: MS-DOS 6.0, Windows 3.1, Windows 95, BS2000 P: Visual Basic, ODBC DB: MS Access 2.0 and 7.0, Oracle

Sep 1996 - Dec 1997
4 months

Software Developer

Implementation of various maintenance, management and interface programs for a health insurance database system

BS: SINIX 5.x P: C, SQL, ESQL/C, Shell DB: Informix 6.x and 7.x

Jul 1996 - Jan 1997
7 months

Software Developer

Design and implementation of an evaluation system for data center error messages (based on an MS Access database); integration of a complex reporting system; connection to Word; multi-user environment

BS: MS-DOS 6.0, Windows 3.1, Windows 95 P: MS Access Basic, Word Basic, Visual Basic DB: MS Access 2.0 and 7.0

Aug 1995 - Oct 1998
3 years 3 months

Software Developer

Design and implementation of a client management system for tax and law firms; automated data exchange with Word; multi-user environment

BS: MS-DOS 6.0, Windows 3.1, Windows 95 P: MS Access Basic, Word Basic, Visual Basic DB: MS Access 2.0, 7.0 and 8.0

Apr 1995 - Jul 1995
4 months

Software Developer

Creation of an interface program for data exchange between two radiation protection management systems; porting of the application from MS-DOS to SINIX

BS: SINIX 5.x, MS-DOS 5.0 P: SQL, ESQL/C, Shell, Batch DB: Informix

Feb 1995 - Jul 1995
6 months

Software Developer

Design of a customer information system and a management system for customer and product data

BS: MS-DOS 6.0, Windows 3.1 P: MS Access Basic DB: MS Access 2.0

Jul 1994 - May 1995
11 months

Software Developer

Design and development of an individual marketing system (based on an already existing system with basic functionality) for recording and maintaining planning and customer data

BS: MS-DOS 5.0 P: FoxPro, Batch DB: FoxPro

Mar 1994 - Mar 1994
1 month

Software Developer

Conversion of Word and WordPerfect documents for use in a retrieval system

BS: MS-DOS, Windows 3.1 P: Word Basic, Batch

Jun 1993 - May 1996
3 years

Software Developer

Porting of a sales information and sales processing system from SINIX to MS-DOS with graphical interface, conversion to client/server architecture; development of an interface to SAP R/3

BS: SINIX 5.x, MS-DOS 6.0, Windows 3.1 P: C, SQL, ESQL/C, 4GL, OPL, Shell, Word Basic DB: Informix, DBA.D

Nov 1992 - Oct 1993
1 year

Software Developer

Creation of various routines for a transfer data processing system

BS: SINIX, MS-DOS P: C, SQL, ESQL/C, 4GL DB: Informix

Jan 1991 - Mar 1992
1 year 3 months

Software Developer

Creation of various routines for an improvement suggestion management system

BS: SINIX, MS-DOS P: C, SQL, ESQL/C, 4GL DB: Informix

May 1990 - May 1993
3 years 1 month

Software Developer

Creation of various modules for a sales information and sales processing system, database processing and merging, data transfer in the network

BS: SINIX P: C, SQL, ESQL/C, 4GL, Shell DB: Informix

Feb 1990 - Sep 1995
5 years 8 months

Software Developer

Extension and tuning of a radiation protection management system, porting of the application from SINIX NSC to SINIX Intel

BS: SINIX, MS-DOS P: SQL, ESQL/C, Shell DB: Informix

Nov 1989 - Dec 1989
2 months

Software Developer

Tuning and performance measurement of an existing Informix-ESQL/C application

BS: MS-DOS P: SQL, ESQL/C DB: Informix

Jan 1988 - Present
36 years 2 months
Munich, Germany

Self-employed IT Consultant

  • Design, programming and implementation of relational databases
  • Application development for relational databases
  • Optimization of business processes
  • 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)
  • Creation of graphical user interfaces (Windows, MS Office)
  • Solaris/UNIX/SINIX shell programming
  • SharePoint / SharePoint Server
  • Mail servers (Kopano, Zarafa)
  • BRM system 'infra-struktur' (Business Relationship Management)
  • Beverage industry / beverage cash register / inventory management (beverage wholesale)
  • Design, programming and implementation of websites
  • Creation of installation programs (setup)
  • Macro programming (Word, Excel, etc.)
Aug 1987 - Jul 1988
1 year

Software Developer

Porting of a BTX application

BS: BS2000, SINIX P: C, SQL, ESQL/C, Cobol, Pascal DB: Informix

Apr 1987 - Sep 1989
2 years 6 months

Software Developer

Development, maintenance and application development of a sales-supporting marketing database

BS: SINIX P: SQL, ESQL/C, Shell DB: Informix

Jul 1985 - Aug 1985
2 months

Software Developer

Extension of a data center accounting system

BS: BS2000 P: Assembler

Summary

Design, Programmierung und Einsatz von relationalen Datenbanken Applikationsentwicklung für relationale Datenbanken Optimierung von Geschäftsprozessen E-Invoicing / Electronic Invoices (XML, XRechnung, ZUGFeRD) Konzipierung und Realisierung von Schnittstellenprogrammen Performance-Tuning für relationale Datenbanken Migration und Software-Portierung Client-Server-Lösungen Anwendungsentwicklung (Konzipierung und Realisierung) CRM-Systeme (Customer Relationship Management) Erstellung graph. Benutzeroberflächen (Windows, MS Office) Solaris/UNIX/SINIX-Shell-Programmierung SharePoint / SharePoint-Server Mail-Server (Kopano, Zarafa) BRM-System 'infra-struktur' (Business Relationship Management) Getränkewirtschaft / Getränkekasse / Warenwirtschaft (Getränkefachgroßhandel) Design, Programmierung und Einsatz von Websites Erstellung von Installationsprogrammen (Setup) Makro-Programmierung (Word, Excel, dgl.)

Languages

German
Native
English
Advanced

Education

Oct 1984 - Jun 1988

Fachhochschule München

Wirtschaftsinformatik · Munich, Germany