Stephan Z. - GIS Expert and Database Developer in the Field of Traveler Information Systems

Go to Website

Brombachtal, Germany

Experience

Apr 2024 - Present

1 year 9 months

GIS Expert and Database Developer in the Field of Traveler Information Systems

Deutsche Bahn AG

Developed automated tools for passenger information systems using PostgreSQL/PostGIS (administration & development), imposm, osm2pgsql, pgsql2shp, GeoServer (WMS, WFS, WCS, etc.), and various geo-formats like OpenStreetMap (OSM).
PostgreSQL/PostGIS, imposm, osm2pgsql, pgsql2hp, (ESRI) Shape-Files, QGIS, Python 3.x, PyDev, Eclipse, Linux, AWS, OSM, XML, bash, pgsql, Docker

Mar 2022 - Dec 2022

10 months

Python Software Developer & Data Scientist

Deutsche Bahn AG

Developed an analysis framework for train movement reports, which forms the basis for real-time data in passenger information systems.
Python 3.6, PyDev, Eclipse, PostgreSQL/PostGIS, Data Science

Dec 2021 - Dec 2021

1 month

Android App Developer

ieits integrated enterprise IT solutions GmbH

Developed three apps:
Time tracking for mini-jobs and reporting (web)
Analytical capture of sales booking transactions
Tracking performance metrics
Android Studio, MySQL

Nov 2021 - Dec 2022

1 year 2 months

Senior Digitalization Consultant

Wianco OTT Robotics GmbH

Installed, configured, and commissioned a new software version for the workflow management system of a large energy supplier.
Fintus 2.1, MS SQL Server, Java, Web, BPMN, Camunda

Apr 2021 - Apr 2021

1 month

Germany

PostgreSQL and BitBucket Expert, Python Developer

GOIO Data GmbH

Set up a CD pipeline for SQL commands and developed an exporter.
PostgreSQL, BitBucket, Python3

Jan 2021 - Apr 2021

4 months

Germany

MS Access Expert, Moodle Development

ZDSK and TANDEM-Frankfurt e.V.

MS Access with Moodle.
VBA, MS Access, Moodle

Dec 2020 - Jan 2021

2 months

Germany

MS Access Expert

DekaBank

MS Access ODBC to Oracle troubleshooting and documentation.
VBA, MS Access, Oracle

May 2020 - May 2021

1 year 1 month

Germany

PostgreSQL and MS Access Expert

Deutsche Bahn AG

Migration of an MS Access backend to PostgreSQL.
VBA, MS Access, PostgreSQL, Windows, PowerShell (DOS)

Feb 2020 - Feb 2020

1 month

Germany

MS SQL Server and MS Access Expert

Deutsche Bahn AG

Conducting a feasibility study for migrating the MS Access backend to MS SQL Server.
VBA, MS Access, MS SQL Server, Windows, PowerShell (DOS)

Dec 2019 - Dec 2019

1 month

Germany

C# Developer

Wianco OTT Robotics

Development of components for text recognition.
C#; MS Visual Studio 2019, ABBYY FineReader

Jul 2019 - Aug 2019

2 months

Sanya, China

Peer-Reviewer

CSAE 2019

Review technical papers for the CSAE 2019 conference (blind peer review).

Jul 2016 - Oct 2016

4 months

Brombachtal, Germany

Database Administrator

ieits integrated enterprise IT solutions GmbH

Conducted a case study for database migration from Oracle to PostgreSQL / PostGIS for the EUMETSAT long-term archive (UMARF).
Oracle 12g, PostgreSQL / PostGIS 8.3.
on-time / on-budget.

Aug 2013 - Apr 2019

5 years 9 months

Brombachtal, Germany

Software and System Engineering Consultant

ieits integrated enterprise IT solutions GmbH

Software and System Engineering Consultant, project lead for EUMETSAT on the EUMETSAT Advanced Retransmission System (EARS).
Java (5-8), Linux, PostgreSQL, Oracle, HTML, JScript, SQL, XML, Python2/3, Apache ActiveMQ.
Lead for EARS system requirements and system design.
Complete redesign for EARS 2.0.
Published articles in industry publications.
Participated in international reviews.

Aug 2010 - Aug 2013

3 years 1 month

Darmstadt, Germany

System Engineering Consultant

EUMETSAT

Software and System Engineering Consultant, project lead for EUMETSAT on the EUMETSAT long-term archive (UMARF).
Java (5-8), C ++, Linux, Windows, Oracle 11g / 12g, PostgreSQL / PostGIS, HTML, JScript, CORBA, XML, Jenkins, Maven, REST.
Responsible for the design of extensions to UMARF (long-term archive) and EOPortal (web ordering application) for Sentinel 3.
Participated in international reviews.

May 2005 - Aug 2010

5 years 4 months

Brandenburg, Germany

Project Manager, Lead Software Engineer

RapidEye AG

Software and system engineer for RapidEye's ground segment.
Managed various customer projects, including map creation using spatial data and geoformats for analysis with PostgreSQL/PostGIS, GeoServer, QGIS, etc.
Java (4-6), Swing, C++, HTML, PostgreSQL/PostGIS, ESRI ArcGIS, XML, JScript, WMS, WFS, WCS, GeoServer, imposm, osm2pgsl, pgsql2shp.
Lead software engineer and designer of the Product Processing System.
Named the 5 RapidEye satellites.
Participated in international reviews.

May 2003 - Nov 2004

1 year 7 months

Berlin, Germany

Software Developer, Project Manager

Alpha Travel Consultants GmbH

Re-implementation (new concept) of a web-based application for online booking and management for travel arrangement resellers.
MS .NET, C#, JScript, Ajax.
Supervision of the offsite development team in Belarus.

May 1998 - May 2005

7 years 1 month

Berlin, Germany

Head of Software Development, Project Manager, Consultant and Software Developer

CMO Information Systems GmbH

Execution of all tasks in software engineering.
Project manager.
C++, Java, MFC, Oracle 7-9, MS SQL Server, MySQL, C#, XML, XSL, XSD, WSDL, Windows, DOS, IIS, ATL, STL, COM / DCOM, OCX, RPC, OLE, ODBC.

Jan 1998 - Apr 1998

4 months

Berlin, Germany

System Administrator and Software Developer

SDC GmbH (now CMG Deutschland GmbH)

System administrator and software developer for Commerzbank.
Windows, Linux, Oracle, MS SQL Server, VBA, C++.

Apr 1997 - Dec 2005

8 years 9 months

Berlin, Germany

Software Developer, Research Associate

Federal Institute for Health Protection of Consumers and Veterinary Medicine (BgVV), (now Federal Institute for Risk Assessment

Execution of several research projects on replacing animal testing in chemical evaluation.
Windows, MS Access, DOS.
2004 Dorothy Hegarty Award for the best paper published in ATLA 32.

May 1996 - Dec 1997

1 year 8 months

Berlin, Germany

Research Associate and Software Developer

Federal Institute for Health Protection of Consumers and Veterinary Medicine (BgVV), (now Federal Institute for Risk Assessment

Development of a computer-based expert system to predict potential toxicological effects of chemicals on skin and eyes.
MS Access, VBA.
Publication of articles in professional journals.

Feb 1995 - Sep 1995

8 months

Blankenfelde-Mahlow, Germany