Notes below from my customer discussions / requirements
Final design pending but will not be 'fancy'.
All is open to your 'best practices' recommendations
Main thing is ease of use for users (less than 100 total, probably only about 60 and a handful of 'admins')
Many functions are native and may not need too much, if any, "coding".
Skills: mysql, drupal, php