Finally migrated my site to a very capable CMS system.
Drupal is a very capable content management system that allows creation of short friendly URL aliases. Organization/type/hierarchy agnostic content creation.
Along with creating short friendly URLs using Drupal. I also used the mod_rewrite from apache to maintain compatibility with existing links. So if anyone still clicks on the older pages from search engine links or any friends who linked to me will still be able to fetch the updated content from the same URLs.

Drupal has a very capable content organization system called taxonomy.
I am still exploring the goodies it has to offer me in terms of enhanced blogging experience.

I like Drupal over other personal Content Management Systems I tried during last few days including Mambo and PHPNuke. I haven't tried many others although I am going to put in more effort into Mambo which looks promising.