For me, 'on the weekend' usually implies the future, referring to something that is about to occur: "Come visit me on the weekend. I'll be here."
If talking about something that has passed, I'd say "Last weekend I . . . '
"on weekends" refers to something that happens habitually: "On weekends, I usually sleep in."