grant database

Database Development

Organization: 
El Centro de la Raza
VISTA Name: 
Mike Moore
Program Start: 
1/2007
Program End: 
3/2008
Project Description: 

Initially, the Vista member focused on database development to increase the technological capacity and efficiency of El Centro de la Raza (ECLR). Starting from scratch, Mr. Moore was able to build a centralized demographics database based primarily on Microsoft Access. In order to accomplish this, he needed to analyze previous systems utilized by staff, troubleshoot, and develop solutions to migrate the infrastructure in a manner that staff could utilize effectively. After completing this task, he completed a manual detailing usage and offered informal trainings to staff. The Vista member was also asked to update other databases (donor, volunteer, and grant tracker databases) in order to improve the tracking and reporting capacity of staff. Mr. Moore was also asked to monitored the server, install standard organizational computer configurations, update other technological systems, assist with events, and other software duties as necessary.

Project Outcome: 

Throughout the service year, Mr. Moore showed a great deal of flexibility by taking on new tasks and meeting agency needs as well as those specifically involving the databases. He also showed his development capability by increasing the effectiveness of our databases, and helping our staff increase their reporting accuracy. Mr. Moore’s efforts led to the following successes:

1. Developed a new centralized demographics database to prevent duplication in reporting to major funders,
2. Increased the efficiency of the donor database,
3. Increased the accuracy of the grant tracker database,
4. Increased the accuracy and usability of the volunteer database,
5. Began to rebuild ECLR’s homepage,
6. Helped fulfill ECLR’s server needs in the absence of a part-time IT Manager, ­
7. Helped to install standard software packages on new ECLR hardware, and
8. Assisted staff with Microsoft Office problems.

Mike Moore came to El Centro de la Raza expecting to primarily customize an existing system, migrate data, tutor users and monitor data input. However, by the end of the first week, our staff realized his experience and capabilities were well suited for so much more. Mike quickly realized that the database El Centro proposed to utilize was difficult to tailor to our needs. Compounding the problem was an IT Staff that was difficult to reach and slow to respond. Mike projected that this customization and full utilization process would take close to the entire year simply to implement, no less train staff and begin to migrate data. This was time that our agency did not have, as major funders pressed us to improve our accuracy and develop unduplicated counts of individuals served. Mike recognized the immediacy of our needs, and proposed to build a database specifically customized to track demographic data in a format we could fully utilize. Working alongside staff members from a number of different departments, Mike noted each person’s need and a series of solutions to maximize the database’s efficiency and usability. On top of accomplishing other tasks associated with his placement (tutoring and modifying other databases), Mr. Moore was able to complete a workable system in just under five months. This left plenty of time to migrate data to the system and meet all of our deadlines.

Fundraising

VISTA Name: 
Nathan Biggs
Program Start: 
6/2005
Program End: 
6/2006
Project Description: 

In short, Nathan is helping us build the sustainability to continue all of UTEC’s mission. He has spent much focus on building systems (i.e. donor recognition systems) so that his work will last longer than his immediate 1-year impact. he produced our first ever annual report!! And, he has excited the entire development departament about the possibilities inherent in individual donor fundraising through his infectious excitement about such fundraising.

Project Outcome: 

Nathan has done an excellent job in his role as a VISTA here at UTEC! He took on a leading role in coordinating UTEC’s most comprehensive and successfull fundraiser to date. He has contributed immensely by helping us organize and develop a new online grants database (which I strongly believe will be a model for other nonprofits on how to best integrate technology into their development work). He has written and won grants. He has created a well organized foundation/donor recognition system that has substantially improved our capacity for relationship building with funders. And he has provided much excitement around the development of a new individual donor organization process. I have been very pleased with Nathan’s work (this being his first time in a development position as this) and would rehire him in a minute.

Impact Quote: 

Nathan took a leading role in coordinating all aspects of our first major fundraiser. With our Dvelopment Director out sick for some time during this period, he was sometimes running this without a ton of support. He took this as a challenge and semed to be invigorated by the challenge… never pessimistic or overwhelmed by stress. In the end, we had nearly 200 guests attend and profited nearly $10,000. Moreover, all those who attended coninue today to talk about how professional and well orchestrated it was. Ultimately, Nathan was able to establish the inception of what will now be the annual fundraiser event for UTEC….each year building upon the success of all his work this past year.

Transmission Project