What does data cleansing do and what are its benefits?

Data cleansing involves the enrichment and rearrangement of data to meet a specified standard format followed by clustering of duplicate accounts of the same customer in order to assign a unique customer identity number to every individual customer

What is standardized data?

Standardized data is data that has been arranged into a pre-specified or standard format, which thus simplifies the task of identifying and verifying data.

Why should data cleansing be done and why should a unique customer identity be created?

Data cleansing offers a wide range of benefits that would help the company in the long and short run. There is though, an immediate need for banks, according to the RBI circular DBOD. AML. BC. No. 2 /14 .01.001/2011-12, to enhance customer information, remove duplicates and assign unique customer identities, the importance of which is evident from the recent fines imposed by the RBI on several leading banks for failing to comply with the norm. Moreover cleansing offers for fulfilment of the database, customer satisfaction and also allows for better implementation of CRM for marketing purposes.

What does Nelito offer with regards to cleansing?

Depending on the banks requirements and priorities Nelito can offer different cleansing mechanisms with regards to the fields to be cleansed. If the banks requirement is purely regulatory then only the fields that are critical according to the RBI's norms will be cleansed but if the bank wants other parameters like contact numbers or STD codes to be cleansed, then it can also be done.

What are the fields critical to the RBI for cleansing?

The customer name, permanent address, date of birth, gender, Any national identity card and in case of companies the name of the company, the principal place of operation, mailing address of the company and the telephone/ fax number is essential.

What are the benefits of cleansing those fields that are not critical to RBI?

Certain details may not be important to the RBI, but they could aid the bank significantly for some of its activities. The bank gets full knowledge of the customer which provides for easy identification or verification of the customer. Also fully cleansed customer records are easier to de-duplicate than partially cleansed records and will result in higher quality of the de-duplication process. Moreover, completely cleansing the fields will help the bank in householding customers and also for providing other features which enables the bank to offer better service to its customers.

Will the cleansing be done on the bank's premises or offsite?

Depending on the bank's preferences it can be done either way.

Does Nelito offer data cleansing as a tool or as a service?

Data cleansing is offered as a service by Nelito

What software, tool or medium does Nelito use to cleanse the data?

Nelito uses IBM quality stage

Can Nelito offer support and means to collect missing data?

It can if the bank so desires

How is entry of missing data done? Will the entered data be standardized?

If the bank has a data entry software which validates and imposes constraints on the data to be entered in the fields, thus standardizing it, then it can be entered directly at the bank's site using the bank's software. If the bank however, does not have such a data entry software then Nelito will provide a specialized interface which imposes the above mentioned constraints in order to standardize data at the entry level.

Will Nelito help with the extraction and update of data?

The extraction and update of data is not Nelito's responsibility but it can be added if the bank so desires.


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


    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


    Navin A Bijur | Manager - IBD

    The Shamrao Vittal Coop Bank Ltd