Enhancing IQ

ICICI

Bank, India's second-largest bank, has a network of about 560 branches and

extension counters and over 1,900 ATMs. It offers a wide range of banking

products and financial services to corporate and retail customers through a

variety of delivery channels and through its specialized subsidiaries and

affiliates in the areas of investment banking, life and non-life insurance,

venture capital and asset management.

There was a distinct

need for a solution that can integrate all data sources across the enterprise,

is user-friendly and above-all a scalable solution that can support the growing

business needs of ICICI Bank. The SAS enterprise intelligence platform was an

ideal fit in this business scenario, as it empowered the bank with the key

cornerstones of manageability, interoperability, scalability and usability.

The key departments

involved in evaluating the solution were the technology management group and the

retail and corporate banking teams. The IT team was convinced that the Web-based

solution would enable ICICI Bank to provide information access to all users

across the enterprise, it would address greater number of queries and could be

deployed as one point of control in setting up permissions.

The IT team at ICICI

Bank was also keen to know if it would be possible for the SAS solution to

report on warehouse or marts. This helped in broadening the 'scope' with the

introduction of SAS ETL Server for creation of marts. Also the vision behind the

setting-up of an enterprise-wide business intelligence platform helped the team

to establish a distinct need for SAS E-Miner.

A single enterprise BI

platform with a centralized metadata management helped in broadening the vision

for consolidating their existing BI environment and establishing an enterprise

intelligence platform.

With prior experience

of reporting through multiple reporting systems, the business users in the

retail and corporate banking arm of ICICI Bank still had two separate sets of

concerns. These included migration of existing reports and whether the User

Interface was user friendly. To address issues related to migration and

scalability, SAS suggested a point of contact (PoC) and involved both business

as well as the IT users during the PoC.

The bank identified a

complex Cognos Cube-which had complex transformations in computation of moving

averages, flow through buckets, delinquency periods. The bank provided SAS with

the raw data (flat file) from which the Cognos Cube was created and also a

Cognos IDQ which SAS exported into flat file.

The success of the PoC

was the key turning point for SAS. The vision of consolidating the BI

environment and setting up an enterprise-wide Business Intelligence Platform had

been created. ICICI Bank was able to establish the requisite framework for

deriving one version of truth and reporting through an enterprise-wide reporting

system.

Pravir Vohra, chief

technology officer, ICICI Bank said, “Adoption in ICICI Bank is in the line

with our strategy to consolidate our business intelligence framework and

establish an enterprise-wide business intelligence platform.”

Team DQ



mail@dqindia.com