Joachim Bleichert
Further development and maintenance of a company-wide monitoring database
Experience
Further development and maintenance of a company-wide monitoring database
BASF SE
Maintenance of a company-wide Oracle database that consolidates information from various internal databases, Active Directory and other systems
Data transfer via Oracle jobs between the monitoring DB and other systems
Data visualization and manipulation using APEX and Oracle Forms (the latter is being replaced by APEX)
Gathering requirements from the business units
Designing the implementation
Implementing at the database level and in APEX
System maintenance
Troubleshooting
Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer
Access database programmer in the accounting department
Generali Versicherung / Europ Assistance
The department runs an extensive MS Access database for invoice generation
The system consists of separate Access front-end and back-end files
There are also ETL connections to Oracle and SAP systems
Fixing issues in the existing system
Programming new features
Planning and executing a migration of Access data to Oracle
Revising and adapting the ETL connections
Technologies: MS Access, VBA, Oracle, PL/SQL
Programming a dynamic ESG report
Deutsche Bank AG / DWS
Programming a comprehensive dynamic ESG report for portfolio management
Working as the sole developer in collaboration with the business unit
Core technology: Seismic plug-in for MS PowerPoint
Optimizing and fixing existing Seismic reports
Implementing the static report design
Implementing and optimizing the requirements in consultation with the business unit
Analyzing existing data structures
Developing database queries
Creating Excel models for data aggregation
Programming the dynamic Seismic elements for data visualization
Testing and documentation
Technologies: Seismic, SQL, MS Excel, MS PowerPoint
Development of a test data generator
Scopeland Technology GmbH
Supporting a development team at a low-code software vendor
Automatic creation of test data with complex data structures in the context of a software rollout
Analyzing data structures
Developing a test data generator for large-scale data
Implementing in PL/SQL
Integrating script calls into the user interface
Technologies: Oracle PL/SQL, SCRUM, JIRA
Support for a storage team
Allianz Deutschland AG
Assisting in the development of various concepts and software implementations related to storage management solutions
Developing permission concepts for databases with storage analysis features
Supporting data migration projects
Creating guidelines for the offshore team in India and progress tracking
Optimizing the technical backend for order-to-cash and delivery processes
Modeling analysis processes with Transact-SQL and PowerShell
Creating data analyses with Transact-SQL
Technologies: MS SQL Server, Transact-SQL, PowerShell, SCRUM, JIRA, Adonis
Rollout support for shipping software
Lufthansa Systems / Hamburg Süd
Technical support for a rollout team in preparing a worldwide container software
Data reconciliation between the live system and the new system
Initial loading of the new system with master data
Synchronization of the old and new systems
Data validations
Dynamic generation of PL/SQL code via VBA scripts with error logging
Generation of reports
Technologies: Oracle, PL/SQL, SQL Developer, VBA, MS Excel
Consulting on the redesign of external data interfaces
VTB Bank (Europe) SE
Redesign of existing X4 interfaces (SWIFT, EDIFACT) to and from information service providers
Reproduction of the interfaces as PowerShell scripts
Standardization of legacy designs without code dependencies
Analysis of the existing X4 interfaces
Analysis and redesign of ETL processes
Design of new interfaces with central error logging and code independence
Implementation proposals
Technologies: X4, PowerShell, ETL, SWIFT, EDIFACT
Process monitoring and control in the banking sector
Fiducia & GAD IT AG
Operation and maintenance of the UC4/Automic process control on hosted customer databases (banks)
Monitoring and maintenance of processes created with UC4/Automic
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
Data analysis, user support and coordination tasks in an SAP environment
TAL GmbH
Coordination tasks between business departments and external SAP consultants
User support in the SAP environment
Programming data analyses to support the annual inventory
Support of SAP users
Coordination between business units and SAP consultants
Data analysis of SAP data
Customization of SAP mail merge functionalities
Technologies: SAP, VBA, MS Access, MS Excel
Development and custom programming in a banking environment
Fiducia & GAD IT AG
Creation and maintenance of installation packages for various Windows versions at an IT service company in banking and insurance
Packaging with MSI and InstallShield
Customization of installations using Perl and shell scripts
Automated updating of existing installation packages
Creation of software packages with MSI and InstallShield
Development and customization of Perl and shell scripts to control installation on different Windows platforms
Setup of user interfaces and configuration of access permissions
Test installations on various platforms
Design and programming of Perl scripts for automated adaptation to new releases
Support for software distribution during troubleshooting
Technologies: SQL, InstallShield, MSI, Perl, PowerShell, sh/csh
Automation programming in the EDA environment
Texas Instruments Deutschland GmbH
Supporting designers in the Electronic Design Automation team by automating recurring tasks
Automation of data archiving including concept, programming, integration and tests for data consistency
Analysis of EDA data on component usage during failure analysis
Creation of various statistics in the EDA design area
Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, ER modeling, TCL, Cadence
Development and expansion of a sales/contracts database
Eticur GmbH
Mapping processes for developing contacts with prospects/customers
Implementation of postal code-based access control for sales staff (multi-tenancy capability)
Reporting and analytics for sales support
Extension of the authorization concept for new user groups
Gathering customer requirements
Conceptualizing the implementation and estimating effort
Database design and modeling
Frontend enhancements and improvements, adapting 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 the changes
Technologies: MS SQL Server 2005–2014, Transact-SQL, SQL, ETL, ER modeling, MS Access, VB/VBA, Windows Server, Windows 8, Crystal Reports
Development in the area of logistics and inventory databases
MuK + Transthermos GmbH
Interface development for bidirectional data exchange between logistics and inventory databases and customers (EDIFACT, FORTRAS and custom formats)
Embedding the interfaces into in-house processing and synchronization
Programming small helper programs for accounting, sales and controlling
Reporting and intranet analyses with output in Excel, HTML and print
Design and programming of extensive Perl libraries for standardizing database access, GUI development and output
Building permission structures for reporting based on database roles
Automation scripts on servers for time-based analyses and data monitoring with alerts
Design and implementation of a data warehouse system and related ETL processes for mass data and nightly processing in Informix
Technologies: ER modeling, HTML, Informix, JavaScript, Shell scripting, Linux, MySQL, Perl, PHP, sh/csh, SQL, ETL, VB/VBA, EDIFACT, FORTRAS, QlikView
Further development and maintenance of a sales database
E.ON Energie Deutschland GmbH
- Requirement analysis from the sales department
- Design, modeling and implementation of a data structure in Oracle
- Development of an authorization concept
- Development of the Access frontend
- Testing, documentation and deployment
- Maintenance, further development and user support
Technologies: ER modeling, Oracle, MS Access, Postgres, SQL
Development and maintenance of a knowledge database
NetExpress Network Solutions GmbH
Development of a knowledge database including requirements gathering, design/modeling and implementation in Postgres
Creation of an authorization concept and frontend development
Testing, documentation and deployment
Maintenance and further development of the application
Coordinating change and enhancement requests
Installation of a bug tracking system (iTracker)
Reviewing changes and updating documentation
Technologies: ER modeling, Oracle, MS Access, Postgres, SQL
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Information Technology (27 years), Transportation (9.5 years), Banking and Finance (8.5 years), Insurance (4.5 years), Energy (2 years), and Chemical (1.5 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (27 years), Business Intelligence (25 years), Sales (17 years), Supply Chain Management (9 years), Accounting (3.5 years), and Operations (2 years).
Skills
Main Focus Areas: Database Design, Modeling And Programming (T-sql, Pl/sql, Apex), Perl, Powershell, Vb/vba Development, Data Migrations, Data Analysis Including Graphical Representation (E.g. Crystal Reports, Seismic, Qlikview, Ms Access), Design And Implementation Of Etl Processes (Using Custom Scripts Or Tools)
Operating Systems: Linux, Windows
Programming Languages: Visual Basic, Visual Basic For Applications (Vba), Perl, Powershell, Tcl, Pascal, Java, Javascript, Php, Python, Shell Scripts, Html, Xml, Pl/sql, Ms Sql, Transact-sql
Databases & Programming: Oracle (8-19), Oracle Apex, Ms Sql Server (From 2000), Informix, Ms Access, Mysql, Postgres, Db2, Dbase, Entity-relationship Modeling, Etl
Apis/libraries: Dao, Ado, Odbc
Development Environments/tools: Sql Developer, Toad, Squirrel, Sql Server Management Studio, Seismic (As A Powerpoint Plug-in), Crystal Reports, Qlikview, Uc4 (Automic), X4
Application Software/tools: Sap, Emacs, Ms Office Pro, Staroffice, Photoshop, Lightroom, Captureone
Protocols/interfaces: Edifact, Fortras, Swift
Services/applications: Installshield, Msi, Oracle Rman, Oracle Sql*plus, Active Directory
Methodologies: Scrum, Agile
Industries: Banking & Financial Services, Insurance, Consulting, Software Vendors, Energy, Retail, Medical Technology, Telecommunications, Logistics, Chemicals, Electrical Industry
Languages
Education
Diplom-Ingenieur in Electrical Engineering and Telecommunications Engineering · Electrical Engineering, Telecommunications Engineering
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Joachim based?
What languages does Joachim speak?
How many years of experience does Joachim have?
What roles would Joachim be best suited for?
What is Joachim's latest experience?
What companies has Joachim worked for in recent years?
Which industries is Joachim most experienced in?
Which business areas is Joachim most experienced in?
Which industries has Joachim worked in recently?
Which business areas has Joachim worked in recently?
What is Joachim's education?
What is the availability of Joachim?
What is the rate of Joachim?
How to hire Joachim?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Further development and maintenance of a company-wide monitoring database
Nearby freelancers
Professionals working in or nearby Munich, Germany
