Lead Business Functional Analyst

Business analysis and project management for IT projects

• Project management and business analysis in migration projects
• Test coordination, execution, and documentation
• IT change management with ServiceNow
• Task management for migration projects with JIRA
• Concept validation and technical testing for migration projects
• Database management (MS Access, Oracle, SQL Server)
• Job management (Control-M, PowerShell, SFTP interfaces) to define automated data flows for migrated applications/systems
• Documentation with Confluence
• Support for disaster recovery setup and tests
• IT asset ownership advisory
• IT environment: SAP R/3, SAP HANA, GCP Cloud, ServiceNow, IBM UrbanCode Deploy, JIRA, Confluence, HP ALM, Control-M, SQL Server, Oracle, MS Access, Git, Bitbucket

End-to-end business analysis for IT roadmap projects. Coaching and advising on:

• Analysis and design of data management and business processes
• Documentation of systems, interfaces, and processes
• Liaison between initiatives and Scrum implementation teams regarding requirements
• Gathering requirements for various initiatives with stakeholders (storytelling)
• Documenting requirements as user stories following the INVEST principle
• Preparing user stories for Scrum teams
• Considering and evolving the existing UX/UI concept
• Presenting user stories in refinement sessions
• Preliminary approval of user stories after delivery by Scrum teams
• Coordination with IT portfolio project management and business/IT architecture

Selected IT projects (initiatives):

• Project 1: Yield management integration with Microsoft Dynamics CRM, microservice, Power Automate, RabbitMQ, ERP: Lead IT business analyst for three development teams (internal scrums + external team) and business unit (analysis, design, advice, documentation on requirements, data, interfaces, etc.)

• Project 2: Integration of the supplier management system JAGGAER and ERP carve-out (monolith to microservice architecture and Angular front end): Lead IT business analyst/project manager for development team, JAGGAER support team, and business units

• Project 3: Support for LeanIX integration (enterprise architecture management)

• Project 4: Documentation of IT systems (including Microsoft Dynamics CRM)

• Project 5: Support for digitalizing mobile services & backlog management

• Project 6: Establishing business analysis processes and tasks

• Project 7: Implementation of various user stories (ERP adjustments)

• Project 8: Analysis of managing GeoFences (GeoJSON)

• IT environment: Confluence, JIRA, MIRO, FIGMA, LeanIX, JAGGAER, Microsoft Teams, Planner, Office, Visual Studio, Postman, Zephyr, GitLab, Bitbucket, SQL Server, UML, BPMN, Scrum, Kanban, microservices, SAP S/4HANA, data formats (JSON, Protobuf, CSV), RabbitMQ, Angular front ends, AWS, Azure, Microsoft Dynamics 365 CRM, Microsoft Access, etc.

Design, develop, and integrate business IT systems (PMS, DWH, DMS, BI)

• Requirements analysis, consulting, and design (IT concept, cloud technologies, portfolio management system, ERP, data warehouse, web front end, dashboards, and reporting)
• Create and maintain functional specs and IT concepts
• Application development with VBA (Excel, Access, SQL Server)
• Project management
• Automate processes and interfaces (XML, CSV)
• Support system selection (virtual data rooms, document management systems, data centers/clouds)
• Support system integration of Otris DMS
• Documentation and user training
• Data analysis and modeling
• IT environment: Excel, Access, VBA (ADO, SQL), XML, Easy/Otris DMS, Visio (UML, BPMN), cloud, SQL Server, C#.NET, web technologies

Aladdin Green package integration:

• Replace vendor RiskMetrics for market risk with BlackRock Aladdin
• Adjust interfaces, applications, and reporting

Requirements engineering:

• Configure and test a .NET front end with abstraction and approval layer

• IT environment: SQL Server, T-SQL, Excel, SSRS, RiskMetrics, BlackRock Aladdin, Oracle, XML, HP ALM, dbClarity

• Derivatives reporting
• Data warehouse interfaces
• SQL Server 2005/2008 migration
• Data center relocation
• SQL Server jobs/Control-M migration
• Leverage calculation
• Onboarding US portfolios
• Various analysis tools and reporting
• IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, Control-M, SSIS, RiskMetrics, dbClarity

• UCITS IV/KID reporting system
• Liquidity risk system (RC Banken Liquidity Analyser, RiskMetrics)
• Backtesting monitoring & reporting tool
• Test, analyze, and evaluate a BI system (Armanta)
• Contribute to abstraction layer (expression layer, limit system, approval layer, stakeholder interface)
• Requirement specification
• Various analysis tools and reporting
• IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, Armanta, SSIS, RiskMetrics

• Regulatory monitoring & reporting solutions
• Time series upload process (Bloomberg/RiskMetrics)
• Onboarding APAC portfolios
• Dashboard
• Various analysis tools and reporting
• IT environment: SQL Server, Access, VBA, T-SQL, SQL, XML, Oracle, SSIS, RiskMetrics, Bloomberg

• Integration of a reporting solution for fund fact sheets and monthly reporting
• Investment committee reporting
• IT environment: Quartal Flow, SQL Server

Developed an application to dynamically map multi-layered sales processes in an international corporate structure

• IT environment: Access, VBA, SQL

Optimized and extended a complex Access system landscape

• IT environment: Access, VBA, SQL