Erich Wanner.
Menu

Language

Contact

Home / Roles

← Roles

Business Analyst

Understand business processes, clarify business context and develop changes with those involved. This produces process models, requirements and a basis for implementation decisions.

Freelance support for your project. Primarily working remotely from Germany and Spain, with on-site visits by arrangement.

Discuss a business analysis assignment

Project experience

02/2021–05/2021

Service Monitor

DB Fernverkehr, Frankfurt am Main

Agile Business Analyst

Analyse business processes and requirements for a service monitor and specify them for development and quality assurance.

Show details Hide details

Analyse and structure business and technical requirements for monitoring the service status of vehicles within a train formation, and specify them for development and quality assurance. Use DBeaver for database queries and GitLab as a repository.

Used in the project

Planning & collaboration
Jira, Confluence, Microsoft Teams, Microsoft Office
Analysis & modelling
Enterprise Architect
Development & operations
DBeaver, GitLab
Cloud & data
PostgreSQL, Tableau

05/2020–12/2020

MOSAIK – ticket inspection and revenue protection

DB Vertrieb, Frankfurt am Main

Agile Business Analyst · Proxy Product Owner · Deputy Scrum Master

Structure requirements for mobile ticket inspection and revenue protection, and coordinate them across several teams; also support and stand in for Product Owners and Scrum Masters.

Show details Hide details

Structure requirements for a mobile replacement platform for ticket inspection and revenue protection, and coordinate interfaces with mobile devices, printers and payment terminals. Support Product Owners and Scrum Masters in an organisation with multiple Scrum teams. Use Cucumber primarily for test specifications.

Used in the project

Planning & collaboration
Jira, Confluence, Microsoft Teams, Microsoft Office
Analysis & modelling
Enterprise Architect
Development & operations
Cucumber

06/2018–03/2020

Mobile app for farm management

GEA Farm Technologies, Bönen

Product Owner · Business Analyst

Mobile app for herd and farm management, with online and offline data capture and cloud synchronisation.

Show details Hide details

Analyse workflows, create mockups and specify requirements and REST interfaces. Support coordination with the external development team. When a connection was available, the app synchronised recorded animal data and actions with FarmNet.

Used in the project

Collaboration
Jira, Confluence, Microsoft Teams, Microsoft Office, Wiki
Interfaces
REST APIs
Platforms
Windows, Android, iOS

03/2018–03/2020

Herd management web portal

GEA Farm Technologies, Bönen

Product Owner · Solution Architect · Business Analyst

Further development of a cloud-based web platform for herd management and farm processes.

Show details Hide details

Analysis and structuring of functional and non-functional requirements, roadmap alignment, and definition of epics and user stories. Collaboration with distributed development teams, product management and pilot customers. The portal supported the planning and recording of animal-related activities, as well as data exchange with mobile applications and IoT systems.

Used in the project

Planning & collaboration
Jira, Confluence, Microsoft Teams, Microsoft Office, Wiki
Development & operations
Java, Docker, Ranorex
Cloud & data
AWS, OTC, Windows

12/2016–03/2020

Cloud integration for local equipment control

GEA Farm Technologies, Bönen

Product Owner · Solution Architect · Business Analyst

Cloud and IoT platform for synchronising local equipment control with FarmNet cloud processes.

Show details Hide details

Analysis of requirements from existing systems and local equipment control, translated into epics and user stories. Structuring of the microservices implementation with the development team; support for test management and further development. A Windows client and an IoT cloud service connected local equipment control to FarmNet and synchronised measurements and animal-related activities.

Used in the project

Planning & collaboration
Jira, Confluence, Microsoft Teams, Microsoft Office, Wiki
Development & operations
Java, Docker, Ranorex
Cloud & data
AWS, Windows

06/2018–01/2019

BI reporting for dairy farms

GEA Farm Technologies, Bönen

Product Owner · Solution Architect · Business Analyst

BI and data analytics solution for preparing and analysing operational and performance data for customers and farms in the North American market.

Show details Hide details

Analyse competitors, studies, and market and customer requirements for farms in North America. Specify Power BI reports, user stories and test data, and coordinate architecture and delivery with the distributed team. The solution processed data on herd performance, health, milk yield and nutrition: from DairyBox via IoT Hub and Azure SQL to data preparation with Data Factory and report delivery.

Used in the project

Planning & collaboration
Jira, Confluence, Microsoft Office, Wiki
Cloud & data
Microsoft Azure, App Service, Azure IoT Hub, Azure SQL, Data Factory, Azure Analysis Services
Reporting & BI
Power BI

11/2015–01/2016

Payment – SEPA B2B Direct Debit and Credit Card

ASCAMSO, Frankfurt am Main

Product Owner · Business Analyst

Specify SEPA direct debit and credit card payments for a cloud platform and coordinate implementation with the development team.

Show details Hide details

Analyse payment processes and SEPA requirements for purchasing platform credits. Model processes with yEd Graph, specify user stories, acceptance criteria and test cases in Jira, and coordinate implementation with the development team in Kyiv. The solution supported SEPA B2B direct debits with mandates and credit card payments.

Used in the project

Planning & collaboration
Jira, Microsoft Office, SharePoint
Analysis & modelling
yEd Graph
Development & operations
Java, TestLink
Cloud & data
Windows 8.x

01/2015–10/2015

TUCA – test environment, user and software client administration

Commerzbank, Frankfurt am Main

Proxy Scrum Product Owner · Business Analyst

Model processes for test initiatives, test users and permissions, and support the first release from a business perspective – as Business Analyst and Proxy Scrum Product Owner.

Show details Hide details

Analyse processes across four organisational units and model a shared workflow in Enterprise Architect. Create the domain and database model, including DDL scripts, specify user stories and test cases in Team Foundation Server, and test implemented functions. The web application linked registration, resource reservation, approval and closure of test initiatives with the management of test users, permissions and software clients simulating workstations. Oracle and SQL Server data were integrated.

Used in the project

Planning & collaboration
Microsoft Office
Analysis & modelling
Enterprise Architect, UML
Development & operations
HP Quality Center, DBeaver, Team Foundation Server 2013
Cloud & data
Windows XP, Oracle 11, SQL Server, WebSphere

03/2014–12/2014

Integration of dairy farming into a farm management information system

GEA Farm Technologies, Bönen / Gütersloh

Product Owner · Solution Architect · Business Analyst

Align requirements and application architecture for integrating dairy farming into a farm management system, and support implementation.

Show details Hide details

Coordinate application architecture and the roadmap, specify epics, user stories and acceptance criteria, and coordinate test management. Introduce Scrum practices with reviews, planning and retrospectives. The platform connected dairy farming, other farm processes and equipment control, and was designed for both cloud and local use.

Used in the project

Planning & collaboration
Jira, Microsoft Office, SharePoint
Analysis & modelling
Enterprise Architect, UML
Development & operations
Java, TestLink, SVN, Postscript
Cloud & data
Windows 8.x

08/2012–06/2013

Action administration

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Web application for administering actions resulting from changes to payment control.

Show details Hide details

Web application for controlling follow-up actions after changes to payment control: updating affected pension records or triggering notifications. Action-specific rules defined dates, checks and approvals. The application determined the number of affected records and generated an order for each record when the action ran.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova XML Spy, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB

01/2012–06/2013

Payment control administration

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Web application for administering bitemporal control tables for payment control, posting codes, outlays, value dates and country relationships.

Show details Hide details

Model-generated web application for maintaining bitemporal control tables for payment routes, posting codes, expenses, value dates and country relationships. The UML model in Together described tables, references, and variable or invariant attributes. Changes were controlled through maintenance transactions with locking, logging and dual approval.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova XML Spy, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB

01/2012–06/2013

Payment control file upload

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Batch process and services for updating payment control from external files.

Show details Hide details

Batch processing and services for comparing external files with payment-control master tables. Additions, deletions and changes generated maintenance transactions subject to business approval under defined rules. Inputs included SWIFT BIC and bank holiday data, the SCL Directory for SEPA reachability, and US bank routing numbers from the Federal Reserve System.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, CVS, TOAD, Tosca TestSuite
Cloud & data
Windows XP, HP-UX, Oracle DB

05/2011–06/2013

International liquidity management

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Integration of outlays, expenses, business transactions and posting codes into payment control.

Show details Hide details

Integrate expenses, charges, business transactions and posting codes into payment control, and provide data for SAP, accounting and settlement. The solution aggregated amounts and counts for advance-payment forecasts and settlement. A web application provided up-to-date ad hoc analysis of these data.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova XML Spy, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB

05/2010–04/2013

International payment management

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Payment of ongoing pensions and one-off payments abroad, and design of central payment control.

Show details Hide details

Design central payment control for recurring pensions and one-off payments abroad, and migrate legacy host control data to a client-server database architecture. The solution generated bank files in formats including SEPA PAIN, PAX and HBV Impay. Bitemporal control tables supported retrospective cancellations and corrected payments.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB

01/2011–02/2013

International processing order management

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Electronic processing of new cases, changes and closures for beneficiaries abroad.

Show details Hide details

Extend the processing of new, changed and closed records for pension recipients abroad to include recurring and one-off payments. Integrate detailed payment transactions, input checks and recovery claims by recipient, item and overpaid amount. Migration of existing records also included calculating historical payment transactions.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, CVS, TOAD, Tosca TestSuite
Cloud & data
Windows XP, HP-UX, Oracle DB

05/2011–06/2012

Multi-tenant user administration

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Extension of user administration to provide tenant-specific access to data and functions.

Show details Hide details

Extend user management with tenant-specific access to data and functions, and delegate permission management to the respective tenant administrators. User management was migrated from Oracle Internet Directory to OpenLDAP.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, Tosca TestSuite, Struts
Cloud & data
Windows XP, HP-UX, LDAP, OID, OpenLDAP

05/2011–06/2012

Online enquiries

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Extension of model-driven case enquiries from intranet to internet use cases.

Show details Hide details

Provide model-driven access to pension records for external partners, with tenant-specific permissions for data, document types and functions. Internal and external applications shared data access and most layout definitions. Specific presentation differences were added where needed; shared definitions kept both applications aligned across releases.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova XML Spy, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB, EMC Centera

10/2010–06/2012

Calendar management: administration and use

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Web application for managing specific calendars, time spans and dates for payment and processing workflows.

Show details Hide details

Model business calendars for payment and processing cycles whose periods differ from the standard calendar. Calendar types defined the structure and nesting of time spans and their associated dates. Defaulting and scheduling rules, together with web-based administration, supported maintenance.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB

07/2010–01/2011

Complaint management

Deutsche Post AG / Renten Service, Köln

Business Analyst · Application Architect

Web application for recording, categorising and monitoring complaints and enquiries.

Show details Hide details

Web application for recording complaints and enquiries associated with information provided by telephone or in writing. Reasons and categories could be administered. Continuous monitoring of unusual patterns supported the investigation of potential payment issues and subsequent communication with case handlers.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB

08/2008–11/2009

Case enquiry layout and printing improvements

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Improvement of the layout, search, copy function and PDF print output for case enquiries.

Show details Hide details

Revise the presentation and JavaScript of the pension-record enquiry application while retaining its model-driven approach. Additions included a copy function for search results defined in the model using regular expressions, and PDF print output with Altova StyleVision.

Used in the project

Planning & collaboration
Jira, Microsoft Office, PLANTA Project
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB

01/2007–08/2008

Document management

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Extension of case enquiries to include document management, scanning, barcode recognition, signatures and archiving.

Show details Hide details

Connect document management with barcode matching and scan import to the pension-record enquiry application. Document types determined retention periods and other attributes; documents were stored asynchronously, first in the database and then in EMC Centera. The solution supported signatures, documents with or without a linked pension record, and a dedicated completeness check.

Used in the project

Planning & collaboration
Jira, Microsoft Office, PLANTA Project
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB, EMC Centera

09/2006–10/2007

Case enquiries

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Web application for searching and displaying cases using a model-driven presentation.

Show details Hide details

Model search functions, options and result lists for a web-based pension-record enquiry application using extended UML state diagrams. Layouts and the assignment of record data to data groups were described through models. DSL and OCL extensions in Together provided the basis for specifying this and other web applications.

Used in the project

Planning & collaboration
Jira, Microsoft Office, PLANTA Project
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB

07/2007–09/2007

Bank information enquiries

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Model-driven development of an enquiry application for financial institutions, successor banks, addresses and communication channels.

Show details Hide details

Model-driven access to information on banks, successor banks, addresses, dates and communication channels. During the transition from national bank codes and account numbers to BIC and IBAN, information objects controlled the exchange of account information with the SEPA portal or directly with the bank, and monitored its processing.

Used in the project

Planning & collaboration
Jira, Microsoft Office, PLANTA Project
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts, Altova Stylevision
Cloud & data
Windows XP, HP-UX, Oracle DB

07/2006–12/2006

Snapshot archive

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Concept and system for replacing microfiche and printed lists with electronic archiving.

Show details Hide details

Solution

Electronic archiving and retrieval to replace microfiche and lists; version-independent structures.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD
Cloud & data
Windows XP, HP-UX, Oracle DB, EMC Centera

12/2003–07/2006

Information service

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Separation of processing order management and the information service through information objects.

Show details Hide details

Solution

Asynchronous delivery of information objects to recipients and internal interfaces.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB, EMC Centera

03/2005–01/2006

Statistical enquiries on information objects

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Web application and services for statistical analysis of information objects.

Show details Hide details

Solution

Selectable summary statistics and lists for information objects; output to screen, Excel and files.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB

08/2004–08/2005

Notification and error interface

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Web application for displaying and handling notifications and errors from order processing.

Show details Hide details

Solution

Comparison of processing orders and existing case data for notifications and errors; processing status and scheduling integration.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Tosca TestSuite, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB

11/2002–04/2005

Domestic processing order management

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Development and introduction of processing order management as part of a comprehensive system modernisation.

Show details Hide details

Solution

Model-driven processing order management introduced; legacy records migrated from the host. The system scale was 120 million records including history.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, CVS, TOAD
Cloud & data
Windows XP, HP-UX, Oracle DB

12/2003–12/2004

Scheduling management

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Web application for managing dates and tasks associated with users and applications.

Show details Hide details

Solution

Dates and tasks with permissions, escalation, forwarding, return and logging.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, JavaScript, CVS, TOAD, Struts
Cloud & data
Windows XP, HP-UX, Oracle DB

08/2003–06/2004

Archiving

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Selection, design and commissioning of an archiving infrastructure based on EMC Centera.

Show details Hide details

Solution

Archive system selected and commissioned; storage structure, access paths and administration designed.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Analysis & modelling
Together, UML, BPMN
Development & operations
Java, CVS, TOAD
Cloud & data
Windows XP, HP-UX, Oracle DB, EMC Centera

07/2001–07/2002

User administration

Deutsche Post AG / Renten Service, Köln

Project Manager · Business Analyst · Application Architect

Establishment of LDAP-based user administration, including authentication, authorisation and administration.

Show details Hide details

Solution

LDAP directory, schema, authentication, authorisation and web administration configured and put into operation.

Used in the project

Planning & collaboration
Jira, Microsoft Office
Development & operations
Java, CVS, TOAD
Cloud & data
Windows XP, HP-UX, LDAP, OID

05/1999–07/2001

Target-state design

Deutsche Post AG / Renten Service, Köln

Project Manager · Business process analysis · BPM

Develop target processes and application architecture for modernising pension administration, and support phased implementation across numerous project components.

Show details Hide details

Purpose

Current-state analysis, customer relationship analysis and target-state design for core business processes.

Responsibilities

Lead and play a key role in the target-state design; analyse the current state and customer relationships, and optimise structures and processes.

Solution

Current and target processes, application architecture, IT landscape plan and phased implementation approach.

Used in the project

Planning & collaboration
Microsoft Office
Analysis & modelling
Oracle Designer, ARIS, Visio
Development & operations
HTML
Cloud & data
Windows

06/1997–12/1997

Management control – Aristoteles PROBET / DIVA

Wayss & Freytag AG, Frankfurt / Hahn

Business Analyst

Analysis, alignment and integration of management control and management information systems.

Show details Hide details

Responsibilities

Project management and business process analysis; alignment and presentation of results, and preparation of decision papers.

Solution

Project and company data consolidated and aggregated for management control and management information.

Used in the project

Planning & collaboration
Microsoft Office
Analysis & modelling
ARIS
Cloud & data
Windows, Oracle, SAP

03/1997–12/1997

Construction estimating – Aristoteles KUBUS

Wayss & Freytag AG, Frankfurt / Hahn

Business Analyst

Analysis, customisation and integration of a system for construction estimating, tender preparation and project control.

Show details Hide details

Responsibilities

Analyse and design processes; agree and present adaptations, and prepare decision papers.

Solution

Adapted construction estimating and project delivery processes implemented and tested as a prototype at a pilot branch.

Used in the project

Planning & collaboration
Microsoft Office
Analysis & modelling
ARIS
Cloud & data
Windows, Oracle, SAP

01/1996–05/1996

Motor claims handling

HDI, Hannover

Business Analyst

Business process analysis and optimisation of motor claims handling in the context of electronic case files.

Show details Hide details

Responsibilities

Advice on methods and approaches, and business process analysis.

Solution

Core process for electronic document management developed; project planned and launched.

Used in the project

Microsoft Office, Windows, Oracle

09/1995–12/1995

Life insurance

Barmenia, Wuppertal

Business Analyst

Business process reengineering in life insurance, including customer relationship analysis and business process architecture.

Show details Hide details

Responsibilities

Advice on methods and approaches, and business process analysis.

Solution

Business process architecture and core processes developed; one core process detailed and results presented to the executive board.

02/1995–08/1995

Payroll workflow and archiving

Erzbistum Köln

Project Manager

Reorganisation of a payroll department handling around 38,000 personnel cases through a workflow and archiving solution.

Show details Hide details

Responsibilities

Business process analysis, project management and project control.

Solution

Electronic archiving and workflow system introduced, with scanning, indexing, distribution, search and integration with existing applications.

Used in the project

Microsoft Office, Windows, COSA Workflow, Novell

01/1990–12/1992

Project control

Deutsche Post / Telekom, Bonn

Project Manager

Review of project delivery across 14 major projects, each with implementation costs exceeding DM 40 million.

Show details Hide details

Responsibilities

Lead a working group of managers and specialists; define the approach, analyse, design and present.

Solution

Weaknesses investigated and a paper prepared for the executive board, with project-specific and cross-project improvement measures.

07/1988–10/1988

Integration of federal and state monitoring networks

Bundesministerium der Umwelt, Bonn / Köln

Systems Analyst

Design and effort estimation for integrating federal and state monitoring networks.

Show details Hide details

Responsibilities

Design, analysis and effort estimation.

Solution

Application concept developed for integrating federal and state monitoring networks for early detection of environmental disasters.