Joachim Bleichert
Oracle Consulting and Development
Experience
Oracle Consulting and Development
Berufsgenossenschaft Nahrungsmittel & Gastgewerbe (BNG)
- Development and consulting for various web applications for data preparation and distribution using Oracle databases and PL/SQL
- Technologies: Oracle 19, Oracle PL/SQL, Oracle APEX
Enhancement and Maintenance of a Corporate-wide Monitoring Database
Badische Anilin- und Sodafabrik (BASF SE)
- Requirements gathering with the business units
- Design
- Implementation at the 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 Versicherung / Europ Assistance
- Requirements analysis and business analysis
- Troubleshooting the existing system
- Programming new features
- Planning and implementing 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 large datasets
- 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 evaluation processes with Transact-SQL and PowerShell
- Creation of data analyses with Transact-SQL
- Technologies: MS SQL Server, Transact-SQL, PowerShell, SCRUM, JIRA, Confluence, Adonis
Business analysis and rollout support for shipping software
Lufthansa Systems / Hamburg Süd
- Requirement analysis and business analysis
- Initial population of the new system with base data
- Synchronization of the old and new system
- 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
Business analysis and consulting for the redesign of external data interfaces
VTB Bank (Europe) SE
- Requirement analysis and business analysis
- Analysis of existing X4 interfaces (SWIFT, EDIFACT, etc.)
- Analysis and redesign of ETL processes
- Design of new interfaces with centralized 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
Business analysis, data analysis, user support, and coordination tasks in an SAP environment
TAL GmbH
- Requirement analysis and business analysis
- SAP user support
- Coordination between departments and external SAP consultants
- Data analysis of SAP data to support the annual inventory
- Adjustment of SAP mail merge functions
- Technologies: SAP, VBA, MS Access, MS Excel
Development and Custom Programming in Banking Environment
Fiducia & GAD IT AG
- Creating software packages with MSI and InstallShield
- Creating and customizing Perl and shell scripts to control package installation on various Windows platforms
- Performing test installations on different platforms
- Designing and programming Perl scripts to automate package adjustments for new releases
- Supporting software deployment in troubleshooting
- 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
- Automating data archiving including concept development, programming, integration, and testing
- Evaluating EDA data on component usage in failure analyses
- Creating various statistics in the EDA design area
- Technologies: Oracle, MS Access, Perl, Python, sh/csh, SQL, ER modeling, TCL, Cadence
Business Analysis, Development and Expansion of a Sales/Contract Database
Eticur GmbH
- Requirements analysis and business analysis
- Planning the implementation and estimating effort
- Designing and modeling the database
- Extending and improving the frontend, adapting the data structure
- Data import (ETL)
- Statistical evaluations
- Integrating with the telephone system
- Improving security requirements for data access
- Optimizing data storage and tuning the MS SQL Server
- Documenting and testing 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 for Logistics and Warehouse Databases
MuK + Transthermos GmbH
- Designing, programming, and creating SQL scripts for Informix interfaces in EDIFACT and FORTRAS formats
- Testing, installing, and commissioning bidirectional data exchange interfaces
- Integrating interfaces into internal processing and syncing with customer databases
- Programming small utilities for accounting, sales, and controlling
- Reporting and intranet analyses in Excel, HTML, and print formats
- Developing extensive Perl libraries for database access and GUI
- Designing and implementing a data warehouse system including ETL processes
- Server automation scripts to distribute reports and monitor data inputs
- Technologies: Informix, MySQL, SQL, ER modeling, ETL, QlikView, Perl, PHP, sh/csh, HTML, JavaScript, shell script
Business Analysis, Enhancement and Maintenance of a Sales Database
E.ON Energie Deutschland GmbH
- Requirements analysis for the sales department
- Designing, modeling, and implementing a data structure in Oracle
- Creating an authorization concept
- Developing the Access frontend with VBA
- Testing, documenting, and commissioning
- Maintenance and further development
- User support
- Technologies: ER modeling, Oracle, VB/VBA, MS Access, SQL
Business analysis, development and maintenance of a knowledge database
NetExpress Network Solutions GmbH
- Gathering requirements from users across different departments
- Designing, modeling, and implementing a data structure in Postgres
- Creating an access control concept
- Developing the application including frontends
- Testing, documentation, and deployment
- Coordinating change and enhancement requests
- Installing a bug-tracking system (iTracker)
- Testing and updating the documentation
- Technologies: ER modeling, VB/VBA, MS Access, MS Excel, 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, Logistics, Product Development, Quality Assurance, and Accounting.
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 Graphical Presentation (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 (From 2000), Informix, Ms Access, Mysql, Postgres, Db2, Dbase, Er Modeling, Etl, Dwh
Api / 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, Trade, Medical Technology, Telecommunications, Logistics, Chemicals, Electrical Industry
Languages
Education
Diploma in 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 Oracle Consulting and Development
Nearby freelancers
Professionals working in or nearby Munich, Germany