Hi Friends,

Even as I launch this today ( my 80th Birthday ), I realize that there is yet so much to say and do. There is just no time to look back, no time to wonder,"Will anyone read these pages?"

With regards,
Hemen Parekh
27 June 2013

Now as I approach my 90th birthday ( 27 June 2023 ) , I invite you to visit my Digital Avatar ( www.hemenparekh.ai ) – and continue chatting with me , even when I am no more here physically

Translate

Saturday, 29 November 2008

RSS FEEDS-JOB AGGREGATOR

scan0001.jpg

Date: 29-11-08

From/To: Shalaka $\rightarrow$ Shubhangi

  • URL: www.careerjet.co.in
  • Claims:
    • 15.8 million job advts, published on 63,331 websites.
    • Of which, 187,289 jobs are published in India.
  • Note: It provides only links to those jobsites! (Similar to Bixee — Indeed — ebharatjobs).
  • Observation: But, useful to "find" those jobsite URLs from which it must be scraping those jobs.

scan0002.jpg

Date: 29-11-08

From/To: Shalaka — Shubhangi

  • URL: www.india.recruit.net
    • Co. name is given (in job advt) but no email ID.
    • Strategy: If we find a way to "allot/assign" email IDs (from our "Corpo. Email Database") based on Company/Job-Advertiser's name, then this site could be a good source for a Job Aggregator.
  • URL: http://www.jobconsultancy.com/jobprofile.php?
    • Gives: 1) Co. Name, 2) Co. email ID.
    • Could be a good source for job aggregator. Also lots of International Job Advts of interest. (Note: No RSS).
  • URL: www.careerbuilder.co.in
    • Another website with lots of good jobs (from well-known companies), but NO email ID of Advt!
    • We must find a way to "assign/allot" email IDs. (Note: No RSS).
  • Job Aggregating Sites List:
    1. Bixee
    2. Indeed
    3. ebharatjobs
    4. www.careerjet.co.in

scan0003.jpg

Header: Shalaka

scan0004.jpg

Date: 29-11-08

Header: Shalaka

City

Job Count

Bangalore

1777

Cochin

669

Chennai

1469

Coimbatore

739

Mumbai

988

Hyd

964

Pune

836

Delhi

1145

Al'end (Ahmedabad)

671

Kolkata

693

Goa

540

Total

10,491 jobs

scan0005.jpg

Date: 13/11/08

From/To: Shalaka / Shubhangi

  1. URL: www.oneclickjob.com/default.aspx
    • Another "job aggregator" site (like Bixee).
    • Claims 104,936 jobs!
  2. Lookup: www.indiandir.com/jobs/websites.html

scan0006.jpg

Date: 10-11-08

Header: Shalaka

  1. Job RSS at: www.jobisland.com/employer
  2. Note: You may wish to read para on E-MAIL RESUMES™ at: http://www.preferredjobs.com/email_promo/bronzepromo.asp
  3. URL: http://www.brothersoft.com/job-search-pro-176156.html
    • Job Search Pro 3.0 (Cost: $24.00)
    • Comment: Seems VERY INTERESTING! If you think this will help us download hundreds of jobs from many Indian jobsites, then we should buy it.
  4. URL: http://www.brothersoft.com/jobseeker-50559.html
    • JobSeeker 2.1.1.6 (Freeware).

scan0007.jpg

Date: 27-10-08

From/To: Rahul / Shalaka

  • URL: http://chrisnavta.emyrse.com/
  • Note: His resume mentions: Harvest — Career Site Job Scraping and Distribution System.
    • "Harvest is an award-winning technology that scrapes a Company's Career site and distributes those jobs to a network of sites aimed at — — — — —."
  • Instruction: Please ask his "contact" info from the Contact tab. If we succeed, ask him to visit IndiaRecruiter and a brief account of our efforts.

scan0008.jpg

Date: 27-10-08

From/To: Rahul $\rightarrow$ Shalaka

  • URL: http://www.scriptlance.com/projects/1221694420.shtml
  • Description of ScriptGeni (JobGeni):
    • JobGeni is a Fully Automated Job Aggregator Search Engine written in PHP/Ajax Script, utilizing Ajax Google Feed API.
    • Collects multiple data feeds from major job boards (Indeed.com, SimplyHired.com, MonsterBoard.com, Yahoo Hot Jobs, Jobster.com, etc.).
    • Features: Auto-filled with thousands of jobs instantly; no big databases; no nightly spidering jobs (searches in real-time through RSS feeds).

scan0009.jpg

Date: 27-10-08

From/To: Rahul $\rightarrow$ Shalaka $\rightarrow$ Alex

scan0010.jpg

Date: 27-10-08

Header: Shalaka

  • Google Search: [Job Advt + RSS feed] $\rightarrow$ 275,000 results (India Pages).
  • URL: Locanto.in
    • A free classifieds website with RSS feed, but job advts are very CRYPTIC (one/two lines). Not much help.
  • URL: http://www.clickjobs.com/feeds/
    • 30/40 function-industrywise feeds (RSS-XML-JS) almost like Naukri. This is a MAJOR jobsite.
  • URL: http://www.indeed.co.in/intl/en/faq.html
    • Indeed also "aggregates" job advts from many websites (like https://www.google.com/search?q=Bixee.com) and provides RSS feeds. Worth examining.
  • URL: http://www.freshershome.com/jobs
    • Offers: "Get Jobs by E-mail" and "Hot RSS Feeds."

 

scan0011.jpg

Title: RSS Feeds

[Bottom Section in Green Ink]

  • http://faayda.com/ $\rightarrow$ 1,64,570 jobs
    • "Job search made simple. Looking for a job shouldn't be a full-time job! That is why we built the smartest job-search engine on the web. We search thousands of jobsites and companies, just so you don't have to."
  • Another: Indeed, Bixee.

scan0012.jpg

scan0013.jpg

Name: Shalaka | Date: 25/10/08

  1. http://itthebest.com/emailalerts.php
    • If you register, you will get email alerts for jobs getting posted.
  2. http://www.teleportjobs.com
    • Has [XML] [RSS] feed.
  3. www.simplyitjob.com
  4. https://www.google.com/search?q=Jobmixi.com — "links to 200,102 new jobs across India"

scan0014.jpg

Name: Shalaka | Date: 27/10/08

  • http://www.bixee.com/help/bixeebot
    • Makes very useful reading! Especially "How to submit your site for Bixee indexing".
    • Many jobsites maybe getting tempted to submit their sites to Bixeebot, since they would know that, when a jobseeker clicks on any of "their" job adverts on Bixee, he would be taken to the webpage of original site! So, nothing is lost—and everything gained!
    • Bixee acts as a common door (portal)—that's all!

scan0015.jpg

From: Rahul $\rightarrow$ Shalaka | Date: 28/09/08 | Page: 1

Subject: Job Aggregator (Jobsearch: One Stop)

The 3 main jobsites from where we will download job-advts (and create a structured database) are:

  • Naukri
  • TimesJobs
  • MonsterIndia

The job advertisers corporate profile is like:

You will notice:

  • There are very few unique jobs.
  • There is a lot of overlap between the three.

Most Corporates advertise on:

  • Naukri + Monster
  • OR Naukri + TimesJobs
  • OR Naukri + Monster + TimesJobs

scan0016.jpg

[Rahul $\rightarrow$ Shalaka] | Page: 2

Same holds true of Recruitment Agencies.

Again, within each corporate HR dept or a Recruit Agency, it is the SAME executive/consultant/recruiter who "posts" the Ad on:

  • all 3, or
  • 2, or
  • 1 (i.e., Naukri).

Therefore, his/her email ID remains SAME, company or Recruitment Agency remains SAME (as long as Advt. is SAME).

Now,

Naukri gives email IDs for nearly ALL advts. So, we can use the same email ID for any job-advts posted by same company on Monster/TimesJobs.

We have to simply MAP:

Company Name $\xleftrightarrow{with}$ Email ID (appearing on Naukri)

Then we don't need to worry that Monster & TimesJobs Advts do NOT carry email IDs.

scan0017.jpg

[Rahul $\rightarrow$ Shalaka] | Page: 3

So let us resolve to download job-advts from Monster & TimesJobs as well, to add to our database.

Another IMPORTANT thing:

In Shubhangi's "Resume Search - Textwise", in the tabular display, we have a column "No. of times Resume Viewed". We hope this will prompt/motivate corporate recruiters to "open" those resumes which got viewed "more no. of times".

But the display-order still remains: "Descending Order of Raw Scores".

For Job-Advts display (in Job Aggregator), my suggestions is as follows:

Let us:

  • Introduce a column "No. of Candidates Applied" (against each Advt).
  • Arrange tabular display in descending order of the "No. of Candidates Applied".

scan0018.jpg

[Rahul $\rightarrow$ Shalaka] | Page: 4

It is safe to assume that a great majority of candidates will apply against:

  • Popular Companies, OR
  • Popular job-positions/vacancies, OR
  • Popular "posting cities"

And, therefore, such job-advts will tend to rise to the top—in turn, motivating a still larger no. of candidates to apply against the same—setting in motion a VIRTUOUS CIRCLE (Self-fulfilling prophecy).

Someday, these figures may even enable us to "RANK" (and arrange in descending order):

  • Popular Companies
  • Popular jobs
  • Popular cities

scan0019.jpg

From: Rahul $\rightarrow$ Shalaka | Date: 25/09/08 | Page: 1

Subject: Job Aggregation

  • On MonsterIndia, there is a link called "Get jobs in your Inbox".
    • Could this help? Even if it does, Monster job-advts do not show email ID!—May not help. And I don't see any RSS feed link.
  • Timesjobs.com $\rightarrow$ Site Map $\rightarrow$ My Jobs / My Alerts
    • Worth investigating. But, once again, Timesjobs does NOT give email ID in job advt—so, may not help.

EXCEPT:

Every job advt of Timesjobs shows:

  • Company Name
  • Industry

All that we have to do is to MAP:

Timesjob Industry A = IndiaRecruiter Industry B

scan0020.jpg

[Rahul $\rightarrow$ Shalaka] | Page: 2

  • Naukriguru
    • Almost always provides email ID.
    • Also has a feature/link $\rightarrow$ "Email me jobs".
  • Goldenjobs.com
    • Almost always provides email ID—but seems very few new job postings—mostly OLD jobs.
    • Can be considered for extracting Company Name and Email IDs.
    • Question: FREE signup for Employer = FREE Resume Search?
  • https://www.google.com/search?q=Bharatcareers.com
    • Free registration for employers for resume-search and job search.
    • Look-up FAQs—it says: "Employers who are fully registered will receive the information of resumes posted thru email".

 

scan0021.jpg

IndiasJobs.com

  • See item #13 of FAQ
  • also shows "No. of times resume viewed" in "https://www.google.com/search?q=MyIndiasJobs.com" section
  • All job-advts carry email ID — except it is not clickable (but, I suppose, we can harvest!)
  • has provision to "Get the latest jobs in your inbox" (Jobseekers Login).

scan0022.jpg (Page 1)

Rahul -> Shalaka — 21/09/08

How to leverage?

  • RSS Feed of Job Advts from Naukri
  • Daily arrival of "unsolicited" text resumes (ave = 150/day) being processed by Tushar (cumu = approx. 31000)

Tushar is "rating" — then storing these resumes "NON-IT Function wise (40+). You said, these add up to 31000+ by now.

These are the ones which we are going to display in "Resume Search — Text wise" 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)

scan0023.jpg (Page 2)

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 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 $\approx$ Our "Functions"

This will enable us to store, most of Naukri's job-advts (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)

scan0024.jpg (Page 3)

Which means, we can alert,

  • "Sales/Mktg" Corporates with matching Resumes
  • " " " Jobseekers with matching Job Advts,

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

Idea is to use

  • Job Advts as "magnates" to entice jobseekers
  • Resumes as "magnates" to entice advertisers.

Of course,

  • Recipient Jobseekers must feel that the "job-advts 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!):

scan0025.jpg (Page 4)

Let us say, Friday midnight, we have in our online databases

  • 400 "Sales/Mktg" job-advts (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 IndraRecruiter?

scan0026.jpg (Page 5)

That would defeat our purpose!

My suggestion is as follows:

To 400 Corporate job advertisers, we send 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.

scan0027.jpg (Page 6)

if you click

Sales / Marketing / Resume Search — Text wise

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 "Resume Search — Text wise", he may visit on his own, without waiting to receive our Email Alert.

scan0028.jpg (Page 7)

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 dont 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 rank 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.

scan0029.jpg (Page 8)

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-advts — 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 Advts. | Job Advts Posted on various portals during last week (Function wise) |

| :--- | :--- |

| Mail ID 1 _________ | Accounts / Finance / Audit |

| " 2 _________ | Front office / secretarial |

| " 3 _________ | After sales service |

[ Send Mail ]

Highlights of Job Advts

| SN | Company Name | Position | City | E-Mail ID |

| :--- | :--- | :--- | :--- | :--- |

| | Voltas | Material Manager (clicking will show full advt) | | [ Copy / Paste ] Not clickable |

scan0030.jpg (Page 9)

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, 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

[Signature] 21/09/08

 

scan0031.jpg

Title: Naukri Job-Category Mapping (Annexure A)

S.No

Naukri Job-Category

Our Serial No

India Recruiter's Equivalent "Function"

1

Accounts, Finance

1

Accts / Finance / Audit

2

Architect, Interior Design

5

Civil / Architecture / Int. Design

3

Automobiles

4

Banking, Financial Services

7

Banking / Insurance

5

BPO, KPO

6

Construction, Engineering

12, 31

Construction Mgmt / Site Eng / Project Mgmt

7

Consultants

8

Content, Journalism

9

Corp. Planning, Consulting

9, 20

Business Development / Gen-Mgmt / Strategy

10

Engineering Design, R&D

17, 33

Engineering / R&D / Engineering Design

11

Export, Import

18

Import / Export / Int. Trading

12

Fashion, Garments

13

Fresher, Trainee Jobs

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

20

IT, Software Services

21

Legal

10

Legal / Law

22

Manufacturing

26

Operations Mgmt

23

Marketing, Advertising

24

Media, Entertainment

11, 24

Advertising / Media / PR / Marketing

25

NGO, Govt, Defense Jobs

26

Oil, Energy, Power

27

Overseas, International

28

Packaging

29

Pharma, BioTech

25

Biotech / Pharma

30

Purchase, Supply Chain

16, 32

Supply Chain / Logistics / Purchase / Vendor Devlp / Inv

scan0032.jpg

Title: Naukri Job-Category Mapping (Continued)

S.No

Naukri Job-Category

Our Serial No

India Recruiter's Equivalent "Function"

31

Retail

32

Sales, BD

34

Sales / Marketing

33

Secretary, Front Office

2

Front Office / Sec. service

34

Site Engineering

31

Site Eng / Project Mgmt

35

Teaching, Education

35

Education / Teaching / Training

36

Telecom

37

Telecom / ISP

37

Top Management-IT

20

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

scan0033.jpg

Handwritten Notes (Shalaka):

  • Google Search 1: "Rss feed" + "Indian jobsites" —> 62 results.
    • Found: 1) Bixee, 2) Flipdog
  • Google Search 2: site: www.interbiznet.com job scraping —> 35 results.

scan0034.jpg

Handwritten Notes (Shalaka):

  • Topic: Job RSS feed
  • Note: Rahul told me that Clickjobs have stopped mentioning "Job Title / Designation" from Job Advts.
  • Discovery: I just found that "https://www.google.com/search?q=Keralaglobal.com" does provide "Title / Com. Name / email / city". Pl- look up.
    • Annotation: Occasionally not clickable.
  • Additional Source: Also see goldenjobs.com.
  • Date: 26/05/09

scan0035.jpg

Database Tables (Candidate & Resume Details):

  • CandidateProjectDetails: PEN (PK/FK), PartnerId, ProjectTitle, ProjectClient, KeySkills Id, RolePlayed, StartDate, EndDate, EnterDate, UpdateDate.
    • Note: "Only for further IT (List Box)".
  • CandidateRecord: RecordId (PK), PartnerId, PEN (FK), ActivityType, RecordDate, Recipient, EnterDate, UpdateDate.
  • GRPERSONSALARY: Note: Cancelled by Rahul.
  • ResumeBlastDetails: RBlastID (PK), PartnerId, PEN (FK), RBlastCount, EnterDate, AgenciesId.
  • GRRESUMEBLAST_RESPONSE: ResponseID (PK), AgencyId, RBlastId, FeedBack, Enterdt.
  • CandidateFunction: PEN (PK/FK), PartnerId, FunctionId, KeyWords, RawScore, FunctionRank.
  • Handwritten Scribbles: Mention of "Candidate Indents" (PKID, PEN, PartnerID, Indent ID) and "Master Profile Master".

scan0036.jpg

Title: Client Tables

  • ClientDetails: PartnerId (PK), ClientId (PK), ClientUserName, ClientPassword, SecretQuestionId, SecretAnswer, EmailId, CompanyName, ContactPerson, Designation, IndustryIds, Address, CountryId, CityId, Pin, Phone, Mobile, Fax, InUse, EmailVerified, EnterDate, UpdateDate.
  • IndustryMaster: IndustryId (PK), IndustryName, InUse, EnterDate.
  • CountryMaster: CountryId (PK), CountryName, EnterDate.
  • CityMaster: CityId (PK), CityName, StateId (FK), CountryId (FK), EnterDate.
  • StateMaster: StateId (PK), StateName, CountryId (FK), EnterDate.

scan0037.jpg

Database Tables (Masters & Agency):

  • FunctionMaster: FunctionId (PK), FunctionName, Category, InUse, EnterDate.
  • AgencyData: AgencyId (PK), CompanyNM, Email, CityNM, CountryID, IndustryID, PartnerID, ClientID.
  • ClientSubscriptionDetails: ClientSubscriptionId (PK), PartnerId, ClientId, PlanId, CreditPoints, InUse, EnterDate, UpdateDate.
  • SecretQuestionsMaster: SecretQuestionId (PK), SecretQuestion, InUse, EnterDate, UpdateDate.

scan0038.jpg

Database Table: JobAdvt

  • Columns: AdvtId (PK), FolderId, PartnerId, ClientId, ReferenceCode, JobTitle, JobDescription, FunctionId, Keywords, DesignationLevelId, Designation, IndustryId, PostingCountryId, PostingStateId, PostingCityId, SalaryCurrency, MinSalary, MaxSalary, SalaryStatus, ManSpecifications, MinExperience, MaxExperience, EducationLevelIds, DegreeId, BranchId, JobType, JobAdvtPlain, CompanyName, CompanyProfile, CompanyAddress, CompanyWebsite, ContactPerson, Email, Phone, Mobile, Fax, ExpiryDate, InUse, EnterDate, UpdateDate.

Handwritten Notes:

  • Candidate Job Search Details: PKID, PEN, Entdt, Keywords, Exp from year month, Exp to year month, City Ids, Function ID, Skill Id, Industry ID, Designation Level Id, Job type Id.
  • Candidate Advt details: PKID, PEN, A Advt Id, EnterDT.
  • Employer Resume Details: Partner Id, PKID, Client Id, Resume Id.

scan0039.jpg

Database Tables (Repository & Vacancy):

  • ResumeRepository: FolderId (PK), FolderName, PartnerId, ClientId, AdvtId, PEN, Source, Shortlisted, InUse, EnterDate, UpdateDate.
  • ClientCreatedJobDescriptions: DescriptionID (PK), PartnerID, ClientID, JobTitle, JobDescription, EnterDate, UpdateDate, Status.
  • VacancyBlastRecords: VBlastId (PK), PartnerId, ClientId, AdvtId, VBlastCount, AgencyId, EnterDate.
  • VacancyBlastPreferences: VBlastRefernceId (PK), PartnerId, ClientId, MyAgencies, EnterDate, UpdateDate.

scan0040.jpg

Title: Candidate Tables

  • CandidatePersonalDetails: PEN (PK), FirstName, LastName, Email, AlternateEmail, Phone, Mobile, PreferredLocations, OtherLocation, DateOfBirth, Gender, MaritalStatus, Address, Nationality, CityId, StateId, CountryId, SkypeId, EnterDate, UpdateDate.
    • Handwritten note: Concatenate the Country Code + Std Code + No.
  • CandidateLoginDetails: PEN (PK/FK), Username, Password, SecretQuestionId, SecretAnswer, EnterDate, UpdateDate.
  • CandidateBasicDetails: PEN (PK/FK), TotalExperienceInYears, TotalExperienceInMonths, CurrentDesignationLevel, CurrentActualDesignation, CurrentEmployerIndustry, PrimaryFunctionSkillName.

Handwritten Calculations: Various numeric scribbles (1.11, 0.83, 10, 12) and arrows pointing toward master table preferences.

 

 

scan0041.jpg

Database Tables: Candidate History

  • CandidateExperienceDetails: EmployerName, Designation, Dates (Start/End Month/Year), and Salary.
  • CandidateResumeDetails: ResumeId, ResumePlain (Text), ResumeHTML (Text), and ActiveStatus.
  • CandidateEducationDetails: HighestQualification, BranchId, InstituteName, and Passing Dates.
  • CandidateAdditionalSkillsDetails: SkillName and Proficiency.

scan0042.jpg

Database Tables: Master & History

  • DesignationLevelMaster: DesignationId and DesignationName.
  • EducationBranchMaster: BranchId, DegreeId, and BranchName.
  • EducationDegreeMaster: DegreeId and DegreeName.
  • EducationLevelMaster: LevelId and LevelName.
  • GRRESUMECOURIERHISTORY: PKID, PenId, Recdate, and Email1 through Email10.
  • Handwritten Notes: Outline for "Additional Qualification Details" (PKID, PenID, ComID, Specialization, Start/End Month/Year).

scan0043.jpg to scan0049.jpg

Visual Basic Code: frmSaveAttachments These pages contain code for an automated resume attachment saver from Outlook.

  • Logic: Uses Outlook Object Model (Outlook.Application, Namespace, MailItem) and ADODB for database connections.
  • Email Sources: Specifically looks for resumes from "Monster Resume #", "JobsAhead:", and "cs@jobsdb.co.in".
  • Extraction: The getsentence function extracts data based on starting and ending strings (e.g., "Employer Ref No.", "Post Date").
  • File Handling: Checks attachment extensions for ".DOC", ".RTF", and ".HTM" before saving to specific directory paths like C:\Attachments\.
  • Database Operations: Inserts/updates records in resumes_date, resumes_adwise, and job_advt based on the email content scanned.
  • Initialization: The Form_Load event opens a database connection with provider MSDAORA.1.

 



















































Posted by No comments:
Subscribe to: Comments (Atom)