Jörn Dinkla's projects

This page is also available as

This page contains an overview of all my projects. The projects are divided into two sections:

My projects
In these projects i wanted to learn about new technologies.
Projects for clients
I worked in these projects as a freelancer/employee for paying customers or for the company i was employed to.

The combined list is also available as MS Word (TM) document and as a text file (UTF-8).

My projects

Project Migration of my blog from Wordpress to Jekyll
Term 11/2016 - 11/2016
Role Designer, developer, tester
Description
  • Export of all post from Wordpress, import into Jekyll
Software Jekyll, Ruby, SQL, Node.js, JavaScript, HTML5, CSS3, Bootstrap, GitHub pages, Disqus
Link http://blog.dinkla.net
Project Web app for visualization of the history of family names
Term 09/2016 - 11/2016
Role Designer, developer, tester
Description
  • Web app created for the culture hackathon "Coding da Vinci Nord"
  • Visualization of historical data for research of family names (genealogy)
Software Java 8, JavaScript, Node.js, Express, Mocha, MariaDB, Neo4J, Angular, D3.js, Underscore.js, Chai, HTML5, CSS3, Bootstrap, Docker, Amazon Web Services (AWS)
Link http://www.dinkla.com/en/programming/javascript-familiennamen.html
Project Import and analysis of emails with Elasticsearch in a Spring Boot application
Term 05/2016 - 05/2016
Role Designer, developer, tester
Description
  • Spring Boot application with Spring MVC web Frontend
  • Import of Emails into Elastiksearch with Spring Data Elasticsearch
  • Analysis of emails with Java API, optional with Kibana
Software Spring Boot, Spring MVC, Spring Data Elasticsearch, Elasticsearch, JavaMail API, Jackson JSON, Bootstrap, Plotly, Gradle, Spock, Docker, Groovy, HTML5, CSS3, Kibana
Link http://www.dinkla.com/en/programming/spring-boot-elasticsearch.html
Project Web page and email campaign
Term 03/2016 - 04/2016
Role Designer, developer, tester
Description
  • Update of web page, generation of content with Groovy Server Pages (GSP)
  • Software for email campaign from Excel address data
Software Groovy, JVM, GSP, HTML5, CSS3, JavaScript, Ant, Apache POI, XML, XML Schema, Bootstrap
Link http://www.dinkla.com/
Project Book "Die komplexe Perspektive - Einführung in die digitale Wirtschaft"
Term 08/2015 - 02/2016
Role Author
Description
  • Wrote and published a book
  • Big Data, Data Science, Artificial Intelligence
  • Economy as a complex system, Agent Based Modelling (ABM)
Software Dart, NetLogo, Neo4J, Voldemort, CouchDB
Link http://komplexe-perspektive.dinkla.net
Project Detection of neighbors with k-d trees, Apache Spark and Scala
Term 06/2015 - 06/2015
Role Designer, developer, tester
Description
  • Installation and configuration of a small virtual cluster with 3 nodes with Ubuntu Server 15.04
  • Configuration of Hadoop HDFS and Spark in cluster mode.
  • Implementation of k-d tree, transformations with Spark RDDs
  • Evaluation wit R
Software Apache Hadoop, Apache Spark, Scala, SBT, ScalaTest, Kryo, VirtualBox, Ubuntu Server 15.04, Ganglia, R, rhdfs, ggplot2, ggmap
Link http://www.dinkla.com/en/datascience/lbnn.html
Project Evaluation of multi GPU computing
Term 03/2015 - 04/2015
Role designer, developer, tester
Description
  • Evaluation, example code and teaching material
Software C++ 11, NVIDIA CUDA, OpenCL, C++ AMP, XCode, Eclipse NSight, Intel INDE
Link http://www.dinkla.com/en/programming/gpu-heat-diffusion.html
Project Parallel ray tracer with DSL for describing scenes
Term 01/2010 - 06/2015
Role designer, developer, tester
Description
  • Continuation of the optimization of a ray tracer with parallel processing
  • Porting the C++ code to Java
  • Made the code more object oriented
  • Made the code thread-safe for parallel execution
  • Created a Groovy DSL for easy scene creation and manipulation
Software Java, Groovy, Ant, Gradle
Link http://www.dinkla.com/en/programming/groovy-rendering.html
Project Performance optimization with parallel processing
Term 02/2009 - 12/2011
Role designer, developer, tester
Description
  • Optimization of a ray tracer with parallel processing (SIMD, MIMD)
  • Architecture 1: Cell Broadband Engine (Playstation 3)
  • Architecture 2: NVIDIA CUDA (graphics board, GPU computing)
  • Architecture 3: ForkJoinPool of Java 7
  • Architecture 4: OpenMP
  • Design and implementation of parallel algorithms and data structures
  • Performance optimization
Software C++, NVIDIA CUDA, GCC, OpenGL, Java, OpenMP
Link http://www.dinkla.com/de/programming/parallel-raytracer.html
Project Game similiar to Scrabble, contribution to Dynamic Languages Shootout 2008
Term 12/2007 - 12/2007
Role architect, designer, software developer, tester
Description
  • Contribution to the programming competition "Dynamic Languages Shootout"
  • for the OOP 2008 sponsored by the magazine JavaSpektrum
  • Result: 6th
  • Searching with Artificial Intelligence
  • Design and implementation of complex algorithms
  • Performance optimization of Java and Groovy programs
Software Groovy, Grails, Java, OOA, OOD, JUnit, Spring MVC, Hibernate
Link http://www.dinkla.com/en/programming/groovy-shootout.html
Project Groovy UML2 builder
Term 11/2007 - 11/2007
Role Designer, software developer, tester
Description
  • Simplification of the usage of UML2 with Groovy
Software Eclipse, Groovy, Java, Eclipse Modeling Framework (EMF), domain specific languages (DSL), UML, UML2, MDT-UML2
Link http://www.dinkla.com/en/programming/groovy-uml2.html
Project Groovy application for showing disc usage
Term 06/2007 - 06/2007
Role Designer, software developer, tester
Description
  • Written during learning Groovy
Software Groovy, Java, Swing, AWT, JFreeChart
Link http://www.dinkla.com/en/programming/groovy-diskusage.html
Project Groovy EMF Builder
Term 04/2007 - 06/2007
Role Designer, software developer, tester
Description
  • Simplification of the usage of EMF with Groovy
Software Eclipse, Groovy, Java, Eclipse Modeling Framework (EMF), domain specific languages (DSL)
Link http://www.dinkla.com/en/programming/groovy-emf.html
Project Eclipse-Editor of Common Warehouse Metadata Model (CWM)
Term 01/2007 - 01/2007
Role Designer, software developer, tester
Description
  • Eclipse plugin for experimenting with CWM
Software Eclipse, Eclipse Modelling Framework (EMF), XSLT, Common Warehouse Metamodel (CWM), Meta Object Facility (MOF), UML, EMOF, Ecore, OMG Standards, Java, Eclipse plugin development (PDE), Metadata
Link http://www.dinkla.com/en/programming/eclipse-cwm.html
Project Editor and viewer for family trees
Term 04/2005 - 04/2005
Role Designer, software developer, tester
Description
  • Private project, prototype
  • Written during learning Eclipse, EMF and GEF
Software Eclipse, Eclipse Modeling Framework (EMF), Graphical Editor Framework (GEF), Java, Eclipse-Plugin-Entwicklung (PDE)
Link http://www.dinkla.com/en/programming/eclipse-gef.html
Project SQL Editor Prototype for Eclipse
Term 02/2005 - 04/2005
Role Designer, software developer, tester
Description
  • Written during learning Eclipse
Software Eclipse, SWT, Java, Eclipse plugin development (PDE)
Link http://www.dinkla.com/en/programming/eclipse-editor.html
Project Metadata driven ETL development with Eclipse
Term 12/2004 - 04/2005
Role Designer, software developer, tester
Description
  • Generating DLL scripts and import/export-scripts from metadata
Software Written during learning Eclipse and EMF
Link http://www.dinkla.com/en/programming/eclipse-emf.html

Projects for clients

Project Two articles about GPU computing in the german magazine iX Developer
Term 01/2013 - 01/2013
Company Magazine
Sector Software
Role Author
Description
  • Article "Grundlagen der GPU-Programmierung" (foundations of GPU computing)
  • Article "GPU-Programmierung in der Praxis mit CUDA" (GPU programming with CUDA in action)
Software NVIDIA CUDA
Link https://shop.heise.de/katalog/ix-programmieren-heute-2013
Project Design and Implementation of parallel algorithms with NVIDIA CUDA
Term 04/2012 - 12/2014
Company Manufacturer of laser imaging systems
Sector Software
Role Developer, consultant, tester, coach
Description
  • Tomographic Particle Image Velocimetry (PIV)
  • Design, implementation and optimization of image- and volume-processing algorithms
  • Processing huge data sets on GPUs
  • Processing compressed 3d volumes
  • Image processing, Point based algorithms
  • parallel algorithms for 2D- and 3D correlations
  • Training and consulting
Software NVIDIA CUDA, C++, OpenMP, MS Visual Studio, Boost, Qt
Project Software for point-of-sale terminals
Term 01/2012 - 04/2012
Company Logistics
Sector Retail, E-commerce
Role Developer, consultant, tester, coach
Description
  • Software for point-of-sale terminals with bar code scanners
  • REST, Representational State Transfer
Software Grails, Groovy, Spring MVC, Hibernate
Project Technical proofer of the book "OpenCL in Action"
Term 08/2011 - 09/2011
Company Manning Publications Co.
Sector Software
Role Technical proofer
Description
  • Review of the book
  • Check of correctness of program code
  • Check of consistency with the OpenCL specification
Software OpenCL, C, C++, Java, Python
Link https://www.manning.com/books/opencl-in-action
Project Design and Implementation of parallel algorithms with NVIDIA CUDA
Term 01/2010 - 09/2011
Company Manufacturer of laser imaging systems
Sector Software
Role Developer, consultant, tester, coach
Description
  • Particle Image Velocimetry (PIV), Tomographic PIV
  • Design, implementation and optimization of image- and volume-processing algorithms
  • Processing huge data sets on GPUs
  • Processing compressed 3d volumes
  • Image processing, Point based algorithms
  • parallel algorithms for 2D- and 3D correlations
  • Training and consulting
Software NVIDIA CUDA, C++, OpenMP, MS Visual Studio, Boost
Project Extension of a data warehouse of a bank
Term 07/2009 - 12/2009
Company Software and Consulting Company
Sector Banking
Role designer, consultant, software developer, tester, coach
Description
  • Design, development and test of ETL processes
  • Optimization of SQL queries
Software Oracle, PL/SQL, Java, Eclipse, Groovy, Velocity, XML, XSLT, XPath, Juxy, Xom
Project Optimization and extension of a data warehouse of a telecommunications company
Term 01/2009 - 07/2009
Company Telecommunications company
Sector Telecommunications
Role Analyst, designer, developer, consultant, coach
Description
  • Reorganization and optimization of the data warehouse, esp. of the ETL architecture and ETL processes
  • Analysis, design and implementation of ETL processes, e. g. Order lifecycle history
  • Coaching of employees, e. g. Ab Initio
Software SAND, Ab Initio, Perl
Project Reorganization and optimization of a Data Warehouse of an Insurance
Term 09/2008 - 12/2008
Company Insurance
Sector Insurance
Role Analyst, architect, designer, consultant, coach
Description
  • Reorganization and optimization of the ETL architecture and of ETL processes
  • Coaching of employees: Oracle, DWH, optimization, test driven software development, TDD
Software Oracle database, PL/SQL, Pentaho Data Integration/Kettle, Oracle Warehouse Builder
Project Analytic Application for forecasting/prediction of sales
Term 05/2008 - 08/2008
Company International mail order and E-commerce company
Sector Mail order, E-commerce
Role Analyst, architect, designer, developer, coach, tester
Description
  • Analytical rich client application
  • Project leader
  • Teaching and coaching
Software Java, Eclipse, SWT, JFace, Eclipse Data Binding, Ant, iBATIS, JFreeChart, JUnit, DbUnit, Apache POI, Hudson, Oracle
Project Java EE/JEE/J2EE Enterprise Application
Term 01/2008 - 04/2008
Company Software and Consulting Company
Sector Wholesale, E-commerce
Role architect, designer, developer, consultant, tester
Description
  • Re-Engineering, development and maintenance of an ERP application
Software JEE, J2EE, Java EE, EJB, Java, JBoss, Struts, IBatis, MySQL, JSP, JSTL
Project Data Warehouse Project for a bank
Term 08/2007 - 11/2007
Company Software and Consulting Company
Sector Banking
Role designer, consultant, software developer
Description
  • Design, development and test of ETL processes
  • Generation of test data
  • Development of reports
Software Oracle, PL/SQL, Java, Eclipse, Groovy, Cognos 8
Project Data Warehouse Project for Customers and Revenue
Term 02/2007 - 06/2007
Company International Telecommunications Company, Bucharest, Romania
Sector Telecommunications
Role System architect, lead ETL designer, consultant
Description
  • Standards for software development methodology, testing framework
  • Source system analysis of CDR records from Amdocs
  • Advice for hardware- and software configuration
  • Design of an ETL framework and ETL processes
Software Oracle, Ab Initio, Informatica, Business Objects, Perl, Ruby, XML, Groovy, ERwin
Project Offer of a contract for work and services for a data warehouse project
Term 01/2007 - 02/2007
Company International Telecommunications Company, Bucharest, Romania
Sector Telecommunications
Role Author
Description
  • Consolidation and refinement of a draft to the final version of the contract
  • Creation of a project plan
  • Creation of the technical parts of the offer
Software Oracle, Ab Initio, Informatica, Business Objects, MS Project, PowerDesigner
Project Data Warehouse Project, Creation of an extraction and DQA framework
Term 11/2006 - 12/2006
Company International Telecommunications company, Istanbul, Turkey
Sector Telecommunications
Role analyst, ETL designer, consultant
Description
  • Extraction and quality assurance framework
    • Extraction of data from productive systems with data quality assurance rules
    • Generic framework, generation of meta data from MS Excel files
Software Ab Initio, Teradata, Oracle, Perl, MS Excel
Project Offer for a project for migrating a data warehouses from DB2 for z/OS to DB2 for AIX
Term 11/2006 - 11/2006
Company Insurance Company, Germany
Sector Insurances
Role Technical designer, project planner
Description
  • As-is analysis, feasibility study, design of the migration
  • Coarse project planing and effort estimation
Software IBM DB2, z/OS, AIX, Ascential DataStage, JCL
Project Reply to an RfP for a contract of work and services for a data warehouse project
Term 09/2006 - 10/2006
Company International Telecommunications Company, Bucharest, Romania
Sector Telecommunications
Role Author, analyst, architect, designer
Description
  • As-is analysis, requirements engineering
  • Conceptual design of ETL processes and solutions
  • Design of the technical aspects of the project
  • Design of a migration from Informatica to Ab Initio, Oracle 9i to Teradata
  • Presentation and documentation
Software Ab Initio, Informatica, Oracle, Teradata, Business Objects, MicroStrategy, PowerDesigner
Project European data warehouse project, Email-Service for mobile devices
Term 08/2006 - 08/2006
Company International Telecommunications Company, Germany
Sector Telecommunications
Role ETL designer, consultant
Description
  • Analysis of the requirements of business users
  • Analysis of concept and interfaces of middleware application
  • Coordination between designers, users and developers
  • Design of ETL processes
Software Oracle, Ab Initio
Project Data warehouse project, revenue and forecasting system
Term 05/2006 - 07/2006
Company International Telecommunications company, Tokyo, Japan
Sector Telecommunications
Role ETL designer, developer, consultant, coach
Description
  • Design and implementation of aggregations of CDR records
  • Alignment of two billing systems
  • Definition of standards for Ab Initio and shell scripts
  • Documentation, training, collaboration with quality assurance
Software Teradata, Ab Initio, BTEQ/SQL, Perl, Shell-Skripte, MicroStrategy
Project Development of SAND/DNA for SAP BI
Term 01/2005 - 05/2006
Company SAND Technology
Sector Software development
Role Technical project leader, architekt, designer, developer, tester
Description
  • Interface between SAP BW and SAND/DNA (Nearline Storage)
  • Technical project leader in an international team
  • Design and implementation: SAP BW side in ABAP, middleware in Java
Software ABAP, data modeling, BAPI, AAK, Batch Input, process chains, Java, OOA, OOD, UML, Eclipse, JUnit, Ant, AspectJ/AJDT, XML, CruiseControl
Project Migration concept for the ETL tool Ab Initio
Term 11/2004 - 01/2005
Company International telecommunications company, Germany
Sector Telecommunications
Role Consultant, architect
Description
  • Creation of a migration concept for the ETL tool Ab Initio
  • Definition of standards, guidelines and processes
  • migration of shell-, perl-, PL/SQL- and Informatica-scripts to Ab Initio
  • As-is analysis of the existing ETL tools, processes and development standards
  • Development of "best practices" for the migration
Software Oracle, Informatica, PL/SQL, Ab Initio, Cognos
Project Data Mart for analysis of customer behaviour
Term 09/2004 - 03/2005
Company International internet trader, Germany
Sector E-commerce
Role Consultant, designer, developer
Description
  • Data Mart for analytical CRM
  • Develoment and optimization of ETL processes
Software Eclipse, Perl, SQL and Java on Sun Solaris and Linux AMD64
Project Data warehouse for analytical CRM
Term 11/2002 - 08/2004
Company International Internet provider, Germany
Sector Internet provider
Role Consultant, designer, developer, administrator and tester
Description
  • Design and implementation of a distributed ETL architecture
  • Development of ETL processes with Ab Initio
  • Huge data sets, e.g. historical data with more than 1 billion rows
  • Design and implementation of algorithms
    • "Find the closest store for every customer" (geometric)
    • "Determine the optimal schedule for the ETL processes" (combinatoric)
Software Ab Initio, Eclipse, Perl, Java, Bash, C, Haskell, Sun Solaris, Business Objects, SAS, SPPS Clementine, Brio/Hyperion, ODBC, JDBC, MS SQL Server, Sybase, Excel, Uniserv, SPPS
Project Data warehouses and Business Intelligence
Term 09/2001 - 10/2002
Company Various companies
Sector Book retailer, consulting companies, finance service providers
Role Designer, developer, tester, consultant
Description
  • Development and maintenance of Business Intelligence systems
  • Relational OLAP (ROLAP) and multidimensional OLAP (MOLAP)
Software Oracle Datenbank, Oracle Express, Oracle Designer, Oracle JDeveloper, PL/SQL, Oracle Warehouse Builder, Java, BI Beans, Oracle Application Server, Oracle Web Agent, Apache Web Server
Project Analytical software for telecommunications and energy
Term 10/2000 - 08/2001
Company DWH Decision Warehouse GmbH, Hamburg, German
Sector Telecommunications, Energy, Software development
Role Analyst, designer, developer, tester
Description
  • Business Inteligence system
  • Analysis of telecommunications data
Software OLAP, data mining, active X, COM, Microsoft SQL Server, MS Visual Basic, interfaces to MS office
Project Fraud detection with Artificial Intelligence
Term 01/1999 - 09/2000
Company International telecommunications company
Sector Telecommunications
Role Research associate, consultant, architect
Description
  • As-is analysis and development of improvements
  • Fraud management and fraud detection
  • "Knowledge Discovery in Databases" data mining, data science
  • Fraud management systems, intrusion detection systems
Software IBM DB2, IBM Intelligent Miner, SGI MineSet, Java, Perl, R, PostgreSQL
Project Reengineering system for software maintenance of PL/I programs
Term 03/1993 - 08/1993
Company Consulting company, Cologne, Germany
Sector Software development
Role Designer, developer, tester
Description
  • Development of an analysis program for PL/I-Programs
Software C, C++, Turbo Pascal, Smalltalk, Yacc, PL/I