Erik Wind Logo Computer & Database Diagram

Crisis Management Analyst (CMA)
Used by: Response of Suffolk County and other information/referral hotlines.

Purpose: Call logging, ad-hoc reporting, trend discovery/analysis.

Response of Suffolk County is a crisis intervention hotline consisting of dedicated telephone counselors offering support to those experiencing difficult and often tragic situations such as grief, substance abuse, economic hardship, and health problems.

Response was in need of a way to collect the information obtained in these calls in order to report results to their funding sources, discover trends in their call data, and protect their data in the event of a physical disaster.

Prior to CMA, counselors checked off various categories (substance abuse, grief, anxiety, etc.) on index cards. This information was later manually entered into a spreadsheet that would produce monthly and annual reports. This painstaking data-entry process was time consuming, and yielded aggregate data of the highest level (geographic breakdown, number of calls, age brackets, etc). It was impossible to keep costs down because new cards had to be printed every time a new category was added. More importantly, in the event of a physical disaster, the organization’s data would have been lost.

CMA automated the card entry process, allowing counselors to complete a computerized card with just a few clicks of a mouse, along with their narrative of the call. Counselors can review their completed cards, save incomplete cards for later, and indicate that post-call follow-up is needed.

CMA’s statistical reporting system is second to none. Response can now find out specific requests such as “the number of males between the ages of 16 and 20, experiencing depression in the Town of Babylon, who called in the past 30 days.” This type of analysis and ad-hoc reporting has prepared Response for any possible data request that may arise. Request information on CMA.

TESTIMONIALS


Response of Suffolk County Inc.

 Jennifer Paul, Information and Referral Coordinator

"After being hired to work as a technical staff member for Response I was introduced to Erik who had been performing various technical projects for them since 2001.   At the time I was hired they were rolling out a fantastic application Erik had developed which allows volunteers and staff to easily log calls, keep track of necessary follow ups, and create statistical reports quickly and easily based on time period and numerous other parameters. 

Erik continues to maintain the database which the application is based on and provides us with timely releases containing requested additional features.  He is also very patient with non-technical staff."