Monday, December 14, 2009

Online CRM stuff

In doing research for solutions for the alumni database project that I`m working on, I came across some interesting web solutions.

HighriseHQ and Network Hippo are some really interesting CRM applications. I tried out HighriseHQ and really liked it. I haven`t tried network hippo yet, but that`s on my list of things to do this week.

Stuff like this inspires me to learn more about web technologies. I wish I knew enough to setup up concepts like these quickly to make a pitch to potential partners and investors for new web technology ideas.

Some interesting ideas

I keep having these great ideas and get excited about implementing them, but I keep finding that other people had those same ideas earlier and already put a solution in place.

While I was interviewing with Torstar Digital, I came up with some ideas for improving Workopolis.com, one of their web properties. I thought that there must be a way to have enhanced resumes couple with some sort of generic online system for employee reviews. That way the system could rate people based on their performance as rated by their bosses. It would give additional information on top of the simple resume to help recruiters choose candidates to interview. I figured the same system could be used abroad in other countries so that skilled immigrants to Canada would have a rating to point to that would be familiar to employers here in Canada.

I also had that in mind when I was putting together my online resume. These days, recruiters get hundreds of resumes when they post a job. Sifting through them to find good candidates to interview is a time consuming and expensive job. The one-page resume formated isn`t enough anymore...you need something else to show recruiters. My online resume shows more detail in a way that`s easy for people to access and review. It also helps in trying to arrange info meetings.

I was looking into trying to develop a site where people could make similar online resumes easily and open the system up for recruiters to search through. A kind of giant resume book. I also thought of adding a performance review feature based on the U of Waterloo co-op evaluation form.

I started talking to people about these ideas and found out about two sites: whyhire.me and rypple.com. Apparently, these people had similar ideas put them into motion. What I had in mind was a little different (and in my mind better...for obvious reasons) from their solutions, but they already have something built.

I`m thinking about putting together a proposal for the Queen`s business career centre about implementing the solution for their grads with some other added features.

Back in Kingston

About a month ago, I was on my way to Ottawa for an info meeting with an engineering company. I made plans to stop in Kingston along the way and arranged another meeting with a company in town. The traffic on the drive was a lot lighter than I expected and I got into Kingston a couple of hours early, so I decided to stop by the business school and say hi to the MBA staff.

I ran into my old team facilitator from the MBA program and we decided to go out for lunch. I turned out that there were some changes that happened in the career centre and he became the director there over the summer. He was telling me about some of the challenges that he was facing. One of them was that the Queen's alumni weren't being utilized well enough in placing graduating business students in jobs. He wanted a database developed that would help in engaging alumni and help his department prospect jobs for students. He asked me how my job search was going and then asked me if I was interested in running with the project since he didn't have anyone available to make it happen. So we ended lunch with a verbal agreement on a 3-month consulting arrangement to get this database off the ground and I agreed to start 4 days later on Nov 23.

The info meeting in Ottawa fell through and nothing came of the other info meeting I had set up in Kingston so I left town earlier than expected to head home to pack a bag with some work clothes.

I've been working on defining the requirements of the project over the last 4 weeks...interviewing staff and asking them how they use alumni data and how they store it. It's a similar type of information flow and data problem to the one that I was tackling with my big business idea. People use data in a business process but keep track of data differently. You can gain efficiencies and better performance through a combination of behavioural changes and application of some technology. In the case of the business career centre, the goal is to place a higher percentage of students in jobs in a shorter time period. The final product will either be an adoption of an existing CRM database or a custom built system specific to the needs of the career centre. I'm leaning towards recommending a custom solution but there are other financial and time factors to consider. The new system should be up and running by mid-feb barring any issues.

It's an interesting place to be...My previous interaction with the career centre staff was as a student. Now I'm working with them in their office. The first week was a little surreal but I'm starting to get used to it now. I have to say that I like this type of consulting gig. I set my own hours and don't really have a boss. I just invoice my time and show results. I just have to find some longer term arrangements so I can finally stop living like a student and get to feel like a pro again.