Summary:
- Designed a custom web application that enables org-wide ease of property management and status tracking of various projects
- Built a completely cloud ready application running on Azure and integrated with Azure AD SSO
- Integrated with in-house SQL warehouse, Azure Data Factory and PowerBI
- Built custom APIs and modules, semi-attended data upload workflows, that are security enabled for ensuring role-based access control and permissions on need-to-know basis.
The Challenge
- Client was using Spreadsheets for many of their financial models for each deal.
- Client had a huge data warehouse that was being planned and required a sophisticated cloud native application that runs on Microsoft Azure
- The client used ADFS for their application federation that was integrated with their Office 365 as well and need to integrate the same setup for the custom app
- The application was intended to be used by large number of users across the org and needed a scalable architecture
- Agile teams were required to handle continuously evolving client requirements
The Solutions
- Replaced and Imported Excel data to standardize life cycle deal data across Domestic and International portfolio
- Custom SSO with Azure AD integrated with Microsoft ADFS
- Scalable and Cloud Native App Component Setup with Microservice Architecture and third party integrations
- Beautiful User Interface and Experience that runs on any device seamlessly
Testimonials
- “I can manage all the data from the development deals and Investment Committee in one standard solution. So much better than Excel!”
– Development Finance VP - “Finally a system to store all our investment deals in one place, with standardized data and automated weekly and monthly reporting ”
– International Investment Manager
Project by the numbers
- Application planned to be used by over 1000 internal users
- Managed property data worth several billion USD
- 3 Staged DevOps Pipeline Setup for ensuring continuous development and integration
- Application used by users across 3 continents
- Integrations with several third-party including Microsoft Flows, Azure Data Factory, SharePoint and PowerBI
- 25 custom screens
- Mobile App, iPad App
- 40 Power BI reports
Ongoing Benefits
- Portal to access all the property info, pipeline data, investment management and reporting
- Continuous updates, development and maintenance
- On-going support services
- Secure Internal and External Collaboration
- Access on Desktop, Mobile and Tablet devices
- Auditable System with detailed logging
- 100% cloud native and cloud ready
Who Was Helped:
- Executive Leadership Team, Investments Team, Acquisition Groups
- Departmental Heads
- Developers, Asset Managers, Project Managers
- Construction Managers and Logistics
Systems Integrated:
- Microsoft Azure, Azure SQL, first Azure Web Service App, first CI/CD DevOps
- Power BI Reporting Services
- .Net Web App, Web Services, and Xamarin
- Azure Active Directory for SSO,
- Security Groups, Authorization
Application Landing Page
- The landing page with custom navigation is displayed when the user logs into the application via SSO.
- The menu options, pages and features are controlled via RBAC permissions from Azure AD.
Custom Grid, Filters and Navigation
We designed a customizable data grid that users can choose on what columns details they would like to see and filter across the large dataset and custom navigation menu on left hand side
Semi-Attended Workflow
- The semi-attended workflow allows the client to upload large datasets directly inside of the warehouse.
- The workflows were designed to handle validations, data cleansing, and report issues to the user for rectification.
- Fully attended flows with auto data cleaning and error fixing will be coming up soon.
Coming Soon
- Custom Asset Management Module
- Fully Attended File Upload Workflow
