Development of a finance data platform
Objective
A large European Union bank wanted to build a platform which can provide a consistent quality of data and cater to the various groups outside the CFO organization for financial and regulatory reporting.
Challenges
- Lack of expertise required to build a centralised platform flexible enough to cater to different lines of business
- Volume and variety of data needing integration in the central platform
- Manual processing required to generate detailed drill-downs to a granular level
Approach
- Profiled 1,400+ attributes and defined checks for the 14 data feeds
- Provided CRISIL SMEs to fill skill gaps in technical roles with advisory experts to design and build the platform
- Used Spark, Tableau, Apache Sqoop and Kafka in finance data platform build
Impact
- Analyzed and integrated 14+ source feeds in a single centralized platform, creating a single point of access for different business lines
- Reduced the time to refresh 12GB of data down to 5 minutes
- Generated 200+ reports for group disclosures to facilitate drill-down into granular data
Questions