Skill set database
Author
Discussion

bluesatin

Original Poster:

3,115 posts

295 months

Tuesday 17th January 2006
quotequote all
Can anybody point me in the direction of any skill set databases that may be available and/or anybody who has developed one. What we are trying to achieve is to map the intellectual property within the company so that we can develop skills and more importantly react to change/opportunity quickly. We have found on numerous occasions that people have acquired skills over time that they may no be using in their current job but would be useful to specific projects!

Finally it would need to be self regulated and most probably populated from new hire forms.

Thanks

Don

28,378 posts

307 months

Tuesday 17th January 2006
quotequote all
Guy,

We don't have the specific features you want - but do have a web-based "personnel" style application to which such a database could be added...

If you don't find a specific product to help you 'mail me. I'm afraid we're not necessarily cheap so if you find something off the shelf that does just what you want go for it.

On the other hand our stuff covers a lot of personnel functions and a Skills database would be complementary so if you get stuck we could talk about a deal...

Good luck.

jeremyc

27,106 posts

307 months

Tuesday 17th January 2006
quotequote all
What you need to do is find someone in the company that has the necessary skill sets to build such a database application ......


Oh, hold on. I see your problem.

Don

28,378 posts

307 months

Tuesday 17th January 2006
quotequote all
jeremyc said:
What you need to do is find someone in the company that has the necessary skill sets to build such a database application ......

Oh, hold on. I see your problem.


Don

28,378 posts

307 months

Tuesday 17th January 2006
quotequote all
bluesatin said:
probably populated from new hire forms.


Could even do an on-line new-hire form - bang the details across if you hire 'em.

victormeldrew

8,293 posts

300 months

Tuesday 17th January 2006
quotequote all
I developed a skills database for an Aerospace company to track capabilities. I am about to rewrite that in asp.net, as it relied on some third party middleware to connect web pages to the back-end database. It was also linked to a basic T&A module which allowed some basic forward planning, allowing managers to see a/ where the workforce were deficient in skills for particular products and b/ where key skills absence due to sickness and holidays caused transient skills shortages.

If your interested I'd be happy to discuss inclusion of any specific requirements you have in my rewrite.

Don

28,378 posts

307 months

Tuesday 17th January 2006
quotequote all
victormeldrew said:
as it relied on some third party middleware to connect web pages to the back-end database



[THREADHIJACK]
How interesting! We use middleware to connect web-pages to the back-end database - but we wrote it ourselves...we've re-written the app to use standard Microsoft stuff....! Oh..there's still some of our "magic" in there but no need for Java/ActiveX/.NET applets or anything....

Our stuff also does T&A, Timesheets etc etc etc
[/THREADHIJACK]

bluesatin

Original Poster:

3,115 posts

295 months

Tuesday 17th January 2006
quotequote all
All sounds interesting-please send more.

No budget at the moment but as usual this can be liberated when needed.

Guy

tobeee

1,436 posts

291 months

Tuesday 17th January 2006
quotequote all
Good idea! I suggested this to the company I work for about a year ago, and they've finally started to develop something. Unfortunately I won't be able to see the code so am not really much use to you. Sorry!

Plotloss

67,280 posts

293 months

Tuesday 17th January 2006
quotequote all
Peoplesoft may have something, thats probably a sledgehammer to crack a nut mind you, worth having a conversation with though as they may know of something in their space thats a little smaller and more suited.

Wouldnt be too pricey to get a bespoke system I wouldnt have thought, depending on the complexities of the interactions required between records.

Red V8

873 posts

250 months

Tuesday 17th January 2006
quotequote all
Have you thought about using a simple contact management product?

But instead of tracking customers, track employees. Then you can specify skills as contact records and group together etc... something like Goldmine or ACT will only cost you about £100.

bluesatin

Original Poster:

3,115 posts

295 months

Tuesday 17th January 2006
quotequote all
Cost is not an issue and we a fully siebeled up on the contact mangement front. What we need is a simple to use simple to implement system that will provide a solution. The company emply 4,000 people but what percentage of them we may need to track we don't know!

Don

28,378 posts

307 months

Wednesday 18th January 2006
quotequote all
bluesatin said:
All sounds interesting-please send more.

No budget at the moment but as usual this can be liberated when needed.

Guy


If you want to see what we do you can read a bit about us at www.aballantine.com . We are actively interested in extending the functionality of our product - whenever its complementary - which a skills database would be.

If you already have Siebel you probably already have the raw data to populate the "people" records. Now you need the means for your folks to update their own skills information. A web-based tool would be perfect for that - I'm pretty sure our app would make a decent starting point. 4000 users shouldn't be a problem - we've put in Time Recording systems for that number.

If you'd like to see the software and discuss what would need to be done to meet your needs either myself or one of my partners would be delighted to pop over. No obligation!

victormeldrew

8,293 posts

300 months

Thursday 19th January 2006
quotequote all
Don said:
victormeldrew said:
as it relied on some third party middleware to connect web pages to the back-end database



[THREADHIJACK]
How interesting! We use middleware to connect web-pages to the back-end database - but we wrote it ourselves...we've re-written the app to use standard Microsoft stuff....! Oh..there's still some of our "magic" in there but no need for Java/ActiveX/.NET applets or anything....

Our stuff also does T&A, Timesheets etc etc etc
[/THREADHIJACK]
Interesting indeed! "Middleware" is a pretty flexible term of course. In this case the middleware was functionally equivalent to something like Oracle Data Provider for .Net - the backend database the original client used is/was very niche.

I am rewriting the app (all of it, not just the Skills module, the full MRO/ERP system) to use much more mainsteam technology of the asp.net/SQL variety - standard MS stuff in other words - while still supporting the original clients' niche database. I just wish I'd put my efforts here previously instead of developing a powerful web application generator for the afore mentioned niche database/middleware, I'd have saved a good years work; hindsight is a wonderful thing!

Apologies for extending the thread hijack Guy - techies eh!

edc

9,486 posts

274 months

Friday 20th January 2006
quotequote all
I am interested in seeing/buying any skills software. I need it to be searchable for personal/physical attributes, language skills, technical skills and some sort of category for past performance and availability/contract end date. Ability to attach CV or other docs would be great. Do any of you who posted above produce such a product? I have a meeting on wednesday next week and need to put all options on the table by then!

Don

28,378 posts

307 months

Friday 20th January 2006
quotequote all
edc said:
I am interested in seeing/buying any skills software. I need it to be searchable for personal/physical attributes, language skills, technical skills and some sort of category for past performance and availability/contract end date. Ability to attach CV or other docs would be great. Do any of you who posted above produce such a product? I have a meeting on wednesday next week and need to put all options on the table by then!


Sadly we don't have an off-the-shelf product that does that. We do, of course, have an application to which such functionality could be added - it would be particularly suited, I think, to the business process bluesatin was talking about - as our app is web-based and would be very easy to make available to a large number of employees so they could update their own skills etc etc. The database would then be searchable very easily and so on. But I would be proposing to add the new functionality in and it would be a project for us to do so. The advantage is, of course, that the functionality of the new software can be matched very precisely to the business need.

The disadvantage is that building software ain't cheap and we'd be looking to put in a decent sized multi-user system to cover the development costs.

If *you* require a multi-user, employee friendly, web-based system we could look at what you require as well - very happily.

On the other hand if you're really after a desktop product for just a couple of users the economics wouldn't make sense for either of us...and, sadly, I really don't know what is out there in the marketplace in that sector.

edc

9,486 posts

274 months

Friday 20th January 2006
quotequote all
Sorry should have added that it will be server based with circa 6-8 users. Ideally, it would allow remote access. Forgive me if I am talking nonsense but I'm talking from my HR point of view and not an IT one!

victormeldrew

8,293 posts

300 months

Friday 20th January 2006
quotequote all
edc

I'm in pretty much the same place as Don, from a slightly different angle. I have a product which does most (if not all) of what you want, but it was written for a very specific target and uses a database which most people won't have heard of and won't want to get involved with. I am starting a project to commercialise this app and migrate it to industry standard platforms - Microsoft, SQL etc - but don't have anything RIGHT NOW.

3 months from now is another matter altogether, but right now I don't have anything to put on the table.

Good to see that demand exists though!

Without wishing to get too vulgar, you would be looking at high £££, possibly ££££, plus implementation/training/consultancy costs, so you'd need to decide if that cost could be justified.



>> Edited by victormeldrew on Friday 20th January 18:55

Don

28,378 posts

307 months

Friday 20th January 2006
quotequote all
victormeldrew said:

Without wishing to get too vulgar, you would be looking at high £££, possibly ££££, plus implementation/training/consultancy costs, so you'd need to decide if that cost could be justified.


edc, I can assure you that Mr VictorMeldrew here is offering some serious *value* in that regard.

I'm happy to be vulgar, though! Our target installation minimum is around £12K. We've put in systems as low as £2K and ones that run into the hundreds of thousands. For someone with whom we were "partnering" a new "module" for our product there would be a deal. 6-8 users would make us too expensive, I expect, sadly. You really want something off the shelf if you can find it - which is my best advice. If its not available then surely contact us/me if the sums involved don't put you off.

BTW VM: Where are you based? We *really* ought to have a beer and discuss the market. Even if we're in competition we might still be able to help each other...

victormeldrew

8,293 posts

300 months

Friday 20th January 2006
quotequote all
Don

That sounds like a civilised idea! I'm based in Rugby. We'll take this offline at this point I think!

For reference my original system sold for £9k, and there is an ongoing annual licence fee (20% pa) charged, so not exactly cheap. Bespoke database development isn't, as you know .