June 18, 2009

Waahhh.....I skipped the blog for almost 4-5 months and back just to tell my day today. Today is one of the most memorable days in my first internship experience. The most satisfying as well pressurizing day. I started out quite nice in the morning. Tried to go earlier. Got a friend to chat with in bus. Arrived in Yio Chu Kang MRT just in time to poo in the MRT's toilet there (which then made me came late to work). Caught 70 just in time. Had quite a smooth noon. Thinking about going back earlier to research and decide on the macbook pro choices. But just when everything was about to end nicely, I clicked my mouse twice to slip into the worst case scenario in my job i.e. DROPPING DATABASE. Yeah, just a two-step two-fingers gesture and that would end you up in a biggest disaster ever in database-related job. I dropped 'master_outbound' database. One database only but from the name there we can deduce already that it is quite an enormous database. Easy to come, easy to go. The old proverb simply does not match with my experience. A two-step dropping process ended up in tedious and complicated recovering procedure. First I had to copy a similar database (new_outbound_delivery) and renamed it to 'master_outbound' (takes about 15 mins.) then I had to add two columns there (char_wtperunit and tonnage) which takes about 5-10 mins. Then I had my friend re populate both columns and re-check the data for duplicates and discrepancies. Next I had my other colleague to pull out a number of files from FTP which would be used to add the missing data to the database. After all data was populated, the quality assurance process came (done by the same colleague who pull out the files from FTP). The whole process took the 5 of us to leave office at around 9.30pm. Yeah the 5 of us. I was quite happy that my friends in fact were so tolerant that they were willing to stay late to help me to repopulate the database. I guess trouble has its own good side i.e. it strengthen the bond between us employees(?).  I went home by taxi. Very happy bcoz my supervisor said that the taxi will be compensated by company. In taxi I felt the most satisfaction mood I've ever had in my internship. Taxi fare was not as expensive as I thought it would be. I expected 15++ while it ended up as 12.60.

Feb 20 2009, Friday

I simply woke late n missed work...

Thursday, 5 February 2009

Hurray!! managed to finish most of the First Attempt Successful Rate report!!

Tuesday, 3 February 2009

Today as usual I continue my RubyonRails...

I found out that charts and graphs are not that easy to make. Although I have almost all the resources I need, it turns out I still struggled with it.

To cut the long story short, I finally found and solved the graph problem. I solved the Daily part of the program. Now what left is just copying and finalising for others. Looking forward for UAT!!!

Monday, 2 February 2009

Wew....luckily this Monday is not Monday Blues for me. I managed to finish the 'trend' series of the assignment. Daily to DailyTrend was a jump. DailyTrend to WeeklyTrend was another jump. WeeklyTrend to MonthlyTrend and QuarterlyTrend was a simple hop. Finally at least I managed to finish the table. Next thing is the line and pie chart. I am less worried for these two charts since I found a great documentation on amchart.com website about the chart. It was more interesting to play around with the chart rather than playing around with displaying the data using ruby. (Actually, had I not found the amchart.com documentation, the charts were another nightmare for me!!)

My supervisor finally returned to work this morning. Little late as usual. He seems to be cheerful since he greeted everybody at the cubicles.

After the charts? Play on graphic design and user interface!!

Friday, 30 January 2009

It is really a big day for me!!! Won't forget this 30 January 2009. This is the first time I found a way to solve my First Attempt Successful Rate assignment! It's about DN_Number man, DN_Number!! 

I was so confused (uber-confused if I must say) because I could not find what was wrong with my program yet I kept getting errors. I wished for Jimmy's help today but then he did not come to office!

9-12pm. 3 hours of confusion. After a break and lunch at Ang Mo Kio, I returned to office...be confused for an hour and finally found a solution!! I inspect the array of daily_figures to know what is contained inside each arrays. I would be very happy if my Safari hanged due to overwhelming data in the array...hahaha.

The rest of the day I just kept on programming and finish the 'daily' part of the assignment. Gotta home sooner for EE3001 meeting. Continue the rest on next monday. GO!

6th day, Monday, 19 January

Ahhh....today I did not get a sleep and stayed up till morning then cao to my office. Today I was just continuing what I've been doing...not much to say I think.