Stefan Fuchs, Developer in Vienna, Austria
Stefan is available for hire
Hire Stefan

Stefan Fuchs

Verified Expert  in Engineering

Data Warehouse Design Developer

Location
Vienna, Austria
Toptal Member Since
June 18, 2020

Stefan is a passionate data engineer and data warehouse developer who knows how to build complex, scalable data processing flows and data structures for data analysis. He has worked with Oracle, Postgres, diverse BI-Platforms (QV, SAP BO, Cognos) and focused on BigData processing (Apache Kafka, Spark, Cassandra) over the last two years.

Portfolio

willhaben.at
PostgreSQL, Sybase, SAP, QlikView, Apache Kafka, Spark, Cassandra, Spring, Java...
Coface Austria
Oracle Application Express (APEX), PL/SQL...
Berlin-Chemie AG
Microsoft Access, Apex, IBM Cognos, Oracle

Experience

Availability

Part-time

Preferred Environment

Ubuntu, Windows, Slack, Jira, Bitbucket, IntelliJ IDEA

The most amazing...

...project I've worked on was a recursive decent parser for Oracle SQL functions including analytical functions for a sophisticated syntax highlighter.

Work Experience

Data Engineer

2015 - 2018
willhaben.at
  • Redesigned the category data structure in the OLTP DB.
  • Contributed to optimizing the data model and stored procedures in collaboration with the Java developers.
  • Redesigned the data pipeline from the OLTP-system to the BI Tool (QlikView).
  • Supported the setup of a Cassandra cluster.
  • Developed an event collector including some Java components such as Spring Boot, Kafka, and Cassandra.
  • Supported the setup of a Spark cluster.
  • Developed Spark jobs (using Scala) to aggregate the collected event data.
Technologies: PostgreSQL, Sybase, SAP, QlikView, Apache Kafka, Spark, Cassandra, Spring, Java, Scala

BI Specialist

2014 - 2015
Coface Austria
  • Migrated and redesigned the data warehouse.
  • Redesigned the BO Universe (meta-data layer).
  • Implemented the ETL using PL/SQL.
  • Built the UI for data maintenance using Oracle APEX.
Technologies: Oracle Application Express (APEX), PL/SQL, SAP BusinessObjects Data Service (BODS), Oracle

Team Lead CRM & Reportng Systems Pharma Germany

2011 - 2014
Berlin-Chemie AG
  • Managed all systems related to the support of the pharma sales force in Germany (reporting, CRM, and territory management).
  • Served as an internal consultant to the sales and product management.
  • Engineered requirements for a new CRM.
  • Migrated Access apps to Oracle using APEX as UI.
Technologies: Microsoft Access, Apex, IBM Cognos, Oracle

Sales Controller (Field Force Evaluation)

2004 - 2010
Berlin-Chemie AG
  • Created standard reports.
  • Developed report automation.
  • Provided ad-hoc analysis.
  • Defined KPIs.
  • Designed and calculated Bonus System.
Technologies: Oracle PL/SQL, Oracle SQL, Cognos 10, Microsoft Excel, Microsoft Access

Junior Sales Controller

2001 - 2003
Berlin-Chemie AG
  • Developed standard reports.
  • Automated reports.
  • Provided ad-hoc analysis.
Technologies: GIS, Microsoft Access, Microsoft Excel, Cognos 10

Event Collector

The events are sent to a Kafka Queue that is consumed by multiple instances of a Java component that is writing the data to a Cassandra DB.

The setup handles currently 2k events per second but is able to scale linear horizontally. The system is highly available due to multiple instances (respectively partitions).
2012 - 2015

Master of Arts Degree in IT Management

FOM - Berlin, Germany

2009 - 2011

Bachelor of Arts Degree in Business Administration

VWA - Berlin, Germany

2006 - 2009

Diploma in Informatik-Betriebswirt (IT & business administration)

VWA - Berlin, Germany

1998 - 2001

Education and Apprenticeship in Informatikkaufmann (IT economics)

OSZ für Industrie und Datenverarbeitung and Berlin-Chemie AG - Berlin, Germany

Tools

Bitbucket, Jira, Slack, Microsoft Excel, Microsoft Access, GIS, IBM Cognos, Oracle Application Express (APEX), IntelliJ IDEA

Paradigms

Database Design, ETL Implementation & Design, Agile Software Development, Object-oriented Programming (OOP), Database Development, Functional Programming, MVC Design, Design Patterns, Requirements Analysis

Languages

SQL, Apex, Java, Scala, T-SQL (Transact-SQL), Java 8

Platforms

Oracle, Apache Kafka, Windows, Ubuntu, QlikView

Frameworks

Spark, Spring, Spring Boot, Spring IoC, Spring MVC

Storage

PL/SQL, PostgreSQL, Oracle SQL, Oracle PL/SQL, Cassandra, Sybase, Spring Data for Apache Cassandra, Database Modeling

Other

Apache Cassandra, Data Warehouse Design, Cognos 10, SAP BusinessObjects Data Service (BODS), SAP, SAP BusinessObjects (BO)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring