Commercial Digital

Commercial Digital

1. Digital Dash Board

   • Reports
     • Payment Activity looks like
     • How many active ?
     • How profitable these clients are ?
     • Top clients using Digital ? ( There is a perception that top clients are using digital)
     • Top 10 Clients ?
     • Year or Year growth?
     • Number of registrations?
     • # Active clients?
     • Total Payments
     • Rolling 12 Months
     • Average last year
     • Does channel being used by the clients we want to use by ?
     • Number of Multiple payment types used ?
       • Questions ideas from Single client view Jan2015  slide -19
     • Number of Approver groups and Panels
       • Questions ideas from Single client view Jan2015  slide -19
     • Number of active & inactive Users,registarations and administarators
     • Number of Channels
     • Number of Operational Sites
     • KPI : Client marked as High , Medium and Low
   • SSAS Cube
     • Star Schema
       • ETL
         • Migrated DB
           • COL
           • LOLI
           • Dial -up Applications
         • COB
         • One MI
         • M4V
   • Business Model
     • Client / Customer
       • Data Sources
         • New Digital
           • CBO
           • Payments
         • Old Digital
           • COL
           • LOLI
           • Dial-up Applications
         • GDW
           • CMD
             • All Legal Entity's
           • MM ( Mid Markets)
         • One MI
           • Financial Data
             • SQL SERVER ,SSAS & Excel
         • M4V
           • SME Data
             • Might be Oracle or SQL Server ???
         • OCIS
           • All SME records
       • Client
         • Client known as Untimate Relationship Group or Super Group. But all clients may not come under super group - some clients are big, they may have different COG's and different Legan Entity's. It could be one single big company who are group of clients ... ( can I assume like that ?) 
         • URG (Ultimate Relationship Group) or Super Group
         • Legal Entity
           • Legal Entity will have CMDID
         • Legal Entity Group
           • Legal Entity Group will have CRISPID
         • Client will have CRISPID
       • Channels
         • Legacy System
           • COL
           • WID&V
           • POLI
           • THINLINK
           • EBS/DIAL-UP
       • System
         • OCIS MI
           • Contains facility and account information for customers of Lloyds TSB Corporate and Wholesale Banking Operations.
         • COM CMD
           • Provides a view of the customer across LTSB heritage Corporate Markets
         • CRISP
           • Contains facility and account information for customers of Lloyds TSB Corporate and Wholesale Banking Operations.     
       • Business Units
         • FI ( Financial Institutions)
         • GC ( Global Corporate)
         • MM ( Mid Markets)
         • BSU/ Non-Core
         • SME
         • International
         • RBB
         • Private Banking
         • Overall Average