Home » Success Stories » Banking & Insurance » Data warehouse rebuild in order to analyze consumer credits risks
PRISM Print E-mail

Data warehouse rebuild to analyze consumer credit risks

 

Activity and interventions


  • Functional & IT Audit of existing data warehouse system
  • Proposal of a new technical architecture solution adapted to the needs
  • Training sessions and customer handover

 


 Technical environment


  • Business Object
  • ORACLE
  • Open source SQL Developer (PL/SQL)

 


Key figures


  • 30 End-Users
  • Project duration: 5 months
 Context

 

The main aim of the project is a wide Business Intelligence knowledge transfer, particularly about  best practices related to new data warehouse setup and load.

The 5 project members didn’t have enough background regarding the Business Intelligence processes and methodologies:   

  • Many manual tasks
  • Poor data quality
  • Users’ queries response time too long

 

 

 

ALTEN's achievements

 


The following tasks were performed:

  • Audit of the old Business Intelligence system and identification of  the action points to rebuild a new efficient data warehouse.
  • Proposal of new data warehouse architecture  and standard methodologies.
  • Set up training courses for project members (architecture, dimensional data modeling, PL/SQL, BO Designer).
  • Coaching the project team on 2 sub-projects.

 

 

 

ALTEN's Added value

 

Alten’s added value to this project was reflected in different ways:

  • Complete approach of Business Intelligence life cycle.
  • Full tasks automation.
  • Library of standard development procedures, reusable for next projects.
  • Increase in project team’s autonomy for future projects.
  • Reduction of IT development and maintenance cost.