Skip to content
All case studies

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
Trading chart on a dark screen

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.

Let’s build together

Need help with software development?

Tell us about your project and we’ll respond promptly to see how we can best assist you.

Contact Us