Ratovo S. M. Lionel

Open to opportunities

I turn complex business needs into systems that hold.

Java full-stack developer, technical and functional consultant. Five years in total: a national land information system, two international data accounts, web production.

AntananarivoAbidjanMauritius

BICI2021 · 5 monthsMercedes-Benz2021–2022 · 9 monthsCartier2022–2023 · 6 monthsGSK2023–2024 · 10 monthsSIF · SIGFUCôte d'Ivoire · 2024 →Free parcelAlone · or three with NEXTRI→ Your projectNAREA ∝ DURATION · SURVEYED 2021–202662 MONTHS ON MISSION · 12 MONTHS AVAILABLESHEET 01 · CAREER
  • Current mission
  • Data
  • Web production
  • Legacy systems
  • Available · 12 months
01

Who I am

Lionel Ratovo, based in Antananarivo. I work on systems that cannot be stopped to be fixed: a national land registry in service, marketing data pipelines in production, business applications taken over without documentation.

My strength is not pure technique, and I do not sell it as such. It is understanding what the business actually needs, then the technical constraints that follow from it. I come alone when the job fits one person. When it does not, we are three: NEXTRI, a collective of engineers in Antananarivo.

Title block · careerAntananarivo · Madagascar
Working since2021
Missions5
FieldCôte d'Ivoire · Mauritius · Madagascar
EducationMaster MIAGE · MBDS
LanguagesMalagasy · French · English
AvailabilityOpen to opportunities
02

What I offer

01

From server to interface

Java Spring Boot, Java EE, NestJS on the server; Angular and Ext JS on the interface. Drools for the rules, Camunda for the workflows: business rules that live in the system, not in the head of whoever wrote them.

In the fieldSIF: land-management processes are orchestrated in Camunda, and every write passes through a Drools rules engine before it reaches the database.

02

SQL modelling and optimisation

PostgreSQL, Oracle. Model first, then make the queries hold once the volume arrives.

In the fieldGSK: segmenting and analysing the group's marketing data, with queries whose results span thousands of rows.

03

Taking over legacy systems

Stepping into a system you did not write, often without documentation, and evolving it without breaking what runs.

In the fieldCartier: Salesforce flows taken over as they stood. BICI: four applications on an internal framework.

04

Support to technical leadership

Business workshops, estimation, task breakdown and follow-up, supporting the team lead. The interface between those who decide and those who build.

In the fieldMercedes-Benz: coordinating a local team of eight, on production split across two countries.

Systems and accounts I have worked on
Côte d'IvoireMinistry of Urban PlanningData accountGlaxoSmithKlineData accountCartierWeb productionMercedes-Benz
03

What I have delivered

ClientMinistère de l'Urbanisme · Côte d'Ivoire
Period2024 →
StackJava Spring Boot · Camunda · Drools · PostgreSQL · ExtJS

Migrating a national land registry without stopping the service

The SGFH had to become the SIF. Nine PostgreSQL schemas, a public portal that only reads, and other government services' databases that had to be both consulted and fed. The November 2024 go-live was the real challenge of the project.

  • 9PostgreSQL schemas
  • 150tables · innola
  • 100+portal users
  • 11/2024go-live
Read the case study : Migrating a national land registry without stopping the service
Portail SIGFU · publicAngularNest JSPostgreslecture seulevia les API du SIFSIFExt JSJavaSpring BootDroolsmétierCamundaworkflowsPostgres9 schémaslectureécritureAutres services de l'ÉtatBDD
RAPP IO · GSK · Cartier2022 · 2024

Two data accounts, pipelines that cannot break

At Cartier, taking over the campaign preparation pipelines where they already stood, in Salesforce. At GSK, segmenting and targeting through SQL queries, then training the people taking over.

Read : Two data accounts, pipelines that cannot break
RAPP IO · Mercedes-Benz2021 · 2022

Publishing web content at a carmaker's scale

Producing and publishing content under AEM, and internally coordinating the Madagascar team on production split between Mauritius and Madagascar.

Read : Publishing web content at a carmaker's scale
A thread through all three

Taking over what exists

SGFH → SIFmigrating a live land-registry application into a service without stopping itCartiertaking over Salesforce flows already in place, without rebuilding themBICIfour applications on an internal framework, without documentation

Career path

  1. January 2024 – Present
    Consultant · SIF and SIGFU public portalIGN FI · Ministry of Urban Planning · Abidjan, Côte d'Ivoire
  2. July 2021 – January 2024
    Consultant · developer, then webmaster, then data engineerBICI Madagascar · seconded to RAPP IO Mauritius · Madagascar & Mauritius
    • GSKMarch 2023 – January 2024 · data engineer, international account
    • CartierSeptember 2022 – March 2023 · data engineer, three months on site in Mauritius
    • Mercedes-BenzDecember 2021 – September 2022 · webmaster, production split Mauritius / Madagascar
    • Phô Resto & 3 business applicationsJuly 2021 – December 2021 · final-year internship, then developer and assistant project manager
  3. 2022–2023 · 2019–2021
    Master's MIAGE MBDS · Bachelor's in Computer ScienceUniversité Côte d'Azur & IT University · Antananarivo
04

How to reach me

Hiring

A role to fill?

Remote or on-site, as I have since 2021. Write, and I answer.

lionelratovo@gmail.com
Consulting

A project to deliver?

I can come alone. And if the project outgrows one person, we are three: NEXTRI, a collective of engineers in Antananarivo.

nextri.mg@outlook.com