Torsten Glunde - BI Consultant for Datavault and DataOps

🚀 FRATCH GPT 2.0 - Find freelancers with a single prompt. Now including price benchmarking.

Recommended expert

Hanover, Germany

Check rate

Experience

Jan 2024 - Dec 2024

1 year

Data Vault with Informatica on Oracle

SEFE

Data Vault modeling and performance improvements in Oracle.
Requirements process with model-driven Data Vault automation.
Preparation of business requirements for the price database in the gas and electricity market.
Sales performance based on Salesforce CRM.
Tasks: Concept and development.
Tools used: Informatica, Oracle, DBT, Docker, DataOps, Airflow Workflow, Python Ingestion, Gitlab CI.

Jul 2023 - Dec 2023

6 months

Datavault Builder Data Warehouse with Qlik frontend

NVL - Luerssen

Data Vault modeling and performance improvements in Snowflake with Datavault Builder and the business rules in DBT.
Tasks: Concept and development.
Tools used: Datavault-Builder, Snowflake, Azure, DBT, Docker, DataOps, Airflow Workflow, Python Ingestion, Gitlab CI.

Jul 2022 - Present

4 years 3 months

Alligator Company in-house consulting product

ACS

Development of a consulting product, ACS-Datastack, based on open source data pipelines (CNCF, Argo, DBT and Airbyte) and model-driven Data Vault automation (AutomateDV, Datavault Builder).
Development of the IaC and GitOps-based automation solution.
Tasks: Concept and development.
Tools used: Datavault-Builder, Exasol, Snowflake, Azure Synapse, Postgres, BigQuery, DBT, Docker, DataOps, Argo Workflow, Python Ingestion, Airbyte Ingestion, k3s, Gitlab CI.

Apr 2021 - Jul 2022

1 year 4 months

Data Vault Automation Datavault Builder, data management and GitOps

Gelita

Review of an existing implementation of Datavault Builder on Exasol.
Introduction of ELM workshops for requirements gathering and consistent modeling in Data Vault.
Transformation rules in DBT with a corresponding continuous integration test and deployment pipeline.
Runtime environment (DataOps) in Kubernetes (k3s, Argo Workflow) with disposable development, staging and production - introduction and training with development guides and GitOps approaches.
Tasks: Consulting on data architecture and introduction of GitOps.
Tools used: Datavault-Builder, Exasol, DBT, Docker, DataOps, Argo Workflow, Python Ingestion, k3s, Gitlab CI, PowerBI.

Sep 2020 - Mar 2021

7 months

Berlin, Germany

Data Vault Automation Datavault Builder, data management and GitOps

GVL

Review and consulting on the concepts for Data Vault modeling, automation and DataOps.
Initial introduction of the Snowflake data warehouse and migration of data to the cloud.
Extensive consulting on data management, procedures, development guides and deployment planning for the tools (Datavault-Builder, DBT, Airflow and Git).
Organizational consulting on the alignment of the newly founded Data Warehouse department.
Tasks: Consulting and PoC execution.
Tools used: Datavault-Builder, Snowflake, DBT, Docker, AWS DataOps, Python Ingestion, Airflow, Tableau.

Aug 2020 - Aug 2020

1 month

Munich, Germany

Data Vault automation with DBT on Snowflake with Airflow, DataOps

E.ON

Review and consulting on the concepts for Data Vault modeling, automation, and DataOps.
Suggestions for improvements in architecture and implementation using DBT, Airflow, Docker, Kubernetes, and Snowflake.
Tasks: review and consulting.
Tools used: Datavault-Builder, Snowflake, DBT, Kubernetes, Docker, Azure DataOps, Python, Airflow.

Jun 2020 - Mar 2021

10 months

Stuttgart, Germany

DWH DataOps, architecture and introduction of Data Vault Builder and Exasol

Vector.com

Requirements analysis and implementation of requirements in the area of an automotive supplier in embedded software development.
Introduction of DataOps methods in Microsoft Azure using Exasol, Datavault Builder.
Consulting and training on modeling, development methods, and cost analysis for introducing a new data warehouse infrastructure and development.
Tasks: design, consulting, and training for introducing the infrastructure and development methods.
Tools used: Datavault-Builder, Exasol, DBT, Kubernetes, Docker, Azure DataOps.

Jun 2019 - Dec 2019

7 months

Munich, Germany

BI architecture and DWH modernization

SBK

Carrying out POC and consulting on DWH modernization with DBT and Datavault Builder on the Exasol database.
Programming the DBT adapter for Exasol in Python and Jinja.
CI/CD using Gitlab.
Tools used: Exasol, DBT, ELT, Docker, Gitlab, CI/CD, VisualStudio Code, batch processing, ELT/ETL, DevOps/DataOps, TDD, Python.

Jan 2019 - Mar 2020

1 year 3 months

BI architecture, Data Vault and cloud migration

TUI InfoTec

Architecture consulting and implementation of DevOps/DataOps, mechanisms, and renewal of the data pipeline with Python and DBT.
Defining test scenarios with DBT.
Scheduling batch processing with Airflow.
CI/CD using Gitlab.
Tools used: Docker, AWS S3, SQL, DB2 BLU, Amazon Redshift, Informatica, Snowflake DB, DBT, Python, Airflow, Kubernetes, batch processing, ELT/ETL, DevOps/DataOps, TDD, CI/CD, Gitlab.

Jun 2018 - Jan 2019

8 months

BI architect and Data Vault modeling

HSH Nordbank

Architecture consulting in the implementation project.
UDG Data Vault Generator XText and Java.
Physical DB optimization on Oracle.
Tools used: UDG Data Vault, Oracle, batch processing, ELT/ETL, TDD.

Jul 2017 - Mar 2018

9 months

Solution Architect

Uelzener Tier

Introduced the solution architecture with Datavault Builder and guidelines for implementing the business model. A special part was the bi-temporal source system, which was built in the Data Vault with a versioned hub.
In the dimensional model, the source views for the Qlik frontend were created and performance optimizations were carried out on SQL Server.
Execution plans were analyzed and measures such as indexing and Business Vault materializations were applied.
Existing Talend ETL processes were also replaced and adapted to the new source structures of the EDWH.
Tools used: Datavault Builder, SQL Server, SQL, GIT, Qlik, Talend.

Apr 2017 - Jul 2018

1 year 4 months

BI Architect and Data Vault Modeling

Talanx – HDI Global SE

Responsibility for architecture, modeling guidelines, and advising the modelers in the implementation project.
UDG Data Vault Generator XText and Java.
IGC glossary and mapping transports.
IDA logical modeling and implementation in Data Vault.
Develop test scenarios for batch jobs with DBFit/Fitnesse.
Tools used: UDG Data Vault, Oracle, batch processing, ELT/ETL TDD.

Sep 2015 - Mar 2017

1 year 7 months

BI Architect and Data Vault Modeling

VHV

Modeling of E-DWH and Data Mart with MID Innovator Data Vault modeling and automation.
DB2 Column Store database DB2 BLU.
OBIEE frontend reporting.
TDD and DataOps/DevOps for MID Automation and SAS-DI / Talend batch jobs.
Tools used: MID Innovator, DB2 BLU, SAS-DI, SAS, OBIEE, batch processing, ELT/ETL, DataOps/DevOps, TDD.

Sep 2014 - Aug 2015

1 year

BI Consultant E-DWH DataVault

DPV

Modeling of E-DWH and Data Mart with PowerDesigner.
Implementation of Informatica processes for loading data.
Maintenance and support of SSIS, SSAS, and SSRS implementation based on MSSQL.
Data Vault modeling and automation.
Exasol PoC against Oracle Column Store.
Tools used: Informatica, MSSQL 2012, SSIS, SSRS, SSAS, SSDT, TFS, Cognos 10.x, PowerDesigner, Exasol, batch processing, ELT/ETL.

Sep 2012 - Dec 2012

4 months

BI Architecture, eDWH Design with Data Vault

Westfalia Automotive

Creation and validation of a business and implementation concept for an eDWH based on a Data Vault core.
Tools used: BODS, PostgreSQL, SAP BI-4, Power Architect, Jedox, batch processing, ELT/ETL.

Aug 2011 - May 2014

2 years 10 months

BI Architect, EDWH Design

Netrada

POC, design and implementation of the EDWH.
SCRUM Master and Agile Coaching.
Architecture and implementation of the SQL Server FastTrack instance, including modeling of the logical and physical data model.
3NF modeling in the CORE Warehouse and dimensional modeling for the frontend.
Modeling and implementation of Framework Manager models in Cognos.
Implementation and design of ETL processes in Informatica PowerCenter and SSIS.
Tools used: Informatica, MSSQL 2012 FastTrack, MS SSIS, Cognos 10.x, Power Designer,, batch processing, ELT/ETL, TDD.

Jul 2011 - Dec 2011

6 months

Pentaho PDI / Kettle EII, Mondrian

Finanz Informatik

EII implementation for processing and caching Mondrian queries on a host DB2 legacy database.
Tools used: Pentaho, DB2 UDB, DB2 host.
Standards used: SQL, datamart, DB design, performance tuning, star join optimization, batch processing, ELT/ETL.

Jul 2009 - Jul 2011

2 years 1 month

BI Architect Pentaho, Business Objects and Cognos

Finanz Informatik

Evaluation and POC for tool selection between Pentaho, BO and Cognos.
Implementation of Pentaho and Mondrian in WebSphere and a custom deployment environment.
Tools used: Pentaho PDI, Business Objects, DB2 UDB, DB2 host, DataStage, Mercury Quality Center, LoadRunner, Cognos, S-DWH, iWHS, IBM Federation Server, Power Designer.
Standards used: SQL, datamart, DB design, performance tuning, star join optimization, batch processing, ELT/ETL.

Mar 2009 - Dec 2013

4 years 10 months

BI ETL Developer

HASPA

Creation of a datamart, universe and reports based on DB2, Informatica and Business Objects in the area of CRM, KBP / update.
Concept creation, modeling, implementation and rollout in the business area.
Tools used: Business Objects, DB2 UDB, DB2 host, Informatica PowerCenter 8.6, Mercury Quality Center, LoadRunner, KBP from Update, IBM Data Architect Modeling.
Standards used: SQL, datamart, DB design, performance tuning, star join optimization, batch processing, ELT/ETL.

Mar 2009 - Aug 2009

6 months

Creation of an Enterprise Data Warehouse

Kabel Deutschland GmbH

Creation and validation of a business and implementation concept for an eDWH based on a Data Vault core.
Analysis and development of an enterprise data warehouse.
Subproject lead of the development stream (ETL development and modeling).
Creation of a technical data warehouse assessment.
Requirements analysis with the business department, batch processing, ELT/ETL.
Tools used: Oracle 11g, Erwin, Crystal Reports, Business Objects Strategy Management, Business Objects XI, Business Objects Data Services (Data Integrator, Data Quality), Business Objects Universe Designer, PL/SQL, SAP BW, Office Suite.

Sep 2006 - Dec 2006

4 months

BI Architect ETL, CDC, BO, Informatica

VW

Architecture and evaluation, documents for technical specification and requirements management.
Tools used: Business Objects, Informatica PowerCenter, Oracle, DB2 host, Websphere Information Integration, MQSeries, Unix, ERWin.
Standards used: Change Data Capture, SQL, batch processing, ELT/ETL.

Mar 2006 - Oct 2006

8 months

Transport management system Eclipse, Weblogic

DP-ITSolutions

Data management and JAAS security implementation Weblogic.
Leading offshore teams (in Russia).
Tools used: Eclipse, Maven, Ant, Junit, Tomcat, SOA, HSQLDB, Postgres, Spring-IOC, Spring-ORM, Oracle, OWB, BEA Weblogic 9, JAAS, Unix.
Standards used: OOA, OOD, J2EE, JSP + Servlets, Web services, SOA, XML, XSLT, MVC.

Jan 2006 - Jun 2009

3 years 6 months

BI Architect Business Objects

FinanzIT

Technical design of the use of Business Objects in a multi-tenant environment in the customer's infrastructure.
Multi-tenancy and standard reporting releases, auditing and billing of the services provided as a data center for the customer.
Performance tuning and system design, preparation, execution and evaluation of the load test to verify the infrastructure.
Support and coaching for the development of datamart design, universe design and report development.
Tools used: Business Objects, DB2 UDB, DB2 host, Postgres, Power-Designer, Weblogic, Unix, DataStage ETL, FastTrack, Mercury Quality Center and LoadRunner.
Standards used: SQL, datamart, DB design, performance tuning, batch processing, ELT/ETL.

Jul 2005 - Feb 2006

8 months

Seminar booking and billing

Telekommunikation

Technical project management of a seminar booking system and a billing solution.
Implementation of a web application based on Tapestry, Spring-IOC, Spring-ORM, Spring-AOP and Hibernate.
Design and planning of highly available servers.
OLAP and reporting Business Objects.
Analysis and optimization of processes in the data warehouse, ETL, OLTP.
Tools used: Oracle, Tapestry, Eclipse, Maven, Ant, JUnit, Tomcat, Spring-IOC, Spring-ORM, Spring-AOP, Websphere, Axis, Java 1.5, PL/SQL, Sand Analytic Server, Sand Searchable Archive, DWH, Business Objects (Reporting, OLAP), Unix, Power-Designer.
Standards used: OOA, OOD, J2EE, SOA, UML, SQL.

Aug 2004 - Oct 2012

8 years 3 months

Project management and architecture

Alligator Company Software GmbH

Project: ESB Messaging Server.
Extension of the AlligatorDBC product with ESB functionalities using message queue systems and the OpenESB server.
Expansion of the functionality into a broker with features for EII, XML integration, Web services and JBI – for integrating business process logic.
Project: EII and OLAP BI component.
AlligatorDBC is an EII and OLAP component. It is a 100% pure Java component with interfaces to the best-known BI tools. The OLAP component consists of a dynamic, hybrid MOLAP cube.
Integration with Business Objects, BRIO, Hyperion, SPSS, Cognos, SAP.
Building a Business Intelligence platform with an EII engine (virtual data warehouse) with reporting and OLAP interface.
Data warehouse automation implementation with BIML and SSIS based on DataVault and SQL Server Integration Patterns.
Tools used: Eclipse, Maven, Ant, Junit, Tomcat, Axis, Xerces, Xalan, Jaxen, Digester, Web Services, SOA, HSQLDB, Spring-IOC, Spring-ORM, Sand Analytic Server, Sand Searchable Archive, Oracle, DB2, BIML, SSIS, MSSQL, SAP, Analytic Services, Cognos, SAS, BRIO, Business Objects, Crystal Reports, Hyperion, Unix, Message Queue Server, OpenESB.
Standards used: agile software development, OOA, OOD, J2EE, JSP + Servlets, Web services, SOA, XML, XSLT, MVC, ETL, EII, OLAP, SQL, SCRUM Master, batch processing, ELT/ETL.

May 2004 - Jun 2005

1 year 2 months

The Hague, Netherlands

Webservice, SOA and JSR-168 Portal

Europäisches Patentamt

Based on Axis 1.1, a web service was developed in JAVA that uses access to JINI services to query backend databases.
Using a document/literal service, a pipeline/valve-oriented processing design was implemented with the help of XML transformations.
As a GUI, the user gets access through a portlet that was developed based on the JSR-168 interfaces, so that both Tomcat and WPS can be used as target servers.
Tools used: Eclipse, Maven, Ant, Junit, Tomcat, Axis, Xerces, Xalan, Jaxen, Digester, Spring-IOC, WPS 5, WAS 5, JINI, Java 1.3.1, Unix.
Standards used: OOA, OOD, J2EE, Jsp + Servlets, Portlets JSR-168, Web services, SOA, XML, XSLT, MVC.

Sep 2003 - Jan 2004

5 months

AlligatorSQL.de

Alligator Company Software GmbH

Based on the Struts APIs, the dynamic content and an administrative interface including a CRM system were developed.
On the server side, the Hibernate persistence framework was used.
Session beans were used as session facades for the business logic in the application server.
Tools used: Eclipse, Struts, Spring-IOC, Hibernate, JBoss, Postgres.
Standards used: OOA, OOD, J2EE, Jsp + Servlets, JDBC, SQL, JavaMail, Unix, SQL.

Apr 2003 - Oct 2003

7 months

AlligatorSQL

Alligator Company Software GmbH

Further development of the "kernel routines" and dialog engine for DB2 access in the AlligatorSQL standard software.
AlligatorSQL was extended with DB2 access via CLI and the other administrative APIs of DB2.
Tools used: Microsoft Visual C++, DB2 CLI, DB2 Admin. API.
Standards used: Model-View-Controller, MFC, OOD.

Jan 2003 - Jan 2004

1 year 1 month

Project management, OOA, OOD, development

Bank

Project: communication interface for high-value payment transactions (continuation).
Design and implementation of the SAP integration of payment transaction applications for connection to the existing communication interface.
To integrate applications newly developed in SAP into communication with "non-SAP" applications, IDoc-based conversions were developed.
Tools used: WebsphereMQ, WebsphereAppServer, Jdk1.3.1, RMI/IIOP, EJB, Aix, SAP/R3, Websphere Application Developer, Oracle 8.1.7, Log4J, Jakarta-Oro, MQClasses4J, Xerces, Xalan, Ant, Junit, R3/Link, Unix, Innovator.
Standards used: Model-View-Controller, J2EE, JDBC, DAO/DMO, Gof-Pattern, UML, Idoc, SQL, batch processing, ELT/ETL.

Jan 2002 - Dec 2002

1 year

Project management, OOA, OOD, development

Bank

Project: communication interface for high-value payment transactions.
The German Bundesbank wanted communication software that had already been ported from OS/390 to Java to be extended. This software transports payment data from high-value payment transactions between applications that supply the applications with payment data as part of the intranet.
The software is based on WebsphereMQ as the transport medium and offers interfaces for Java applications via RMI. Each transport is represented as an order, and an order management system is provided, with status displays that give the applications information about the progress of the order.
The task was to adapt and extend the existing application in order to prepare the software for future tasks. The main part was to integrate a separate database, since until then the old application on OS/390 and the Java application on AIX had used the same database and the Java version was therefore tied to the OS/390 location.
In addition, the architecture was extended and redesigned with regard to layer separation in preparation for connection to EJB interfaces. The transaction layer was mapped with the help of DAOs and DMOs and also made configurable, so that resources such as MQ and DB connections could also be made available within a J2EE context. The business logic was restructured and simplified with the help of the Command pattern and a Template Method.
In addition to the connection through EJBs, the extensions included the implementation of a new file-based interface via FTP and the integration of SAP applications with the help of R3/Link. Converters were written that are able to deliver IDoc packages and implement the connection to R3/Link.
In addition, the Ant tool was introduced to automate build and delivery, and the JUnit test framework was integrated for quality assurance.
Tools used: WebsphereMQ, WebsphereAppServer, Jdk1.3.1, RMI/IIOP, EJB, Aix, SAP/R3, Websphere Application Developer, Oracle 8.1.7, Log4J, Jakarta-Oro, MQClasses4J, Xerces, Xalan, Ant, Junit, Unix, Innovator.
Standards used: Model-View-Controller, J2EE, JDBC, DAO/DMO, Gof-Pattern, UML, IDoc, SQL.

Sep 2001 - Feb 2002

6 months

Project management, OOA, OOD, development

Large Kitchen Supplier

Project: Multimedia product CD-ROM.
To launch a new device, a multimedia CD-ROM for product presentation was to be created.
Special features are a sales price calculation based on the intended use and an energy/benefit calculation to determine the required size of the system.
Visual C++ was used as the development tool, along with an HTML-based GUI to ensure later use as a web application.
WxWindows was used as the GUI API, since it also ensures platform independence. The result reports were generated in HTML.
Tools used: Microsoft Visual C++, WxWindows.
Standards used: Model-View-Controller, C++, STL.

May 2001 - Oct 2001

6 months

Project management, OOA, OOD, development

Nutrition Industry Supplier

Project: E-commerce internet portal.
New development of the existing e-commerce portal with extended community features. The overall system is used to support overweight patients over the internet. Chats, forums, and interactive expert systems are used for communication and advice. Products are to be sold through a shop. A fee system should be able to collect due charges.
Java Enterprise Beans were chosen as the base architecture. Using Data-Access and Data-Model objects, the transaction layer was built with the help of an OR mapping framework. The business logic was stored in stateless session beans. Access through the controller layer takes place via the Apache Struts tag libraries with the help of Java Server Pages (JSPs).
To keep the JSPs free of Java code, custom tag libraries were developed. This made it possible to ensure that project members without Java knowledge could create JSPs.
The e-commerce components include a shop and a billing system that communicate over secure connections with banks and partner companies.
In the community features area, a chat system is worth mentioning, which was implemented using Java Message Services. Administration was enabled through the Java Management Extension.
The Model-View-Controller concept was successfully implemented through strict separation of the layers.
In addition to developing the architecture and object model in UML, I also took over the design of the data model. I was also responsible for configuring the Ant build tool and automating the JUnit test framework for quality assurance. Besides my role as reviewer, I developed a large part of the JMS-based chat.
Tools used: Tomcat, JBoss, Jdk1.3.1, Apache, Linux, Castor, Ant, Junit, PowerArchitekt, Postgres.
Standards used: Model-View-Controller, EJB 1.1, Servlet 2.2, JSP 1.1, JMS, JMX, JDBC.

Aug 2000 - Apr 2001

9 months

Subproject management, OOA, OOD, development, SQL

Telecommunications

Project: Mobile portal.
For a mobile telecommunications company, a mobile portal was to be developed that combines community, messaging, office, and content services. The main focus in the concept was above all on device independence of the delivered results, mass processing, and the extensibility and configurability of the overall framework.
In addition to connecting the WAP portal to the WebLogic Servlet Engine and the business logic in the EJBs, an administrative JMS-based framework was developed that implements monitoring, administration, and connectivity to content partners and the SMS gateway.
My area of responsibility was the latter part, which was connected to the "rest" of the business logic via EJBs. The framework itself consists of "plain" Java applications that communicate via RMI and JMS.
Monitoring and administrative tasks (start, stop, reload) are handled by a server that was made fail-safe by a watchdog process. I also evaluated the message brokers.
The other services/applications were SMS applications such as chat, content lookup, and games via SMS, as well as the interface to the customer's content partners to retrieve current data. A key challenge in the implementation was solving the mass processing problem, which was handled through caching and appropriate distribution routines.
To display the content independently of the device, an XML/XSLT transformation was used. To connect to the SMS gateway, the CIMD2 protocol from Nokia was implemented.
In the final part of the project, the application was moved to a high-availability platform across the different parts with a Linux cluster. Ant was also used as the build tool, and the JUnit framework was used for quality assurance and testing.
Standards used: UML, GoF pattern, Model-View-Controller, EJB 1.1, Servlet 2.2, JSP 1.1, JMS, JDBC.
Tools used: Weblogic 5.1, Visual Cafee, SonicMQ, JMS, Xerces, Xalan, RMI, Unix, Power-Designer.

Aug 2000 - Dec 2000

5 months

Project management, design and development

Internet Service Provider

Project: Application server in Perl.
For an internet agency, a server was to be developed that is able to "host" customer pages and provide them with an additional, standardized range of services.
These services for customers included email forms for customer contact, data mining functions, and a forum solution. The implementation was to develop a framework that ensures administration and extensibility on the side of the internet agency.
For the implementation, Perl and Apache with an embedded Perl module were used based on the available skills. The MySQL database was used.
The implementation was carried out by the internal employees after the architecture, data model, and class design had been developed.
The architecture was based on a CORBA-distributed solution, since the server was designed to be scalable. In addition to representing the database layer using the DAO/DMO pattern, a framework was developed for HTTP form-based services that represents the HTTP forms in Perl classes.
Tools used: MySQL, CORBA ORB, Perl, Unix, SQL, ERWin.

Apr 2000 - Jun 2000

3 months

Design and development

Catering Service Provider

Project: Catering calculation software.
The catering business required calculation software that allows menus and their costs to be calculated based on a recipe database.
MS Access with Visual Basic was used to display the forms.
A master data management system for ingredients and the composition of dishes and the resulting menus was implemented.
Based on the stored prices and the preparation requirements, a kitchen plan and price calculation were output.
Tools used: Visual Basic 6, MSAccess, SQL.

Feb 2000 - Nov 2000

10 months

Expert system C++

Dienstleistung

Development of an expert system for personalizing goods deliveries.
During the picking of meal packages, a personal letter from the chef was to comment on the menu selection. Only two seconds passed between scanning the package and the machine inserting the letter. In this time, the letter had to be fully created and printed. Windows 95 was specified as the target system.
Implementation: An algorithm was designed that makes a suitable selection of text blocks and puts them together into a letter. To save print time, the Windows print function was not used. Instead, the letter was created in PCL5 and copied to the printer as a raw file. This task was handled by a server program.
A client program was used to administer the data inventory.
Tools used: Microsoft Visual C++, Microsoft Visual FoxPro.
Standards used: PCL5, SQL, ER design.

Jan 2000 - Oct 2000

10 months

Design and development

Telecommunications service provider

Project: Unified Messaging Solution.
For mobile communication via laptops, a Visual Basic based application was written that offered email, fax and SMS services in an integrated form.
While the application and forms were implemented in Visual Basic, all protocols (SMTP, POP3, IMAP, FAX, SMS) and I/O access were implemented in Visual C++ as a DLL.
Tools used: VB6, C++, Visual Studio.
Standards used: C++, STL, DAO.

Jan 2000 - Mar 2000

3 months

Design and development

Aviation

Project: 3D visualization with VRML and Java3D.
Aircraft models designed in MSC-Patran were to be transformed into a browser-compatible representation for easier viewing and visualization.
VRML was chosen as the target format, with display possible in Java3D.
The raw data described the model in very small polygon sections, which caused a very large amount of data. Therefore, an optimization was used to minimize the amount of data in the target model.
In addition, an AWT application was created to configure the generation and view the visualization with Java3D. This software runs as an applet in the browser.
Tools used: HP-UX - Unix, JDK 1.1.
Standards used: VRML, Java3D.

Dec 1998 - Aug 2000

1 year 9 months

Design and development

Nutrition industry service provider

Project: Internet portal for the nutrition industry.
Development of an eCommerce portal with an online shop and chat system. The overall system serves to support overweight patients over the internet.
In the evaluation phase, Apple's WebObjects was also considered. However, this option was rejected because of the complexity of the software and budget issues.
Therefore, a Servlet/JSP based architecture with direct database access from the servlet layer was chosen. Database access was encapsulated in suitable DAO/DMO objects.
The MVC architecture was also implemented here, with the view and controller in the JSPs/servlets and the model represented in the transaction layer behind them.
MySQL was chosen as the database, and Tomcat was used as the servlet engine.
The chat server was also implemented with servlets and server-side daemons, and on the client side with an applet. For the moderators, a Java Swing application was created that provided more advanced functions such as blocking users and multimedia features with images and animations to illustrate topics.
My tasks initially included providing the architecture, class design using UML, and developing the database model.
Implementation was then split among the participants, where my main tasks were code review and developing the moderator Swing client.
In addition, I was responsible for configuration management of the web server components Apache / Tomcat and access to MySQL. Jakarta Ant was used as the build tool. JUnit was used for quality assurance.
Tools used: JBuilder, Together, Tomcat, Postgres, Linux - Unix, WinNT, Swing, JDK 1.2, J2EE, CVS, Apache, Ant, JUnit.
Standards used: MVC, J2EE, GoF patterns, UML, SQL, ER design.

Jan 1996 - Dec 1998

3 years

Design and development

Law office

Project: Law office software.
Law firm software based on office applications.
A document management system was created with links to the client, lawyer and court databases.
The goal was to create the corresponding links between the different data sources for each case file.
The paperless office was implemented using external scanning software.
Visual C++ was used to create the corresponding DLLs for accessing the data and external controls, and Visual Basic for Applications was used to create the applications within MS Word.
Tools used: MS Office, MS Visual Studio.
Standards used: C++, STL, Basic, ER design.

Jan 1994 - Dec 1999

6 years

Design, Development and Training

CAD - Service Provider

Project: Training. For the AutoCAD service provider, customers of the developed software were trained on AutoCAD and the planning software.
Project: Industry software for AutoCAD. A special solution for commercial kitchen planning offices and service providers was to be created, supporting the entire project flow from quote, planning, calculation, parts lists, and invoicing. MS Access and AutoCAD were given as requirements. Building on an existing supporting solution, a master data management for articles, project management, quote calculation based on the parts lists from CAD, and invoicing were implemented. AutoCAD Lisp and C++ were used to take the drawing to be created directly from the master data and use it. This meant the parts list, and thus the basis for quote calculation, was already available. The calculation supports list price and purchase price based calculations and also includes target price calculation, where the prices of individual items are adjusted to a specified target price.
Tools used: Microsoft Visual C++, Microsoft Access, Autodesk AutoCAD, Linux, SQL.
Standards used: C++, STL, Basic, SQL, ER design.

Industry experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Banking and Finance, Professional Services, Insurance, Retail, and Telecommunication.

Information Technology

Banking and Finance

Professional Services

Insurance

Retail

Telecommunication

Business area experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Product Development, Project Management, Quality Assurance, and Sales.

Information Technology

Business Intelligence

Product Development

Project Management

Quality Assurance

Sales

Summary

BI consultant, more than 25 years of experience in planning, selection and implementation of solutions in the area of business intelligence, data architecture and data management.

Languages

German

Native

English

Advanced

French

Elementary

Polish

Elementary

Statistics

Experience

Total positions 41

Experience in Information Technology 21 y

Avg length 1 y 4 m

Longest experience 8 y 2 m

Global experience

Countries worked in 2 (Germany, Netherlands)

Primary country Germany

Expertise

Recent roles Data Vault with Informatica on Oracle, Datavault Builder Data Warehouse with Qlik frontend, Alligator Company in-house consulting product

Main industries Information Technology, Banking and Finance, Professional Services

Main business areas Information Technology, Business Intelligence, Product Development

Profile

Member since

August 2025

Last update

August 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Torsten is based in Hanover, Germany.

Torsten speaks the following languages: German (Native), English (Advanced), French (Elementary), Polish (Elementary).

Torsten has at least 32 years of experience. During this time, Torsten has worked in at least 32 different roles and for 37 different companies. The average length of individual experience is 1 year and 9 months. Note that Torsten may not have shared all experience and actually has more experience.

Based on recent experience, Torsten would be well-suited for roles such as: Data Vault with Informatica on Oracle, Datavault Builder Data Warehouse with Qlik frontend, Alligator Company in-house consulting product.

Torsten's most recent position is Data Vault with Informatica on Oracle at SEFE.

In recent years, Torsten has worked for SEFE, NVL - Luerssen, ACS, and Gelita.

Torsten is most experienced in industries like Information Technology, Banking and Finance, and Professional Services. Torsten also has some experience in Insurance, Retail, and Telecommunication.

Torsten is most experienced in business areas like Information Technology, Business Intelligence, and Product Development. Torsten also has some experience in Project Management, Quality Assurance, and Sales.

Torsten has recently worked in industries like Information Technology, Professional Services, and Biotechnology.

Torsten has recently worked in business areas like Business Intelligence, Information Technology, and Product Development.

The availability of Torsten needs to be confirmed.

Daily rate distribution

0 2 4 6 8

<€640 €800-960 €1120-1280 €1440+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1000

750

500

250

Daily rate avg. 900 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1000

750

500

250

Median rate 856 €

The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.

Calculated based on our freelancers’ daily rates as of 7 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.