We're developing a very fun, custom app using Twilio ([login to view URL]). Involves creating a system that automatically responds to users' SMSs, stores information in a database, and makes basic decisions about what to respond to the user.
You MUST know Twilio, php and SQL.
Very exciting project!