Joachim Bleichert - Oracle consulting and development

Munich, Germany

Experience

May 2025 - Present

9 months

Mannheim, Germany

Oracle consulting and development

Statutory Accident Insurance for Food & Hospitality (BNG)

Development and consulting of various web applications for data preparation and distribution using Oracle databases and PL/SQL
Technologies: Oracle 19, Oracle PL/SQL, Oracle APEX

Apr 2023 - Dec 2024

1 year 9 months

Ludwigshafen, Germany

Further development and maintenance of a group-wide monitoring database

Badische Anilin- und Sodafabrik (BASF SE)

Gathering requirements from business units
Design
Implementation at database level and in APEX
Creation of SQL scripts for Oracle
System maintenance
Troubleshooting
Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer, Data Warehouse (DWH)

Jul 2022 - Apr 2023

10 months

Munich, Germany

Access database programmer in the accounting department

Generali Insurance / Europ Assistance

Requirements analysis and business analysis
Troubleshooting the existing system
Programming new functionalities
Planning and executing a migration of Access data to Oracle
Revising and adjusting ETL connections
Technologies: MS Access, VBA, Oracle, PL/SQL

Oct 2021 - Jul 2022

10 months

Frankfurt, Germany

Business analysis and programming of a dynamic ESG report

Deutsche Bank AG / DWS

Requirements analysis and business analysis
Implementation of the static report design
Implementation and optimization of requirements in coordination with the business unit
Analysis of existing data structures
Development of database queries
Development of 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

Business analysis and development of a test data generator

Scopeland Technology GmbH

Requirements analysis and business analysis
Analysis of data structures
Development of a test data generator for mass data
Implementation in PL/SQL
Creation of SQL scripts for Oracle
Integration of script calls into the user interface
Technologies: Oracle PL/SQL, SCRUM

Feb 2020 - Dec 2020

11 months

Munich, Germany

Support for a storage team

Allianz Deutschland AG

Development of authorization concepts for databases with storage analysis features
Support for data migration projects
Creation of guidelines for the Indian offshoring team and progress tracking
Optimization of the technical backend for order-to-cash and delivery processes
Creation of SQL scripts for MS SQL Server
Modeling of analysis processes with Transact-SQL and PowerShell
Creation of data analyses with Transact-SQL
Technologies: MS SQL Server, Transact-SQL, PowerShell, SCRUM, JIRA, Confluence, Adonis

Sep 2019 - Jan 2020

5 months

Hamburg, Germany

BA and rollout support for shipping software

Lufthansa Systems / Hamburg Süd

Requirements analysis and business analysis
Initial population of the new system with basic data
Synchronization of the old and new systems
Data validations
Dynamic generation of PL/SQL code via VBA scripts with error logging
Report generation
Technologies: Oracle, PL/SQL, SQL Developer, VBA, MS Excel

Jul 2019 - Sep 2019

3 months

Frankfurt, Germany

BA and consulting for the redesign of external data interfaces

VTB Bank (Europe) SE

Requirements analysis and business analysis
Analysis of existing X4 interfaces (SWIFT, EDIFACT, etc.)
Analysis and redesign of ETL processes
Design of new interfaces with central error logging and code independence
Creation of implementation proposals
Technologies: X4, PowerShell, ETL, SWIFT, EDIFACT

May 2018 - Jun 2019

1 year 2 months

Münster, Germany

Process monitoring and control in a banking environment

Fiducia & GAD IT AG

Monitoring and maintenance of processes created with UC4/Automic
Creation of SQL scripts
Troubleshooting and optimization
Migration of databases (SQL, Access)
Testing and deployment of new versions
Technologies: UC4/Automic, SQL, Access, ER modeling, Perl, shell scripts, VBA

Dec 2016 - Apr 2017

5 months

Munich, Germany

BA, data analysis, user support, and coordination tasks in an SAP environment

TAL GmbH

Requirements analysis and business analysis
Support for SAP users
Coordination between business units and external SAP consultants
Data analyses of SAP data to support the annual inventory
Customization of SAP mail merge functionalities
Technologies: SAP, VBA, MS Access, MS Excel

Mar 2013 - Dec 2020

7 years 10 months

Karlsruhe, Germany

Development and customization programming in the banking environment

Fiducia & GAD IT AG

Created software packages with MSI and InstallShield
Created and customized Perl and shell scripts for fine-grained control of package installations on various Windows platforms
Performed test installations on various platforms
Designed and programmed Perl scripts to automate package adjustments for new releases
Supported software distribution during problem resolution
Technologies: SQL, InstallShield, MSI, Perl, PowerShell, sh/csh

Jun 2012 - Oct 2012

5 months

Freising, Germany

Business analysis and automation programming in the EDA environment

Texas Instruments Deutschland GmbH

Requirements analysis and business analysis
Automated data archiving, including concept development, programming, integration, and testing
Analyzed EDA data on component usage for failure analyses
Generated various statistics in the EDA design area
Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, ER modeling, TCL, Cadence

Apr 2009 - Sep 2021

12 years 6 months

Business analysis, development, and enhancement of a sales/contract database

Eticur GmbH

Requirements analysis and business analysis
Planned the implementation and estimated the effort
Designed and modeled the database
Extended and improved the frontend; adapted the data structure
Data import (ETL)
Statistical analyses
Integrated with the telephone system
Enhanced security requirements for data access
Optimized data storage and tuned the MS SQL Server
Documented and tested the adjustments
Technologies: MS SQL Server 2005–2014, Transact-SQL, ETL, ER modeling, VB/VBA, MS Access, Windows Server, Crystal Reports

Apr 2003 - May 2012

9 years 2 months

Munich, Germany

Business analysis and development of logistics and inventory databases

MuK + Transthermos GmbH

Designed, programmed, and created SQL scripts for Informix interfaces in EDIFACT and FORTRAS formats
Tested, installed, and commissioned bidirectional data exchange interfaces
Integrated the interfaces into internal processing and synchronized with customer databases
Developed small utility programs for accounting, sales, and controlling
Developed reports and intranet analyses in Excel, HTML, and print formats
Developed extensive Perl libraries for database access and GUI
Designed and implemented a data warehouse system including ETL processes
Developed automation scripts on servers to distribute reports and monitor data inputs
Technologies: Informix, MySQL, SQL, ER modeling, ETL, QlikView, Perl, PHP, sh/csh, HTML, JavaScript, shell scripts

Jan 2001 - Dec 2002

2 years

Munich, Germany

Business analysis, further development, and maintenance of a sales database

E.ON Energie Deutschland GmbH

Conducted requirements analysis for the sales department
Designed, modeled, and implemented a data structure in Oracle
Developed an authorization concept
Developed the Access frontend using VBA
Tested, documented, and deployed
Maintained and further developed
Provided user support
Technologies: ER modeling, Oracle, VB/VBA, MS Access, SQL

Jan 1999 - Jul 2003

4 years 7 months

Gräfelfing, Germany

Business analysis, development and maintenance of a knowledge database

NetExpress Network Solutions GmbH

Gather requirements from users across different departments
Design, model and implement a data structure in Postgres
Create an access control concept
Develop the application including frontends
Testing, documentation and deployment
Coordinate change and enhancement requests
Install a bug tracking system (iTracker)
Test and update the documentation
Technologies: ER modeling, VB/VBA, MS Access, MS Excel, Postgres, SQL

Skills

Database Design, Modeling And Programming (T-sql, Pl/sql, Apex)
Business Analysis (Interface Between Business And It)
Data Warehousing
Perl, Powershell, Vb/vba Development
Data Migrations
Data Analysis Including Visualizations (E.g. Crystal Reports, Seismic, Qlikview, Ms Access)
Design And Implementation Of Etl Processes
Operating Systems: Windows, Linux
Programming Languages: Visual Basic (Vb), Visual Basic For Applications (Vba), Perl, Powershell, Tcl, Pascal, Javascript, Php, Python, Shell Scripts, Html, Xml, Java, Pl/sql, Transact-sql (T-sql)
Databases & Programming: Oracle (8–19), Oracle Apex, Ms Sql Server (Since 2000), Informix, Ms Access, Mysql, Postgres, Db2, Dbase, Er Modeling, Etl, Dwh
Apis / Libraries: Dao, Ado, Odbc
Development Environments / Tools: Sql Developer, Toad, Squirrel, Sql Server Management Studio, Seismic (As Powerpoint Plug-in), Crystal Reports, Qlikview, Uc4 (Automic), X4
Application Software / Tools: Sap, Emacs, Ms Office Pro, Staroffice, Photoshop, Lightroom, Captureone, Cvs, Rcs
Protocols / Interfaces: Edifact, Fortras, Swift
Services / Applications: Installshield, Msi, Oracle Rman, Oracle Sqlplus, Active Directory
Methodologies: Scrum, Agile, Waterfall
Industries: Banking & Financial Services, Insurance, Consulting, Software Vendors, Energy, Retail, Medical Technology, Telecommunications, Logistics, Chemical, Electrical Industry