Notes: June 1999

Saturday, 19 June 1999

JOB- ADVT. DATABASE

Mr. Neville Tarporewalla

Chief Manager - Response

The Time of India Building

Dr. D.N. Road

Mumbai - 400 001

Dear Mr. Tarporewala :

Many thanks for your letter date- June 7.

As for your suggestion of some kind of business relations with regard to your website www.timesjobandcareers. com, I feel there could be interesting possibilities.

Besides providing banners on respective home pages, we could also consider exchanging the JOB - ADVT. DATABASE on each other sites.

I believe you Job - Advt. Database consists of only these advts which have appeared in the print - media of the Times - Group publications. As against this, we scan and upload Job - Advts which have appeared in several papers and magazines, including The Times Of India - Mumbai edition.

How would this help?

· We, at 3P, will save the effort of scanning the job - advts. appearing in the Times of India.

· www.timesjobandcareer.com will be able to attract a much larger no. of surfers to its site by offering a rich database of jobs available across the length and breadth of the country.

If you feel like exploring this idea further, I would be happy to come over and meet you.

Had a meeting the Mr. Sunil Rajshekhar - V.P. & Mr. Taraporewalla On 14-7-99. & also sent an email on 19-7-99.They will send us a proposal by end of July.

Incidentally, during the current month, the daily average no. of visitors (not hits) to our site has been 9000 + so far On 14th June, or site - rank was follows.

Search Engine	Keyword Used	Out Site Rank	Out of Total No. of Pages on WWW
AOL	“jobs hunt”	9	9,53,165
Infoseek	‘head hunt”	4	15.8 millions

Hemen Parekh

Principal Consultant

Friday, 4 June 1999

MASTER LIST OF PUBLIC LIMITED COMPANIES

Cyril

For getting MODULE #1 started, we gave you a Master List of Companies consisting of both "Limited" and "Private Ltd" companies. Some 14000 + records. This was compiled from KOMPASS - 1993 directory.

Although most of the companies mentioned here are "irrelevant" for us, we had to have some Master - List to start Module 1.

As each resume gets entered into Module 1, the "relevant" companies list will grow.

Independent of this, for the last, 4/6 weeks, we have been trying to compile a

MASTER LIST OF (PUBLIC) LIMITED COMPANIES from various source - documents.

These sources are listed in Annex : (A)

We are not using all of these sources, but I have listed these to emphasize that there could be many - many sources.

How would such a MASTER LIST help?

What can we do with it?

I have shown this in Annex : (B)

This is self - explanatory.

Because of the multiple "uses" envisaged in Annex (B), the CORPORATE DATABASE shown in Annexure, has a lot of "fields", for more than the Master List given to you for Module #1.

For the moment, even the current list (of Limited companies) being compiled has only

. Company Name

. Company Address (HO address)

But, we cannot compile a "new" corp. database every 3 months, as we discover a "new" use for it !

It would be highly desirable, if we can, right now, devise a database "structure" which would take care.

of our needs for the foreseeable future. Then, in such a structure, we may go on adding more & more data in on "incremental" manner, as when, we get hold of such data.

This is the same concept as in the case of our

NON - MEMBER EXECUTIVE DATABASE.

Companies can also be "Members" (i.e. clients) or "Non - Members" (i.e. Potential Clients)

We, most certainly need to create such a MASTER CORPORATE DATABASE for our module #2 (Order Execution). And we must start creating this MASTER right now, so that it is ready by the time you are ready to install Module #2. Without this, we will simply not be able to implement Module 2.

I would, therefore, request you to take up on a priority basis, the design of the database struck & make it available to sajida, so that she can start creating such a database and keep it ready within 2/3 months.

While developing the data - entry software (for MASTER CORPORATE DATABASE), please ensure that whatever data entry we have already done can be directly migrate to the new structure and that we do NOT have to re - key in all the fields. This is very important.

For this purpose, you may even depute Lind say to examine the existing database structures of several corp. databases which are floating around in our network.

Then there is also a question .

Can we directly migrate to our MASTER, company databases from

. Explore India CD

. CII floppy

. KOMPASS - 1996 CD

. (Available from Hongkong For $1000)

. Kothari CD (expected in 3/4 months)

. TATA PRESS, GETIT, SELPAGE Directories

. "Capex / PROWESS" online databases from CMIE (Annual subscription of Rs. 40,000 / 50,000 each)

. Databases being offered by VIPUL ZAVERI

. MTNL Phone Directory CD

. VSNL e - Mail directory floppies (60,000 addresses which we recently obtained & trying to get 300,000) This contains 3000/ 4000 Public Limited Companies.

Our aim should be to obviate/ eliminate manual data entry wherever such data (even in a truncated manner) is already available on electronic media.

cc : Nirmit / Sajida

PUBLIC LIMITED COMPANIES MASTER LIST

(Companies ending with “LIMITED / LTD")

SOURCES FOR COMPILATION

1. KOMPASS Directory (Printed) 1993

2. KOMPASS CD - ROM (Printed) 1996

3. Stock Exchange Directories (for all stock exchanges)

4. Directories such as KOTHARI/ IRIS

5. Membership Directories of various Professional Bodies such as

. Chambers of Commerce (city wise)

. CII / FICCI / ASSOCHAM / NASSCOM