IT Service Management / Configuration Management Consulting

The Gothaer Insurance needs support in meeting the DORA requirements.

• Creation of functional and technical concepts as well as interface descriptions for DORA-specific adjustments.
• Support in aligning document content with stakeholders and employees.
• Development of requirement profiles.
• Analysis of existing processes and interfaces and integration into the DORA context.
• Collection of application services through interviews with application owners.
• Documentation of process adjustments and further development of existing documentation.
• Provider management.
• Preparation of DORA requirements for the project steering committee for decision-making.
• Communication interface and coordination between business units and IT.
• Requirements engineering / requirements analysis (IREB).
• Stakeholder management.
• Project management consulting.
• Configuration management (CMDB).
• Automation of data collection.
• Reduction of manual tasks by focusing on key information and its automated retrieval.
• Support / preparation of governance and compliance (business impact analyses, ISMS, etc.).
• Design and analysis of data flows to and from ServiceNow.
• DORA, ServiceNow, process documentation, compliance, project management, requirements engineering (IREB), functional and technical design, ITSM, CMDB, governance, risk management, ISMS.

Support in environment management. The Viridium Group needs support in environment management to provide their (test) environments on time, technically and organizationally as planned.

The goal of this project is:

• Analysis of existing processes.
• Comprehensive familiarization with VG environment management.
• Support in the coordination and takeover of necessary activities in environment management.
• Conducting an inventory and identifying optimization potentials.
• Documentation and alignment of environment management processes.
• Support in the setup, modification, and teardown of environments for various releases – coordination with stakeholders and management of activities.
• Project management – scheduling, budget control, stakeholder/provider management, point of contact for department leadership.
• Support in meeting governance and compliance goals and requirements.
• Communication interface and coordination between business units and IT.
• Requirements engineering / requirements analysis (IREB).
• Stakeholder management.
• Configuration management consulting (CMDB).
• Automation of data collection.
• Reduction of manual tasks by focusing on key information and its automated retrieval.
• Support in governance and compliance (MaRisk, VAIT, business impact analyses, DORA, etc.).
• Process documentation, project management, requirements engineering (IREB), functional and technical design, Jira, governance, risk management, compliance.

• Project leadership for the setup and redesign of IT asset management / CMDB.
• Support in building service trees (e.g., for BIA).
• Preparation and planning of the migration of data from 42 network units to the head office's central CMDB (ServiceNow).
• Creation of a service tree blueprint for the network units and the head office.
• Creation of how-to documents for the business service catalog and technical service catalog.
• Design, conception, and consulting in configuration management (CMDB).
• Automation of data collection.
• Reduction of manual tasks by focusing on key information and its automated retrieval.
• Communication interface between business units and IT.
• Master data organization and management.
• Creation of requirements documents.
• Requirements engineering / requirements analysis (IREB).
• ServiceNow, ADOIT, governance and compliance, business impact analysis, IT asset management.

• Project support for the redesign of the CMDB.
• Support in building service trees.
• Design and consulting in configuration management (CMDB).
• Automation of data collection.
• Reduction of manual tasks by focusing on key information and its automated retrieval.
• Communication interface between the business unit and IT.
• Creation of requirements documents.
• Requirements engineering / requirements analysis (IREB).
• Creation of enrichments in UCMDB to improve data documentation.
• HPSM (HP Service Manager), HP UCMDB, MS Word, ADOIT, CMDB, ITSM, governance and compliance.

• Consulting and planning for CMDB.
• Consulting and planning for IT Asset Management.
• Support in setting up CMDB reporting, designing (management/KPI) reports, designing data transfers.
• Act as communication interface between business unit and IT.
• Support for governance and compliance (MaRisk, BAIT, business impact analyses, etc.).
• Designing and creating interface contracts related to the CMDB.
• Designing ETL processes.
• Further development of the data hub for processing various incoming data into downstream systems.
• Master data organization and management.
• Creation of operational documentation.
• Reviewing the structure of ITIL processes and optimizing them if needed.
• FNT Command, HP Service Manager, HP ucmdb, ETL, interface design, reporting, Oracle DB, functional and technical design, project management, ITSM, CMDB, governance and compliance, business impact analysis, IT asset management.

• Creation of an operations manual for the CMDB (FNT Command).
• Defining and documenting various ITIL processes according to the Daimler "Journey to Excellence (J2E)" standard to cover incident, change, and problem management.
• Supporting, deploying, and monitoring an "Import Server" based on an early version of FNT's Command Staging Area for importing server data (physical and virtual) into the CMDB, resolving functional and technical inconsistencies. The underlying database was MongoDB, and the CMDB runs on Oracle 11gR2.
• Designing CMDB reporting (based on FNT Command) to improve data availability and ensure data quality.
• Analyzing requirements for the reporting tool through discussions with key users.
• Evaluating existing BI/reporting tools at Daimler.
• Selecting the "best" tool based on gathered requirements and conditions.
• Analyzing existing and needed reports based on key user input.
• Building the PoC with FNT's Staging Area Extended.
• Master data organization and management.
• ETL development.
• Quality assurance.
• Checking possibilities and feasibility of the concept.
• ITIL, Journey to Excellence, FNT Command, ITSM, CMDB, Oracle 11gR2, MongoDB, ETL, SQL, Reporting/BI Tools.

• Technical project lead – scheduling, budget control, stakeholder/provider management, main contact for business unit management.
• CMDB consulting and planning.
• Asset management consulting.
• Consulting on integrating the CMDB into ITIL change and incident management processes.
• Designing and creating interface contracts related to the CMDB.
• Designing ETL processes.
• Developing ETL processes (including a mapplet for all essential data transformations to the incident management system).
• Master data organization and management.
• Test management and execution.
• Creating operational documentation.
• Supporting go-lives.
• ETL development with Informatica PowerCenter, FNT Command, BMC Suite, SQL/PLSQL, ITSM, CMDB, asset management.

• Developing PL/SQL and SQL scripts for data capture and processing.
• Ensuring data quality in the CMDB (FNT Command).
• Developing reports using Oracle Application Express 4.0.2.
• Oracle RDBMS, PL/SQL, SQL, Oracle scripting, data warehousing, performance tuning, Oracle Application Express, FNT Command, ITSM, CMDB.

• Internal training and development sessions on various topics (NoSQL databases, Oracle APEX, etc.)

Background: Allianz Managed Operations SE (AMOS) is a shared service organization that, among other things, also provides IT for Allianz organizational units and branches.

Context: As part of a large-scale migration project, a subproject was initiated to create a database inventory for capturing IBM UDB/DB2 and Oracle databases.

Task: Defining and implementing a role and group concept for permission assignment and developing a user interface to manage these permissions.

• PL/SQL, Oracle Application Express.

Background: Siemens Mobility is a world-leading provider of transportation technology. It supplies solutions for rail transportation, the aviation industry, and road traffic. These solutions are implemented over several years in projects. A project platform, the so-called project portal, is available for these projects.

Context: Over the years, a tool called the Adminwizard was developed for effective project and user management of system users in the project portal. It manages projects, project roles, system roles, and systems and administers them across systems. Endlich OHG has been continuously developing this tool since 2004.

• Further development / maintenance of the Adminwizard tool at Siemens Mobility IT.
• Development in Oracle Application Express.
• PL/SQL, SQL development, implementation of ETL load procedures for the analysis schema.
• Oracle APEX, SQL / PL/SQL, Oracle RDBMS.