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.


  • 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

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

    Ashutosh Satsangi | VP-Operations

  • 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