"Do you really wish to know?"
Spoilers from the books and/or adaptations to follow!
Pierre was a tailor at the Tailor's Workshop in Beauclair in 1275. He typically sells clothes.
If Geralt keeps Syanna safe: Pierre sewed the Beauclair doublet for Geralt for the later ceremony.