Thursday, December 17, 2009

Last Words...

This summarizes what I've been doing in IT. Of all the people I worked with, I would say this is definitely the best group, everyone is technically capable and work ethics is superb. (I wont talk about process-oriented or management tasks: that is given).

And what is more awesome is to receive praises from these experts - similar to hitting 500K in Bejeweled Blitz hehe. During the last day (btw I'm proud to say i didnt cry!), one of the leads commented he has no idea how I managed to do these things when I was never in a single BRD (business requirements discovery) session and I also dont do ETL/OLAP development. I said I was just guessing from what I see. 'but your guesses are always correct'. So fun. :D (thank GOd I probably didnt have much booboos).

So that's it, I'm leaving this behind to do something else. Scary. Back to 0. Still the same goal: I want to retire!!! :p

Funny that I actually took time and managed to write down something related to work. DWH/SQL/data - whatever it is, it has become a part of me for the past 6.5years. I might not be vocal or expressive of things I appreciate. For the last time, I give credit when credit is due. Thanks for keeping me company and making me happy.

P.S. The time I speak the truth might be the time I bade goodbye. *sobs*

Data Checks (2 of 2)

Some more tips on analyzing incoming source data (referred as IFS in the telco project that I handled). Datawarehouse in a Nutshell: garbage in is garbage out. From a quality standpoint, throw away all the garbages before any app moves to production. The earlier it is detected, the less headaches, the cheaper. This again is part of the KT manual I created.

1. Most common issue is PK/integrity checks.
If there’s only one PK (natural key) stated in IFS specs, then IFS should not have two entries with the same natural key, this would result in Oracle constraint error during loading.
Product Code Desc Product Type
1 Class A 001
1 Class B 002

Possible course of action:
1) It could be source issue. Ask for Regen
2) Recheck data model. Maybe there’s a need to check whether natural key is defined correctly. There’s a possibility to explore addition of another new column, (eg. Product Type) which should be part of natural key to determine PK.


2. Not null columns.
Whatever primary columns or columns defined as not null in IFS specs, these columns should not be null in IFS.
Product Code Desc
1 Class A
Class B

Possible course of action: Ask for Regen


3. Unknown codes in Fact Tables
Logically, whatever codes submitted in Fact files should be present in Code tables, or else this would result to lookup failure:

Fact IFS:
Month Product Code Amount
200910 1 500
200910 3 400

Code IFS
Product Code Desc
1 Class A
2 Class B

Possible course of action:
1. If unknown code in Fact IFS is valid (product code = 3), then Code IFS should have regen.
2. If unknown code in Fact IFS is invalid, then Fact IFS should have regen.
3. Or customer can decide that it is ok to keep it as is.


4. Different Cases/Forms that cause mismatch during lookups
As pointed in above point#3, logically, whatever codes submitted in Fact files should be present in Code tables, or else this would resolve to lookup failure. However there are times that manipulation is needed in ETL side to make the join to be successful. Eg: functions like: UPPER, LOWER, TO_CHAR, LTRIM, RTRIM, SUBSTR, ABS, etc.

Fact IFS:
Month Product Code Amount
200910 101a 500
200910 000203B 400

Code IFS
Product Code Desc
101A Class A
203B Class B

Closely looking at the values, the values do exist but not exactly in the same form. This should tell you that these are not really lookup failures.

Possible course of action:
1. Agree with client who should change which and what should be handled in ETL in their side or our side. Other than the agreed things, then whatever that still fails lookup is considered ‘valid’. Revisit the logic when more data has been loaded. Document such to have reference in the future.


5. Volume of Data
The volume of data should more or less be consistent. If a fact file contains 3M records on a daily basis, then it shouldn’t fall too low, eg 100k records. For additional info, data volume is tracked for several other purposes. This is usually checked in SIT.

a. One is for tracking performance: comparing ETL processing time against different IFS files having different data volume.

b. Another purpose is for is tracking compression (in comparison to aggregated tables), this is to check whether compression targets are met or not. If targets are not met, then there is a need to revisit design. Some columns might not be suitable to be part of the group by clause.

Possible course of action:
If IFS file suddenly has too low rowcount, it has to be informed to client to check from their source. This might need IFS regen from M1.


6. Other Common IFS Issues:
• Duplicates - same entry of exactly same records are sent twice.

• Default values. Default values as indicated in IFS specs are not followed. There are also cases where agreed values are Y or N, but in actual IFS, it is showing null values, X values, etc.

• Missing footer record. ETL program from M1 side has to be completed, and thus trailer record will be populated.

• Column length too long.

• Missing or Additional column in IFS

• Extra spaces for data some columns in IFS, special characters.

• Invalid filename

Data Checks (1 of 2)

Sharing some techniques. I drafted this one time when I was asked to do some 'knowledge sharing'. It's actually just common sense and some room for imagination to cater for 'intelligent assumptions'. :)

Scenario: Amounts do not tally.

1) Open the report in UAT instance. If specific account number or cust is given, search for that number. Replicate the issue for those accounts/CIFs raised, you can bring in other fields into the report (eg Sector Code, Sub Product Type, etc) if you need more information.

2) Check how the amount is calculated. The amount field can be an OLAP variable, look for the specific table.column in ETL that is used and do the calculation manually. If it’s a direct fetch from EDW, then query the database.

3) Next is to query the source itself. If it’s a lookup field from another instance, then look for specific join conditions in actual ETL mapping. If let’s say all your amounts are null but in Raw has value, then something is wrong in EDW. Either it’s an ETL lookup issue related to data, or requirement itself is wrong.

Eg: Issues:
- All debit fields are null because debit stream lookup to VBM in ETL in incorrect
- Some FD Credit balances are not matching and consistently lower in OLAP than in Raw, because VBM lookup in ETL has a component for renewal counters, and this field appears differently in VBM and GFDR and has to be padded with 0.

4) It could also happen that for some of the accounts match, some do not match, and there is no data format (trimming, padding) issue or ETL lookup error. This would mean that some of the filters (in either ETL side or OLAP side) are not proper

Eg: We had issues wherein we actually have to modify the filters, upon investigation that something is consistently wrong in our side. Sample issues:
BO: add filter to include Accounts Closed within Current Month. Remove filter on Receipt Status is Closed
ETL: remove filter on sub product type = GT.
Net, it can happen that requirement itself is incorrect. There are times when we cannot fully rely on what is stated in signed off mapping specs/report specs.

5) Another way is the comparison of total number of accounts. In this project, we normally go by account. Get the total number of accounts in OLAP vs the total number of accounts in Raw.
- It can happen that there are MISSING accounts from Raw but in EDW we take them in.
- Or the other way around, there are EXTRA accounts from Raw but in EDW we don’t have. With this, then you have to extract the accounts that are missing/extra, justify why it is or it is not there in EDW. Then do analysis and find a pattern where possible.

Apples and Oranges

Here goes a simple sample for a datawarehousing project from a bank. (note that this is just simple current accounts and fixed deposits, we're not even talking about equities, derivatives, bonds or forex).


In a dwh project, usually there will be some existing reports from old system to be compared against a new EDW. EDW will consist of ETL (processing source data and implementation of all data transformation) and OLAP (reporting layer where further filters and metrics can be applied). With this, data accuracy will be challenged and it's troublesome to find which part exactly has data gone wrong. Sometimes numbers can be critical, especially in banks. These numbers appearing in the report are read by Marketing or Sales people for their forecast, or even CEOs. A cent lost has to be digged out.


In layman's terms: my edw has 20 apples (15 are apple pies, 5 are apple muffins) and 30 oranges (10 are orange pies, 20 are orange muffins). Existing report shows 30 apples and 30 oranges. Somewhere data has gone wrong, it maybe during tagging of pies and muffins or it maybe there is a certain formula for classifying what is a valid apple and a valid orange. Literally comparing apples to oranges. (I hope it gives a better idea now) :D Depends on the type of project, if numbers dont tally, normally it can NOT go into production until the culprit is found. Or sometimes maybe the existing report is actually wrong. Or sometimes the business requirements are not correctly captured. Endless possibilities.


I'm actually not a SQL expert. I can only do simple queries and subqueries, not the too fancy ones. Think about it, it's quite fun to do those intersect, union to extract the correct data that you need in order to find the culprit.































































































Wednesday, December 16, 2009

Q409 blues

I seemed to make a decision that has several implications, those that I'm not sure whether I can afford the consequences. Just that deep inside I have this strange feeling that I had to.. And the worst part is simple thing as it is, there were some complications along with it of which I didnt expect things to turn out to be. It seems like everyday of November, I was thinking of a reason, an excuse, a strategy to get out of the situation the soonest. Lame..to the point I had to start making stories, or even checking legal constituents hehe? There are certain decisions when made, you can only afford to err on one side. The more indecisive, the more strings attached and the harder it is to be politically correct. I am not good with this, dont hate me. All's well that ends well anyway.

November was also my mom's bday. For a change, I wanted to surprise her. Thank God there were friends who helped to realize this. It's the first time I thought of giving her a 'real' un-informed surprise. I scheduled 2 deliveries within the week courtesy of Red Ribbon, for both her real and lunar bday. Her reaction: priceless. My reaction: bitter sweet. :(



I went to Bintan for a quick weekend getaway. I went there with guilt, stress and usual confusion, and flushed down all these with the unending waves. I went back cleansed and relaxed, hopefully. As perks, unexpectedly I got a free pictorial, check it out at flicker :)






Christmas and New Year. It's always my most favorite holiday, discounting the fact that the most painful things also happened the same time many years ago. Now it still pinches my heart a bit to see the beautifully-lit streets of Orchard now packed with even more glamourous malls, with me alone walking, even if I have companions. Strange that the emptiness doesnt get filled by just anyone. (Cool, serves me right) By the way my hausmate was homesick one day and sharing her memories of having christmas trees. Unfortunately I cannot relate, coz I never had one back home. (okay let's not dwell on difficult lives in this post :p) Passed by a store and thought of buying this 'snowflaking' crystal ball, a slight attempt to put a little decor in my room. :)

It's confirmed, my newest nephew coming sometime Feb is a boy! My alagas will be increased to 4. !!!

And I thought my previous offices are already big MNCs. (or maybe I also cannot directly compare the offices). It's quite exag to see the dual monitors per person in each spacious cubicle in the new office (one monitor seems not enough, they want the comfort of dragging screens in 2 display monitors) For me it doesnt matter, most important is I dont want laptop! I dont want carrying heavy stuff to and from office anymore :p, i dont want bringing any work home. so just give me my desktop hihi! Same goes with the hearsay of 2ksgd ergonomic chair we're sitting on (?). I feel barbaric, like coming from mountain inhabitation. Vain, but I like. :D

I just realize how much I love sql and data analysis, now that it seems I wont be doing much of it. For only this once in my career, I felt a sense of accomplishment. It has become a part of me... now is the time to recount our memories, before we go separate ways...*sigh* I will blog in detail in next post.
Merry Christmas everyone! I had 4 consecutive parties since last Friday, despite claiming to be anti-social. hohoho. Santa, grant me a major wish this year... Btw in one of the parties, I was told.. ang lamig ng boses while singing. Excellent, luv it Crazy for you by Madonna! Let me end this post with a christmas song.. Chestnuts roasting on an open fire..... :)

Friday, November 27, 2009

Eco Tours

Joined a field trip with my friend last Sep09. Learned several things about agriculture.

Frog Farm
Trivia: How to differentiate a male from female... the female has a yellowish neck.
Other than frogs, they also have ponds for eels, fishes, etc. Other interesting fact is that all these (female) can lay hundreds of eggs. You can earn lots as long as weather cooperates.










Goat Farm
People go to these farms to buy fresh goat milk.












Bollywood Veggies
This is the closest thing to Tagaytay, but smaller and maybe, not as developed. Similar to Sonya's concept, they plant everything that they have in their menu.

Pulau Ubin Tour

Pulau Ubin is an island lying in the outskirts of SG. In it there is Chek Jawa for you to explore the different ecosystem/habitat. Went there last Aug09.

Random Thoughts Oct'09

...delayed post.


I finished watching the korean series hit phenomenon Boys Over Flower last month. (This is the korean version of Meteor Garden). Just one thing, it doesnt matter whether it's korean or taiwanese or japanese version, my heart goes to Ji-Ho/Hwatselei/Rui. When the whole world goes crazy over Gu Jun Pyo, I still like Ji Ho more. Well I cant say I dont like Jun Pyo (no normal girl wont be attracted to this manly creature), and I also dont have much inclination towards authistic people, just that he has one quality.. the ultimate 's'. Watch the series and see for yourself.

Because of this, I started researching this hottie KHJ. Quite young, he's born in 1986. He's the leader of SS501 group and oh my, he dances so well, the dance step with the shaking of jacket in the song 'Im your man'. Well cant understand anything except when he shouts 'Im your man', translation would be much welcomed. Whew cant keep my eyes off him. (ok ok too much bs) Here's a link. http://www.youtube.com/watch?v=bxu94q7HWew&feature=related

Haayz I took Korean and I can't understand the lyrics. I took French and gave back half. Now I just finished Japanese, yes nihonggo dear, dozou yoroshiku. Ask me now, before I return all of it again. Well at least I master 4 languages from birth then learn 3 extra (barely basic level, nothing to boast of), that brings my total to 7.

I attended my friend's bday party few weeks ago. There I met a French couple. I was able to use my 'Comment talez vous' and 'Aunshante'. (the spelling is not reliable) The french guy said my accent is ok, he can understand me. Note that French has one of the hardest intonations. I feel flattered :p See this is how learning a new thing comes handy, you can relate to people in small little ways. So here goes another passion, finally started dancing waltz. Curtsy.

My attempt to find a new job sets in. I rarely have the urge to apply for new job, unless there's a trigger that fascinates me. Hmm like my first company? I just felt like squeezing myself in because it seemed hard to get in. (90% substance and 10% luck?). This time I want to squeeze myself into one of the top XXX, and I dont know any acquaintance working there except for one ex-colleague. The other top 2 places are where almost all my friends are working at. I am not crowd-centric so I didnt try the same companies. What topak is the cause... Prestige, shallow as it may sound. And actually cowardice to be exact.. trying to let nature decide its course. Running away. Or maybe, just maybe, this is actually what facing reality is about... There are always 2 sides of a coin, it's up to you to decide which side it actually is. I am quite tired, que sera sera.

I was excited the first week, then delay sets in. It's the first time I got a phone call that is neutral - i was not rejected nor accepted. In short, the rule of elimination is there. Probably I'll stand a very minute chance if they cant get anyone, and the waiting timeframe seems indefinite. I am not satisfied with my interview answers either. I have an expression disorder. Thoughts, actions and words don't jive at the same time. I'm not good in putting my best food forward. Well, there are other major booboos in my life anyway. Maybe the one essential answer that I want to know, till now still cant spit out anything. Big L. (L sign on the forehead). For such answers, I guess it's just a matter of time when I'll be able to tell myself, maybe the answers dont make much difference anymore. :p

There was a day I was late to a dinner get-together, only because Canon in D was played in an orchestra outside a new mall. I just stood there till the piece was finished. I was drawn to the melody, it always reminds me of My Sassy Girl (being one of the OST). One day I hope I can also write an interesting story online.

What should I write.. It should be unique. Interesting. Sweet yet some bitterness. Most importantly with my signature air of depth and non-sensical whim with a twist of suspense that perhaps nobody would understand. Disturbing. Anticipated flop :p A taste of it below.

...A strange dream. I kept knocking. Knocking so hard that my hands bled and bruised. Still the door wasnt opened. The stars that I hold on to, started to become blur. Was it just my imagination? Hallucination? Well do you ever care? It is just me? Probably yes. The echo seems to reckon.

Enough. Reminds me of my friend's fave phrase: P.O.I.N.T.L.E.S.S. Literature suicide hihi

If there are no enough points, then a line segment wont be formed. It's not always that life gives you a line with the arrowhead. Math guru.

Still, is holding on to something pointless considered stupid? I used to firmly believe it's not, now I thought it can be. (but I still am in denial to say it is hihi) Time to live a life, dear princess.

Speaking of, I have a severe hallucination disorder. Like for one, I always would like to feel I'm tall. Then suddenly I looked around and notice just within my circle of friends, I can already name 1 or 2 girls taller than me, and they dont feel they are tall. All these years, I chose to think I was tall, which now I think I have to brainwash myself all over again...unlearn and relearn.


Few months ago I queued so long in a bank for some transactions that later prompted me to write my first letter of complaint online. Onlife stuff works amazing here. I did get a reply within close of business, apologizing and saying they will investigate. I related the same story to my achi. I was really waiting for her to say I'm bitchy. She just commented on my well written letter, told me I have a talent. Then asked me 'Gago, what's your problem??!! lo-siao!@#$' Haha gago is a sign of endearment for us. The whole story was I lost sleep the night before, then had to wake up earlier that morning to go to the bank, queued so early and soo long with an inefficient queue handling system, then rushed to office and missed the bus, paid much for a cab, then was late for a meeting. It doesnt justify anything for bitchiness :p, just that we are human beings. I get pissed off too, dont push me. Waah I should be thankful there are still a handful of people who can tell. Or who simply chosed to believe. Even if I dont say a word. Thanks for blurting out the words for me. Things are not always proportional to what is seen or heard. We are all just mere elements of fate and logic and emotions. And sometimes not everything has an explanation. Watch 500 days of Summer.


I am in my petix mode, project's about to end. Addicted to FB games during office hours. Bejeweled Blitz, cant help but to play the one-minute game and try my luck to strike the top1 spot. Farmville is also nice, I fancied one thing there, that keeps me planting everyday. Havent played the more famous Mafia Wars or Resto city, not too much into games with 'interaction'. May not be so obvious, yes I'm anti-social, I finally realized I'm one, whether you believe me or not.

Recent gadget update: finally bought ipod. As mentioned previously, just to experience the feeling of the 'wifi'-enabled city of SG. Unfortunately, I'm not using it quite often for wifi, unlike people who update fb statuses every hour. I dont seem to have a gadget appetite, not fancying anything new, even the iphone 3gs is not enough to lure me for a 2-yr phone contract. Probably iphone 3gs is a good instrument for status quo, however I'd buy something else if that is the purpose. *wink*

I'm still enjoying the scents in my room. Last month is lavender, this month is jasmine. I wonder what to put next.

I can get satisfaction from a simple task as shampooing. I'm addicted to newly washed hair, even more to fan-dried or blow-dried hair. It sets a good mood, a good start for the day if I'm able to feel my hair fresh and dry. Sheer happiness and also the cause of tardiness. (it rhymes)

Polda-dotted, that's how I think I looked like. Went for a massage few weeks ago. The masseuse was so eager to do her salestalk for 'cupping' (pa kuan). Google it, it's a form of ancient Chinese detoxification therapy where you have empty bottles on your back to suck the toxins out of your body, via pressure valves. (orig is via fire, but that's not too commonly administered now ) Since it's free, I nodded and didnt seem to expect the trouble this would be bringing me. Holy cow, it was one hell of a painnnn, I felt like being severely beaten and punched. After the therapy, my whole back and neck have big, dark red swollen circular spots. My hausmate teased me, the marks look like .. love spots? I laughed and said, 'I think being sucked by an elephant would be more suitable lolz!'. Whoooa it took 10 days to fade all these polka dots, I felt pain the first few days even when lying down or sitting. I dont think I'll be doing this again. Well after a few days, it did give sort of a relaxing feeling. But the whole process, overall I dont think it's something worth doing regularly, I'm too tired to go through hell to get a little taste of heaven. (here's a cropped pix, quote me I normally wont go backless for a self-taken pic - too crazy, just that this is a waste if not captured)

I behaved well this year, didnt keep going to Manila for vacation like last year. Maybe, there's not much difference anyway. I underestimated and overestimated several things, really.

It has been a different year. One simple thing. The world will not stop revolving. It's up to you to keep up. I tried so many things, avoided a few things. In the end, it's not so easy to pick up where I left off. It takes courage, and I dont seem to have enough of it right now. I play with numbers everyday in my work, however age is not one of those numbers to play with, I know.

If life can be as simple as just dining in a nice place, taking some fancy pictures, the world would be such a happy place isnt it. =)

Tuesday, October 27, 2009

Song for the Day

Featuring the latest LSS of the week:

It's been playing in my ipod over and over again. Yes I bought one last month, just to experience the wifi-enabled city of SG, where everyone feels it and I still don't. I am barbaric.

I'm hooked with the melody. Even if you don't understand the lyrics, listening to it gives u somewhat a surge of emotions. (Disregard the video, I personally think the song is much more meaningful than the video content)

http://www.youtube.com/watch?v=KmQJcIw7fAA

灰色的彩虹

我從秋天等到 安靜的落葉
還不夠時間 倒帶想念
就像電影情節 最後完結篇
褪色的畫面 沒有笑臉

我的記憶搖晃著昨天 我還有感覺
一抬頭什麼都看不見 雨後的無言

紅橙黃綠我都找不到的晴天
從此 我們兩個世界
在灰色季節漸漸忘記你的一切
過幾年 我在原點

彩虹出現 而我再也找不到
美麗的蝴蝶 偏偏飛不上天
對你的想念 再也寄不到
你世界 地址是再見

P.S. If you manage to understand the lyrics then this somehow describes how I feel before taking the chapter tomorrow. I'm living to my name of 'nature girl', the lyrics mostly pertain to nature elements. I'm going to be hooked on this for some time I think. It's a hook that I throw myself into...

P.P.S. The hardest word to say.. it's not Sorry, not I Love/Hate You. It is Goodbye.

Sunday, October 4, 2009

Jargon

I was never good in bluffing. - my weakness, hate it.

Here I am trying to understand some fin/fx jargon to prepare for a 'testing the water' day tomorrow. If I respond fast enough, then I might be 'considered'. Booh.

There's only one thing in my mind from the very first day I stepped into the corporate world, the IT world to be exact... I like the job but I STILL want to RETIRE EARLY! haha.

I am really not confident in this.. I have a feeling this is not gonna work. Worse comes to worst, please join me for a few drinks and ice cream tomorrow.

Still, I tried and am trying my best like any other encounters in my life.. 要不起就可以不要了嗎??

If I am to write a song, that would be superb lyrics. =p

Saturday, September 19, 2009

The Simple Things

I like. I crave. The best things in life are not always expensive. =)



The best-tasting siomai I've ever tried. I discover this in a little store across my house here. Too bad the store opens only during mornings till 1230. It only costs 0.60sgd per piece (considered cheap here)










I so much like this Polo bread (Po Lo Pao), this is quite popular in HK. It's a soft bun with a not-too-sweet crust designed to look like a pineapple. Note that only a few bakeries here have it (well the most famous Bread Talk doesnt sell this). The nearest bakery to my haus only produces a small quantity of Po Lo Pao, hence again this is one of the reasons to wake up early and rush down to get hold of one.


Strolling is the next best thing on a lazy afternoon. The clean river, the bridge, the dollhouses (aka mansions), the sunset, the lights view at night. Hmm hmm.. if only parks in Manila are not just meant for dodongs and indays.. and if rivers can be much cleaner.. lolz














I seem to have developed a new addiction for soft scents (not the dizziness-inducing strong air freshener in cars). I now have a regular supply of something nice-smelling to hang in my bedroom. The scent, with my bed and
blanket.. all hates to part with me every morning.


The new lamp, Just the right hues for night mode. (the lamp has disappeared with my high-tech cam :p)

Monday, September 14, 2009

Heal

In this world, seems like everyone just have so many hang-ups in their own lives.

...I'm guilty to have my own share, once in a while.

I was listening to radio the other day and heard this song ranked as #1 in the weekly hit chart. Melody is nice and the voice is very 'clean'. I immediately searched in web and to my surprise, the singer is... handicapped. He is blind.

http://www.youtube.com/watch?v=fvk7EZdpHJM

The video is about a lady grieving over her failed relationship. And as she narrates and seeks comfort from the singer, she's also describing to him what colors are there in this world. The dialogue goes:

Lady: (after consolation)
The ocean is blue.. The sky is white.. The tree is green.. The flower is red. I'll paint love with color.. My smile is a spectrum of colors.

Singer:
My ocean is pitch-black. Sky is black. Tree is also black. Flower is still black. However, it seems like only love is white in color.

The mandarin verses of course are much more meaningful (I just made a literal plain translation). I felt moved by the song and the video. The singer happens to be a main guest performer in the previous National Day Parade. I admire his determination to inspire people with his talent as a composer and performer.

Maybe as long we have eyes to see, have feet to walk, or just being able to breathe, is there really a burden too drowning to let us down. Something to lighten us up.

Monday, August 10, 2009

Malacca day trip

Overdued post. I went to Malacca last June for a city tour.

The most popular landmark in Malacca is the Melaka Church, situated in Dutch Square.















Other remarkable pix are:
Statue in a Chinese Temple (which I forgot the name)











Jonker Street
(reminds me of my hometown, this is how Binondo looks!)










Trails of Baba and Nonya Musuem
-these are the descendants of Portugese-Chinese. They are known for the beaded handicraft artwork (which by the way is very expensive as they are hand-sewn piece by piece). And also quite known for the Peranakan cuisine, which is as spicy as you can imagine.









Bakery (interestingly named Sha Shu Kong, meaning 3rd uncle)









On the trip back, I was watching Jet Lee's 'Fearless' movie on the bus. It has been so long since a movie has made me teary-eyed (or was it because I was feeling low and down then). Anyway, I was moved by the character of Jet Lee, of how he transformed from an arrogant fighter into understanding the true essence of winning. A lot of things in life are not what they seemed to be.

P.S. Finally back to blogging mode. I was surprised to see thousand+ hits in Adsense (although of course it only has a few cents lol). I'll try to lessen the 'emo' posts in the future :p

Strange Images

There are certain times when you feel like throwing a Vista machine. Waiting for 40,000+days is 100years+. Are humans still alive by then?









Remember the usual puzzled look you'd see on cartoons, like three strips of sweat dripping on the forehead, and some question marks appearing all over the head? This will make you recall that expression. That's why conversing in Mandarin is preferable at times.











Cookies and Creme flavors for ice cream and cakes are certified crowd favorites. However, I never thought of having it on my hair during a hair spa session. Another killer - special bundle of joy? I only see the phrase used by excited parents welcoming their newborns, other than that, this is the first time I've seen it used elsewhere.












P.S. No offense for any sarcasm for the last 2 images. Kasi pinupuno lagi ang mailbox d2 ng flyers. I hope they dont have blogs and dont read blogs. But anyway think of the bright side, this is free online advertisement :D

By the way, I have added one more resto to my previous blog for Best Kept Secrets. Once I have the time, I'll showcase some more foodie trips.

Sunday, August 9, 2009

What's Cooking 09

Some serious decoration can help create appetite. Let's have some fancy names this time.

Grilled Chicken Marinated with Basil and Herbs

(finally trying to divert away from the usual Chinese cooking hehe)









Prawn and Squid Ball in Tomato Puree

(in layman terms, leftover from ref :p)





Deep Fried Lapu-lapu fillet

(the secret is simple, marinade)






My Two Way Chicken
Teriyaki Chicken - finally made one without using a ready-made sauce!

Oatmeal Fried Chicken

(theme is sesame seeds :p)



Chicken and Veggie Medley

take note of my flower carvings again

(special mention to this simple dish is that I cooked this last year at home during my vacation, my mom and sister liked it and asked for my recipe! yoohoo success)



P.S. Finally starting to expand my seasonings. The taste of the herb mixes is quite strange at times, even I didnt like it, too strong.

Best Kept Secrets: Food Reco

Yesterday was really an enjoyable day. KTV for 5 hours from new songs to classic 90's genre, followed by an unexpected sumptous meal over Uncle Leong's seafood of which is known for Crab Beehon. My initial reaction was like 'huh? crab sotanghon is ok but having a crab swimming in a bihon soup, that doesnt sound good?'. Yet it was one of the best tasting soup I ever had. To finish off the night, I finally watched G.I. Joe and I enjoyed it, I even think the plot is more interesting than Transformer 2. A much needed relaxing break.

So here goes my urge to share some of the restos that I recently tried and would recommend. The best ones are usually not located inside the malls, it's for you to uncover these best kept secrets. And another important thing, there is definitely a long queue! The longer the queue, the more it arouses my curiosity - anong meron? pila rin tayo. :D

Uncle Leong's
As mentioned, known for crab beehon, an alternative to the usual chilli crab and black pepper crab. If you are not a spice fanatic, this one's for you. The crab is big and the meat is firm. The soup is so tasty. This is just located in a hawker near AMK, not a fancy resto. The other dish is deep fried prawn in salted egg (but I personally still prefer cereal prawn over it).




Vines
I like the ambience of this resto, it's just so homey and it actually resembles some restos in Phil. Light is a little dim, music for chillax, ideal for dates actually and the most important thing is I like their famous BBQ Pork Ribs (which is ranked among top 100 dishes by some orgs) And it's quite cheap. I find the steaks better than Tony Romas and the price is just less than half. There are times when you just want to have a good meal with good company, and you wouldnt really feel like splurging all the way - so this is the best place to be.


Founder Bak Kut Teh
I'm not a huge fan of Bak Kuh Teh, I seldom order it. However so far this is one of the best tasting bak kut tehs that I've had.






Loy Kee
Actually I cant distinguish much what is a 'good' chicken rice :). I just know that this is one of the famous chicken rice restos in town, next to the famous Boon Tong Kee and Wee Nam Kee probably. The chicken is tender and juicy.




Those that didnt quite make it to my fave list:

Ajisen-Ramen
I dont know why there are so many branches of Ajisen-Rames all over Asia: Singapore, Malaysia, Thailand, HK, China, Macau, etc. I actually didnt find anything outstanding (or probably I'm not ordering correctly?) I find the ramen soup too oily and salty.







Xin Wang Taiwan Cafe
One of the popular Taiwan street food is their breaded chicken chop. This one's really a huggge serving and I finished it. Pair it with milk tea with sago - Perfect







Xin Wang Hong Kong Cafe
And the equiv for the staple food in HK is none other than HK baked rice or baked spaghetti. Quite ok, just that usually the cream tends to make the dish too 'nakakaumay'. Pair with nai-cha (milk tea) and it sure's gonna create some sensations in your mouth.





Soup Spoon
For me this is an ideal place to go when you have colds. When you are in your sneezing mode and you feel like drinking a hot healthy soup with veggies (like minestrome or chowder), this is the place to go. A typical order is a soup with a french bread, cost about 12sgd.




Zhou's Kitchen
I saw it in one of the reviews to be great, one of the famous Chinese dimsum in Novena. The best seller is some siomai soup. After tax, each small bowl costs more than 17sgd+. I didnt find it worth the raves.





Updated Aug 13:
Deli Moroccan
The best place for moroccan dishes, try their kebabs. A big serving costs only about 10sgd. You can also try the freshly brewed mint tea, which gives you a strong toothpaste aftertaste - unique. (though I dont feel like consuming it often)

Saturday, August 1, 2009

Testing

Wished I bothered to study typing in Chinese before. Composing below lines took me ages.

都已經過了兩個月了,
可我心裏有時還是七上八下的.
怎麽有一種被惩罰的感覺 :-<
這次真的考倒我了 真希望...

Monday, July 27, 2009

Nothingness

Was so lazy the past few days, or was it the past few months. Failed to update blog in a long time. Toxic days ahead in work, I can already feel it coming.

Pasalubong
Some of my favorite pasalubongs in my last trip:
Mom's blouse - I got attracted by the brooch-like sewn design the first time I saw it and the cut of the blouse, however the blouse was twice my budget so I left without buying (I previously already bought a few pcs for this uwi but not as nice as this one). Few weeks before my flight, I again went to my usual shopping place and saw it again. Cant resist anymore, I know it'll look good on my mom. I specifically told her to reserve that for special occasions only *winks* demanding.

Nephew's shirt - I am not a big fan of any cartoon character but this one really caught my attention. I saw it on sale and dug my hand so fast. Just so cute both graphics and message. I think I better stop buying too kiddie stuff as my nephews are already in grade school



'Lag'
I somehow have a 'lag' in terms of price range and fads nowadays in Manila. I'm still used to what I thought was a 'reasonable/practical' price of commodities and services before. If you're away for 2 years+, then you'd feel the surge in prices, inflation in Philippines. My sister was laughing, 'dapat nga sanay ka sa mahal eh'. I answered 'sa SG oo no choice eh, pero dito parang weird!'

1. I went for dental tooth filling (pasta) and was charged for 1500phhp for 3 teeth. I used to pay only 300-350php for each before. I complained at home and my sister said, ''pasalamat ka, I just had mine for 700php each!"

2. I was asked to treat lunch at Penang Hill. I used to like their food before, but it wasnt on top of my list for the reason that I can taste any of their bestseller dishes in the hawker anyday if I want to. However since my companions seemed to be craving for Makan food: here goes Roti Prata, Beef Rendang, Thai Tom Yum, Char Kway Teow, Fish Curry. Hainanese chicken was out of stock or else 'all present' talaga. And that point in time I was craving for Jerry's Grill hehe, well not really a mega huge fan of Filipino food. Anyway, since I enjoy being in the company of people na nasa mood kumain, so cge pagbigyan. Since there wasnt any expensive seafood at all in the bill, I was a bit surprised that total charge was like more than 1400php. Mahal na rin pla mag-eat out sa Manila.

3. Jollibee - a place I always have to pay 'courtesy call' to.
One-pc chicken spaghetti meal with drinks is now 100php. Gone are the days where 50php was sufficed for a chickenjoy meal. One-pc chickenjoy meal with drinks is 82php. Anyway, I still enjoy eating at Jollibee. As my friend reacted, if a fastfood meal costs 100php, magkano na ba ang allowance ng mga students ngyon sa Manila?

4. I havent received a bday cake in quite some time. Finally got a Mango Bravo from Conti's, which I heard was popular. Lame first-timer. It was good.









5. A friend told me membership at Fitness First's gym is now at 2600php/month. 2 years back, I know it was only 1200-1500php. It doubled.

6. My sister got a free voucher for massage and pedicure from The Spa, which she wont be able to use and gave to me. I havent been there before and I know they charge above average. Anyway it's free so I went there to pamper myself. I checked the worth of the vouchers: pedicure 380php, 1hr swedish massage 820php. Quite high especially the pedicure! After the pampering session, I further walked around the mall and saw a lot of familiar shops that I see in SG: Wade, Aldo, Iora, Topshop/Topman, Dorothy Perkins, Promod, etc - the prices are similar actually at 2K+php. (2k+php seems more exorbitantly high than seeing 70sgd? :p),Seems like spending level has gone up in Manila.

7. Kelan pa nagsulputan ang mga Savory Chicken branches in malls? I havent noticed this before. A briliant step to franchise a classic indeed. I used to order chicken and lomi from their main branch in Escolta. Bigla ako nagcrave, that's what I requested to be ordered in my yummy byebye dinner, with Mom's home-cooked seafood dishes. Party time.









Lag na, d ako updated.


Counting
Because of the recent stories related to sickness shared by people around me, I suddenly became aware and conscious of life's predicaments, i.e. gynaecological-related.

I used to have a classmate before who was the ultimate boy magnet, crush ng bayan, the type whom ordinary girls (like me) would admire. This girl was already engaged 4 years back, and yet mysteriously, her wedding was called off by the guy's side. It was like 'omg, what went wrong, jackpot na pinakawalan pa'. It was only late last year when I heard of the reason... The girl went through some operations with mattress (uterus)-related problems and have implications on birth-giving. The harsh reality.

and I initially thought such disorder was rare, .. seemed not.

I recently heard of few couples who were married for years and wifey not pregnant till now. I guess such situations are tough. Irregular menstrual cycle, polycystic cases, in vitro, etc,

So what sums up the essence of a woman:
At age >24, question: kelan ka ikakasal?
After marriage, question: d ka pa buntis?
*Additional for the old-style FilChi, question: wala ka pang anak na lalaki?
:)

Well I guess the essence of a man doesnt sound so easy too, add to above: earnings? cars? house?. so life is what.

Anyway, as my mom puts it, better 'pay tuition to buy peace of mind', referring to having check-ups for prevention. Note that it was heavily raining in Manila the whole week I was there, and I got to experience typhoon signal#2 again in a very long time. Despite so, I still dragged myself for an ultrasound. (read: ultrasound is not for pregnant woman only, it's for checking whole upper and lower abdomen with all the organs). I hope to see results as 'cleared'.

The nurse/technician who assisted me seems like a baguhan. I dont know if it was SOP as she asked me so many questions. It was my first time so I also had no idea. Suddenly she pointed at the screen and counted aloud '1, 2, 3, 4, 5, 6...'. I was like 'what???', i suddenly felt some numbness. I asked her 'may nakita kayong cyst?'. She answered 'ahmm ahmm, wala naman'. I asked again, 'normal ba'. She said 'antayin nyo na lng yun result bukas'. Hmm I'm not feeling lucky nowadays, I really hope there is nothing serious.

The next day I went to get the results. Despite the medical jargon, I didnt see any familiar word that should be a cause of big panic. The only '6' I can see in the results is the measurement of some organs like 1.6*1.9*2.3 etc, so I guess she was counting the centimeters from a ruler bar in her screen? I felt somewhat relieved and went for the doctor's diagnosis. All's well that end's well. (If not, I wont be blogging about it here). Loko lng si nurse :p. Anyway, that's a reminder for all the women and girls (once you have your period), it's always better to be safe than sorry.


The Young Days
I live in Binondo, studied in Binondo both elem and HS, and the whole stretch of Masangkay and Benavidez, memoryado ko with closed eyes. I went there for an errand and ended up buying all the street food that I can see. It was years ago when I passed by there.
- Fishballs, Kikiam and Kwek Kwek outside St. Stephen's
- HK style pan-fried noodles in Eat Fresh
- Fresh boiled corn outside the chapel near Metro Hospital
- New store: pancit malabon from Tunay na Pancit Malabon
- New store: fresh bibingka (i forgot the stall's name)
too bad there was no dirty ice cream that time.

If only my stomach could still fill in some more food - there were Suzhou dimsum and Lan Zhou La Mien across Metropolitan Hospital. I was surprised to see Goldilocks and Red Ribbon in the same vicinity too.

I was amused to see another new condo in progress right across St. Stephen's High School. Metro Hospital now looks superb and 'sosyal', far from the shabby building it used to be. It even has Seattles's Coffee house inside.

I also got to try some of my fave Binondo dimsum houses again while meeting up with a few close friends who bothered to take time to see me:
- Wanchai
- Tasty
- of course Wai Ying
- Xiao Chuen Yuen

It was like time travel.


Ending line:
I heard this line from someone before...'where nothingness is everything, and everything else is nothing'


P.S.
都已經過了兩個月了, 可我心裏有時還是七上八下的.
怎麽有一種被惩罰的感覺 :-< 這次真的考倒我了 真希望...