Hi, Robert:
Interesting you should mention your concept of "...assign them projects" as a method of training programmers. I discussed in an earlier reply to Neil that I had employed the services of Jon Sisk some time back, to train a "PICK newbie" here at KTP. Jon and I kicked around a few options, the first of which was for me to send my guy to California. It was Jon's suggestion, though, that we do a SKYP, one-on-one, and use an actual "project" that I would find useful to have out of the way. I could eliminate any travel costs, and have the new guy here for other emergencies.
It happened that we had been wanting to merge a series of files' names-and-addresses together, into a "common" mailing address. Over many years, we had gathered such information from Special Orders, Holds, POS Transactions, Used/New Firearms and Archery serial number files, etc. It was this application that Jon used to begin my new hire's PICK programming career. He is still here, almost 11 years after the training. And, today, that contains file contains over 402,000 customers for us to tap into for receiving our flyers and post cards.
We didn't waste time using the newly-merged mailing file, which not only included demographics, but told us, as well, what type of merchandise (Classes) the customer had spent their money on. Consequently, as special promotions come about for fishing products, camping or hunting gear, archery equipment, or clothing/boots/shoes specials (by men, women, and children categories, we now have a huge list to start with to concentrate advertising. Not only by region (zip codes), but by actual customer mailing addresses.
I can't even begin to estimate ROI from having Jon's superior knowledge put to use for training, using a pre-existing need for application.
Jim Cronin
Director, Management Information Services
Kittery, Maine