Currently employed

William Loubat

Business Analyst

I turn business needs into concrete, actionable solutions.

Business Analyst with full-stack developer experience: I speak both languages, business and technology.

Châtillon · Greater Paris

William Loubat

Profile

A data Business Analyst at Sopra Steria since June 2025, I work on public-sector applications (disability, autonomy, health data). I write the specifications, test and validate deliveries before they go live, and handle the takeover of applications after a change of contractor. My 4 years in software development (Java, Angular, SQL) allow me to read code and queries, so I speak the same language as developers and can quickly find the source of a discrepancy.

Detailed functional specificationsQualification and acceptance testingApplication takeoverDual functional and technical expertise

Work experience

Sopra Steria

Montreuil, France

Business 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)
Functional specification
  • 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.
Qualification and acceptance testing
  • 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.
Application takeover (reversibility)
  • 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.
Data analysis and SQL
  • 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.
Tooling and knowledge sharing
  • 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

Klee Group

Le Plessis-Robinson, France

Full Stack Developer

May 2024 - June 2025

HealthcareJoint venture between Groupama, SantéClair, SpSanté and ISEA
  • Gather and analyse business needs during daily meetings
  • Turn client requests into bug-fix and enhancement tickets
  • Run workshops with the Proxy Product Owner to refine solutions
  • Leverage my dual skill set to anticipate business needs and turn them into concrete solutions
TransportWork-site scheduling on the Paris railway network (RATP)
  • Deliver fixes and functional enhancements to improve work-site planning and tracking
  • Comply with specifications defined by the business analysis team
  • Contribute to daily meetings to track development progress
  • Use my technical and functional know-how to anticipate and clarify business needs
Human resourcesCRM built for Synergie
  • Design and build the CRM from inception, working in an agile setup
  • Actively contribute to backlog refinement and sprint planning sessions, including ticket estimation
  • Stay close to the client to refine and validate functional requirements
  • Coordinate development work and functional requirements within a multidisciplinary team

LCL

Villejuif, France

Software Engineer

October 2020 - November 2023

BankingIT department
  • Design and implement Java microservices with Spring Boot
  • Document REST APIs with Swagger to ease their consumption
  • Write technical specifications

Certifications

Skills

Business analysis

  • Needs gathering and analysis
  • Detailed functional specifications
  • Technical specifications
  • Use cases · business rules
  • Data mapping · interface contracts
  • Workshop facilitation · business/IT bridge
  • Change management
  • Indicators · BI dashboard mock-ups

Method & quality

  • Agile · Scrum
  • Product Ownership · PSPO I certified
  • Backlog refinement · estimation
  • Acceptance strategies · qualification
  • Non-regression testing
  • Anomaly tracking · run

Tools

  • JIRA
  • Confluence
  • DBeaver
  • Postman
  • GitLab
  • Teams

Technical

  • SQL · PostgreSQL
  • Java · Spring Boot · microservices
  • Angular · React
  • REST · SOAP APIs · Swagger

Languages

  • FrenchNative
  • EnglishProfessional

Strengths

  • Autonomy
  • Adaptability
  • Team spirit
  • Curiosity

Interests

  • Cycling
  • Badminton
  • Board games

Education

Master's degree in IT & Information Systems

EPSI, Paris - La Défense

2021 - 2023

Bachelor's degree in DevOps

EPSI, Paris - La Défense

2020 - 2021

Two-year technical degree (BTS) in Digital Systems - IT & Networks

École Agora, Puteaux

2018 - 2020

A role, a project, a question?

Drop me a line through this form - I reply quickly. You can also copy my email address or reach me on LinkedIn.

Contact