Anti–Money Laundering Detection Services for a Card Provider
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Leading Public Bank
Industry
Banking, Financial Services & Insurance
Business Problem
The client wanted to store Indian card–transaction data inside India to comply with regulators, analyze historical activity for potential money–laundering patterns and generate actionable reports. Strict data–localization rules, unprocessed 16–month backlogs and the need to detach India–specific logic from a global platform forced the business to re–engineer processes, deploy new infrastructure and build fresh analytics capability–each task carrying operational, regulatory and technical risk.
Outcome
- India–only analytics cubes.
- Clean 16–month data backlog.
- Regulatory–ready reporting layer.
Challenges
- India data blocked abroad
- Legacy procedures interwoven globally
- Separate servers and mapping required
Solutions
- Build new cubes for India money–laundering analysis
- Map India servers to India modules within global services
- Execute separated procedures and load data into cubes
- Generate validation reports on loaded data
- Develop business reports on top of analytics cubes
Technical Environment
- MS SQL Server, SQL, T–SQL
- Power BI
Results
- Data backlog of 16 months processed and loaded
- 100% separation of India procedures from global set–up
- End–to–end reporting cycle established within new cubes