Sopra Steria
Montreuil, FranceBusiness Analyst
June 2025 - present
Public Services division. Client: CNSA (French national solidarity fund for autonomy), third-party application maintenance (TMA) of its Data contract. Takeover of the applications after a change of contractor and migration to the cloud (Bronze, Silver, Gold architecture).
Applications
- National steering of medico-social orientations (SDO)
- Data transmission to the French National Health Data System (SNDS)
- Le Centre de données (LCD), the analytics system of the MDPH (departmental disability offices)
- Data reception and pseudonymisation component (BRPD)
- Detailed functional specifications: written alone or as a team for two applications handling sensitive data (file pseudonymisation, encrypted transmission of health data). First delivery met on a tight schedule.
- Modelling and mapping: conceptual data model, source-to-target data mapping handed over to developers, use case sequence diagrams in draw.io, screen mock-ups.
- Reverse documentation: where documentation was missing, specifications rebuilt from the code, with the list of gaps between what was specified and what was actually developed.
- Workshops and documentation: preparation and follow-up of workshops with the client and its data supplier, meeting minutes, summary documentation explaining an application end to end.
- Test strategy: definition of what must be tested and in what order of priority, nominal, alternative and error test cases, purpose-built test data sets, tracking in SpiraPlan.
- Checks and non-regression: every development and every fix is tested before it is delivered, so that no defect slips through. After the optimisation and cloud migration of a health data pipeline, proof that the output data remains strictly identical, with a confirmed performance gain.
- Acceptance testing of BI reports (Suadeo): verification that report filters return the same data as the database (Gold layer), reporting of discrepancies and identification of their origin, on the BI side or the database side.
- Knowledge transfer: workshops with the outgoing contractor on 3 applications and written summaries for the team.
- Initial assessment reports: audit of the existing system at takeover (specifications, data, reports). On one application, the report showed that going live was impossible as things stood and led to recommending a redesign.
- Exploration: SQL queries to check data quality, consistency between tables and the accuracy of business indicators.
- Post-migration comparison: discrepancies between the old and the new system explained line by line, with SQL fixes tested and then handed over to developers.
- Operations (RUN): monitoring of data loads, analysis of rejected records with the client and contribution to the design of an automation of these loads.
- Team tool: creation of a tool that imports test cases from Excel into SpiraPlan (REST API, PowerShell), with its user guide, used by the other BAs on the team.
- SpiraTeam lead: creation of the test projects of 3 applications during the move from ALM to SpiraPlan.
- Onboarding: presentation materials on the applications to train newcomers.
Environment
- SpiraPlan
- ALM
- PostgreSQL
- SQL Server
- SSIS
- SAP BusinessObjects (WebI)
- Suadeo
- Airflow
- GitLab
- DBeaver
