Denny Lorenz
Management Consultant Specializing in Regulatory Reporting
Experience
Jan 2022 - Present
2 years 7 months Nierstein, Germany
Management Consultant Specializing in Regulatory Reporting
DL Consulting
Oct 2022 - Dec 2022
3 months Germany
Business Consultant / Business Analyst for Abacus360 Implementation for WIFSta/FinStabDEV
SKS Unternehmensberatung GmbH & Co. KG
- Supported technical setup of the Abacus360 module
- Test planning and execution, defect analysis
Jul 2020 - Jul 2021
1 year 1 month Germany
Business Analyst / Solution Architect for Enhancements of ABACUS/DaVinci and Informatica Preprocessing
SKS Unternehmensberatung GmbH & Co. KG
- Handled risk reports: Own Funds, Leverage Ratio, Large Exposure, Asset Encumbrance
- Supported production issue resolution
- Assisted with ABACUS/DaVinci release upgrades (review release notes, derive business design)
- Developed business concepts (HGB integration of individual reports, adding new products like synthetic securitizations, implementing regulatory changes such as CRR II, SA-CCR, NPL)
- Analyzed legacy data flow via ABACUS/IRR (STAR) for migration to new HGB-based flow
- Test planning, execution and defect analysis (HP ALM)
- Supported product owner in sprint and release planning
Mar 2018 - Jun 2020
2 years 4 months Germany
Test Lead for Report Generation / Solution Architect for ABACUS/DaVinci and Informatica Preprocessing
SKS Unternehmensberatung GmbH & Co. KG
- Managed risk reports: Own Funds, Leverage Ratio, Large Exposure, Asset Encumbrance
- Created operational test plans
- Led the test team
- Reported test progress
- Prioritized test cases and defects
- Assisted test team with execution and defect analysis
- Developed and introduced a business data model
Nov 2017 - Feb 2018
4 months Germany
External Project Manager / Solution Architect for Regulatory Reporting IT Modernization Feasibility Study
SKS Unternehmensberatung GmbH & Co. KG
- Created operational project plans
- Managed the project team
- Reported project progress
- Analyzed and evaluated existing regulatory IT architecture
- Developed target architecture options
- Planned migration steps over a five-year period
- Produced effort estimates
Jun 2013 - Oct 2017
4 years 5 months Germany
Responsible for Production Launch of Statistical and Liquidity Reports via ABACUS/IRR
SKS Unternehmensberatung GmbH & Co. KG
- Managed statistical reports: foreign status, balance sheet stats, borrower stats, interest rate stats, DSGV stats, issue stats
- Managed liquidity reports: LCR/NSFR, LCR Delegated Act, Asset Encumbrance, Additional Liquidity Monitoring Metrics
- Allocated resources for statistical and liquidity reporting
- Created IT design documents (SDL adjustments; customizing ABACUS/IRR for SAP and STAR (CICO technology); customizing ABACUS/DaVinci)
- Designed architecture recommendations for data integration
- Conducted functional and integration tests in ABACUS/DaVinci
- Analyzed defects in ABACUS/IRR and ABACUS/DaVinci tests
- Launched ABACUS/IRR, ABACUS/DaVinci and ABACUS/LiMa into production
- Provided production support for statistical and liquidity reports (incident analysis, solution proposals, design updates)
- Supported all regulatory reporting activities for migration from Bank Analyzer 5.0 to 8.0
- Managed regulatory integration of LoanIQ with SAP Bank Analyzer 8.0, ABACUS/IRR and ABACUS/DaVinci
- Assisted overall IT implementation planning for ABACUS/DaVinci and Abacus360 subprojects
- Handled budgeting, controlling and management of up to 14 SKS resources
Nov 2011 - May 2013
1 year 7 months Germany
Subproject Lead ABACUS/IRR for ABACUS/DaVinci and International Regulatory Reporting Implementation
SKS Unternehmensberatung GmbH & Co. KG
- Planned and organized the IRR subproject
- Managed budget, controls and IT activities until rollout
- Developed business and IT designs (gap analysis; architecture decisions and design; SDL/RDL adjustments; customizing IRR connectors and STAR (CICO technology); migration and consolidation concepts)
- Implemented IT designs (SDL/RDL loading; IRR connector tweaks; STAR customizing)
- Conducted functional and integration tests in ABACUS/DaVinci
- Analyzed defects in IRR and ABACUS/DaVinci tests
- Launched ABACUS/DaVinci and ABACUS/IRR into production
Oct 2011 - Oct 2011
1 month Germany
Regulatory Reporting Department Coach and Report Verification under the Solvency Regulation
SKS Unternehmensberatung GmbH & Co. KG
Jun 2011 - Aug 2011
3 months Germany
Feasibility Study Lead for ABACUS/DaVinci Implementation at an International State Bank
SKS Unternehmensberatung GmbH & Co. KG
- Assessed current architecture
- Defined target architecture
- Prepared business case
- Created project structure and milestone plan
- Developed and described work packages for the upcoming implementation
Apr 2011 - Jun 2011
3 months Germany
Support for Regulatory Reporting Architecture Prestudy at an International State Bank
SKS Unternehmensberatung GmbH & Co. KG
- Assisted with regulatory reporting questions
- Assisted with SAP architecture questions
Feb 2011 - Aug 2011
7 months Germany
Subproject Lead for Report Generation Migration of Regulatory Reporting Analyzer (RRA) on OSPlus
SKS Unternehmensberatung GmbH & Co. KG
- Planned and organized the report generation subproject
- Managed budget, controlling and IT activities until rollout
- Ensured quality of business and IT designs
- Analyzed defects in RRA and SAMBAplus integration tests
- Deployed RRA and supported initial report generation
Jun 2008 - Jan 2011
2 years 8 months Germany
Subproject Lead for Regulatory Reporting Analyzer (RRA) Implementation under GroMiKV
SKS Unternehmensberatung GmbH & Co. KG
- Planned and organized the report generation subproject
- Managed budget, controlling and IT activities until rollout
- Conducted gap analysis in RRA and Source Data Layer for data requirements of GroMiKV and summary sheet processing via RRA
- Developed business and IT designs
- Conducted functional and integration tests
- Analyzed defects in RRA and SAMBAplus tests
- Deployed RRA and supported initial report runs
Oct 2007 - Oct 2007
1 month Germany
Support for SAMBAplus/Basel II Consolidation and PC Conversion Program (CONVERT) Commissioning
SKS Unternehmensberatung GmbH & Co. KG
- Configured SAMBAplus/Basel II at group level (parameters, utilities, control cards, consolidation config)
- Integrated PC conversion program CONVERT for non-SAMBAplus entities to support consolidation
- Tested consolidation via SAMBAplus/Basel II
Jul 2007 - Jul 2007
1 month Germany
Support for SAMBAplus/Basel II Consolidation at a Commercial Bank
SKS Unternehmensberatung GmbH & Co. KG
- Configured SAMBAplus/Basel II at entity and group level (reporting units, parameters, utilities, control cards, consolidation and rating config sheets)
- Documented parameter settings
- Tested configurations
Feb 2007 - Dec 2016
9 years 11 months Germany
Product Manager for SKS Standard Software CONVERT
SKS Unternehmensberatung GmbH & Co. KG
- Adapted PC conversion program CONVERT for Basel II, ECB 2010 updates and CRD II/III/IV for integrating consolidating entities with various regulatory software (ABACUS/DaVinci, BAIS, SAMBAplus)
- Built relevant Excel sheets with base formulas
- Created validation rules within and across reporting forms
- Analyzed import/export interfaces of key software
- Designed conversion logic for import interface (Convert.xls; C++)
- Updated or created documentation
- Conducted technical and business testing
Oct 2006 - Jun 2008
1 year 9 months Germany
Support for Basel II (Pillar 1 – SA) Project with Fernbach Software Modules
SKS Unternehmensberatung GmbH & Co. KG
Sep 2006 - Apr 2008
1 year 8 months Germany
Business and IT Specification for Risk Rating Calculation (SA) at a Commercial Bank
SKS Unternehmensberatung GmbH & Co. KG
Aug 2006 - Jan 2007
6 months Germany
Designed Consolidation of Banking and Financial Holding Groups under New Solvency Regulation and KWG
SKS Unternehmensberatung GmbH & Co. KG
Aug 2006 - Jan 2007
6 months Germany
Optimized Electronic Regulatory Reporting (KWG Reports) in SAMBAplus at Entity and Group Level through Integration
SKS Unternehmensberatung GmbH & Co. KG
Jul 2006 - Dec 2008
1 year 6 months Germany
Data Mapping Support for SAMBAplus/Basel II at a Major Bank
SKS Unternehmensberatung GmbH & Co. KG
Jun 2006 - Jun 2006
1 month Germany
Implemented SAMBAplus Consolidation of Summary Sheet Reports at a Commercial Bank
SKS Unternehmensberatung GmbH & Co. KG
Apr 2006 - Jun 2006
3 months Germany
Implemented SAMBAplus Consolidation of Summary Sheets and GroMiKV Reports at a Commercial Bank
SKS Unternehmensberatung GmbH & Co. KG
Feb 2006 - Dec 2022
16 years 11 months Germany
Senior Manager, Authorized Signatory
SKS Unternehmensberatung GmbH & Co. KG
Feb 2006 - Mar 2006
2 months Germany
Internal Project: Developed Business Concept for “Disclosure Requirements for the German Banking Sector”
SKS Unternehmensberatung GmbH & Co. KG
Feb 2006 - Mar 2006
2 months Germany
Research, Analysis and Documentation of Historical International Rating Parameters - State Bank
SKS Unternehmensberatung GmbH & Co. KG
Summary
- Regulatory reporting expert for over 16 years
- Business and IT design, interface architect, test and project management
- Bank statistics and supervision, especially Own Funds, Liquidity Regulation, LCR/NSFR, ALMM, AE, balance sheet and borrower statistics, as well as Large Exposure, million credit reports, WIFSta/FinStabDEV
- ABACUS/DaVinci, ABACUS/IRR, ABACUS/LiMa and Abacus360
Languages
German
Native
English
Advanced
Education
Oct 2000 - Jun 2006
University of Leipzig
Diplom-Kaufmann (equivalent to Master in Business Administration) · Business Administration · Leipzig, Germany
Certifications & licenses
Product Owner
Maxpert GmbH
Scrum Master
Maxpert GmbH
Associate’s Certificate in Project Management
George Washington University
The New GroMiKV SAMBAplus
BearingPoint
Regulatory Reporting Specialist
Frankfurt School of
Similar Freelancers
Discover other experts with similar qualifications and experience