Migration Generali Lebensversicherung

• Data deliveries from msg.Life Factory, msg.Commission, SAP BO, SAP FS-CD via a datawarehouse SAP S/4HANA into distribution systems of Generali and Deutsche Vermögensberatung AG by web services and daily file transfers
• Development of a SQL-script for the migration of accrued commissions from commission systems of Generali to msg.Commission

Technologies: SQL, BiPRO, GDV-Format
Systems: msg.Life Factory, msg.Commission, SAP BP, SAP FS-CD, SAP S/4HANA
Tools: Jira, Confluence

Website Beck-Online

• Implementation of website Beck-Online

Technologies: ASP.NET, C#, HTML, CSS, JavaScript, jQuery, SQL-Server
Tools: Visual Studio, Git, Bitbucket, Jira, Confluence
Working method: Scrum

Invoice Application

• Implementation of an invoice application using VB.NET following a legacy application in Visual Basic 6.0 and new requirements

Technologies: VB.NET, SQL-Server
Tools: Visual Studio, Git, Bitbucket, Jira, Confluence

Human Resources for Sales Representatives

• Agile Implementation of an application for maintaining personal data, calculation of payments and creating personalized letters

Technologies: Visual Basic, SQL, Access, Excel, Word

Gross Margins

• Development of an application for calculating gross margins per customer

Ranges

• Development of an application for calculating ranges per article

Technologies: Visual Basic, SQL, Access, Excel

Actuarial Practice / Fermat

• Implementation of an application for designing and documenting technical descriptions
• Initiation of a pension insurance for online sales
• Analysis and coordination of business requirements on insurance processes calling the actuarial core
• Writing technical drafts for calling the actuarial core in online-, client- and host-processes like calculation and dynamic increments of premiums and pensions, statutory equalization of pensions
• Ordering and coordination of development and test

Fund Management System

• Analysis of the business requirements on the fund management system for unit linked life and pension insurance policies
• Writing technical drafts for processing fund switch, fund shift, fund distribution, guarantee funds, closure of funds and customer information
• Testing of online-, client- and host-processes and support of testing in India

Tools: HP Project and Portfolio Management Center, HP Quality Center, DbVisualizer

Technologies: Visual Basic, SQL, Pega, Java, C

Working methods: Scrum, agile

Business Analysis for Clerical Medical Investment Group Ltd. Germany, Austria und Italy

• Analysis of funds and unit linked life and pension insurance policies
• Writing business and technical requirement specifications in terms of guarantee fund, insurance tax, money-laundering, sales portal, BiPRO
• Coordinating software development and test with an outsourcing partner in India

Technologies: Visual Basic, SQL, Access, Excel, Word

Quality assurance of commissions for life and pension insurance policies

• Consulting in introducing legal rules with respect to calculation of commissions for new business in connection with cancellation
• Definition of rules for new business in connection with cancellation
• Concept, development and test of an application for determining new business in connection with cancellation by determining temporal, personal and product relations between new business, cancellations and changes of policies and by regarding such relations in calculation of commissions and in allocation of policies to agents

Policy data

• Analysis, concept, development and test of an application to query policy data with access to host systems, with export to excel, with sums of policy data for one or several agents and with functionality for circulars

Contracts for agents

• Analysis of contracts for broker, exclusive agents and employed agents
• Concept, development and test of an application for writing contracts and supplements for agents with data transfer of agents data and commission data from an agents database

Calculation of compensations

• Analysis of current processes in calculation of compensations
• Concept, development and test of an application for calculating compensations according to the principles for the calculation of compensations (§ 89 b HGB) and the processing of the calculated compensations

Calculation of commissions

• Analysis of the current systems with respect to the calculation of commissions
• Concept, development and test of an application for calculating commissions based on an input file, with access to an agents database, with processing of the calculated commissions, with the ability of manual calculation or correction, with data transfer to the payment system

Mergers

• Analysis, concept and implementation of the adjustment of the applications above to the systems of the merged company following the merger of Generali Versicherungen and Volksfürsorge Versicherungen on 1.1.2009
• Consulting of Thuringia Versicherungs-AG during the merger with Generali Versicherung AG on 1.1.2003

Technologies: Visual Basic, SQL, Access, Excel, Word

Software Design for the "Man Machine Interface"

• Data modelling based on the customer’s software requirements regarding the major data model of the project
• Writing software design documents
• Creating test plans
• Change management

Technologies: Tool for data modelling, software development and test

Seminar Information System

• Development of an application for planning courses with functionalities of accounting and circulars

Address Management System

• Development of an application for managing data of employees and customers with import and export functions

Planning of Action

• Development of an application for allocating employees to actions and target-performance comparisons

Technologies: Visual Basic, SQL, Access

Product development

• Development and adjustment of health insurance products
• Analysis and creating a mathematical model for shift of covering funds in case of product change
• Development of a product database
• Migration of a legacy system into the new product database
• Analysis, concept, development and test of an application for the calculation of new products and adjustment of existing products, management of calculated products, analysis of effects for the portfolio of contracts, transfer of products to the product database

Technologies: Visual Basic, SQL,Access

• with special subjects financial mathematics and actuarial economy
• with certificate „Diplom Wirtschaftsmathematik“