Schlagwörter
Skills
Projekthistorie
- 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
- 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
- development of daily ETL processes
- create processes to gather Shopify data using its API & update Webshop metadata
- 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
- 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
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“