Case Study | Development of Web Application with SharePoint Integration
Development a Self Service Portal hosted on Azure with SharePoint Automated Document Uploads for an NPO
Published: 1 November 2021
Business Challenge
The Allan Gray Orbis Foundation is a Non-Profit Organisation (NPO) that invests in the education and development of individuals with entrepreneurial potential within Southern Africa. The Orbis Foundation identifies potential entrepreneurs from previously disadvantaged communities and engages them in a full-service educational programme developed to cultivate their entrepreneurial mindset and skillset.
The Orbis Foundation was committed to leading by example. They required a highly functioning candidate-management ecosystem knowing that the technology their candidates use will set the expectations and experience-base for each cohort of candidates; hence they were dedicated to providing superior user experience.
The solution needed to alleviate the administrative processes required for:
- Scholar, fellowship, and mentorship applications
- Candidate selection
- Onboarding new candidates into the program monitoring and assessment of their educational and emotional growth.
In addition to automating the processes that were already an integral component of the candidate management, Orbis Foundation’s data analysts were keen to implement data-driven interventions. They required more accessible data to be able to perform advanced analytics, to answer questions such as: Which variables reliably provide early-warning signals of issues that may affect candidate success? What strategies improve outcomes in a personalised learning journey?
The Solution
Tangent Solutions delivered a Self Service Portal and ecosystem that empowers the Orbis Foundation to manage candidates through the full lifecycle of their entrepreneurial journey.
The application utilises a microservices-based architecture implemented with Python and Django. Azure’s App Service is used to host the application on Azure.
Images and documents are managed with Azure Blob Storage. Sensitive documents, such as Academic Transcripts, are automatically uploaded and submitted to the Foundation’s SharePoint on Office 365 for internal processing.
The Process
Tangent Solutions worked closely with Orbis Foundation’s product owners during development, staging, and production. This deep integration between the product owners and the Tangent Solutions development team allowed fast feedback on issues and intense stakeholder input, enabling bi-monthly feature releases.
A Scrum methodology with 2-week cycles was used along with Task Management, Source Control and Continuous Integration and Continuous Deployment (CICD) using Azure DevOps.
Django best practices were applied to asynchronous and live development. As the portal utilises frontend JavaScript for page-by-page dynamic features, it was designed with responsiveness in mind.
Tangent Solutions worked with the Orbis Foundation to establish how to integrate with their preexisting toolset. The first step was to bring the entire Orbis Foundation into Dynamics CRM 365; from staff to applicants. This allowed all personal data to be managed by Microsoft’s Azure Active Directory.
Business Outcomes
The Orbis Foundation now provides a streamlined application and approval process for candidates through its dedicated ecosystem. All candidates are enabled to self- report on academic performance and wellness through an application that is responsive to monitor size.
Data is collected passively as candidates pass through the program, and actively during contact session feedback. All data is collated providing the Orbis Foundation with a single comprehensive view of each candidate.
The foundation is now positioned to apply machine learning algorithms, test the efficacy of alternative learning path strategies, and report on candidate progress.
This NPO can provide real-time KPI metrics to their funders and other stakeholders. Also, the wealth of data they collate in Power BI dashboards on the economic realities of the people they support is now highly accessible to external stakeholders such as the South African government.
Want to learn more
about Tangent?
Take a look at all our Case Studies, Articles, On The Record, and In The News