|
Home >
Services >
Fixed Income Services >
Research & Analytics >
Data Management Services |
|
|
Data Management Services |
|
|
In the ever growing
securitization industry, the quantum of data flowing across
industry players is enormous and so is the need to analyze
that data. Data flows in multiple physical formats such as
simple text, Excel spreadsheets, Acrobat PDF, Microsoft Word
document etc. Data processing and Management is crucial for
analyzed output which enables strategic decisions.
Our Data management service offering includes:
 |
Initial Data Tape Processing |
|
|
-
Stratification Reports, Risk Related Reports, Data Exports
-
Data
Review, Validation and Standardization
-
Identification of High Risk Loans
|
|
|
Data formatting of Trustee
reports to clients’ specified excel formats for ease of
usage. |
|
|
Data formatting of monthly
performance statistics for newly issued and outstanding
securities. |
A few example services we offer under Data Management and
Analysis suite are mentioned below:
|
|
A. |
Data formatting for Trustee reports
to clients’ specified excel formats for ease of usage |
|
|
|
|
|
|
| |
Manually converting some of the Client required
fields from PDF to MS-Excel, few fields may include, |
|
|
|
|
|
|
|
|
|
Fund Name |
|
Currency |
|
Maturity Date |
|
|
ISIN |
|
As
of Date |
|
Moody’s Rating |
|
|
CUSIP |
|
Principal Balance |
|
S&P Rating |
|
|
Fixed/Floating |
|
Default Date |
|
Fitch Rating |
|
|
All in Rate |
|
Security Type |
|
Moody’s Industry |
|
|
Payment Frequency |
|
Security Name |
|
S&P Industry |
|
|
Accrual Method |
|
Issuer Name |
|
Fitch Industry |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
B. |
Data Formatting
for Monthly statistics of deal during its lifetime |
|
|
|
|
|
|
|
This involves analysis of
Trustee data during the lifetime of deal. We receive
the required Trustee reports in the form of PDF from
which the data is extracted from different sheets
like Par Value tests, Interest Coverage Tests,
Principal Balance etc. The analyzed data is provided
back to our clients in mutually agreed-on formats. It also
involves running various test scenarios over the
analyzed data such as OC Tests and IC tests. |
|
|
|
|
|
|
|
|
|
|
C. |
Mapping New Deal
issuance from web research |
|
|
|
|
|
|
|
This involves researching and
reporting the new deals issuance through a general
Web Search. With our access to various deal
information websites, our data management team puts
together a periodical report on new deals every
week. |
|
|
|
|
|
|
|
|
|
|
D. |
Issuers mapping |
|
|
|
|
|
|
|
Our t eam extracts the data from
the given Excel spreadsheet to a client specified
template, which has the Master Issuer Record and
Subordinate Issuer Records. In the Master Issuer
Record the Issuer data that we enter will be the
first in the Grouping Hierarchy. The others will be
entered in the Subordinate Issuer Records with
respect to their hierarchy. |
|
|
|
|
|
|
|
|
|
