Profilbild von Johannes Schmidt Freelancer for Data Engineering, Business Intelligence & Software Engineering aus Berlin

Johannes Schmidt

teilweise verfügbar

Letztes Update: 06.09.2022

Freelancer for Data Engineering, Business Intelligence & Software Engineering

Abschluss: Bachelor of Science in Applied Computer Science
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (verhandlungssicher)

Skills

ETL, APIs, MySQL Databases, Facebook Graph API, Analytics API, PostgreSQL, Amazon API, Spotify API, data modeling, SQL, visualization, data visualization, REST API, flask, Sisense, HTML/CSS, Javascript, Bootstrap, jQuery, jVectorMap, d3, js, Highcharts, Java, Python, MS Office, Bash Scripting, eclipse, MySQL, vue.js, FTP, database, Metabase, Git, Data Warehouse, Shopify, API, Webshop, metadata, HTML, CSS, RESTful, Mondrian, Jenkins, Google Docs, Shopify API, Saiku, Vagrant, VirtualBox, PyCharm, Bash, Linux, Web Application Development, DB, user management, Dymo, PHP, Facebook, backup, HP OpenView, mobile application, operating system, Scrum, jBPM

Projekthistorie

04/2016 - bis jetzt
Freelancer for BI, Data Engineering & Web Development
Universal Music Germany (Medien und Verlage, 250-500 Mitarbeiter)

  • supporting & consulting the business intelligence unit in ETL processes
  • implementing ETL processes using different sources, such as web APIs, MySQL Databases (i.e. Facebook Graph API, Google Analytics API, PostgreSQL, Amazon API, Spotify API)
  • data modeling and optimization using the Business Intelligence Tool Sisense and SQL
  • creating/designing reports & dashboards for the visualization of predefined KPIs
  • Sisense front/back end enhancement & plugin development for advanced data visualization
  • REST API development based on flask and PostgreSQL
  • full stack web development

Overview of Software, Frameworks and Tools used: Sisense, HTML/CSS & Javascript, Bootstrap, jQuery, jVectorMap, d3.js, Highcharts, Java, Python, MS Office, Bash Scripting, eclipse, PostgreSQL, MySQL, vue.js, FTP


07/2019 - 05/2020
Freelance Data Analyst
Urban Sports GmbH (Sonstiges, 250-500 Mitarbeiter)

  • MySQL/PostgreSQL database analysis & documentation
  • reporting and decision making support for B2B migration/post-merger processes
  • implementation/design of dashboards and ad-hoc reports
  • direct line of support for merger stakeholders, partner management, customer care/acquisition, finance

Overview of Software, Frameworks and Tools used: Metabase, PostgreSQL, MySQL, Python, Git, HTML/CSS & Javascript, MS Office

02/2019 - 06/2019
Freelance Data Warehouse Engineer
Urbanara GmbH (Konsumgüter und Handel, 10-50 Mitarbeiter)

  • enhance existing & build new data warehouse based on PostgreSQL
  • development of daily ETL processes
  • create processes to gather Shopify data using its API & update Webshop metadata
Overview of Software, Frameworks and Tools used:  Python, git, PostgreSQL, Mondrian, Jenkins, Google Docs, Shopify API, REST API, Saiku, Vagrant, VirtualBox, PyCharm, Bash, Linux

07/2018 - 12/2018
Full Stack Web Application Development Project
nordisch Filmproduction (Medien und Verlage, 10-50 Mitarbeiter)

  • view and manage entries of a MySQL Database comprised of a movie DB
  • Web App inlcudes user management, listing/searching & filtering of entries, creating new entries, editing & updating database, printing of labels using the Dymo Framework
Framesworks & Tools used: HTML/CSS/Javascript, jQuery, Bootstrap, PHP, MySQL, Dymo.js

01/2014 - 01/2016
Working Student for Business Intelligence
Universal Music (Medien und Verlage, 250-500 Mitarbeiter)

  • implementation ETL processes using several web APIs (i.e. Facebook Graph API, Amazon API)
  • development & enhancement of a web portal as a single point of entry for reports and dashboards
  • statistical analysis and creation of dashboards using the Business Intelligence Tool Datameer
  • development of Java Programs for backup and restore purposes of Datameer configurations, using the Datameer REST API

10/2009 - 09/2012
Software Engineering Interships (Dual Study Program)
Hewlett-Packard Germany (Internet und Informationstechnologie, >10.000 Mitarbeiter)

Department HP Software BTO, Division for Quality Assurance (Mar 2010 - May 2010):

Evaluation and development of a solution for the manual test coverage analysis of HP BSM Software (Business Service Management, former name “HP OpenView“) and integration of new processes.

Department HP Communications & Media Solutions Marketing (Nov 2010 - Feb 2011):

Development of the mobile application “HP Contacts“, an offline database-driven phone directory containing contact information of all HP employees, for the operating system webOS. 

Hewlett-Packard Fort Collins, Colorado (USA), Department HP Software Operations (Jun 2011 - Sep 2011):

Enhancement of an application responsible for the virtual simulation of a network, while working as part of a Scrum team.

Department HP Dataprotector (May 2012- Sep. 2012):

Work on the Bachelor thesis titled “Implementation of a Prototype for Error-handling and REST-based Business Process Management using jBPM“


Reisebereitschaft

Verfügbar in den Ländern Deutschland
Profilbild von Johannes Schmidt Freelancer for Data Engineering, Business Intelligence & Software Engineering aus Berlin Freelancer for Data Engineering, Business Intelligence & Software Engineering
Registrieren