Stephan H.
Developer, Tester
Experience
Development, Tester
Building a sales information system: The goal of this project was to set up an operational contract information system. It is mainly used as an order management system to transfer existing contracts and to create and provide new contract bundles. Sales agents can order new services, modify existing ones, migrate service types, and provide price information to customers. This supports marketing new service offerings and replacing old services for existing customers. In addition, master data is imported, processed (ETL), and provided via services for further use in the portal front end.
Analyzing business and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Enhancing/creating frontend components (React/JavaScript)
Designing and implementing business logic
Creating business and technical component documentation
Executing tests / 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
Task management: GitLab
Platform: Linux
Build management: GitLab
Development, Data Security/Security, Tester, Test Automation
Building a sales information system: To support order management, a sales information system was established. Through a web UI, users can view contracts, record orders, and forward them to downstream systems for execution. Part of the project was ensuring data retention periods that comply with data protection rules for personal information.
Technical design of business data retention periods (data security)
Developing backend components for time-based deletion of imported, master, and transaction data according to the data security concept
Creating business and technical component documentation
Quality assurance (implementing and performing 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
Task management: GitLab
Platform: Linux
Build management: GitLab
Development, Tester, Test Automation
Anonymizing statistical data: A government agency is required to prevent the back-calculation of statistical values to original values and thus ensure their anonymization. Mathematical algorithms using noise factors and overlay matrices are applied for this purpose. It must be ensured that the deviations reported in the final results stay within a defined range due to the applied adjustments. For the specialist departments/applications, appropriate REST & SOAP web services must be provided to receive these original values (up to 1 million records), process them as needed, and return the modified values. In addition, the business logic must be tested for correctness and performance, and corresponding module and system tests must be implemented.
Analyzing business and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Designing and implementing service interfaces (REST & SOAP services)
Designing and implementing service objects (XML/XSD, JSON)
Designing and implementing business logic
Designing and implementing the persistence layer (data structures, XML, CSV)
Quality assurance (designing and performing module and integration tests, test coverage, code quality (Sonar), security quality (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
Task management: Jira, Confluence
Platform: Windows
Build management: Jenkins
Test Manager
Customs export declaration (PortaZa): The ATLAS IT procedure (Automated Tariff and Local Customs Clearance System) was introduced in Germany in 2006. Since July 1, 2009, participation has been mandatory across the EU. In simplified terms, PortaZa serves as an interface between ERP systems of small businesses (e.g., SelectLine or MyFactory) and customs/customs declaration. In the course of product development around PortaZa, ongoing improvements, component and architecture changes, and used frameworks highlighted the need to establish proper QA / qualified testing.
Analyzing business and technical requirements for system testing
Creating a test concept
Analyzing business and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Developing a technical test specification
Developing a business test specification
Advising on the specification and execution of test cases
Industry: Foreign trade
Team size: 6 people
Technologies: Java 8, JBehave, Selenium, Serenity, Hibernate
Tools: Word, PowerPoint, NetBeans, Maven, Docker
Task management: Jira, Confluence
Build management: Jenkins
SIT Coordinator, Business Analyst, Test Automation, Tester
Unbundling traction current: An international traction current energy company must technically separate its market roles (user and supplier) system-wide due to BNetzA regulations. The new system, which is under continuous development, should cover all business cases supported so far from data entry to billing, while meeting the new requirements and regulations of BNetzA. The newly created system landscape must undergo continuous QA for all running processes (market communication, master data storage and management, reporting, etc.). Implementation is done in an international team.
Analyzing business and technical use cases (workflows, involved processes/systems, communication paths, security requirements)
Documenting business use cases and involved processes/systems
Designing business and technical test cases/scenarios (including load & performance tests) with a focus on system and system integration tests
Creating test specifications and test plans (including acceptance documents, QA)
Designing, implementing, and automating 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
Task management: Jira, HP ALM/QC
Platform: Linux (SLES12), Windows
Build management: Jenkins
System Designer, Developer, Tester
Usage Data Management System: An internationally active railway power energy company must, due to BNetzA regulations, technically separate its market roles (user and supplier) across the entire system. For this purpose, a new system landscape must be set up for all processes within this scope (market communication, master data storage and management, reporting, etc.). The usage data management area involves receiving and storing role-specific data (master data, usage information) as well as their automated processing and the transmission to downstream systems / processes. The new system should cover all previously supported business cases and at the same time meet the new requirements and regulations of the BNetzA. The implementation takes place 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 the gateway processes/interfaces (Tibco)
Creation of the component documentation
Quality assurance (planning and execution of module, integration and acceptance tests)
Consulting for the system go-live
Industry: Energy supply
Team size: 8 people (NDM team), 60 people (entire 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
Work management: Jira
Testing: JUnit, SoapUI (Groovy)
Platform: Linux (SLES11/12), Windows
Build management: Jenkins
Business Analyst, System Designer, Consultant
Shipping Management System: An internationally active parcel carrier operates a shipping management system that has reached its technological and functional limits. This has led to the desire for a fundamental system redesign. The new system should cover all previously supported business cases and also meet the new requirements. In addition, it has to be brought up to the current technology level. The implementation takes place in an international team.
Analysis of the business use cases (screens, customer requests, 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 the 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
Work management: Redmine
Testing: JUnit
Platform: Linux, Windows
Business Analyst, System Designer, Consultant and Developer
Voucher Management Suite: A proprietary coupon system is used for an online shop. To better manage the vouchers, a management suite was designed and implemented. With this suite, the customer support can handle a wide range of business cases.
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 the 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 the SSO mechanisms (OpenID, OAuth1)
Execution of tests on the acceptance system (SLES11)
Creation of the system documentation
Consulting for the go-live
The project was carried out as part of 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
Work management: Jira, Confluence
Testing: JUnit
Platform: Linux
Build management: Jenkins
Business/Technical Analyst, System Designer, Consultant and Developer
Development of a gateway between a classic and an IP-based telephony system: As part of the IP-based voice services, the goal was to access the integrated answering machine of the classic telephony system. This was done via a specific gateway that provides the required SOAP services. The project was carried out as part of 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 the 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
Work management: Jira, Confluence
Testing: JUnit
Platform: Linux
Build management: Jenkins, Maven
Business/Technical Analyst, System Designer, Consultant and Developer
Development of a REST gateway for the SMS successor service Joyn (RCS-e): The industry association of international mobile network operators developed the successor standard Joyn (RCS-e) for the previously no longer attractive SMS standard for sending short messages. This standard not only allows text transmission but also file transfer, chat, and video telephony. As part of the project, the deployed infrastructure was equipped with a REST interface, allowing enterprise applications to establish communication links with mobile devices. The project was carried out as part of an iterative agile approach (SCRUM).
Structural and impact analysis of the Joyn system to be integrated, especially the relevant service calls from RCS-e and other peripheral software components
Specification of the main technical use cases, including identification of the involved systems, communication channels 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 participation in the implementation
Integration (third-party software)
Connection of the supplier backend
Execution of acceptance tests
Consulting for the migration to the live system
Consulting for the go-live of the live system
Creation of the 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
Work management: Jira, Redmin
Testing: JUnit
Platform: Linux
Build management: Jenkins, Maven
Business Analyst, System Designer, Implementer, Senior Test Manager
Mobile webshop front end: A renowned cloud services provider offers a multitenant shop infrastructure including a payment processing system for medium-sized and small businesses. In addition to the 'classic' browser-based access, shop access should also be possible via an Android app. The app is structured so that it can be adapted to the branding of each tenant with little configuration effort.
Identifying and documenting the relevant use cases
GUI design
Designing/defining the software architecture for a configurable GUI layout
Implementation as a native app in Java
Planning, executing, and documenting manual system tests
Industry: Internet service provider
Team size: 3 people
Technologies: Java, web service, REST, JSON, OAuth
Tools: PENCIL, Balsamiq, Netbeans with Android plugin
Work management: Confluence, Jira
Platform: Android
Build management: Jenkins, Git
Business/Technical Analyst, System Designer, Consulting and Development
Development of a SOAP interface for an email service: Running a mail system involves many configuration challenges. A specific interface was created to standardize and simplify these configuration processes. The interface was implemented as a SOAP service.
Analyzing the mail system APIs and communication paths
Capturing and modeling the relevant use cases
Designing the required state machine model
Service interface design
Service implementation
Designing, planning, and executing automated regression tests
Migrating the services to the production environment
Consulting on product rollout
Creating 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
Business/Technical Analyst, System Designer, Consulting and Development
Development of a system for automated GUI tests: A portal operator runs many GUI-based services whose availability and stability need to be monitored and which are under constant development. Automated regression tests are required for this purpose. An infrastructure was developed to enable automated testing of dynamic user dialogs.
Analyzing the applications to be tested
Designing and implementing a screen and template parser
Creating 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
System Designer, Consulting and Development
Development of a gateway for accessing a cloud store: Within a portal service, various cloud services are provided to users, including the ability to store different files in the cloud. Depending on the file type, access is provided through the portal, such as viewing and editing images and videos. To simplify access from mobile devices via an app, a specific gateway was developed. The project was carried out using an iterative agile methodology (SCRUM).
Analyzing existing backend services
Gathering requirements
Designing and implementing new software components
Conducting unit and bundle tests
Packaging (RPM) and delivery
Consulting on software delivery, distribution, and quality assurance
Creating 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
System Designer, Development
Development of a mobile front end for a project controlling system: As part of project controlling, the actual effort spent on individual tasks needs to be recorded. Dedicated entry pages are available on the intranet for this purpose. Field staff should also be able to use mobile devices for this.
Identifying key use cases
GUI design with mockups
Designing and implementing REST services
Implementing the iOS app
Application testing
Software distribution
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
Business/Technical Analyst, System Designer, Consultant
Feasibility study for providing streaming services of a media portal on modern TVs: The streaming offers published via the web portal by the portal operator were to be made available on new internet-enabled TVs. This involved clarifying authorization and billing issues. As part of the feasibility study, several TV devices were tested for suitability, a solution architecture was designed, and a prototype was implemented.
Analyzed technical features 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 telco’s authorization and billing systems
Documented performance features and limitations of the device platforms
Documented the 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
Technical Analyst, System Designer, Consultant, Developer
Migration of telco backend services to the OSGi platform: The client operates several backend services within an application server. By migrating to an OSGi-compliant architecture, their operation and especially service updates are significantly simplified. This makes it possible to bring new service versions online without having to restart the application server. This is crucial for services with high availability requirements.
Analyzed existing services
Defined requirements for migration
Technical project management
Designed and implemented new software components
Planned and conducted tests on the acceptance system
Packaged and delivered
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
Technical Analyst, System Designer, Consultant, Developer
Development of a SOAP interface for a voice-over-IP system: The VoIP system provides various services for end customers. Access to these services had to be connected to the central authorization and provisioning system. For this purpose, the VoIP system needed to be equipped with a corresponding SOAP interface, through which rights management can be performed programmatically.
Identified and documented key use cases (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 production 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
Technical Analyst, System Designer, Consultant, Developer
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 a SOAP-published API. The services provided here had to be modified so that they comply with the standards of the Web Services Interoperability Organization (WS-I).
Technical analysis of 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
Technical Analyst, System Designer, Consultant, Developer
Development of a platform to connect digital photo frames to an image archive: The operator of a web portal offers users the ability to store multimedia content, including images, in its cloud and share them with friends and acquaintances. Until now, 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 the associated configuration front end
Technical project management
Advised the operator on installation and configuration of infrastructure components
Deployed software to the 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
Technical Analyst, System Designer, Consulting, Development
Migration of a reporting system (DWH): On behalf of the operator of a large web portal, statistical usage data about the services offered in the portal are collected in a DWH. Infrastructural changes made it necessary to migrate 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 processing system (AIX & DB2)
Support with the installation of components for web service operation
Deployment of the software to 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 to compress data for the import packages
Execution of tests
Preparation of test/acceptance protocols
Creation of reports
Migration to the test and production systems
Consulting during production system rollout
Creation of system documentation
Training of DWH users
Industry: Telecommunications
Team size: 8 people
Technologies: Java, Axis, XML/SOAP, JSON
Tools: Enterprise Architect, Netbeans, XML Spy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI, MS Access, DB2, Oracle, Informatica
Task management: Confluence, Jira
Platform: Linux, AIX
Build management: Hudson, Ant
Technical Analyst, System Designer, Consulting and Implementation
Provision of a generic SOAP interface on a social network platform: The operator of a large web portal integrates social media services into its offering. As part of this offering, users have the option to store personal profile data and share it with friends upon request. Users may have stored similar profile information on alternative, established Web 2.0 platforms. The mentioned interface allows users to exchange information between the different platforms.
Analysis of the various existing social network services (Flickr, Facebook, YouTube …) and their architectures (WSDL, REST)
Development of a concept for a simplified modular gateway interface to these services (SOAP web service)
Design of the data structures required for interface configuration
Presentation and alignment of the solution with the business units and technical teams
Participation in implementation
Industry: Telecommunications
Team size: 6 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, Eclipse, XML Spy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI
Task management: Jira, Confluence
Platform: Linux
Build management: Hudson, Ant
Technical Analyst, System Designer, Consulting and Implementation
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 provides its users with a variety of message-based communication services. The underlying systems grew organically over time and have shortcomings that make it difficult to further develop and replace components, as well as to connect external services. Therefore, the entire infrastructure needed a redesign based on service-oriented architecture concepts and the enterprise service bus.
Technical analysis of existing services and identification of weaknesses
Validation and testing of existing service interfaces and their documentation
Redesign of the services into a SOAP structure that follows the guidelines of the Web Services Interoperability Organization (WS-I)
Leading workshops to develop the new service structure
Industry: Telecommunications
Team size: 6 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, Eclipse, XML Spy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI
Task management: Jira, Confluence
Platform: Linux
Build management: Hudson, Ant
System Designer, Consulting and Implementation
Development of a platform for load testing a streaming system
Extension of the existing web application with rights and user management
Revision of documentation and changes to the data model
Execution of 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 management: Confluence, Jira
Platform: Linux
System Designer, Consulting and Implementation
Development of a central web service platform as a central access point to a portal operator’s services
Implementation of the central service platform as a SOAP web service
Design and implementation of the rights concept and management
Design and implementation of access to distributed backend systems considering various communication protocols
Design and implementation of data mapping and consolidation for the target systems
Execution of tests on the acceptance system
Migration to production
Support during production rollout
Documentation
Industry: Telecommunications
Team size: 2 people
Technologies: Java, Axis, XML/SOAP
Tools: Enterprise Architect, JBuilder, XML Spy, MS SOAP Toolkit, Tomcat, Jetty, PuTTY, SSH, SoapUI, MS Access
Task management: Confluence, Jira
Platform: Linux
Build management: Hudson, Ant
System-Designer, Consulting and Implementation
Development of a system to perform real-time analysis on a portal operator's technical systems
Integration of a multi-tenant database
Design and implementation of data transformation rules for the target 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 system documentation
Migration to the production system
Consulting for production system go-live
Sector: Telecommunications
Team size: 2 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MySQL, Apache, Putty, SSH, MS-SOAP-Toolkit, Tomcat, MS-Access, DB2, Oracle
Project management: Confluence, Jira
Platform: Linux
Technical-Analyst, System-Designer, Consulting and Implementation
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-tenant database
Design and implementation of data mapping for the target system
Design of the relevant use cases (record dependencies)
Design of a "reaction matrix" as a state machine
Conducting acceptance tests
Creating system documentation
Migration to the production system
Consulting for production system go-live
Sector: Telecommunications
Team size: 8 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MySQL, Apache, Putty, SSH, MS-SOAP-Toolkit, Tomcat, MS-Access
Project management: Jira, Confluence
Platform: Linux
Build management: Jenkins, Ant
Business-Analyst, System-Designer, Consulting and Implementation
Creation of a reporting system: For a standardized ERP system, only a limited set of business reports was available. Since the ERP system relied on MS-SQL database services for data storage, it made sense to use the BI services of this database to provide advanced reports.
Analysis of enterprise 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, e.g., for procurement, sales, management overview, revenue planning
Extension and customization of existing reports
Development of a migration concept for report templates
Creating system documentation
User training
Sector: Food industry
Team size: 2 people
Tools: MS-SQL Server, MS Reporting Services, MS Analysis Services, MS Visual Studio, myFactory (ERP system), MS Internet Information Server
Project management: Confluence, Jira
Platform: MS Windows Server
Technical-Analyst, System-Designer, Consulting and Implementation
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 a state machine
Conducting acceptance tests
Creating system documentation
Migration to the production system
Consulting for production system go-live
Sector: Telecommunications
Team size: 6 people
Technologies: Java, Axis, XML/SOAP
Tools: JBuilder, MySQL, Apache, Putty, SSH, MS-SOAP-Toolkit, Tomcat, MS-Access
Project management: Confluence, Jira
Platform: Linux
System-Designer, Consulting and Implementation
Redesign of a support controlling system: The IT subsidiary of an international car manufacturer provides support services to the parent company for IT infrastructure operations. Service quality and related costs need to be monitored with appropriate controlling. This was previously done using various Lotus Notes components. The project provides information using standard 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 delivery jobs (ETL)
Design of reports
Conducting tests on the acceptance system
Migration to the production system
Sector: 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
Project management: Confluence, Jira
Platform: AIX, Windows
System Designer, Consulting and Implementation
Creation of a personnel deployment planning system: Within a telecommunications company, various tasks are needed to maintain and expand the infrastructure. Service teams are used for this purpose, and their activities must be planned accordingly. As part of the project, the required planning and controlling tools were provided based on the Cognos suite.
Analysis of the existing operational data
Design and implementation of the data model for the central OLAP data storage system
Design of the cube models
Design of data extraction processes
Migration of models between different system environments
Development and planning of automation routines (including a fail-safe scenario) for cube creation
Load testing
Design of audit reports (Report-Net)
Customer support regarding professional consulting and model adjustments
Creation of documentation for 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
Version control: ClearCase
Platform: Windows
System Designer, Consulting and Implementation
Development of a balance sheet-based rating system: An international automobile manufacturer conducts its sales mainly through a network of partner dealers. The dealers in this network need to be objectively evaluated in terms of their financial situation, along with related opportunities and risks. For this purpose, comparison perspectives are created between each dealer and dealer reference groups based on balance sheet data and interim financial 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
Setup of a test system
Design of 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
Technical Analyst, System Designer, Consulting and Implementation
Development of test scenarios for a customer database: Access to the central customer database is required to provide telecommunications services. It publishes its information via web services. The database itself is continuously developed. To ensure system stability, it needs to undergo automated regression tests. As part of the project, both the tests for the current development status of the database and a testing tool that enables automated tests were developed.
Analysis of existing access functions to the customer database
Identification of "typical" use cases for interaction 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 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
Technical Analyst, Consulting and Commissioning
Support of a paid content platform: The client quickly developed a variety of new internet-based information and communication services, integrated them into the portal, and launched them on the market. These offerings are based on a unified technical infrastructure. The related technical conditions influence the functional structure of the services and must be taken into account during service implementation. As part of the project, consulting services were provided for integrating new services into the mentioned infrastructure.
Development of internal system data management tools
Creation and management of system configurations
Analysis and restructuring of existing functionality
Test management regarding the implementation of new functions within the platform components
Design of system documentation
Technical support for external partners when integrating new services with 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
System Designer, Consulting and Implementation
Enhancement 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 features
Creation of the user manual
Industry: IT Services
Team size: 4 people
Technologies: Java
Tools: PowerDesigner, Eclipse, MS SQL Server
Work management: Confluence, Jira
Platform: Windows
System Designer and Implementation
Creating a web presence based on a content management system
Analysis of the components to be published (content & design)
Design and implementation of HTML design 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
Task management: Confluence, Jira
Platform: Windows
Business and Technical Analyst, System Designer
Redesign of the transaction module for a mobile payment system: In the backend of a mobile payment system, the requested transactions need to be processed. Here, the correct handling of the purpose field was an unsolved challenge that this project aimed to solve. In this project phase, the requirements definition was to be 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
Business and Technical Analyst, System Designer, Consulting and Implementation
Development of a fund management system: Processing fund transactions in their previous form was complex and prone to errors. The causes lay both in the organization and in the technical infrastructure. The processing workflow spans several departments and technical systems. The same information is stored multiple times in different systems and must also be entered more than once to bridge system boundaries. This leads to disproportionately high 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 systems involved was reduced and the communication between systems was automated. A web-based online entry for fund orders was provided as part of the project, and interfaces to the adjacent issuing 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
Design of test scenarios and execution of 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
Task management: Confluence, Jira
Platform: Unix
Business and Technical Analyst, System Designer, Consulting and Implementation
Development of a universal and flexible pricing system
Managed an international group of developers
Training and coaching in Java, OOP, 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, Visual Age for Java, JBuilder, JUnit, Tomcat, MS Project
Task management: Confluence, Jira
Platform: Unix
Summary
I have solid knowledge 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 focusing 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 such as telecommunications, automotive, energy, and banking, I have enabled the realization of complex web-based platforms, data migrations, and challenging consulting tasks. My technical skills cover a broad spectrum of modern technologies, including Java, Axis, XML/SOAP, Jenkins, and Tomcat, which I use professionally on Linux and Windows platforms.
Languages
Education
Apprenticeship as IT Specialist in System Integration · IT Specialist in System Integration
Darmstadt University of Applied Sciences
Computer Science Studies · Germany
Certifications & licenses
ISTQB Certified Tester
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.