Freelancer profile translated to English.

Description

PhD in Probability & Finance in 2014 and a Master's degree in Financial Mathematics in 2010 from Centrale Marseille, Master's in Probability and Statistics, Bachelor's in Mathematics-Computer Science.

For 8 years, I have been providing technical support for various functional departments in the design and development of applications, maintenance, and evolution of applications. Thus, possessing technical and managerial skills acquired through professional experience; I have carried out:

1. A 22-month mission (March 2020 - December 2021) as N3 support and manager of an application pool of 2000 applications in VBA macros at SNCF: Incident processing.

2. Studies, design, and development in VBA of a P&L Pricing tool (February 2019 to February 2020) at SAUR.

3. One year at CNP ASSURANCE in the design and development in VBA of a compliance tool in 2018.

4. Project Manager for the Design and piloting of ANACREDIT POC at Société Générale (October 2016 - November 2017)

5. 24 months (September 2014 - August 2016) partnership CDC/Paris X, in the design and development of a market VaR calculation tool - Index Portfolio.

Mathematician - Computer Scientist by training with the following national qualifications:

6. Qualified Associate Professor in applied mathematics at the national level with national number 16226255866.

7. Qualified Associate Professor in pure mathematics at the national level with national number 17225255866.

9. Researcher affiliated with the Random Modeling Laboratory of Paris X University since 2017.

Languages

French
Native or bilingual
English
Fluent
Fula
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

CNP Assurances
CNP ASSURANCE Studies and Development of VBA/Excel Tools
BANKING AND INSURANCE
January 2018 - November 2018 (10 months)
Paris, France

Context
• Regulatory Project: Fight against Money Laundering and Terrorist Financing (AML/CFT)
• Cleaning of homonyms in databases with a tool implemented in VBA. Compliance
Department of CNP Assurance
Responsibilities
• Choice and design of the VBA analysis tool
• Implementation of the schedule and deadlines
• Support for the IT department (two developers) with programming and control
• Continuous facilitation of project monitoring workshops (IT, Business, Client): business team of 4 compliance analysts
• Daily management of anomalies after the tool's deployment
• Driving change and adaptation with users
Deliverables
• A VBA compliance analysis tool
• User guide/support
Technical and functional environment
• VBA/Excel, SQL in Access
• Windows
• Compliance
ANALYSIS Design COMMUNICATION VBA COMPLIANCE CUSTOMER RELATIONS
SAUR
SAUR Studies and Development of VBA/Excel Tools
DIGITAL AND IT
October 2019 - February 2020 (4 months)
Issy-les-Moulineaux, France
Context:
Project on the offer pricing tool:
• Harmonize the pricing methods for Public Service Delegation offers between the 6 operational
departments of Saur
• Design a single pricing tool with these new methods, to simplify cost estimation for
Design Office engineers
• Automate the financial consolidation of cost estimation, in the key outputs used by the group
o Internal P&L (type P&L)
o Financial presentation to the supervisory board
Responsibilities and deliverables:
Business Owner / Technical Owner Mission
• Gathering requirements from the various directors of the design offices.
• Drafting of specifications
• Delivery schedule and deadlines
• Development in VBA
• Regular reporting with the Pricing team
On-boarding and knowledge transfer:
• Handover of the pricing model and corresponding VBA code: functional v0 (feeding the target P&L
from input tabs)
• Contextualization session with business stakeholders (Design Office Director) and Finance (Management Controller)
• Transfer of costing methodologies by cost item and corresponding target P&L item
Finalize a first testable version of the model in parallel with the current model developer:
• Finalization of input tabs, based on feedback from the working group composed of Design Office Directors
and the financial controller
• Finalization of P&L feeding based on these inputs, as well as the KPI consolidation tab
Technicals
Support the testing phase in design offices:
• Monitoring of design engineers selected for the testing phase (based on a lost commercial proposal covering all possible costing scenarios)
• Consolidation of feedback from design office engineers on both substance (cost items to modify,
inputs to adapt) and form (calculation speed, format of different tabs)
• Reporting of this feedback to the Pricing Group, and prioritization
• Integration of feedback from the Group
Prepare the tool deployment:
• Addition of key functionalities - in parallel with the testing phase
• Including final key outputs to be created: financial indicators for the Supervisory Board, technical
indicators for invoice simulation...
• Input of actual figures from the last three years for contract renewals - under the supervision of Management Control
• Participation in user training program
• Writing a user guide for design office engineers, based on the main questions from the testing phase
• Technical documentation
• VBA code documentation, writing a guide for handover to SAUR's IT department
ANALYSIS Design MATHEMATICS Communication VBA Management Control
SNCF
SNCF N3 Support and Manager of VBA Macros Expertise Unit
DIGITAL AND IT
March 2020 - Today (6 years and 3 months)
Paris, France
Context:
As part of the Windows 10 acceleration program, SNCF has an application pool of approximately 2000 applications, all designed under Windows 7 or earlier versions, with Office 2010 or earlier versions.
It is necessary to upgrade all applications that pose an incompatibility problem with Office 365 ProPlus 64-bit version, ranging from simple adaptation of a library or API to development in VBA and integration of functionalities not supported by Microsoft Office.
Responsibilities and deliverables:
Business Owner / Technical Owner Mission
• Analysis of requests from users of SNCF RESEAU, SNCF VOYAGEURS, GARE ET CONNEXION, FRET, e.SNCF
• Analysis and provision to users of the first tools to help resolve problems using the readiness toolkit
• Qualification and assignment of requests to N1 or N2 support
• If necessary, update VBA macros in case of incompatibility, as N3 support
• If necessary, development and integration of additional macros (in the case of ActiveX controls,
COM add-ins, ...) as N3 support
• Monitoring and reporting of incidents to the corresponding IT departments until ticket closure, as
unit manager
Deliverables
Applications that function correctly.
VBA Windows 10 Data Analysis Communication CUSTOMER RELATIONS