I remember going to lunch was torture because the car was about 120 degrees Fahrenheit. But if we didnt go out to eat, we didnt see the light of day.
There was a team of about twenty people that worked on the preparation for this conversion over a one year period. The last few weeks were almost nonstop conversion dry runs.
Wed work a few days straight, take a breather, and then do it all over again. The only time I spent at home (when not in sweltering Texas) was to sleep and shower.
Finally it was time to do the actual conversion under the hot Texas sun. Okay, we were really in a freezing data center under the hot Texas sun, but we were still sweating under the pressure.
Each program took many hours to crunch through and convert all the data. So it was hurry up and wait, then validate. This was another one of those weekend conversions, so the team was under the gun to finish before users logged in Monday morning.
We almost didnt make it.
In truth we didnt make it, at least not completely. Out of the five developers who had written conversion programs, it turned out that mine was the only one that caused a major problem. I ended up using an older version by mistake and one particularly important data mapping was not correct, causing hundreds of thousands of duplicate records to be created.
Discovering this on Monday morning at 3 AM was not a pleasant feeling. I had let the team down and put us all in jeopardy of failing.
Through teamwork we were able to clean up most of the data by 8 AM, but not everything. Therefore part of the system was not available that first week until all data was scrubbed clean.
As I walked back to the hotel, we passed the training team waiting to go in and educate a group of users. The first thing they said was you guys stink!
I took the comment literally and felt like socking the dude, but the reality was that we hadnt left the data center all weekend, thus no showers. We really did stink.
I went to my hotel room and passed out for 12 hours, totally exhausted and despondent.
Looking back on it, I realize that these were great learning experiences that everyone has to go through. We all hit our rough patches. They key is that we learn from them.
Im extra careful about backing things up and making sure I have the correct versions of software, documents, and whatever Im delivering to a customer.
So what is my third worst experience?
Thats easy. After finishing a six month project, I had to repeat almost the exact same project for another customer.
Same custom software, just with different data sources.
I was absolutely bored out of my mind! There is nothing worse than showing up for work knowing that you wont be challenged and that you wont learn anything new.
Id learned tons from the first two bad experiences and would do them over again. However, I cant shake the feeling that any customer would rather I be bored to tears.
Eric Spiegel is CEO and co-founder of XTS, which provides software for planning, managing and auditing Citrix and other virtualization platforms.