Instituto para la Protección al Ahorro Bancario Automation Demonstration - PowerPoint PPT Presentation

liam
slide1 l.
Skip this Video
Loading SlideShow in 5 Seconds..
Instituto para la Protección al Ahorro Bancario Automation Demonstration PowerPoint Presentation
Download Presentation
Instituto para la Protección al Ahorro Bancario Automation Demonstration

play fullscreen
1 / 20
Download Presentation
Instituto para la Protección al Ahorro Bancario Automation Demonstration
346 Views
Download Presentation

Instituto para la Protección al Ahorro Bancario Automation Demonstration

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Instituto para la Protección al Ahorro Bancario Automation Demonstration

  2. 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.

  3. 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.

  4. 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!!

  5. 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.

  6. 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

  7. 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

  8. Screenshots

  9. Screenshots

  10. Screenshots

  11. 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)

  12. 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

  13. Screenshots

  14. Screenshots

  15. Screenshots

  16. Screenshots

  17. Survey’s results

  18. Survey’s results

  19. Status Report

  20. Thank you for your attention www.ipab.org.mx