Executive Summary :

Nrit has designed, developed, deployed and continues to support custom applications at a large leading Bank. One of the projects successfully implemented by Nrit at this Bank is a custom data mart and predictive modeling application that has been successfully used to increase home equity credit line utilization by over 15% in the target customer base.

A data warehouse that was designed and implemented for a major Bank to provide a complete picture of a customer's relationship over multiple products and to improve bottom-line profitability by increasing credit line utilization levels. The project was implemented for a select group of customers and used to analyze and plan strategy to improve utilization over 50% for the target group.

Nrit has been implementing enterprise-wide BI solutions for Fortune 100 Clients for the last 9 years. Nrit has a vast experience in development of Data Warehouse and Data Marts, with a strong understanding of Data Architecture and Data Modeling along with the experience of using ETL tools such as Informatica, Ascential (Prism), Decision Stream (Cognos), and Acta (now part of BO). Other reasons for choosing Nrit were:

Nrit designed and implemented an integrated application suite that streamlined and automated the entire loan processing workflow for specific loan products offered by the Bank. Our solution utilized a hybrid PC-mainframe paradigm where the IBM mainframe essentially became "black-box" data server, and the PC-based SQL Server database became the repository of intermediate workflow oriented data. A robust, graphical, client server application written in Visual Basic and Transact SQL to provide a user friendly system that markedly cut down the learning curve and increased productivity many fold, and provided visibility, analysis, and business logic to complicated financial transactions.

 

Designed and implemented a data warehouse for the Bank to provide a complete picture of a customer's relationship over multiple products. The project was implemented for a select group of customers and used to analyze and plan strategy to improve utilization over 50% for the target group.

Nrit's solution included an embedded rules-based engine that guided the representative's discussion with the customer based on the customer's overall profile with the bank over multiple product lines. This allowed for better targeting of cross-selling opportunities and increased utilization of the loan and other products available to the customer. The engine also helped to guide discussions with customers who wished to inquire about and utilize different loan products such as the fixed rate loan option of their home equity credit lines and discuss multiple and inter-related scenarios.