Actuarial skills
Calculation of technical provisions: PSAP by the chainladder method, use of claims triangles, mathematical provisions in provident, loan and health insurance
Calculation of PANE
Valuation of pure premiums, pricing, future pension liabilities, pensions and indemnities
Pillars I and II under Solvency 2: reserve calculations, risk modules, SCR, MCR, S29 statements
ORSA estimates: provisions, asset portfolio, balance sheets and income statements, sensitivities
Calculations under IFRS17
Project skills
Study and analysis of documents provided to review the tools used and the working methods applied, on sometimes unknown subjects, in order to precisely identify the client’s needs
Drafting of a summary document which will form the basis of the specifications
Participation in meetings with the client to validate the needs and finalise the specifications
Drafting of user guides and process guides with the different steps and procedures to follow
Cross-functional meetings with the client’s various departments (accounting, management, actuarial, IT) to arrive at a common approach
Presentations to the client to explain the methods and provide information on the tools developed
IT skills
Creation or adaptation of a database in SQL
Creation or adaptation of calculation tools in SQL and/or VBA
Creation or adaptation of models for the restitution of numerical results in Excel
Processing and feeding of data
Testing of tools, sometimes unknown, and writing of summary notes on the results
Data science, analyzing data, knowledge of R
Office softwares
Daily use of Microsoft office, Teams, SharePoint
Master Google suite
Knowledge of CRM platforms like MailChimp
Knowledge of WordPress
Languages
English written, read and spoken.
Spanish : Basic written read and spoken
French : mother tongue.