Joachim B. - Further development and maintenance of a group-wide monitoring database

Go to Website

Munich, Germany

Experience

Apr 2023 - Dec 2024

1 year 9 months

Ludwigshafen, Germany

Further development and maintenance of a group-wide monitoring database

BASF SE

The client runs a group-wide Oracle database where information from various internal databases, Active Directory, and other systems comes together.
Data transfer between the monitoring DB and other systems is done using Oracle jobs.
Data visualization and editing is done with APEX and Oracle Forms (the latter will gradually be replaced by APEX).
Gathering requirements from the departments.
Conceptual design.
Implementation at the database level and in APEX.
System maintenance.
Troubleshooting.
Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer

Jul 2022 - Present

3 years 3 months

Munich, Germany

Access database programmer in the accounting department

Generali Versicherung / Europ Assistance

The department runs a large MS Access database for invoice creation.
The overall system consists of separate Access front-end and back-end files.
There are also ETL connections to Oracle and SAP systems.
Bug fixing in the existing system.
Programming new functions.
Planning and carrying out a migration of the Access data to Oracle.
Overhaul and adjustment of the ETL connections.
Technologies: MS Access, VBA, Oracle, PL/SQL

Oct 2021 - Jul 2022

10 months

Frankfurt, Germany

Programming a dynamic ESG report

Deutsche Bank AG / DWS

Programming a comprehensive dynamic ESG report for portfolio management.
As the sole developer, the report was created in direct collaboration with the department.
The core technology was the Seismic plug-in for MS PowerPoint.
It also involved optimizing and correcting existing Seismic reports.
Implementation of the (static) report draft.
Implementing and optimizing the requirements in consultation with the department.
Analysis of existing data structures.
Development of database queries.
Development of Excel models for data aggregation.
Programming the dynamic Seismic elements for data visualization.
Testing and documentation.
Technologies: Seismic, SQL, MS Excel, MS PowerPoint

Jan 2021 - Sep 2021

9 months

Berlin, Germany

Development of a test data generator

Scopeland Technology GmbH

Support for a development team of a low-code software vendor.
Automatic generation of test data with complex data structures for a software rollout.
Analysis of data structures.
Development of a test data generator for mass data.
Implementation in PL/SQL.
Integration of script calls into the user interface.
Technologies: Oracle PL/SQL, SCRUM, JIRA

Feb 2020 - Dec 2020

11 months

Munich, Germany

Support for a storage team

Allianz Deutschland AG

Supporting the development of various concepts and software implementations for the customer's storage solution management.
Developing authorization concepts for databases with storage analysis features.
Supporting data migration projects.
Creating guidelines for the offshore team in India and doing progress tracking.
Optimizing the technical backend for order-to-cash and delivery processes.
Modeling evaluation processes with Transact-SQL and PowerShell.
Creating data analyses with Transact-SQL.
Technologies: MS SQL Server, Transact SQL, PowerShell, SCRUM, JIRA, Adonis

Sep 2019 - Jan 2020

5 months

Hamburg, Germany

Rollout support for a shipping software

Lufthansa Systems / Hamburg Süd

Technical support for a rollout team in preparing container software to be used worldwide.
Data comparisons between the currently running and the new software.
Initial loading of the new system with base data.
Synchronization of the old and new systems.
Data validations.
Dynamic generation of PL/SQL code via VBA scripts (the generated code in turn contains procedures with error logging).
Creating reports.
Technologies: Oracle, PL/SQL, SQL Developer, VBA, MS Excel

Jul 2019 - Sep 2019

3 months

Frankfurt, Germany

Consulting on the redesign of external data interfaces

VTB Bank (Europe) SE

Existing X4 interfaces (formats like SWIFT, EDIFACT, etc.) to and from the bank's information providers (e.g. Bloomberg) were redesigned and recreated as PowerShell scripts.
The historically grown variety of designs was standardized.
There were no code dependencies between the interfaces (e.g. shared libraries).
Analysis of existing X4 interfaces.
Analysis and redesign of ETL processes.
Designing new interfaces (including a central error logging, code standardization while keeping code independence).
Implementation proposals.
Technologies: X4, PowerShell, ETL, SWIFT, EDIFACT

May 2018 - Jun 2019

1 year 2 months

Karlsruhe, Germany

Process monitoring and control in a banking environment

Fiducia & GAD IT AG

Operating the UC4 process control on customer-hosted databases (the customers are banks).
Monitoring and maintenance of processes created with UC4/Automic.
Troubleshooting.
Optimization.
Database migration (SQL, Access).
Testing and deployment of new versions.
Technologies: UC4/Automic, SQL, Access, E-R modeling, Perl, shell scripts, VBA

Dec 2016 - Apr 2017

5 months

Munich, Germany

Data analysis, user support and coordination tasks in an SAP environment

TAL GmbH

Coordination between departments and external SAP consultants in an SAP environment, and user support.
Programming data analyses to support the annual inventory.
Supporting SAP users.
Coordinating between business units and SAP consultants.
Data analysis of SAP data.
Adapting SAP mail merge functions.
Technologies: SAP, VBA, MS Access, MS Excel

Mar 2013 - Dec 2020

7 years 10 months

Karlsruhe, Germany

Development and custom programming in a banking environment

Fiducia & GAD IT AG

Creating and maintaining installation packages at a service company in the banking and insurance sector.
Target platforms were various Windows versions.
MSI and InstallShield were used for packaging.
Customizing installations on different Windows platforms with extensive Perl and shell scripts.
Writing scripts to automatically update existing installation packages.
Creating software packages with MSI and InstallShield.
Writing and customizing Perl and shell scripts to control installation of packages on different Windows platforms, set up user interfaces, and configure access rights.
Test installations on various platforms.
Designing and programming Perl scripts to automatically adapt the packages to new releases.
Supporting software distribution in troubleshooting.
Technologies: SQL, InstallShield, MSI, Perl, PowerShell, sh/csh

Jun 2012 - Oct 2012

5 months

Freising, Germany

Programming automations in the EDA environment

Texas Instruments Deutschland GmbH

Working in the "Electronic Design Automation" team.
Supporting designers in the EDA environment by automating recurring processes.
This included:
Automation of data archiving.
Creating concepts in coordination with the designers (for data archiving).
Programming and integrating the tasks (for data archiving).
Subsequent tests for data consistency (for data archiving).
Analysis of EDA data on component usage during failure analyses.
Creating various statistics in the EDA design area.
Adapting SAP mail merge functions.
Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, E-R modeling, TCL, Cadence

Apr 2009 - Present

16 years 6 months

Development and enhancement of a sales / contract database

Eticur GmbH

Mapping processes for lead development to prospects/customers, implementing postal code-based access control for sales staff (multi-tenancy), reporting and analytics for sales support.
Extending the authorization concept for new user groups.
Gathering customer requirements.
Conceptual design and effort estimation.
Database design and modeling.
Frontend extensions and improvements, adjusting the data structure.
Data import (ETL).
Statistical analyses.
Integration with the telephone system.
Improving security requirements for data access.
Optimizing data storage and tuning the MS SQL Server.
Documentation and testing of changes.
Technologies: MS SQL Server 2005 - 2014, Transact SQL, SQL, ETL, E-R modeling, MS Access, VB/VBA, Windows Server, Windows 8 (initially XP), Crystal Reports

Apr 2003 - May 2012

9 years 2 months

Munich, Germany

Development in the area of logistics and inventory databases

MuK + Transthermos GmbH

Interface development (entire project duration).
Design, programming, testing, installation and commissioning of interfaces for two-way data exchange between the client's logistics and inventory databases and its customers in standard formats like EDIFACT and FORTRAS, as well as various custom formats.
Embedding the interfaces in the in-house processing and syncing with customer databases.
Programming small helper programs for accounting, sales, and controlling.
Reporting and intranet reports (entire project duration).
Requirements analysis, design, programming, testing and delivery of reports for the customer intranet with output in various formats (Excel, HTML, direct print).
Reports range from simple lists to complex processes like order and transport management, product traceability, invoicing, management of large rate structures, etc.
The recipients of the reports are various parts of the company from management through sales, controlling, accounting to production operations in the branches.
Linked to the reports was the design and programming of extensive Perl libraries to standardize database access, GUI development, output, etc.
Setting up structures for authorization checks for the above reporting based on existing database authorization roles.
Server automation scripts (2005 to project end).
Requirements analysis, design, programming, testing, integration/installation of automated processes for a customer trading system.
This included distributing scheduled/timed reports for various business areas and monitoring data inputs, checking for data inconsistencies, errors in data sets, etc., with corresponding alerts.
Design and implementation of a data warehouse system and its ETL processes (2008 to project end).
Requirements analysis, design, modeling the data structure, programming, testing, integration/installation to provide mass data for statistical analyses.
For reasons of data complexity and especially performance, production data is processed in various nightly jobs and provided in a new Informix database for heavy analyses.
This step was necessary to prevent complex statistical analyses from affecting daily operations and to provide results within acceptable run times.
Technologies: E-R modeling, HTML, Informix, JavaScript, shell scripts, Linux, MS Office, MySQL, Perl, PHP, sh/csh, SQL, ETL, VB/VBA, EDIFACT, FORTRAS, QlikView