Joachim Bleichert-Oracle Consulting and Development
Check rate
Experience
Oracle Consulting and Development
Berufsgenossenschaft Nahrungsmittel & Gastgewerbe (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
Development and maintenance of a company-wide monitoring database
Badische Anilin- und Sodafabrik (BASF SE)
- Gathering requirements from the business units
- Design
- Implementation at the database level and in APEX
- Creating 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 gathering and business analysis
- Fixing issues in 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 gathering and business analysis
- Implementation of the static report design
- Implementing and optimizing requirements in consultation with the business unit
- Analysis of existing data structures
- Developing database queries
- Creating 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 gathering and business analysis
- Analysis of data structures
- Development of a test data generator for large datasets
- Implementation in PL/SQL
- Creating 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 permission 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 reporting 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 loading of the new system with master data
- Synchronization of the old and new system
- Data validations
- Dynamic generation of PL/SQL code using VBA scripts with error logging
- Generation of reports
- Technologies: Oracle, PL/SQL, SQL Developer, VBA, MS Excel
BA and consulting in redesigning 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 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
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 departments 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 Custom Programming in Banking Environment
Fiducia & GAD IT AG
- Creation of software packages with MSI and InstallShield
- Creation and customization of Perl and shell scripts for precise control of package installation on different Windows platforms
- Test installations on various platforms
- Design and programming of Perl scripts for automated package adjustments to new releases
- Support for software distribution in troubleshooting
- Technologies: SQL, InstallShield, MSI, Perl, PowerShell, sh/csh
Business Analysis and Programming of Automations in the EDA Environment
Texas Instruments Deutschland GmbH
- Requirements analysis and business analysis
- Automation of data archiving including concept development, programming, integration, and testing
- Analysis of EDA data on component usage for error investigations
- Creation of 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
- Conceptualization of the implementation and effort estimation
- Database design and modeling
- Frontend enhancements and improvements, adjustment of data structure
- Data import (ETL)
- Statistical evaluations
- Integration with the telephone system
- Enhancement of security requirements for data access
- Data management optimization and tuning of the MS SQL Server
- Documentation and testing of adjustments
- Technologies: MS SQL Server 2005 – 2014, Transact-SQL, ETL, ER modeling, VB/VBA, MS Access, Windows Server, Crystal Reports
Business Analysis and Development in the Context of Logistics and Warehouse Management Databases
MuK + Transthermos GmbH
- Design, programming, and creation of SQL scripts for Informix interfaces in EDIFACT and FORTRAS formats
- Testing, installation, and commissioning of bidirectional data exchange interfaces
- Integration of interfaces into internal workflows and synchronization with customer databases
- Programming small helper programs for accounting, sales, and controlling
- Reporting and intranet analyses in Excel, HTML, and print formats
- Development of extensive Perl libraries for database access and GUI
- Design and implementation of a data warehouse system including ETL processes
- Automation scripts on servers for distributing reports and monitoring data inputs
- Technologies: Informix, MySQL, SQL, ER modeling, ETL, QlikView, Perl, PHP, sh/csh, HTML, JavaScript, shell scripting
Business Analysis, Enhancement and Maintenance of a Sales Database
E.ON Energie Deutschland GmbH
- Requirements analysis from the sales department
- Design, modeling, and implementation of a data structure in Oracle
- Creation of an authorization concept
- Development of the Access frontend using VBA
- Testing, documentation, 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 of different departments
- Design, modeling and implementation of a data structure in Postgres
- Creating an authorization concept
- Developing the application including frontends
- Testing, documentation and deployment
- Coordinating change and enhancement requests
- Installing a bug-tracking system (iTracker)
- Testing and adjusting 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 Representation (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, Chemicals, Electrical Engineering
Languages
Education
Diploma in Engineering · Electrical Engineering, Communications Engineering
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
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
