Pandas Experts in Berlin

• Advising companies on building, migrating and optimising BI and reporting landscapes (Power BI, SQL, Python, ETL)

• 5 client engagements in real estate and finance since 05/2025: taking over and stabilising existing reporting, automating recurring standard and management reports, building cash-flow models

• Proposal and feasibility assessments for BI and reporting projects

• Using AI-assisted development (Claude Code) to accelerate automation, tooling and web/app development

• Custom ERP system

• Problem: A client's core processes ran on scattered, siloed Excel files with no central data storage – error-prone, hard to scale and impossible to analyse end-to-end.

• Approach: Captured the business processes and requirements, modelled the data and developed iteratively together with the business team.

• Implementation: Built a tailored, web-based ERP system with a central database, role-based modules and automated reporting – delivered using AI-assisted development in Claude Code.

• Timesheet app

• Starting point: Time tracking based on an overgrown, macro-heavy Excel template – maintenance-intensive, single-user and error-prone.

• Implementation: Migrated all functionality and VBA macros into a standalone web app with central data storage, multi-user support and automated reporting.

• Cash-flow modelling

• Starting point: The existing cash-flow model covered standing investments only; project developments were missing from steering.

• Implementation: Built and extended the CF model to include project-development cash flows.

• Optimisation: Reviewed and optimised existing CF models and expanded the KPI outputs for reporting and steering.

• Detecting fraud patterns by implementing aggressive anti-fraud rules while maintaining acceptable false positive rates, reducing fraud exposure to users by up to 80%
• Supporting ideation and roll-out of new trust and safety features to block fraudulent activity and increase user awareness for fraud
• Supporting Product, Development and Customer Support with BI reports and further guidance to identify and fight fraud and policy violations

• Cut first-30-day post-subscription churn 45% to 20% by revamping onboarding and optimizing time-to-value.
• Drove 3x LTV in 6 months through retention and monetization experiments across the customer lifecycle.
• Owned app redesign and feature delivery leading to lifting active-user NPS from 6.3 to 8.5.

• Designed and implemented a hybrid recommendation system (content-based + collaborative filtering)
• Built end-to-end ML pipelines including data processing, feature engineering, model training, and evaluation
• Developed RAG-based LLM systems using LangChain and vector databases for semantic search and knowledge retrieval
• Established MLOps workflows with MLflow for experiment tracking, versioning, and deployment readiness
• Implemented deep learning models (computer vision & classification) using PyTorch and TensorFlow

• Codebase Evaluation & Problem Design: Designed and stress-tested complex software engineering problems against large open-source Python codebases (including pandas), requiring deep context acquisition and architectural understanding to produce well-scoped, realistic problem statements aligned to strict correctness guidelines.
• Agent Failure Analysis: Assessed LLM coding agent solutions for correctness and completeness, identifying meaningful failures across edge case handling, dtype behaviour, and multi-column NaN propagation logic; documented findings with precision for downstream evaluation use.
• Programmatic Test Suite Development: Authored comprehensive pytest suites to programmatically verify agent-generated solutions against defined requirements, with deliberate coverage of boundary conditions and failure modes not caught by naive implementations.
• Containerised Environment Engineering: Built and debugged Docker environments for reproducible agent execution, including git-based repository provisioning, dependency pinning with npm ci, and multi-stage Dockerfile authoring across Linux-based containers.

• Designed and implemented scalable ETL/ELT pipelines using Python, SQL, dbt, AWS and Informatica to ingest data from sources such as APIs, relational databases, and flat files into Snowflake, reducing pipeline runtime by ~30%.
• Migrated high-volume datasets from on-premises Teradata to Snowflake using AWS services (S3, Glue, Step Functions, IAM), ensuring data consistency and integrity.
• Applied Kimball methodology to design star and snowflake schemas, improving query performance and reducing Snowflake compute costs.
• Implemented automated data quality checks using SQL-based dbt tests and the Great Expectations framework to detect anomalies and enforce data correctness before production loads.
• Orchestrated ETL workflows in Airflow using Python and managed code deployments via Git with CI/CD best practices to increase deployment reliability and maintain pipeline uptime.
• Built interactive Power BI dashboards and curated datasets to enable data-driven decision-making for stakeholders.
• Maintained technical documentation in Confluence for ETL workflows, and led knowledge-sharing sessions for new joiners.

• Providing freelance software engineering and AI orchestration services for an early-stage startup.
• Designing and coordinating autonomous AI systems capable of executing complex, multi- step workflows.
• Developing customer-facing pilots and proof-of-concept solutions.
• Participating in meetings with customers and investors to support product development and business discussions.

• Acted as technical consultant to optimize multi-layer ensemble models combining ResNet, CNN-BiGRU-Attention, and XGBoost.
• Guided implementation of a Logistic Regression meta-learner to solve class imbalance problems, achieving 92.86% accuracy and 0.9644 AUC on PTB-XL and Chapman-Shaoxing datasets.

• Developing methods for monocular 3D facial reconstruction and personalized geometric modelling from mobile imagery
• Building learning-based approaches for facial shape estimation, video-based facial analysis, and privacy-preserving visual learning

• Lecturer for the GenAI Track at the Master School Institute of Technology
• Development of a full-stack AI application (React + Python/FastAPI) for automated supplier product import with intelligent column and category classification (4-layer hierarchical) including human-in-the-loop validation

• Context: Healthcare and laboratory teams required faster document analysis, treatment-planning support, and reliable AI workflows for MR/VR-assisted operations.
• Contribution: Built the AI healthcare platform, model/agent workflows, VR-glasses deployment platform, REST APIs, Next.js/React interfaces, and CI/CD pipelines.
• Impact: Delivered a production-ready AI product foundation that improved clinical document review, supported laboratory automation, and made VR fleet deployment manageable across environments.

Tech: TypeScript, Next.js, Node.js, React, Java, Spring Boot, Python, PyTorch, TensorFlow, Docker, PostgreSQL, OpenAPI, GitLab, GitHub Actions.

• Insurance service provider*

Challenge: Business-critical documents were processed through external OCR providers, with ongoing costs, dependency, and data privacy risks for sensitive insurance data.

Implementation:

• Architecture and production implementation of an on-premise OCR solution with full data ownership
• Methods for recognizing document structures as the basis for automated further processing
• ML-, NLP-, and LLM/VLM-based information extraction, especially from invoices and quotations

Success: Replaced external providers: full data ownership, GDPR-compliant processing, and 75% lower recurring OCR costs per year

Used technologies: Python, Docker, Microservices, FastAPI, PyTorch, Torchvision, MongoDB, MySQL

• Assessment of the existing reporting landscape and strategic bundling of needs
• Migration and consolidation of reports to Metabase, connected to ClickHouse as the data foundation
• Building and maintaining data pipelines

Stack: Metabase · ClickHouse · Appsmith · Airflow

• Develop and demonstrate solutions using GenAI software like langchain, vercel ai sdk, copilotkit
• Work with customers to understand their challenges and provide the best solutions based on open-source data products
• Build RAG and GraphRAG solutions using Neo4j, lancedb, and Postgres
• Deploy a LLMOps platform using kubernetes, terraform, helmfile, Arize phoenix, mlflow
• Architect and build data pipelines using dbt, Trino, Spark, Iceberg, Airflow, ArgoCD, terraform, kubernetes
• Delivered user-centred technical strategy for Agriculture 4.0 and precision livestock farming, helping my client secure funding from Bpifrance
• Delivered a prospecting tool for a leading French solar carport installer, using geospatial computing (GIS), speeding up the sales process
• Built digital twin architecture for solar carports and EV chargers, making real-time monitoring and smart charging possible