Nathalie AVRIL

📝 Profile

Data/DevOps Engineer transitioning after 19 years of embedded software development in industrial environments. Hybrid profile combining industrial rigour, data expertise and DevOps culture.

💼 Professional Experience

📊 ETL Pipelines — ERP/MES Integration

• Designed 4 bidirectional ETL pipelines (Prefect 3) synchronising an ERP and an MES in industrial production
• REST API (OAuth2) and ODBC (SQL Server) connectors with retry, exponential backoff
• Incremental synchronisation with delta tracking, Pydantic validation
• 220+ pytest tests (69% coverage), Mermaid documentation, Teams alerting

⚡ Power Platform — Supplier Invoice Integration

• End-to-end solution: 9 Power Automate flows + 1 Canvas App (PowerApps) for dispute management
• Automated pipeline: email → PDF → SharePoint → SFTP → ERP Sylob, Teams notifications, logging
• DEV/PROD environments, 21 environment variables, Power Platform CLI (pac) deployment pipeline

🔬 Litho — Laboratory Management Application

• Frappe Framework application (36 data models), EAV architecture
• ERP integration via ODBC, lab instrument parsers, BI API (Superset, Power BI)
• 210+ tests, GitLab CI/CD (Ruff → build → test → release)

☸️ Kubernetes Infrastructure — Platform Engineering

• On-premise Kubernetes cluster, GitOps (ArgoCD) deployment
• 16 applications in production: Litho, Airbyte, Superset, ThingsBoard, Grafana/Loki, MinIO
• Centralised monitoring (Grafana + Loki), distributed storage (Longhorn), backup (Kopia)

• Automated trading platform: FastAPI + Streamlit + PostgreSQL + MongoDB
• Kubernetes cluster (Talos Linux, 3 nodes) on Proxmox, Cloudflare Tunnel
• GitOps (ArgoCD), Sealed Secrets, multi-env (dev/staging/prod)
• Hybrid on-premise + cloud architecture (97.5% cost reduction)
• Monitoring (Grafana + Loki + Promtail), GitLab CI/CD, GitLab project management

• Class A/B embedded software in C, ISO 13485 compliant (medical devices), real-time
• Desktop applications (C++, C#): production test benches, control interfaces, Python analysis
• eGroupware intranet (PHP, MySQL): quotes, orders, suppliers — used 15 years
• Onboarding of ERP Sylob (same ERP integrated via ETL at Neolithe)
• Staff training, code reviews, cross-department coordination

• Embedded C software under real-time OS, automated test benches (LabView)
• Company website (PHP, MySQL), prototyping and industrialisation

🎓 Education