Benedikt T. - Actuarial Analyst

Go to Website

Münster, Germany

Experience

Jan 2023 - Present

2 years 10 months

Germany

Actuarial Analyst

Standard Life

developing realization concepts based on given technical business plans and actuarial requirements
testing the changes made to the policy administration system
performing individual actuarial calculations
carrying out portfolio and system corrections

Jan 2022 - Jul 2022

7 months

Germany

Actuary Portfolio Migration

Viridium Group

supporting a portfolio migration to msg.Life Factory
reconciling balance sheets (FB 100) between old and new systems at contract, tariff and portfolio group levels
checking code mapping at the contract level using SQL
technical implementation using SQL procedures in SAP HANA DWH (versioning with git)
preparing analysis results for approval by business decision makers

Oct 2018 - Dec 2021

3 years 3 months

Germany

Risk Controlling and Actuarial Mathematics

Ärzteversorgung Westfalen Lippe

developing and analyzing business requirements for actuarial mathematics and risk modeling for technical implementation
assessing technical feasibility of actuarial topics
monitoring regulatory developments (especially Solvency II and ABV) and updating the risk model
point of contact for RisCo2 and mapping of the internal risk model and ABV stress test in RisCo2
designing various Excel tools using VBA macros
introducing a SQL database for storing discretionary actuarial data
configuring the standard software RisCo2 for risk capital calculation, risk bearing capacity, limit utilization and documentation of calculations
designing, implementing, testing and conducting stress tests and scenario analyses
evaluating calculations via SQL queries from the RisCo2 database and reviewing the standard risk report
creating a customizing specification for risk reporting via RisCo2 as a Word report including ESG risk data
further development of RisCo2 for ÄVWL and representation at user meetings
migrating the discretionary database of policy portfolios from Access to MS SQL Server including manual adjustments, testing and optimizing SQL queries
technical design, implementation, testing and introduction of a fund database via MS SQL Server with Excel/VBA interface and dashboard reporting
creating and maintaining a credit monitoring database for loan project business and integrating it into monthly reports
developing an analysis tool for Excel file linking for interface definition
compiling emerging risks for ÄVWL
submitting data to the actuarial expert and validating the calculation of technical provisions in C#
supporting the introduction of a new policy administration system and options to adjust the discount rate
reviewing and updating the technical business plan in collaboration with the actuarial expert
daily reports on special securities funds, monthly risk controlling reports and a semi-annual risk report to management and committees
year-end closing activities and validation of external fund data
updating and improving the internal risk model, risk manual and process modeling
high-level concept for transferring key process risks to GBTEC Cloud from RisCo2
creating and analyzing the claims database in RisCo2
inputs for the annual asset-liability management study and proposal for profit distribution
ensuring compliance with regulatory requirements

Jul 2016 - Sep 2018

2 years 3 months

Germany

Actuarial Consultant

ERGO Group AG

advising the life insurance departments on operational and strategic challenges
maintaining the journal and account management modules for life insurance
maintaining the actuarial modules for legacy Victoria tariffs
creating high-level and detailed business concepts and technical implementation
developing, testing and introducing IT systems as well as performing system corrections in the release process
analyzing existing business requirements and business plans for technical implementation
identifying affected portfolios using complex SQL queries and manually calculating actuarial adjustment values
point of contact for the change process for introducing the ITIL standard
application development on mainframe using TSO ISPF, RD/z, JCL, DB2, ENDEVOR, QMF, Rochade, FileAid and XFR

Jun 2012 - Jun 2016

4 years 1 month

Germany

Pension Actuary and Corporate Pension Consultant

AON AG

preparing actuarial reports on pension, anniversary and phased-retirement commitments for SMEs up to DAX corporations
advising on restructuring company pension schemes and revising pension commitments
point of contact in the international network for consolidation of group financial statements in the corporate pension area
advising on accounting for pension obligations under StGB, HGB, FAS and IAS
preparing forecast calculations based on scenario specifications

Summary

very good insurance and financial mathematics knowledge
Actuary (DAV), CERA (DAV)
proficient in several database and programming languages (SQL (+++), VBA (+++), R (+++))
very good Excel/VBA skills
team player, committed, responsible
over ten years of experience as an actuary
continuous professional development