Reference: Databases

Institute for American Indian Arts

Ana managed a $250,000 project from start to finish. She managed and completed all aspects of the project, and was the main contact between the Institute and the software developers. Without Ana's knowledge of database structure we would not have completed this very large project on time. Ana was the key person that made this a successful project. In the year that Ana worked at the Institute I was completely satisfied with her work. She is a very diligent worker, a conscientious worker, and a very organized person. If it were not for these qualities we would not have had the success that we did.

Anthony J. Coca
Information Systems Director
Institute of American Indian Arts

Read More >>>

Databases

There are many different approaches to cleaning up the data management systems in your organization.

These include the design of customized databases, the customization of existing databases, and the implementation + configuration of purchased or acquired databases that need to be set up.


Platform Integration


Typically, a small non-profit uses separate systems to:

  • manage data about their clients/constituents/members/services
  • generate reports
  • write internal reports and documents
  • massage and generate numbers from data
  • send and manage emails
  • mass email constituents/members

Connecting your database to the other software that you use daily is integral to supporting your staff to do their work effortlessly and effectively.

I can personalize your information systems to integrate them with one another, and train your staff to use these integrated systems to extract information and reports, publish the data using software mail merging functions, and mass email constituents using a variety of different platforms.

Even better, I can train your staff to use all of these systems together easily so that they are not repeating work.

Database Platforms

Database platforms I have worked with and am very proficient in include:

  • Access
  • FileMaker
  • ACT!
  • Oracle
  • BlackBaud Databases
  • Contact Management Systems (CMS)
  • Contact Records Management (CRMs) systems


Reporting Tools

But if you can't summarize the results of your data into reports, that data can become cumbersome and obsolete. For that reason, I have also developed a great deal of experience with the following reporting tools:

  • SQL Queries
  • MySQL Queries using PhpMyAdmin
  • Crystal Reports
  • iReport
  • and designing reports in Access and FileMaker


Training

Regardless of whether you are creating a new data management system, it is necessary to train new and existing staff on how to work smart using the existing database and software that you have available.

Powered by drupal, hosted by mayfirst / people link, and tweaked by jellobrain.

jellobrain, 206 Randolph St. NE #right, Atlanta, GA, 30312 | 404.524.0351

...