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 database and other systems
Data visualization and processing using APEX and Oracle Forms (with Forms being replaced by APEX)
Gathering requirements from business units
Designing the implementation
Implementation 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 a large MS Access database for invoice generation
The overall system consists of separate Access front-end and back-end files
There are also ETL connections to Oracle and SAP systems
Troubleshooting in the existing system
Programming new features
Planning and executing a migration of Access data to Oracle
Revising and adjusting the ETL connections
Technologies: MS Access, VBA, Oracle, PL/SQL
Development of a dynamic ESG report
Deutsche Bank AG / DWS
Development of 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 correcting existing Seismic reports
Implementing the static report design
Implementing and optimizing the 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
Development of a test data generator
Scopeland Technology GmbH
Supporting a development team of a low-code software vendor
Automatic generation of test data with complex structures for a software rollout
Analyzing data structures
Developing a test data generator for bulk 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
Supporting the development of various concepts and software implementations for storage management solutions
Developing permission concepts for databases with storage analysis features
Supporting data migration projects
Creating guidelines for the Indian offshoring team and tracking progress
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
Rollout support for shipping software
Lufthansa Systems / Hamburg Süd
Technical support for a rollout team in preparing container software to be deployed worldwide
Data reconciliations between the live and the new system
Initial load 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 with error logging
Generation of reports
Technologies: Oracle, PL/SQL, SQL Developer, VBA, MS Excel
Consulting on redesign of external data interfaces
VTB Bank (Europe) SE
Redesign of existing X4 interfaces (SWIFT, EDIFACT) to and from information providers
Recreating 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 a banking environment
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 departments and external SAP consultants
User support in the SAP environment
Programming of data analyses to support the annual inventory
Support of SAP users
Coordination between departments and SAP consultants
Data analysis of SAP data
Customization of SAP mail merge functionality
Technologies: SAP, VBA, MS Access, MS Excel
Development and customization programming in a banking environment
Fiducia & GAD IT AG
Creation and maintenance of installation packages for various Windows versions at a service company in banking and insurance
Packaging with MSI and InstallShield
Customizing installations using Perl and shell scripts
Automated updating of existing installation packages
Creating software packages with MSI and InstallShield
Developing and customizing Perl and shell scripts to control installation on different Windows platforms
Setting up user interfaces and configuring access permissions
Test installations on various platforms
Design and programming of Perl scripts for automated adaptation to new releases
Supporting software distribution in troubleshooting
Technologies: SQL, InstallShield, MSI, Perl, PowerShell, sh/csh
Programming automations in the EDA environment
Texas Instruments Deutschland GmbH
Supporting designers in the Electronic Design Automation team by automating recurring tasks
Automating data archiving including concept, programming, integration, and tests for data consistency
Analyzing EDA data on component usage for error analyses
Creating various statistics in the EDA design area
Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, ER modeling, TCL, Cadence
Development and extension of a sales/contracts database
Eticur GmbH
Mapping processes for developing contacts with prospects and customers
Implementing postal code-based access control for sales staff (multi-tenancy)
Reporting and analytics for sales support
Extending the permissions concept for new user groups
Gathering customer requirements
Designing the solution and estimating effort
Designing and modeling the database
Enhancing and improving the frontend, adjusting the data structure
Data import (ETL)
Statistical analyses
Integrating 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, ER modeling, MS Access, VB/VBA, Windows Server, Windows 8, Crystal Reports
Development in the area of logistics and warehouse management databases
MuK + Transthermos GmbH
Developing interfaces for bidirectional data exchange between logistics and warehouse management databases and customers (EDIFACT, FORTRAS, and custom formats)
Integrating the interfaces into in-house processing and synchronization
Programming small utility programs for accounting, sales, and controlling
Reporting and intranet analyses with output in Excel, HTML, and print
Designing and programming extensive Perl libraries for standardizing database access, GUI development, and output
Setting up permission structures for reporting based on database roles
Creating automation scripts on the servers for scheduled/time-based analyses and data monitoring with alerts
Designing and implementing a data warehouse system and related ETL processes for mass data and nightly processing in Informix
Technologies: ER modeling, HTML, Informix, JavaScript, shell script, 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
- Gathering requirements from the sales department
- Designing, modeling, and implementing a data structure in Oracle
- Creating a permissions concept
- Developing the Access frontend
- Testing, documenting, and commissioning
- 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
Developing a knowledge database, including requirements gathering, design/modeling, and implementation in Postgres
Creating a permissions concept and developing the frontend
Testing, documentation, and commissioning
Maintaining and further developing the application
Coordinating change and extension requests
Installing a bug tracking system (iTracker)
Aligning changes and updating documentation
Technologies: ER modeling, Oracle, MS Access, Postgres, SQL
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Transportation, Banking and Finance, Insurance, Energy, and Chemical.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Sales, Supply Chain Management, Accounting, and Operations.
Skills
Technical Focus: Database Design, Modeling And Programming (T-sql, Pl/sql, Apex), Perl, Powershell, Vb / Vba Development, Data Migrations, Data Analyses Including Graphical Representation (E.g. Crystal Reports, Seismic, Qlikview, Ms Access), Design And Implementation Of Etl Processes (Using Single 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, Postgresql, Db2, Dbase, Er 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
Applications / Software Tools: Sap, Emacs, Ms Office Pro, Staroffice, Photoshop, Lightroom, Captureone
Protocols / Interfaces: Edifact, Fortras, Swift
Services / Applications: Installshield, Msi, Oracle Rman, Oracle Sqlplus, Active Directory
Methodologies: Scrum, Agile
Industries: Banking & Financial Services, Insurance, Consulting, Software Vendors, Energy, Retail, Medical Technology, Telecommunications, Logistics, Chemicals, Electrical Engineering
Languages
Education
Diploma in Electrical and Communications Engineering · Electrical Engineering, Communications Engineering
Statistics
Experience
Global Experience
Expertise
Qualifications
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
