Carl E.

Two-week assignment within the Management Control team of Allianz France, to evolve the new general expenses allocation model developed in SAS and Excel/VBA:

• [Excel/VBA + SAS] Integration of initial data processing developed in Excel/VBA

• [Excel/VBA + SAS] Integration of a database into the allocation process

• [Excel/VBA] Development of a tracking solution for modifications to an Excel/VBA tool

• [VBS] Development of a solution to automate the "segmentation" of portfolios in Excel format

• [Word] Documentation of developments

1. Actuarial Techniques - Data & Pricing Expert

• Pricing studies (GLM, Machine Learning)

• Training teams in data science (Python)

• 100% Health Reform

• Key Account Underwriting (customized)

2. Digital Transformation - Product Owner and Innovation Lead

• Deployment of pre- and post-sales insurance solutions

• Construction and integration of an insurance data management system

• Data Architecture

• Product Owner for the range of technical solutions

3. Digital Project Management - Lead Hong Kong & Thailand

• Go-live of about ten digital customer journeys

• Integration of a market-leading BI solution (AWS QuickSight)

• Industrialization of price testing via API

• Development of automation tools

• Project Management

• Multi-project management

4. Technical Management

• Recruitment and supervision of a team of junior technical contributors

• Management of technico-digital innovation projects

• Supervision of actuarial dissertations

-> Daily use of Excel & Python, and regular use of SAS, VBA.

-> Daily communication in English with local entities.

Real Estate Credit Consulting (Borrower Insurance, credit buyback and renegotiation, study on different types of loans) - Creation of simulators using Excel and VBA and writing a summary on real estate credit consulting in Word. Participation in the update of the annual study on unearned premium provisions for borrower insurance - Manipulation of claims and customer databases using Excel and VBA. Study on the correlation between various pluviometric and meteorological station indicators and the production of rice and cotton in Benin communes (with the aim of providing an index for setting up index-based insurance in Benin) - Adaptation and automation of the correlation process using R, Excel, and VBA.