Rabobank
High-volume data transformations for regulatory reporting for the second largest bank in the Netherlands
Summary
High-volume data transformations for regulatory reporting at a major Dutch bank, with metadata-driven source-to-target mapping, workflow orchestration, and a full migration from on-premise to Azure.
The Challenge
Rabobank faces complex regulatory reporting requirements mandated by Dutch and EU financial regulators. Data from multiple source systems must be transformed and dynamically mapped to target reporting formats, a process involving high volumes, complex mappings, and strict accuracy requirements.
The Solution
Embedded with the Rabobank team across a multi-year engagement to develop and maintain a data transformation platform. Built metadata management for dynamic source-to-target mapping across multiple source systems, workflow orchestration, and data staging and optimization. Migrated from on-premise servers to Azure. Built and maintained CI-CD pipelines with automated security scanning.
The Results
Rabobank's regulatory reporting team gained a reliable, auditable platform for high-volume data transformations. Metadata-driven configuration replaced manual coordination. The Azure-native architecture supports the bank's scale requirements, and the Agile DevOps delivery model enables continuous improvement as regulatory requirements evolve.
Client (Industry)
Rabobank (Banking)
Services
Custom Software Development Web App Development Database Development API Development and Integration Cloud Migration and Deployments Agile DevOps
Technologies
SQL Server REST APIs Azure Azure DevOps YAML bicep Blazor MudBlazor HTML5 CSS3 C# MSTest PetaPoco SOLID SQL Express Splunk ETL Microsoft Graph OpenID OAuth Entra SSO CI-CD Infrastructure as Code Checkmarx SonarQube
Metadata management for complex, dynamic mapping of multiple source systems to one target system
Orchestration, workflow, and system integration for data staging, optimizing, and mapping data from source to target systems
Joe is an outstanding developer and I have had the pleasure of working with him for the past two years.
His deep and thorough knowledge of DevOps practices and tools has greatly contributed to our team's success.
Joe is approachable, always willing to help and takes the time to assist others, ensuring that everyone on the team feels supported.
His ability to process complex thoughts and communicate them clearly is impressive. Joe was a tremendous asset to our team and any company would be lucky to have him.
Marjolein Wiegerinck
Product Owner, External Reporting
Rabobank
I had the privilege of working with Joe as a fellow developer. He is incredibly knowledgeable, technically strong, and highly disciplined. Joe's ability to collaborate, communicate effectively, and support the team made him an invaluable colleague.
Beyond his technical skills, his approachable and positive nature made working with him an absolute pleasure. I highly recommend Joe and know he'll excel in any role he takes on.
Piyush Gakre
DevOps Engineer in .NET
Rabobank
