I am looking for a derogatory name (not aggressive or distasteful, just a bit derogatory). Let me explain: In my country, there are these kind of average people who think they are great and know everything, and have a really bad attitude towards everything and everyone they consider "inferior", and yet they are considered ridiculous by everyone.
So it's not the same concept as "Average Joe", but an "Average Joe who thinks he's not average". The term that comes closest is Joe Schmoe, but I think there must be a more apt word.
Preferably, it needs to be a name. This is for a character we wrote in Spanish, but the name does not translate at all.