1 / 11

Compliance Database Development Project

CONFIDENTIAL---FOR INTERNAL PURPOSES ONLY---CONFIDENTIAL. Compliance Database Development Project. Presentation for Application Development Group Global Capital Markets January 2001. The Current Process. D&T Seattle gets tape from Client Statistical sample is selected from total pool

ina-carey
Download Presentation

Compliance Database Development Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CONFIDENTIAL---FOR INTERNAL PURPOSES ONLY---CONFIDENTIAL Compliance DatabaseDevelopment Project Presentation for Application Development Group Global Capital Markets January 2001

  2. The Current Process • D&T Seattle gets tape from Client • Statistical sample is selected from total pool • D&T LA receives email from Seattle with Excel spreadsheet detailing the captured loan information • Loan numbers that will be examined are given in advance of the review • D&T LA coordinates with review site to arrange visit • D&T LA schedules and trains staff for the deal

  3. The Current Process – On site Check Sheets are printed and brought to review site Check Sheets are Cross-referenced to loans Missing loans are identified and rep. is notified Review staff is trained, as necessary Loans are checked to Check Sheets Check Sheets are entered into Excel spreadsheet Quality Check is performed on spreadsheet Problems? Return to review staff Corrections made to Spreadsheet Report is created in Word for Client Check Sheets retained for reference

  4. Changes with Database Check Sheets are printed and brought to review site Check Sheets are Cross-referenced to loans Missing loans are identified and rep. is notified Review staff is trained, as necessary Loans are checked to Check Sheets Check Sheets are entered into Excel spreadsheet Quality Check is performed on spreadsheet Problems? Return to review staff Corrections made to Spreadsheet = Step eliminated Report is created in Word for Client Check Sheets retained for reference = Step altered = Step automated

  5. Database Process Loans inventoried and numbers keyed into spreadsheet Missing Loan Report produced Staff training and hub/computer set-up Loan Files checked by document and data captured Data entered into database Quality Check is performed on data as entered Data input masks reduce and catch errors at data entry Problems? Return to review staff Report for Client produced Electronic database file saved for reference = Entry step = Automated step

  6. Primary Benefits of Database Utilization • Reduces eight hours of sample selection to approximately one to four hours • Improves efficiency by reducing on site entry steps from over a dozen to three • Database automatically recognizes errors as data is entered – no back tracking and increased accuracy • Ensures the proper data is captured • Significantly reduces human error and common mistakes in data entry • Allows for cumulative data tracking and analysis over multiple deals

  7. System Description • Network Hub Environment • Microsoft Access-based Database (supported by D&T) • Visual Basic programming of automated functions – bulk of programming completed upfront with minimal continuing programming costs anticipated • Backup data stored separately from program

  8. The Current Process – Time 30 30 15 Check Sheets are printed and brought to originator site Check Sheets are Cross-referenced to loans Missing loans are identified and rep. is notified 60 30 300 Reviewers are trained, as necessary Loans are checked to Check Sheets Check Sheets are entered into Excel spreadsheet 60 5? 30 Quality Check is performed on spreadsheet Problems? Return to review staff Corrections made to Spreadsheet = Approximate minutes per average deal 90 5 Report is created in Word for Client Check Sheets retained for reference = Approximate minutes per average loan

  9. Database Process – Time(optimal operation) 15 5 60 Loans inventoried and numbers keyed into spreadsheet Missing Loan Report produced Orientation and hub/computer set-up 25 0 0 Loan Files checked by document and data captured Data entered into database Quality Check is performed on data as entered 0 0 5 Data input masks reduce and catch errors at data entry Problems? Return to reviewer staff Report for Client produced/General review = Approximate minutes per average deal 0 Electronic database file saved for reference = Approximate minutes per average loan

  10. Process Time Comparison(excluding pre-deal sampling) Current Process – 94.9 hours New Process Optimal – 61.8 hoursConservative – 75.2 hours Time Savings Optimal – 33.1 hoursConservative – 19.7 hours Total fixed = 620 minutes or 10.3 hours (525 on-site + 95 post deal) Total variable per average deal = 5075 minutes or 84.6 hours (average loan file review time of 35 minutes * average deal size of 145 loans) Total fixed = 85 minutes or 1.4 hours (80 on-site + 5 post deal) Total variable per average deal = 3625 minutes or 60.4 hours (average loan file review time of 25 minutes * average deal size of 145 loans) Total fixed = 220 minutes or 3.7 hours (160 on-site + 60 post deal) Total variable per average deal = 4350 minutes or 72.5 hours (average loan file review time of 30 minutes * average deal size of 145 loans) Total fixed savings = 535 minutesor 8.9 hours (445 on-site + 90 post deal) Total variable savings per average deal = 1450 minutes or 24.2 hours Total fixed savings = 455 minutesor 7.6 hours (365 on-site + 90 post deal) Total variable savings per average deal = 725 minutes or 12.1 hours

  11. Estimated Increased Efficiency Minimum Time Needed Maximum Time Needed (optimal) (most conservative) Pre-deal Sampling: Status quo: 8 hours On-site due diligence review: Status quo: 93.3 hours Post-deal quality control and reporting: Status quo: 1.5 hours Total Efficiency Range Status quo: 102.9 hours (Including sampling) 1 hours 4 hours 61.8 hours 75.2 hours 0 hours 1 hour 62.8 hours 80.2 hours

More Related