Joachim B. - Further development and maintenance of a company-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 company-wide monitoring database

BASF SE

Gathering requirements from business units
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 2 months

Munich, Germany

Access database programmer in the accounting department

Generali Versicherung / Europ Assistance

Troubleshooting in the existing system
Programming new features
Planning and executing migration of Access data to Oracle
Revising and adapting ETL connections

Technologies: MS Access, VBA, Oracle, PL/SQL

Oct 2021 - Jul 2022

10 months

Frankfurt am Main, Germany

Programming a dynamic ESG report

Deutsche Bank AG / DWS

Implementing the (static) report design
Implementing and optimizing requirements in coordination with the business unit
Analyzing existing data structures
Developing database queries
Developing Excel models for data aggregation
Programming dynamic Seismic elements for data visualization
Testing and documentation

Technologies: Seismic, SQL, MS Excel, MS PowerPoint

Jan 2021 - Sep 2021

9 months

Berlin, Germany

Developing a test data generator

Scopeland Technology GmbH

Analyzing data structures
Developing a bulk data test generator
Implementation in PL/SQL
Integrating 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

Developing permission concepts for databases with storage analysis functionalities
Supporting data migration projects
Creating guidelines for the Indian offshore team and progress tracking
Optimizing the technical backend for order-to-cash and delivery processes
Modeling reporting 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

Initial loading of base data into the new system
Synchronizing the old and new systems
Data validations
Dynamically generating PL/SQL code via VBA scripts
Generating reports

Technologies: Oracle, PL/SQL, SQL Developer, VBA, MS Excel

Jul 2019 - Sep 2019

3 months

Frankfurt am Main, Germany

Consulting on redesign of external data interfaces

VTB Bank (Europe) SE

Analyzing existing X4 interfaces
Analyzing and redesigning ETL processes
Designing new interfaces (including 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

Monitoring and maintaining processes created with UC4/Automic
Troubleshooting
Optimization
Migration of databases (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

Supporting SAP users
Coordinating between business units and SAP consultants
Analyzing SAP data
Customizing SAP mail merge functionalities

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 software packages with MSI and InstallShield
Writing and customizing Perl and shell scripts to control package installation on different Windows platforms, setting up user interfaces and configuring access permissions
Test installations on various platforms
Designing and programming Perl scripts to automatically adapt the above packages to new releases
Supporting software distribution during issue resolution

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

Automating data archiving, creating concepts, programming and integration, and testing for data consistency
Analyzing EDA data on component usage for failure analysis
Creating various statistics in the EDA design area

Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, E-R modeling, TCL, Cadence

Apr 2009 - Present

16 years 5 months

Development and extension of a sales/contract database

Eticur GmbH

Gathering customer requirements
Designing the implementation and estimating effort
Designing and modeling the database
Extending and improving the frontend, adapting the data structure
Data import (ETL)
Statistical analyses
Integration with the phone system
Improving security requirements for data access
Optimizing data storage and tuning the MS SQL Server
Documenting and testing the 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 field of logistics and warehouse databases

MuK + Transthermos GmbH

Interface development

Designing, programming, testing, installing, and commissioning interfaces for two-way data exchange with customers
Integrating interfaces into in-house processing and sync
Programming small utility programs for accounting, sales, and controlling

Reporting and intranet reporting

Requirement analysis, design, programming, testing, and delivery of intranet reports
Creating reports, from simple lists to complex layouts and workflows
Establishing structures for permission checks

Automation scripts

Designing and programming automated workflows for customer trading systems
Implementing overnight processes for complex statistical analyses

Datawarehouse system

Designing and implementing data warehouse, data integration, and ETL processes
Optimizing for performance and availability in daily operations

Technologies: E-R modeling, HTML, Informix, JavaScript, Shell script, Linux, MS Office, MySQL, Perl, PHP, sh/csh, SQL, ETL, VB/VBA, EDIFACT, FORTRAS, QlikView

Jan 2001 - Dec 2002

2 years

Munich, Germany