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

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

-
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

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

|