PROJECT EXAMPLE

Industry: Financial Services

Functional area: Finance Management & Controlling

Project: Regulatory Reporting

Project Success

Challenges:

  • Over 20 disparate data sources across several business functions
  • Increased demand (frequency) for delivering reports
  • Constantly changing requirements (legal and regulatory)

Solution:

  • SPOT (Single-Point-of-Truth) Back-End Architecture
  • Automated generation and distribution of reports

Technologies & Methods

Front-End: SSRS, APEX, Excel, MDS

Back-End: IBM DB2, Informix, Oracle, SQL Server, SSAS, SSIS, Informatica PowerCenter, SAP Data Services

Abacus DaVinci, Oracle Financials

Data Vault, Dimensional Modeling

Competences

BI Architect

ETL Developer

Front-End Developer

Project Manager

Special Know-How

Regulatory reporting for banks and insurance companies – SolvV / CRR, BISTA, HGB Bilanz, IFRS, COREP, ALMM, FINREP