1 / 19

Nelito Systems Limited Data Quality

finacle data management services, core banking vendors, core banking implementation<br>http://www.nelito.com/services/finacle-cbs-implementation.html<br>

isabelfabiano
Download Presentation

Nelito Systems Limited Data Quality

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nelito Systems Limited Data Quality © Nelito Systems Ltd. 2013 1

  2. Table of contents About Us Business Drivers Solution Architecture Case study Differentiators 3 6 10 12 13 © Nelito Systems Ltd. 2013 2

  3. Our Commitment “Solutions that Perform” We solve business problems of our clients through solutions based on customer involvement, deep domain knowledge, innovative technologies and personalized service support We deliver what we commit 3 © Nelito Systems Ltd. 2015

  4. Corporate Snapshot Head Quartered at Mumbai 45+ Service Locations 800+ Professionals 100+ Banking Clients • • BFSI Focused Solutions with own IPR Products and product based services in the area of Transaction and Payment Systems, Analytics and DW, Mobility & e-Governance Leadership position in Automated Data Flow (ADF) MIS vis-à-vis compliance to Central Bank of thecountry Providing Manpower with varied Professional IT Skill sets to Banking and Non Banking organizations in India & International locations. • • Partners 4 © Nelito Systems Ltd. 2015

  5. Offerings Portfolio :- Products Analytics Transaction & Payment Systems Payment systems Mobility Mobility & DW Transaction & Payment Systems • Mobile Banking • CTS • Transaction: • Data Quality • Internet Banking • NACH • FinCraft CBS • Cleansing • Door Step Banking • SWIFT • PACS • Classification • E-KYC and • IMPS • SACOS • Enhancement Customer On- • DBT • AML Boarding • ABPS • Reconciliation • LMS 5 © Nelito Systems Ltd. 2015

  6. Offerings Portfolio : Services Data Payment management services Transaction IT Services Mobility management services management services Transaction & Payment Systems • BPO Services • IT Infrastructure Management Services • Professional Consulting Services • 3rdParty CBS Implementation and Roll out Services • Customer On- Boarding services • Card management services • Reconciliation services • Customer identification services • Financial inclusion • NPA monitoring and management • SAP BO • IBM Cognos • Data quality services • Data enrichment services • MIS • CTS • MMS • SWIFT services 6 © Nelito Systems Ltd. 2015

  7. Customers FinCraft CBS Banks Other Banks 7 © Nelito Systems Ltd. 2015

  8. Customers Other Solutions and Services International e-Governance Hutch Telecom Sri Lanka 8 © Nelito Systems Ltd. 2015

  9. Business Drivers • Unique customer ID (UCIC) • Identifying High risk customers • Complying with KYC process • Anti Money Laundering Fraud Detection • TDS • Rating requirements and delinquency analysis • Upsell/cross sell/analytics/alerts • Reduction of transaction costs by moving them to alternate channels like mobile/internet banking • Customer House holding Knowing the Customer better 9 © Nelito Systems Ltd. 2013

  10. Sources of Poor Quality Data Causes Careless data entry/lack of validations/direct updates Duplicate customers records Incomplete records especially Loans/Advances Lack of standardization Lack of data attributes Inconsistency in data Forms and other Paper Sources Spellings Legibility Purposeful Misrepresentation of identity by customers    Data Corruption is Unavoidable        10 © Nelito Systems Ltd. 2013

  11. Impact of Poor Quality Data Impacts Time wasted in reconciling data (CBS&LAPS) Fraud Lack of cross selling Duplicate mailings Customer Dissatisfaction Cannot move customers to alternate channel Compliance Problems Duplicate customer references    Impacts your ROI      11 © Nelito Systems Ltd. 2013

  12. Nelito’s End to end Data Quality solution Data Analysis Design of data standardization rules Data health analysis Auto standardization process using tool User interface for Manual data cleansing Rerun of standardization process De duplication report Out put data to source data base Final check 12 © Nelito Systems Ltd. 2013

  13. Data Quality Tool Data Warehouses, MDM Solutions Load Transform SAP R/3 ERP Mainframe CRM Call Ctr SAP CRM M e t h o d o l o g y DE duping Custom RDBMS Survive Enrich Match Certify Standardize Investigate Postal Reference CRM SFA Siebel Business Rules Business Reference PC Data SCM Personal Reference i2 Other Reference Finance HR People Soft External Data Validate Business Rules Profile Sources Extract Staging Master Data Integration: Assess – Align – Harmonize – Load 13 © Nelito Systems Ltd. 2013

  14. Data Quality process INPUT RAW DATA Manual CLEANSE PROCESSED DATA PROFILING Standardization DEDUPE MATCH CLUSTER REPORT Text report as .csv Name & Address Unique ID generated for matches- UCIC PAN and other IDs Web report as html/pdf Name & any configurable criteria 14 © Nelito Systems Ltd. 2013

  15. Case Study Clients – Bank of Maharashtra ,1825 branches UCO Bank – 2500 branches UBI bank – 1800 branches Bank’s requirements Implementation Highlights Benefits to the bank Allocating unique customer ID (UCIC) Identify High risk customers & verify with international lists.k Grouping for TDS , rating requirements and delinquency analysis. Marketing/upsell/cross sell/retention/analytics/ alerts. Cleansing of key fields leads to better operations and customer satisfaction. Reduces frauds Improve branding, image, marketing efforts. Savings in postal costs. Correct internal/external MIS and other reports. Better gender classification, segmentation, cross sell Pre account opening verification. Implementation for Bank of Maharashtra :- 10 branches in 1 months UCO Bank :- 15 branches(in process) UBI Bank :- 5 Branches in 15 days Implementation of De- Duplication engine • • • 15 © Nelito Systems Ltd. 2013

  16. Differentiators for Nelito’s Data Quality Solution Enhanced Data Dictionaries for • 70 million Indian names • 20 million Mobile nos. • 70 million Addresses ,Postal codes • 20 million Email IDs Data Cleansing done on various database of CBS VIZ • Finnacle • TCS BaNCS Customized Data Profiling • 20 Customer Sectors covered • Customer Categorization (Age,Gender,Caste,Religion) • Capability to match records for House holding 16 © Nelito Systems Ltd. 2013 (contd.)

  17. Differentiators for Nelito’s Data Quality Solution Prebuilt Data Warehouse Design for Retail Banking and MIS– Data Marts Easily configurable for any source database structure End to end solutions • BPO Services for data collection and data punching of missing data like  Postal addresses  Mobile no's, • Integration of external statutory sources like  PAN no. integration  AADHAR to UADAI seeding. 17 © Nelito Systems Ltd. 2013

  18. Product Road Map BPO services for manual data updating with decision workflow system Building of Various Data Marts End to End integration with Core and ancillary systems Real Time Data De Duplication Check Visual Reports for presentation of Data Health 18 © Nelito Systems Ltd. 2013

  19. THANK YOU Get in touch 205-208 Bldg 2, Sector 1 Millennium Business Park Navi Mumbai 400 710 Tele: (+91-22) 6713 5555, 6713 5600 Fax: (+91-22) 6713 5503 © Nelito Systems Ltd. 2013

More Related