Stefan Fuchs, Data Warehouse Design Developer in Vienna, Austria
Stefan Fuchs

Data Warehouse Design Developer in Vienna, Austria

Member since April 28, 2018
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.
Stefan is now available for hire

Portfolio

Experience

Location

Vienna, Austria

Availability

Part-time

Preferred Environment

Ubuntu, Windows, Slack, Jira, Bitbucket, IntelliJ

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.

Employment

  • 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

Experience

  • 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).

Skills

  • Languages

    SQL, Apex, Java, Scala, T-SQL, Java 8
  • Paradigms

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

    Spark, Spring, Spring Boot, Spring IoC, Spring MVC
  • Platforms

    Oracle, Apache Kafka, Windows, Ubuntu, QlikView
  • 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)
  • Tools

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

Education

  • Master of Arts degree in IT Management
    2012 - 2015
    FOM - Berlin, Germany
  • Bachelor of Arts degree in Business Administration
    2009 - 2011
    VWA - Berlin, Germany
  • Diploma in Informatik-Betriebswirt (IT & business administration)
    2006 - 2009
    VWA - Berlin, Germany
  • Education and apprenticeship in Informatikkaufmann (IT economics)
    1998 - 2001
    OSZ für Industrie und Datenverarbeitung and Berlin-Chemie AG - Berlin, Germany

To view more profiles

Join Toptal
Share it with others