Is Ron Roy author of A to Z Mysteries still alive?

Yes. He lives in Connecticut.

And wrote a book as recently as this year:

August Acrobat (2012).