Mama I’m coming home (Thanks Adi)

Well.. The first things I had to check was if my leaves on 3rd to 6th Nov was approved. I was not even knowing how would I know that, so I went on intranet to see if it is approved. Well, realized that even if it is approved it would be costly to go. No check air fair :( So I deleted leave requests and I put new requests for next weekend. Time during Shubhangi’s wedding (24th Jan), Jaidev’s Wedding (4th Feb), Didi’s birthday (4th Feb again), my own (9th Feb). So many thing in line. I have planned the travel too. One more thing. I’d also applied for leave for whole week starting from 3rd Sept 2007. (Govinda aala re!!!!!) Coming back to leave. I requested him that I have applied for next weekend’s leave and I have canceled coming weekend’s leave plan. Well, after 5 minutes I got mail sayingg leave status changed. So now I know that I get a mail when my leave is sanctioned.Now people in team got to know that I applied for leave to be taken almost after a year. They were amused and laughing….. “You have planned for one year….” I believe you can apply for “week with family” leaves twice a year easily. Probably these guys don’t know how I used to apply leaves when in Cybage. One day leave 2 day leave with 3 to 6 months notice… BTW. I don’t have a credit card :(( Never liked the idea of “credit” and all these sites takes only credit card. Couldn’t book the tickets. I gotta catch someone to book it.

Lastly, I gotta find a Hardware Engineer. PC got some problem with fan. It stops after 2 minutes so CPU temperature goes high and as soon as it reaches 75 PC reboots. Sounds funny, but I verified it. Vooo…… This is my roomies laptop. Good that he is on phone with some gal…. Ab bhagwan ne chaha to kal blog hoga.. I have seen some ads. Hope to get this problem fixed…

Headline (rumour) of the day
1. 60% employees of BPO have been laid off. Told straight to find a job in 30 days with 90 days salary as lumpsum payment.
2. Finanacial companies have stopped giving leans, credits to employees of IVYComptech.
3. 888 holdings (Company who owns 888.com) to merge with PartyGamin PLC (Parent company of IVYComptech) —–> This one affects me directly.. More chnages to the reports due to merger. More reports. Abe 888 ka ID 888 rakhna.
4. 32 nations of EU to back a law that would make gambling business more answerable to govts.
Quite good. They should be controlled to some slight extent. Player in USA, Server in Gibraltar, one of Top 100 company listed in London stock exchnage and 95% staff in India. Who the hell is contrlling the money transactions.

It is raining Orkut

It was around 4 in morning and I got up due to some noise. I saw my roomie Sunil closing his shelf. Later he told me he had got up to shut the windows. Read forward. Well I just slept back. Now at 8 O’clock I realize that is chilling cold even though door and windows were shut. I just looked outside, sky was covered by Grey clouds. It was a very nice scene specially seeing the whole city from you window. I live at not one of the costliest but the costliest place in Hyderabad. I like the place with slight extra premium price to stay. It was raining whole day. Could not even go out to get the bike washed. In evening went out and had 5 somasas and 2 Cup of tea at New Jubilee Hotel, the friendly neighborhood tea shop :-). Chao!!!!

I met my many friends or school. Probably for the first time after a break of 11 years. Cool.. Orkut rocks….

I hate innocent people

Hey kinda surprising, isn’t it? But this is about the all people who send me invite for sites. Let it be big or small. Generally I have subscription to all type of site that interests me. Still I get mailers from my few friends to register for some sites. I really get irrigated by this. Only Reason, most of them are new so could be in email harvesting. I hate spams. I hate my innocent friend who sent me a flowered to win Nokia phone keeping some spammers/email id harvester in CC. I have not able to counter spam in last 3 years. I had very jolly 4 years of usage. I didn’t get even single Spam. I use service of GMX.net as my primary email. I send my personal mails from this id only, if at all. Now I get around 30 spams a day :((. So just ad advice, if you like a service take some effort to send a personal mail, drop an offline or scrap. Don’t use ready-made mailer of websites. Do you know that these sites would keep 1 PX image in image to find the authenticity of the address and sell it? Just to tell you Spam is the biggest cost to ISP. Let us see the offline model first. If someone wants to send you unwanted postcards like “40 din mein takdeer badal gayi.” My home in Bombay still gets such mails. The spammers have to spend money for that. But in case of online model it is your ISP who pays to mail server-hosting ISP when you open such a Spam. Totally opposite of offline model. Also, now spammers have become damn smart. They would scan Internet for PC with less security (Blame it on evil empire of Bill Gates called Windows, the most widespread but most useless OS) to use as relay for Spam. This way they can even hid the origin of Spam. So just an advice (1) Don’t put anyone’s mail id in any web page (2) Don’t forward a mail for winning something. Those are just Spam. Remember the “Bill Gates is sharing his fortune” that was the biggest running online scam. It originated some 6 years back I still get mail of people expecting money for forwarding money. BTW, the reason I use Gmx.net as my primary email, because it is world’s only ad-free POP-3 supported mail service provider.

Peter…………..

About to finished the report that Peter explained to me. And now Peter pings me about some correction in some report. God knows what does he want!! He changes his requirement every now and then. Chatted with me to do something that he could have had done by just dragging some object (intentionally) hidden from reports. These OLTP guys are really big problem. How much time it takes to write a report on OLTP system. May be 10 minutes. The same would take 1-2 days or may be even more. If not possible then go for Freeform SQLs. Man. how he is chatting with me. I do not know the answers, so ask Ritesh. He was busy with Adi due to last day of week. He asks to ignore him. Well I just did that. 5 minutes later phone rang. That was Mayank asking about the same. Peter wanted a confirmation about the possibility of the same. I was witless, due to not having any information about the table used in the report. He was asking to make that report as he has seen in OLTP system, which we don’t see. So can’t comment on it. So finally the report guru Sachit comes. HE was the one who made the report about which Peter was fretting. I gave up. Sachit asked me ask Peter to chat with Sachit. Well Peter was still insisting that I should let Sachit know all that. I told his he was the person who created the report so it is better to ask him. Well 1 minute after that Peter said, “When you were not the person having created the report, why were you answering the question?” Bouncer… no beamer….

Just in one day the misunderstanding was cleared…

7 days and 30 Days. 3D Reports (I love myself)

Marketing and Sales are the most ideate guys that you come across in your professional life. Jinx broken with some doubts. Peter had given some reports to be complete ASAP about the user trends. I could say that the main report was very tough. There are total 4 reports. Size keep on decreasing but the difficulty level remains the same. The biggest report was almost completed by Raj. Really very good work. I was given that report in my down time but my approach was incorrect due to set of attributes picking date from different table and it was must to be taken from different tables s that’s how the WH was evolved. Well. I was trying to explain to Ritesh about the second report. They wanted approval % and $ of various card payment methods. Flat report was already present. Btu they wanted the average of same to be compared with last 7 days and last 30 days. After having understood this problem, I explained it to him rotating my finger less in case of 7 days and longer in case of 30 days, as if we were seeing reports. He found it very funny and wanted me to do it again… :)) Well Sriram came to help me out and told me that I can achieve it by “Apply Simple”ing the whole metric. Total bouncer. So He sat with me. Got the SQL. Edited it. And told me to the fine level what to be made “apply simple” [FYI, Apply Simple is the way to use database supported function directly in MicroStrategy. Highly highly NOT recommended by MicroStrategy Inc] Yup. By 4:30 I achieved it. I felt so great. By 5:30 it was tested and found to be correct. Now comes the pick on the day.

I started looking into 3rd report. This has very cryptic column name. I asked Sriram if he knew anything about it. He told me about the entire column he could explain, but he insisted to ask requester of report to verify. Well I pinged Peter on yahoo chat for it. When I told him I could not get 2nd column, rest column were depended upon it directly or indirectly, he just asked my ext. Voila, here is Peter calling you on phone. This thing that I could not get was Monthly Projection and they had written monthly estimates. He explained to me how is that calculated. I could not get it and I could not listen to him well due to my neighbor chatting too much. He is a complete chatter bug. He I just asked him to explain again. Well, He explained it to me all over again. I covered my other ear to hear him properly. (I don’t know but this strange thing of not able to talk well happens whenever there is an overseas call, inbound or outbound). Contrary to the feedback I had got about him, I would him excellent.

Sriram and Peter were hero of day for me. Sp. Sriram for making things Simple.

Zero of the Day. Sify Braodband. This blog was supposed to come yesterday but hey someone stole his wire and I was connectionless. Such thing happens in India. My broadband operator in Mumbai had accepted doing such thing.