Use Cases

Global Bank: “Manual Reconciliation”

COMPANY

NAME: Global Banking & Financial Services Company
SIZE: 100,000 employees in 70 countries
INDUSTRY: Financial Services

CHALLENGES:

  1. Problems in the reconciliation of the same transaction being passed over and presented in multiple data streams
  2. Analysts were manually identifying duplicate and inconsistent entries in excel spreadsheets of security sales data.
  3. Data lacked standard naming conventions and other attributes like client names, status, unique ID

Situation: Manual Reconciliation 
To help clients reconcile data from various different data streams. Also, identify outliers that cannot be identified. Two data streams with similar transaction information but data is presented differently and there is no unique identifier.

Solution: DRaaS + SmartJoin 
Multilevel semantic join based on Hadoop i.e. two hoops of jump and then get joins from there. The schema is for ‘MultiJoin’. Configurable rules engine for validation of incoming and outgoing data and create rules for project

Estimated Savings: Approximately 25% resource savings identified as currently, 75+ people are doing this exercise manually

Large Bank: “Build Customer Master Data”

COMPANY

NAME: National Level Securities De-materialization institution
SIZE: Handles 3 or 4 of securities held & settled in dematerialized (Demat) form in the Indian capital market
INDUSTRY: Financial Services

CHALLENGES:

  1. Poor quality of Data
  2. Multiple ways of association
  3. Large volumes and multiple stakeholders in each account
  4. Depository participants to provide know your customer proofs

Situation: Federal Bank requirements require account holders data to be correct, complete, standardized, up to date and de duplicated to ensure accurate reporting.

Solution: Used SmartJoin™ + DRaaS to build customer master data. Included data discovery, cleansing and deduplication along with survivorship, manual validation and updating. Added innovations in toolset to adapt to legacy data, systems and quality of information, created rule framework and best practices for governance.

Result: Bank could identify + 99% of unique customers. Helped bank generate high-quality reports, comply with data related regulations. Help embark on a journey of using customer master data for cross-selling and up-selling

Asset Management Company: “Improve data quality, comply with KYC norms”

COMPANY

NAME: Global Asset Management Company
SIZE: –
INDUSTRY: Financial Services

CHALLENGES:

  1. Increase in cost of acquiring new customers
  2. Crowded & competitive industry with little differentiation in offerings
  3. Existing customers facing client manager turnover
  4. Focused product marketing with the profile of customers needed to identify risk-averse and cautious  customers
  5. Existing CRM affected by poor data quality
  6. Consolidated view of the client not available. All data managed at a single fund subscription level

Situation: Increase existing customer base while maintaining margins. Data fragmented and of poor quality impedes client service & retention management.

Solution: Hexanika was provided limited data (names, addresses, bank details, product type). Provided geographic profile of customer by breaking up addresses into granular elements and profiling customers as urban or rural and further profiling customers based on neighborhoods within urban agglomerates.

Result: Provided a 52-week deduplication service with zero downtime for the last 6 years while maintaining, managing, and providing customizations for over 70 million records.

Global Bank: “Use Data Quality for KYC management & channel strategy”

COMPANY

NAME: Midsize bank
SIZE: 100 branches
INDUSTRY: Financial Services

CHALLENGES:

  1. De-centralized banking
  2. Lack of availability of common customer view. Know your Customer (KYC)
  3. Data spread across rural, semi-urban and urban geographies
  4. The day-to-day business relied on personal rapport. Clean data is not a requirement and hence poor data quality

Situation: Client’s aggressive growth transformation and execution of strategic roadmap entailing customer, product, and credit re-alignment, process centralization, and technology up-gradation. Required KYC compliance of all accounts across the Bank to prevent freezing of non-compliant accounts; branch rationalization to determine which branches to retain; consolidated view of the customer to migrate data to the new core banking system and for CRM.

Solution: Cleansed, standardized, enriched and deduplicated account data; provided geographical boundaries; created unique customer/household views; classified records on address, contact & identity data; identified accounts for KYC information and developed channel strategy based on addresses/contact data at the household level

Result: Determined channel strategy for data collection and set the stage for bank’s expansion strategy.

Securities Institution: “Enable compliance; monitor suspicious trends”

COMPANY

NAME: National level securities de-materialization institution
SIZE: Handles ¾ of securities held & settled in dematerialized (Demat) form in the Indian capital market
INDUSTRY: Financial Services

CHALLENGES:

  1. Poor quality of Data
  2. Multiple ways of association
  3. Large volumes and multiple stakeholders in each account
  4. Depository participants to provide know your customer proofs

Situation: Record linkage for meeting compliance. Identify associated parties with multiple Demat accounts. Multiple Demat accounts were being used for numerous applications resulting in increased chances of allotment of IPO subscriptions

Solution: Hexanika’s expertise, toolsets, and services were used to define linkages and association rules for identifying parties within legacy data. Customer data was matched against the UN sanctions list; adapters were implemented to convert and normalize incoming data formats to standard formats and reject bad data using business rules.

Result: Customized dashboards were created to enable regulatory compliance. Reports were fed back into depository participants (DP) by the client. For specific customers “Know your customer” proofs were provided by DP to complete the cycle

Credit card processing company: “Removal of duplicates in online screening”

COMPANY

NAME: Large multinational financial services company engaged with the processing of credit cards for a midsize bank
SIZE: 13 million customers
INDUSTRY: Financial Services

CHALLENGES:

  1. Maintain turnaround time of under 10 seconds for every new inquiry
  2. More than 24 tokens needed to be matched across several rules involving multiple addresses and multiple phone numbers
  3. Poor and incomplete quality of data

Situation: Existing system for credit screening loan applications against an existing database of 13 million records missed a large number of duplicates. Waste of time and resources expended in manual eyeballing effort. Possible extension of credit to high risk

Solution: Hexanika’s expertise was used to match data and seamlessly integrate with the client’s loan transaction system. Multiple iterations were made to ensure negligible skips compared to the existing system while ensuring maximum relevant matches made against the existing customer database, negative individual database, and negative company database. A flexible rule-based system was implemented for continuous improvement in match quality and there was the flexibility to add new fields for new match rules without IT involvement

Result: Relevant matches increased by 60%

Insurance Company: “Value based customer segmentation with k-clustering”

COMPANY

NAME: Private Insurance Company
SIZE: 6 million insurance policy database
INDUSTRY: Financial Services

CHALLENGES:

  1. Database with profile & investment behavior variables existing & derived. Around 100 variables analyzed for completeness, availability and standard values
  2. Narrow variables for customers and agents using distribution analysis
  3. Optimization of cluster identification for customer groups with similar behaviour patterns
  4. Link agent segmentation tree with customer segmentation tree to understand impact of agent behaviour on customer retention

Situation: Identification of key market segments based on profile and potential for cross-selling & up-selling of new policy types.

Solution: Identified distinct customer and agent segments for targeting new products. The process involved: data preparation, data enrichment, data quality assessment, data transformation, exploratory analytics, building analysis tables, cluster optimization, k-clustering trials, shortlisting clustering trial results for policy owners and agents, drill down OLAP analysis & recommendations on which segments to target and which product to target

Result: Distinct clusters identified indicating lifecycle behavior of customers along the value chain. Based on this, the client designed a new marketing & distribution strategy

European Bank: “Online de duplication for timely, quality credit screenings”

COMPANY

NAME: Global European Bank
SIZE: Top 10 global bank by market cap
INDUSTRY: Financial Services

CHALLENGES:

  1. Data variation challenge
  2. Change of key transaction systems in a short time frame despite continuous environment change while simultaneously managing data inflows from legacy and new systems.
  3. Ensure business continuity. Round-the-clock services were given notwithstanding public holidays as those were high loan days.
  4. Provide good match quality and accuracy without compromising on speed to handle a large number of loan applications coming every day

Situation: Mitigate the risk of bad loans and accompanying possible reputational risk. Client critical requirement was timely and as ‘accurate as possible’ detection of potentially fraudulent applications across personal loans, auto loans, mortgages, secured loans, business loans, etc. Identify with a high level of confidence similarly sounding names & addresses in good turnaround time to enable downstream processes of credit scoring and application approval

Solution: Provided customized ETL to validate, verify and join disparate structures across 7+ types of loan systems in record time; customized middleware to schedule & manage incoming data based on data type and operation; optimal match methodology; and customizable reports of match results for downstream decision making

Result: Client achieved its stated goals in the required time to ensure timely & quality credit screening

Insurance Company: “Value based customer segmentation with k-clustering”

COMPANY

NAME: Private Insurance Company
SIZE: 6 million insurance policy database
INDUSTRY: Financial Services

CHALLENGES:

  1. Database with profile & investment behavior variables existing & derived. Around 100 variables were analyzed for completeness, availability, and standard values
  2. Narrow variables for customers and agents using distribution analysis
  3. Optimization of cluster identification for customer groups with similar behavior patterns
  4. Link agent segmentation tree with customer segmentation tree to understand the impact of agent behavior on customer retention

Situation: Identification of key market segments based on profile and potential for cross-selling & up-selling of new policy types.

Solution: Identified distinct customer and agent segments for targeting new products. The process involved: data preparation, data enrichment, data quality assessment, data transformation, exploratory analytics, building analysis tables, cluster optimization, k-clustering trials, shortlisting clustering trial results for policy owners and agents, drill down OLAP analysis & recommendations on which segments to target and which product to target

Result: Distinct clusters identified indicating lifecycle behavior of customers along the value chain. Based on this, the client designed a new marketing & distribution strategy

Insurance Company: “Identify unique customer identity”

COMPANY

NAME: Insurance Company
SIZE: 4 million policyholders
INDUSTRY: Financial Services

CHALLENGES:

  1. Identify unique policyholders. Telephone numbers and addresses were interchanged for various records of the same policyholders
  2. Adopt different matching strategies for urban and rural areas
  3. Understand date of birth patterns and classify records as high/low integrity
  4. Assign correct gender
  5. Manage old and new telephone numbers and multiple phone numbers in the same field
  6. Put in place process for end to end implementation

Situation: Identify unique customers and households to increase operational efficiency, cross-selling, and understand cumulative exposure across a single entity. Identify additional duplicates not detected by the in-house IT team. Data spread over urban/rural areas; data quality poor and with variations; and large percentages of matches missed using internal

Solution: Defined various linkages and association rules for identifying unique customers and households. Used cleansing and de-duplication and supported by expert eyeballing services to identify outliers. Provided client with a set of high and low confidence matches for final certification and upload.

Result: The client achieved its stated target of identifying the unique customers and households and achieved a better understanding of the total number of policies held by each individual and household

New Bank: “Merge customer database across 8 different financial entities”

COMPANY

NAME: Commercial Bank
SIZE: 900,000 customers, 500 branches, over 1,000 ATM’s. Total assets: US$2.9 B
INDUSTRY: Financial Services

CHALLENGES:

  1. Scale: 900,000 + customers to be migrated to the new system
  2. Heterogeneous Databases Identify and extract relevant data from 8 host systems
  3. Tight time frames: Total one-month time frame with tight time window with actual migration
  4. Incremental data handling: Manage incremental data added during the process of migration
  5. Manage risk: Ensure accurate de-duplication and no loss of information or customer records

Situation: Client converting from finance company into a commercial bank. Data from Group’s 8 different legal entities required to be merged into a single cleansed and unique

Solution: Provided expertise in working with data-related issues to identify problem sources and fixes. Identified data-related issues, anomalies, and exceptions in the data and resolved them. Customized rules generated and provided for various types of data- depending on customer type (corporate or individual), customer location, and customer address. Incremental de duplication round to match new records added in interim while cleansing process going on with already matched data.

Result: Client achieved its stated goals in the required time-merging various databases into a single entity.

Menu