Joachim Bleichert

Further development and maintenance of a group-wide monitoring database

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 1 month
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 4 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
Jan 2001 - Dec 2002
2 years
Munich, Germany

Further development and maintenance of a sales database

E.ON Energie Deutschland GmbH

  • Requirements analysis from the sales department.
  • Design/modeling and implementation of a data structure in Oracle.
  • Creating an authorization concept.
  • Developing the Access front-end.
  • Testing, documentation and go-live.
  • Maintenance and further development.
  • User support.
  • Technologies: E-R modeling, Oracle, MS Access, Postgres, SQL
Jan 1999 - Jul 2003
4 years 7 months
Gräfelfing, Germany

Development and maintenance of a knowledge database

NetExpress Network Solutions GmbH

  • Gathering requirements from users in various departments.
  • Design/modeling and implementation of a data structure in Postgres.
  • Creating an authorization concept.
  • Developing the application including the front-ends.
  • Testing, documentation and go-live.
  • Collecting and coordinating change and enhancement requests.
  • Installing a bug tracking system (iTracker).
  • Aligning changes.
  • Testing and updating documentation.
  • Technologies: E-R modeling, Oracle, MS Access, Postgres, SQL
Languages
German
Native
English
Advanced
Education
Lorem ipsum dolor sit amet

Dipl.-Ing., Communications Engineering · Electrical Engineering

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions