Enquiry Form

Blogs

Leveraging the power of BI thru Business objects

Updated On : October 2015  |  by Amol S. Khanvilkar

Banks worldwide and especially in India and other developing economies are burdened with Non-Performing Assets (NPA). The provisioning requirements put a huge burden on the banks and financial institutions to closely monitor their assets and take preventive steps to recover, monitor and prevent defaults in this area on a proactive basis. There is also a need for reporting extensively to regulatory authorities and internal management. The operational costs for this activity is huge and erodes the profitability of the banks.

Financial institutions have a need and also do proactively govern NPA. However, this activity has number of challenges. Details on credit facilities/collateral granted to a customer often lie scattered across different banking systems. There are also a number of related details like guarantors, insurance details, documentation details, collection patterns, industry patterns are also spread across various systems and internal monitoring purposes.

While there are a number of activities related to monitory of recovery of NPA’s , the most critical component is to have an instant view of the entire portfolio for reporting , analysis and decision taking at various levels of the organization.

Nelito Systems has automated the entire process of requirement gathering, extract transform loading, reporting and publishing in various points leveraging a central data repository initially built as part of its MIS ADF initiative which works for more than 6 public sector banks in India.

A comprehensive NPA warehouse has been pre built for various dimensions and measures. ETL processes have been customized for data cleansing, enrichment and logical aggregates to speed up the decision making process. Prebuilt dashboards give a bird's eye view of various scenarios. Some functionalities that are supported are indicated below.

  • 360 degree NPA Overview
  • Classification wise, Product Wise, Country Wise, Region Wise, State Wise, Zone Wise, etc
  • Drill downs on dashboards Top N NPA branch/Products and Accounts
  • Top N NPA Branches
  • Year/Month wise NPA comparison
  • Graphical View – NPA Ratios, Branch Performance, Category Wise, Interest Rate Wise, etc.
  • Recovery in NPA Accounts/Overdue Accounts- Classification wise, Product Wise, Country Wise, Region Wise, State Wise, Zone Wise, etc – What if analysis

The ETL processes work seamlessly with core banking solutions like Finacle, FinCraftTM, TCS Banks and other loan management software.

Technology from SAP has been leveraged to build reports using Crystal Reports( all regulatory reports are available) ETL has two components, homegrown for smaller institutions and SAP extraction tool (DI).

Dash Boards are prebuilt using Business objects, the same can be published.

Slice and dice and drill down can be achieved by using SAP BO – Web intelligence.

Data quality is ensured leveraging technology and wide usage of industry standard MIS information directories.

The smart use of technology and a prebuild solution gives quick return of investment to automate the process of monitoring and prevention.

Advanced analytics for better collection management like propensity to default, credit scoring etc. will be custom built for institutions during the project engagement.

Nelito also offers consulting and expertise to leverage licenses and data that the bank already has in its core systems. Deliverables include process, technology, customization, streamlining ETL, enhancing data marts, building of dashboard, queries and ongoing support on SAP tools like Business Object Dashboard, Webi, Explorer, Crystal Reports, DQ (Data quality), DI (Data Integrator).

Also Read

Leave Comments :

CLIENT SPEAK

  • CBS

    “The Bank is associated with M/S Nelito since 2002. M/S Nelito Systems Ltd has been our CBS vendor since 2009. The Products, quality of service offered by them are excellent. They have a very good support team and are trained enough for handling any type of situation.”

    D K Kandpal | Vice President (IT)

    Nainital Bank
  • MIS ADF

    “Good & Co-operative.”

    Ronniee Gupta | DGM

    UCO Bank
  • CBS

    “We appreciate your local team who continuously supported & assisted our team to meet the goal.”

    Nagendra Nath Sinha | Principal Secretary IT

    Government of Jharkhand, Ranchi
  • CBS

    Knowledge and service provided to the bank is beyond expectation. And we would definitely engage and recommend solution to others .

    Rachelle F. Rivas | IT Project Manager (Senior Manager)

    Bank of the Philippine Islands (BPI)
  • CBS

    • As Vendor strict adherence to process & procedures
    • Risk Mitigants in Place
    • Flexible to customer requirements

    Dinesh Negi | VP (Clg)

    DCB Bank Ltd
  • Custom Application Development testimonial

    Bank has implemented CBS of Nelito Ltd in the year 2008-09 in phase manner. Also integrated RTGS/NEFT, CTS, MMS etc which help us in smooth automation of banking operation.

    K.T. Wadia | CEO

    The Sutex Co-op bank Ltd
  • CBS

    Experience during development of Rating Engine Module has been good in the context of commitment to meet timelines & lot of hard work has been put by Nelito's team.

    Ashuthsoh Satsangi | VP-Operations

    SMERA
  • CBS

    Everything was successfully implemented and tested. The implementation was professionally done in a very efficient and cooperative manner. Migration was very smooth.

    Frithjof Ramb | Vice President

    SBI- Frankfurt, Germany
  • CBS

    Nelito and its team has always been supportive and efficient in achieving the tasks set up by the Dept. Apps developed by the software engineers for the Public Health Dept have proved to be excellent among the top competitors and have been acclaimed for its effective service delivery to the end user at the grass root level which is the foremost object of any Govt organization. Many thanks for the sincere efforts.

    Sanjay Kamlakar | Under Secretary to GoM

    Govt of Maharashtra
  • DGM

    "We appreciate Nelito team who were always on time and responsive to our needs and changing ideas. They worked efficiently from the project inception to its completion in a timely and professional manner. Their understanding of this space has been invaluable to the success and launch of 'PMAY CLSS' app."

    Susanta K. Padhi | DGM

    National Housing Bank