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