Distributed Financial Data Aggregation Service
One interface over several financial data providers. Cut manual data entry 80% and made four partnerships possible.
- ROLE
- Full Stack Software Engineer, MXS Solutions
- PERIOD
- 2021 – Present
- LESS MANUAL DATA ENTRY
- 80%
- STACK
- TypeScript, Node.js, AWS, PostgreSQL, API design
This is client work at MXS Solutions. The code and the running systems are private, so there's nothing to link.
THE PROBLEM
Data came in from several providers, each with its own format, its own auth, and its own idea of uptime. Staff re-keyed the numbers between systems by hand. That was slow, and every keystroke was a chance to get a number wrong.
WHAT I BUILT
- Normalized every provider into one internal shape. Nothing downstream has to care which provider a number came from.
- Kept each provider behind its own adapter, so adding one doesn't mean touching the core.
- Made partial failure explicit. If one upstream is degraded you get partial results, not an error.
- Automated the paths that used to need a person moving data between systems.
OUTCOME
- Manual data entry down 80%, and the typos that came with it went too.
- Four partnerships became possible once onboarding a new provider was a week's work and not a quarter's.
- Downstream products build against one interface. There used to be several, each shaped by whichever vendor it wrapped.