
Case Study · Financial technology
Automating Brokerage Compliance Data for a Financial Technology Provider
Integrating brokerage trading data into a compliance surveillance platform: SSIS pipelines from system-generated files into SQL Server, automated nightly refreshes and new trade blotter, account and position features.
- Client
- A financial technology and compliance software provider
- Industry
- Financial technology
- Our role
- Engineering partner
- Duration
- 1 year

The challenge
A financial technology provider offered brokerage firms a compliance surveillance platform that automates the detection, documentation and reporting required for internal and regulatory audits. To do its job, the platform needed each brokerage’s trading and account data, delivered accurately and on time, every day.
That data arrived as system-generated flat files in varying formats, and onboarding it reliably was critical: compliance teams can’t review what the platform doesn’t have.
What we did
SunAge worked with the provider’s team to:
- Migrate brokerage data into the compliance platform, so detection, documentation and audit reporting could run automatically.
- Build SSIS pipelines to import trade data from system-generated flat files into SQL Server.
- Schedule daily jobs with SQL Server Agent, refreshing the application each morning with the previous day’s trading activity across all client accounts.
- Add new functionality to the application’s trading screens: the trade blotter, account profile and position views.
The outcome
- Brokerage data flowing into the compliance platform automatically, ready for internal and regulatory audits.
- Compliance teams starting each day with complete, up-to-date trading activity.
- Enhanced trading screens giving reviewers more of the information they need in one place.
