The SQL query that made me smile

A few days back, I filed my income tax online. To many, that may seem like something ordinary but to me, being able to do that online was a milestone in itself. Maybe it has something to do with the fact that when I heard that taxes can be filed online, I started off exploring with a pessimistic outlook ... maybe the website would be down ... the system might be slow ... will it be reliable ... will it do what it claims. I had reasons for thinking this way, as over the years I've seen that these processes and the bookkeeping behind the curtains has been largely manual and on paper. And I've had my shares of experiences that have made me form my opinions ... I've stood in queues for hours, I've visited the IT office(*1) and seen how much time & effort it takes to locate a physical file and have always wished that someday (maybe in 10-15 years), things would get computerized. I wasn't expecting it to come so soon though.

The experience of filing my tax online was a surprise so pleasant, that I was actually .... QUITE surprised. I entered my name, date of birth and PAN number and the query pulled up my address on record. I'm a programmer myself and have written quite a few queries myself but let me tell you ... no other query has given me so much happiness. For this query to be able to fetch data meant that the records existed in digital form and could be queried. That, in itself, opens so many avenues and limitless possibilities.

The overall process including registration, downloading and filling up the form and uploading the data took me less than an hour. The overall workflow was very thoughtfully designed, with a few exceptions which I'll come to. I was able to file my tax from halfway around the world and there was only one manual leg in the process (since I didn't have a digital signature).

These were my highs and not-so-highs..

The Highs:

The Not-So-Highs:


Overall, filing tax was a Breeze; IMO, the process isn't perfect yet but it definitely a big step forward. Believe it or not, I actually jumped with joy after completing the process in less than an hour. And the SQL query for PAN, that's brought on an instant Smile!

(*1): The best part about visiting the IT office at Mayur Bhawan in Connaught Place, New Delhi ... getting to have the Special Choley Bhature/Rajmah Chawal/Kadi Chawal at Shankar Market...Mmmmm, I can smell those bhaturas from here
(*2): Maybe that trip really is worth it (Refer *1).

Labels: , , , ,