We're looking for a skilled IT volunteer professional (or a couple co-workers/friends in IT who would want to work as a team) to help us develop an intranet that will save significant funds in administrative labor costs, help us increase our capacity to see more kids in hospitals and ensure our impact data (big picture impact, not personal or private information) on kids and their family members reached continues to have integrity.

The solution would be a simple to use intranet (password protected) that has a calendar function with reminders on scheduling, a means to enter data after a hospital visit, a means to tag someone's status if they haven't entered data, and a reporting tool that easily provides summary data or specifics to look at impact and several other components noted below.

We're a small organization of one employee with a tremendous impact with lots of dedicated volunteers. Currently, we're using various free tools including airset.com, a custom data entry tool, emails lists and excel spreadsheets which is taking exponentially more time as we continue to grow. To ensure data integrity, the data on each of these "tools" needs to be compared and this takes significant time each week.

Your help with this project will be tremendous and truly utilize technology to aid in efficiencies that would help us make sure funds raised go for program growth rather than administrative overhead. Particularly, this project would help the Executive Director spend more time growing the program to reach more kids.

• We are looking for someone to take this entire program and work it start to finish in a reliable manner. We're looking for someone with specific experience doing this type of work with excellent follow through. We need someone who can create and implement this, and support it (it shouldn't really need any support once bugs are worked out.) COMPONENTS OF THIS PROJECT 1. *Scheduling & email reminders Last year, our volunteer Hospital Magicians (HM) saw over 2,200 kids at their bedside through regularly scheduled visits to five different hospitals in the area. A reminder is sent to each HM a day or two before their visit. It's important to know who is where since we're working in hospitals. 2. *Tracking impact and # of tricks handed out (5-10 different varieties) for inventory tracking Hospital Magicians also teach young patients and their siblings magic and hand away specific magic instruction booklets (English and Spanish) and the supplies to perform. After each visit, a HM will enter data through a website on number of patients, siblings, and parents/adults guests visited. So when we say we saw over 2,200 patients, this data continues to have integrity. The HM also notes how many tricks were given away, and some other data points. He/she also notes starting and end times to track service time for the organization, a data point important to some donors and granting institutions. We use many of these impact numbers to track internal benchmarks of effectiveness. 3. *Follow up on data not entered Occasionally, certain computer labs at the hospital may be closed, a HM stays longer than anticipated and data is not entered. Flags to remind the HM to enter the data, a change in their status and a reminder for the administrator are all key in ensuring the data will be complete. 4. *Other scheduling - on-going instruction at OHM Magic University for the Hospital Magicians to work in new medical situations 5. *Ordering component for tricks and booklets and then an inventory tracking means to compare what a magician ordered to what they gave away, the data point captured in the report they input after visiting patients. 6. *Status tracking of Hospital Magicians HM's have certain responsibilities, but this is difficult to track via emails. Would be nice to be able to give a Hospital Magician a certain status on the intranet as well as show events attended, missed, etc. 7. *Means to track items lent out - magic library. 8. *Administrative reporting tool 9. *Administrative summary & Hospital Magician calendar and individual summary pages 10. *Internal note board. (Easy to use) 11. "Ability to make this scalable - adding new Hospital Magicians, new hospitals, etc. etc. You will work directly with the Director who is excellent as giving specifics but not able to lead this IT project due to his lack of IT experience. He's a "user" and apologizes for such. He is comfortable with technology and will help as best he can. He'll be very quick to respond to questions, will detail and document all before the project, and will be extremely thankful for your help. We will start to look at responses mid-March, after our Benefit. Please respond and give your thoughts on this project and your specific background as it relates to this specific work. This project is going to require an investment of time resources on our side and we want to make sure we have the right person or team. Thanks in advance for your responses. Truly, thanks in advance for your help. The team or professional selected will be listed on our new website being developed through the Grip Design Strategic Marketing and Design Program to show our appreciation. The professional providing on-going support will also be noted to show our appreciation. We would also be interested in anyone's thoughts if they're familiar with an IT foundation that provides assistance with such a project.