SUCCESS STORY

Data Management & Reporting Tool (Technology Consulting, Data & Analytics, Automation, Application Services)

The Problem

The client was looking for a solution that could read and analyze different sets (Images, video, geospatial etc.) of real estate data and to generate customized reports.

Process

BTM came up with a detailed technology stack required to build a robust big data platform (HADOOP).
We built the complete data layer by ingesting multiple data into mapR-FS cluster and writing JAVA based map-reduced queries to build a database.
Deploying Apache Drill, which in turn were exposed to Tableau. By incorporating Tableau into the solution, BTM generated multiple reports.

BTM Financial Solution

Read and structured different types of client’s data.
Generated customized reports using TABLEAU.
Produced Sales Comparable, Foreclosure, Transaction History, Property Retail, Property Statistics and Neighbor Report.

Related Case Studies

Pipeline management system (cloud, application services, business process outsourcing, data & analytics, technology consulting, automation)

To develop a Pipeline Management System that contributes end-to-end development as well as integration of customized/Private APIs. APIâ€™s access /authentication is being provided in a very high secured environment.

Audit & validation reporting of CLO model (structured finance, data & analytics)

Finding the Inconsistency in the collateral and bonds cash flows in the model which was being compared with third party cash flows. Audit of application of the cash flows due to various default and prepayment, partial prepayment scenarios. Auditing of priority of payments and providing our findings. Finding of miscalculation of various fees involved in the structuring and servicing process.

Term Sheet Model(Structured Finance, Application Services, Data & Analytics, Technology Consulting, Automation)

Build a comprehensive model to process complex inputs and generate the Term Sheet report. To Implement comprehensive error reporting to identify and track the source of all errors identified using the business rules.

Regression Testing Suite Application (Quant Analytics, Application Services, Data & Analytics, Technology Consulting, Automation)

The C++ Testing Suite had approximately 3500 test cases and Excel is not designed to handle the sheer size and its internal tools are limited. The objective is to build regression test models in python. To ensure that debugging is systematic and transparent for people who have not being involved in building the test. Ensuring that the process is consistent to be able to avoid “dependency”. To make the code structured and written with a common discipline

Data Mart Platform (Artificial Intelligence, Application Services, Data & Analytics, Technology Consulting, Automation)

The Data Mart Platform is built to aggregate Loan, mortgage & other data from various sources and store it in a structured format in a central repository. This data is made accessible to other tools & third-party applications in a secure & efficient manner via REST based APIs.

Blockchain & AI Enabled lending Platform (Artificial Intelligence, Blockchain, Application Services, Data & Analytics, Technology Consulting, Automation)

The underlying objective of creating this application is to create a trust-less platform to facilitate the complete Lending process while ensuring complete transparency & fairness in dissemination of information to all stakeholders.

End to end mortgage analytics (Application Services, Data & Analytics, Technology Consulting, Structured Finance, Fixed Income & Equity Analytics, Automation)

Existing structuring solutions are third party tools that are license based on user and asset type making the cost structure very expensive. Most of the existing products are based on "One size fits all" approach & offers limited customization option to users. The current Structuring platforms are “legacy systems” using archaic core technologies.. The available tools were designed for the initial world of agency deals and then adapted for other asset types and not designed “ground up”.

CMBS CREDIT MODEL (Application Services, Data & Analytics, Technology Consulting, Structured Finance, Fixed Income & Equity Analytics, Automation)

To design a database driven system to identify pieces of loans which exists in complex form e.g. A/B or Pari Passu structure. Also incorporate global assumptions which are NOI curve, Cap rate, Debt Yield threshold, largest tenant, LTV assumptions, Occupancy etc. for estimating Loss Severity, Timing and Amount of default, Balloon Loss Severity for each loan etc.

Human Assisted Automation Suite (Artificial Intelligence, Data & Analytics, Automation, Business Process Outsourcing

The Client’s has tons of data manually updated by its analysts. The client wanted to establish fast, human assisted automation suite for minimizing errors and time utilization.

Data Warehouse and Dashboard/Tear Sheet (Automation, Application Services, Data & Analytics)

To create a distributed data warehouse and a dashboard/Tear Sheet in order to analyze various type real estate data. The client was looking for an integrated solution that could track the whole set of data in a single dashboard view with various filtered criteria.

Property and Loan Level Data Processing & Analytics (Automation, Application Services, Valuation and Advisory Services, Data & Analytics)

The underlying objective of creating this application is to process the unstructured data into structured format and performed the analytics on the cleansed data.