Collaborated in developing an application to generate retrocession reports focusing on frontend development with Microsoft Access, also backend development with SQL Server.
Agile software development with Azure DevOps.
Mar 2019 - Dec 2019
10 months
Munich, Germany
Database Developer
Munich Re
Took over an existing SQL Server database, documented the current state, maintained it.
Created a tool for automated rollout of new database versions (using SQLCMD, T-SQL, and batch scripting).
Created migration scripts to migrate the old database into the new structure.
Worked with GIT and agile methodology.
Regular exchange with team members and users.
Gained insight into general insurance topics (layers, towers etc.).
Apr 2006 - Jan 2018
11 years 10 months
Munich, Germany
Software Developer
Prodeus
Further development of IBM Rational ClearQuest workflows in Munich.
Direct contact with end customers Infineon and Intel.
Developed new features based on customer requirements.
Prepared documentation and specifications in English.
Participated in requirements engineering.
Developed web services and tools in VB.net.
Extensive access to the underlying SQL Server database.
Extensive work with Microsoft SQL Server.
Created scripts and stored procedures in T-SQL for data migrations and to extend the functionality of the ClearQuest standard solution.
For example, developed a complex system of stored procedures and database functions in T-SQL to delete complex data objects.
VB-Script development, also for migration and feature extension.
Sep 2004 - Dec 2005
1 year 4 months
Software Developer
DAB-Bank
Designed and implemented Access applications for data consolidation (large-scale duplicate cleanup).
The Access applications consist largely of VBA code.
Also accessed an Oracle database via ODBC.
Developed additional Access tools for bank employees.
Carried out cleanup operations on a remote database (created change messages via Access VBA, extensive analysis and coordination tasks).
Apr 2002 - Mar 2004
2 years
Web Developer
cukk
Implemented a website that allows customers like auto repair shops to enter data on waste generation, energy consumption, etc. interactively into a database.
As a result, they receive various reports, e.g. a "waste balance" or comparative analyses.
I implemented the website using ASP (VB-Script), HTML, JavaScript, and an Access database.
Jan 1999 - Feb 2002
3 years 2 months
Freelance Software Developer
COMPUS
Developed a high-quality CRM system first in Access 97 and later in Access 2000 and 2002.
Used ADO technology and Microsoft SQL Server 7.0 and 2000.
Integrated with Microsoft Office applications (e.g. creating and reading forms in Word from Access) and Axapta via COM (VBA, Automation).
The Access application makes extensive use of VBA; all forms are VBA-driven.
Part of the CRM was implemented as a website (with ASP, HTML, JavaScript), so that COMPUS staff on site could make entries into the database (for so-called "service reports").
Custom development for Navision Axapta.
Mainly report design and extensions of database and dialogs.
Thorough Axapta training in Navision (formerly Damgaard) courses.
Jun 1994 - Oct 1998
4 years 5 months
Software Developer
Ebusoft
Co-developed the “EBUS Generator-C” product. This is a cross-platform development tool for creating database applications (suitable for Windows and Unix).
Programmed various modules of the “generator” in C (also developing DLLs).
Developed applications using the generator, e.g. managing time tracking terminals as part of a time management system.
Created documentation (e.g. user manual).
Programmed Word macros as part of porting a manual from Ventura Publisher to Word (using doc-to-help).
Freelance Software Developer
Richter und Frenzel
Access applications for managing an appointment list and analyzing sales data for Richter und Frenzel (mostly VBA-driven).
Freelance Software Developer
SPQR
Created a form for a large banking project at SPQR (in C++).
Freelance Software Developer
Tagesaltenpflege Neuaubing
Access application for managing a care home for Tagesaltenpflege Neuaubing.
Summary
Programming Languages with project experience: VB.net, VB-Script (ASP, ClearQuest), VBA (Access), C, C++, Transact-SQL, SQLCMD, HTML, JavaScript, X++.
Development environments: Microsoft Visual Studio, Rational ClearQuest, Microsoft Access, ASP, EBUS Generator, GIT, Agile development.
Databases: Microsoft SQL Server, Oracle, Microsoft Access
Applications: Word, Excel, Outlook.
Soft skills: My biggest strengths are clean coding style and a conscientious way of working.