IT_One, project for a major bank for Java Backend
Event-driven notifications and integrations
- Task
- Connect the portal to external systems and keep employees informed about their requests.
- What I did
- A Kafka notification producer and a consumer service that delivers messages through the corporate messenger API
- Unified read receipts across Redis, workflow tasks and requests: an atomic Lua script, idempotent PostgreSQL writes
- A courier service API: cost calculation, documents, tracking, scheduled status updates
- Admin search over several million requests rewritten from JPA / Criteria API to dynamic native SQL: filtering and pagination in a CTE before the joins, pg_trgm GIN indexes
- REST integrations with the Idea Platform low-code system
- Result
- Request search went from ~1–2 s to ~200–300 ms. Notifications run on Kafka events and reach employees in the corporate messenger; the portal exchanges data with the courier service and Idea Platform.