Torsten Glunde - BI consultant

Recommended expert

Hanover, Germany

Experience

Jan 2024 - Dec 2024

1 year

Datavault with Informatica on Oracle

SEFE

Datavault modeling and performance improvements in Oracle.
Requirements process with model-driven Datavault automation.
Preparation of business requirements for the pricing database in the gas and electricity market.
Sales performance based on Salesforce CRM.
Tasks: design 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

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

Jul 2022 - Present

3 years 7 months

Alligator Company in-house consulting product

ACS

Developed the ACS-Datastack consulting product based on open source data pipelines (CNCF, Argo, DBT, and Airbyte) and model-driven Datavault automation (AutomateDV, Datavault-Builder).
Developed the IaC and GitOps based automation solution.
Tasks: design 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

Datavault automation with Datavault-Builder, data management, and GitOps

Gelita

Review of an existing implementation of Datavault-Builder on Exasol.
Introduction of ELM workshops to gather requirements for consistent Datavault modeling.
Transformation rules in DBT with 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 practices.
Tasks: data architecture consulting and GitOps implementation.
Tools used: Datavault-Builder, Exasol, DBT, Docker, DataOps, Argo Workflow, Python Ingestion, k3s, Gitlab CI, PowerBI.

Sep 2020 - Mar 2021

7 months

Berlin, Germany

Datavault automation, Datavault-Builder, data management, and GitOps

GVL

Review and consulting on concepts for Datavault modeling, automation, and DataOps.
Initial implementation of the Snowflake data warehouse and migration of data to the cloud.
Comprehensive consulting on data management, methodologies, development guides, and tool deployment planning (Datavault-Builder, DBT, Airflow, and Git).
Organizational consulting for structuring the newly formed 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

Datavault automation with DBT on Snowflake using Airflow, DataOps

E.ON

Review and consultation on 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 consultation.
Tools used: Datavault Builder, Snowflake, DBT, Kubernetes, Docker, Azure DataOps, Python, Airflow.

Jun 2020 - Mar 2021

10 months

Stuttgart, Germany

DWH DataOps, architecture, and implementation of Datavault Builder and Exasol

Vector.com

Requirements analysis and implementation for an automotive supplier in embedded software development.
Implementation of DataOps methods in Microsoft Azure using Exasol and Datavault Builder.
Consulting and training on modeling, development methods, and cost analysis for the introduction of a new data warehouse infrastructure and development.
Tasks: design, consulting, and training for the introduction of 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

Conducting a proof of concept (POC) and advising 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, Visual Studio 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 using 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 using Xtext and Java.
Physical database optimization on Oracle.
Tools used: UDG Data Vault, Oracle, batch processing, ELT/ETL, TDD.

Jul 2017 - Mar 2018

9 months

Solution Architect

Uelzener Tier

Introduction of the solution architecture with Datavault Builder and guidelines for implementing the business model. The special feature was the bi-temporal source system, which was implemented in the Datavault with a versioned hub.
In the dimensional model, the source views for the Qlik frontend were created and performance optimizations on the SQL Server were performed.
Execution plans were analyzed and measures like indexing and Businessvault materializations were applied.
Existing Talend ETL processes were 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

Architecture ownership, modeling guidelines and consulting of 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.
Developing 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 the 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 Data Vault

DPV

Modeling of the E-DWH and data mart with PowerDesigner.
Implementation of the Informatica processes for data loading.
Maintenance and support of the 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, Power-Designer, Exasol, batch processing, ELT/ETL.

Sep 2012 - Dec 2012

4 months

BI Architecture, eDWH Design with Data Vault

Westfalia Automotive

Creation and testing of a functional 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 models.
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, PowerDesigner, batch processing, ELT/ETL, TDD.

Jul 2011 - Dec 2011

6 months

Pentaho PDI / Kettle EII, Mondrian

Finanz Informatik

EII implementation for preparing and caching Mondrian queries on a host DB2 legacy database.
Tools used: Pentaho, DB2 UDB, DB2 Host.
Standards used: SQL, datamart, database 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, PowerDesigner.
Standards used: SQL, datamart, database 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 CRM, KBP/Update.
Concept development, modeling, implementation and rollout in the business unit.
Tools used: Business Objects, DB2 UDB, DB2 Host, Informatica PowerCenter 8.6, Mercury Quality Center, LoadRunner, KBP by Update, IBM Data Architect Modeling.
Standards used: SQL, datamart, database design, performance tuning, star join optimization, batch processing, ELT/ETL.

Mar 2009 - Aug 2009

6 months

Development of an Enterprise Data Warehouse

Kabel Deutschland GmbH

Development and testing of a business and implementation concept for an eDWH based on a Data Vault core.
Analysis and development of an enterprise data warehouse.
Sub-project lead of the development stream (ETL development and modeling).
Creation of a technical data warehouse assessment.
Requirements analysis with the business unit, 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 specifications 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 in 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 and Servlets, Web services, SOA, XML, XSLT, MVC.

Jan 2006 - Jun 2009

3 years 6 months

BI Architect Business Objects

FinanzIT

IT design for using Business Objects in a multi-tenant environment in the client's infrastructure.
Multi-tenancy and standard reporting releases, auditing and billing of the data center services provided to the client.
Performance tuning and system design, preparations, execution and evaluation of load tests 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, PowerDesigner, WebLogic, Unix, DataStage ETL, FastTrack, Mercury Quality Center and LoadRunner.
Standards used: SQL, datamart, database design, performance tuning, batch processing, ELT/ETL.

Jul 2005 - Feb 2006

8 months

Seminar booking and billing

Telecommunications

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.
Designing and planning high-availability servers.
OLAP and reporting with Business Objects.
Analysis and optimization of data warehouse, ETL and OLTP processes.
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, PowerDesigner.
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.
Extending the AlligatorDBC product with ESB features using message queue systems and the OpenESB server.
Expanding functionality into a broker with EII, XML integration, web services and JBI features 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 most common BI tools. The OLAP component is 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 interfaces.
Data warehouse automation implementation using BIML and SSIS based on Data Vault 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 and 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

Web Service, SOA and JSR-168 Portal

European Patent Office

Based on Axis 1.1, a web service was developed in Java that performs backend database queries by accessing JINI services.
Using a document/literal service and XML transformations, a pipeline/valve-oriented processing design was implemented.
The user accesses the GUI via a portlet developed based on the JSR-168 interfaces, making both Tomcat and WPS viable 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, JSR-168 Portlets, Web services, SOA, XML, XSLT, MVC.

Sep 2003 - Jan 2004

5 months

AlligatorSQL.de

Alligator Company Software Ltd.

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

Apr 2003 - Oct 2003

7 months

AlligatorSQL

Alligator Company Software Ltd.

Further development of the 'kernel routines' and the dialog engine for DB2 access in the AlligatorSQL standard software.
AlligatorSQL was extended with DB2 access via the DB2 CLI and other administrative APIs.
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 lead, OOA, OOD, development

Bank

Project: large-value payments communication interface (continued).
Designed and implemented SAP integration of payment transaction applications to connect to the existing communication interface.
To integrate newly developed SAP applications into communication with non-SAP applications, IDoc-based conversions were developed.
Tools used: WebSphere MQ, WebSphere Application Server, JDK 1.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 patterns, UML, IDoc, SQL, batch processing, ELT/ETL.

Jan 2002 - Dec 2002

1 year

Project lead, OOA, OOD, development

Bank

Project: large-value payments communication interface.
For the Bundesbank, existing communication software ported from OS/390 to Java was extended. This software transports large-value payment data between the intranet applications that provide payment data.
The software is based on WebSphere MQ as transport and offers RMI interfaces for Java applications. Each transport is represented as a job and a job management system is provided, which presents statuses that give applications information on the progress of the job.
The task was to adapt and extend the existing application to prepare the software for future tasks. This essentially involved integrating a standalone data store, as the legacy OS/390 application and the Java application on AIX had used the same data store, binding the Java variant to the OS/390 site.
Furthermore, the architecture was extended and redesigned in terms of layer separation in preparation for connecting to EJB interfaces. The transaction layer was implemented using DAOs and DMOs and made configurable so that resources like MQ and DB connections could also be made available within a J2EE context. The business logic was restructured and simplified using the Command pattern and a Template Method.
In addition to the EJB connectivity, extensions included implementing a new file-based interface over FTP and integrating SAP applications using R3/Link. Converters were written to deliver IDoc packages and enable R3/Link connectivity.
Furthermore, Ant was introduced for build and deployment automation and the JUnit test framework was integrated for quality assurance.
Tools used: WebSphere MQ, WebSphere Application Server, JDK 1.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 patterns, UML, IDoc, SQL.

Sep 2001 - Feb 2002

6 months

Project Management, OOA, OOD, Development

Commercial Kitchen Service Provider

Project: Multimedia product CD-ROM.
For the launch of a new device, a multimedia CD-ROM was to be created for product presentation.
Special features include 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, and an HTML-based GUI was used to allow future use as a web application.
The GUI API was WxWindows to ensure 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 Service Provider

Project: E-commerce internet portal.
Redevelopment of the existing eCommerce portal with extended community features. The overall system is used to support overweight patients over the Internet. Chats, forums, and interactive expert systems serve for communication and consultation. Products are sold through a shop. A fee system collects any charges.
The underlying architecture used Java Enterprise Beans. Using Data Access and Data Model objects, the transaction layer was created with the help of an ORM framework. The business logic was placed in stateless session beans. Access through the controller layer is done via Apache Struts tag libraries using JavaServer Pages (JSPs).
To keep the JSPs free of Java code, custom tag libraries were developed. This ensured that project staff without Java knowledge could create JSPs.
The eCommerce components include a shop and a fee billing system, which communicate with banks and partners over secure connections.
In the area of community functions, a chat system is noteworthy, which was implemented using Java Messaging Service. Administration was enabled via Java Management Extensions.
The Model-View-Controller concept was successfully implemented through a consistent separation of layers.
Besides developing the architecture and the object model in UML, I also took over the data model design. I was also responsible for configuring the build tool Ant and automating the JUnit test framework for quality assurance. In addition to my role as a reviewer, I developed most of the JMS-based chat.
Tools used: Tomcat, JBoss, JDK 1.3.1, Apache, Linux, Castor, Ant, JUnit, PowerArchitect, 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 unites community, messaging, office, and content services. The main focus during design was 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 EJBs, an administrative JMS-based framework was developed to provide monitoring, administration, and connectivity to content partners and the SMS gateway.
My tasks were in 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.
A server handles monitoring and administrative tasks (start, stop, reload), made fail-safe with a watchdog process. I also evaluated the message brokers.
The other services/applications included SMS applications like chat, content queries, and games via SMS, as well as the interface to the customer's content partners to fetch current data. An interesting challenge was solving the mass processing problem, which was addressed with caching and appropriate distribution routines.
For device-independent content presentation, an XML-XSLT transformation was used. To connect to the SMS gateway, the Nokia CIMD2 protocol was implemented.
In the final part of the project, the application was deployed across its components on a high-availability platform using a Linux cluster. Ant was used as the build tool, and the JUnit framework was used for quality assurance and testing.
Standards used: UML, GoF patterns, Model-View-Controller, EJB 1.1, Servlet 2.2, JSP 1.1, JMS, JDBC.
Tools used: WebLogic 5.1, Visual Cafe, SonicMQ, JMS, Xerces, Xalan, RMI, Unix, PowerDesigner.

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 could host client websites and provide an additional standardized set of services.
These services included email forms for client contact, data mining functions, and a forum solution. The implementation needed to develop a framework to ensure administration and expandability for the internet agency.
For implementation, we used Perl and Apache with the Embedded Perl module based on available skills. MySQL was used as the database.
The internal staff carried out the implementation after the architecture, data model, and class design were developed.
The architecture was based on a distributed CORBA solution since the server was designed to be scalable. Besides presenting the database layer using the DAO/DMO pattern, a framework was developed for HTTP form-based services to map HTTP forms to 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.
For the catering industry, calculation software was required to allow menu and cost calculations based on a recipe database.
MS Access with Visual Basic was used to create the forms.
A master data management system for ingredients and the composition of dishes and resulting menus was implemented.
Based on stored prices and preparation instructions, kitchen planning and price calculations were generated.
Tools used: Visual Basic 6, MS Access, SQL.

Feb 2000 - Nov 2000

10 months

C++ Expert System

Service company

Development of an expert system for personalizing goods deliveries.
During the picking of meal packages, a personal letter from the cook commented on the menu composition. There were only two seconds between scanning the package and machine insertion of the letter. In that time, the letter had to be completely created and printed. Windows 95 was the target system.
Implementation: An algorithm was designed that selects a suitable set of text blocks and assembles them into a letter. To save printing time, the Windows print function was not used. Instead, the letter was created in PCL5 and copied as a raw file to the printer. This task was handled by a server program.
A client program was used to administer the data repository.
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.
A Visual Basic based application was written for mobile communication on laptops 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 accesses 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 planned in MSC-Patran were transformed into a browser-compatible representation for simplified viewing and visualization.
VRML was chosen as the target format with a possible display in Java3D.
The raw data describes the model in very small patches of polygons, which caused a very large data volume. Therefore, an optimization was used to minimize the data size in the target model.
An AWT application was also created to configure the generation and view the visualization using 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: Nutrition industry internet portal.
Development of an eCommerce portal with online shop and chat system. The overall system is used to support overweight patients over the internet.
In the evaluation phase, Apple’s WebObjects was also considered. However, this option was dropped due to software complexity and budget issues.
Therefore, a Servlet/JSP-based architecture with direct database access from the servlet layer was chosen. Database accesses were encapsulated in corresponding DAO/DMO objects.
Here too, the MVC architecture was implemented, with the view and controller in the JSPs/servlets and the model in the underlying transaction layer.
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 a client-side applet. For moderators, a Java Swing application was developed to provide additional features like user blocking and multimedia functions with images and animations to illustrate content.
My tasks initially included setting up the architecture, class design using UML, and developing the database model.
The implementation was then divided among the team, with my main responsibilities in code reviews and development of the moderator Swing client.
I was also 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, PostgreSQL, 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 firm

Project: Legal software.
Law firm software based on Office applications.
A document management system with links to the client, lawyer, and court databases was created.
The goal was to create the appropriate links between the different data sources for each case file.
The paperless office was implemented via external scanning software.
Visual C++ was used to create DLLs for data access 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 sessions. Customers of the developed software were trained in AutoCAD and the planning software for the AutoCAD service provider.
Project: Industry software for AutoCAD. A commercial kitchen-specific solution for design offices and large kitchen service providers was created to support the entire project process from quoting, planning, calculation, parts lists to invoicing. MS Access and AutoCAD were specified. Building on an existing support solution, article master data management, project management, quote calculation based on the parts lists from CAD, and invoicing were implemented. AutoCAD Lisp and C++ were used to import and insert the drawing to be created directly from the master data. This provided the parts list and thus the basis for the quote calculation. The calculation supports both list price and purchase price-based calculations and includes a target price calculation that adjusts individual item prices to a predetermined target price.
Tools used: Microsoft Visual C++, Microsoft Access, Autodesk AutoCAD, Linux, SQL.
Standards used: C++, STL, Basic, SQL, ER design.

Summary

Bi consultant, more than 25 years 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

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Markus Groh