Dialog's extensive client portfolio

Browse through some of Dialog's success stories. For more information please contact us at dialogit@dialog.com.au.

National Australia Bank

National Australia Bank

National Australia Bank (NAB) is a ­financial services organisation employing over 40,000 people, operating more than 1,800 branches and service centres and responsible to more than 460,000 shareholders.

NAB Asia is a small but rapidly growing contributor to the NAB Group business.

The flow of NAB Asia’s data from its core banking systems was a patch-work of point-to-point solutions. This lead to difficulties in reconciling data, complexity of support and inhibited transition of the NAB Asia core banking systems.

While this may be an acceptable position for systems that are used only by NAB staff, the quality and availability of these data stores did not meet the standards necessary for making data available to customers.

Solution

  • Dialog was engaged in the Asia Data Repository (ADR) Project to provide expertise in the Database Design and Data Modelling of the Asia Data Repository.
  • The ADR solution was built to centralise customer data from all NAB Asia upstream systems. This data is then made available for NAB Asia and Group wide Reporting and is also provided to existing NAB downstream systems.
  • Throughout the course of the project, Dialog worked closely with the Business Analysts and, as a result, became closely involved in the Business and Data Analysis of the numerous upstream and downstream systems.
  • Dialog liaised with the NAB Security, Infrastructure and Solution Architects to assist with architectural decisions and supported the ETL Design, Development and Testing of the ADR solution.
  • The Asia Data Repository (ADR) solution was built to centralise customer data from all NAB Asia upstream systems. This data is then made available for NAB Asia and Group wide Reporting and is also provided to existing NAB downstream systems.

Technologies

  • Microsoft SQL Server for ADR Staging, Operation Data Store and Data Mart databases
  • Microsoft SQL Server Integration Services for Extract, Transform and Load (ETL)
  • Microsoft SQL Server Analysis Services for Online Analytical Processing (OLAP) cubes
  • Microsoft Excel for ad hoc Reporting ETL processes developed to consume data extracts from systems
  • ETL processes developed to deliver data extracts to numerous downstream systems

← Return to Portfolio items
  • Involved
  • -
  • Committed
  • -
  • Can Do
  • -
  • Always