SW Engineer, Data Analyst/-Scientist

6/2019 – 31/8/2019
DB Systel GmbH, Frankfurt am Main
Data Scientist / Developer
+ Consultation and Development of BI Dashboards in Splunk
+ Machine Learning Prediction with the Splunk MLTK
+ for further information see german description

8/2017 – 1/2018
EXA AG
Data analysis - Predictive Maintenance
+ Data analysis in SAP HANA. Machine learning driven prediction in SAP HANA PAL (Predictive Analytics Library) &
+ Development of analytics concept
+ Analysis of existing data on HANA
+ Data preprocessing (data cleansing, feature extraction, feature selection, field-aggregation, dimensionality reduction with PCA, table transformation and transposition)
+ Machine learning classification with various algorithms:  logistic regression, KNN, SVM, decision tree, random forest, neural network (multi-layer-perceptron) of logged sensor data
+ examination of possible clustering use-case for K-Means
+ development in SAP HANA (HANA SQL Script) as component for further automated use
+ development in Python ( Jupyter, PyCharm, Pandas, Numpy, Scikit-learn ) for proof of concept
+ Explorative visualization and presentation in Tableau
 
Technologies:
+ SAP HANA Developer, SAP HANA SQL Script
+ Python, Jupyter, PyCharm, Pandas, Numpy, Scikit-learn, Tableau

4/2017 – 7/2017
KKS Architekten GmbH
System administrator
+ System administration: Administration of server hardware and software, installation of software on desktop PCs, automatic backups of fileserver, possible replacement and installation of switches, cables, PC soft- and hardware
+ System integration: Installation und startup of server hardware and Software, server virtualization with Proxmox
+ Internal technical consultation

4/2016 – 9/2016
H_DA
Developer - ETL / Data warehouse
Analysis / ETL:
+ Data Processing/ ETL from JSON in "Pentaho Spoon"-ETL Suite into a MySQL Data warehouse

Frontend:
+ Open-Source BI Dashboard in Material Design made with Bootstrap with interactive Javascript open-source dashboard-elements (Pie-, Donut-, Line charts, Geolocation-map and more)
+ jQuery for additional functionality

Backend:
+ Local Apache webserver in XAMPP, MySQL DB with custom PHP API for dashboard connection
+ Processing of form data with custom PHP API. Outputs are aggregated data und time-series for dashboard charts. communication with REST.

Technologies:
MySQL, Pentaho Spoon, JavaScript, Bootstrap, PHP, HTML, CSS, Postman, Heidi SQL

9/2014 – 12/2015
DB Systel GmbH
Functional Architect
+ Team: functional management of data delivery
+ Data analysis, error analysis and data maintenance in Oracle SQL Developer, Excel, Altova XMLSpy
+ development of tools und scripts in oracle SQL developer und excel VBA
+ maintenance of passenger information
+ adjustment of GPS Windows

Technologies:
Oracle SQL, SQL Developer, Excel VBA, Altova XMLSpy

11/2013 – 6/2014
Energy Net GmbH
System integrator
+ System integration: Installation and startup of server hardware
+ Software virtualization in VMware vSphere
+ System administration: oversight of server hardware and software
+ Setup of monitoring over web-frontend. JBoss, Java, Hibernate   and SQL-Script development for monitoring
+ supporting function for data analysis
+ adjustment of frontend with HTML und CSS
+ business support: telephone support at client requests, VPN server, local service and error handling, configuration of Astaro hardware firewall