What are my odds of transferring from a Community College to an Ivy league school?

You might want to consider the University of Minnesota. It has a strong chemical engineering department, it’s in your state so tuition will be pretty affordable, and you stand a quite good chance of admission.