The architect of the year’s biggest and arguably most surprising health-care deal is a former pharmacist from rural Pennsylvania who won over Wall Street with a reboot of CVS Health Corp.

Larry Merlo, CVS’s chief executive since 2011, impressed skeptics with his turnaround of Caremark, the pharmacy-benefits manager that CVS bought four years before he took over.

Now...