Ronny H. - Business Analyst | Product Owner | Developer

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 the data into the existing BI model (extending the star schema to a galaxy schema) to create 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 core systems and consolidation into the new reporting environment
Provision of the data in a BI model (star schema) for the funding committee report and the business development report (e.g. new business, refinancing, portfolio, exits, write-offs) and implementation of the necessary software
Establishment of an automated information dashboard and providing information for ad-hoc analyses
Data quality assurance by reconciling the core systems
Knowledge transfer to department staff (SQL database, Power Pivot, DAX)

May 2022 - Present

3 years 8 months

Germany

Lorem ipsum dolor sit amet

Industriekunde Metall

Conducted a requirements analysis and followed up with the implementation to establish a new tool/system in sales controlling and procurement on the topic of "Metal Management"
Created a preliminary study document as a decision basis for the next steps, including technology consulting
On-premise implementation of the solution chosen by the customer
Implementation project using agile project management as a liaison between the software provider and the customer
Visualization using Power BI Desktop in the Power BI Server environment

Jan 2022 - Dec 2024

3 years

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

ETL processes, data modeling, analysis, and visualization of calculated interest rate sensitivities/sensitivity measurement in the portfolio
ETL processes, data modeling, analysis, and visualization for cross-product portfolio reporting, including history functionality for capital markets and municipal financing
Integration of ESG data from various external providers (MSCI, ISS) and linking it with the capital markets business portfolio
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

Preliminary study to analyze the optimization potential of the "Neartime Sensitivity Measurement" tool in the capital markets area
Creation of a functional concept and prototype development based on the front office system (standard sensitivity functionalities) and optimized use of the existing sensitivity tool
Improved transparency of results and increased calculation speed
Preliminary study as a technical basis to support the decision on using BI tools for standard and ad-hoc reporting in the capital markets area
Creation of a functional concept and agile development of a BI solution using Microsoft technology (Microsoft Business Intelligence, Power BI, Front Arena)

Mar 2020 - Jan 2021

11 months

Lorem ipsum dolor sit amet

International Commercial Law Firm

Review existing product backlog
Define new and refine existing functional, technical, and non-functional requirements
Define acceptance criteria
Analyze import/export functionality of existing standalone solutions
Develop business rules to identify relevant data sets
Identify and document test cases
Develop test management for UAT
Create complex SQL queries and extract data dumps
Develop strategies to improve data quality in existing database solutions
Perform 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

Create system and process documentation and data center concepts to meet external audit requirements for data backup strategy, disaster recovery test documentation, data protection policies, technical operations manuals, and emergency recovery process
Implement company-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

Create system and process documentation according to ITIL standards for the custom software developed to support loan administration and asset management services
Analyze business processes and model processes for loan administration and asset/loan portfolio management
Create system documentation, user manual, 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 10 months

Germany

Lorem ipsum dolor sit amet

Medical Technology Service Provider

Requirements analysis
Data modeling
Database development
Data migration
Windows desktop application development
Report development
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
Create user stories and maintain the product backlog
Data modeling: functional design and implementation support
Design and implementation support for BI model
Design and implementation support for reports
Prioritize and align business and technical topics with the asset manager
Conduct workshops
Training, documentation, and handover to operations
Technologies: Microsoft SQL Server, Microsoft Analysis Server, Microsoft Reporting Server

Jan 2016 - Dec 2017

2 years

IT Analyst/Business Analyst

Service IT in the Processing Operations Company

Analysis of current systems vs. current processes in administrative operations
Mediator function between the business unit, internal IT, and IT provider
Clarification of archiving requirements
Review and formal 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 assessment tool to determine the tax-based 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 various credit structures (e.g., term loans, revolving facilities, project finance)
Development of the tool based on an MS SQL Server architecture and integration of a Bloomberg market data feed
Repeated 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 the documentation of the valuation methodology
Derivation of discount curves for credit risk using Bloomberg Curve Builder and documentation
Modeling of discount curves and assignment 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 bank processes versus international banking standards
Development of an action catalog and initiation of implementation

Jan 2012 - Dec 2013

2 years

Business Analyst

International Business Process Outsourcing (BPO) Landesbank active in credit

Contribution to the business case
Functional design and assurance of credit analysis, credit rating, and credit monitoring services
Customization of software packages to customer needs
Technologies: .NET application, MS SQL Server, Cognos

Jan 2008 - Dec 2010

3 years

Business Analyst/Quant Analyst/Senior Financial Engineer

International Landesbank engaged in Active Credit Portfolio Management

Preparation of portfolio analyses and periodic 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 establishment of various credit portfolio management activities
Definition, implementation, and monitoring of transaction-specific KPIs to ensure an adequate portfolio structure, considering risk/reward aspects and capital consumption
Improvement of tradability/liquidity of the credit portfolio
Proactive management inputs 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

Regional bank active in international credit portfolio management

Initial design and ongoing development of the Early Warning System (EWS) to detect credit deterioration in the overall bank portfolio
Support for implementation
Test management and documentation
Operational role: Preparing portfolio-related analyses for individual and portfolio risks, including market parameters/market data
Operational role: 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

Regional bank active in international asset securitization and credit derivatives

Administration of trade receivable asset-backed transactions for corporate clients
Conceptual design, setup, and development of a credit derivatives data warehouse with a web-based frontend
Planning and development of a front-to-back office system (MS Access) to manage credit derivatives (CDS, basket CDS, TRS) and linking with data providers (Bloomberg, Reuters) and internal business data
Creation of IT specifications, tests, 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 know 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 can optimally support both business and technical requirements.

I have supported numerous projects for process digitization and automation and worked closely with business units to implement tailored solutions. With solid analysis and optimization skills, I can quickly understand specific requirements and implement them efficiently.