Project Overview

Designed and implemented a regulatory data migration platform for the Central Bank of Tunisia, enabling secure and compliant exchange of financial data between commercial banks and the BCT. Defined XML schemas and XSD validation rules, migrated critical datasets from Oracle to SQL Server, and built a centralized data warehouse to support regulatory reporting and advanced analytics.

Key Features

• Regulatory Data Exchange Design: Defined XML schemas and XSD validation rules for financial files exchanged between commercial banks and the BCT, ensuring strict compliance and data integrity.
• Data Migration: Migrated critical datasets from Oracle to SQL Server, enabling smoother integration with Power BI
• Data Warehouse Architecture: Designed and implemented the architecture of a centralized data warehouse to consolidate banking data for regulatory reporting and analytics.
• Business Intelligence Enablement: Enabled advanced analysis and regulatory reporting through SQL Server-based data models and dashboards.

Challenges & Solutions

The main challenge was ensuring compliance with strict regulatory standards while migrating large volumes of sensitive banking data across heterogeneous systems. To address this, I implemented XML/XSD validation rules to enforce data integrity and designed robust ETL pipelines to securely transfer data from Oracle to SQL Server. The centralized data warehouse architecture provided a single source of truth for consistent reporting and analytics across all datasets.