The most excitable mini schnauzer you have ever seen

by Donna
(Brisbane Australia)

We have the most gorgeous well natured mini schnauzer in the whole world (we are not biased!!! ha ha). He is almost 11 months old, de-sexed. Extremely well socialised. The issue is walking him.
When ever he sees another dog or a person he goes absolutely nuts with excitement. He just wants to get to them and say hello. It is beyond out of control. It even happens when he sees a dog across the road. I walk late in the evenings to try to avoid as many people and dogs as we can. Some owners now cross the street to avoid us. I have had a professional trainer spend 5 hours with us. I have tried all sorts of training options, collars, leads, harnesses and even a collar that makes ultrasonic waves when he barks. I am at my wits end. What should I do. He wont walk at all in a Halti head harness.
The only other ideas I have is to hire a professional trainer to walk him everyday until both he and I have it worked out or to use a collar that zaps him when he pulls or barks and I don't actually think I could even bring myself to do that. Will he just grow out of the habit?
Please has anyone had the same experience and what worked for you?
I will load a short video clip of his behaviour soon. Just need my husband to come along when we walk in the daylight to record it as I need both hands on the lead.