PeopleSoft / DB2 Regulatory Data Integration
Keeps PeopleSoft/DB2 records aligned with regulatory data from RegEd, replacing the earlier RegEd flow with a stable, event-driven design.
- Architecture
- Kafka-driven Spring Boot microservices consume RegEd messages, apply PeopleSoft-specific mapping and write to DB2 through Hibernate/JPA, so each message is validated and translated before it reaches the target.
- Complexity
- Four distinct streams (daily and monthly, individual and branch). Individual payloads run 400 KB to 30 MB daily and 30–35 MB monthly; branch payloads 10 KB to 5 MB daily and 4–7 MB monthly, with heavy month-end peaks.
- My role
- Drove technical analysis and solution design and owned a substantial share of the implementation.