Payments Services

Secure SQL Server reporting for financial crime analysis

Pro DBA designed and delivered a secure reporting solution on the client’s existing SQL Server database under strict personnel, office and network security controls.

Pre-engagement security controls satisfied

£0

Charged for security checks and access setup

Secure reporting solution delivered and supported

Certified technology partners

Work carried out

Completed stringent consultant security checks
Supported an audit of Pro DBA’s offices
Installed specialist secure access devices
Worked through a controlled network connection
Designed the SQL Server reporting solution
Developed reporting for trends and patterns
Worked with the client and the data owner
Accommodated changes to the original specification
Implemented and supported the solution during bedding-in
Removed and returned secure access equipment after delivery

Services & Tech Stack

Services

SQL Server consultancy
Secure reporting development
Database reporting
Solution design
Implementation support
Security and compliance support

Technology stack

Microsoft SQL Server
Secure remote access devices
Controlled network connection

Sensitive financial data required a controlled delivery model

A payments services provider needed a reporting solution added to its existing SQL Server database. The solution would analyse highly sensitive customer data used to help fight financial crime.

The data owner required all development to be completed by security-vetted SQL Server professionals working from audited offices through a controlled network connection.

Security requirements were completed before development

Pro DBA consultants completed the required security checks. Auditors also visited Pro DBA’s offices, and specialist access devices were installed to create a secure connection to the data.

Pro DBA completed these pre-engagement checks and setup activities without charging the client.

Reporting was built around the analysts’ needs

The reporting solution was designed to identify trends and patterns within the data. Pro DBA’s SQL Server consultants worked with both the client and the data owner, incorporating several changes to the original specification during development.

After implementation, Pro DBA supported the solution through its bedding-in period. The finished product reduced the amount of manual analysis required from the client’s team.