Johannes Schmidt

supporting & consulting the business intelligence unit in ETL processes; implementing interfaces for data extraction & aggregation from different sources, such as web APIs, MySQL Databases; data modeling and optimization using the company's business intelligence system; creating & designing reports & dashboards for the visualization of predefined KPIs; enhancing the web application of the company's business intelligence software on the front and back end

• 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

• enhance existing & build new data warehouse based on PostgreSQL and python • 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

• Full stack web application development • 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 (including but not limited to): HTML/CSS/Javascript, jQuery, Bootstrap, PHP, MySQL, Dymo.js

implementation of interfaces for data extraction & aggregation from several web APIs and development & enhancement of a web portal as a single point of entry for reports and dashboards

Department HP Data Protector - development of a business process management prototype for the integration and automation of processes using Java

Department HP Software Operations Fort Collins, Colorado, USA - further development of an application responsible for the virtual simulation of a network, working as part of a Scrum team

Department HP Communications & Media Solutions Marketing - development of a mobile app for webOS, accessing the company's employee database with contact info using Java/HTML/CSS

Department for HP Software Business Technology Optimization, Quality Assurance - development of a test coverage analysis application for the software "HP Business Service Management (HP OpenView)"