Birgit S.

Business Analyst, Requirements Engineer

Munich, Germany

Experience

Jan 2020 - Dec 2024
5 years

Business Analyst, Requirements Engineer

M-net (Telecommunications)

As a Business Analyst and Requirements Engineer in a Scrum team, I supported the Product Owner with epic and feature refinement as well as coordination with the business units. The project language was mostly English.

  • Projects:

  • Increase of customer self-service in the portals: To relieve customer service, the level of self-management for contracts, customer master and billing data in the customer portal and via the M-net hilft app was increased. The login was also secured using Keycloak and a second factor.

  • Order flows: Various new features were added to the existing order flows. This included creating a process for special discounts and implementing data collection and exchange mechanisms with expansion partners like Telekom.

  • Data protection topics: Design of the overall architecture for a system for secure customer identification, overall concept for an email verification system, concept and data model for a central system to manage contacts, and concept for implementing consumer protection according to TKMOG.

  • Product catalog: Creation of a unified, company-wide product catalog to avoid duplicate maintenance. The design, modeling, and configuration of this catalog as well as the analysis of all business processes were part of the task. The interfaces are based on the TMF standard.

  • Design of an IT-supported process in order management: Development of a process to inform affected customers about the gradual shutdown of old copper lines by TELEKOM (TAL connections) and to provide information on alternative connection options.

  • Tasks:

  • Analysis responsibility for various cross-system initiatives, creating the solution concept and architecture.

  • Epic and feature refinement and writing user stories.

  • Analyzing the impact of new requirements on business processes in the business units and the IT systems.

  • Coordination and alignment of the required measures across all stakeholders, both internal and other external service providers.

  • Participation in the development of a future authorization concept for the customer portal using Keycloak with extended user registration options.

  • Data analysis on the Oracle database with SQL.

  • Support in testing and providing test data.

  • Design of future end-to-end processes.

  • Technologies and interfaces:

  • Tools used: JIRA, Confluence, SQL, PLANTUML.

  • Interfaces: WITA, WBCI, DHL returns, ICCS, Salesforce.

Jan 2019 - Dec 2019
1 year

Business Analyst, Requirements Engineer

Loyality Partner Solutions (End customer: Deutsche Bahn Long-Distance)

Further development of the DB loyalty program. The management of BahnCard contracts and the Bahn-Bonus program at DB Long-Distance was refined and tailored to the more individual needs and buying behavior of customers. This required various extensions to the existing applications. In addition, customer management was handed over to another data master (VENDO KTO), for which various mechanisms for bidirectional data exchange were created. A new system became the master for customer master data. For the existing contract management system for BahnCard and Bahn-Bonus, new functionalities for bidirectional synchronization were created. To support migration, inconsistent states that prevented customer deletion were cleaned up to reduce the migration volume. Regardless of the new customer data master, existing loyalty applications were optimized and personalized. In addition, deletion mechanisms for customer master data were developed in accordance with GDPR.

  • Role:

  • Business Analyst, Requirements Engineer in a Scrum team.

  • Supporting the Product Owner with epic and feature refinement and alignment with the customer.

  • Tasks:

  • Epic and feature refinement of requirements.

  • Writing user stories.

  • Data analysis on the Oracle database with SQL.

  • Optimizing campaign management processes in SIEBEL for active customer outreach by mail or email and for outreach at other touchpoints.

  • Tools:

  • Confluence, JIRA, HP ALM, Oracle, SIEBEL tools, SIEBEL interface, ARCWAY.

Jan 2018 - Dec 2018
1 year

Business Analyst, Requirements Engineer

Automotive (BMW)

  • Integration of a group-wide customer master data system (GCDM)

  • The global group-wide BMW customer master data system GCDM was further developed and integrated into the heterogeneous system landscape. International "customers" like market-specific apps connect to this application for data exchange.

  • Extensions of the central system were designed (e.g., data model extensions, integration of OpenID Connect, additional plausibility checks and error states).

  • Connected applications were advised on an optimal strategy (intranet vs. internet, guidance on creating and using email templates via Apache Velocity, use of standard components).

  • To ensure stability, full interface contracts were emphasized, i.e. an exact description of the integration, the services used, and the data volumes.

  • Tasks:

  • Advising customers on the optimal connection to the system.

  • Configuring the integration of applications.

  • Functional design of feature extensions, writing feature descriptions and user stories in coordination with the client's requesting departments.

  • Sub-project management in terms of cost clarification, schedule monitoring, risk assessment, and coordination of all involved areas.

  • System environment and methods:

  • Web architecture, JIRA, Confluence, Apache Velocity, CURL, Scrum, OAuth2, XML, json. The project language was English.

Jan 2017 - Dec 2018
2 years

Business Analyst, Requirements Engineer

Automotive (BMW)

  • Requirements analysis for and migration to a new CRM system

  • The 15-year-old, self-developed BMW CRM system "Top Drive" was to be replaced by a modern system (Salesforce).

  • The goal was to gain a 360º view of the customer and use new technical possibilities for implementing campaigns and optimizing processes in external agencies.

  • The high-level requirements defined for the new system were detailed to give them a use-case character, taking GDPR requirements into account.

  • ADOBE Campaign was to be used for campaign management.

  • Tasks:

  • Refining requirements for a new campaign management system.

  • Documenting the as-is processes in the supporting external agencies for running campaigns across different channels.

  • Functional specification of migration rules.

  • Analysis of the around 40 interfaces to be connected to the new CRM system, including how they will be integrated and any potential limitations on access rights at the business object level.

  • System environment:

  • Salesforce, ADOBE Campaign.

Jan 2016 - Dec 2017
2 years

Business Analyst

Bank

  • Quality assurance of migration for real estate financing software

  • A bank developed a new system for real estate financing, and existing data was migrated. The migration result had to be accepted by the affected institutions.

  • Designing and developing reports to ensure the completeness and correctness of the migration.

  • Coordinating the required evidence for acceptance with the affected institutions.

  • The acceptance criteria were defined together with the client, based on errors found during migration and a comparison of source to target data, including a gap analysis.

  • Tasks:

  • Creating reports for object comparison, including checking foreign key relationships.

  • Developing reports to comprehensively show all error situations for a business object.

  • Creating statistical reports by error scenario and visualizing them.

  • Defining and aligning the acceptance criteria.

  • System environment:

  • DB2, ORACLE, Clover ETL, Jasper Report, Scrum.

Jan 2012 - Dec 2016
5 years

Business Analysis, solution design, functional project management

Insurance (BG-Phoenics – IT service provider of BG BAU)

  • Various business analysis tasks / continuation of solution areas from „Data Quality Assurance“**

  • Creation of various functional specifications in the partner area, especially further development of the duplicate merging features.

  • Optimization of master data maintenance and search in the partner area to reduce new partner duplicates.

  • Development of mechanisms for targeted detection of emerging partner duplicates.

  • Design of various improvements to the existing system and consulting of departments on data quality guidelines.

  • Prefeasibility project „Data Quality Assurance“**

  • Uncovered weaknesses in the existing software solution leading to data quality issues.

  • Created a concept to eliminate the weaknesses, including defining an improved target state and reviewing processes in the departments.

  • Migration to SEPA**

  • Functional concept for converting bank accounts and previous direct debits to meet SEPA requirements.

  • Functional analysis of current data, testing of account converters, coordination with SWIFT and development of an implementation concept for SEPA core mandates.

  • Cleanup of partner and address data**

  • Analysis of how partner duplicates arose due to migrations and daily operations.

  • Developed a concept to eliminate redundancies and reduce future duplicates.

  • Cross-functional tasks:**

  • Various data cleanups, creating functional specifications for the duplicate merging ruleset.

  • Designing stricter plausibility checks, integration of externally provided partners, improving data import.

  • Software selection for a successor product for duplicate detection.

  • Concept for slimming down search results and mechanisms for semi-automated duplicate cleanup.

  • System environment:**

  • AIX, DB2, ACCESS, Innovator, ADONIS, Shell scripts, SQL (including stored procedures), paint.net, UNISERV Click-IT.

Jan 2009 - Dec 2012
4 years

Business Analyst, solution design, functional sub-project leadership

Insurance (BG-Phoenics – IT service provider of BG BAU)

  • Replacement of legacy systems after merger**

  • Solution design and sub-project leadership for migrating various legacy systems from previously independent institutions to a common Java-based target system.

  • Simultaneous setup of an archive system for non-migrated data.

  • Tasks:**

  • Functional analysis of current data and clarification of existing business processes in the members and contributions area in close coordination with the departments.

  • Identification of problem areas regarding the discrepancy between current and target data (gap analysis).

  • Development of functional solutions to assess and improve the quality of existing data sources.

  • Definition of transfer rules („mapping“) to the target and archive systems.

  • Preparation of decision papers regarding migration scope, effort, and risk assessment.

  • Implementation of migration rules via ETL, SQL and shell scripts.

  • Analysis of non-migrated data.

  • Setup of the archive system in coordination with the departments.

  • System environment:**

  • AIX, DB2, ACCESS, Innovator, ADONIS, DataStage, Shell scripts, VBA.

Jan 2003 - Dec 2009
7 years

Business Analyst, solution/system design, data modeling, sub-project leadership, implementation

IT service provider

  • Data and base architecture for a payroll system**

  • Solution and system design as well as sub-project leadership for a large-scale database migration for a major industry IT service provider.

  • Migration of a payroll system based on block VSAM processing to DB2.

  • The goal was to reduce redundancies, fully historized storage and the creation of a payroll archive (DB2) for better management and analysis.

  • The architecture was made flexible through a metadata-triggered table control of the transformation, making the system almost maintenance-free.

  • Generators for access modules helped reduce maintenance costs.

  • Tasks:**

  • Preliminary study for the migration of batch payroll processing considering performance and security aspects.

  • Solution design for master data storage, including migration rules.

  • Weakness analysis of existing data structures.

  • Data modeling of the new normalized structures for the payroll system with Rational Rose (approx. 500 entities).

  • Physical DB design of the archive database.

  • Design and partial implementation of an access and transformation layer.

  • Design of generators for standard database access modules.

  • Consulting, training and support of internal client staff.

  • Creation and implementation of additional solution designs (e.g. site concept, consolidated DÜ reports).

  • System environment:**

  • z/OS, DB2, VSAM, Rational Rose, COBOL, C, VBA.

Jan 2001 - Dec 2003
3 years

Project management, consulting, data modeling, design

Bank

  • Extensible, multi-tenant architecture for a business partner data system**

  • Solution and system design for extending the central business partner data system after several mergers to meet data protection requirements.

  • For flexibility, business processes and their sequence were stored as state transitions in a parameter database, which the application uses to control screen flow and validations.

  • Tasks included reverse engineering of the data model, uncovering discrepancies and model optimization, as well as design and implementation of improvements. (System environment: OS/390, COBOL, DB2, ErWin).

  • Company-wide replacement of legacy address data**

  • Consulting and project management for a migration from VSAM to DB2 to reduce data redundancies.

  • VSAM legacy accesses were replaced in all software systems by accesses to the new operational DB2 business partner database.

  • Tasks included development of roll-out and fallback strategies, consulting on contingency mechanisms, coordination of dependencies, optimization of accesses, and data analyses and cleanups. (System environment: OS/390, DB2).

  • Replacement of a business partner data application**

  • Developed a replacement strategy and project managed to reduce maintenance effort by decommissioning the host application of a C/S and host application.

  • Tasks included analysis of functional deltas, analysis of business processes, a technical feasibility study, and development of a replacement strategy.

Jan 2000 - Dec 2001
2 years

Project management, design, process modeling

Insurance

  • WAN broadcast tool for timely user notifications during outages**

  • Project management of a feasibility study for providing a LAN-based broadcast tool for WAN use by field agencies. Tasks included technical coordination with network specialists and functional coordination with support teams.

  • Web application to increase efficiency of hardware swap service**

  • Project management and design of a Lotus Notes–based application to reduce the time from reporting a defect to hardware replacement for field agencies. Tasks included designing the user interface and data structure, and managing the external implementation vendor.

  • Central software distribution processes**

  • Project management and process modeling for a system for automatic software distribution to field agencies. To ensure a fast and secure restart after outages, precise operating processes, especially for problem management, were defined. Tasks included defining processes for problem and change management and delivering training. (System environment: ADONIS, MS Project).

  • Building a server farm for the intranet**

  • Project management and process modeling for connecting independent field agencies to the intranet via a server farm in the DMZ. Because of the security-critical position, high importance was placed on security management processes. Tasks included defining operating processes (problem, change, security management), setting service level agreements, and designing control mechanisms and training. (System environment: ADONIS, MS Project).

Summary

  • Business analysis
  • Requirements engineering
  • Product ownership
  • Business process analysis and modeling
  • Use case modeling
  • Data modeling
  • Defining interfaces between systems
  • Modeling functionalities
  • Database design (DB2 specialized know-how)
  • Planning
  • Monitoring (time & budget)
  • Reporting
  • Quick and effective onboarding to new business and technical tasks
  • Strong analytical thinking
  • High abstraction skills
  • Very good understanding of IT applications (source code)
  • Very good presentation and communication skills, especially with customer business units
  • Very good knowledge of GDPR and other data protection regulations

Languages

German
Native
English
Advanced
French
Intermediate

Education

Lorem ipsum dolor sit amet

Diploma · Computer Science

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