Set your route like this:
map.connect 'user/:user/profile', :controller => "account", :action
Write your profile action like this:
@user = User.find_by_name(params[:user])
The ID isn't used at all. You must make your user name be unique for
this to work correctly.