Stefan Fuchs
Verified Expert in Engineering
Data Warehouse Design Developer
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
Experience
Availability
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.
Work Experience
Data Engineer
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.
BI Specialist
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.
Team Lead CRM & Reportng Systems Pharma Germany
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.
Sales Controller (Field Force Evaluation)
Berlin-Chemie AG
- Created standard reports.
- Developed report automation.
- Provided ad-hoc analysis.
- Defined KPIs.
- Designed and calculated Bonus System.
Junior Sales Controller
Berlin-Chemie AG
- Developed standard reports.
- Automated reports.
- Provided ad-hoc analysis.
Experience
Event Collector
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 (Transact-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
FOM - Berlin, Germany
Bachelor of Arts Degree in Business Administration
VWA - Berlin, Germany
Diploma in Informatik-Betriebswirt (IT & business administration)
VWA - Berlin, Germany
Education and Apprenticeship in Informatikkaufmann (IT economics)
OSZ für Industrie und Datenverarbeitung and Berlin-Chemie AG - Berlin, Germany