Torsten G. - Datavault Architecture with Datavault Builder and DBT on Exasol

Go to Website

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 price database in the gas and electricity market.
Sales performance using 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 with 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 3 months

Alligator Company proprietary consulting product

ACS

Development of a consulting product ACS-Datastack based on open source data pipelines (CNCF, Argo, DBT and Airbyte) and model-driven Datavault automation (AutomateDV, Datavault Builder).
Development of 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 for gathering requirements for consistent modeling in the Datavault.
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 practices.
Tasks: advising on data architecture and introducing 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

Datavault automation with Datavault Builder, data management and GitOps

GVL

Review and consulting on the concepts for Datavault modeling, automation and DataOps.
Initial introduction of the Snowflake Data Warehouse and migration of data to the cloud.
Comprehensive consulting on data management, practices, development guides and planning the use of tools (Datavault-Builder, DBT, Airflow and Git).
Organizational consulting for aligning the newly founded department to a data warehouse.
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 with Airflow, DataOps

E.ON

Review and consulting on concepts for Datavault modeling, automation, and DataOps.
Proposals 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 Datavault Builder and Exasol

Vector.com

Requirement analysis and implementation of requirements for an automotive supplier in embedded software development.
Introduction of DataOps methods on Microsoft Azure using Exasol and Datavault Builder.
Consulting and training on modeling, development methods, and cost analysis for launching a new data warehouse infrastructure and development.
Tasks: design, consulting, and training for implementing 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 POCs 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, 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 processes 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 with 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

Introduced the solution architecture with Datavault Builder and guidelines for implementing the business model. A special feature was the bi-temporal source system, which was implemented in the Data Vault with a versioned hub.
In the dimensional model, created the base views for the Qlik frontend and performed performance optimizations on the SQL Server.
Analyzed execution plans and applied measures such as indexing and Business Vault materializations.
Also replaced existing Talend ETL and adapted it to the new base 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

Responsible for architecture, modeling guidelines, and advising modelers in the implementation project.
UDG Data Vault Generator XText and Java.
IGC glossary and mapping transports.
Logical modeling in IDA and implementation in Data Vault.
Developed test scenarios for batch jobs using 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

Modeled enterprise DWH and data mart using 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

Modeled E-DWH and data mart with Power-Designer.
Implemented Informatica processes for loading.
Maintained and supported SSIS, SSAS, and SSRS implementations based on MSSQL.
Data Vault modeling and automation.
Exasol proof of concept 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 Architect, eDWH Design with Data Vault

Westfalia Automotive

Developed and tested 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, 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 proof of concept to choose tools 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 the CRM area, 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

Enterprise Data Warehouse Development

Kabel Deutschland GmbH

Creation 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.
Subproject 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, documentation for technical specifications and requirements management.
Tools used: Business Objects, Informatica PowerCenter, Oracle, DB2 Host, WebSphere Information Integration, MQSeries, Unix, ERWin.
Standards applied: Change Data Capture, SQL, batch processing, ELT/ETL.

Mar 2006 - Oct 2006

8 months

Transport Management System with Eclipse, WebLogic

DP-ITSolutions

Data management and JAAS security implementation in WebLogic.
Lead of 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 applied: OOA, OOD, J2EE, JSP + Servlets, web services, SOA, XML, XSLT, MVC.

Jan 2006 - Jun 2009

3 years 6 months

BI Architect Business Objects

FinanzIT

Data warehouse design of the use of Business Objects in a multi-tenant environment within 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, preparation, execution and evaluation of load tests to verify the infrastructure.
Support and coaching for developing data mart 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 applied: SQL, data mart, database design, performance tuning, batch processing, ELT/ETL.

Jul 2005 - Feb 2006

8 months

Seminar Booking and Billing

Telecommunications

Technical project lead for 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 servers for high availability.
OLAP and reporting with 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 applied: OOA, OOD, J2EE, SOA, UML, SQL.

Aug 2004 - Oct 2012

8 years 3 months

Project Lead and Architecture

Alligator Company Software GmbH

Project: ESB Messaging Server.
Extension of the AlligatorDBC product with ESB functionality using message queue systems and the OpenESB server.
Expansion of functionality to 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 most popular 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 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, MS SQL, SAP, Analytic Services, Cognos, SAS, BRIO, Business Objects, Crystal Reports, Hyperion, Unix, message queue server, OpenESB.
Standards applied: 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

Web service, SOA and JSR-168 Portal

European Patent Office

Based on Axis 1.1, a Java web service was developed that executes queries on backend databases via JINI Services.
A document/literal service was implemented with a pipeline/valve-oriented processing design using XML transformations.
As a GUI, the user accesses a portlet built on JSR-168 interfaces, allowing both Tomcat and WPS 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: 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, dynamic content and an admin interface including a CRM system were developed.
The persistence framework Hibernate was used on the server side.
Session beans were used as session facades for business logic in the application server.
Tools used: Eclipse, Struts, Spring-IOC, Hibernate, JBoss, Postgres.
Standards: 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.
The AlligatorSQL was extended for DB2 access via the DB2 CLI and other administrative DB2 APIs.
Tools used: Microsoft Visual C++, DB2 CLI, DB2 Admin API.
Standards: Model-View-Controller, MFC, OOD.

Jan 2003 - Jan 2004

1 year 1 month

Project lead, OOA, OOD, development

Bank

Project: Large payment transactions communication interface (continuation).
Designed and implemented the SAP integration of payment transaction applications to connect to the existing communication interface.
To integrate new SAP-based applications 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: Model-View-Controller, J2EE, JDBC, DAO/DMO, Gof-Pattern, UML, Idoc, SQL, batch processing, ELT/ETL.

Jan 2002 - Dec 2002

1 year

Project lead, OOA, OOD, development

Bank

Project: Large payment transactions communication interface.
For the Bundesbank, an OS/390-to-Java ported communication software was to be extended. This software transports large payment transaction data between applications that supply payment data within the intranet.
The software is based on WebsphereMQ as the transport mechanism and offers RMI interfaces for Java applications. Each transport is modeled as a job, and order management is provided with status indicators that inform applications about the job's progress.
The task was to adapt and extend the existing application to prepare the software for future tasks. Essentially, this involved integrating a standalone data store, since until then the legacy application on OS/390 and the Java application on AIX had used the same data store, which tied the Java variant to the OS/390 location.
The architecture was also extended and redesigned to separate layers in preparation for EJB interface integration. The transaction layer was implemented using DAOs and DMOs and made configurable so that resources like MQ and DB connections are available within a J2EE context. Business logic was restructured and simplified using the Command pattern and the Template Method.
The enhancements, in addition to integrating EJBs, included implementing a new file-based interface over FTP and integrating SAP applications using R3/Link. Converters were developed to deliver Idoc packages and enable R3/Link connectivity.
Additionally, the Ant tool was introduced for build and delivery automation, 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: Model-View-Controller, J2EE, JDBC, DAO/DMO, Gof-Pattern, UML, Idoc, SQL.

Sep 2001 - Feb 2002

6 months

Project lead, OOA, OOD, Development

Catering Service Provider

Project: Multimedia product CD-ROM.
To launch a new device, a multimedia CD-ROM was created for product presentation.
Special features include a sales price calculation based on the intended use and an energy-benefit calculation to compute the required system size.
Visual C++ was used as the development tool and an HTML-based GUI was implemented to ensure future use as a web application.
WxWindows was used as the GUI API 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 lead, OOA, OOD, Development

Nutrition Industry Service Provider

Project: E-commerce internet portal.
Redevelopment of the existing e-commerce portal with extended community functions. The overall system is used to support overweight patients over the Internet. Communication and consulting are provided through chats, forums and interactive expert systems. Products are sold via a shop. A fee system can collect the required contributions.
Java Enterprise Beans were chosen as the underlying architecture. Using data-access and data-model objects, the transaction layer was built with the help of an ORM framework. The business logic was implemented in stateless session beans. Access through the controller layer is done via Apache Struts tag libraries with Java Server Pages (JSPs).
Custom tag libraries were developed to keep the JSPs free of Java code. This ensured that project staff without Java knowledge could create JSPs.
The e-commerce components include a shop and a billing system that communicate with banks and partner companies over secure connections.
In the area of community functions, a chat system is worth mentioning, which was implemented using Java Message Service. Administration was enabled via Java Management Extensions.
The Model-View-Controller concept was successfully implemented through a clear separation of layers.
In addition to developing the architecture and the object model in UML, I also took over the design of the data model. Furthermore, I was responsible for configuring the Ant build tool and automating the JUnit test framework for quality assurance. In addition to my role as a reviewer, I developed much 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 lead, OOA, OOD, Development, SQL

Telecommunications

Project: Mobile portal.
For a mobile telecommunications company, a mobile portal was to be developed that unifies community, messaging, office, and content services. The key focus in the design was on device independence of delivered results, high-volume processing, and 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 to provide monitoring, administration, and connectivity to content partners and the SMS gateway.
My area of responsibility was the latter part, which was connected to the remaining 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 made fail-safe with a watchdog process. I also carried out the evaluation of message brokers.
The other services/applications were then SMS applications such as chat, content queries, and games via SMS, as well as the interface to the customer's content partners to retrieve current data. The interesting part of the implementation was solving the high-volume processing problem, which was handled through caching and appropriate distribution routines.
For device-independent content presentation, an XML-to-XSLT transformation was used. To connect to the SMS gateway, the Nokia-based cimd2 was implemented.
In the final phase of the project, the application was deployed as a whole on a high-availability platform using a Linux cluster. Ant was used as the build tool and the JUnit framework 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 Café, SonicMQ, JMS, Xerces, Xalan, RMI, Unix, PowerDesigner.

Aug 2000 - Dec 2000

5 months

Project lead, design and development

Internet Service Provider

Project: Application server in Perl.
For an internet agency, a server was to be developed that can host customer sites and provide additional standardized services.
These services for customers included email forms for customer contact, data mining functions, and a forum solution. The implementation was supposed to develop a framework that ensures administration and extensibility for the internet agency.
For implementation, Perl and Apache with the Embedded Perl module were used based on existing skills. MySQL was used as the database.
The implementation was carried out by the internal employees after the architecture, data model, and class design were developed.
The architecture was based on a CORBA distributed solution, as the server was designed to be scalable. In addition to presenting the database layer using the DAO/DMO pattern, a framework was developed for the HTTP-form-based services that maps HTTP forms to Perl classes.
Tools used: MySQL, CorbaOrb, Perl, Unix, SQL, ERWin.

Apr 2000 - Jun 2000

3 months

Design and development

Gastronomy Service Provider

Project: Catering cost calculation software.
For the gastronomy industry, cost calculation software was required that allows menus and their costs to be calculated based on a recipe database.
MSAccess with Visual Basic was used to display the forms.
A master data management for ingredients and the composition of dishes and the resulting menus was implemented.
Using the stored prices and the preparation specifications, a plan for the kitchen and a cost calculation were generated.
Tools used: Visual Basic 6, MSAccess, SQL.

Feb 2000 - Nov 2000

10 months

C++ Expert System Developer

Service Provider

Developed an expert system for personalizing goods deliveries.
During the picking of meal packages, a personal note from the cook should comment on the menu selection. Only two seconds passed between scanning the package and machine feeding the note. In that time, the letter had to be fully created and printed. Windows 95 was specified as the target system.
Implementation: Designed an algorithm that selects appropriate text blocks and assembles them into a letter. To save printing time, the Windows printing function was not used. Instead, the letter was created in PCL5 and copied as a raw file to the printer. A server program handled this task.
A client program was used to manage 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.
For mobile communication on laptops, a Visual Basic-based application was created offering 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 operations were implemented in a Visual C++ 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 needed to be transformed into a browser-capable format for simplified viewing and visualization.
VRML was chosen as the target format, enabling display with Java3D.
The raw data described the model in very small polygon segments, causing a huge data volume. Therefore, optimization was applied 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: Internet portal for the nutrition industry.
Developed an e-commerce portal with an online shop and chat system. The overall system is used to support overweight patients over the Internet.
During the evaluation phase, Apple's WebObjects was also considered. However, this option was rejected due to software complexity and budget issues.
Therefore, a servlet/JSP-based architecture was chosen with direct database access from the servlet layer. Database accesses were encapsulated in the corresponding DAO/DMO objects.
MVC architecture was implemented here as well, 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, offering advanced features like user blocking, multimedia functions with images and animations to illustrate concepts.
My tasks initially included providing the architecture, class design using UML, and developing the database model.
The implementation was then divided among team members, with my main tasks being code review and developing the moderator's Swing client.
I was also responsible for configuration management of the web server components Apache/Tomcat and the MySQL access. Jakarta Ant was used as the build tool. The test framework JUnit was used for quality assurance.
Tools used: JBuilder, Together, Tomcat, PostgreSQL, Linux (Unix), Windows NT, 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 practice software.
Law firm – software based on Office applications.
A document management system was created with links to client, attorney, and court databases.
The goal was to establish the appropriate 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 necessary DLLs for data access and external controls, and Visual Basic for Applications was used to develop 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. The clients of the developed software were trained on AutoCAD and the planning software for the CAD service provider.
Project: Industry-specific software for AutoCAD. A large commercial kitchen-specific solution for planning firms and commercial kitchen service providers was developed to support the entire project flow from quotation, planning, costing, bills of materials to invoicing. MS Access and AutoCAD were the set requirements. Building on an existing support solution, product master data management, project management, quotation costing based on the CAD bills of materials and invoicing were implemented. AutoCAD Lisp and C++ were used to pull the drawing directly from the master data. This made the bill of materials, and thus the basis for quotation costing, available immediately. The costing supports list price and purchase price calculations and also includes target price calculation, where the prices of individual items are adjusted to a given 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.