Some 675 jobs are to be created following massive investment in the biopharmaceutical and software sectors in Cork, Dublin, and Galway.