Report search on Elasticsearch

Built 7+ report APIs with PDF and Excel downloads over ticket data, and cut query latency from 4–5 s to 400 ms by moving report reads from multi-join database queries to Elasticsearch, with PostgreSQL still the source of truth.

Back to work

Turn on JavaScript to read the rest of this case study.