Olaf Taesch
BI Architect in the Kanban Team
Experience
BI Architect in the Kanban Team
Gulp / Randstad for HHLA
- Creating automated tests.
- Extending the functionality of the enterprise BI data warehouse.
- Design and development in SQL and PL/SQL.
- Data modeling as well as performance measurement and tuning.
- Creating and working on user stories and concepts.
- Technical environment: Windows, Linux.
- Database: Oracle 19c incl. DWH, CDB, PDB.
- Tools: Confluence, CVS, Eclipse, Git, GitLab, Jira, N4, PL/SQL, SQL Developer, utPLSQL.
Consultant (Architecture and Implementation) in the Kanban Team TRail
IPSWays for EGIM
- Creating automated tests.
- Extending the functionality of the container rail logistics solution TRail.
- Design and development in Java, SQL, and PL/SQL.
- Implementation of EDI interfaces (AC03, EDIFACT, IFTMIN, JSON, XML, etc.).
- Data modeling as well as performance measurement and tuning.
- Creating and working on user stories and concepts.
- Technical environment: Windows, Linux.
- Database: Oracle 19c.
- Tools: Bitbucket, Confluence, Docker, Git, IntelliJ, Java, Jenkins, Jira, Maven, PL/SQL, PL/SQL Developer, SQL*Plus, utPLSQL.
Consultant in the Kanban Team Invoicing
IPSWays for EUROGATE
- Refactoring and merging of different database systems in the invoicing area for container ship transport.
- Creating automated tests.
- Expanding business and technical functionality.
- Design and development in Java, SQL, and PL/SQL.
- Implementation of interfaces to SAP.
- Data modeling as well as performance measurement and tuning.
- Creating and working on user stories and concepts.
- Technical environment: Windows, Linux.
- Database: Oracle 19c.
- Tools: Bitbucket, Confluence, Docker, Eclipse, Git, Java, Jenkins, Jira, JSON, Maven, PL/SQL, PL/SQL Developer, SQL*Plus, utPLSQL, XML.
Consultant in the Scrum / Kanban Team Tax & Accounting
SMF for Berenberg
- Design and development of tax & accounting solutions in Java, SQL, and PL/SQL.
- Data modeling as well as performance measurement and tuning.
- Implementation and maintenance of interfaces to BZSt, CRS/FATCA, DWH, Elster, IRS, TaxBox, WM.
- Enhancing reporting and certification processes.
- Test automation using various test frameworks.
- Creating and working on user stories and concepts.
- Technical environment: Windows, Linux, Oracle Solaris.
- Database: Oracle 12c, 18c, 19c incl. DWH, DV2, VPD.
- Tools: Angular, APEX, Bamboo, Bitbucket, Camunda, Confluence, Docker, ERwin, Git, IntelliJ, Java, Jenkins, Jira, Jon, JSON, LeanIX, Marathon, Maven, PL/SQL, PL/SQL Developer, Postman, Python, REST, SAFe, SonarQube, Splunk, SQL*Plus, Spring, SVN, utPLSQL, Visual Studio Code, XML.
Consultant in the Scrum Team DWH
CAS for HSH Nordbank
- Creation of requirement specifications for the data warehouse project "zDP" using Data Vault 2.
- Design and data modeling with a customer-specific DSL.
- Contribution to regulatory reporting.
- Technical environment: Windows, Linux.
- Database: Oracle 12c incl. DWH, DV2.
- Tools: Confluence, DataVault2, Eclipse, Jira, PL/SQL, SQL Developer, SQL*Plus, SVN, Universal Datamodel Generator (UDG), XText.
Consultant in the Scrum DWH team
SMF for Berenberg
- Designed and implemented test automation for the enterprise BI data warehouse using Data Vault 2.
- Created concept, prototype, and implementation for automated tests.
- Data modeling and performance measurement.
- Implemented XML and XBRL interfaces to BAIS (regulatory reporting).
- Test management for the DWH.
- Technical environment: Windows, Linux, Oracle Solaris.
- Database: Oracle 12c including DWH, DV2, VPD.
- Tools: APEX, Bamboo, Bitbucket, Confluence, DataVault2, DevOp, ERwin, Git, Jira, JSON, Pentaho, PL/SQL, PL/SQL Developer, Python, QlikView, SonarQube, SourceTree, SQL*Plus, TestRail, XBRL, XML.
Consultant (concept and implementation)
Huxley for Commerzbank
- Converted a BI service from MySQL to Oracle.
- Implemented calculations using statistical methods for independent price verification (I-PV).
- Extended and optimized ETL processes.
- Code and performance analysis and tuning.
- Technical environment: Windows, Linux, Oracle Solaris.
- Database: Oracle 12c, MySQL 5.
- Tools: Ajax, Apache, APEX, Aqua Data Studio, bash, Confluence, Eclipse, HTML, JavaScript, jQuery including DataTables, JSON, Perl, PL/SQL, REST, SQL*Plus, SQL Developer, SVN, XML.
Consultant
IBYKUS Erfurt for Hessische Landesbank
- Software development using the in-house development platform for the HIAP agri-environment program project.
- Further development of customer-specific requirements.
- Bug fixing and technical support.
- Technical environment: Windows.
- Database: Oracle 11.
- Tools: CVS, IBYKUS AP, Remote Desktop, Oracle SQL Developer, PL/SQL.
Consultant (architect and implementation)
T-Systems for Deutsche Telekom
- Long-term further development and maintenance of the BL-T application for preorder research.
- Responsible for architecture, data modeling, and database design.
- Optimization of SOA and SOAP-based services.
- Conducted code reviews and static code analysis.
- Created data vault concepts and further developed the J2EE application.
- Performance measurement and tuning of Oracle RDBMS and Java applications.
- Planning and execution of multiple migration projects.
- Technical environment: Windows, Sun Solaris, AIX.
- Database: Oracle 10, 11, PostgreSQL.
- Tools: APEX, Apache, Eclipse, EJB, Enterprise Architect, ERwin, ETL, Hibernate, HTML, Java, Jenkins, JMS, JSP, JPA, J2EE, Mercury Quality Center, OCI, PL/SQL Developer, Rational Software Architect for WebSphere, REST, Ruby, Sonar/SonarQube, SQL*Plus, Subversion, Struts, SVN, UML, Visual Source Safe/Azure DevOps Server, WebSphere Application Server, WebSphere MQ, XML, XMLBeans.
Consultant (architect and implementation)
T-Systems for Deutsche Telekom
- Continued development and optimization of the BL-T line search and preorder application.
- Maintenance and expansion of the service-oriented architecture.
- Data modeling, database design, and performance optimization.
- Code review and static code analysis of offshore deliveries.
- Execution of migration projects.
- Technical environment: Windows, Sun Solaris, AIX.
- Database: Oracle 10, 11, PostgreSQL.
- Tools: APEX, Apache, Eclipse, EJB, Enterprise Architect, ERwin, ETL, Hibernate, HTML, Java, Jenkins, JMS, JSP, JPA, J2EE, Mercury Quality Center, OCI, PL/SQL Developer, Rational Software Architect for WebSphere, REST, Ruby, Sonar/SonarQube, SQL*Plus, Subversion, Struts, SVN, UML, Visual Source Safe/Azure DevOps Server, WebSphere Application Server, WebSphere MQ, XML, XMLBeans.
Consultant (Architecture and Implementation)
T-Systems for Deutsche Telekom
- Concept and implementation of a line lookup and pre-order in the BL-T project.
- Design and implementation of a service-oriented architecture.
- Data modeling and database architecture.
- Optimization of existing services (SOA, SOAP).
- Code review and static code analysis of offshore projects.
- Creation of IT concepts and further development of the J2EE application BL-T.
- Performance measurement and tuning for Oracle RDBMS and Java.
- Design and implementation of several migration projects.
- Technical environment: Windows, Sun Solaris, AIX.
- Database: Oracle 10, 11, PostgreSQL.
- Tools: APEX, Apache, Eclipse, EJB, Enterprise Architect, ERwin, ETL, Hibernate, HTML, Java, Jenkins, JMS, JSP, JPA, J2EE, Mercury Quality Center, OCI, PL/SQL Developer, Rational Software Architect for WebSphere, REST, Ruby, Sonar/SonarQube, SQL*Plus, Subversion, Struts, SVN, UML, Visual Source Safe/Azure DevOps Server, WebSphere Application Server, WebSphere MQ, XML, XMLBeans.
Consulting / Test Management
T-Systems and CSC for a government agency in Wiesbaden
- Design of automated tests for an application with a dynamic data model.
- Creation of prototypes and implementation of automated tests.
- Design and development of test drivers.
- Collaboration on developing a custom test client.
- Extension of XML interfaces.
- Creation of migration and adaptation scripts.
- Test management and coaching of project team members.
- Technical environment: HP-UX, Linux, Windows.
- Database: Oracle 9, 10, 11 including VPD.
- Tools: Castor, CodeBeamer, HTML, HP Quick Test Professional (QTP), Java, JAXB, Maven, Mercury Quality Center, Oracle SQL Developer, WebLogic Server WLS, Perl, PL/SQL Developer, SQL*Plus, SVN, Telelogic Change Management Synergy CMS, Toad, xalan, xerces, XMLSpy, XML, XSL, XSLT.
Consultant (Architecture Consulting and Design)
Heise Verlag
- Design and contribution to a prototype for a decentralized news ticker (newsticker, channel, forum, newsletter) based on a content management system.
- Consulting on architecture and technical implementation.
- Technical environment: Linux.
- Database: MySQL.
- Tools: Apache Web Server, Perl.
Consultant (Design and Implementation)
Augsburg Clinic
- Data modeling for a planning tool and urology documentation.
- Design and implementation of the migration strategy.
- Design and development of a planning tool.
- Development of a urology documentation system including statistics and automatic mail merge generation.
- Technical environment: UNIX, Windows.
- Database: Oracle 9i.
- Tools: Eclipse, HTML, OCI, Perl, PHP, PL/SQL Developer.
Consultant / Deputy Project Manager
T-Systems for Deutsche Telekom
- System analysis as well as web server and database programming for a telecom provider.
- Design and implementation of a high-availability system.
- Data modeling and performance tuning.
- Co-development of several J2EE applications.
- Design and implementation of a service-oriented architecture over HTTP and JMS.
- Creation of business analyses, functional specifications, and IT concepts.
- Organization and execution of an offshore project.
- Technical environment: HP-UX, Sun Solaris, Windows.
- Database: Oracle.
- Tools: Apache Web Server, ClearCase, Eclipse, EJB, Enterprise Architect, HTML, IBM WebSphere Application Developer (WSAD), IBM WebSphere Application Server Toolkit (ASTK), Java, JMS, JSP, J2EE, Mercury Quality Center, OCI, Perl, PL/SQL Developer, Rational Application Developer, Samba, SQL*Plus, Subversion, Struts, Toad, Tomcat, UML, WebSphere Application Server, WebSphere MQ, XML, XMLBeans.
Consultant
T-Systems für Deutsche Telekom
- Continued work on DSL infrastructure management.
- System analysis, web server and database programming.
- Further performance tuning and data modeling.
- Implementation of migration and architecture projects and maintenance of the automated email dispatch system.
- Technical environment: HP-UX, Linux, Sun Solaris, Windows.
- Database: Oracle.
- Tools: Apache Web Server, APEX, ASP, Eclipse, CGI, HTML, IIS, Java, OCI, Perl, PHP, PL/SQL Developer, Remedy Action Request System, Samba, SQL*Plus, SQL Server, TestDirector, Toad.
Consultant
T-Systems für Deutsche Telekom
- System analysis, web server and database programming for DSL infrastructure management of a telecom provider.
- Data modeling and performance tuning.
- Study and prototype of a conversion from ASP to PHP.
- Development of an automated mail dispatch system.
- Execution of various migration projects and architecture analyses.
- Technical environment: HP-UX, Linux, Sun Solaris, Windows.
- Database: Oracle.
- Tools: Apache Web Server, APEX, ASP, Eclipse, CGI, HTML, IIS, Java, OCI, Perl, PHP, PL/SQL Developer, Remedy Action Request System, Samba, SQL*Plus, SQL Server, TestDirector, Toad.
Consultant / Project Manager
ammoSYS
- Design and implementation of a securities trading system.
- Implementation of chart analysis functions.
- Set up automatic price updates over the Internet.
- Implementation of automatic order placement.
- Technical environment: Linux.
- Databases: MySQL, MariaDB.
- Tools: Apache Web Server, Flask, Matplotlib, NumPy, Pandas, Perl, PHP, Python.
Consultant
Dresdner Bank
- Worked on the "WEB-Publishing" study and carried out tool evaluations.
- Introduced the NPS content management system.
- System analysis, design and implementation to replace a mainframe solution.
- Development of a portal for business information.
- System integration of web application, search engine and publishing system.
- Technical environment: Sun Solaris, Windows.
- Databases: MySQL, Oracle.
- Tools: Apache Web Server, CGI, HTML, HTML-Transit, Infopark NPS, Netscape Enterprise Server, Perl, PHP, Samba, SQL*Plus, TCL, Verity Information Server.
Consultant / Technical Project Manager
Landesamt für Flurneuordnung Baden-Württemberg
- Design and development of a data management system for a graphical geo-information system.
- Development of interfaces to SAP R/3.
- Creation of a system class library.
- Technical environment: Windows.
- Databases: Gupta SQL, Oracle.
- Tools: SQL-Windows, Centura Team Developer, C++, Java, Team Windows, ERwin, SQL-Base, Team Object Manager, Oracle Procedure Builder, Oracle Web Server, PL/SQL.
Consultant
Systema
- Developed a cost distribution calculation for a debt collection system.
- SQL-Windows and database programming.
- Technical environment: Novell, RS/6000, Windows.
- Databases: Oracle, SQL-Base.
- Tools: SQL-Windows.
Consultant
AIC for TÜV Bavaria
- Designed and set up a database replication for an appraisal project.
- Technical environment: Windows.
- Databases: Oracle, Gupta SQL-Base.
- Tools: SQL-Windows.
Consultant
Self-employed
- Self-employed consultant since 1994 as an Oracle Senior Consultant.
- Focus areas: data warehouse, Data Vault 2, database architecture, data modeling, database programming, performance measurement and tuning.
- Worked in project management, technical project leadership and requirements engineering across various industries (banking, government, industry, medical technology, media, telecommunications, software).
Consultant
AIC and IBM for the Berlin State Office for Settlement of Unresolved Asset Issues
- Designed and co-developed a workflow system (Managementflow).
- Text data integration and data modeling.
- Set up a text data management system with centrally managed text modules.
- Technical environment: IBM, Unix, Windows.
- Database: Informix.
- Tools: Q+E, SQL-Windows, Visual Basic.
Consultant
Microdata
- Developed a production planning and control (PPC)/ERP solution.
- Technical environment: HP-UX, SINIX.
- Database: DB++.
- Tools: C, C++, XVT.
Head of organization and data processing / CIO
GMJ Jessen
- Application programming and system programming.
- Implementation of a PPS/ERP solution in mechanical engineering.
- Responsibility for organization and data processing.
- Technical environment: DOS, HP-UX, RSX.
- Database: Eloquence.
- Tools: dBase, DECnet, Turbo Pascal, Turbo Vision.
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 (32 years), Professional Services (32 years), Banking and Finance (28 years), Telecommunication (11 years), Government and Administration (9 years), and Manufacturing (5.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 (37 years), Business Intelligence (32 years), Project Management (32 years), Product Development (28 years), Quality Assurance (7 years), and Operations (5.5 years).
Skills
Core Competencies
- Oracle Senior Consultant
- Data Warehouse, Data Vault 2, Cdvp2
- Database Architecture, Data Modeling
- Database Programming, Ocp
- Performance Measurement And Tuning
- Project Management And Technical Project Leadership
- Requirements Engineering
Industries
- Banking: Web Publishing And Content Management, Securities Trading System, Bi Service, Dwh, Taxes, Data Modeling, Regulatory Reporting, Tax
- Government: Case Management, Geo-information System, Test Automation
- Industry: Cio, Erp, Invoicing, Transport, Logistics
- Medical Technology: Urology, Controlling
- Media: News Ticker
- Software: Pps / Erp, Debt Collection System
- Telecom: Multiple Projects In Dsl And Ordering
It Detailed Knowledge
- Operating Systems: Unix (Aix, Hp-ux, Sun Solaris, Oracle Solaris), Linux (Debian, Mint, Oracle Linux, Red Hat, Suse, Ubuntu), Windows (Xp / 7 / 8 / 10 / 11), Windows Server (2003 / 2008 / 2012 / 2016)
- Architectures: Docker, Eai, Ejb, J(2)ee, Rest, Soa, Soap, Webservice
- Process Models: Kanban, Scrum, Safe, Waterfall
- Databases: Gupta, Informix, Mariadb, Mysql, Oracle (8, 9i, 10g, 11g, 12c, 18c, 19c, 21c), Postgresql, Ms Sql Server
- Modeling Languages: Bpmn, Er, Pap, Uml
- Programming Languages: C, C++, Java, Lua, Perl, Pl/pgsql, Pl/sql, Python, Ruby, T-sql, Shell (Bash, Cmd, Ksh, Powershell, Sh), Sql, Sql Windows, Tcl, Visual Basic, Xslt
- Web Technologies: Ac03, Ajax, Angular, Asp, Bootstrap, Cgi, Css, Dtd, Flask, Iftmin, Html, Javascript, Jquery, Jsp, Json, Php, Rest, Struts, Soa, Soap, Spring, Svg, Wsdl, Xampp (Lamp, Wamp…), Xbrl, Xsd, Xsl, Xml
- Middleware: Bea, Java Ee (J2ee/jee), Jboss, Jms, Mq, Rpc, Tomcat, Ibm Websphere Application Server, Oracle Application Server (Oas), Oracle Weblogic Server (Wls)
- Tools / Frameworks: Ant, Apache Web Server, Aqua Data Studio, Axon, Azure Devops Server, Bamboo, Bea Weblogic Server (Wls), Bitbucket, Camunda, Castor, Centura Team Developer, Chart Director, Clearcase, Cm Synergy, Confluence, Codebeamer, Cvs, Datavault2, Devop, Dwh, Eclipse, Ejb, Enterprise Architect, Ibm Websphere Application Server Toolkit (Astk), Erwin, Etl, Git, Hibernate, Hp Quick Test Professional (Qtp), Ibykus Ap, Infopark Nps, Intellij, Jaxb, Jboss, Jbuilder, Jdbc, Jenkins, Jira, Jon, Joomla, Jpa, Junit, Keycloak, Leanix, Maven, Mercury Quality Center, Ms Internet Information Server, Netscape Enterprise Server, Nginx, Numpy, Odbc, Oracle Apex, Oracle Call Interface (Oci), Oracle Data Modeler, Oracle Designer, Oracle Procedure Builder, Oracle Sql Developer, Office (Libre, Ms, Open), Owncloud, Pentaho, Phpeclipse, Phpnuke, Pl/sql Developer, Postman, Ppi Udg, Qlikview, Rational Application Developer (Rad), Rational Software Architect (Rsa), Remedy Action Request System, Samba, Selenium, Sonar / Sonarqube, Sourcetree, Sql*plus, Splunk, Spring, Subversion (Svn), Swing, Team Object Manager, Testdirector, Testrail, Toad, Tora, Universal Datamodel Generator (Udg), Utplsql, Verity Information Server, Visual Source Safe, Visual Studio Code, Vmware, Websphere Studio Application Developer (Wsad), Websphere Mq, Xalan, Xerces, Xmlbeans, Xmlspy, Xtext
Special Skills
- Data Warehouse, Data Vault 2
- Database Architect
- Relational Databases, Oracle
- Test Automation
- Requirements Management
- Process Analysis
Languages
Education
Diploma in Business Informatics · Business Informatics
Certifications & licenses
Certified Data Vault 2.0 Practitioner (CDVP2)
Oracle Certified Professional – Advanced Pl/SQL Developer (OCP)
Oracle Pl/SQL Developer Certified Associate (OCA)
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Olaf based?
What languages does Olaf speak?
How many years of experience does Olaf have?
What roles would Olaf be best suited for?
What is Olaf's latest experience?
What companies has Olaf worked for in recent years?
Which industries is Olaf most experienced in?
Which business areas is Olaf most experienced in?
Which industries has Olaf worked in recently?
Which business areas has Olaf worked in recently?
What is Olaf's education?
Does Olaf have any certificates?
What is the availability of Olaf?
What is the rate of Olaf?
How to hire Olaf?
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 BI Architect in the Kanban Team
Nearby freelancers
Professionals working in or nearby Jessen (Elster), Germany