We were happy about it. We partnered with a friend family and bought an investment house in Toronto. This individual double garage house is good for family rentees. Our friend posted the ad on MLS and Facebook. Finally, we settled the lease agreement with a family who happens to have a building project nearby and would like to live here for a while.
This experience could be ranked as one of the top challenges in my life. Among those including mathematic competitions, solo performance, board report presentations and CPA exams etc. This developer interview and technique test were really sucked my bone.
Although I write many SQL scripts in my daily full-time work, it does not mean that I am a professional developer. In fact, I am a well-skilled Financial Analyst. I learned and practiced various programming languages, including Python, R and SQL, because these skills help me to improve my efficiency. I never think about moving my career into this area.
There was a sweet opportunity. This banking giant is looking for a SQL developer. The main focus is to main the advanced Finance systems. Surprised that I passed the first round of behaviour interviews. Actually, I didn't think that I would go into the next technical test interview because I was not from the development field.
Understand that I will not be a good fit for them. But I still spent a whole night refreshing my knowledge. I just did not want to show a terrible paper, hopefully at least 50. Of course, I wasn't picked. But the hiring manager gave me a call and told me that she was actually pretty impressed with my test. I was ranked No.2 on her shortlist. Wow! What great progress in my data analysis exploration! I am very appreciative of her for giving me this opportunity to see my thoughts too.
Sometimes, only when lines come across by a trigger, we have opportunities to know each other.
Appreciated by our neighbour's small backyard party, we were gathered together. Lisa and Joe just lived next 3 houses by ours. They joined this street about 4 years ago. Due to our busy life and work, we never meet each other face to face until this party. And I realized that I don't even know they are on our street.
I grab this chance and chat with Lisa as much as possible. In compensation for the time that we missed, I showed her my garden, and we exchanged our interests. I admired her that she has two young kids, and she can take care of her green plants so well.
I thought they would allow me to work on this project for at least a week. Nope! I received the request and basic information just one night before the report. Although it was not a new thing. We learned the skills at professional programs. This is the first time that I was asked to submit a report based on foreign currencies too.
The boss has a plan to invested in this foreign farm and importer. The partner site has prepared a version of FS in their local practice. I needed to translate this into our general practice here. And calculated the forecasted revenue, assets and EBITA.
Lucky that this was not the first case for my manager. She sent me a previous case study. Based on her previous template. I was able to figure out details bit by bit and filled the numbers. We discussed on the phone to confirm our assumptions of predict market growth rate. Then we submitted the report for review.
When the partner site feedbacked that we did the right thing on most items, it was a big relief. And we worked on the mall changes after that, like reclassifying the custom drawback item as revenue and removing biological inventories revaluation (gain or loss) from EBITA.
It was a great practical experience for me!
I am delighted that when I resolved the query in this way. Finally, I understand that I can add a null column when I combine tables if there is no data in one of them. I can apply multiple filters to make the query more accurate.
I can validate the data directly, and the numbers look so good.
In the morning, when we wake up and see the world in white, I feel calm. Really want to treat me a freshly brewed coffee with my favourite biscuits.
We've been in this city more than ten years now, but in love with the first snow day.
These grocery service guys resolve a big problem for us during the pandemic. Since we worried about going out and bring anything back home. We tried our best to stay home and call those delivery services. Lucky that we are located in the central area, almost every delivery service is available.
I tried several providers, now I only keep three to four of them. We were impressed by their on-time delivery, good communication and easy payment methods. And most of it, the product quality has remained.
When people asked me how I supported the small business during the difficult times, I would always mention these grocery delivery guys and their contribution to the local communities.
