Sebastian Hoering
IT-Consultant
MSc (LSE)
Stuckstraße 9
81677 München
Fon: +49 89 6971888
sebastian@hoering.de
Archived Site - Out of date!
Continue here!

Projects

 
 
Project: IT security clearance of a SaaS solution
Description: Preparation and implementation of the IT security audit and pen test.
Project management.
Determination of protection requirements in collaboration with the department and IT security officer.
Identification of a catalogue of measures based on the analysis of protection requirements and steering the implementation of the measures.
Preparation & execution of the audit with the external auditor.
Preparation and performance of a pen test.
Moderation of workshops to analyse and evaluate the results and define measures.
Planning and controlling the implementation of further measures for the long-term improvement of IT security.
Evaluation of IT security approval:
Security Rating: Good
Maximum risk level: Low
Function: Project Lead, Architect
Skills: ISMS, IT-Security, formal audit processes
Team Size: >20
Years: 2022 - 2023
 
Project: ISMS implementation / TISAX audit
Description: Setup and introduction of an ISMS.
Project management.
Definition and implementation of an information security management system to fulfil TISAX AL2 "Handling of information with high protection requirements".
Definition of company-specific requirements.
Design and implementation of the ISMS, coordination with stakeholders.
Tayloring for the specific requirements of a multi-project organisation and a SaaS provider.
Managing the definition and introduction of company-wide processes.
Change management and implementation support in the individual projects.
Auditing the ISMS and its implementation.
Result:
Maturity level 3 at 40 and maturity level 2 at one out of 41 controls.
TISAX label issued without major or minor deviations.
Function: Project Manager
Skills: ISMS, TISAX, formal audit processes, IT-Security
Team Size: >40
Years: 2021 - 2022
 
Project: Test Automation and Monitoring Ecosystem & SaaS
Description: Design & implementation of end-2-end test automation.
Requirements analysis in the environment of digital services in the automotive sector.
Workshops to analyse the current situation and identify requirements.
Evaluation of the requirements and formulation as a feature map.
Extension of standard TA functionality with virtual testing and automatic test data management including generation and cleanup.
Can be used in the development context as well as in the active monitoring of live systems.
Realisation of a solution as a UML model, structure of the feature map, dependency analysis of the feature areas.
Prototyping and development of individual features.
Support of the systems to be tested:
Web portals, MQTT Services, REST APIs, and mobile devices
Automated distribution of test results to numerous group-wide client systems via MQTT.
Integration into existing tool landscape (Jira, Jenkins, Pager Duty, monitoring infrastructure).
Load and performance tests based on business test cases.
Elaborated reporting: aggregation, dashboarding, and timelining via OpenSearch, including drilldown to detailed test reports in the execution environment.
Design, implementation, commissioning of a micro-service aand bot army for test data supply in the IoT area.
Function: Requirements Engineer, Principal Architect, Projekt Lead
Skills: AWS, Python, Selenium, Appium, MQTT, Jenkins, Jira, REST, XML, VueJS, Vuetify
Team Size: >200
Years: 2016 - now
 
Project: Architect Mulesoft & Salesforce load and performance tests
Description: Design & implementation of end-2-end load and performance tests of a Salesforce template and a national market of an automotive group.
Use of existing end business tests to achieve meaningful load test results.
Implementation of the load test functionality for the existing test automation.
Preparation of variant realistic mass test data.
Use of load and performance test results for empirical verification and right-sizing of Salesforce limits.
Use of the load and performance test results for empirical verification of the MuleSoft Worker configuration and timeouts.
Use of Salesforce and MuleSoft instrumentation to identify internal errors and bottlenecks.
Workshops with all trades to jointly monitor the environment during the test execution and to identify the appropriate measures.
Function: Software Architect
Skills: EAI, ESB, Distributed Services, Python
Team Size: >80
Years: 2020 - 2022
 
Project: Code review of a Salesforce template for national markets of several brands of an automotive group
Description: Compliance with coding standards and naming conventions.
Proposal of patterns to standardise the code base.
Identification of antipatterns.
Identification of refactoring guidelines for the optimisation of reuse and call structures.
Permission checks and batch sizes.
Technical assessment of unit test coverage.
Evaluation and interpretation of the automated code analysis.
Workshops to resolve the findings with developers and architects.
Function: Code Review Engineer
Skills: Patterns, Antipatterns, Clean Code, Code Refactoring, Architecture Refactoring
Team Size: >80
Years: 2020 - 2021
 
Project: Integrative Test Management for Vehicle related Online Services
Description: Integrative Test Management.
Planning of tests spanning several Projects.
Coordination of test concepts and test plans between projects of several main departments.
Consolidation of release and deployment plans.
Concept, implematation and training of the cross project test data management.
Gap analysis of test coverage.
Cocept for testing of non functional requirements.
Function: Integrative Test Manager
Skills: Test Management, Project Management
Team Size: >40
Years: 2014 - 2018
 
Project: Platform for the international Sales Web Sites of a Premium Automobile Manufacturer
Description: Senior Requirements Analyst of a "multi-scrum" project employing more than 300 team members.
Specified the standards for writing detailed business concepts.
Consolidated the processes for writing business concepts, business documentation and technical documentation.
Developed central business concepts (multi client capability, internationalization).
Function: Senior Requirements Analyst
Skills: Requirements Analysis, UML, Large Projects, Scrum, Multi-Scrum
Team Size: >300
Years: 2012 - 2014
 
Project: Software for claims management
Description: Analysed the requirements and identified the business cases, subsequently developed and refined the use cases.
Designed the architecture and implemented the Systems.
Developed a System for entering the claims based on Spring, Tomcat und Hibernate.
Developed a system for managing the workflow and managing the claims based on Eclipse RCP, JFace, MySQL.
Automated synchronisation of both systems.
Generation of letters using OpenOffice.org and UNO.
Function: Technical Project Manager, Requirement Analyst, Developer
Skills: RCP, JFace, Spring, Tomcat, MySQL, DTAUS, SEPA, MT940, OpenOffice.org, UNO
Team Size: up to 5
Years: 2008 - 2013
 
Project: Platform for the international Sales Web Sites of a Premium Automobile Manufacturer
Description: Staff function "Business Integration" of a "multi-scrum" project employing more than 300 team members.
Matched technical architecture and business architecture.
Specified the standards for business documentation. Defined a process for generating all relevant documents required by BMW ITPM process from one consolidated set of documentation maintained in a Wiki.
Coordination of business requirements and technical requirements.
Mediated between business department and scrum teams.
Function: Virtual Team Business Integration
Skills: Requirements Analysis, UML, Large Projects, Scrum, Multi-Scrum
Team Size: >300
Years: 2011, 2012
 
Project: Web-Portal generating Reports und Analyses
Description: Development of a web portal which provides functionalities for generating reports and analyses based on a data warehouse and which manages all related workflows and reports.
Introduction of a Scrum-like development process.
Function: Development Team Lead, Scrum Master
Skills: GWT, ExtGWT, Spring, Hibernate, Tomcat, Cubeware
Team Size: 8
Years: 2009, 2010
 
Project: Architecture for a Web-Portal generating Reports und Analyses
Description: Architecture document for a web portal which provides functionalities for generating reports and analyses based on a data warehouse and which manages all related workflows and reports.
Analysis and consideration of alternative Technologies.
Gave a recommendation for the appropriate tools and development process.
Function: Software Architect
Skills: Comprehensive experience regarding software architecture and development processes
Team Size: 3
Years: 2009
 
Project: Data restructuring of a Market Data System
Description: Analysed the status quo. Prepared a wealth of reports in order to identify the potential areas of improvement, also reflecting demanding requirements regarding scalability and numerous dependent processes.
Fine-tuned the measures with the specialist department.
Introduced a fine-grained process for unloading and archiving data.
Function: Requirement Analyst, Developer
Skills: Asset Control, Jetty, Java, Solaris, Perl
Team Size: 7
Years: 2009
 
Project: Standard Software for Data Preparation in Smartcard production
Description: Managed the development of a standardised software for preparing and enriching all data necessary for the production of all kinds of different smart cards (money cards, credit cards , GSM SIM cards...), which, until then, had been dealt with using numerous different applications.
Led the team through the entire life cycle - from analysis and consolidation of requirements with the operating departments through the development phase to the introduction of the product in the production environment.
Coordinated the joint development of common components with other departments.
Function: Technical Project Manager
Skills: Sun Java System Application Server (Glassfish) , Web Services, J5EE, Java 6, OpenBP, MDA, Code Generation
Team Size: 12
Years: 2006, 2007, 2008
 
Project: Introduction of a New Card Type for a Prominent Customer Bonus Program
Description: Analysed and consolidated the requirements with the expert departments.
Designed and implemented the necessary new components in the middle tier and in the web tier based on the existing architecture.
Function: Requirements Engineer, Moderator, Developer
Skills: BEA Weblogic, WebWorks, Spring, JSP, Hibernate, CoreMedia, Tomcat
Team Size: 10
Years: 2006
 
Project: Architecture and Coaching for a Configuration Management Tool
Description: Coached the architecture and development of a configuration management tool for complex simulation systems at a major European aeronautics and space company.
The system was based on meta models representing the workflow utilising a multi-level validating state machine.
Function: Architect, Coach
Skills: Spring, Hibernate, Tomcat, JSP
Team Size: 18
Years: 2005 / 2006
 
Project: Troubleshooting and Completion of a Real Time Data-Plotter in Java
Description: The tool is used to display real time flight simulation data at a major European aeronautics and space company.
An analysis of the existing project with regard to risks and efforts involved in its completion was undertaken.
In a second step the requirements were consolidated with the stakeholders.
Finally the software was rengineered and refactored according to the requirements and the project was completed by supplying missing functions.
Function: Requirements Engineer, Architect, Moderator, Developer
Skills: Swing, Java2D, JFreeChart
Team Size: 18
Years: 2005 / 2006
 
Project: Requirement Engineering of Product Data Management (PDM) for the Automotive Construction Processes at a Renowned Car Manufacturer
Description: Moderated the definition of use cases and logical data models of the sub-project "networked construction" at a major automobile manufacturer using use case diagrams, activity diagrams, class diagrams and detailed use case descriptions.
Implemented an interactive GUI-prototype for illustration, refinement, and coordination of the defined processes with other partial projects.
Coordination of requirements with the expert departments.
Function: Requirements Analyst, UML-Modelling, Moderation
Skills: UML, SAP iPPE, CATIA V4/V5
Team Size: >1000
Years: 2005
 
Project: Development of a Release Management System
Description: The tool facilitates the free configuration of release processes (Programmeinsatzverfahren / PeV) as defined by the specifications of the German Sparkassenverband. The history of the release processes as well as the process definitions are stored in an audit proof manner.
A comprehensive concept for tackling authentication and authorisation issues and the dynamic association of roles and process versions allows for a fine grained, per-process definition of roles was developed.
By using an abstract hierarchical model, the workflows can easily be adapted to changing requirements.
Function: Software Developer / Software Engineer
Skills: UML, Java, J2EE, Oracle 9i, Borland Enterprise Server, Hibernate, Tomcat, Struts, Tiles, CVS
Team Size: 4
Years: 2004
 
Project: Reorganisation, Refactoring of Source Code Repositories
Description: The task was to reorganise and refactor the source code repository at a major European aeronautics and space company. The repository contains several projects with more than 1.000.000 lines of code written in Java, C++, Fortan and C.
Coached the development team with regard to issues in software engineering, refactoring, agile processes.
Introduced a wiki in order to solve knowledge management issues
Extended CVS with access control list functionality, including hierarchical inheritance of permissions.
Trained the company�s team in using both tools.
Function: Software Developer / Software Engineer
Skills: C, CVS, Wiki, agile processes
Team Size: 18
Years: 2003
 
Project: OpenCms Module
Description: Server side programming for the website of a metal industry company. Developed an OpenCms module based on JSP, including an intgration with the product database and a function for the automatedly requesting offers.
Function: Software Engineer
Skills: OpenCMS, JSP, MySQL
Team Size: 3
Years: 2004
 
Project: Web-Shop
Description: Web shop for supplying the restaurants of a prominent fast food chain with professional clothing.
Since an adaptation of standard software would have been too difficult, the shop system was newly developed in order to cater for the particular requirements with regard to user authentication, individualisation of offers, and user guidance.
Function: Consultant / Software Developer
Skills: Apache, HTML, JavaScript, Perl, CGI
Team Size: 4
Years: 2003
 
Project: Components for Automated Teller Machines
Description: Remote surveillance and remote administration of ATMs through web services. Defined and implemented a TCP/IP Server and an XML Interface.
Function: Consultant / Software Developer
Skills: C++, STL, WOSA/XFS, Wincor/Nixdorf-Protopas, J/XFS, Java
Team Size: 4
Years: 2002/2003
 
Project: Display-Components for Automated Teller Machines
Description: The Components allow for decoupling user interface and program code by utilising a simple event mechanism tailored to the purpose.
Thus, all parts of the user interface and the look-and-feel can be defined in HTML and exchanged easily without having to change any part of the program code.
Function: Consultant / Software Developer
Skills: Visual C++ 6.0 and 7.0, STL, STL, ATL, Win32
Team Size: 4
Years: 2002
 
Project: Intranet Application
Description: An intranet application for providing communication as well as information on products and stocks to the client's international agencies.
By employing chained XSLT transformations for different logical aspects an adaption to new requirements is easily possible.
Consulted the client's IT team with regard to several questions of web and database technologies.
Function: Consultant / Software Developer
Skills: PostgreSQL; XML/XSLT
Team Size: 4
Years: 2002
 
Project: Controlling Application
Description: Developed a controlling application for a public service organisation with more than 50 local subsidiaries.
Based on a framework (quite similar to Apache Cocoon), which allows for the definition of site workflow and site design using XML and XSLT, a comprehensive controlling application was developed. It comprises document management, integration with the accounting system ProFiB, comprehensive ACL-based access control, a reporting system, and a workflow management.
Function: Consultant / Software Developer
Skills: XML/XSLT, MS IIS, MS SQL-Server, Visual Basic, VB-Script
Team Size: 6
Years: 2001/2002
 
Project: Interactive Realtime Presentation Service
Description: The service provides the presentation and control of PowerPoint presentations over the internet, several online collaboration tools such as application sharing, whiteboards, and mark-up tools for the presentations, all based on JavaScript and DHTML with no plugins required.
Designed and developed large parts of the user management, the internationalisation, the management of presentations, associated phone conferences, and participants.
Project definition, design and specification in UML. International team with English as working language.
Function: Team lead, software architect, software developer
Skills: UML, Java, J2EE(Servlets, JSP), Solaris, Perl, Javascript, DHTML
Team Size: 19
Years: 1999-2001
 
Project: Development of Training Programs
Description: Developed, coordinated and held training programs on internet technologies.
In particular, developed the program "Business Academy Web", a comprehensive training instrument for professional web developers.
Function: Training, Team Lead
Skills: Java, Perl, Javascript, HTML, CGI
Team Size: 5
Years: 1999/2000
 
Project: Web-Portal for the Major German Motoring Organisation
Description: Developed substantial parts of the ADAC web site, including a round trip integration of Intershop with Imperia CMS.
Designed the conception of the data transformation from the hierarchical structure of Imperia to the relational structure of Intershop - and back.
Defined the interface between Imperia and Intershop and automated the data transfers.
Function: Software Architect, Software Developer
Skills: Intershop, Imperia, Perl, Javascript, HTML, CGI
Team Size: 8
Years: 1998/1999
 
Project: Web-Portal for a Software Company
Description: Programmed the server component for the web site, including user authentication, personalisation of content, several games, incentives and Surveys.
Function: Software Architect, Software Developer
Skills: Perl, Javascript, HTML, CGI
Team Size: 4
Years: 1997-1999
 
Project: Marketing Database for a Wholesale IT Distributor
Description: Maintenance and Extension of the marketing database using MS Access and Windows NT. Development of reports, data imports, data exports for several external systems.
Function: Software Developer
Skills: Microsoft Access, SQL, Windows NT
Team Size: 4
Years: 1997/1998
 
Project: System Control Software
Description: Developed a software for the purpose of controlling system functions of devices which measure the electromechanical properties of toners.
Function: Software Developer
Skills: Microsoft Quickbasic
Team Size: 6
Years: 1989