Lionel ADHEPEAU

Digicel FWI – Telecom DOM-TOM (Full remote) April 2025 to september 2025 (6mois) Business/Data Analyst Consultant within the “Marketing Analysis” team on issues related to modeling and pricing for new plans and promotional campaigns, in collaboration with the Product Managers responsible for each offer. Result: Actual vs. Forecast almost identical, with **EBITDA +€7k** at end-2025 despite higher A&P cost. • Assessed profitability and pricing for new plans to be launched, factoring in roaming costs and Digicel FWI subscribers’ consumption habits, using Python. • Built operational dashboards to monitor involuntary churn — rewrote extraction queries and reworked the Power BI semantic model and indicators. • Produced KPIs and group reporting in euros & USD — Churn, Gross Adds, Net Adds, Port-In & Port-Out, Budget vs. Outlook, and ARPU. Functional context: • Finance & Marketing Technical environment: • PowerBI • SQL • Python

Cleaning Services Oversight (Production) — Client project Delivered a low-code AppSheet application with a BigQuery backend for a cleaning vendor serving Paris Airports (Groupe ADP). Tracks service delivery and operations; in production and used daily by the cleaning teams. Body Damage & Incident Tracking (Production) — Client project Built an AppSheet + BigQuery app to log and annotate vehicle bodywork dents/scratches using an image-recognition/annotation workflow. In production and actively used by cleaning/maintenance teams.

Business Analyst Data Consultant within the Datalab on a project to roll out a **worldwide AI & Python platform** for the **Finance, Capital & Actuarial (FAC)** division, **Actuarial France**, and **Risk** teams across **EMEA**, and also outside the eurozone (Asia and Latin American countries). • Managed and set up the portfolio to inventory regulatory use cases (Solvency II, pricing, portfolio monitoring, reserves calculation, etc.) across Savings, Protection, **Credit Life (ADE)**, and Affinity. • Led and tracked support for actuaries during POCs migrating existing tools (SAS, VBA) to Python. • Supported and framed use cases for pricing/underwriting monitoring (portfolio risk tracking, rate tracking via actuarial and supervised/unsupervised learning models). • Ran requirements-gathering workshops. • Wrote functional specifications and scoping documents. • Performed functional testing of deliverables. • Wrote user stories and took part in SCRUM ceremonies. Supported the platform’s **data governance** definition with the **Head Data Office**: • Inventory of critical business processes and related datasets. • Drafted guidelines and recommendations for data management and usage on the platform across the full lifecycle. • Implemented the process to declare data used by each use case to ensure **GDPR** and **BNP internal policy** compliance. • Oversaw the implementation of the reference tool as **Product Owner** and executed functional testing. Functional context: • Health/Protection Actuarial • Marketing Technical environment: • Domino Data Lab • Power BI • SQL • Python • IBM COS / MinIO

Business Analyst Data Consultant (Capital Markets) within the **Asset Management Directorate (DGA) of france**. • Oversaw a BI program ensuring continuity of steering for approvals of market participants and products authorized for distribution. • Conducted data profiling and audits. • Approvals context: Asset Management Companies, UCITS (FCP & SICAV) & NAV monitoring. • Analyzed and audited quarterly **MMF** (money market funds) regulatory reports submitted to **ESMA** (European Securities and Markets Authority). • Wrote functional specifications. • Performed functional testing on deliverables. • Ran requirements-gathering workshops. • Wrote user stories and participated in SCRUM ceremonies. Functional context: Financial markets regulation Steering of investment fund approvals Registry of UCITS financial products (SICAV & FCP) Technical environment: • SAS Enterprise Guide • SQL Server

Context: Major decision-intelligence program at Malakoff Médéric to ensure continuity of steering after a redesign of operational & BI systems. Scope & impact Ensured business steering continuity post-transformation (process + systems) across Health & Disability lines, individual & group. Delivered functional specs and supported strategic group-level reporting (Underwriting, Finance, etc.). Key contributions Authored functional specifications for contributions/premiums, claims statements, and benefit payments (Health & Disability, individual & group). Led feasibility studies and data source assessments (data discovery, lineage, quality checks). Ran and supported functional testing/UAT of deliverables; coordinated sign-offs with business stakeholders. Facilitated requirements workshops (Underwriting, Finance, Operations) to align reporting needs and KPIs. Tech / tools: SAS Enterprise Guide, Graphtalk AIA Keywords: Business Analysis (AMOA), Actuarial, Health & Disability, Contributions/Premiums, Claims/Benefits, UAT, Feasibility, Data Discovery, KPI/Reporting, Steering Continuity.

Client: Orange Business Services (B2B) — multiple entities (Controlling, Customer Relationship Management) Scope & impact Owned BI/analytics projects to support margin tracking by offer, commercial follow-up, and appointment scheduling across 13 subsidiaries. Improved sales efficiency and reduced national deployment lead time by standardizing reporting and processes across entities. Enabled contractual SLA monitoring for external service providers (production & commercial follow-up) via defined KPIs. Key contributions Ran requirements discovery with Controlling & CRM teams; authored functional and technical specifications. Produced SFG (high-level functional specs) and detailed specs for delivery; coordinated stakeholders through to go-live. Designed dashboards and data models in QlikView; wrote SQL for data prep and KPI computation. Tech: SQL, QlikView (data visualization) Keywords: Business Analysis, BI/Analytics, Margin by Offer, CRM, KPI/SLA, Deployment Lead Time, Multi-entity Rollout, SFG, QlikView, SQL.

Scope: Change requests and fixes on the Decision Intelligence stack (Data Lake & P&C/Protection Datamarts). Close collaboration with risk analysts and actuaries on reporting and data quality topics. Key contributions Produced statistics and exposed SID data to the Risk function for analysis and decision-making. Ran requirements discovery with Risk and Finance teams to automate Solvency II and ENS reporting, including the production of three QRTs (20, 21, 03). Led scoping (cadrage), coordinated stakeholders, and authored the Functional Specification (SFG) for evolutions and corrections. Supported governance: validated data lineage/controls for actuarial & finance use cases across Data Lake and Datamarts. Keywords: Business Analysis, P&C Insurance, Protection, Finance & Actuarial, Solvency II, ENS, QRT, Data Lake, Datamart, UAT, SFG, Reporting Automation, Risk Analytics.

Program: Enterprise reporting & analytics — from zero to a full BI stack for Africa operations. Scope & impact Delivered a Decision Intelligence platform (SID) with a new Data Warehouse for P&C (IARD) and Life (VIE); created business datamarts for Finance, Underwriting, Marketing, and Actuarial — starting from no prior BI system. Enabled end-to-end operational and financial steering across the continent by extracting and harmonizing data from operational information systems (SIO). Key contributions Analyzed existing financial & accounting statements, consolidation processes, and actuarial reports aligned with CIMA and IFRS standards; mapped operational data sources and extraction paths. Designed and executed the UAT/Test strategy; authored user guides and trained 20 users (CFO office & Controllers) split between Paris and multiple African countries. Implemented an Asset Management tool; performed analysis and integrity controls on statutory asset disclosures (equities, bonds, loans, real estate). Authored the Functional Specification (SFG / high-level functional spec) and contributed to data modeling and KPI definitions. Tech stack Business Objects, SQL

R&D Engineer (Apprenticeship) Role: Analyst/engineer supporting multiple R&D teams with recurring needs across testing and tooling. Key contributions Built a GSP testing framework; developed JavaFX modules for UI testing of a GSP used in a Canon print-systems product line. Led the test-orchestration application project: requirements gathering, stakeholder alignment, delivery planning, and demos/UAT. Wrote specifications (UML 2.0), designed test plans, and contributed to development across the stack. Developed Java modules enabling communication between the GSP and print systems over multiple protocols; performed iterative testing and bug fixing. Set up version control & CI workflows around Git to support team delivery. Contributed to front end (HTML5/CSS) and back end (Spring MVC, Hibernate) components as needed. Tech stack Java, JavaFX, J2EE (Jakarta EE), Spring MVC, Hibernate, HTML5/CSS, XML, UML 2.0, Git, Agile/SCRUM