Loan performance and CMBS Data Management

Context:

    • Database management , analysis, support, and maintenance

Approach:

    • Finalizing the Data structure and table structure
    • Performing various DBMS operations using SQL, Oracle, MS access and 1010Data
    • Modification for existing tables, update tables, replace, tables, merge with existing tables, select queries and cursors
    • Data warehouse support and maintenance
    • 1010Data Management (Create and upload new tables, Update existing tables, Create various need based queries,Create 1010data based models to perform complex Loan performance analysis and financial modelling)

Result:

    • Efficient Database management for client
    • Input to various financial models from loan performance data bases