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

  • The Meticulousness of efforts to ensure customer delight by each of the team member during the course of the project is appreciable. - Data Archival Project

    R. Ganesh (Senior Manager)

    Indian Overseas Bank
  • Overall we are happy with the services provided by Nelito. The implementation team is sensitive to our support requirements and does a good job.

    Vinayak Khadye (Chief Digital Officer)

    Finanzmart Services Pvt Ltd
  • We are extremely thankful to the whole team who have devotedly committed and created this excellent database. Much of our time was wasted in data retrieval from i link where we were facing lots of issues.

    You have given us an awesome product which is superior to our Finacle itself in its display capabilities. The great idea of taking pdf/word/excel option is simply superb. Merging the party code and Finacle CIF and account numbers are another feather in the cap.

    N Sampath Kumar (Branch Manager)

    Corporation Bank
  • We have successfully made Nelito's Fincraft Software for NBFC live in early March for LOS,LMS and Sanjiv Khalkho, Arijit Chakraborty with his team have been very instrumental in making this software live . I would like to appreciate on the turnaround time during the go live phase of the team in getting some of our key requirements done and helping our users to use the software for recording and disbursing all the sales from the software.

    In technology side I would like to praise Pramod Navale and Ganesh Khetmalis for in depth knowledge of the product and their technical skills is outstanding. Looking forward for the continued relationship for our next release and whole of 2018.

    Prateek P Katyal (CTO)

    WheelsEMI Pvt. Ltd
  • "We are extremely pleased with the kind of support extended by you and your team for our year end work. Although whole bunch of people worked for making the support seamless from your end, my special thanks to following resources. Anurag, Arpit, Arvind, Pranit, Suraj, Udgran, Nilesh, Leena and Udgrand. Also, thanks to all others who have supported us directly or indirectly at your end."

    Ananda Padebettu (IT Manager)

    The Nav Jeevan Co-op Bank Ltd.
  • "For a Bank of our size, this system suffices and is very cost effective. Almost all of the bank’s activities run on the one system. Nelito constitutes a partner more than a supplier and the relationship includes provision of the bank’s underlying technology as well as its Fincraft range of applications."

    Chairman

    The Nainital Bank Ltd.
  • "The best mix of functionality and technological support and our vision of “Cash Less and Paper Less” work environment for Sonata has come true with our technological partner Nelito. I highly recommend FinCraft Core Microfinance platform and especially integrations with a number of third party services."

    IT Head

    Sonata Finance Pvt. Ltd.
  • CBS

    "We are happy to use FinCraft Data Archival & Retrieval solution from Nelito Systems; it has given huge ROI in terms of saving revenue by retiring legacy applications. We get all desired reports in a timely manner from the solution."

    Assistant General Manager (CBS)

    United Bank of India
  • Custom Application Development testimonial

    "Proactive & professionally supportive, technically skilled team."

    General Manager

    Federal Bank
  • DGM

    "My bank is working with Nelito from the last about 9 Years and the services provided by the company may prolong our association."

    Sikander Gupta | CEO

    The Jammu Central Co-op Bank Ltd.
  • DGM

    "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)
  • DGM

    "As Vendor strict adherence to process & procedures. Risk Mitigates in Place. Flexible to customer requirements."

    Dinesh Negi | VP (Clg)

    DCB Bank Ltd
  • DGM

    "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
  • DGM

    Support services provided for Swift is really up to the mark and meets all clients requirement. Kindly keep this ongoing.

    Rudolph Banis | Head - IT CBS and Application Management

    IndusInd Bank
  • DGM

    Excellent

    Navin A Bijur | Manager - IBD

    The Shamrao Vittal Coop Bank Ltd