Sopra Steria
Montreuil, FranceBusiness Analyst
June 2025 - present
Programme for the CNSA (French national solidarity fund for autonomy): a processing chain for health data submitted by the MDPH (departmental disability offices), made of three complementary building blocks: data reception and protection, analytics platform feeding and orientation monitoring.
Health dataData Reception and Protection component (BRPD), secure entry point for MDPH files into the CNSA information system
- Write detailed functional specifications for several domains of the chain
- Model use cases, processing flows and business rules based on workshops with the business analysis team, architects and the security expert
- Specify data mapping and interface contracts (fragmented upload through a SOAP web service; flow and file tracking)
- Bridge business and development teams and track deliveries across several release batches, with hands-on support (SQL, acceptance testing)
Testing & RunFeeding of the CNSA analytics platform (LCD) from MDPH data, qualification and production monitoring
- Qualify the developments: write qualification strategies, build test data sets and write acceptance reports
- Check non-regression by comparing data before and after migration (SQL extraction queries, per-batch difference lists) and identify discrepancies
- Monitor the weekly loading of MDPH files in production and produce the related reporting
- Qualify bug fixes and keep the anomaly log up to date until resolution
Steering / BIOrientation Monitoring (SDO), a decision-support tool for steering the orientations of people with disabilities (regional health agencies, MDPH, departmental councils)
- Specify the calculation rules of the 7 priority indicators (orientation supply / demand) with their analysis dimensions and applicable filters
- Define the business rules and source data feeding each indicator
- Design the mock-ups of the reporting dashboards
- Incorporate feedback from business workshops and evolve the specifications across release batches