Database Design

Auto Adjusticating Claims Processing System. Developed a self-insured claims processing system used by Hospitals, Steel Mills, School Systems for processing employee related claims. Handled Health, Workers Comp, Dental, Prescription Drug claims processing. NY Dept of Corrections hired a consortium of specialized consultants to prepare recommendations for inmate related health care expenses. Tasked and responsible for the compilation and reviewing of the inmate cost of case on a case by case basis. Compiled hundreds of thousands of inpatient and outpatient records as they related to which hospital was treatment performed, cost of care, diagnosis and prognosis related detail. The information from this study demonstrated the "Who, Where, What, Why & How Much" of the extensive cost of providing inmate care.