I presently possess a SQL Server (Express 2005) database to carry some transaction/metadata which i would now like to migrate to Oracle 10g express instance.

Are you able to do that programmatically or it is possible to decent software program that anybody can suggest?

Oracle Migration Work bench is included in SQL Developer. Check it to find out if it meets your requirements.