Freelancer profile translated to English.

Description

I am particularly enthusiastic about Excel and the diverse possibilities for optimization and automation with VBA. But I am also a database person. Structured data belongs in a database. Preferably with Access as the frontend, and MySQL, MS SQL Server, and Oracle as the backend.

Languages

German
Native or bilingual
English
Basic

Workplace preferences

Can work on-site

Heideck (up to 50km), Nürnberg (up to 100km), München (up to 100km), Berlin (up to 100km), Frankfurt am Main (up to 100km), Stuttgart (up to 100km)

Projekt
Further Development of Excel Tools with VBA
BANKING AND INSURANCE
July 2011 - March 2019 (7 years and 8 months)
Ismaning, Germany
• Further development and conversion of the data source for million-credit reporting to the Bundesbank
• Conversion of an Excel tool to an Access frontend
• Storage of transaction data in the SQL Server
• Creation of Word mail merges from Excel and filling them with data from the SQL Server.
• Conversion of Excel and text data sources to SQL Server basis. (DAO to ADO).
• Migration from Excel 2000 to 2010
• Revision of Excel macros, error correction, establishment and documentation of new functions
VBA Microsoft Excel Microsoft Access SQL Server ODBC Microsoft Word
Projekt
Extension of Existing Access Frontends
ENVIRONMENTAL
July 2011 - Today (15 years)
Augsburg, Germany
• Implementation of GDPR for forgetting personal data
• Use of a signature pad with storage of the entered signature in the database
• New application for recording and evaluating temporary workers
• Import and preparation of Tebis data (Steinhaus ODBC) (forms, reports, output to Excel)
Microsoft Access Microsoft Excel VBA Oracle ODBC SevTools
Projekt
Excel Article List for Upload to SAP
PHARMACEUTICALS INDUSTRY
August 2019 - August 2019
Raubling, Germany
• Create Ribbon Band
• Various filter views (display only the fields/columns necessary for the department)
• Check if required data is available
• Generate email with file link
• Create upload file
Microsoft Excel VBA Outlook XML for Ribbon Band

Be the first to recommend Werner

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Programmer
Ingolstadt
1987
Grundlagen Datenverarbeitung Grundlagen Programmierung Programmieren in GW Basic Programmierern in Cobol

Other

Werner Ebner

VBA Programmer, Database, Trainer

About Werner

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories