Joachim Bleichert
Oracle consulting and development
Experience
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
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 (17 years), Transportation (9.5 years), Banking and Finance (8.5 years), Insurance (2.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 (26.5 years), Business Intelligence (21 years), Logistics (9 years), Product Development (8.5 years), Quality Assurance (4.5 years), and Accounting (1 year).
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
Languages
Education
Diploma in engineering · Electrical engineering, communications 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 Oracle consulting and development
Nearby freelancers
Professionals working in or nearby Munich, Germany