Freelancer profile translated to English.

Description

Experienced Business Analyst with solid expertise in retirement savings, regulatory compliance, and data migration. I have supported large groups (Malakoff Humanis, Generali, Humanis) in strategic IT system transformation projects, particularly in decommissioning legacy tools and implementing modern solutions like Assurex and Kelia. My technical skills include developing and optimizing SQL queries, database management (Oracle, SQL Server), and creating decision-making reports with Power BI. I also have extensive experience in Agile Scrum project management, writing functional specifications, and conducting functional and acceptance testing.

Would you like to collaborate on strategic savings or IT transformation projects? Let's discuss!

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

MALAKOFF HUMANIS
Business Analyst - Retirement Savings
November 2021 - Today (4 years and 7 months)
Context As part of Malakoff Humanis's strategic development of its Savings business, the group has initiated major IT system evolution and renovation projects for Retirement Savings.

The progressive decommissioning of all Legacy tools is planned within a multi-year plan. The implementation of the Assurex then Kelia software package for managing all Retirement Savings benefits involves significant data validation work before migration.

Within the TOO and PEPIT programs, the Quatrem tool must be decommissioned in favor of the group's target tool to manage all Retirement Savings benefits in a single tool. The main challenge concerns data validation before migration and the recovery of data outside the IT system.
Missions: Writing functional specifications for the development of a migration factory
Data mapping and development of functional rules for data recovery Recovery of data outside the IT system: reconstruction of pension rights by fund for differential annuities (Social Security, AGIRC, ARRCO…) from an Excel database Interface with development teams to monitor work progress Preparation of steering committee materials for the Validation workstream Development of functional test plans and acceptance test cases Testing and quality control of migration flows via the migration factory Development of reporting and integration counters for communication preparation of steering committees
Technical Environment: QUATREM, Assurex, Kelia, Microsoft Office Suite, JIRA, SQL Server, DollarU, ODI, Oracle, DB2, and Microsoft databases
GENERALI
Business Analyst Actimize
August 2018 - October 2021 (3 years and 2 months)
Context Nice Actimize: Software package designed for anti-money laundering and anti-terrorism financing.

Within the Compliance department, and as part of the deployment of the Compliance module within the Generali group, establishing the connection with AGI (Retirement Savings contract back office), Assurex, and PPVIE (annuity payment and simulation tools) was necessary to meet regulatory requirements for combating money laundering and terrorist financing.
Missions: Implementation of real-time filtering on management operations. Targeting with the NICE editor and compliance teams. Configuration of the solution with compliance teams and support. Migration to the new version of NICE Actimize from Generali France to the Italian version. Data migration. User needs gathering and analysis. Writing the specifications document. Monitoring developments in relation to IT development. Coordination of the various teams involved (IT development, support, editor, production, etc.). Supervision and/or execution of the acceptance phase. User training and functional support. Reporting to management.
Technical Environment: Nice Actimize, Assurex, Savings Back office, Anti-money laundering, VBScript, SOAP, SQL DEVELOPER
HUMANIS
Business Analyst Retirement Savings
December 2016 - August 2018 (1 year and 8 months)
Context Assurex: Software package designed for customer portfolio management.

Within the Savings department, management of delegated portfolios (management and payment of supplementary annuities), provision of restitution reports to various business departments and delegators. The implementation of about fifty reports (reporting solutions in the field of life insurance and supplementary retirement); Missions: Functional needs analysis, SQL query development, selection and extraction of data from SQL SERVER databases, Support for functional teams, Studies and implementation of optimization processes for existing SQL queries,
User assistance on the Assurex software package, Unit and integration tests during data migrations, Data validation during version upgrades.
Technical Environment: Koro: acceptance and anomaly tracking, VBScript, Excel, tool development, SQL SERVER Management Studio 2012