Projects

Selected projects, 2020 to 2026

A selection of the data platform, business intelligence, generative AI and database projects we have delivered for finance, aviation, energy, transport, industry and public sector organisations.

15+

years in data

7

technology partners

1h 35m

report that took a week before tuning

7x24

database support

Data platforms

Real-time and lakehouse platforms

Capital markets, 2023
Real-time order book analytics

Real-time monitoring and reporting of every traded product, with automatic management reports and fraud detection on high-volume order data.

KafkaApache KuduSparkCloudera CDPMicroStrategyMachine learning
Aviation, operations centre, 2024–2026
Real-time irregular operations (IRROPS) monitoring

Live dashboards and automatic alerts that help the operations team react quickly to flight disruptions.

Apache NiFiOracle ExadataMicroStrategyEvent-driven architecture
Aviation, operations control centre, 2026
Operations control centre dashboard modernisation

Moved reporting to a cloud-native lakehouse that combines batch, ad-hoc and real-time processing, with a semantic layer and a feature store for ML.

AirflowSparkTrinoFlinkKafkaS3 + IcebergDremio + dbtLanceDBPower BIQlik Sense
Data warehousing and BI

Data warehouses and reporting

Public sector, local government, 2023–2026
Monitoring and reporting of municipal services

A central data warehouse for all municipal services, with management dashboards and periodic reports for decision support.

PostgreSQLSQL ServerOracle DWHApache NiFiPower BI
Industry chamber, 2024–2026
Membership and activity reporting on Azure

A fully managed cloud data platform for membership, activity and administrative reporting, including data integration with TOBB and AI features.

Azure Data FactoryAzure SynapsePower BI PremiumAzure AI
Generative AI

Generative AI and AI agents

Aviation, airline, 2026
Document chatbots for several departments

Question-answering assistants over audit documents, training material and hotel contracts, built on the company's central file system, with quality evaluation and tuning.

vLLMLlama 4 ScoutpgvectorLlamaIndexS3
Aviation, airline, 2026
Multimodal Q&A on scanned documents

Reads scanned documents with their tables and images, without OCR, and answers questions, compares documents and finds where information appears.

vLLMQwen3-VLDoclingLangGraphpgvector
Aviation, airline, 2026
On-premises document translation and summarisation

Translation and summarisation services with local language models, integrated into the document management system to reduce external translation costs.

vLLMLlama 4 ScoutStreamlitS3
Aviation, energy and industry, 2023–2026
Agentic dashboards

Autonomous agents that answer natural-language questions and create charts from APIs, data warehouses and analytical cubes.

vLLMAzure OpenAILangGraphCrewAIFastAPIPower BIMicroStrategy
Public transport, 2023
Journey-planning assistant

A natural-language assistant that turns questions into API calls and explains live bus positions, speeds and routes for Istanbul public transport.

OpenAILangChainPostgreSQLPower BI
Database services

Database projects

Telco, finance, aviation, public sector, Since 2020
Database performance tuning

Finding and removing bottlenecks in critical database systems.

OracleSQL ServerPostgreSQLMySQLDB2
A one-week report reduced to 1 hour 35 minutes; an 8-second query reduced to 3 seconds.
Telco, finance, aviation, public sector, Since 2020
7x24 maintenance, upgrades and security

Health checks, backup and recovery, Data Guard, RAC, Exadata and ODA, Always On, GoldenGate, upgrades, security and audit for many database platforms.

OracleExadataSQL ServerPostgreSQLMongoDBMariaDBAdabas

Have a similar challenge?

We are happy to share more detail about any of these projects in a meeting.