Recommended expert

Stephan Heilmann

Development, Tester

Stephan Heilmann
Darmstadt, Germany

Experience

May 2025 - Present
10 months

Development, Tester

Telecommunications

  • Set up an operational contract information system. It is mainly used as an order management system—for migrating existing contracts and creating and providing new contract bundles.

  • Sales agents can use it to 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.

  • Also, the system imports and processes master data (ETL) and provides it via services for further use in the portal front end.

  • 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)

  • 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

Jan 2025 - Apr 2025
4 months

Development, Data Security/Security, Tester, Test Automation Engineer

Telecommunications

  • Set up a sales information system. To support order management, a sales information system was established. Through a web UI, users can view contracts, capture orders, and forward them to downstream systems. Part of the project was ensuring data protection compliant retention periods for personal information.

  • Technical design of business retention periods (data security)

  • Development 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)

  • 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

Jun 2021 - Dec 2024
3 years 7 months

Development, Tester, Test Automation Engineer

Government

  • Anonymization of statistical data. A government agency is required to prevent back-calculation of statistical values to original values and thus ensure their anonymization.

  • For this, mathematical algorithms are applied using noise factors and overlay matrices.

  • It must be ensured that the final deviations in the results due to the noise factors remain within a defined range.

  • For the departments and applications, appropriate REST & SOAP web services must be provided that accept the original values (up to 1 million records), process them based on the use case, and return the overlaid values.

  • In addition, the functional behavior must be tested for correctness and performance, and corresponding module and system tests must be 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, Sonar code quality, OWASP security checks)

  • Test automation (JUnit, Mockito, SoapUI)

  • Team size: 4 people (subproject team), 25 people (total project team)

  • Technologies: JavaEE 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

Apr 2021 - Jun 2021
3 months

Test Manager

Foreign Trade

  • Export customs declaration (PortaZa). PortaZa provides an interface between small business ERP systems and customs for export declarations.

  • During product development, the need arose 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

  • Team size: 6 people

  • Technologies: Java 8, JBehave, Selenium, Serenity, Hibernate

  • Tools: Word, PowerPoint, NetBeans, Maven, Docker

  • Work management: Jira, Confluence

  • Build management: Jenkins

Nov 2018 - Apr 2021
2 years 6 months

SIT Coordinator, Business Analyst, Test Automation Engineer, Tester

Energy Supply

  • Unbundling railway electricity. An international railway electricity company must technically separate its market roles (user and supplier) system-wide.

  • The new system should cover all previously supported business cases from data entry to billing and at the same time meet the new requirements and regulations of the BNetzA.

  • The newly created system landscape must undergo continuous QA for all processes.

  • 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 and performance tests) with a focus on system and system integration testing

  • 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

  • Team size: 14 people (supplier stream), 60 people (total 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

Mar 2015 - Nov 2018
3 years 9 months

System Designer, Development, Tester

Energy Supply

  • Usage data management system. Building a new system landscape to separate market roles (user and supplier) for market communication, master data storage and management, and reporting.

  • Receiving and storing role-specific data (master data, usage information) and automatically processing and forwarding it to downstream systems.

  • Analysis of technical use cases (workflows, involved processes/systems, communication paths, security requirements)

  • Documenting the use cases with Innovator (UML)

  • Designing and implementing service objects (MDB, JMS, and SOAP services)

  • Designing and implementing the business logic

  • Designing and implementing the persistence layer (data structures, JPA)

  • Designing gateway processes/interfaces (Tibco)

  • Creating component documentation

  • Quality assurance (planning and executing module, integration, and acceptance tests)

  • Advising on system production rollout

  • Team size: 8 people (NDM team), 60 people (overall 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

  • Tests: JUnit, SoapUI (Groovy)

  • Platform: Linux (SLES11/12), Windows

  • Build management: Jenkins

Aug 2014 - Feb 2015
7 months

Business Analyst, System Designer, Consultant

Logistics

  • Shipping management system. Fundamental system redesign of a shipping management system that has reached its technical limits.

  • The new system covers all business scenarios and is brought up to the current technology level.

  • Analysis of functional use cases (screens, customer requirements, support team needs)

  • Analysis of technical use cases (workflows, involved backend systems, communication paths, security requirements)

  • Documenting the use cases with UML2

  • Creating system documentation

  • 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

  • Tests: JUnit

  • Platform: Linux, Windows

Oct 2013 - Sep 2014
1 year

Business Analyst, System Designer, Consulting and Development

Telecommunications

  • Voucher management suite. Designing and implementing a management suite for a proprietary voucher system of an online shop.

  • Supporting various business processes for customer support.

  • Analysis of technical use cases (workflows, involved backend systems, communication paths, security requirements)

  • Documenting the use cases with UML2

  • Designing and implementing service objects (Spring MVC) and designing/implementing the front-end UI (HTML5, CSS, JSP, JavaScript, jQuery)

  • Designing and implementing the persistence layer (data structures, JPA)

  • Implementing SSO mechanisms (OpenId, OAuth1)

  • Running tests on the acceptance system (SLES11)

  • Creating system documentation

  • Advising on production rollout

  • The project was carried out using an iterative agile approach (SCRUM)

  • 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

  • Tests: JUnit

  • Platform: Linux

  • Build management: Jenkins

Nov 2012 - Jun 2013
8 months

Business/Technical Analyst, System Designer, Consulting and Development

Telecommunications

  • Developing a gateway between a traditional and an IP-based telephone system. Enabling access to the built-in voicemail through a dedicated gateway with SOAP services.

  • Structural and impact analysis of the telephone system interfaces, including performance measurements

  • Designing the process architecture of the gateway/interface

  • Designing the persistence layer

  • Designing an infrastructure to ensure high system availability

  • Planning and participating in implementation tasks

  • Quality assurance (planning and executing module, integration, and acceptance tests)

  • Advising on system go-live

  • The project was carried out within an iterative agile methodology (SCRUM)

  • 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

  • Tests: JUnit

  • Platform: Linux

  • Build management: Jenkins, Maven

Aug 2012 - Oct 2013
1 year 3 months

Business/Technical Analyst, System Designer, Consulting and Development

Telecommunications

  • Developing a REST gateway for the SMS successor service Joyn (RCSe). Equipping the infrastructure with a REST interface to communicate with mobile devices (text, files, chat, video calling).

  • Structural and impact analysis of the Joyn system to be integrated

  • Specifying the main technical use cases

  • Evaluating third-party providers for RCS/RCS-e components

  • Planning and managing the pilot phase and final implementation

  • Technical project leadership, consulting and assisting with implementation

  • Integrating third-party software and connecting the supplier backend

  • Conducting acceptance tests

  • Advising on migration to the live system and commissioning

  • Creating system documentation

  • The project was executed using an iterative agile methodology (SCRUM)

  • 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, Redmin

  • Tests: JUnit

  • Platform: Linux

  • Build management: Jenkins, Maven

Mar 2012 - Aug 2012
6 months

Business Analyst, System Designer, Implementer, Senior Test Manager

Internet-Service-Provider

  • Mobile webshop frontend. Enabling shop access via Android app for a multi-tenant shop infrastructure.

  • Native app with configurable branding layout.

  • 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

  • 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

Dec 2011 - Mar 2012
4 months

Business/Technical Analyst, System Designer, Consulting and Development

Telecommunications

  • Development of a SOAP interface to an email service. Standardization and simplification of configuration processes for a mail system via a SOAP interface.

  • Analysis of the mail system APIs and communication paths

  • Capture 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 deployment

  • Creation of the system documentation

  • 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

  • Tests: JUnit

  • Platform: Linux

  • Build management: Jenkins, Ant

Nov 2011 - Dec 2011
2 months

Business/Technical Analyst, System Designer, Consulting and Development

Telecommunications

  • Development of a system for automated GUI tests. Building an infrastructure for automated testing of dynamic user dialogs for GUI-based services.

  • Analysis of the applications to be tested

  • Design and implementation of a mask and template parser

  • Creation of the system documentation

  • Team size: 2 people

  • Technologies: PHP, Perl, JavaScript, HTML5, CSS3, jQuery

  • Tools: Zend Studio

  • Work management: Jira, Confluence

  • Platform: Linux

  • Build management: Jenkins, Ant

Mar 2011 - Oct 2011
8 months

System Designer, Consulting and Development

Telecommunications

  • Development of a gateway for access to a cloud store. Building a specific gateway for app access to cloud services (images, videos).

  • Analysis of the existing backend services, defining requirements

  • Design and implementation of the new software components

  • Execution of unit and bundle tests

  • Packaging (RPM) and delivery

  • Consulting on software delivery, distribution and quality assurance

  • Creation of the system documentation

  • The project was carried out using an iterative agile approach (SCRUM)

  • 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

Feb 2011 - Aug 2011
7 months

System Designer, Development

Industry-independent standard product

  • Development of a mobile frontend for a project controlling system. Enabling the capture of actual efforts via mobile devices for field staff.

  • Identification of the key use cases

  • GUI design using mockups

  • Design and implementation of the REST services

  • Implementation of the iOS app

  • Application testing, software distribution

  • Team size: 1 person

  • Technologies: Objective C, REST, JSON

  • Tools: Xcode 4, iPhone/iPad emulator

  • Work management: Jira, Confluence

  • Platform: OSX

Jan 2011 - Apr 2011
4 months

Business/Technical Analyst, System Designer, Consulting

Telecommunications

  • Created a feasibility study for offering streaming services from a media portal on modern TVs. Evaluated TV devices for streaming suitability, including authorization and billing.

  • 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 authorization and billing systems

  • Documented performance features and shortcomings of device platforms

  • Documented required workflows

  • 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

Jun 2010 - Jan 2011
8 months

Technical Analyst, System Designer, Consulting, Development

Telecommunications

  • Migrated telecom backend services to the OSGI platform. Converted to an OSGI-compliant architecture to simplify operations and enable service updates without restart.

  • Analyzed existing services and developed migration requirements

  • Technical project management

  • Designed and implemented new software components

  • Planned and executed tests on the acceptance system

  • Packaged and delivered software

  • Provided consulting on software delivery/distribution/quality assurance

  • Created system documentation

  • 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

Dec 2009 - Feb 2011
1 year 3 months

Technical Analyst, System Designer, Consulting, Development

Telecommunications

  • Developed a SOAP interface for a voice-over-IP system. Connected the VoIP system to the central authorization and provisioning system via a SOAP interface.

  • Identified and documented key use cases

  • Designed data transformation rules between the VoIP system and the 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 and provided go-live support

  • 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

Oct 2009 - Apr 2010
7 months

Technical Analyst, System Designer, Consulting, Development

Telecommunications

  • Redesigned an existing SOAP-based communication platform to achieve WS-I compliance. Modified the email service API according to Web Services Interoperability Organization (WS-I) standards.

  • Performed 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 enhanced services

  • 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

Apr 2009 - Jul 2009
4 months

Technical Analyst, System Designer, Consulting, Development

Telecommunications

  • Developed a platform to connect digital photo frames to an image archive. Enabled display of cloud images on digital photo frames.

  • Analyzed existing interfaces to the image archive

  • Designed data transformation rules between interfaces and new SOAP services

  • Designed and implemented an RSS photo feed server and configuration front end

  • Technical project management and consulting for installation/configuration

  • Delivered software to the test and production systems

  • Created system documentation

  • 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

Jan 2009 - Nov 2009
11 months

Technical Analyst, System Designer, Consulting, Development

Telecommunications

  • Migration of a reporting system (DWH). Migrated the DWH and data supply processes from Debian Linux/Oracle to AIX/DB2.

  • Current state analysis of the existing system

  • Design and implementation of data transformations for AIX & DB2

  • Deployment to the test system and packaging for the production system

  • Design of the ETL for the staging area

  • Implementation of an application to control external processes and data compression

  • Conducting tests and creating reports

  • Consulting during production system rollout and user training

  • 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

  • Project management: Confluence, Jira

  • Platform: Linux, AIX

  • Build management: Hudson, Ant

Sep 2008 - Feb 2009
6 months

Technical Analyst, System Designer, Consulting and Implementation

Telecommunications

  • Provided a generic SOAP interface for a social network platform. Enabled information exchange between different Web 2.0 platforms.

  • Analysis of existing social network services (Flickr, Facebook, YouTube) and their architecture (WSDL, REST)

  • Developed a concept for a modular gateway interface (SOAP)

  • Designed data structures for the interface configuration

  • Presented and aligned the solution

  • Participated in implementation

  • Team size: 6 people

  • Technologies: Java, Axis, XML/SOAP

  • Tools: Enterprise Architect, Eclipse, XML-Spy, MS-SOAP-Toolkit, Tomcat, Jetty, Putty, SSH, SoapUI

  • Project management: Jira, Confluence

  • Platform: Linux

  • Build management: Hudson, Ant

Jul 2008 - Dec 2008
6 months

Technical Analyst, System Designer, Consulting and Implementation

Telecommunications

  • Converted existing communication service components to a service-oriented architecture (SOA) and an enterprise service bus (ESB). Redesigned the message-based communication infrastructure.

  • Technical analysis of existing services and identification of weaknesses

  • Validated and tested existing service interfaces and documented them

  • Redesigned the services to a WS-I-compliant SOAP structure

  • Led workshops to develop the new service structure

  • Team size: 6 people

  • Technologies: Java, Axis, XML/SOAP

  • Tools: Enterprise Architect, Eclipse, XML-Spy, MS-SOAP-Toolkit, Tomcat, Jetty, Putty, SSH, SoapUI

  • Project management: Jira, Confluence

  • Platform: Linux

  • Build management: Hudson, Ant

Nov 2007 - Nov 2007
1 month

System Designer, Consulting and Implementation

Telecommunications

  • Developed a platform to perform load tests on a streaming system.

  • Extended the existing web application with access rights and user management

  • Updated the documentation and made changes to the data model

  • Conducted acceptance tests and user training

  • Advised on setting up configurations and conducting the load tests

  • Team size: 2 people

  • Technologies: PHP, HTML, CSS

  • Tools: Zend Studio, MySQL, Apache, Putty, SSH, WinSCP

  • Project management: Confluence, Jira

  • Platform: Linux

Jul 2007 - Oct 2008
1 year 4 months

System Designer, Consulting and Implementation

Telecommunications

  • Developed a central web service platform as a single access point to a portal operator's services.

  • Implemented the central service platform as a SOAP web service

  • Designed and implemented the rights concept and management

  • Designed and implemented access to distributed backend systems

  • Designed and implemented data mapping and consolidation

  • Conducted tests on the acceptance system and migrated to the production system

  • 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

  • Project management: Confluence, Jira

  • Platform: Linux

  • Build management: Hudson, Ant

Feb 2007 - Jul 2007
6 months

System Designer, Consulting and Implementation

Telecommunications

  • Development of a system to perform real-time analyses on the technical systems of a portal operator.

  • Integration of a multi-participant database

  • Design and implementation of data transformation rules

  • Consolidation and ETL of incoming data (preprocessing)

  • Performance optimization at source code and database level for just-in-time processing

  • Conducting tests on the acceptance system

  • Creating system documentation and migration to the production system

  • 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

Oct 2006 - Feb 2007
5 months

Technical Analyst, System Designer, Consulting and Implementation

Telecommunications

  • Development of web services for a VoIP system. Connecting existing backend systems to a VoIP system via a specific gateway.

  • Integration of a multi-participant database

  • Design and implementation of data mapping

  • Design of relevant use cases (record dependencies)

  • Design of a reaction matrix as an automaton

  • Conducting acceptance tests

  • Creating system documentation and migration to the production system

  • 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

Jun 2006 - Oct 2006
5 months

Business Analyst, System Designer, Consulting and Implementation

Food industry

  • Development of a reporting system. Providing business reports for a standardized ERP system using BI services of an MS SQL database.

  • Analysis of company data in the ERP system

  • Design and provisioning of data views for reporting

  • Design and provisioning of the cube model

  • Design and provisioning of reports for purchasing, sales, and revenue planning

  • Extension and customization of existing reports

  • Development of a migration concept for report templates

  • 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

Mar 2006 - Jun 2006
4 months

Technical Analyst, System Designer, Consulting and Implementation

Telecommunications

  • Development of web services for a VoIP system. Connecting existing backend systems to a VoIP system via a specific gateway.

  • Analysis of incoming data

  • Identification of relevant use cases

  • Design and implementation of data transformations

  • Design of a reaction matrix as an automaton

  • Conducting acceptance tests and creating system documentation

  • Migration to the production system

  • 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

Feb 2006 - Apr 2006
3 months

System Designer, Consulting and Implementation

Automotive

  • Redesign of a support controlling system. Providing information using business intelligence methods to control support services.

  • Analysis of the existing legacy system

  • Design and implementation of the data model for the central OLAP data storage system

  • Design of data marts and data provisioning jobs (ETL)

  • Design of reports

  • Conducting tests on the acceptance system and migration to the production system

  • Team size: 2 people

  • Technologies: Data Warehousing, Business Intelligence, ETL

  • Tools: PowerDesigner, Cognos DecisionStream, Cognos Impromptu, Cognos PowerPlay, DB2, Toad for DB2

  • Work management: Confluence, Jira

  • Platform: AIX, Windows

Apr 2005 - Feb 2006
11 months

System-Designer, Consulting and Implementation

Telecommunications

  • Development of a staff scheduling system. Providing planning and controlling tools for service teams based on the Cognos suite.

  • Analysis of the existing operational data

  • Design and implementation of the data model for the OLAP data storage system

  • Design of cube models and data extraction processes

  • Development of automation for cube generation (including fail-safe)

  • Design of audit reports (Report-Net)

  • Creation of documentation for the OLAP datastore and analysis cube models

  • Conducting user training

  • Team size: 10 people

  • Technologies: Data Warehousing, Business Intelligence, ETL

  • Tools: Cognos Transformer, Cognos Contributor, Cognos Analyst, Cognos Connection, Cognos Report Studio, PowerDesigner, Toad, Oracle 10.1

  • Work management: ClearCase

  • Platform: Windows

Jan 2005 - Apr 2005
4 months

System-Designer, Consulting and Implementation

Automotive

  • Development of a balance sheet–based rating system. Objective evaluation of partner dealers regarding their financial status based on balance sheet data.

  • Analysis of manually created reports and document structure

  • Design of GUI templates and report templates

  • Implementation of a report generation engine

  • Development of a converter from HTML reports to PDF reports

  • Setup of a test system and performance of load tests

  • 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, Freemaker, Adobe Acrobat, MS Visual Studio

  • Work management: Confluence, Jira

  • Platform: AIX, Windows

Jan 2005 - Apr 2005
4 months

Technical-Analyst, System-Designer, Consulting and Implementation

Telecommunications

  • Development of test scenarios for a customer database. Development of automated regression tests for a customer database with a web service API.

  • Analysis of the existing access functions to the customer database

  • Gathering typical use cases for interaction according to the developer concept

  • Development of test scripts for a generic simulator

  • Execution and logging of tests (pass/fail scenarios)

  • Bug reporting

  • Team size: 2 people

  • Technologies: Java, Axis, XML/SOAP

  • Tools: JBuilder, MS SOAP Toolkit, Apache, PuTTY, SSH, Tomcat

  • Work management: Confluence, Jira

  • Platform: Linux

May 2002 - Jan 2005
2 years 9 months

Technical-Analyst, Consulting and Deployment

Telecommunications

  • Support for a paid content platform. Consulting on connecting new internet-based services to a unified technical infrastructure.

  • Development of internal system data management tools

  • Creation and maintenance of system configurations

  • Analysis and restructuring of existing functionality

  • Test management for the implementation of new features

  • Technical support for external partners during integration

  • 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

Apr 2002 - May 2002
2 months

System-Designer, Consulting and Implementation

IT-Services

  • 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

  • Team size: 4 people

  • Technologies: Java

  • Tools: PowerDesigner, Eclipse, MS SQL Server

  • Work management: Confluence, Jira

  • Platform: Windows

Jan 2002 - Apr 2002
4 months

System Designer and Implementation

IT-Services

  • Creation of 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)

  • Team size: 1 person

  • Technologies: HTML, CSS, JavaScript, VB-Script

  • Tools: Microsoft CMS, SQL Server

  • Work management: Confluence, Jira

  • Platform: Windows

Dec 2001 - Jan 2002
2 months

Business and Technical Analyst, System Designer

Finance

  • Redesign of the transaction module for a mobile payment system. Solution for correct processing of payment reference in the backend of a payment system.

  • Analysis and documentation of the existing system architecture

  • Specification/documentation of the new target architecture with extended functionality

  • Team size: 1 person

  • Technologies: PL/SQL

  • Tools: Oracle 8i, Toad

  • Platform: Unix

Sep 2001 - Dec 2001
4 months

Business and Technical Analyst, System Designer, Consulting and Implementation

Finance

  • Development of a fund management system. Redesign of the business process to reduce costs and error rates by automating system communication.

  • 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

  • Team size: 10 people

  • Technologies: Java, PL/SQL, HTML, CSS, UML, JSP, JavaScript

  • Tools: PowerDesigner, Enterprise Architect, Oracle 8i, Toad, JBuilder, JUnit

  • Work management: Confluence, Jira

  • Platform: Unix

Feb 2001 - Sep 2001
8 months

Business and Technical Analyst, System Designer, Consulting and Implementation

Finance

  • Development of a universal and flexible rating system.

  • Leadership of an international developer team

  • Training and coaching in Java, OO, relational databases

  • Design, implementation and testing of the application framework in Java

  • Design and implementation of the data storage system

  • 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

  • Work management: Confluence, Jira

  • Platform: Unix

Skills

  • Senior Consultant With A Focus On Web Applications (Back- And Front-end)

  • Tester (Istqb)

  • Test Automation Engineer

  • Integration Tester

  • Banking

  • Government

  • Foreign Trade

  • It

  • Energy Supply

  • Marketing

  • Telecommunications

  • Automotive

  • Logistics

  • Microsoft Office Tools, O365

  • Ms Project

  • Industry-specific Prt Tools

  • Jira, Gitlab

  • Confluence

  • Infopath

  • Sharepoint

  • Hp Alm / Qualitycenter

  • Waterfall Model

  • V Model

  • Agile Software Development With Scrum

  • Agile Streams / Value Streams

  • Ooa/ood

  • Behavior Driven Development

  • Test Driven Development

  • Data/er Modeling / Db Design

  • Uml

  • Bpmn

  • Macos 7.x/8.x/10.x

  • Ios 4-7 (Iphone/ipad)

  • Ms-dos

  • Windows 95-7/10/11, Server 2008/2016/2019

  • Linux (Debian, Sles, Ubuntu)

  • Solaris

  • Assembler (8-bit)

  • C#

  • Objective-c, Swift (Basic Knowledge)

  • Java/javaee (Primary Programming Language Used), Jdk 1.8-21, Openjdk 11-23, Jakarta Ee 9/10

  • Scala

  • Php

  • Python

  • Html/html5

  • Css/css3

  • Xml (Xsd/dtd/xslt)

  • Sql

  • Pl/sql

  • Tcl/tk

  • Groovy

  • Access

  • Oracle 8, 8i, 10.x, 11, 12

  • Ms Sql Server (2000, 2005, 2008)

  • Db2

  • H2db

  • Mysql, Mariadb

  • Postgresql

  • Odbc/jdbc

  • Enterprise Architect

  • Powerdesigner

  • Ms Visual Modeller

  • Innovator

  • Visio

  • Mindmap

  • Talend 6.x (Etl)

  • Cognos Series 7 With Powerplay, Impromptu, Decisionstream (Etl)

  • Microsoft Sql Server 2005 Analysis Server

  • Microsoft Sql Server 2005 Reporting Server

  • Eclipse / Myeclipse

  • Netbeans

  • Jbuilder 3.5-2008

  • Visual Studio (.Net)

  • Visual Studio Code

  • Zend, Phpstorm

  • Pycharm

  • Webstorm

  • Intellij Idea

  • Apple Xcode

  • Xmlspy / Oxygen

  • Maven, Ant

  • Soapui (Incl. Groovy)

  • Ms Soap Toolkit

  • Cvs, Svn, Git, Mercurial

  • Gitlab Ci/cd, Jenkins

  • Vmware (Test, Acceptance And Development Systems)

  • Apache

  • Tomcat, Tomee

  • Docker

  • Jetty

  • Iis

  • Jboss, Wildfly, Glassfish

  • Ejb

  • Com/dcom

  • Ria (Gtw, Silverlight)

  • Jquery, Bootstrap 4/5

  • Spring Frameworks / Spring Boot

  • Hibernate, Jpa, Eclipselink

  • Servlets

  • Jsp, Jsf

  • React, React Toolkit, Vite

  • Jms / Mdb (Tibco, Ems, Jboss Hornetq)

  • Jbehave, Selenium, Serenity

  • Cypress

  • Playwright (Java, Python)

  • Owasp, Sonar, Trivy

  • Sqlalchemy

  • S3

  • Soap (Wsdl, Wadl)

  • Json/rest (Wadl)

  • Swagger, Openapi

  • Ajax

  • Yaml

  • Markdown

Languages

German
Native
English
Advanced
French
Elementary

Education

Unknown

Vocational training as IT specialist in system integration · IT specialist in system integration · Germany

Darmstadt University of Applied Sciences

Computer Science · Darmstadt, Germany

Certifications & licenses

ISTQB Certified Tester

Profile

Created
Last Update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Stephan based?

Stephan is based in Darmstadt, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Stephan speak?

Stephan speaks the following languages: German (Native), English (Advanced), French (Elementary).

How many years of experience does Stephan have?

Stephan has at least 25 years of experience. During this time, Stephan has worked in at least 23 different roles and for 11 different companies. The average length of individual experience is 7 months. Note that Stephan may not have shared all experience and actually has more experience.

What roles would Stephan be best suited for?

Based on recent experience, Stephan would be well-suited for roles such as: Development, Tester, Development, Data Security/Security, Tester, Test Automation Engineer, Development, Tester, Test Automation Engineer.

What is Stephan's latest experience?

Stephan's most recent position is Development, Tester at Telecommunications.

What companies has Stephan worked for in recent years?

In recent years, Stephan has worked for Telecommunications, Government, Foreign Trade, and Energy Supply.

Which industries is Stephan most experienced in?

Stephan is most experienced in industries like Telecommunication, Utility Services, and Government and Public Administration. Stephan also has some experience in Information Technology (IT), Banking and Finance, and Transportation and Logistics.

Which business areas is Stephan most experienced in?

Stephan is most experienced in business areas like Information Technology (IT), Quality Assurance (QA), and Product Development. Stephan also has some experience in Business Intelligence and Project Management.

Which industries has Stephan worked in recently?

Stephan has recently worked in industries like Government and Public Administration, Utility Services, and Telecommunication.

Which business areas has Stephan worked in recently?

Stephan has recently worked in business areas like Quality Assurance (QA), Information Technology (IT), and Product Development.

What is Stephan's education?

Stephan attended Unknown for IT specialist in system integration.

Does Stephan have any certificates?

Stephan has 1 certificate: ISTQB Certified Tester.

What is the availability of Stephan?

Stephan is immediately available full-time for suitable projects.

What is the rate of Stephan?

Stephan's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Stephan?

To hire Stephan, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 850-1010 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.