Client
- Property Management App
Services
- Dedicated Hire Team
- UI/UX Design
- Product Development
Industry
- Property Management
The Brief
Our client a property management company, wanted to develop an app to manage its properties throughout its lifecycle from induction until it gets phased out.
The Challenge
The challenges faced while making the property management mobile application and a website for the client.
- User Management: The property management uses ADP as their HR Management tool and Azure Active Directory services to provide access to their users on their network. They needed a solution where if a user is onboarded from ADP first or Azure Active Directory, a profile should get created in the web application and they should be able to use it once done.
- Task Execution: The client wanted the ability to run financial tasks for all active properties on the 1st of every month. Each property would have close to 100 tasks. Initially, there were a few properties and it worked fine. After a few months, the number of properties increased and the operation started to time out.
- Load Time of Reports: The data kept on growing over the years and at a point in time, the performance of several important reports went down resulting in slow load times from 15-20 seconds to more than a minute on some.
The Solution
In response to these challenges, we utilized a combination of robust technologies and a systematic method :
- User Management: We analyzed the ADP and Azure APIs for user management and implemented synchronization to the Users table. Cron jobs were set up to bulk load data from both ADP and Azure tables, and sync routines were developed to ensure two-way synchronization and data integrity within the Users table.
- Task Execution: Due to the large number of records processed during task execution, each call was hitting the database, resulting in extended operation times and timeout errors on the site. To address this, the team optimized database queries to minimize hits, leading to faster execution and resolution of the timeout issue.
- Load Time of Reports: With critical reports experiencing slowdowns, the team investigated and identified inefficiencies in the code and database optimization as root causes. After optimizing the database with indexes and utilizing a combination of Stored Procedures, Functions, and code optimizations.
API Integration
Yardi API Integration to get and process property data. ADP and Azure Active Directory (now Entra) API Integration to facilitate User Management.
Google Maps and GeoCoded API
Google Maps integration to display property locations and GeoCode API integration to calculate distance from a specific location.
Document Management
Sharepoint integration to facilitate Document management for storage and have a common point of access throughout the organization with access privileges.
SSIS Packages
To manage Azure DB connections and manage the workflow between Yardi and the Mayfair Application.
Azure Devops
Create and Maintain CI/CD pipelines to manage Dev, Staging and Production environments.
The Results
An amalgamation of various Microsoft technologies to bring out a complete custom property management platform that has been used by the client for more than 10 years.
What Our Clients Say
Solvios Technology not only created a new website, but a logo and its marketing campaigns, as well. They had well-established management that understood all of the client's needs, big or small. The team also commendably understood the client's industry.
