LEVERAGING DATABASES

Rahul → Shalaka

21/09/08

How to leverage?

▶ RSS Feed of Job Advts from Naukri

▶ Daily arrival of “unsolicited” text resumes (caveat = 150/day) being processed by Tushar (Cumu = approx. 31,000)

---

Tushar is “rating” then storing these resumes NON-IT Function wise (40+). You said these add up to 31,000+ by now.

These are the ones which we are going to display in

“Resume Search – Textwise”

being developed by Shubhangi.

These will keep growing thru

▶ further daily arrival (contact@3pjobs.com)

▶ online “Submit Resume – Plain Text” (when ready)

---

Hopefully, soon, Shalaka will succeed in creating RSS feeds for job advts from Naukri.

One RSS feed for each of Naukri’s "Job Categories"

(some 43 categories in all)

---

We will parse each advt into 20/25 “fields”,

create a structured database & store. “Job Advt posting date” capture is important.

Now, not all 43 RSS (job-categories) of Naukri pertain to “Functions”.

Some are purely “Industry”!

Our so-called “function-names” suffer from the same malady! Some are not “functions” at all. They denote “Industry-Names”

But Naukri had such huge lead over us

that we had little choice – except to adopt their

“Terminology / Naming–Convention”,

which had become an INDUSTRY STANDARD!

---

In any case, in enclosed ANNEX: A,

I have tried to “MAP”

Naukri Job Categories ↔ Our “Functions”

This will enable us to store most of Naukri’s job-adverts (downloaded daily thru RSS feed),

against our FUNCTION-NAMES

Which means we will have:

▶ Job Advts – for (say) “Sales/Marketing” – (from Naukri)

▶ Text Resumes – “ ” – (from Tushar)

Which means, we can alert,

• "Sales/Mktg" Corporates with matching Resumes

• "" "" Jobseekers "" Job Advts

Hoping that such (weekly?) alerts will bring them to our website — and register.

Idea is to use:

• Job Advts as “magnets” to entice jobseekers

• Resumes "" "" advertisers

Of course,

• Recipient Jobseekers must feel that the “job-advt alerts” are matching / relevant,
  (– thereby eliminating need for ONLINE job searches on umpteen websites — simplifying life)

• Recipient Advertisers too must get a feeling that the resumes that he gets to see squarely meet his “advertised” needs,
  and from now onwards, he has no need to conduct Resume Searches on umpteen job-portals.

I suggest we generate such (weekly?) alerts as follows (you may have better ideas!):

---

Let us say, Friday midnight, we have in our online database:

• 400 “Sales/Mktg” job-adverts (downloaded during preceding week — thru RSS)
  and

• 2900 “Sales/Mktg” resumes (plain text)

Obviously we cannot send (full text or even a tabulated SUMMARY) of:

• 2900 resumes to 400 advertisers
  OR

• 400 advts to 2900 jobseekers

Our server may crash!

Again, if the corporates receive resumes in their mailboxes

and

jobseekers receive the advts in their mailboxes,

then why should they visit IndiaRecruiter?

That would defeat our purpose!

My suggestion is as follows:

▶ To 400 corporate job advertisers, we send the following email (we have got their email IDs from job advt):

Dear Madam / Sir

DO NOT OPEN YOUR MAILBOX!

On one of the job-portals, you recently advertised for

▶ Position: [______________]

▶ Job Category: [ Sales / Marketing ]

Given your company’s high reputation, there is no doubt hundreds of jobseekers will “APPLY ONLINE”, flooding your mailbox.

After spending many hours reading those resumes, you will reach a conclusion that only 25 resumes (out of several hundred you read), were “relevant / worth considering for an interview”.

Suffering this pain is entirely unnecessary

if you click

Sales / Marketing / ResumeSearch–Textwise

There, you will find [ 2900 ] resumes belonging to this FUNCTION.

But, you will need to read only the TOP 25. Then send “Interview Call Emails” online/instantly.

Our “Resume Rater” Software has already “read / rated / ranked” those [ 2900 ] resumes and arranged these in the “DESCENDING ORDER” of relevance, with the best at the top!

There is no need to read all.

There is no need to open your mailbox!

with regards

– Shalaka  

shalaka@recruitguru.com  

Ph: 91–22–670,70,372

To read resumes, a corporate will have to register.  

Once he discovers “ResumeSearch–Textwise”, he may visit on his own, without waiting to receive our Email Alert.

Next comes the question of sending “Job Alerts” to those 2900 “Sales/Marketing” jobseekers.

They have all been “rated/ranked” on “Sales/Marketing” keywords, assigned “RAW SCORES” and arranged in descending order.

Now, as long as their text resumes don’t change, their RAW SCORES remain same.

Of course, as more text resumes continue to get added into

“Resume Search – Textwise” database,

their relative positions may change (up/down).

But what is the point of sending a job alert to a jobseeker, whose resume has scored

5 or 7 or 11

on “Sales/Marketing”, and got a ranked position of

2237 out of 2900?

Obviously, he is NOT SUITABLE candidate for that function!

Therefore, we should restrict our job-alerts to only the TOP 10% of the candidates listed under each FUNCTION.

Again, there will be no point in sending to each of those TOP 10% (in our assumed case, 290 out of 2900), all the 400 job-adverts – even as a SUMMARY TABULATION.

Maybe we could do the following:

Modify our “Resume Courier” page as follows:

---

Resume Courier Service

Copy/Paste below email IDs from Job-Adverts	Job-Adverts posted on various portals during last week (Function wise)
Mail ID 1	Accounts / Finance / Audit
Mail ID 2	Front office / Secretarial
Mail ID 3	After Sales Service

⬇️ [Send Mail]

---

Our (weekly) email to those 290 “Sales/Mktg” (TOP 10%) jobseekers will read:

Dear [   ] ← Actual Name

STOP JOB SEARCHING!

If you belong to function  

   [ Sales / Marketing ]  

You will find [ 400 ] Sales/Marketing jobs  

recently advertised on leading job-portals,  

during last week, aggregated /  

compiled on our website, at  

Resume Courier  

Instead of spending endless hours on all  

those jobsites, simply use our FREE  

“Resume Courier”  

to send your resume to all those advertisers  

in one single step. Then come back next week  

for looking-up and applying against latest  

weekly compilation.  

With regards  

– Shalaka

S.No	Naukri Job-Category	Our Serial No	IndiaRecruiters Equivalent Function (Resume Search – Textwise)
1	Accounts, Finance	1	Accts / Finance / Audit
2	Architect, Interior Design	5	Civil / Architecture / Int. Design
3	Automobile
4	Banking, Financial Services	7	Banking / Insurance
5	BPO, KPO	12
6	Construction, Engineering	31	Site Engg / Project Mgmt
7	Consultants
8	Content, Journalism
9	Corp. Planning, Consulting	9	Business Development
10	Engineering Design, R&D	17 / 32	Engineering / R&D / Engineering Design
11	Export, Import	18	Import / Export / Int. Trading
12	Fashion, Garments
13	Fresher, Trainee Job
14	Healthcare, Medical, R&D	41	Medical / Healthcare
15	Hotels, Restaurants	40	Hotels / Restaurants
16	HR, Admin	21	HR / Admin
17	IT-Hardware, Telecom
18	Industrial Products
19	Insurance	7	Banking / Insurance (Same as S.No 4)
20	IT Software Services
21	Legal	10	Legal / Law
22	Manufacturing	26	Operations Mgmt
23	Marketing, Advertising	11 / 24	Advertising / Media / PR, E-Marketing
24	Media, Entertainment
25	NGO, Govt., Defence Jobs
26	Oil, Energy, Power
27	Overseas, Internationals
28	Packaging
29	Pharma, Biotech	25	Biotech / Pharma
30	Purchase, Supply Chain	16 / 32	Supply Chain / Logistics, Purchase / Vendor Devlp / Inv

S.No	Naukri Job-Category	Our Serial No	IndiaRecruiters Equivalent Function (Resume Search – Textwise)
31	Retail	24	Sales / Marketing
32	Sales, BD	24	Sales / Marketing
33	Secretary, Front Office	34	Front Office / Sec. Services
34	Site Engineering	31	Site Engg / Project Mgmt
35	Teaching, Education	35	Education / Teaching / Training
36	Telecom	37	Telecom / ISP
37	Top Management–IT		General Mgmt / Strategy
38	Top Management–Non-IT	20	General Mgmt / Strategy
39	Travel, Airlines
40	TV, Films	38	Arts / Entertainment / TV
41	Walk-In Interviews
42	Web, Graphic Design
43	Others