Hello, I am Simon Schreck

As an IT consultant at tuteco GmbH, I specialised in Data Engineering, metadata management and application development. My work included the design and implementation of metadata mapping solutions, the optimisation of data processes as well as the development of Python-based applications for the harmonisation of legacy systems. Additionally, I led projects in the areas of process modelling (BPMN 2.0, UML), database analysis (Oracle, PostgreSQL) and tool provision (Docker, AWS ECR). My focus was on creating scalable and maintainable solutions for data integration and management in corporate environments.

• Metadata management & mapping

  • Development and maintenance of a Python application for mapping metadata from multiple legacy systems to harmonise data structures and enable efficient data integration.
  • Python, Flask, PostgreSQL, Oracle SQL, Microsoft SQL, master data, metadata, data integration, Docker, AWS ECR, UML

• Application development & provision

  • Design and implementation of web services for metadata processing, including containerisation and cloud provision.
  • Web services, REST APIs, Flask, Docker, Podman, Docker Compose, AWS ECR, CI/CD

• Database analysis & modelling

  • Analysis of databases from legacy systems to identify data structures, relationships and optimisation potentials for migration- and integration projects.
  • Oracle SQL, Microsoft SQL, PostgreSQL, data modelling, UML, ER diagrams, data migration

• Process optimisation & tool implementation

  • Restructuring of backlogs and adapting task templates in Azure DevOps to align with team workflows and requirements.
  • Azure DevOps, Kanban, Agile methods, task templates, team workshops, process documentation

The training was conducted as an extraordinary vocational training in cooperation between tuteco GmbH in Lörrach and the Wirtschaftsakademie Pfalz (WA) in Ludwigshafen. The main motivation was the practical imparting of solution competence in the field of information processing in companies.

• Software development

  • Developing practical software solutions in information and knowledge management.
  • Programming languages Python and R, version control, object orientation, structuring of software packages, reading data sources, preparing data, building data structures, file formats in data processing, programmatic statistical evaluation of data, programmatic representation of information

• Databases

  • Basics of relational and NoSQL databases.
  • Relational databases, NoSQL databases, data processing with SQL, database programming, data modelling

• Information management

  • Practical Application of Information Management
  • Identifying information needs , planning information offerings, availability of information, information quality, organisation of information supply, information architectures, evaluation of information technology solutions, strategic information management

• Knowledge Management

  • Practical Application of Knowledge Management
  • Types of knowledge, importance of knowledge for businesses, identification and planning of knowledge needs, knowledge objectives, knowledge acquisition, knowledge development, knowledge distribution, knowledge utilisation, knowledge preservation, knowledge evaluation. Process orientation in knowledge management

• Cloud Computing

  • Understanding and applying the fundamentals of modern solution architectures of the cloud. Using the provider Amazon Web Services (AWS) to learn about the various components of cloud architecture and being able to apply them in practical work.

• Business Economist (WA)

  • The knowledge for the business economist was acquired at the Economic Academy Pfalz and successfully completed with a final examination as well as a cross-disciplinary project work in computer science and business administration.

• Project Management (WA)

  • The fundamentals of project management were conducted at the Economic Academy Pfalz through the course "Specialist in Multi-Project Management (WA-Pfalz)" and successfully completed with a final examination.

• Own Project: Stock Price Weighting

  • On my own initiative, I developed an application for weighting stocks based on the data series from Yahoo Finance.
  • Fetching data from API, Yahoo Finance API, Programming language R, R Markdown, Machine Learning, Portfolio management