Content Management System

Project Role: 
Site Builder and Administrator
Project Dates: 
January, 2010 - August, 2010
Project Description: 
This project involved creating a secure, internal-use only, online media content tracking and communication system with a client portal for reviewing content. Internal users can log in to update the status of media assets they are working on, leaving comments that get attached to the assets. Supervisors can log in and review media assets, change status to either “approved” or “to-be-revised” and leave comments. Production personnel can log in to view reports that summarize the status of entire the production and compare it to the production schedule to ensure work is on track or falling behind. Lastly, company clients can log in to a simplified and separate area of the system to view posted examples of media assets to review and comment on. This system replaced an existing flat file database system of entirely of Microsoft Excel spreadsheet documents.
Tasks Performed: 
  • Meeting with Big Jump Productions owners and staff to discuss individual needs of various production departments
  • Producing Flowcharts detailing production flow and approval process
  • Responsible for choosing much of the technology used
  • Performed all site testing on a local installation before migrating to production server
  • Demonstrating at various stages of development how the system functions
  • Testing the content management system's functionality in Firefox, Safari and Explorer browsers
  • Editing graphics using Photoshop
  • Editing CSS
  • Setting up, migrating and backing up MySQL databases
  • Generated weekly reports detailing progress, issues and research & testing of contributed Drupal modules
  • Reviewing hyperlinks to ensure their validity
  • Troubleshooting and solving content management system errors
  • Testing and managing compatibility of contributed Drupal modules
  • Installing and setting up jQuery libraries for enhanced functionality
  • Ensuring that the website continues to meet the goals of Big Jump's production environment which include some of the following attributes:
  • making sure the interface is end-user friendly
  • ensuring there is a common look and feel across all pages
  • configuring and maintaining a robust array of role-based content access permissions
  • configuring the layout of various content displays used in site generated reports
Environment: 
Drupal 6.19 (Content Management System), HTML, XML, Cascading Style Sheets (CSS), Flash CS4, Adobe Photoshop CS4, PDF, Safari, Firefox, Explorer, Windows Server 2003, Apache Web Server 2.2.14, MySQL 5, PHP 5.3.1, OmniGraffle Pro (Flowcharts).