Build of a sales information system: The goal of this project is to build an operational contract information system. It is mainly used as an order management system - for transferring existing contracts as well as for creating and providing new contract bundles. Sales agents can order new services, modify existing ones, migrate service types, and provide price information to customers. This supports especially the marketing of new services and the replacement of old services for existing customers. In addition, master data is imported into the system, processed (ETL), and provided via services for further use in the portal frontend.
Analysis of functional and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Further development / creation of frontend components (React/JavaScript)
Design and implementation of business logic
Creation of functional and technical component documentation
Test execution / test automation (Cypress, test coverage)
Industry: Telecommunications
Team size: 8 people
Technologies: React, JavaScript, REST (JSON), YAML, Markdown, MariaDB (SQL), Docker, Swagger, Cypress
Tools: WebStorm, React Developer Tools, Visual Studio Code, Word, DBeaver, Git/GitLab
Work management: GitLab
Platform: Linux
Build management: GitLab
Build of a sales information system: To support order management, a sales information system is to be set up. Through a web UI, users can view contracts, capture orders, and pass them on to downstream systems for execution. Part of the project is ensuring data retention periods for personal data in compliance with data protection regulations.
Technical design of the business requirements for data retention periods (data security)
Creation of backend components for time-based deletion of import/master and transaction data according to the data security concept
Creation of functional and technical component documentation
Quality assurance (implementation and execution of module and system tests)
Test automation (PyTest, test coverage)
Industry: Telecommunications
Team size: 8 people
Technologies: Python, REST (JSON), YAML, Markdown, S3, MariaDB (SQL), Docker
Tools: PyCharm, Visual Studio Code, WebStorm, SoapUI, Word, DBeaver, Git/GitLab
Work management: GitLab
Platform: Linux
Build management: GitLab
Anonymization of statistical data: A government agency is required to prevent back-calculation of statistical values to original values and thus ensure their anonymization, among other things. For this, mathematical algorithms using noise factors and overlay matrices are applied. It must be ensured that the deviations of the total results due to overriding remain within a defined range. For the specialist departments/applications, appropriate REST & SOAP web services must be provided that receive these original values (up to 1 million records), process them depending on the use case, and return the overlaid values. Furthermore, the respective business logic must be tested for correctness and performance and corresponding module and system tests implemented.
Analysis of functional and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Design and implementation of service interfaces (REST & SOAP services)
Design and implementation of service objects (XML/XSD, JSON)
Design and implementation of business logic
Design and implementation of the persistence layer (data structures, XML, CSV)
Quality assurance (design and execution of module and integration tests, test coverage, CodeQS Sonar, security QS OWASP)
Test automation (JUnit, Mockito, SoapUI)
Industry: Government
Team size: 4 people (subproject team), 25 people (overall project team)
Technologies: Java EE 8/Jakarta EE 10, SOAP, REST, Groovy, CSV, XML, XSD, Swagger, OpenAPI
Tools: Eclipse, JBoss AS 7.4 & 8.0, SoapUI, Word, PowerPoint, PDF, Maven, Mockito, Sonar, Jacoco, OWASP
Work management: Jira, Confluence
Platform: Windows
Build management: Jenkins
Customs export declaration (PortaZa): The ATLAS IT process (Automated Tariff and Local Customs Clearance System) was introduced in Germany in 2006. Since July 1, 2009, participation has been mandatory EU-wide. Simply put, PortaZa serves as an interface between the ERP systems of small businesses (e.g., SelectLine or MyFactory) and customs or customs declaration. As part of product development around PortaZa, the constant evolution, component and architecture changes, and the frameworks used have highlighted the need to establish proper QA/qualified testing.
Analysis of functional and technical requirements for system testing
Creation of a test concept
Analysis of functional and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Development of a technical test specification
Development of a functional test specification
Consulting on the specification and implementation of test cases
Industry: Foreign trade
Team size: 6 people
Technologies: Java 8, JBehave, Selenium, Serenity, Hibernate
Tools: Word, PowerPoint, NetBeans, Maven, Docker
Work management: Jira, Confluence
Build management: Jenkins
Railway power unbundling: An international railway power energy company must, due to requirements of the Federal Network Agency (BNetzA), technically separate its market roles (consumer and supplier) system-wide. The new system, which is under continuous development, should cover all previously supported business cases from capture through billing and at the same time meet the new requirements and regulations of the Federal Network Agency. The newly created system landscape must undergo continuous QA for all running processes (market communication, master data storage and management, reporting, etc.). Implementation takes place in an international team.
Analysis of functional and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Documentation of functional use cases and involved processes/systems
Design of functional and technical test cases/scenarios (including load & performance tests) with a focus on system and system integration tests
Design of test specifications and test plans (including acceptance documents, QA)
Design, implementation, and automation of tests/regression tests (including logging test results in HP QC)
Recording defects in HP ALM/QC
Industry: Energy supply
Team size: 14 people (supplier stream), 60 people (overall project team)
Technologies: SOAP, Groovy, HP ALM/QC, JMS/TibcoEMS (MDB), Oracle SQL, Java 8
Tools: SoapUI, Word, PDF, Innovator, Maven, TestRunner Framework, JUnit
Work management: Jira, HP ALM/QC
Platform: Linux (SLES12), Windows
Build management: Jenkins
Usage Data Management System: An international railway power energy company has to technically separate its market roles (consumer and supplier) system-wide due to requirements from the Federal Network Agency (BNetzA). For this purpose, a new system landscape must be set up for all processes running within this scope (market communication, master data storage and management, reporting, etc.). In the area of usage data management it involves receiving and storing market role specific data (master data, usage information) as well as processing it automatically and transmitting it to downstream systems/processes. The new system should cover all previously supported business cases while meeting the new requirements and obligations of the BNetzA. Implementation is carried out in an international team.
Analysis of the technical use cases (workflows, involved processes/systems, communication channels, security requirements)
Documentation of the use cases using Innovator (UML)
Design and implementation of service objects (MDB, JMS and SOAP services)
Design and implementation of the business logic
Design and implementation of the persistence layer (data structures, JPA)
Design of gateway processes/interfaces (Tibco)
Creation of component documentation
Quality assurance (planning and execution of module, integration and acceptance tests)
Consulting for system go-live
Industry: Energy supply
Team size: 8 people (NDM team), 60 people (total project team)
Technologies: Java 7/8, JEE, SOAP, JPA/Hibernate, EJB3, Log4J, JMS/TibcoEMS (MDB)
Tools: Word, PowerPoint, Innovator, Eclipse, JBoss AS 7 (6.4.1), Tibco Designer, Maven
Task management: Jira
Testing: JUnit, SoapUI (Groovy)
Platform: Linux (SLES11/12), Windows
Build management: Jenkins
Shipping Management System: An international parcel carrier operates a shipping management system that has reached its technological and functional limits. This created the need for a fundamental system redesign. The new system should cover all previously supported business cases while meeting the new requirements. It also needs to be updated to the current technology level. Implementation is carried out in an international team.
Analysis of the business use cases (screens, customer requirements, support team requirements)
Analysis of the technical use cases (workflows, involved backend systems, communication channels, security requirements)
Documentation of the use cases using UML2
Creation of system documentation
Industry: Logistics
Team size: 12 people
Technologies: Java 7, JEE, REST, JPA/Hibernate, Log4J
Tools: Word, PowerPoint, Google Docs, Enterprise Architect, NetBeans 7, JBoss 7, BPMN
Task management: Redmine
Testing: JUnit
Platform: Linux, Windows
Voucher Management Suite: A proprietary voucher system is used for an online shop. To improve the handling of vouchers, a management suite was designed and implemented. With the help of this suite, a variety of business transactions can be supported by customer support.
Analysis of the technical use cases (workflows, involved backend systems, communication channels, security requirements)
Documentation of the use cases using UML2.
Design and implementation of service objects (Spring MVC) and design/implementation of the frontend UI (HTML5, CSS, JSP, JavaScript, jQuery)
Design and implementation of the persistence layer (data structures, JPA)
Implementation of SSO mechanisms (OpenId, OAuth1)
Execution of tests on the acceptance system (SLES11)
Creation of system documentation
Consulting for go-live
The project was executed within an iterative agile approach (SCRUM).
Industry: Telecommunications
Team size: 7 people
Technologies: Java 7, JEE, JavaScript, JSP, CSS, REST, Spring Framework, JPA/Hibernate, OAuth1, Log4J, HTML5, CSS3
Tools: Enterprise Architect, NetBeans 7, Maven, Tomcat 7, Apache Commons Configuration
Task management: Jira, Confluence
Testing: JUnit
Platform: Linux
Build management: Jenkins
Development of a gateway between a classical and an IP-based telephony system: Within the scope of IP-based voice services, access had to be provided to the built-in answering machine of the classical telephony system. This was done via a specific gateway that provides the necessary SOAP services. The project was carried out within an iterative agile approach (SCRUM).
Structural and impact analysis of the telephony system interfaces including performance measurements
Design of the process architecture of the gateway/interface
Design of the persistence layer
Design of an infrastructure to ensure high system availability
Planning and participation in the implementation work
Quality assurance (planning and execution of module, integration, and acceptance tests)
Consulting for system go-live
Industry: Telecommunications
Team size: 5 people
Technologies: UML, Java 7, JEE, Axis, XML, XSD, SOAP, shell scripting, JPA/Hibernate, OAuth1, Log4J, SCRUM
Tools: Enterprise Architect, NetBeans 7, Tomcat 6, XMLSpy, MS-SOAP-Toolkit, PuTTY, SSH, SoapUI, MS Access, Apache Commons Configuration
Task management: Jira, Confluence
Testing: JUnit
Platform: Linux
Build management: Jenkins, Maven
Development of a REST gateway for the SMS successor service Joyn (RCSe): The industry association of international mobile network operators developed the successor standard Joyn (RCSe) to replace the now less attractive SMS standard for transmitting short messages. This allows not only the transmission of texts but also files, chat, and video calls. As part of the project, the infrastructure used for this was provided with a REST interface, enabling enterprise applications to establish communication links with mobile devices. The project was carried out within an iterative agile approach (SCRUM).
Structural and impact analysis of the Joyn system to be connected, especially the relevant service calls on the RCS-e side and other peripheral software components
Specification of the essential technical use cases, including identification of the involved systems, communication paths and protocols, as well as the resulting security requirements
Evaluation of third-party providers in RCS/RCS-e components
Planning and management of the pilot phase and final implementation
Technical project leadership
Consulting and contributing to the implementation
Integration (third-party software)
Integration of the supplier backend
Execution of acceptance tests
Consulting for migration to the production system
Consulting for production system go-live
Creation of system documentation
Industry: Telecommunications
Team size: 8 people
Technologies: Java 7, JEE, Axis, XML, XSD, SOAP, shell scripting, JPA/Hibernate, OAuth1, Log4J, SCRUM
Tools: Enterprise Architect, Eclipse, Tomcat 7, XMLSpy, PuTTY, SSH, SoapUI, MS Access, MS PowerPoint, Apache Commons Configuration
Task management: Jira, Redmine
Testing: JUnit
Platform: Linux
Build management: Jenkins, Maven
Mobile webshop frontend: A renowned cloud services provider offers a multi-tenant shop infrastructure including payment processing system for medium and small companies. Besides the classic browser-based access, the shop should also be accessible via an Android app. The app is designed so that it can be easily adapted to each client's branding with minimal configuration.
Identification and documentation of the relevant use cases
GUI design
Design/definition of the software architecture for a configurable GUI layout
Implementation as a native app in Java
Planning, execution and documentation of manual system tests
Industry: Internet service provider
Team size: 3 people
Technologies: Java, web services, REST, JSON, OAuth
Tools: PENCIL, Balsamiq, Netbeans with Android plugin
Work management: Confluence, Jira
Platform: Android
Build management: Jenkins, Git
Development of a SOAP interface for an email service: Operating a mail system involves many configuration challenges. A specific interface was created to standardize and simplify the configuration processes. This interface was implemented as a SOAP service.
Analysis of the mail system's APIs and communication paths
Capturing and modeling of the relevant use cases
Design of the required state machine model
Service interface design
Service implementation
Design, planning and execution of automated regression tests
Migration of the services to the production environment
Consulting on product rollout
Preparation of system documentation
Industry: Telecommunications
Team size: 4 people
Technologies: Java 7, JEE, Axis, XML, XSD, SOAP, shell scripting, JPA/Hibernate, Log4J
Tools: Enterprise Architect, Netbeans 7, Tomcat 6, XMLSpy, MS SOAP Toolkit, PuTTY, SSH, SoapUI, MS Access, Apache Commons Configuration
Work management: Jira, Confluence
Testing: JUnit
Platform: Linux
Build management: Jenkins, Ant
Development of a system for automated GUI testing: A portal operator runs many GUI-based services that need constant monitoring for availability and stability, and are subject to continuous development. Automated regression tests are required for this. To enable this, an infrastructure was developed to automate testing of dynamic user dialogs.
Analysis of the applications to be tested
Design and implementation of a mask and template parser
Preparation of system documentation
Industry: Telecommunications
Team size: 2 people
Technologies: PHP, Perl, JavaScript, HTML5, CSS3, jQuery
Tools: Zend Studio
Work management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Development of a gateway for access to a cloud store: As part of a portal service, various cloud services are offered to users, including the ability to store different files in the cloud. Depending on the file type, the portal allows access, for example viewing/editing images and videos. To provide simplified access for mobile devices via an app, a specific gateway was developed. The project was carried out using an iterative agile process (SCRUM).
Analysis of existing backend services
Gathering requirements
Design and implementation of new software components
Execution of unit and bundle tests
Packaging (RPM) and delivery
Consulting on software distribution, deployment and quality assurance
Preparation of system documentation
Industry: Telecommunications
Team size: 12 people
Technologies: Java 6, Axis, XML, SOAP, OSGi, Spring Framework, PHP, SCRUM
Tools: Eclipse, PuTTY, SoapUI, SSH, Apache Commons Configuration
Work management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Development of a mobile frontend for a project controlling system: In project controlling, the actual efforts (actual costs) need to be recorded that are incurred to complete each task. For this, appropriate input pages are available in the intranet. Now field staff should also be able to access this via mobile devices.
Identification of the main use cases
GUI design via mockup
Design and implementation of the REST services
Implementation of the iOS app
Application testing
Software deployment
Industry: cross-industry standard product
Team size: 1 person
Technologies: Objective C, REST, JSON
Tools: XCode 4, iPhone/iPad emulator
Work management: Jira, Confluence
Platform: OSX
Created a feasibility study for providing streaming services of a media portal on modern TV sets: The streaming offers published via the web portal by the portal operator were to be made available on new TV sets with internet access. This included clarifying questions of authorization and usage billing. As part of the feasibility study, several TV devices were tested for suitability, a possible solution architecture was designed, and a prototype implementation was carried out.
Analyzed technical characteristics of sample devices (Samsung, Philips, LG)
Analyzed device APIs
Developed test applications for each device platform (native apps and web apps)
Implemented applications including access to the telecom company's authorization and billing systems
Documented performance features and shortcomings of the device platforms
Documented required workflows for potential production use
Industry: Telecommunications
Team size: 3 people
Technologies: Device SDKs, Java 6, JavaScript, REST, SOAP, Axis, XML, HTML
Tools: NetBeans, Tomcat 7, Apache Commons Configuration
Task management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Migration of telecom backend services to the OSGi platform: The client runs several backend services within an application server. By switching to an OSGi-compliant architecture, their operation, and in particular service updates, become much simpler. It allows new service versions to be deployed without restarting the application server. This is crucial for services with high availability requirements.
Analyzed existing services
Defined requirements for the migration
Technical project management
Designed and implemented new software components
Planned and executed tests on the acceptance system
Packaging and deployment
Advised on software delivery/distribution/quality assurance
Created system documentation
Industry: Telecommunications
Team size: 3 people
Technologies: Java, Axis, XML/SOAP, OSGi, Spring Framework
Tools: Enterprise Architect, Eclipse, Tomcat 6
Task management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Development of a SOAP interface for a Voice-over-IP system: Various services are provided to end customers in the Voice-over-IP system. Access to these services had to be connected to the central authorization and provisioning system. For this, it was necessary to equip the VoIP system with a SOAP interface through which rights management can be handled programmatically.
Identified and documented key use cases
Designed data transformation rules between the existing VoIP system and its API, and the new SOAP interface
Designed the state machine model for communication control
Implemented the SOAP interface/gateway
Planned, executed, and documented system and acceptance tests
Created system documentation
Migrated the gateway to the live system
Advised on go-live
Industry: Telecommunications
Team size: 5 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, NetBeans, XML-Spy, MS SOAP Toolkit, Tomcat 6, IBM WebSphere, Jetty, PuTTY, SSH, SoapUI, MS Access
Task management: Confluence, Jira
Platform: Linux
Build management: Jenkins, Ant
Redesign of an existing SOAP-based communication platform to achieve WS-I compliance: The email service provided by a portal operator can be configured via an API published as SOAP services. These services had to be modified to meet the standards of the Web Services Interoperability Organization (WS-I).
Technically analyzed service requests and their parameter structures
Redesigned services into a WS-I compliant SOAP structure
Generated technical service interfaces using SOAP toolkits
Validated, tested, and documented the new service interfaces
Implemented extended services
Industry: Telecommunications
Team size: 2 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, JBuilder, Eclipse, XML-Spy, MS SOAP Toolkit, Tomcat 6, Jetty, PuTTY, SSH, SoapUI
Task management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Development of a platform to connect digital photo frames to an image archive: The operator of a web portal offers its users the ability to store multimedia content, including images, in its cloud and share it with friends and family. So far this was possible using PCs and mobile devices (smartphones, tablets). Based on the platform developed here, images could also be displayed on digital photo frames.
Analyzed existing interfaces to the image archive
Designed data transformation rules between the existing interfaces and the new SOAP services
Designed and implemented an RSS photo feed server and its configuration front-end
Technical project management
Advised the operator on installation and configuration of infrastructure components
Delivered software to test and production systems
Advised on go-live
Created system documentation
Industry: Telecommunications
Team size: 3 people
Technologies: Java, Axis, XML/SOAP, JSON, RSS, Media RSS, ATOM
Tools: Enterprise Architect, Eclipse, XML-Spy, MS SOAP Toolkit, Struts 2, Tomcat, Jetty, PuTTY, SSH, SoapUI
Task management: Confluence, Jira
Platform: Linux
Build management: Jenkins, Ant
Migration of a reporting system (DWH): The operator of a large web portal collects statistical usage information in a DWH about the portal's services. Infrastructure changes required migrating the DWH and its data supply processes from Debian Linux and Oracle to AIX and DB2.
As-Is analysis of the existing system (Debian & Oracle)
Design and implementation of data transformations for the target system (AIX & DB2)
Support for installing components for web service operations
Deployment of software on the test system
Packaging for the production system
Design of the ETL for the initial loading of the staging area
Implementation of an application to control external processes and compress data for import packages
Conducting tests
Preparation of test and acceptance reports
Creation of reports
Migration to the test and production systems
Consulting during production rollout
Creating system documentation
Training DWH users
Industry: Telecommunications
Team size: 8 people
Technologies: Java, Axis, XML/SOAP, JSON
Tools: Enterprise Architect, NetBeans, XMLSpy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI, MS Access, DB2, Oracle, Informatica
Task tracking: Confluence, Jira
Platform: Linux, AIX
Build management: Hudson, Ant
Provision of a generic SOAP interface for a social network platform: The operator of a large web portal integrates social media services into its offering. As part of this, users can store personal profile data and share it with friends if they choose. Users may have stored similar profile information on other established Web 2.0 platforms. This interface allows users to exchange information between different platforms.
Analysis of existing social network services (Flickr, Facebook, YouTube, etc.) and their architecture (WSDL, REST)
Development of a concept for a simplified modular gateway interface to these services (SOAP web service)
Design of the data structures needed for interface configuration
Presentation and alignment of the solution with business and technical teams
Participation in implementation
Industry: Telecommunications
Team size: 6 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, Eclipse, XMLSpy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI
Task tracking: Jira, Confluence
Platform: Linux
Build management: Hudson, Ant
Migration of existing communication service components to a service-oriented architecture (SOA) and an enterprise service bus (ESB): The operator of a large web portal offers users a variety of message-based communication services. The underlying systems have grown historically and have shortcomings that make further development and component replacement as well as connecting external services difficult. The entire infrastructure needed redesigning based on SOA and ESB concepts.
Technical analysis of existing services and identification of weaknesses
Validation and testing of existing service interfaces and their documentation
Redesign of services into a SOAP structure following the Web Services Interoperability Organization (WS-I) guidelines
Leading workshops to develop the new service structure
Industry: Telecommunications
Team size: 6 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, Eclipse, XMLSpy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI
Task tracking: Jira, Confluence
Platform: Linux
Build management: Hudson, Ant
Development of a platform for carrying out load tests on a streaming system
Extending the existing web application with a rights and user management module
Updating documentation and making changes to the data model
Conducting acceptance tests
User training
Consulting on setting up configurations and conducting load tests
Consulting during production rollout
Industry: Telecommunications
Team size: 2 people
Technologies: PHP, HTML, CSS
Tools: Zend Studio, MySQL, Apache, PuTTY, SSH, WinSCP
Task tracking: Confluence, Jira
Platform: Linux
Development of a central web service platform as the main access point to a portal operator's services
Implementing the central service platform as a SOAP web service
Designing and implementing the rights concept and management
Designing and implementing access to distributed backend systems considering various communication protocols
Designing and implementing data mapping and consolidation for the target systems
Conducting tests on the acceptance system
Migration to the production system
Support during production rollout
Documentation
Industry: Telecommunications
Team size: 2 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, JBuilder, XMLSpy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI, MS Access
Task tracking: Confluence, Jira
Platform: Linux
Build management: Hudson, Ant
Development of a system for carrying out real-time analyses on the technical systems of a portal operator
Integration of a multi-subscriber database
Design and implementation of the data transformation rules for the target processing system
Consolidation and ETL of incoming data (preprocessing)
Performance optimization at source code and DB level for just-in-time data processing/delivery
Conducting tests on the acceptance system
Creating the system documentation
Migration to the production system
Consulting for production system rollout
Industry: Telecommunications
Team size: 2 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MySQL, Apache, Putty, SSH, MS SOAP Toolkit, Tomcat, MS Access, DB2, Oracle
Work management: Confluence, Jira
Platform: Linux
Development of web services for a VoIP system: As part of providing an integrated answering machine, it was necessary to connect additional existing backend systems to the VoIP system. This was done by providing a specific gateway.
Integration of a multi-subscriber database
Design and implementation of data mapping for the target processing system
Design of the relevant use cases (record dependencies)
Design of a "reaction matrix" as an automaton
Conducting acceptance tests
Creating the system documentation
Migration to the production system
Consulting for production system go-live
Industry: Telecommunications
Team size: 8 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MySQL, Apache, Putty, SSH, MS SOAP Toolkit, Tomcat, MS Access
Work management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Creation of a reporting system: For a standard ERP system, only limited business reports were available. Since the ERP system relied on an MS SQL database for data storage, it made sense to use the BI services of this database to provide advanced reports.
Analysis of company data in the ERP system
Design and provision of data views for reporting
Design and provision of the cube model
Design and provision of reports, including purchasing, sales, executive overview, revenue planning
Extension and customization of existing reports
Development of a migration concept for report templates
Creation of the system documentation
User training
Industry: Food industry
Team size: 2 people
Tools: MS SQL Server, MS Reporting Server, MS Analysis Server, MS Visual Studio, myFactory (ERP system), MS Internet Information Server
Work management: Confluence, Jira
Platform: MS Windows Server
Development of web services for a VoIP system: As part of providing an integrated answering machine, it was necessary to connect the existing backend systems to the VoIP system. This was done by providing a specific gateway.
Analysis of incoming data
Identification of relevant use cases
Design and implementation of data transformations for the target system
Design of a "reaction matrix" as an automaton
Conducting acceptance tests
Creating the system documentation
Migration to the production system
Consulting for production system go-live
Industry: Telecommunications
Team size: 6 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MySQL, Apache, Putty, SSH, MS SOAP Toolkit, Tomcat, MS Access
Work management: Confluence, Jira
Platform: Linux
Redesign of a support controlling system: The IT subsidiary of an international car manufacturer provides the parent company with support services for operating the IT infrastructure. Here, service quality and incurred costs must be controlled. Until now, this was done using various Lotus Notes components. With this project, information is provided using standardized business intelligence methods and tools.
Analysis of the existing legacy system
Design and implementation of the data model for the central OLAP data storage system
Design of data marts
Design of data provisioning jobs (ETL)
Design of reports
Conducting tests on the acceptance system
Migration to the production system
Industry: Automotive
Team size: 2 people
Technologies: Data Warehousing, Business Intelligence, ETL
Tools: PowerDesigner, Cognos DecisionStream (ETL), Cognos Impromptu (Reporting), Cognos PowerPlay (Reporting), DB2, Toad for DB2, DB2 admin tools
Work management: Confluence, Jira
Platform: AIX, Windows
Development of a personnel planning system: Within a telecommunications company, various tasks are needed to maintain and expand the infrastructure. Service teams are used for this, and their work needs to be planned accordingly. As part of the project, the planning and controlling tools required were provided based on the Cognos suite.
Analysis of existing operational data
Design and implementation of the data model for the central OLAP data storage system
Cube model design
Design of data extraction processes
Migration of models between different system environments
Development and planning of automation (including fail-safe scenario) for cube creation
Load testing
Design of audit reports (Report Net)
Customer support for consulting and model adjustments
Documentation of the OLAP datastore and the analysis cube models
Bug reporting
Conducting user training
Industry: Telecommunications
Team size: 10 people
Technologies: Data Warehousing, Business Intelligence, ETL
Tools: Cognos Transformer, Cognos Contributor, Cognos Analyst, Cognos Connection, Cognos Report Studio, Cognos Server Admin Tools, PowerDesigner, Toad, Oracle 10.1
Work management: ClearCase
Platform: Windows
Development of a balance-based rating system: An international car manufacturer handles its sales primarily through a network of partner dealers. Dealers in this network are to be evaluated objectively in terms of their financial situation and the associated opportunities and risks. For this, comparison perspectives between each dealer and dealer reference groups are created based on balance sheet data and intra-year metrics.
Analysis of manually created reports regarding document structure and variable data parts within the reports
Design of GUI templates
Design of report templates
Implementation of a report generation engine
Development of a converter from HTML reports to PDF reports
Setting up a test system
Writing the system documentation
Conducting load tests
Industry: Automotive
Team size: 7 people
Technologies: Data Warehousing, Business Intelligence, ETL, OLE Automation, COM, HTML, XHTML, Java, Delphi, VBA
Tools: PowerDesigner, Cognos DecisionStream, Toad, DB2, Delphi, Eclipse, IntelliJ, FreeMarker, Adobe Acrobat, CZDoc2PDF, MS Visual Studio
Work management: Confluence, Jira
Platform: AIX, Windows
Development of test scenarios for a customer database: For the delivery of telecommunications services, access to the central customer database is required. It publishes its information via web services. The database itself is under constant development. To ensure system stability, it must undergo automated regression testing in this context. In this project, both the tests for the current database development state and a test tool that allows automated tests were developed.
Analysis of existing access functions to the customer database
Identification of "typical" use cases for interacting with the customer database according to the developer concept
Development of test scripts for a generic simulator based on the identified use cases
Execution and logging of the tests (pass/fail scenarios)
Bug reporting
Industry: Telecommunications
Team size: 2 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MS SOAP Toolkit, Apache, PuTTY, SSH, Tomcat
Work management: Confluence, Jira
Platform: Linux
Support for a paid content platform: The client quickly developed many new internet-based information and communication services, integrated them into the portal, and launched them on the market. These services are based on a unified technical infrastructure. The technical aspects affect the functional structure of the services and must be considered during their implementation. In this project, consulting services were provided to connect new services to the mentioned infrastructure.
Development of internal system data management tools
Creation and management of system configurations
Analysis and restructuring of existing functionality
Test management for the implementation of new functions within the platform components
Writing system documentation
Technical support for external partners in connecting new services to the platform
Industry: Telecommunications
Team size: 10 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, XMLSpy, MS SOAP Toolkit, Apache, PuTTY, SSH, Tomcat, MS Project, MS Access
Work management: MS Project
Platform: Linux
Extension of a CRM/HR system
Design of GUI templates (HTML)
Script development to extend the GUI templates
Analysis and restructuring of existing functionality
Implementation of new functions
Writing the user manual
Industry: IT services
Team size: 4 people
Technologies: Java
Tools: PowerDesigner, Eclipse, MS SQL Server
Work management: Confluence, Jira
Platform: Windows
Creation of a web presence based on a content management system
Analysis of components to be published (content & design)
Design and implementation of HTML templates
CMS administration
Script development for dynamic content (sitemap, ...)
Industry: IT services
Team size: 1 person
Technologies: HTML, CSS, JavaScript, VBScript
Tools: Microsoft CMS, SQL Server
Project management: Confluence, Jira
Platform: Windows
Redesign of the transaction module for a mobile payment system: The backend of a mobile payment system processes the requested transactions. Correct handling of the payment reference was an open challenge that the project aimed to solve. In this phase, the requirements definition was created.
Analysis and documentation of the existing system architecture
Specification/documentation of the (new) target architecture with extended functionality and improved performance
Industry: Finance
Team size: 1 person
Technologies: PL/SQL
Tools: Oracle 8i, Toad
Platform: Unix
Development of a fund management system: The processing of fund transactions was complex and prone to errors in its current form. The causes were both organizational and technical. The settlement process spanned multiple departments and technical systems. The same information existed multiple times in different systems and had to be entered several times to bridge system boundaries. This resulted in disproportionate costs, long processing times, and a high error rate. As part of the project, the business process was redesigned (organizational process optimization). The number of involved systems was reduced and communication between systems was automated. A web-based online capture of fund orders was provided and interfaces to the adjacent issuance applications were developed.
Business process analysis
Analysis and documentation of the existing system architecture
Design and implementation of a new data storage system
Design and implementation of the web-based front end
Drafting test scenarios and conducting integration tests
User training
Industry: Finance
Team size: 10 people
Technologies: Java, PL/SQL, HTML, CSS, UML, JSP, JavaScript
Tools: PowerDesigner, Enterprise Architect, Oracle 8i, Toad, JBuilder, JUnit
Project management: Confluence, Jira
Platform: Unix
Development of a universal and flexible tariffing system
Leading an international group of developers
Education and coaching in Java, OO, and relational databases
Design, implementation, and testing of the application framework in Java
Design and implementation of the data storage system
User training
Industry: Finance
Team size: 10 people
Technologies: Java, PL/SQL, HTML, CSS, UML, JSP, JavaScript, XML
Tools: PowerDesigner, Enterprise Architect, Oracle 8i, Toad, VisualAge for Java, JBuilder, JUnit, Tomcat, MS Project
Project management: Confluence, Jira
Platform: Unix
I have solid skills in development and testing and have worked on projects ranging from building contract and order management systems to ensuring data security and compliance in telecommunications and government environments. I design and implement software components with a focus on usability and reliability, analyze use cases step by step, and deliver high-quality results with automated tests.
By successfully leading numerous projects in areas like telecommunications, automotive, energy, and banking, I make it possible to realize complex web-based platforms, data migrations, and demanding consulting tasks. My technical know-how covers a wide range of modern technologies, including Java, Axis, XML/SOAP, Jenkins, and Tomcat, which I use professionally on Linux and Windows platforms.
Discover other experts with similar qualifications and experience
2025 © FRATCH.IO GmbH. All rights reserved.