Simon Dumas

Redesign and optimization of the aeronautical data foundation (AIXM / EuroControl Standard)

Reverse Engineering & Modeling: In-depth analysis of the European AIXM standard (XML/XSD) for the design of a simplified, normalized, and performant target SQL architecture.

Data Engineering: Development of optimized algorithms for parsing, transforming, and ingesting complex data streams into the new data model.

Performance & Scalability: Optimization of storage structures (advanced indexing, normalization constraints) aimed at reducing query latency and storage footprint.

Technical Environment: Python, SQL, XML/XSD Schema, PostgreSQL/Oracle, EuroControl Standards.

Description:

Complete design and development of a multi-tenant SaaS platform dedicated to critical fuel management for aeroclubs. The objective is to automate logistical and financial stock tracking by replacing manual processes with a real-time solution.

Key Achievements:

- Backend Architecture: Design of an asynchronous API with FastAPI (Python 3.12) and PostgreSQL 16, including strict data isolation (multi-tenancy) through dependency injection.

- Business & Data Logic: Implementation of a Weighted Average Cost (WAC) calculation engine for dynamic stock valuation and financial flow management.

- Mobile-First Interface: Development of a responsive frontend with React and Tailwind CSS, optimized for field data entry by pilots (mobile-first UX).

- Automation: Implementation of scheduled tasks (APScheduler) for intelligent anomaly detection in consumption and automatic generation of accounting reports (Excel/PDF via WeasyPrint).

Technical Environment:

Python (FastAPI, SQLAlchemy, Pydantic), React (TypeScript, Zustand), PostgreSQL, Alembic, Docker, API, Resend.

Development of a business application for the West Air Traffic Control Center (CRNA), aimed at optimizing the management and display of operational data.

Key Achievements:

- Real-time Architecture: Implementation of bidirectional communication via WebSockets for instant display of traffic data without page reloads.

- Fullstack Development: Design of the backend for data stream processing and the frontend for smooth and responsive visualization.

- Business Problem Solving: Digitalization of a previously manual process, allowing for significant time savings for operators and reducing the risk of errors.

Technical Environment:

Python, WebSockets, JavaScript (Frontend), SQL.