Sunday, June 28, 2015

MakeMyTrip or SpoilMyTrip - My Harrowing Experience

Background

To book a domestic flight ticket, you would either go to cleartrip, makemytrip, ibibo or the respective airline website. As I embarked on 45 days of professional work for Pune, I thought of booking a ticket for my wife and my 11-month-old kid. The journey was to be made on 28th April 2015 and as my booking was already done on an indigo flight, I thought I would book the same for my kid and wife. In what appears to be a blunder judgment on my part which I regret to this day, I decided to to book through makemytrip.com. Why did I choose this over others like the clear trip, well Makemytrip people found a cute way to lure people to their website. They show the price of your ticket before the discount whereas as clear trip will show the final amount that you have to pay.

On 17th April 2015, I booked the return for 28 April 2015 and 5th June 2015. It cost me Rs 14k but was refundable. It was later decided that I had to stay till 12 June in Pune but my wife wanted to come back. So I decided that I'd ask my mother to visit Pune and accompany my wife on the return journey since my wife was a little nervous traveling alone with an 11-month-old baby. 

I searched for cheaper tickets and found out that if I canceled my previously booked ticket and booked 2 tickets on Spicejet I would save 4k. Not bad at all. But I wanted to be sure about the refund.

On 30 April, after returning from the office, I decided to perform some cancellation operation on makemytrip and hoped that in the course of this action, I could see what would be refunded and hence I could decide to cancel it eventually or keep it henceforth book an additional ticket on the same flight. To my utter surprise, the cancellation operation was completed without giving me alerts about the refundable amount or telling me that I needed to contact the airline to know the refundable amount. It got canceled and in makemytrip lingo, called a partial cancellation. Since it is a partial cancellation, I would not be told about the refunded amount until it eventually comes into my account. And the painful, frustrating journey began...

MakeMyTrip - the synonym for dysfunctional internal departments, unprofessional handling, inexperienced customer care   

I called the airline to inquire about the refunded amount. To my surprise, the ticket wasn't canceled. I asked for the refundable amount in case I decide to cancel it. The total saving was not what I was expecting. The second error in judgment, I decided to call to make my trip and request them to ignore my cancellation request. I called them a number of times. It was a pathetic experience in itself. You would be asked for a 10-15-digit booking ID and would eventually be told to stay online while they transfer my call to the other department. Talking to these customer care executives, I realized that there was so little collaboration between the departments. To compensate for the lack of effective collaboration, they created a rule which made no sense. And these naive executives expected the customer to understand these rules as if they were god written. Some of the instances are

[Executive] "Sir, You have to wait for 48 hours and we will call you in order to confirm whether you want to cancel your ticket or not"
[Me]: "But I am telling you that I don't want to cancel anymore, why would I wait for 48 hours to tell you this"
[Executive]: "Sir, these are the company policy. There is a different department"
[Me]: "But the ticket price increases every day. Can you tell me if it is canceled or not? I want to book another ticket "
[Executive]: "Sir, usually it will not be canceled unless we call you for confirmation"
[Me] Thinking:  " WTF :-/"

There were no calls for the next 2 days and I decided to call them eventually, Some executive told me that my cancellation request had now been ignored and I could go ahead and book another on the same flight. I was already spooked, so I asked in written





I received the following reply,



Satisfied with the written reply, I booked another ticket on the same flight using Make My Trip just in case there is a problem in the future. The tickets cost me 8k. All was well until on 25 May my wife decided to do a web check-in. To our utter shock, the airline told us that the ticket was canceled by make my trip. I made numerous attempts to call customer care, and each time they told me to wait for 8-9 days without giving me assurance that they would settle it. I have to book another set of tickets for 4th June instead of 5th June as prices sky rocketed. I can't describe the pain, anger, and frustration they have caused me. Look at the complaints I have made so far,





To this date, not a single penny has been credited to my account. Every time I call them, they acknowledge their mistake and tell me that they will refund the amount in the next 6 working days. 


Summary

I am contemplating legal action as I believe I have a very strong case. I don't care less about the money I will spend pursuing or the money that is not been refunded so far. It is the unprofessionalism, lack of respect for the customer, anger, and frustration they have caused me. 

 I would strongly suggest against doing any kind of business with make my trip. After this, I keep hearing similar stories from my near dear ones. Just google "makemytrip pathetic" and you will see loads of this. If you still decide and make a booking through it, be ready to join our club :). Not Looking forward to seeing you. 





Wednesday, April 30, 2014

Experimental - Mondrian XMLA with Microsoft Excel 2010

Introduction

In my current company, we have our own propriety olap server. The requirement that came up lately was to support Microsoft Excel 2010. Since we already support  Microsoft excel 2007, we had to identify difference between these version. To query our server we used XMLA (server side using olap4j) with Simba O2X as excel and xmla bridge. 
There are stark differences between 2007 and 2010 especially in relation to filtering. This is a topic for another blog. To perform the analysis, we wanted to have open source OLAP server deployed, to which we can fire queries from excel. Mondrian was the answer. Our requirement was just to use food mart example in excel. 

Problems

  1. Mondrian latest version does not have food mart example.
  2. The previous version 3.5.6 of embedded mondrian does not work out of box. This page does not help completely either.
I like to share my experience with Mondrian 3.5.6.

How I solved it

I had apache tomacat 5.0 previously installed. As described in this page, i expanded my embedded-mondrian jar file in webapps folder. Since I was not really interested in having a production data base, I was more than happy to run it against apache derby. This embedded mondrian is available from git repository of mondrian,

  1.  MondrianXMLAServlet not available, Solution: Edit web.xml to have mondrian.xmla.impl.MondrianXmlaServlet as MondrianXMLAServlet  instead of mondrian.xmla.impl.DefaultXmlaServlet. The later is abstract class.
  2. Class not found error, "mondrian.test.DiffRepository"  , Solution: clone mondrian repository, deploy it on your eclipse and pick the class from eclipse compiled classes.
  3. URL of XMLA servlet was wrongly specified, correct it as per your local tomact deployment. This is the URL which excel will use to connect to your XMLA servlet.
  4. Wrong connection URL in datasource.xml. You can paste the following directly.
    <DataSourceInfo>Provider=mondrian;Jdbc='jdbc:derby:classpath:/foodmart';Catalog=/WEB-INF/queries/FoodMart.xml;JdbcDrivers=org.apache.derby.jdbc.EmbeddedDriver;JdbcUser=sa;JdbcPassword=sa;PoolNeeded=false;</DataSourceInfo>

Bingo! I was able to connect my excel 2007 with local mondrian food mart example. For connection with Excel 2010, you have to specify the wrong URL the first time so that a modified window opens up which allows you to select the catalog as well. Specify the correct URL now and catalog list will be populated.  Select FoodMart catalog and you are good to go.

Wednesday, May 12, 2010

Office Leisure

I was the one monitor man almost my entire life untill yesterday. The admin came as an angel and gave me the news that my request for dual monitor has approved. Within 15 minutes, I was sitting in front of dual monitor, looking like a geek straight out of the movie, pirate of silicon valley. After working on it for 2 hours I realized that dual monitor has got some real benefits like,
  1. Less distraction: Office like ours, where every now and then geeks like me attends to nature call or a caffeine addiction, causing unintentional disturbance to other. Well with dual monitor I can always hide behind the two lovely 17 inches I have got.
  2. Sense of belief: I feel like a geek and gave me hell of a confidence :) Hope it stays forever.
  3. Play around: I just love dragging application windows to different place of two screens as if each one is destined to be at specific place.
  4. False image: Newbies looks at me thinking as if I am the most sorted out, technically great and funky person.
And then there are other less important benefits like it helps in productivity, multitasking blah blah. I hope I get my third monitor soon. Though wont be placing request any sooner.

Cheers