Neo's profileNeo TalksBlogLists Tools Help

Neo Talks

Neo and His Matrix
August 15

New Book and Blogspot

Just write to report recent progress.

  • I can fully get used to five workdays a week and even enjoy it. My project in GE runs pretty good. I think I want to finish it before I leave here.
  • Recently I started to read the novel: Da Vinci Code. It is so attractive that I can live without it! I don’t like novels generally. But I do read those bestsellers.
  • Blogspot is accessible now in China. Love its new beta version, faster and smarter. Hope it keeps going. I have already set a new mirror there. Live Space and here will also be updated.
August 13

Make Your Mark: Kick it Out

It's a different summer, in which I entered my favorite company to work. One month has passed. And I know it's only a start.

For someone, it might not be a good choice to work for companies like GE, though it's big and well-known. But from the perspective of salary, GE could be far behind from others, especially those investment banks and consulting firms. And what's more, finance staff inside a company is totally different from outsiders, as Faye, the FMP intern recruiting HR pointed out during my interview. The job is extremely detail-oriented and even mechanic. Instead of creating profit in the frontier directly, like bankers or traders, finance people in industry act more as supporting team to maintain daily operation of business. The role is totally reversed.
Neither rewarding nor dominant, corporate finance in industry is more or less the second or third place for superior job hunters. For some top ones, it's only a backup.

I have experienced the application for investment banks. Fairly speaking, they are really tough. and I was not ready to join them. In the few interviews I attended, my performance was not right at all. Some kind of strong arbitrageur attitude was deep in my mind. With little persuasive reason to meet the challenge from the interviewer: "Why do you want to join us?" I lost the game just at the startline.

Fortunately, I was right when answering GE's question. For the question "why do you want to do finance job?", I was like "I don't know, but I'll find out. Please let me try."

I kicked it out just one day after my last final exam. It was June 23rd 2006 Friday, only one week to Q2 closing deadline. Everyone was busy. They worked for every second, till very late. For me, it's exciting thing to work in that context. I like being busy. It makes me feel respected.
August 03

Spreadsheet and Database

80% of the world business run on Excel. At least true for me.
After years of developments, Excel has grown from one of minor opponents of Lotus 1-2-3 to the most popular business software in the world. Being challenged by online spreadsheet suites, the omnipotent software is absorbing more functionality into its backstage, aiming to provide more complex features for business data users.
As a common Excel user, who only takes advantage of limited set of Excel power, I started to use it as a temporary substitute to Word, to make a curriculum table for new semester. The greatest finding was that Excel can generate arrays like Monday, Tuesday, ..., Sunday through simple drag and drop. But I was confused that why Microsoft made such a big thing only to make tables: Word can do that, and maybe even better.
If you only use it occasionally like I used to, building small datasets and performing little calculation and analysis work, you will never experience the true nature of a spreadsheet. Firstly, it's visual. What you see is what you get. People don't have to run any reports to see what's going on inside the box. Secondly, it's lightweight. My computer at work is a Dell laptop with 512M RAM running Windows 2000. The CPU could be Pentium III, loading Windows in more than 10 minutes every time. But Excel runs just as fast as Freecell (which could be another good name for spreadsheet application). It loads a 500K file in 5 seconds and executes almost all calculation in no time. Such a lightweight application can hold thousands of hundreds of data, up to 256 worksheets at the same time. And there is even a built-in script language (though it's not so visual as how it's named). It's amazing, isn't it? Thirdly, it's extensible. This is a relatively high-end feature. The VBA framework behind the scene provides Excel good extensibility to all types of applications, even in the future. You can export and import data to and from Excel easily. This, along with Microsoft's market share, makes Excel the in-fact data center of the world business.

I use Oracle 11 at work. What should I say? It's big, ugly and slow. With Java as its interface language, the application runs at an incredibly low speed. I thought it might be safer. I was wrong. It's full of errors, reasons not clear. The buggy, sluggish stuff cannot even export data in a considerably flexible way. People have to query manually and copy/paste one by one...

What people invent database for? It should be the center of data collection, storage, processing, analysis and reporting. Built on the steady base of network, database guarantees the security and proper accessibility of data. In my case, Oracle does this job well, although at the cost of performance. However, Oracle cannot do analysis. Users have to export the data to specific analytical software (for most cases, Excel). Unfortunately, the export format is not XLS but plain text.
Excel expert wrote a macro to convert the plain text report into XLS format, which saves some time for analysts. Another tragedy happens here: the macro poorly designed, users have to check the converted report manually.
If we all do it manually, why should we invest money on IT?

Spreadsheet should be also database, or database should take a well-designed spreadsheet UI. That's what we expect, but might also be the beginning of mass unemployment of so-called analysts.
 

Neo

by