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

Extracting and transforming relevant data from the bank's custom SAP system and consolidating it into the existing reporting environment
Integrating the data into the existing BI model (expanding the star schema to a galaxy schema) for the funding committee report and the business development report
Ensuring data quality
Transferring know-how to department staff (SAP, SQL database, Power Pivot, DAX)

Dec 2023 - Apr 2024

5 months

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

Extracting and transforming relevant data from the bank's core systems and consolidating it into the reporting environment being built
Providing the 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-offs) and implementing the appropriate software
Establishing an automated information dashboard and providing the information for ad-hoc analyses
Ensuring data quality by reconciling the core systems
Transferring know-how to department staff (SQL database, Power Pivot, DAX)

May 2022 - Present

3 years 6 months

Germany

Lorem ipsum dolor sit amet

Industriekunde Metall

Conducting a requirements analysis and implementing a new tool/system in sales controlling and material purchasing for "Metal Management"
Creating a preliminary study document as a basis for decision-making on next steps, including technology consulting
On-premise implementation of the solution chosen by the client
Carrying out the implementation project using agile project management as a mediator between the software vendor and the client
Visualizing data using PowerBI Desktop within the PowerBI 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 measurements in the portfolio
ETL process, data modeling, analysis, and visualization for cross-product portfolio reporting, including historization functionality for capital markets and municipal finance
Integrating ESG data from various external providers (MSCI, ISS) and linking it to the capital markets portfolios
Creating interactive dashboard visualizations and reports
Applying agile project management methods
Technologies: Automic, GitLab CI/CD pipeline, Microsoft SQL Server, Microsoft Integration Services, Microsoft Analysis Services, Microsoft PowerBI Server, PowerBI Desktop

Dec 2020 - Sep 2021

10 months

Germany

Lorem ipsum dolor sit amet

Förderbank Deutschland

Conducting a preliminary study to analyze the optimization potential of the "Neartime Sensitivity Measurement" tool in the capital markets division
Creating a functional specification and prototype based on the front-office system (standard sensitivity functionalities) and optimizing the use of the existing sensitivity tool
Improving result transparency and increasing calculation speed
Conducting a preliminary study to provide the technical basis for the decision on the use of BI tools for standard and ad-hoc reporting in the capital markets division
Creating a functional specification and agile development of a BI solution using Microsoft technology (Microsoft Business Intelligence, PowerBI, Front Arena)

Mar 2020 - Jan 2021

11 months

Lorem ipsum dolor sit amet

International Business Law Firm

Review of the existing product backlog
Definition of new and refinement of existing functional, technical, and non-functional requirements
Definition of acceptance criteria
Analysis of the import/export functionality of existing standalone solutions
Development of business rules to identify relevant data sets
Identification and documentation of test cases
Development of test management for UAT
Creation of complex SQL queries and extraction of data dumps
Development of strategies to improve data quality in existing database solutions
Execution of 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

Creation of system and process documentation as well as data center concepts to meet external audit requirements for data backup concept, disaster recovery test documentation, data protection policies, technical operation manuals, and emergency recovery process
Implementation of 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

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

Mar 2018 - Present

7 years 8 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 function
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
Creation of user stories and maintenance of the product backlog
Data modeling: business concept and implementation support
Design and implementation support of BI model
Design and implementation support of reports
Prioritization and coordination of business and technical topics with the asset manager
Conducting 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 Settlement Operations Company

Analyze current systems vs. current processes in administrative operations
Act as mediator between the business unit, internal IT, and IT providers
Clarify archiving requirements
Review and approve 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 Rating - Balance Sheet Management

Functional design and concept of the credit assessment tool to determine the tax arm's length value of existing credit exposures for branches in Sydney, Singapore, Milan, Madrid, and London
Identify and define the key valuation parameters for various credit structures (e.g. term loans, revolving facilities, project financing)
Develop the tool based on an MS SQL Server architecture and integrate a Bloomberg market data feed
Perform recurring credit assessments, ongoing calibration, and monitoring of portfolio-relevant credit risk drivers
Analyze and comment on resulting value changes
Prepare and review documentation of the valuation methodology
Derive discount curves for credit risk using Bloomberg Curve Builder and document them
Model discount curves and assign them to illiquid credit transactions
Present results and portfolio developments to senior management and downstream decision-making bodies
Present and align the model with external auditors and consultants
Technologies: Microsoft SQL Server, Bloomberg

Jan 2013 - Dec 2013

1 year

Business Analyst / Project Lead

Slovenian Development Bank

Analyze current processes in credit analysis, credit portfolio management, controlling/IT, and data warehouse
Conduct a gap analysis of internal banking processes versus international banking standards
Develop a catalog of measures and initiate implementation

Jan 2012 - Dec 2013

2 years

Business Analyst

State Bank active in International Business Process Outsourcing (BPO) for Credit

Support business case
Design and ensure delivery of credit analysis, credit rating, and credit monitoring services
Customize software packages to meet customer needs
Technologies: .Net application, MS SQL Server, Cognos

Jan 2008 - Dec 2010

3 years

Business Analyst / Quantitative Analyst / Senior Financial Engineer

State Bank engaged in International Active Credit Portfolio Management

Create portfolio analyses and cyclical reporting to the bank's committees
Establish a consolidated data repository through functional and technical planning and development of the ACPM credit portfolio analysis environment
Automate information preparation
Implement various credit portfolio management activities bank-wide
Define, implement, and monitor transaction-specific KPIs to ensure an adequate portfolio structure, considering risk/return aspects and capital consumption
Improve the tradability/liquidity of the credit portfolio
Provide proactive steering impulses from forward-looking portfolio analysis
Ensure discipline in investments in customer 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) to detect credit deterioration in the bank-wide portfolio
Support during implementation
Test management and documentation
Operational line tasks: creating portfolio-related analyses of individual and portfolio risks including market parameters/market data
Operational line tasks: daily creation 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 receivable asset-backed transactions for corporate clients
Design, setup and development of a credit derivatives data warehouse with web-based frontend
Planning and development of a front-to-back office system (MS Access) for managing credit derivatives (CDS, Basket CDS, TRS) and linking with data providers (Bloomberg, Reuters) and internal business data
Creation of IT specifications, test cases 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 optimally support both business and technical requirements.

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