These are examples of applications and models that we have designed. While each of these applications is of great value in and of itself, we customize these applications and develop new tools for every situation and client.

• Prescio Data Migration Wizard

  Prescio  Data  Migration  Wizard  is a  self-contained  software  that  allows data transfer across different databases including Excel spreadsheets. This software has been designed to assist analysts who need to transfer data from one type of database or spreadsheet to another type of database. The Prescio Data Migration Wizard has the capability to automatically and routinely transfer data at specified times from one database to another. This software allows a user to work with any database and then upload the data to a different database with ease .

  Most corporations use a standard centralized database as their data repository. A single standard database has two inherent weaknesses. First, every user is forced to use the same standard enterprise database. Second, the centralized system normally slows during peak usage times. Presico Migration Wizard eliminates these two weaknesses.

  Prescio Migration Wizard allows the user to use any local database during peak times,thus reducing unproductive time waiting for downloads during peak hours, and allowing different database systems to be used within an organization. Data stored in various local databases can then be uploaded into the enterprise database during off-peak times.

  

• Prescio Retail Portfolio Valuation Application

  The   Prescio  Retail Portfolio Valuation software was designed as a tool for financial institutions in valuing conventional retail loan portfolios. The software is intended for use by institutions which actively buy and sell conventional retail portfolios. This is one component of Prescio's suite of products that address the whole process of retail lending management from loan origination to portfolio securitization.
  
  The Prescio Retail Portfolio Valuation software is designed for both analysts and management. The software allows analysts to perform thorough due diligence on consumer portfolios. Analysts can perform statistical and graphical analyses on the portfolios, custom design new portfolios from original portfolios using different constraints on the portfolio variables. The analysts can determine the values of the portfolios using different parameters and compare the different portfolio values. The software also allows management to easily determine the value of the portfolio given only the values of the parameters.
  
  Prescio Retail Portfolio Valuation software is designed for ease and efficient valuation of conventional loan portfolios. The salient characteristics of the parameters are listed below.

  

• Prescio Retail Credit Scoring Application

  Prescio  Retail  Credit  Scoring software calculates the credit scores of retail borrowers using chosen sets of variables and three different methods of calculating credit scores. The software can determine credit scores using either Logit, Probit or Neural Network methods, allowing the user to compare credit scores using different methods of credit score computation.

  The software was designed to be customized to an individual client's needs in order for it to provide maximum competitive advantage to the client in the marketplace. It was designed to be used both by non-analytical and sophisticated analytical users.

  Prescio Retail Credit Scoring software allows the user to input retail client background information and then calculate the credit scores using different sets of all or combinations of credit scoring variables. The software can analyze data that is input manually or automatically, and can analyze individual clients or groups of clients.
  
  The software also allows the user to perform graphical and statistical analysis on the raw data sets. Additionally, the software can determine simple risk based prices of loan products given the risk free rate and terms of the loan.

  

• Prescio Interactive Voice Response (IVR) Application

  Prescio  IVR   was   designed  for   the  customer service department of an Indian air conditioner company. Prescio designed a software system using existing technology and off-the-shelf hardware to provide a cost-effective yet thoroughly functional software system.
  
  Prescio IVR is the first point of contact customers have when accessing customer service. Customers can phone in new service requests and can track the response of service requests already reported.
  
  Prescio IVR is also a tool for management of client's resources. Prescio IVR can automatically assign technicians to service calls. It also collects details from field technicians and provides management with several types of valuable reports including, engineering reports, service area reports, specific fault occurrence reports, and breakdown reports for specific machines. All of these reports can be generated automatically at schedules set by the user, and all of the reports can automatically be to management by e-mail. The IVR has many additional features and can be adapted to many types of businesses according to each client's needs.

  

• Prescio Data Import Application

  Prescio Data Import software extends the capabilities of Prescio's Migration Model by allowing data stored in different formats to be used in the Migration Model. Data from different types of loans, such as commercial or consumer loans that have been stored in dbf files, are converted to MS Access format. This data can then be fully analyzed through Prescio's powerful Migration Model software.
  
  The Prescio Data Import software allows a user to fully modify loan record data before such data is analyzed. Erroneous records and duplicate records can be filtered or changed automatically or manually so that complicated and varied loan data is made ready for the Prescio Migration Model advanced analysis. After analyzing and manipulating data, the user can export final data to any other database or to an excel sheet for use in other software or for archiving.

  
  View Screenshot

  

• Prescio Asset Quality Forecasting Model Application

  The Asset Quality Forecasting  Model Application is designed to work over a local area network, where multiple users in a particular hierarchy are involved. As such, it is equipped with advanced administrative capabilities which enhance its usefulness for the entire bank organization. The software allows levels of access to critical data and reports, and has special utilities which set parameters for inputs used to generate analytical reports.

  The genesis of this software was a request from a major United States West Coast bank. The bank sought to improve its customer loan tracking operations. Prescio software, through the use of sophisticated algorithms and pattern analysis, forecasted with great accuracy the probability of a shift in risk level for various loan categories.
  
  At a basic level, the software helps a bank keep track of probable defaulters. At a more advanced level of use, this software can be used as an analytic tool to gauge the overall quality of its assets .

   

  View Screenshot

  

• Prescio Field Encryption Application

  Another  extension  of  data  migration application, Prescio felt the need of sensitive data to be encrypted while being migrated. There is always a risk of data theft either by the miscreants or by the competing parties. Moreover in certain cases, the sensitive nature of the data compels the authority not to reveal it to the outsiders.
  
  The security of the data is the main purpose behind the development of Prescio Field Encryption Application. In order to hide the actual data from the end user the Data Encryption method has been used. The encryption technique used is intelligent enough to hide the actual data from the end user but at the same time this model gives the flexibility to the user to view both the actual data and the encrypted data. The software supports encryption of both Database data and Excel file data. This easy to use application uses infragistic tools to encrypt and decrypt data.

  View Screenshot

  

• Prescio Loan Loss Mitigation Model

  Prescio partnered with a large U.S. based consulting firm to develop a mortgage modification and loss mitigation model. The joint venture was follow on work from an earlier model development project for an international bank's southeast U.S. mortgage business. The join venture adapted the model into a web based software application and enhanced the data analysis, segmentation, and portfolio capabilities of the original modeling venture.
  
  The purpose of the model is to assess stressed mortgages and determine the maximum payment the borrower can and will pay while determining the best modification approach from the standpoint of the lien holder. The model does so through predicting probability of default, assessing future home valuation and disposition costs, and computing a future value of cash flows. Loan level sensitivity analysis, extensive data analysis, and portfolio net present value analysis are made available. Extensive reporting and graphical presentation capabilities are built into the application. The application is currently in a marketing and future development stage.

  

• Prescio Loan Loss Forecasting Model

  Prescio was approached by a western U.S. bank to help model their residential mortgage, consumer loan, small business, and cash reserve portfolio loss forecasts. Prescio developed a desktop application that has extensive data analysis, portfolio segmentation, and reporting capabilities. The model utilizes a Markov chain approach to the portfolio loss forecasting that incorporates both assumed (forecasted) new business for each portfolio on a monthly basis as well as expert judgment adjustments to account for macro and microeconomic variables.
  
  The application is currently deployed at the bank and is under further development and enhancement. In future versions of the model, regression analysis, time series forecasting, and a Bayesian updating technique for the Markov chain are anticipated to be incorporated. Prescio also anticipates a vintage analysis approach to loss forecasting to be incorporated in future versions of the application.