Sexie

A blowhard. Someone who thinks very highly of themself, their abilities, and their appearance.

My colleague John at work is a real sexie. He thinks very highly of his abilities, while no one really takes him seriously.