Milton Koualet

Mapping of outgoing events (Payments, Benefits, Fees...) from Kélia to feed an ODS and all downstream systems for individual and collective retirement.

Rationalization of Kélia operations (context, type, modalities…), Fetching equivalent ODS fields with the correct rules (SQL).

Implementation of a parameter table for fixed data and transcoding used as inputs for DataStage jobs.

Regular workshops with the editor KAPIA on new feature developments and understanding of CREs.

Regular workshops with downstream teams (Accounting, Actuarial, Marketing, Management & Underwriting...) on their data expectations.

• Participation in the closing of actual and prospective financial accounts.

• Reserving of the annuitant portfolio and monitoring of longevity risk.

• Participation in the preparation of the Actuarial Function opinion on new product launches or tenders approved by the Risk Management Committee.

• Reconciliation of inventory provisions/flows and client account provisions/flows.

• Migration of inventory processes from SAS to Python/PySpark on DataBricks

– Transcription of SAS scripts into PySpark and update of documentation.

– Optimization of PySpark programs.

• Testing and validation work on editorial modules, Kelia financial flows

– Design of functional tests and UAT.

– Writing and execution of tests on back-office data.

– Participation in the estimation of charges for test execution.

– Reporting of anomalies, proposals/implementation of corrective measures.

– Querying databases (SQL, ETL...) and analyzing results. – Monitoring and reporting under Jira. Awareness raising for teams on processes.

• Optimization of inventory processes / DREES reporting.

• Preparation of consolidated actual and prospective financial accounts (strategic plans, Budgets), under French GAAP, IFRS 17:

– Construction of the consolidated balance sheet and income statement.

– Analysis of consolidated results. Breakdown by major business lines. – Production of consolidated reporting.

• Margin analysis. Monitoring of profitability indicators (Revenue, NBV, ROE...). – Consolidation of SII indicators (VIF, NBV, LifeECR).

• Implementation of the IFRS 17 Premium Allocation Approach (PAA) model: input retrieval, unwinding of social cash flows and their discounting, calculation of discount effects, calculation of OCI and Unwinding. Feeding the IFRS 17 income statement.

• Lead on the migration from Hyperion to Power BI and monthly reporting: Script transcription, creation of new dashboards.