Olaf Taesch - BI Architect in the Kanban Team

Jessen (Elster), Germany

Experience

May 2024 - Present

1 year 9 months

Hamburg, Germany

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.

Jun 2022 - Mar 2024

1 year 10 months

Hamburg, Germany

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.

Jun 2021 - May 2022

1 year

Hamburg, Germany

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.

Jan 2018 - Dec 2020

3 years

Hamburg, Germany

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.

Jul 2017 - Dec 2017

6 months

Kiel, Germany

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.

Aug 2016 - Jun 2017

11 months

Hamburg, Germany

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.

Jul 2015 - Jul 2016

1 year 1 month

Frankfurt, Germany

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.

Jun 2013 - Mar 2014

10 months

Erfurt, Germany

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.

Jul 2010 - Jun 2015

5 years

Berlin, Germany

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.

Aug 2008 - May 2009

10 months

Berlin, Germany

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.

Nov 2007 - Mar 2008

5 months

Berlin, Germany

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.

Oct 2007 - Dec 2012

5 years 3 months

Wiesbaden, Germany

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.

May 2007 - Jul 2007

3 months

Hanover, Germany

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.

Jan 2005 - Dec 2008

4 years

Augsburg, Germany

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.

Oct 2004 - May 2007

2 years 8 months

Berlin, Germany

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.

Oct 2003 - Dec 2004

1 year 3 months

Berlin, Germany

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.

Aug 2001 - Dec 2002

1 year 5 months

Berlin, Germany

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.

Jan 1999 - Present

27 years 1 month

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.

Jul 1998 - Jun 2001

3 years

Frankfurt, Germany

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.

Jun 1995 - Jun 1998

3 years 1 month

Stuttgart, Germany

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.

Dec 1994 - May 1995

6 months

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.

Oct 1994 - Nov 1994

2 months

Munich, Germany

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.

Jan 1994 - Present

32 years 1 month

Jessen, Germany

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).

Jan 1994 - Sep 1994

9 months

Berlin, Germany

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.

Jun 1993 - Dec 1993

7 months

Berlin, Germany

Consultant

Microdata

Developed a production planning and control (PPC)/ERP solution.
Technical environment: HP-UX, SINIX.
Database: DB++.
Tools: C, C++, XVT.

Sep 1988 - May 1993

4 years 9 months

Jessen, Germany

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.

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