APPLICATIONS
(distributed to 30+ counties)
Profile Manager; End Users can modify only his/her own profile, Power Users modify anyone in their section, Super Users - anyone in their county, and Administrators, anyone in their agency.
Online Document Manager System - encrypts/decrypts with each request; allows specific user groups to access static documents
Online Ad-hoc Query and Reporting; ability to build ad hoc queries with Excel-like filters or using a SQL language generator. Ad hoc queries can be saved to the user's profile for later reference.
Contacts Manager; quick telephone style lookup of active users in system with telephone numbers and clickable email links.
Menu Manager; Restaurant menu system allowing users to electronically select options while providing content to the restaurant's kitchen. Dynamic order status updates display to waiting customers.
Random Moments Time Study System (MOTT); system categorizes time spent on a specific day into agency-designated categories. Currently in use by the Medicaid Program (R1)
Reimbursement Generator: Combines time records with salaries and population-based funding to generate weighted reimbursements per person, section, and county: Used by Medicaid (R2)
Training Tracker; system tracks the receipt of training by staff. Section supervisors can add to the available training topics for their staff. Agency Administrators can deploy global training topics with requirements. Currently in use by the Healthy Start Program (R2).
Family Manager; Healthy Start baby and family intake system. Allows for the reassignment of cases to other sections/counties. Currently in use by the Healthy Start Program (R3).
Juvenile Intake and Assessment System; tracks change over time of risks where participants are assessed to be at risk. End result displays Excel graphs and filters that address average reduction of risks in specific risk domains, specific population risk areas for age, demographics, and response. Currently in use by theJuvenile Crime Prevention Division (R2)
Relief Nurseries Case Management System; state-wide intake tracking system for at-risk families and monitors visits, schedules, and issues. Currently in use (R1.5).
Comprehensive Plan Manager; Agency-specific community and county commission planning tool. Identifies issues, gaps, and barriers. Targets specific groups of recipients with anticipated results. Commission on Children and Families (R2) Commission was assimilated into Dept. of Education which had their own system.
Statewide Financial Management and Reporting System; allocates state funding streams to Oregon counties. Monitors allocation of dollars to specific programs carrying out the resolution of the issues identified in the Comprehensive Plans System. Measures results of programs and maps successes and losses to targeted population groups. Commission on Children and Families (R2). Commission was assimilated into Dept. of Education which had their own system.
Court Appointed Special Advocate (CASA) Management System; manages the oversight and aid to children who have been removed from their parents. Identifies relationships and schedules, manages cases, court interaction, and volunteers. (R1). Funding stream moved to another agency.
Measure 37: system developed to track Measure 37 Oregon land claims. Required parallel database capacity (R1, R2). Measure mandates were successfully satisfied.
Measure 49 Claim Management System; system tracks past Measure 37 claims and current Measure 49 claims, tracks handling of claims by both management and staff. Requires integrated dual agency use byDepartment of Justice and the Department of Lands Conservation and Development (R1, R2). Measure mandates were successfully satisfied.
Family Building Blocks Data Migration Tool: a custom-built system that takes data from a legacy, flat-file data model and converts it into the relational database structure of the State of Oregon's Relief Nursery System. (R1).
Securities and Authorities Management; module allows Administrators to manage the dispersal of individual tools to a single user, a single tool to a user group, the level of authorization a user has, and activation/deactivations. User levels are View Only, End User, Power User, Super User, Administrator.
System Parameters Management; this module allows the management of system parameters, tool creation, and group organization. Examples might be configuring the color of the application, changing the content of the help manuals, configuring the default record return on a summary screen, or creating a new tool to point to an internal web site or application.
Content Management and File Uploading Utility; graphics, site content, and document dispersal are handled by an internal file uploading tool. The tool, when dispersed to power users, limits access to files outside of their group designation.
Data Audits; system constantly tracks the following items for each data transaction: Last Edit, Last Modified By, Create Date/Time, Edit Date/Time, Entered By, Section, County, Entity.
Clothes Circuit Report Tool: custom-built system using Excel Visual Basic for Applications, SQL, SQL Server, PostgreSQL, ASP and ASP.net to extract data generated from a Point of Sales software and generate automated Excel reports on movement of stock, brand performance, and profit margins. Owner retired and closed company.