Overview

BSP regulatory compliance project requiring a large digital wallet platform to display consolidated spending breakdowns across linked accounts — a user may hold up to 5 accounts under one identity.

Architecture

• Parent-child profile model: 1 parent profile ID maps to multiple account IDs, enabling single-query multi-account retrieval instead of N separate calls
• Caching strategy: Pre-aggregated spending data with cache invalidation on transaction events for real-time accuracy
• Asynchronous refund processing: Refunds update the spending aggregate asynchronously to maintain responsiveness

Key Contributions

• Designed the data model enabling single-query aggregation across 5 accounts
• Balanced real-time accuracy against read performance using intelligent cache invalidation
• Produced full technical artifact set: sequence diagrams, data flow diagrams, DB schema, pseudocode

Tech

Java Spring Boot Alibaba Cloud ECS RESTful APIs gRPC Distributed Caching