It would be hard to say that has never happened, because not all sociopaths rise to the level of a mass murderer – or even a common, garden-variety one-off murderer, for that matter. So we don’t know at all who all of the sociopaths in society have been, or are.
Many sociopaths – we’re told – run businesses, successful businesses, from all economic and other indications and metrics of success. The reason that the business is successful generally results from satisfying large numbers of customers. While it might be wrong to say that the sociopath who runs the company – if it is true that the manager is a sociopath – caused that success is difficult for an outsider to say. That person may have impeded the much greater potential success of the company.
In any case, since we normally assign the success (or failure) of a business to its owner / manager, then it would be fair to say that a sociopath running a successful business “is responsible for that success”.
You didn’t ask whether everyone liked him (or her), you just asked about “positive contribution”, and by most metrics increasing the wealth of society in general is a positive contribution.