1.
an offensive term for somebody who regularly drinks a lot of alcohol or who regularly gets drunk
2.
an offensive term for somebody who is regarded as completely incompetent or who is thought to exaggerate his or her competence
3.
someone who does something very badly