Sample Database Project Welfare Compliance and Tracking System See additional highlights below screenshot.
Served as Lead Project Manager for the design and implementation of a new $150K database system to track welfare compliance for Hamilton County.
Chaired a cross-disciplinary team of representatives from all areas of the organization to gather requirements, feedback, and ensure a thorough and successful implementation.
Created all aspects of system design including data model, user interface, data entry screens, security, different levels of functionality by login, and automated reports.
Emphasis was placed on ease-of-use. For example, all records for a single consumer are presented on 1 integrated screen (see screen shot above). Several different departments access the database for different purposes.
Provided advanced technical training and mentorship to inhouse IT staff.
Managed all interactions with internal IS department at Hamilton County Department of Job & Family Services.
Coordinated all Oracle implementations, changes, and backup procedures with Oracle DBA at Hamilton County Department of Job & Family Services.
Our client, Community Link, was recognized as a leader in the nation for their business model and supporting technology and awarded an additional $5M contract in 2005.
Initially launched in 2001, the database system is still in use today and contains several million records.
Technologies involved: Microsoft Access, Visual Basic, Oracle.
