Friday, August 20, 2010

Dunn & Bradstreet's Million Dollar Database

This post was written by Michael Casey. He is one of the folks working with NFJS and a salesman with a terrific track record who has committed to moving into a role that allows him to drive resource sustainability within a company.Note that the rest of this blog would look a lot better if Blogspot supported imbeded tables or allowed me to simply attach a document, etc. but it doesn't. I'm going to try to be as clear as I can without them. If you follow carefully, it will work. When you go to D&B/KCLS you will find it much more user friendly.

From Michael:
Assuming that you have decided to develop a “value proposition” based job search, one of the first steps is identifying potential employers. What companies look like good potential employers?

If you allow yourself to approach this in a disorganized way, it is pretty darn intimidating. One tool that can greatly reduce this is the Dunn & Bradstreet Million Dollar Database. Normally access to this is very expensive, fortunately there are some very convenient ways to avoid the expense. If you are local to the Seattle area, the King County Library (www.kcls.org) provides this as one of their normal services. My assumption is that in other areas, the first place to check is your local library as well. The following description assumes you have a King County Library Card then becomes a “how to” for accessing via the King County Library. Most of this is how to use the DB.

• Go to www.kcls.org

• Click on "DataBases" (top of page, left side)

• Go to "Subject List of Databases" scroll down to

• Click on "Business Economics and Investing"  (Note that under this tab, you will see more than a dozen options which may be helpful to you. This is a very comprehensive list of the best tools available for researching companies, so explore!)

• Click on "D & B Million Dollar Database"

Congratulations! You are in.....now go get a cup of coffee or a beer, walk outside and get some fresh air, then return to your JOB SEARCH.

 

We are going to look for some companies that might help someone who is a CAD designer with considerable talent, and look for metal fabrication companies, who have clients that design and then send their product to be fabricated--they obviously have or need to have CAD people designing their stuff.

____________________________________________________

• Find a company, then put it in the fields and search.
• We will choose a company we know, entering Name, City & State


Company Name:    Magic Metals
City:                       Union Gap
State:                     Washington


This is what is returned:

Magic Metals Inc

SIC Code:       7692
City:                Union Gap
State:              WA USA
Locations:       Single Location
Annual Sales:  $11,887,260
Number Emp   146

We see that the SIC code is 7692....but we want more information, so click on the "Magic Metals Inc".  What comes back is more than a page of information specific to Magic Metals including what their DUNS Number is, what they do, who the President is, how many locations, etc. 

Now look at their SIC codes, they are listed as 7692 welding repair but also 3440 sheet metal work.

“Sheet Metal Work” is also known as “Metal Fabrication” so we have found the SIC code we will use in the next step.

Now we want to go and look for other companies with the 3440 SIC code, because that may lead us to companies that are similar and these are companies we know will use CAD drafting.

Go back to the top of the page, yellow box, and click on SIC and then type in 3444, then eliminate the city, or keep it local, then put your state name in and hit search...:  and we come up with !!!!!! 254 companies.  Too many for practical reasons, so let's limit the search and just put a city back in, like Seattle Wa for the search, see what we come up with---i.e., re-enter SIC code 3444, Seattle for city, Washington for state, then hit search and voila; 34 companies, much more manageable.


1: Lighthouse For The Blind Inc
8331 Seattle WA USA Headquarters $37,597,000 350

2: Ellstrom Manufacturing Inc
2431 Seattle WA USA Single Location $11,500,000 85

3: Pioneer Human Services
8331 Seattle WA USA Branch $9,487,600 200

4: Qual Fab Inc
3444 Seattle WA USA Single Location $6,600,000 45

5: Pacific Aircraft Welders
3581 Seattle WA USA Single Location $5,000,000 10

6: Queen City Sheet Metal
1761 Seattle WA USA Single Location $4,345,596 25

7: David Gulassa & Co Inc
2514 Seattle WA USA Single Location $3,200,000 26

8: Ballard Sheet Metal Works Inc
3444 Seattle WA USA Single Location $3,000,000 20

9: Pacific Sheet Metal Inc
1761 Seattle WA USA Single Location $2,900,000 20

10: Park North Heating Co Inc
1711 Seattle WA USA Single Location $2,200,000 16

11: Global Inc
3443 Seattle WA USA Single Location $2,000,000 15

12: Central Fabricators Inc
5051 Seattle WA USA Single Location $900,000 10

13: Williams Form Engineering Corp
3444 Seattle WA USA Branch $737,508 6

14: All Metals Fabricators Inc
1791 Seattle WA USA Single Location $730,000 6

15: Precision Fabricators LLC
3444 Seattle WA USA Headquarters $625,000 8

16: B & D Sheet Metal LLC
3444 Seattle WA USA Single Location $610,000 6

17: Decorative Metal Arts
3444 Seattle WA USA Single Location $570,000 8

18: Apex Metal Fabricators Inc
3444 Seattle WA USA Single Location $550,000 5

19: Canopy World Inc
3444 Seattle WA USA Branch $491,672 4

20: Mutual Industries Inc
3444 Seattle WA USA Single Location $480,000 5

21: North Industries Inc
3444 Seattle WA USA Single Location $410,000 3

22: A Quality Sheet Metal Co
3444 Seattle WA USA Single Location $270,000 4

23: Whitehead Manufacturing
3444 Seattle WA USA Single Location $250,000 3

24: Form Factor Inc
3444 Seattle WA USA Single Location $210,000 2

25: Kenneth A Edleman
3444 Seattle WA USA Single Location $200,000 2

26: Pacific Northwest
3444 Seattle WA USA Single Location $160,000 2

27: J R Grantham Inc
3444 Seattle WA USA Single Location $140,000 1

28: DK Works
3444 Seattle WA USA Single Location $130,000 2

29: Dockside Repair
3449 Seattle WA USA Single Location $100,000 18

30: McKinstry Co LLC
1711 Seattle WA USA Headquarters 500

Choosing one, say #4, Qual Fab Inc., click on that and once again, we have tons of information:  Location, Sales, CEO, start date, etc.

This tool works for any industry and location. in addition, Dunn & Bradstreet is the tool companies use to check out each other, so it is the most up-to-date available (although it can be as much as six months out of date). It will normally provide the name of at least one senior executive; probably the CEO.  What you end up with is the address of the company, the name of a senior exec, a clear idea of what the company makes, etc. This is a great start.

No comments:

Post a Comment