Johannes Schmidt teilweise verfügbar

Johannes Schmidt

Freelancer for Data Engineering, Business Intelligence & Software Engineering

teilweise verfügbar
Profilbild von Johannes Schmidt Freelancer for Data Engineering, Business Intelligence & Software Engineering aus Berlin
  • 12355 Berlin Freelancer in
  • Abschluss: Bachelor of Science in Applied Computer Science
  • Stunden-/Tagessatz:
  • Sprachkenntnisse: deutsch (Muttersprache) | englisch (verhandlungssicher)
  • Letztes Update: 10.07.2020
SCHLAGWORTE
PROFILBILD
Profilbild von Johannes Schmidt Freelancer for Data Engineering, Business Intelligence & Software Engineering aus Berlin
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

    • Universal Music Germany
    • 250-500 Mitarbeiter
    • Medien und Verlage
  • Freelancer for BI, Data Engineering & Web Development
    • 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

    • Urban Sports GmbH
    • 250-500 Mitarbeiter
    • Sonstiges
  • Freelance Data Analyst
    • 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

    • Urbanara GmbH
    • 10-50 Mitarbeiter
    • Konsumgüter und Handel
  • Freelance Data Warehouse Engineer
    • 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

    • nordisch Filmproduction
    • 10-50 Mitarbeiter
    • Medien und Verlage
  • Full Stack Web Application Development Project
    • 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

    • Universal Music
    • 250-500 Mitarbeiter
    • Medien und Verlage
  • Working Student for Business Intelligence
    • 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

    • Hewlett-Packard Germany
    • >10.000 Mitarbeiter
    • Internet und Informationstechnologie
  • Software Engineering Interships (Dual Study Program)
  • 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“


KONTAKTANFRAGE VERSENDEN

Nachricht:

Absenderdaten: