I have 7 years experiences in working with Automation and testing as well. I used to write lot of automated scripts with data-driven (using excel/csv, xml, text, data server) in my projects.
we can use automation tools such as QTP, Visual Studio, Ranorex... but I love to use Ruby due to free of license for doing automation.
my skype: dany4446.