Instituto para la Protección al Ahorro Bancario Automation Demonstration
REIMBURSEMENT PROCESS • Is modeled after the International Guidelines set forth by the FSF work group; • Is certified under the ISO 9000:2001 standards; • Has received the Innovation and Quality Award from Mexico’s President; • Requires corporate,accounting, operational and systems information, • In-house software development.
SYSTEMS USED • Monitor of insured deposits (MID) • Used to verify bank’s compliance, by law, to classify it’s insured deposits • Claims Management (Reimbursement Process) • Keep track of the claim form submitted from the depositor, and payment status.
MONITOR OF INSURED DEPOSITS • Feed from Bank’s information; • Three main input files: Depositor, Accounts and Depositor-Account relations; • Banks could issued it’s own information layout or used IPAB’s layout; • Includes the projected balances to future dates of the accounts; • Non insured deposits or special conditions marks; • Report rejections and clarifications (Warnings and errors) • Files used as an output to Claims Management (Reimbursement Process) Avoid the garbage principle: Garbage in, then you will get garbage out. It doesn’t matter how automated is your process!!
Technical features • Stand alone application (runs from a PC or a laptop, with a local database). • System specifications: • Windows XP – OS. • Microsoft .NET – Development tool. • Crystal Reports – Reporting tool. • SQL Server 2000 – Local database. • Two basic functions: • Local management of the information of the visited banks: layouts loading and business rules validation. • Information reporting and exporting under predefined filters.
Layout 3. Relational data Layout 1. Personal info Layout 2. Account info Information flow Customer Data Bank’s systems Depositor Data Bank review setup • Workteam registration • Timeline • Information dates • Information samples generation • Data loading • Layouts loading into MID database (applying layout specifications) • Stage 1 validation • Date and filename • Structure • Data types • Field length • Catalogs
Information flow Data integrity review • Stage 2 validation • Business rules • Unique ID per person • Duplicated rows • Specific field validations • On screen errors review Information reporting and analysis • Brief and detailed errors report • Information exporting in Excel format • Support data for the information analysis
LPAB* / Rules CLAIMS MANAGEMENT (REIMBURSEMENT PROCESS) • Are fully automatic under a WEB-based environment (Intranet / Internet) • Consolidate all individual accounts held by client • Perform a pro rata separation of joint accounts • Convert account balances toUDIs1 • Report rejections and clarifications • Perform automatic check issuing and wire transfers • Record comments made during file review in each step of the process • Control sent and received files between each step of the process • Issue deviation reports • Publish information of claim status via Internet • Supports more than 1.5 millon accounts, 500 concurrent users, 6 seconds average • response time • * Ley de Protección al Ahorro Bancario / Law for the Protection of Bank Savings • 1 Unidades de Inversion / Investment Units (unit of account indexed to inflation)
Submit claim forms • Password • Entry Survey • Validation of contracts & balances ANALYSIS DB Bank’s systems Data Base • Accreditation of identity, representation, inheritance. • Exclusions • Issue summons Normal Procedure 1 INITIAL UPLOAD Start REGISTRATION LEGAL • Depositors and Contracts • Exclusions / Clarifications • Pro rata balance separation • Generation of claim forms Authorized Limit ($) Balance ≤ Simplified Procedure 2 CERTIFICATION PAYMENT Immediate Cash Payment End • Checks & wire transfers • Scanning and storage of files • Exit survey • Normal: • Validation of information • Simplified: • Validation of file 1 Normal Procedure 2 Simplified Procedure • Unregistered depositors • Names, balances, accounts and/or share of account requested do not match database • Firms, beneficiaries, legal representatives • Excluded depositors • Individuals present claim form • Name in ID matches system • Not excluded • Accounts, balances and share of account match system’s data base FAILED BANK
Thank you for your attention www.ipab.org.mx