Property Database Management System – ASP.NET MVC App

12 Jul 2020

The Client

The client is one of the leading development and construction services providers, a global leader in rental housing operating across multiple geographies in Latin America, Asia-Pacific, Europe, and the United States. The client with its expertise in the real estate sector offers business services like Investment Management, Property Management, Apartment Search, and rental housing services.

The Need

The client wanted to build an enterprise-grade Property Database Management system that would be integrated with their Office 365, Azure AD for SSO (Single Sign-On). They wanted the solution to be securely locked in as the data contained was highly sensitive and needed access to certain security groups.

Additionally, the client had unique filtering and custom grid development requirements with analytics on the dashboard highlighting several parameters for monitoring and measurement via Microsoft Power BI. The solution had to be scalable and required to allow access to thousands of requests.

The client approached the Microsoft-certified consultants to help them build a state-of-the-art property management system that would help them manage their existing projects and real estate.

The Challenge

The client leveraged several third-party project management tools and systems like Yardi and Procore for project and cost codes management. The client had built custom Power BI dashboards for powerful analytics and data insights.

Given the presence of this software, the client wanted the new solution – the property database management system, to be a total cloud-based, highly scalable solution with enterprise-grade security and performance support.

The client wanted this state-of-the-art property management system to be integrated with the existing tools and systems. They also requested for several unique data filters and search features on the fly.

The Solution

When the client approached Star Knowledge with the custom business solution requirement, the team of bespoke software consultants conducted a detailed analysis of the client’s business needs and performed a thorough assessment of the existing software solutions and third-party tools that needed 360-degree integration with the new solution.

Our team of Microsoft-certified consultants proposed to build an OAuth-enabled ASP.NET MVC application that integrates with the client’s Azure AD for SSO (Single Sign-On) and authorized application access. Our ASP.NET developers proposed to build the entire application on Microsoft Azure PaaS (Platform-as-a-service) with a microservice architecture layer for the web services and the web application that can be scaled independently.

Additionally, we proposed to build the desired database management system on Azure SQL considering the design of the solution, keeping in mind the future needs to integrate NoSQL DB such as Cosmos DB. The solution also involved our DevOps engineers to design automated test cases and deploy Azure DevOps Services for automated release and pipeline management.

The Benefits Obtained

• A scalable property database management system with unique design and architecture
• Highly secure and SSO-enabled
• Configured to work with Azure AD security groups
• Custom Integration to sync multiple systems and automate the update
• DevOps Configuration and automated release management

Technology Stack

• Microsoft ASP.Net MVC
• Microsoft Power BI
• Azure PaaS
• Azure DevOps
• Azure SQL
• OAuth 2.0
• SSO
• Web API
• Entity Framework
• Bing Maps
• HTML
• Keen Bootstrap
• CSS
• C#

Looking to develop a custom business solution? Get in touch with us to discuss your project.

Star Knowledge is a bespoke software development and IT consulting service provider with 10+ years of experience in developing custom software product and business solutions to clients from the AEC industry worldwide. Our certified engineers and consultants with 250+ years of combined experience have built complex software solutions around cloud, web and mobile technologies. Contact us to partner with Star Knowledge.