Olaf Taesch-BI Architect in a Kanban Team
Check rate
Experience
BI Architect in a Kanban Team
Gulp / Randstad for HHLA
- Creation of automated tests.
- Extension of 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.
- Creation of and contribution to 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
- Creation of automated tests.
- Extension of 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.
- Creation of and contribution to 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 consolidation of different database systems in the invoicing environment for container ship transport.
- Creation of automated tests.
- Extension of the 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.
- Creation of and contribution to 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 support of interfaces to BZSt, CRS/FATCA, DWH, Elster, IRS, TaxBox, WM.
- Extension of reporting and certification processes.
- Test automation using different test frameworks.
- Creation of and contribution to 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.
- Support for 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 a Scrum Team DWH
SMF for Berenberg
- Design and implementation of test automation for the enterprise BI data warehouse using Data Vault 2.
- Creation of the concept, prototype, and implementation of automated tests.
- Data modeling and performance measurement.
- Implementation of XML and XBRL interfaces to BAIS (reporting).
- Test management for the DWH.
- Technical environment: Windows, Linux, Oracle Solaris.
- Database: Oracle 12c incl. 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
- Conversion of a BI service from MySQL to Oracle.
- Implementation of calculations using statistical methods for Independent Price Verification (I-PV).
- Expansion and optimization of ETL processes.
- Code and performance analysis as well as 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 incl. DataTables, JSON, Perl, PL/SQL, REST, SQL*Plus, SQL Developer, SVN, XML.
Consultant
IBYKUS Erfurt for Hessische Landesbank
- Software development with the company's own development platform in the HIAP agricultural 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 development and maintenance of the BL-T application for pre-order research.
- Responsibility for architecture, data modeling, and database architecture.
- Optimization of SOA and SOAP-based services.
- Conducting code reviews and static code analysis.
- Creation of DV concepts as well as further development of the J2EE application.
- Performance measurement and tuning of Oracle RDBMS and Java applications.
- Planning 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.
Consultant (architect and implementation)
T-Systems for Deutsche Telekom
- Further development and optimization of the line research and pre-order application BL-T.
- Maintenance and expansion of the service-oriented architecture.
- Data modeling, database architecture, performance optimization.
- Code review and static code analysis of offshore deliveries.
- Carrying out 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 process 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 technical concepts and further development of the J2EE application BL-T.
- Performance measurement and tuning in the Oracle RDBMS and Java area.
- Planning 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 an authority in Wiesbaden
- Planning of automated tests for an application with a dynamic data model.
- Creation of prototypes and implementation of automated tests.
- Planning and development of test drivers.
- Support in 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 incl. 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 Concept)
Heise Verlag
- Planning and work on a prototype for a decentralized news ticker (news ticker, 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 (Concept and Implementation)
Klinikum Augsburg
- Data modeling for a planning tool and urology documentation.
- Design and implementation of the migration strategy.
- Design and creation of a planning tool.
- Development of urology documentation incl. statistics and automatic form letter 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 the service-oriented architecture via HTTP and JMS.
- Creation of business analyses, technical concepts, 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 for 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 as well as maintenance of the automatic mail delivery 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 for Deutsche Telekom
- System analysis as well as web server and database programming for a telecom provider's DSL infrastructure management.
- Data modeling and performance tuning.
- Study and prototype of a conversion from ASP to PHP.
- Creation of an automatic mail delivery 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
- Concept and implementation of a securities trading system.
- Implementation of chart analysis functions.
- Setup of automatic price updates via the internet.
- Implementation of an automatic order feature.
- 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.
- Introduction of the NPS content management system.
- System analysis, design, and implementation to replace a mainframe solution.
- Creation 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 Lead
Landesamt für Flurneuordnung Baden-Württemberg
- Design and creation 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
- Development of a cost allocation 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 Bayern
- Design and setup of database replication for an expert report 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.
- Work in project management, technical project leadership, and requirements engineering in different industries (banking, public authorities, manufacturing, medical technology, media, telecommunications, software).
Consultant
AIC and IBM for the Berlin State Office for the Regulation of Open Property Issues
- Design and co-development of a workflow system (Managementflow).
- Text data integration and data modeling.
- Setup of 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
- Development of a PPS/ERP solution in the area of production planning and control systems.
- 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.
- Introduction 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.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Professional Services, Banking and Finance, Telecommunication, Government and Administration, and Manufacturing.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Project Management, Product Development, Quality Assurance, and Operations.
Skills
Core Competencies
- Oracle Senior Consultant
- Data Warehouse, Data Vault 2, Cdvp2
- Database Architect, Data Modeling
- Database Programming, Ocp
- Performance Measurement And Tuning
- Project Management And Technical Project Lead
- Requirements Engineering
Industries
- Banking: Web Publishing And Content Management, Securities Trading System, Bi Service, Dwh, Taxes, Data Modeling, Reporting, Tax
- Public Sector: Process Control, 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: Several Projects In The Dsl And Ordering Area
It Details
- 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 Knowledge
- 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)
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 BI Architect in a Kanban Team
Nearby freelancers
Professionals working in or nearby Jessen (Elster), Germany
