<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Sumit Kumar on Medium]]></title>
        <description><![CDATA[Stories by Sumit Kumar on Medium]]></description>
        <link>https://medium.com/@sumit22543?source=rss-5ea2cd63e6b1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*Qfxv_4G9pVpoKDnL9V8E0A.jpeg</url>
            <title>Stories by Sumit Kumar on Medium</title>
            <link>https://medium.com/@sumit22543?source=rss-5ea2cd63e6b1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 18:09:15 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@sumit22543/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Understanding the Different Types of Credit Risk Models]]></title>
            <link>https://sumit22543.medium.com/understanding-the-different-types-of-credit-risk-models-bc71504b6cd2?source=rss-5ea2cd63e6b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/bc71504b6cd2</guid>
            <category><![CDATA[credit-models]]></category>
            <category><![CDATA[towards-data-science]]></category>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[credit-risk]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Sumit Kumar]]></dc:creator>
            <pubDate>Thu, 06 Jul 2023 04:18:46 GMT</pubDate>
            <atom:updated>2023-07-06T04:26:32.938Z</atom:updated>
            <content:encoded><![CDATA[<ol><li>Algorithmic Trading Models</li><li>Asset Management Models</li><li>Capital Markets Product Pricing Models</li><li>Compliance Models</li><li>Financial Reporting Impairment Test Models</li><li>Global Private Banking Models</li><li>GPB Investment Models</li><li>GPB Credit Models Insurance Models</li><li>IRRBB Models</li><li>Liquidity Models</li><li>Operational Risk Models</li><li>Other Accounting Models</li><li>Pension Risk Model</li><li>PPNR Forecasting Product Control Models</li><li>Retail Collections Model</li><li>Retail Credit Capital Models</li><li>Retail Credit Other Models</li><li>Retail Expected Credit Loss and Economic Response</li><li>Models Retail Fraud Models</li><li>Scenario Generation and Expansion Models</li><li>Sherwood Models Traded Risk Model</li><li>Wholesale Credit Risk Models</li><li>WPB Customer Selection Models</li></ol><p><strong>Algorithmic Trading Models</strong></p><p>The term ‘<strong>Algorithmic Trading Models</strong>’ refers to models that provide estimates/predictions and create<br>inherent uncertainty of market features used in the context of Trading Algorithms as defined in the<br>Markets FIM B.11.29, including automated trading decisions, trade execution or both via electronic<br>exchanges and platforms.</p><p>All Algorithmic Trading Models must be assigned to the Model Category “<strong>Algorithmic Trading Models</strong>”,<br>and to one of the following subcategories, depending on the asset class each model is used to trade in:</p><ul><li>FX and Commodities;</li><li>Equities;</li><li>Global Debt Markets.</li></ul><p>All Algorithmic Trading Models’ use cases must be assigned to one of the following purposes:</p><ul><li>“<strong>Other — Algorithmic Trading–Client Execution</strong>”. This is the use of an Algorithmic Trading<br>Model to process orders provided by clients, either by internalisation or by orders sent on<br>exchanges and venues, generally with a view to reach an optimal equilibrium between market<br>impact and speed of execution, in a context where the Bank does not create market risk from<br>the execution.</li><li>“<strong>Other — Algorithmic Trading–Bank Trading</strong>”. This is the use of an Algorithmic Trading Model<br>to optimise the transactions conducted by the Bank itself for its own purposes (i.e. principal<br>basis)including hedging and market making, or on account of a client if the Bank incursmarket<br>risk from the execution.</li><li>“<strong>Other — Algorithmic Trading–Client Execution and Bank Trading</strong>”. This is the use of<br>Algorithmic Trading Model to trade for/by clients where the Bank creates market risk and for trading on Bank’s own behalf (i.e. principal basis), generally with a view to risk-manage the<br>inventory.</li></ul><h3>Asset Management Models</h3><p>Asset Management Group (“AMG”) models are being used primarily in a Fiduciary capacity to support:</p><ul><li>Portfolio construction</li><li>Risk management</li><li>Performance monitoring</li><li>Cash flow monitoring</li><li>Oversight of the Investment Team</li><li>Regulatory and client reporting</li></ul><p>AMG models includes:</p><ul><li>Models used to assist portfolio manager is their asset allocation and investment decisions,<br>which are not quant driven. For Example, Bank Analytics, Visualiser.</li><li>Models used to provide oversight of the portfolios; where no investment decisions are being<br>directly made based on the model outputs. For example, FiS APT, BBG LQA.</li></ul><p>Each AMG model must be assigned with the Model category as “<strong>Asset Management Models</strong>”.</p><p>Each model use case within this category must have the purpose “<strong>Other — Fiduciary Asset </strong><br><strong>Management</strong>” and may also be used for “<strong>General Stress Test</strong>” where applicable.</p><h3>Capital Markets Product Pricing Models</h3><p>Capital Markets Product Pricing models refers to models used in the valuation and risk management of<br>financial products that can be traded on exchange or Over the Counter (OTC). These are generically<br>referred to as “<strong>capital markets products</strong>”. These models may be used by Global Markets to price<br>products for Bank’s own positions or by Securities Services to price products for clients’ portfolios.</p><p>These products refer to tradable assets and liabilities such as:</p><ul><li>Shares, bonds and currencies, or to less liquid equivalents such as private equity, debt and<br>loans.</li><li>Listed and OTC Derivative contracts and structured products, for which a concept of Fair<br>Value is relevant.</li></ul><p>In the rest of this document, unless otherwise stated, “<strong>pricing model</strong>” will be used for “<strong>Capital Markets Product Pricing model</strong>”.</p><p>All pricing models owned by Global Markets must be assigned the model category “<strong>Global Markets </strong><br><strong>Product Pricing Models</strong>”. All pricing models owned by Securities Services must be assigned the<br>category “<strong>Securities Services Product Pricing Models</strong>”. Models used to price other categories of<br>products offered by the bank do not belong to this category. No sub-categories are required.</p><p>All model use cases for pricing models should be assigned one of the following Purposes for each<br>region and business:</p><ul><li>“<strong>Financial Reporting — IFRS13 Fair Values</strong>”. This is the front office estimation of accounting<br>value of a traded product, excluding any Fair Value Adjustment. This purpose also means the<br>model is used to price products, estimate market risks and design a hedging strategy. Models<br>that have a MUC with purpose “Financial Reporting — IFRS13 Fair Value” do not include<br>additional MUCs for Pricing and Market Risk purposes.</li><li>“<strong>Other — Other Risk Management</strong>”. This covers the use of the model for estimating the trading desk’s exposure to market risk factors, without any contribution to valuation. For example,<br>complex instruments that are directly marked to an observable market price, but for which a<br>model is needed to project market risks into separate factors.</li><li>“<strong>Other — Pricing and Valuation</strong>”. For models in the Global Markets Product Pricing Models<br>category this relates to use of the model for estimating a price for a capital markets product actually or potentially traded by the bank. For example, the price at which Bank should<br>market the product, or market values estimated for collateral purposes. For models in the<br>Securities Services Product Pricing Models category this relates to the use of valuation<br>models in the pricing of complex assets in the portfolios of clients of Securities Services. The<br>valuations and risk sensitivities that are calculated by Securities Services may be utilised by<br>the client for a number of purposes including but not limited to; collateral management,<br>portfolio valuations or risk reporting purposes.</li></ul><p>Uses of pricing models as inputs for other types of models belonging to other categories should not be<br>considered as separate use cases. Instead, the corresponding pricing models should be registered as<br>feeder models.</p><h3>Compliance Models</h3><p>Compliance models are a group of models used to mitigate financial crime and regulatory conduct<br>associated risk at the bank. Models within this group include those designed to combat several different<br>kinds of financial crime.</p><p>All Compliance models must be assigned to one of the following sub-categories:</p><p><strong>Anti-Money Laundering Transaction Monitoring (AML TM)</strong>A model which is involved in the monitoring of transactional activity to identify potentially suspicious behaviour for investigation<strong>Risk Assessment Rating</strong>A model which determines the risk probability of a given vector (e.g.<br>Customer Risk, Product Risk, Country Risk etc.).<strong>Sanctions Name Screening</strong>A model which is involved in the detection of named sanctioned<br>individuals.<strong>Sanctions Transaction Screening</strong>A model which is involved in the monitoring of transactional activity<br>for links to sanctioned individuals, countries or entities.<strong>Surveillance</strong>A model which is used to identify suspicious activity, market abuse<br>and financial crime, such as insider trading and market manipulation.<strong>Regulatory Compliance (NonSurveillance)</strong>A model which is used in the identification of mis-selling or conduct risk via:<br>Analytical tooling solutions that deliver connected risk insights across product lifecycles to identify customer segments who may not be receiving fair outcomes, or;<br>An intelligence led investigation service that can be deployed to analyse major internal and external regulatory conduct incidents and associated read-across.</p><p>Compliance Model Use Cases are to be assigned one of the following purposes:</p><ul><li>Financial Crime — Financial Crime Risk</li><li>Financial Crime — Fraud Risk</li><li>Financial Crime — Other</li></ul><h3>Financial Reporting Impairment Test Models</h3><p>The Financial Reporting Function owns and uses a small number of models for calculating impairment<br>of goodwill and of interest in certain associates.</p><ul><li>Impairment of Group goodwill.</li><li>Impairment of interest in Associates.</li></ul><p>Model sub-categories are not required.</p><p>The Model Owner must establish use cases in line with the balance sheet presentation of the asset<br>being tested for impairment. Models used by the Corporate Centre for impairment of associates must<br>be assigned as follows:</p><ul><li>BoCom: GBM, CMB and WPB</li><li>SABB: CMB</li></ul><p>Financial Reporting Impairment Test Models are used for:</p><ul><li>Financial Reporting — IAS 36 Value-in-Use</li><li>Financial Reporting — Fair Value Less Costs of Disposal</li></ul><h3>Global Private Banking Models</h3><p>This Model Category Standards (“MCS”) sets out additional granular minimum control requirements,<br>where required, for identifying, measuring and managing model risk for models in two categories:</p><ul><li>GPB Investment Models</li><li>GPB Credit Models</li></ul><h3>GPB Investment Models</h3><p>Investment advice and investment management are defined as the business of managing or providing<br>advice on investment portfolios or individual assets for compensation. GPB Products include: Funds,<br>ETFs, Fixed Income, Equities, Structured Products, Derivatives, Deposits, Foreign Exchange, Custody,<br>Thematic Swaps, Customised Baskets, Private Equity, Private Credit, Private Debt, Real Estate Equity,<br>Hedge Funds, Commodities and investment-linked insurance products.</p><p>Investment Models must be sub-categorised as follows:</p><p><strong>GPB Product / Portfolio Risk</strong>Models that produce metrics with the purpose of measuring the risk of the security and/or the portfolio of securities for investments purposes. Examples of models under this subcategory are: Volatility, Expected Shortfall, VaR, cVaR or instances where those model outcomes are evaluated according to hypothetical or historical scenarios (Stress Testing)<strong>GPB Asset Allocation </strong>Models that produce portfolios of investments in terms of percentages of allocation to assets according to a target risk/return.<strong>GPB Pricing / Tariff</strong>Models that produce a price or a benchmark price for a loan or the tariff, or a benchmark tariff for an investment service / trade / custody.</p><p>All Investment Models must be assigned with the purpose “<strong>Other — Fiduciary Investment Management</strong>”.</p><h3>GPB Credit Models</h3><ul><li>This category contains models that are developed for clients / facilities falling under the GPB scope and are used to measure or manage credit risk.</li><li>GPB Credit Models must be assigned to model sub-category of “PD”, “EAD” or “LGD”.</li><li>GPB Credit Models must be assigned an appropriate purpose:</li><li>Regulatory Capital — Pillar 1</li><li>Financial Reporting — IFRS9 ECL</li><li>Other — Credit Decisioning</li><li>General Stress Test</li></ul><p>Models that are built solely to generate <strong>Temporary Model Adjustments (“TMAs”)</strong> must be assigned the purpose “<strong>Regulatory Capital — Pillar 1 TMA</strong>”. Where a replacement model is awaiting external approval but is currently used solely to calculate RWA in order to quantify a TMA to be applied to the approved “<strong>In Use</strong>” model, then the replacement model must also be assigned the Purpose “<strong>Regulatory Capital — Pillar 1 TMA</strong>” until the replacement model is approved and used to calculate the RWA.</p><h3>Insurance Models</h3><p>The Insurance models category consists of models that are commissioned by the Insurance businesses<br>and associated functions for:</p><ul><li>Manufacturing and underwriting</li><li>Reinsuring</li><li>Selling and customer servicing of Insurance products</li><li>Business management</li></ul><p>The Insurance businesses and associated functions consists of</p><ul><li>Insurance manufacturing entities;</li><li>The Bermuda Captive; and</li><li>All areas and functions that form a part of Insurance or specifically support it.</li></ul><p>All insurance models must be assigned to one of the following sub-categories:</p><p><strong>Reporting</strong>Models used for local regulatory capital and reserving, IFRS reporting, Economic<br>Capital and Stress Testing.<strong>Other </strong>Models not used for Reporting but used for making decisions by Bank or by its<br>customers.</p><p>In scope purposes for Insurance model use cases:</p><ul><li>Financial Reporting — IFRS 4 Insurance Contracts</li><li>Financial Reporting — IFRS 9 ECL</li><li>Financial Reporting — IFRS 17 Insurance Contracts</li><li>Regulatory Capital — Insurance Pillar 1</li><li>Regulatory Capital — Insurance Pillar 2</li><li>Regulatory Capital — Basel–Group–Pillar 2A ICAAP</li><li>Regulatory Capital — Basel–Local–Pillar 2A ICAAP</li><li>Other — Asset-Liability Management</li><li>Other — Benefit Illustration</li><li>Other — Pricing and Profitability Monitoring</li><li>Other — Strategic Planning</li><li>Insurance models may also be used for stress testing, as appropriate</li></ul><p>Models used for pre-provision net revenue forecasting, including balance sheet and profit and loss items<br>must follow the PPNR Forecasting MCS. The Insurance Product Risk Rating model must follow the<br>GPB MCS.</p><h3>IRRBB Models</h3><p>The Interest Rate Risk in Banking Book (“IRRBB”) Models category covers models used in the<br>calculation of:</p><ul><li>Economic Value of Equity (“EVE”),</li><li>Net Interest Income (“NII”), and</li><li>Other measures required for the day to day IRRBB management, including hedging activities<br>and IRRBB regulatory reporting.</li></ul><p>This category includes IRRBB feeder models that are used as key model assumptions, such as:<br>behaviouralisation assumptions (prepayment assumption models, pass-on assumption models), market<br>data assumptions, pricing assumptions.</p><p>All IRRBB models must be assigned the Category “<strong>IRRBB Models</strong>” and Model Sub-Category of “<strong>IRRBB Metrics</strong>”, “<strong>Pre-payment/Attrition Risk</strong>”, “<strong>Pipeline Risk</strong>”.</p><p>All IRRBB models must be assigned the Purpose “<strong>Financial Reporting — IRRBB</strong>”.</p><h3>Liquidity Models</h3><p>Liquidity models defined as any measurement identified as a model per GMRS that is used as part<br>of liquidity and funding risk management of the bank.</p><p>All liquidity models must be assigned to one of the following sub-categories:</p><p><strong>Liquidity– Internal measures </strong>Models developed to measure the liquidity risk of the<br>bank’s portfolios based on internal design and<br>assumptions. This covers Internal Liquidity Metric,<br>Customer Stability Scorecard(CSS) Model, Intraday<br>Liquidity Risk, internal long term funding measurement or<br>any other model calculated to measure liquidity&amp; funding<br>risk based on internal rules and assumptions, including<br>forecasting LCR, NSFR, ILM etc.<strong>Liquidity–Regulatory reporting </strong>Models developed to be used for any regulatory<br>requirement.<strong>Liquidity- Fund Transfer Pricing </strong>Models that calculate internal cost of fund, Liquidity<br>Premium(LP) curve generation and cost allocation across<br>business lines<strong>Liquidity- Fund Transfer Pricing </strong>Models falling outside of the above defined sub-categories,<br>Other measures required for the Liquidity Management<br>activities within Group Treasury or Legal entity ALCM</p><p>Liquidity models are used for one or more of the following purposes:</p><ul><li>Financial Reporting — Liquidity Regulatory Reporting</li><li>Other — Liquidity Risk Management</li></ul><h3>Operational Risk Models</h3><p>Operational risk models are used to estimate the risk of loss arising from people, processes and systems.</p><p>Operational Risk Models must be sub-classified between “<strong>Operational Risk — Capital Models</strong>”, covering models used to calculate capital for economic capital and stress testing purposes, and “<strong>Operational Risk — Other Models</strong>” for all other models.</p><p>The following Purposes are assigned to Operational Risk Models:</p><ul><li>Regulatory Capital — Basel — Group — Pillar 2A ICAAP</li><li>Regulatory Capital — Basel — Local — Pillar 2A ICAAP</li><li>Regulatory Capital — Insurance Pillar 2</li><li>General Stress Test</li></ul><p>There are a number of Operational Risk models in development that will not be used for Capital<br>Reporting purposes. Standards for these models will be developed and incorporated into future versions<br>of the Operational Risk Model Category Standards. In the interim, the Model Owner must liaise with the<br>relevant Model Risk Steward for any additional control requirements.</p><h3>Other Accounting Models</h3><p>The Operational Accounting and Financial Control Functions own a small number of models. These<br>models are used for calculating a number of balances used as part of the period-end close process for<br>producing Financial Statements. These models support the following processes:</p><ul><li>Impairment test of investments in subsidiaries held by the Holding Company Group and other<br>similar investments across Bank.</li><li>Calculation of right-of-use assets and related lease liabilities as required by International Reporting Standard (‘IFRS’) 16.</li><li>Determination of IFRS9 Expected Credit Losses for immaterial sites using a simplified approach<br>from the Group’s consolidation system.</li><li>Determination of effective interest rate, and subsequent recognition of interest income and deferral of fees and expenses for credit cards in WPB in the UK, as required by IFRS9.</li><li>Calculation of provisions for customer redress, for miss-selling Payment Protection Insurance in<br>the UK, as required by IAS37.</li><li>Accounting for mortgages in the USA, including judgemental reserves as per US GAAP and IFRS,<br>and valuation of real-estate owned on the balance sheet.</li><li>Fair value calculations for the purpose of providing fair value disclosures as required by IFRS.</li><li>Calculation of the asset and liability values and associated measures for pension schemes as<br>required by IAS19</li></ul><p>Model sub-categories are not required. Other accounting models are used to generate outputs for use in Financial Statements, other than models covered in other MCS. Use cases for models in this category may have the following purposes:</p><ul><li>Financial Reporting — IAS36 Impairment Testing</li><li>Financial Reporting — IFRS16 Right of Use Assets</li><li>Financial Reporting — IFRS9 ECL</li><li>Financial Reporting — IFRS9 EIR</li><li>Financial Reporting — IAS37 Customer Redress</li><li>Financial Reporting — US GAAP</li><li>Financial Reporting — IFRS13 Fair Values</li><li>Financial Reporting — IAS19 Pensions</li><li>Financial Reporting — Other</li></ul><h3>Pension Risk Model</h3><p>The Pension Risk models category covers only risk measurement or quantification models for pension<br>risk. Pension Risk is defined as the risk:</p><ul><li>To Bank caused by its contractual or other liabilities to, or with respect to, a pension scheme<br>(whether established for its employees or those of a related company or otherwise), and</li><li>That Bank will make payments or other contributions to, or with respect to, a pension scheme<br>because of a moral obligation, or because Bank considers that it needs to do so for some<br>other reason</li></ul><p>The Pension Risk Model Category does not include models operated by third parties appointed by<br>Bank to produce pension accounting advice or data/reporting under IFRS or other accounting<br>requirements.</p><p>The model sub-categories covered in this MCS are limited to:</p><ol><li><strong>Economic Capital Models (EC)</strong> — for the purpose of Individual Capital Adequacy<br>Assessment Process (ICAAP) at group and local entity levels. These models are used for<br>the purpose of assessing Economic/Pillar2A Capital.</li><li><strong>Stress Testing Models</strong> — for the purpose of regulatory stress tests (including PRA, CCAR,<br>DFAST, EBA, HKMA, GIST) consequently these models are also used for the purpose of<br>assessing regulatory capital; and</li><li><strong>Internal risk metric reporting</strong> (including management information dashboard for the GPOF<br>and pension Risk Appetite setting). This use does not support regulatory capital<br>submissions and the purpose is to provide key pension risk management information.</li></ol><p>Pension Risk models are used for the following purposes:</p><ul><li>Regulatory Capital — Basel — Group — Pillar 2A ICAAP</li><li>Regulatory Capital — Basel — Local — Pillar 2A ICAAP</li><li>General Stress Test</li></ul><h3>PPNR Forecasting</h3><p>A ‘<strong>PPNR Forecasting</strong>’ model is one whose primary use is to generate forward-looking estimates (i.e.,<br>forecasts) of <strong>pre-provision net revenue (“PPNR”)</strong>, which is comprised of <strong>net-interest income (NII)</strong>, <strong>noninterest income or revenue (“NIR”)</strong>, and <strong>non-interest expense (“NIX”)</strong> according to the general formula <strong>PPNR = NII + NIR — NIX</strong>. This includes models used to forecast feeder subcomponents, e.g., asset and liability balance models, interest rate/spread models for NII and NIX, and fee rate models for NIR.</p><p>The Model Owner must ensure that each PPNR Forecasting model has at least one model use case<br>for the purpose of:</p><ul><li>“<strong>Other — Strategic Planning</strong>”, which models used for includes Annual Operating Plan (“AOP”)<br>and Monthly Forecasting, or</li><li>“<strong>General Stress Testing</strong>”.</li></ul><h3>Product Control Models</h3><p>The Product Control Model Category includes all the models owned by Product Control. This includes<br>models used for Fair Value Adjustments, Prudent Value Adjustments, Stress Testing and Hedge<br>Accounting.<br>All Product Control models must be assigned to the Category “<strong>Product Control Model Category</strong>”</p><p>Depending on the usage of the Model, each Product Control model and model use case must be<br>mapped to one of the following sub-categories and purposes, respectively:</p><p><strong>Model Sub-CategoryDescriptionPurpose</strong>Fair Value AdjustmentsModel use cases related to Fair value adjustments<br>impacting PnLFinancial Reporting — IFRS13 Fair Value AdjustmentsFinancial Reporting OCS OCIModel use cases related to the OCS reserve<br>posted as a reserve (other comprehensive<br>income).Financial Reporting — IFRS9 OCS OCIPrudent Value AdjustmentsModel use cases related to the prudent value<br>adjustmentsRegulatory Capital — Prudent Value<br>AdjustmentsStress TestingModel use cases related to the stress testing<br>usageGeneral Stress TestFinancial Reporting ECLModel use cases related to IFRS 9 Expected Credit<br>Loss impairment calculationFinancial Reporting — IFRS9 ECLFinancial Reporting Hedge AccountingModel use cases related to Hedge Accounting<br>processFinancial Reporting — IAS39 Hedge<br>AccountingProduct Control — Other<br>ModelsMinor Model Use cases: PnL attribution, curve<br>construction, FINREP purposes, IFRS 16Financial Reporting — IFRS16 Leases<br>Financial Reporting — Other<br>Regulatory Capital — Other<br>Other — Other Non-Risk Management</p><h3>Retail Collections Model</h3><p>Retail Collections Models are used to classify past due and/or delinquent customers into different risk<br>segments so that appropriate and timely collections actions can be applied.</p><ul><li>Segmentation is generally based on their probability to roll forward.</li><li>Collection actions include decisions over contact channels, effort intensity and operational<br>queues.</li></ul><p>Retail Collections Models include:</p><ul><li>Customer collections-specific segmentations across WPB Products (assigning risk level and<br>treatment at customer or account levels)</li><li>Customer collections-specific scorecards</li></ul><p>Retail Collections models do not include:</p><ul><li>Account Management Models such as customer behaviour scorecards, CLI/CLD models, etc.</li><li>Behaviour Scores that are used as input to other Retail Collections Models.</li></ul><p>All Retail Collections models must be assigned the Category “<strong>Retail Collections</strong>”. No sub-categories<br>are required.</p><p>All Retail Collections models must be assigned the Purpose “<strong>Other — Retail Collections</strong>”.</p><h3>Retail Credit Capital Models</h3><p>The Retail Credit Capital Models category covers models used in the calculation of pillar 1 capital<br>requirements for Retail Credit exposure: Probability of Default (“PD”) models, Exposure at Default<br>(“EAD”) models and Loss Given Default (“LGD”) models. This category does not include any other<br>models used to feed PD, EAD or LGD estimates such as behaviour scores, or any models used in<br>regulatory stress tests.</p><p>All Retail Credit Capital models must be assigned the Category “<strong>Retail Credit Capital</strong>” and Model SubCategory of “<strong>PD</strong>”, “<strong>EAD</strong>” or “<strong>LGD</strong>”.</p><p>All Retail Credit Capital models must be assigned the Purpose “<strong>Regulatory Capital — Pillar 1</strong>” except for models that are built solely to generate <strong>Temporary Model Adjustments (“TMAs”)</strong>, for which the Purpose “<strong>Regulatory Capital — Pillar 1 TMA</strong>” is used. Where a replacement model is awaiting external approval but is currently used solely to calculate RWA for TMA purposes1 , then the replacement model must also be assigned the Purpose “<strong>Regulatory Capital — Pillar 1 TMA</strong>”. This purpose should be removed when the replacement model is approved and used to calculate the RWA.</p><h3>Retail Credit Other Models</h3><p>The Retail Credit Other Models category primarily covers models that provide a prediction of risk at the<br>point of application or throughout the lifetime of the account. These are referred to as Application<br>scorecards and Behaviour scorecards.</p><p>The Retail Credit Other Models Category does not cover marketing/propensity, pricing, collections or<br>fraud models that are covered by other model categories.</p><p>All Retail Credit Other models must be assigned Model Sub-Category of either “<strong>Application</strong>”, “<strong>Behaviour</strong>” or “<strong>Other</strong>”</p><p>All Retail Credit Other models with Model sub-category of either “<strong>Application</strong>” or “<strong>Behaviour</strong>” must be assigned the Purpose “<strong>Other — Credit Decisioning</strong>”.</p><h3>Retail Expected Credit Loss and Economic Response Models</h3><p>The Retail ECL and ER models category covers models used:</p><ul><li>To calculate pre-Forward Economic Guidance (“FEG”) ECL estimates; and</li><li>To stress risk parameters based on economic scenarios for use in post-FEG ECL estimates<br>or stress tests</li></ul><p>All Retail ECL and ER models must be assigned the Category “<strong>Retail Expected Credit Loss and </strong><br><strong>Economic Response”</strong> and Model Sub-Category of “<strong>IFRS 9</strong>”, “<strong>CECL</strong>”, “<strong>ERM</strong>” or “<strong>Recovery</strong>”.</p><p>Model use cases must be assigned one of following purposes:</p><ul><li>Financial Reporting — IFRS9 ECL</li><li>Financial Reporting — CECL</li><li>General Stress Testing</li></ul><h3>Retail Fraud Models</h3><p>Retail Fraud Models are used to predict the probability of fraud in a banking transaction or an account<br>opening application. They may also be used to predict the susceptibility of customers to fraud or scams.<br>These models identify possible predictors of fraud associated with known fraud transactions/applications in the past to detect events that are abnormal. Model outputs are generally<br>used directly or indirectly (through rule sets) to approve, decline or refer application or transactions on<br>the basis of suspected fraud. They may also be used to provide appropriate warning messaging to<br>susceptible customers.</p><p>Fraud models include:</p><p>Fraud models include:<br>i. Models that detect potentially fraud card or payment transactions (both 1st party and 3rd party).<br>ii. Models that detect potentially 3rd party fraud applications.<br>iii. Models that detect potentially 1st party fraud application either directly or by targeting creditrelated operational losses.<br>iv. Models that predict susceptibility of customers to potential fraud or scams, for example<br>customer warning models.<br>v. Models that are designed to improve the efficiency of fraud operational alerts, for example<br>false positive ratio reduction models.</p><p>Fraud models do not include:</p><p>i. Models used for anti-money laundering.<br>ii. Models used for detecting sanctions activity.<br>iii. Models used for Know Your Customer activities.<br>iv. Models used for making credit/limit related decisions.<br>v. The platform/system where fraud rules/model are coded is not a model by itself.</p><p>Retail Fraud Models must be assigned to one of the following sub-categories</p><ul><li>1st Party Application Fraud</li><li>3rd Party Application Fraud</li><li>Card Transaction Fraud</li><li>Payment Transaction Fraud</li><li>Scams/Susceptibility</li><li>Retail Fraud Other</li></ul><p>All Retail Fraud models must be assigned the Purpose “<strong>Financial Crime — Fraud Risk</strong>”.</p><h3>Scenario Generation and Expansion Models</h3><p>Scenario Generation and Expansion (“SEG”) Models generate projections for a set of macroeconomic<br>and financial market variables used for:</p><ul><li>Stress testing for capital planning and capital adequacy assessment;</li><li>Forward Economic Guidance (“FEG”) for IFRS 9/CECL reserve calculations; and</li><li>Financial planning proposals.</li></ul><p>Scenario projections reflect an economic narrative over a specified time horizon. The economic<br>narrative could be characterised by a simultaneous or successive occurrence of a set of expected or<br>hypothetical economic events. An appropriate scenario could be:</p><ul><li>Internally designed based on firm’s vulnerabilities, financial risk assessments, or assumptions<br>on forward looking economic views.</li><li>Expanded from narratives directly mandated by the regulatory agencies.</li></ul><p>Scenario models could be used both in design, and expansion of such economic scenario narratives.</p><p>There is some form of an assembly characteristic that distinguishes a scenario model from other model<br>types. Scenario models can have multiple outputs, namely a set of mutually related economic or<br>financial market variables. Unlike many other models, scenario models do not aim to project a single<br>output, such as one particular revenue or loss metrics. Rather, scenario models project a set of<br>economic and financial market variables that best represent a particular economic narrative. Hence,<br>Scenario models are not balance sheet, market risk or financial projection models although their output<br>could feed those models.</p><p>Operational Risk scenario models are not covered by this category because those scenarios are based<br>on non-Financial risk events and have limited linkage to macroeconomic and financial market variables.</p><p>Examples of a scenario model are the Moody’s Macro model that feeds the FEG and stress testing<br>process.</p><p>SEG Models must be assigned the category ‘Scenario Generation and Expansion Models’. No subcategory is required.</p><p>SEG models within traded risk, for example the traded risk factor expansion model, should be classified<br>as Traded Risk Models.</p><p>Scenario models are feeder models and the model outputs are used for one or more of the following<br>purposes:</p><ul><li>Financial Reporting — IFRS9 ECL</li><li>Financial Reporting — CECL</li><li>General Stress Test</li></ul><h3>Sherwood Models</h3><p>Project Sherwood is the framework for making new lending pricing decisions, excluding pricing for<br>retention or back-book portfolio decisioning, using vintage profitability for all lending products (assets)<br>offered by Bank’s WPB Business. Sherwood models ensure that new account booking returns:</p><ul><li>Are optimised and meet a minimum segment and marginal Return on Tangible Equity<br>(“ROTE”) hurdle rates;</li><li>Have efficient use of capital; and</li><li>Credit risks taken are in line with rewards.</li></ul><p>All Sherwood Models must be assigned the category “Sherwood Models”. The RBWM B4.4.1 New<br>Lending Decisioning FIM defines the “in-scope” markets eligible for a Sherwood model. The Model<br>Owner must also register “Sherwood-like” models developed for non-eligible market portfolios (for<br>example, smaller portfolios like Sri Lanka Cards, Argentina Auto Loans etc.) in the central model<br>inventory with “Sherwood Model” as category, with agreement from the relevant Global Product Heads.</p><p>Each Sherwood model must be sub-categorised based on the product covered by the model: “Credit<br>Cards”, “Personal Loans”, “Mortgages”, “Auto Loans” and “Payroll Loans”.</p><p>All Sherwood models must be assigned the purpose “Other — Pricing and Valuation”</p><h3>Traded Risk Model</h3><p>Traded risk model categories consist of the following types of models:</p><p><strong>Traded Risk — Market Risk Models</strong>Models developed to measure the market risk of the bank’s<br>trading positions. This may arise due to changes in market<br>factors such as interest rates, credit spreads, foreign<br>exchange rates, equity or commodity prices.<strong>Traded Risk — Counterparty Credit </strong><br><strong>Risk Models</strong>Models developed to measure the counterparty credit risk<br>exposure of the bank’s trading positions. This may arise<br>due to changes in market factors such as interest rates,<br>credit spreads, foreign exchange rates, equity or<br>commodity prices.<strong>Traded Risk — Treasury Risk </strong><br><strong>Models</strong>Models developed to measure Treasury-related metrics.<strong>Traded Risk — Other Traded Risk </strong><br><strong>Models</strong>Other Traded Risk models falling outside of the above<br>defined categories</p><p>Regardless of the model category, all traded risk models must be assigned to one of the following<br>sub-categories:</p><p><strong>Simulation</strong>Scenario generation and risk factor simulation models<strong>Pricing</strong>Models that calculate PnL using pre-generated scenarios<br>and trade data<strong>Aggregation</strong>Models used to aggregate results calculated using pricing<br>models<strong>Simulation Pricing Aggregation </strong>Models that generate scenarios, calculate PnL and<br>aggregate the results.<strong>Closed Form Estimator</strong>Non-statistical models implemented as a formula<strong>Risk Factor Relationship</strong>Statistical models aiming at establishing relationships<br>between risk factors<strong>Other</strong>Models falling outside of the above defined sub-categories</p><p>Traded risk models are used for one or more of the following purposes:</p><ul><li>Regulatory Capital — Basel — Group — Pillar 1</li><li>Regulatory Capital — Basel — Local — Pillar 1</li><li>Regulatory Capital — Basel — Group — Pillar 2A ICAAP</li><li>Regulatory Capital — Basel — Local — Pillar 2A ICAAP</li><li>Other — Pricing and Valuation</li><li>Other — Initial Margining</li><li>General Stress Test</li></ul><h3>Wholesale Credit Risk Models</h3><p>Wholesale Credit Risk Rating Models are models where the output is either:</p><ul><li>Probability of Default (“PD”)</li><li>Loss Given Default (“LGD”)</li><li>Exposure at Default (“EAD”)</li><li>Slotting Approach</li><li>Expected Credit Loss (“ECL”)</li></ul><p>To meet:</p><ul><li>Regulatory requirements for calculating risk weighted assets for credit risk, or</li><li>Accounting requirements for calculating provisions requirements.</li></ul><p>Wholesale Credit Risk Rating Models must be sub-categorised based on the parameter produced by<br>the model:</p><ul><li>PD</li><li>LGD</li><li>EAD</li><li>Slotting</li><li>ECL</li></ul><p>Wholesale Credit Risk Rating Models are used for the following purposes:</p><ul><li>Regulatory Capital — Pillar 1</li><li>Financial Reporting — IFRS9 ECL</li><li>Financial Reporting — CECL</li><li>General Stress Test</li></ul><p>Wholesale Credit Non-Risk Rating Models are models where the output is not a PD, LGD, EAD or<br>Slotting output, for example CoLT. No sub-categories are required.</p><p>Wholesale Credit Non-Risk Rating Models are used for the following purposes:</p><ul><li>Regulatory Capital — Basel — Group — Pillar 2A ICAAP</li><li>Regulatory Capital — Basel — Local — Pillar 2A ICAAP</li><li>Other — Credit Decisioning</li></ul><h3>WPB Customer Selection Models</h3><p>WPB Customer Selection Models are used for customer targeting by propensity or behaviours,<br>customer elasticity, product usage, channel and digital engagements, and customer servicing, etc. This<br>category excludes risk (fraud, compliance, operational, credit, regulatory, etc.), Sherwood, finance, and<br>credit decisioning models.</p><p>Each model within the WPB Customer Selection category must be classified into one of the following<br>sub-categories:</p><ul><li>Cross-sell/Upsell, including upgrade/downgrade proposition,</li><li>Activation/Attrition,</li><li>Product/Transaction Behaviour, for example balance build, revolver, digital usage, etc.,</li><li>Customer Elasticity, for example to pricing, to product, to channel,</li><li>Customer Servicing and Communication, for example ATM Cash, Pega, Inbound routing,<br>channel migration, operational improvements, miscellaneous,</li><li>Other WPB Customer Selection</li></ul><p>Each model use case within the WPB Customer Selection Models category must have the purpose<br>“<strong>Other — Customer Selection</strong>”.</p><p>Hope you like the article, follow <a href="https://medium.com/u/5ea2cd63e6b1">Sumit Kumar</a> to get more interesting article related to Data Analytics and Data Science in Banking.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bc71504b6cd2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Basics of Credit Card P&L Drivers and Key concepts]]></title>
            <link>https://sumit22543.medium.com/basics-of-credit-card-p-l-drivers-and-key-concepts-4956eef84f36?source=rss-5ea2cd63e6b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/4956eef84f36</guid>
            <category><![CDATA[business-models]]></category>
            <category><![CDATA[credit-cards]]></category>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[towards-data-science]]></category>
            <category><![CDATA[kpi]]></category>
            <dc:creator><![CDATA[Sumit Kumar]]></dc:creator>
            <pubDate>Thu, 06 Jul 2023 04:15:04 GMT</pubDate>
            <atom:updated>2023-07-06T04:15:04.841Z</atom:updated>
            <content:encoded><![CDATA[<h3>What is a credit card ?</h3><p>A credit card is a payment/loan product that a customer can borrow against a line of credit at any time and can repay that loan with a great degree of flexibility.</p><h3>Parties involved in credit card transaction</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/722/0*zL_zD6eihFPNYxK6.png" /></figure><p><strong>Cardholder :</strong> Customer.</p><p><strong>Merchant : </strong>Stores where credit cards are accepted modes of payment.Some stores collaborate with banks to provide reward schemes on credit card use. Eg : Croma, Starbucks, Shoppers Stop</p><p><strong>Acquirer : </strong>Bank providing the EDC machine. Eg : Barclays, Citi, Axis Bank</p><p><strong>VisaNet : </strong>An association of card-issuing banks sets transaction terms for merchants, card-issuing banks, and acquiring banks. Eg : VISA, Master Card, Amex etc.</p><p><strong>Issuer : </strong>Bank that providing the credit cards. Eg : Barclays, Citi, ICIC, SBI, HSBC</p><h3>Credit Card Working Model</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/734/0*xTXxGHTfCiPuEdp7.jpg" /></figure><p><strong>Note: Costs of fraud or charge back are not included</strong></p><h3>Basic Credit Card Business Model</h3><p><strong>Opening Balance</strong></p><p><strong>+ Sales</strong></p><p><strong>+ Interest</strong></p><p><strong>+ Fees</strong></p><p><strong>- Payments</strong></p><p><strong>Closing Balance</strong></p><p>Every month (billing cycle period) a customer will receive a statement indicating</p><ul><li>The Balance from the Prior Month (opening balance),</li><li>The Total Sales</li><li>The Total Payments</li><li>The New Balance (closing balance)</li></ul><p>The Average Net Receivables (ANR) is the average of the opening and closing balances.</p><h3>Key concepts- Credit Limit</h3><p>Maximum allowable credit exposure on the credit card. Depending on market, it can have sub-components: Ex : Spend line and Lend line</p><h3>Spend line</h3><ul><li>Account’s total spend exposure (retail spends and cash advance) should not exceed the spend limit at any point. Customers are provided a little cushion to exceed the credit limit by a very small percentage</li><li>Spend limit has a cash limit component, Cash advances at any point cannot exceed the cash limit</li></ul><h3>Lend line (ALOP line)</h3><ul><li>All the accounts also have a lend limit outside the regular limit of cards. Customer can take installment loans on this limit</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/0*TgnTvaK1bFLINHhU.jpg" /></figure><ul><li>Customers are given line increases periodically.</li><li>Credit limit is dynamically distributed between Spend line and Lend line dynamically based on the usage of card of lend/spend.</li></ul><h3>Basic concepts- Minimum Amount Due</h3><p>The minimum amount due on a credit card is the amount required to pay to keep the account in good credit standing and to avoid penalty</p><ul><li><strong>It is calculated as x% of total amount due plus financial charges &amp; fees.</strong></li></ul><p>Any previous unpaid minimum amount and/or any amount by which you have exceeded the credit limit are added to the minimum amount due.</p><h3>Basic concepts- Delinquency Ageing</h3><p>If min due is not paid by the next statement date, the account is aged and is considered delinquent.</p><p>On system, ageing can be set to happen at due date or statement date. Generally it is set at statement date</p><p>With each subsequent month of not paying (or paying less than the min due), the account moves delinquency buckets as explained below. Some accounts might move from a worse bucket to a better bucket by paying.</p><p>The percentage of accounts and dollar amount that moves from a better bucket to the worse bucket is referred to as roll rate</p><p>‘<a href="https://trenovision.com/credit-monitoring-and-dunning/"><strong>Collection</strong></a>’ division tracks the month on month flow rates of these buckets. Their aim is to control the flow of the balances in higher buckets</p><p>All the unpaid principal balances are written off at 180 DPD. A customer could no more use the card after he/she has gone 90DPD and beyond.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/833/0*LFbwCm_XIU0nOQUG.jpg" /></figure><h3>Customer Swipes at a retail store to purchase groceries</h3><p><em>“Customer makes a purchase/ transaction”</em></p><p><strong>Interchange</strong></p><p><strong>Association Fee</strong></p><p><strong>Cost of Funds</strong></p><p><em>“Customer Earns Cash back or Points”</em></p><p><strong>Cash back amount</strong></p><p><strong>Rebate cost on points redeemed</strong></p><h3>Customer transfers balance or withdraws cash</h3><p><em>“Transferred Balance”</em></p><p><strong>BT Fulfillment Cost</strong></p><p><strong>Balance Transfer Fee</strong></p><p><em>“Withdrawn cash”</em></p><p><strong>Cash advance Fee</strong></p><p><em>“Crossed the credit limit”</em></p><p><strong>OCL Fee</strong></p><p><em>“Receives a statement”</em></p><p><strong>Statement Cost</strong></p><h3>Types of Credit Card customer</h3><p>There are mainly Four types of Credit Card customer :</p><p><strong>1. TRANSACTOR : “Customer makes full payments by due date”</strong></p><ul><li>Transacting Balance</li><li><strong>Cost of Funds</strong></li></ul><p><strong>2.</strong> <strong>REVOLVER : “Customer pays minimum due amount by due date”</strong></p><ul><li>Revolving Balance</li><li><strong>Interest</strong></li></ul><p><strong>3. SLOPPY PAYER : “Customer pays late by few days”</strong></p><ul><li><strong>Late Fee</strong></li><li><strong>Bad check Fee (if cheque bounces)</strong></li></ul><p><strong>4.</strong> <strong>DELINQUENT / DEFAULTER : “Doesn’t Bother to Pay”</strong></p><ul><li>Default Balance</li><li><strong>Written off amount net of recovery</strong></li><li><strong>Collections’/Recovery expense</strong></li></ul><h3>Components of the Credit Card</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/634/0*4n84XpuKYnOUrOhS.jpg" /></figure><p>Hope you like the article, follow <a href="https://medium.com/u/5ea2cd63e6b1">Sumit Kumar</a> to get more interesting article related to Data Analytics and Data Science in Banking.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4956eef84f36" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Quality Check Framework: A Systematic Approach to Data Validation and Tool for Driving…]]></title>
            <link>https://sumit22543.medium.com/data-quality-check-framework-a-systematic-approach-to-data-validation-and-tool-for-driving-f09948864dd4?source=rss-5ea2cd63e6b1------2</link>
            <guid isPermaLink="false">https://medium.com/p/f09948864dd4</guid>
            <category><![CDATA[data-validation]]></category>
            <category><![CDATA[data-quality]]></category>
            <category><![CDATA[banking]]></category>
            <category><![CDATA[towards-data-science]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Sumit Kumar]]></dc:creator>
            <pubDate>Thu, 06 Jul 2023 03:53:39 GMT</pubDate>
            <atom:updated>2023-07-06T03:57:55.754Z</atom:updated>
            <content:encoded><![CDATA[<h3>Data Quality Check Framework : A Systematic Approach to Data Validation and Tool for Driving Business Results</h3><figure><img alt="Data Quality Check Framework" src="https://cdn-images-1.medium.com/max/480/1*PWTZqy5MZ2QmHiqeNQBhuw.gif" /></figure><p><strong>Why Data quality check framework is important ?</strong> Because it ensures that the data you are using is accurate, complete, and consistent. This is important for a number of reasons, including:</p><ul><li><strong>Better decision-making:</strong> When you have high-quality data, you can make better decisions about everything from product development to marketing campaigns.</li><li><strong>Reduced costs:</strong> Poor data quality can lead to a number of costly problems, such as errors in customer records, inaccurate inventory levels, and missed opportunities.</li><li><strong>Increased customer satisfaction:</strong> Customers expect businesses to have accurate and up-to-date information about them. When data quality is poor, customers may experience problems such as incorrect billing, lost orders, or difficulty reaching customer service.</li><li><strong>Enhanced compliance:</strong> Many businesses are subject to regulations that require them to maintain accurate data. By ensuring that your data is high-quality, you can reduce your risk of non-compliance and the associated penalties.</li></ul><p>There are many ways to insure data quality. Here are some of the most important:</p><ul><li><strong>Define data quality standards:</strong> The first step is to define what you mean by “high-quality data.” This will vary depending on your specific needs, but it should include criteria such as accuracy, completeness, and consistency.</li><li><strong>Implement data profiling:</strong> Data profiling is the process of understanding the characteristics of your data. This includes identifying data types, missing values, and outliers.</li><li><strong>Clean data:</strong> Once you have a good understanding of your data, you can start to clean it. This involves identifying and correcting errors in your data.</li><li><strong>Implement data validation:</strong> Data validation is the process of checking data for errors before it is used. This can be done manually or using automated tools.</li><li><strong>Monitor data quality:</strong> It is important to monitor the quality of your data over time. This will help you identify any problems early on and take steps to correct them.</li></ul><p><strong>To ensure that the data which you’re using for driving business results is correct, you can implement the following basic validations :</strong></p><ol><li><strong>Observation Count Check</strong></li></ol><ul><li>Records count variance from previous month’s data ( <strong>ex. critical zone with &gt;5% variance</strong> )</li></ul><p><strong>2.Metadata Details Check</strong></p><ul><li>New variable added in table (<strong>ex. month specific variables</strong> )</li><li>Variables dropped from table (<strong>ex. month specific variables</strong> )</li><li>Variable with change in variable length.</li><li>Variable with change in variable format (<strong>ex. Date</strong>)</li></ul><p><strong>3.Numeric Data Values Check</strong></p><ul><li>Missing numeric data entries</li><li>Numeric entries with 0&#39;s</li><li>Check Standard Deviation</li><li>Primary key voilation</li></ul><p><strong>4.Aggregate/Range Checks</strong></p><ul><li>Minimun Values Check (<strong>ex. Salary</strong>)</li><li>Maximum Values Check (<strong>ex. Salary</strong>)</li><li>Total Values Check (<strong>ex. Balance</strong>)</li><li>Mean Values Check (<strong>ex. Balance</strong>)</li><li>Median Values Check (<strong>ex. Spend</strong>)</li></ul><p><strong>5.Character Data Values Check</strong></p><ul><li>Missing Character Check (<strong>ex. Missing City</strong>)</li><li>Distinct category count/details (<strong>ex. Relationship Type</strong>)</li><li>Valid characteristic values (<strong>ex. Gender M/F</strong>)</li><li>Catergory frequency distribution (<strong>ex. Active/Inactive</strong>)</li><li>Primary key voilation</li></ul><p>Hope you like the article, follow <a href="https://medium.com/u/5ea2cd63e6b1">Sumit Kumar</a> to get more interesting article related to Data Analytics and Data Science in Banking.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f09948864dd4" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>