Ronny H. - Business Analyst/Product Owner

Go to Website

Langenfeld, Germany

Experience

Mar 2025 - Jun 2025

4 months

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

Extraction and transformation of relevant data from the SAP system developed for the bank and consolidation into the existing reporting environment
Integration of data into the existing BI model (extending the star schema to a galaxy schema) for the funding committee report and the business development report
Data quality assurance
Knowledge transfer to department staff (SAP, SQL database, Power Pivot, DAX)

Dec 2023 - Apr 2024

5 months

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

Extraction and transformation of relevant data from the bank's leading systems and consolidation into the reporting environment to be built
Providing data in a BI model (star schema) for the funding committee report and the business development report (including new business, follow-up financing, portfolio, exits, write-downs) and implementing suitable software
Establishment of an automated information dashboard and providing data for ad-hoc analyses
Data quality assurance by reconciling leading systems
Knowledge transfer to department staff (SQL database, Power Pivot, DAX)

May 2022 - Present

3 years 5 months

Germany

Lorem ipsum dolor sit amet

Industriekunde Metall

Conducting a requirements analysis and implementing a new tool/system in the sales controlling and material purchasing area for "Metal Management"
Creating a preliminary study document as a decision basis for the next steps, including technology consulting
On-premise implementation of the solution chosen by the client
Delivery project using agile project management as a bridge between the software provider and the client
Visualization using Power BI Desktop within the Power BI Server environment

Jan 2022 - Dec 2024

3 years

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

ETL process, data modeling, analysis, and visualization of calculated interest rate sensitivities / sensitivity measurement in the portfolio
ETL process, data modeling, analysis, and visualization for cross-product portfolio reporting, including historical functionality for capital markets and municipal financing
Integration of ESG data from various external providers (MSCI, ISS) and linking with the business portfolios of the capital markets division
Creation of interactive dashboard visualizations and reports
Application of agile project management methods
Technologies: Automic, GitLab CI/CD pipeline, Microsoft SQL Server, Microsoft Integration Services, Microsoft Analysis Services, Microsoft Power BI Server, Power BI Desktop

Dec 2020 - Sep 2021

10 months

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

Feasibility study aimed at analyzing the optimization potential of the "Neartime Sensitivity Measurement" tool in the capital markets division
Development of a functional concept and prototype based on the front office system (standard sensitivity functionalities) and optimized use of the existing sensitivity tool
Improving result transparency and increasing calculation speed
Feasibility study for the technical basis to support the decision on using BI tools for standard and ad-hoc reporting in the capital markets division
Creating a functional concept and agile development of a BI solution using Microsoft technologies (Microsoft Business Intelligence, Power BI, Front Arena)

Mar 2020 - Jan 2021

11 months

Lorem ipsum dolor sit amet

International Business Law Firm

Reviewing the existing product backlog
Defining new and refining existing functional, technical and non-functional requirements
Defining acceptance criteria
Analyzing the import/export functionality of existing standalone solutions
Developing business rules to identify relevant data sets
Identifying and documenting test cases
Developing test management for UAT
Creating complex SQL queries and extracting data dumps
Developing strategies to improve data quality in existing database solutions
Performing automated data cleansing activities
Technologies: Microsoft SQL Server, Microsoft Azure

Nov 2019 - Dec 2022

3 years 2 months

Germany

Lorem ipsum dolor sit amet

Fintech Bank/Online-Broker

Creating system and process documentation, as well as data center designs, to meet external audit requirements for backup strategies, disaster recovery test documentation, data protection policies, technical operations manuals and emergency recovery procedures
Implementing an enterprise-wide password management software
Docker development concept
Business continuity management

Feb 2019 - Nov 2020

1 year 10 months

Germany

Lorem ipsum dolor sit amet

Loan Portfolio Servicer

Creating system and process documentation according to ITIL standards for the custom software developed to support loan administration and asset management services
Business process analysis and process modeling for loan administration and asset/loan portfolio management
Creating system documentation, user manuals, change management methodology, user help desk procedures and data processing and security process descriptions
Technologies: Microsoft SQL Server, Microsoft DevOps

Mar 2018 - Present

7 years 7 months

Germany

Lorem ipsum dolor sit amet

Medical Technology Service Provider

Requirements analysis
Data modeling
Database development
Data migration
Developing Windows desktop applications
Creating reports
Corporate website with feedback feature
Service report import from PDF format
Technologies: Docker, MySQL Server, VB.NET, MS Access

Jan 2018 - Jun 2018

6 months

Germany

Business Analyst/Product Owner

Pension Fund

Requirements analysis
Creating user stories and maintaining the product backlog
Data modeling: functional design and implementation support
Designing and supporting implementation of BI model
Designing and supporting implementation of reports
Prioritizing and aligning business and technical topics with the asset manager
Conducting workshops
Training, documentation, handover to business as usual
Technologies: Microsoft SQL Server, Microsoft Analysis Services, Microsoft Reporting Services

Jan 2016 - Dec 2017

2 years

IT Analyst/Business Analyst

Service IT in the Run-Off Operations Company

Analysis of current systems vs. current processes in administrative operations
Acted as mediator between the business unit, internal IT, and IT providers
Clarification of archiving requirements
Review and technical approval of IT system shutdown plans (shut-down concepts)
Technologies: Summit, LoanIQ, SAS

Jan 2013 - Dec 2017

5 years

Business Analyst/Project Coordinator/Test Manager

Service Company Credit Assessment - Balance Sheet Management

Functional design and concept of the credit valuation tool for determining the tax arm’s-length value of existing credit exposures for branches in Sydney, Singapore, Milan, Madrid, and London
Identification and definition of key valuation parameters for a variety of credit structures (e.g., term loans, revolving facilities, project financing)
Development of the tool based on an MS SQL Server architecture and integration of a Bloomberg market data feed
Recurring execution of credit assessments, ongoing calibration, and monitoring of portfolio-relevant credit risk drivers
Analysis and commentary on resulting value changes
Creation and review of documentation for the valuation methodology
Derivation of discount curves for credit risk using the Bloomberg Curve Builder and documentation
Modeling of discount curves and allocation to illiquid credit transactions
Presentation of results and portfolio developments to senior management and downstream decision-making bodies
Presentation and alignment of the model with external auditors and consultants
Technologies: Microsoft SQL Server, Bloomberg

Jan 2013 - Dec 2013

1 year

Business Analyst/Technical Project Lead

Slovenian Development Bank

Analysis of current processes in credit analysis, credit portfolio management, controlling/IT, and data warehouse
Conducting a gap analysis of internal banking processes versus international banking standards
Development of an action plan and initiation of its implementation

Jan 2012 - Dec 2013

2 years

Business Analyst

International Business Process Outsourcing (BPO) credit-focused state bank

Collaboration on business case
Functional design and ensuring services for credit analysis, credit rating, and credit monitoring
Customization of software packages to client needs
Technologies: .NET application, MS SQL Server, Cognos

Jan 2008 - Dec 2010

3 years

Business Analyst/Quantitative Analyst/Senior Financial Engineer

State Bank for International Active Credit Portfolio Management

Creation of portfolio analyses and cyclical reporting to the bank's committees
Establishment of a consolidated data repository through functional and technical planning and development of the ACPM credit portfolio analysis environment
Automation of information preparation
Bank-wide implementation of various credit portfolio management activities
Definition, implementation, and monitoring of transaction-specific KPIs to ensure an adequate portfolio structure, considering risk/return aspects and capital consumption
Improvement of the tradeability/liquidity of the credit portfolio
Proactive steering impulses from forward-looking portfolio analysis
Ensuring discipline in investments in client relationships and compliance with business and risk strategy
Technologies: ASP.NET, MS SQL Server, SAS

Jan 2004 - Dec 2007

4 years

Business Analyst/Quant Analyst/Senior Financial Engineer

State bank active in international credit portfolio management

Initial conception and ongoing development of the Early Warning System (EWS) for early detection of credit deterioration across the entire bank portfolio
Support for the implementation
Test management and documentation
Operational line tasks: preparation of portfolio-related analyses of single and portfolio risks including market parameters/market data
Operational line tasks: daily preparation of the management briefing (market overview)
Technologies: ASP.Net, MS SQL Server, SAS, Bloomberg, Reuters, MarkIT

Jan 2001 - Dec 2003

3 years

Project Manager/Business Analyst/Quant Analyst/Test Manager

State bank active in international asset securitization and credit derivatives

Administration of trade receivables asset-backed transactions for corporate clients
Design, setup, and development of a credit derivatives data warehouse with an internet-based frontend
Planning and development of a front-to-back office system (MS Access) to manage credit derivatives (CDS, basket CDS, TRS) and integrate with data providers (Bloomberg, Reuters) and internal business data
Preparation of IT specifications, test plans, and test documentation
Project management and reporting
Technologies: MS Access, SAS, Bloomberg, Reuters, proprietary systems

Summary

With over 25 years of experience in international finance projects, I understand the complexity of IT systems and their interfaces. As a bridge between business units and technical implementation, I have developed a deep understanding of successful digital transformations.

Thanks to my technical expertise in business intelligence and my experience in agile project management, I support both business and technical requirements effectively.

I have worked on numerous process digitization and automation projects, collaborating closely with business units to deliver tailor-made solutions. With strong analysis and optimization skills, I can quickly identify specific requirements and implement them efficiently.