No, use of the indefinite article with a professional title is generally incorrect in standard English. More particularly, it is incorrect when using it as a title:
Incorrect: He is a CIO Smith.
Incorrect: I am an exterminator Jones.
There is one exception: If the speaker intends humourous effect, this construction can be used. It basically says "Yup, that's me, that's what I am. Hahaha." However, it is non-standard.
It is correct to use the indefinite article when the title is used as an occupation:
Correct: I am a CIO, and my name is Smith.
Correct: He's an exterminator. His name is Jones.
Other than occupational or humourous usage, do not use an article:
Correct: He is President Smith.
Correct: I'm meteorologist Eric Burris.
At its simplest, a title works like this:
Is it being used as a title? Don't use an article.
Is it being used to describe an occupation? Use an article.