ThedaCare: HRA
This fully dynamic system allows for user defined input parameters that feed a proprietary scoring engine to derive a "health score" for each registered user. An extremely extensive web and PDF report that details nearly every aspect of the particular employees health is provided for each employee in his/her personal portal. The overall goal of the application is to drive down the cost of health insurance for the participating companies by making their employees more aware of their health.
Technologies Used: Ruby on Rails, rSpec, Ubuntu 8.04 LTS, Passenger, SQL Server 2005, Reporting Services, Windows Server 2003, XHTML, CSS, JavaScript, Ajax
My Involvement: Discovery, Data Design, App Code, In App Reports, Site Design, XHTML, CSS, Custom SQL/AR Queries, rSpec/selenium IDE Test Suites
Project Timeline: November 2008 - Current
Project Status: In production with ongoing development
Additional Details
This custom solution relied on the ability to unify several pieces of technology through Microsoft SQL Server 2005. I was able to do this by leveraging the FreeTDS library and the new 2000/20005 SQL Server Adapter for Rails found on github here: http://github.com/rails-sqlserver/2000-2005-adapter/tree/master.