Edinburgh's transport convener has said the council is dedicated to making improvements at the Cowgate amid safety concerns after a man was hit by a bus and killed.