Some idiot who thinks (s)he's amazing...when they're drunk.
"There goes Mr. Shitfaced Wonder again, trying to impress that model at the end of the bar."