Improving Efficiencies through a EduFinance IT & Database Audit
Challenge
To provide a recommended structure for the EduFinance database and cloud server that is both cost efficient and scalable.
The EduFinance department operates a Microsoft Azure cloud computing service, which hosts virtual machines, SQL databases, LogicApps pipelines and DataFactory services. EduFinance also connects to 3rd party APIs through FiveTran and while all are functionaing, there may be potential to optimize and ensure that the process is more efficient and scalable.
Expected outcome
A summary presentation outlining a proposed future structure and recommendations for changes.
Implementation of any quick fixes found.
Resources provided
Operations Manual
IT & Database Linkage Walk Through with Ops Director and Data Analyst
Demonstration of how EduFinance uses data from the database
Program structure
Database Audit
Audit of all database linkages after overview with Data Team
Recommendations
Presentation of findings and recommendations
Implementation
Implementation of any quick fixes if time remaining
Skills
Languages
Nonprofit mission
By providing financial solutions and training, we empower people living in poverty to transform their lives, their children’s futures and their communities.
Posted by
