3P EXECUTIVE SEARCH
November 08, 2000
Mr. Sudhakar
Applitech Solution
102 Rock Garden, $1^{st}$ Floor
Opp. Laxmi Indl. Estate
New Andheri Link Road
Andheri (West)
Mumbai 400 058
Dear Mr. Sudhakar,
Order Execution System
I am glad that
yourself/Tapan/Jayant could spend time with Mr. Nagle/Mr. Thakur
and myself yesterday to finalize
the System Requirement and the Output Reports.
I look forward to receiving from
your team this morning, a comprehensive document,
containing
- Data dictionary
- Data Flow Diagram (upto final payment stage)
- Decision Table
- Statement of Processes
- Output Report formats.
The above-mentioned documents
should incorporate those changes which we discussed yesterday and agreed to
incorporate, including the output reports on "Customer Outstandings
(Balance of Payments) – Consultantwise and Clientwise".
B-1, Lok Bharti Complex, Marol
Maroshi Road, Andheri (E), Mumbai 400 059.
Tel. : 91-22) 859 5560
Fax : 91-22) 859 5563
E-mail : contact@3pjobs.com
Web : www.3pjobs.com
Video conf. : 91-22-8519006
Member of Foster Partners Global
Network
(The U. S. alliance firm of KPMG
Peat Marwick LLP)
ARGENTINA • AUSTRALIA •
BAHRAIN • BELGIUM • BRAZIL • CHILE • CHINA • COLOMBIA • COSTA RICA • DENMARK •
DOMINICAN REPUBLIC • FRANCE • GERMANY • GREECE • HONG KONG • HUNGARY • INDIA •
INDONESIA • IRELAND • ISRAEL • ITALY • JAPAN • KOREA • LUXEMBOURG • MALAYSIA •
MEXICO • NETHERLANDS • NEW ZEALAND • PANAMA • POLAND • SAUDI ARABIA • SINGAPORE
• SOUTH AFRICA • SWITZERLAND • TAIWAN • U.K. • U.S.A. • VENEZUELA
3P EXECUTIVE SEARCH
During the discussions, the
following was agreed upon:
- The source-code will be handed over to 3P and will
become the intellectual property of 3P (Pl. see T/1 of my note dated
August 24)
- As per our requirements, we would be free to
install the Order Execution Software at any number of our branches,
without having to pay you any separate “license fee” for the same.
We would, however, pay you
reasonable charges for “installing” this software at our outstation branches,
in case we require your help/assistance in this matter.
- Instead of waiting till the entire software package
gets ready, you will examine the possibility of installing “sub-modules”
of this system as each “sub-module” gets ready. This will help in
debugging the system and familiarizing our staff with its use.
I have no doubt that you will
deliver to us a world-class, top-quality product, in light of the following
remarks attributed to Shri Mukesh Patel (Business Standard, Sept. 22, 2000):
“Mr. Patel said that he
considered the 3Ps order for developing a portal exclusively dedicated to IT
consultants and professionals as one of the most exciting and exclusive ones.
The job entailed constant upgradation of the data base, integrating the CVs
with placement and recruitment.”
With kind regards,
(Signature)
H. C. Parekh
cc : Nirmit
cc : Mr. Nagle
Received
Tapan
8 / 11 / 2000
FROM: APPLITECH SOLUTION PHONE
NO. : 9179569489 Aug. 07 2000 07:23PM P1
2/11/2000
To
3P Consultants Ltd.
Mumbai
Kind attention. Mr. Hemant Parekh
/ Mr. Nirmit Parekh
Dear Sir,
We once again wish you a Happy
New Year.
This has reference to our letter
dated 20/10/2000 and your subsequent reply dated 30/10/2000. We are a bit
concerned after having gone through your reply, and in the interest of project,
we would like to share the same with you.
Your reply dated 30/10/2000
unfortunately did not contain the answer to most of our questions we had raised
in our letters. I am sure you realize that these are extremely important and
urgent for us, as they affect all the points mentioned below.
- Architecture information
- Freezing of requirements (without which tools can
not be selected)
- Selection of appropriate tool (without which
designing can not start)
- Design (without which development cannot take
place)
- Completion of project as per agreed time line
We have received your feedback on
the reports but it lacks the following:
- Suggestion on the content and the data fields (if
any fields have to be added/ deleted)
Feedback on sorting order of each
report
- Sample data
- The formats of the reports (like $e.g.$ grand total
$etc.$ as requested in report formats send to you (reports nos. 37, 42,
43).
- $P.S.$ If a report is to be Printed $e.g.$ along
with frequency $etc.$ (last page of the report format document dated
14/10/2000)
We appreciate your efforts in
grouping the reports logically and will certainly find these effort valuable,
but the above points definitely require immediate attention and priority, at
this point of time.
We have also not received any
feedback on the MOM dated 14/10/00 sent along with the report formats. Your
special attention is drawn towards the following points.
- The complete matter of the standard letters to be
given by 3P latest by 25/10/2000. (Point no:8)
- Format of the checklist to be given by 3P latest by
15/10/2000. (Point no:13)
- Format of the Shopping Basket to be given latest by
3P by 15/10/2000. (Point no: 14)
We regret to inform that as of
this date we are already slipping the deadline by almost a month &
non-availability of the above will only delay the project further.
Sir, I am sure you have faith in
our capabilities and that's why you have chosen us for your requirement of an
OES. We take great pride in following our ISO 9001 practices. Therefore in
keeping with these streamlined processes, we require all the information to
carry out our activities.
FROM: APPLITECH SOLUTION PHONE
NO. : 9179569489 Aug. 07 2000 07:23PM P2
Your suggestions are always
welcome we will always revert back on the same, but we would appreciate if you
can answer our immediate queries on priority. In fact we are already checking
and revising the requirement catalogue based on your feedback vide your letter
dated 30/10/2000.
Your additional inputs such as
Amazon.com writeup are indeed enlightening, but we are not in position to
really commit on any of those features for our system. In case we find
something suited to our needs, we will gladly incorporate any good ideas
In the end we once again request
you to kindly revert immediately on the above-mentioned points since the
project work is at a standstill in absence of the feedback on the same
I am sure you understand and will
extend your fullest co-operation.
Assuring you of our best services
always.
Warm regards,
For Applitech Solution Ltd.
(Signature)
Neeraj Rathi
From: tapan tapan@asi.com
To: nirmit nirmit@3pjobs.com;
hemant@3pjobs.com; naglesys@vsnl.com
Cc: Manish Kasliwal
ManishK@ASL.COM; Neeraj Rathi neeraj@ASL.COM; webmaster@bombay.vsnl.net.in
Sent: Wednesday, October 18, 2000
7:21 PM
Attach: reportsformat.zip;
MINUTES OF MEETING for 14 oct.doc
Subject: Reports format for OES
October 18, 2000
Dear Sir
With reference to our visit to 3P
on 12th and 13th October 2000 and our discussion on the format of the format of
the output requirements please find enclosed file attached herewith
"ReportsFormat.zip" which contains the format of the reports. (The
zip contains the word document "report format.doc")
We request you to kindly study
the same and revert with your suggestions.
Please note that the formats so
decided would be final and would form and integral part of the requirement
catalogue. The requirement catalogue would be submitted to you once the output
format is received and incorporated.
We request you to kindly take
immediate action in the matter and revert.
We are enclosing the minutes of
meeting which you are requested to sign and send it back.
Warm Regards
Tapan, Jayant
10/19/00
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consultants
List of Reports
|
Name of Report |
Page No. |
|
|
1. |
Follow up details for an order
of given client |
3 |
|
2. |
Details of Compensation
received for an order |
3 |
|
3. |
Compensation details remaining
to be received for an order |
3 |
|
4. |
Interview call sent out for an
order |
4 |
|
5. |
Resumes remaining to be sent
(order wise) |
4 |
|
6. |
Resumes sent out for an order |
4 |
|
7. |
Pending order for a consultant
chronologically |
5 |
|
8. |
Pending order for a consultant
(client wise) |
5 |
|
9. |
Pending order for a consultant
(Vacancy Name wise) |
5 |
|
10. |
Pending order for a consultant
(Estimated Billing Value wise) |
6 |
|
11. |
Pending order for a client
chronologically |
6 |
|
12. |
Pending order for a client
(consultant wise) |
6 |
|
13. |
Pending order for a client
(Vacancy Name wise) |
7 |
|
14. |
Pending order for a client
(Estimated Billing Value wise) |
7 |
|
15. |
Pending status for a given
period (industry wise) |
7 |
|
16. |
Pending status for a given
period (function wise) |
8 |
|
17. |
Pending status for a given
period (designation level wise) |
8 |
|
18. |
Monthly Shopping Basket Summary
(for a given Period) |
9 |
|
19. |
Shopping Basket Summary (URL
wise) |
9 |
|
20. |
Shopping Basket Statement (for
a given Period) |
9 |
|
21. |
Shopping Basket Designation
level wise/vacancy wise) (for a given Period) |
10 |
|
22. |
Shopping Basket (Industry wise)
(for a given Period) |
10 |
|
23. |
Shopping Basket (function wise)
(for a given Period) |
10 |
|
24. |
Shopping Basket (Client wise)
(for a given Period) |
11 |
|
25. |
Shopping Basket Consultant wise
(for a given Period) |
11 |
|
26. |
Proposal |
11 |
|
27. |
Sales Order |
11 |
|
28. |
Project Plan for a sales order |
11 |
|
29. |
Advertising Details for a
client (for a given Period) |
12 |
|
30. |
One line statement |
12 |
|
31. |
Interview Schedule for Sales
Order |
12 |
|
32. |
Invoice |
13 |
|
33. |
Project Variance for Sales
Order |
13 |
|
34. |
Follow up with client (for a
given Period) |
13 |
|
35. |
Follow up with candidate (for a
given Period) |
14 |
|
36. |
Details of prospective
candidate |
14 |
|
37. |
Consultant wise client list |
14 |
|
38. |
Compensation Details |
14 |
|
39. |
Client wise Expected date of
joining |
15 |
|
40. |
Advertising response (client
wise) (for a given Period) |
15 |
|
41. |
Advertising response (media
wise) (for a given Period) |
15 |
|
42. |
Janam Kundli (client) |
15 |
|
43. |
Janam Kundli (candidate) |
15 |
|
44. |
Executive Placed summary
(Industry Wise) (for a given Period) |
16 |
|
45. |
Executive Placed summary
(Function Wise) (for a given Period) |
16 |
|
46. |
Executive Placed summary
(Vacancy Wise) (for a given Period) |
17 |
|
47. |
Executive Placed summary
(Client Wise) (for a given Period) |
17 |
|
48. |
Executive Placed summary
(Joining Date Wise) (for a given Period) |
17 |
|
49. |
Executive Placed summary
(Annual Compensation Wise) (for a given Period) |
18 |
|
50. |
Executive Placed summary
complete list (for a given Period) |
18 |
|
51. |
Client List on order value for
a given period |
18 |
|
52. |
Client List on order value for
a given period (function wise) |
19 |
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consultants
|
Page No. |
||
|
53. |
Client List on order value for
a given period (Industry wise) |
19 |
|
54. |
Client List on order value for
a given period (Vacancy wise) |
20 |
|
55. |
List of inquiry for a given
period |
20 |
|
56. |
List of inquiry for a given
period (consultant wise) |
20 |
|
57. |
List of inquiry for a given
period (Industry wise) |
21 |
|
58. |
List of inquiry for a given
period (Function wise) |
21 |
|
59. |
List of inquiry for a given
period (Vacancy wise) |
21 |
|
60. |
List of inquiry for a given
period (Country wise) |
22 |
|
61. |
List of inquiry for a given
period (Country wise) |
22 |
|
62. |
Number of inquiries remaining
to be answered (consultant wise) |
22 |
|
63. |
Invoice (for Final Payment)
summary (client wise) for given period month wise |
23 |
|
64. |
Invoice (for Final Payment)
summary (consultant wise) for given period month wise |
23 |
|
65. |
Invoice (for Final Payment)
summary (for given period month wise) |
24 |
|
66. |
Invoice (for Final Payment)
summary date wise for given period |
24 |
|
67. |
Invoice (for Final Payment)
summary (consultant wise) for given period |
24 |
|
68. |
Candidate History |
25 |
|
69. |
Analysis of order Executed
Summary (Industry Wise) |
26 |
|
70. |
Analysis of order Executed
Summary (Function Wise) |
26 |
|
71. |
Analysis of order Executed
Summary (Designation Level Wise) |
26 |
|
72. |
Analysis of order Executed
Summary (Industry Wise Details) |
27 |
|
73. |
Analysis of order Executed
Summary (Function Wise Details) |
27 |
|
74. |
Analysis of order Executed
Summary (Designation Level Wise Details) |
27 |
|
75. |
Analysis of order Executed
Summary (Total) for a given period |
28 |
|
76. |
List of inquiries which did not
convert to an order |
28 |
|
77. |
Inquiry Status |
29 |
|
78. |
Interview held Summary Client
wise |
30 |
|
79. |
Interview held Summary |
30 |
|
80. |
Load on consultant |
30 |
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consultant
|
List of report |
Print reqd. (Y/N) |
Print on Printed Paper
(Y/N) |
Print on Letter Head (Y/N) |
Paper size (if other than
A4) |
Fre- quency of report |
|
|
1 |
2 |
3 |
4 |
5 |
||
|
1. |
Follow up details for an order
of given client |
|||||
|
2. |
Details of Compensation
received for an order |
|||||
|
3. |
Compensation details remaining
to be received for an order |
|||||
|
4. |
Interview call sent out for an
order |
|||||
|
5. |
Resumes remaining to be sent
(order wise) |
|||||
|
6. |
Resumes sent out for an order |
|||||
|
7. |
Pending order for a consultant
chronologically |
|||||
|
8. |
Pending order for a consultant
(client wise) |
|||||
|
9. |
Pending order for a consultant
(Vacancy Name wise) |
|||||
|
10. |
Pending order for a consultant
(Estimated Billing Value wise) |
|||||
|
11. |
Pending order for a client
chronologically |
|||||
|
12. |
Pending order for a client
(consultant wise) |
|||||
|
13. |
Pending order for a client
(Vacancy Name wise) |
|||||
|
14. |
Pending order for a client
(Estimated Billing Value wise) |
|||||
|
15. |
Pending status for a given
period (industry wise) |
|||||
|
16. |
Pending status for a given
period (function wise) |
|||||
|
17. |
Pending status for a given
period (designation level wise) |
|||||
|
18. |
Monthly Shopping Basket Summary
(for a given Period) |
|||||
|
19. |
Shopping Basket Summary (URL
wise) |
|||||
|
20. |
Shopping Basket Statement (for
a given Period) |
|||||
|
21. |
Shopping Basket Designation
level wise/vacancy wise) (for a given Period) |
|||||
|
22. |
Shopping Basket (Industry wise)
(for a given Period) |
|||||
|
23. |
Shopping Basket (function wise)
(for a given Period) |
|||||
|
24. |
Shopping Basket (Client wise)
(for a given Period) |
|||||
|
25. |
Shopping Basket Consultant wise
(for a given Period) |
|||||
|
26. |
Proposal |
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consultants
|
1 |
2 |
3 |
4 |
5 |
||
|
27. |
Sales Order |
|||||
|
28. |
Project Plan for a sales order |
|||||
|
29. |
Advertising Details for a
client (for a given Period) |
|||||
|
30. |
One line statement |
|||||
|
31. |
Interview Schedule for Sales
Order |
|||||
|
32. |
Invoice |
|||||
|
33. |
Project Variance for Sales
Order |
|||||
|
34. |
Follow up with client (for a
given Period) |
|||||
|
35. |
Follow up with candidate (for a
given Period) |
|||||
|
36. |
Details of prospective
candidate |
|||||
|
37. |
Consultant wise client list |
|||||
|
38. |
Compensation Details |
|||||
|
39. |
Client wise Expected date of
joining |
|||||
|
40. |
Advertising response (client
wise) (for a given Period) |
|||||
|
41. |
Advertising response (media
wise) (for a given Period) |
|||||
|
42. |
Janam Kundli (client) |
|||||
|
43. |
Janam Kundli (candidate) |
|||||
|
44. |
Executive Placed summary
(Industry Wise) (for a given Period) |
|||||
|
45. |
Executive Placed summary
(Function Wise) (for a given Period) |
|||||
|
46. |
Executive Placed summary
(Vacancy Wise) (for a given Period) |
|||||
|
47. |
Executive Placed summary
(Client Wise) (for a given Period) |
|||||
|
48. |
Executive Placed summary
(Joining Date Wise) (for a given Period) |
|||||
|
49. |
Executive Placed summary
(Annual Compensation Wise) (for a given Period) |
|||||
|
50. |
Executive Placed summary
complete list (for a given Period) |
|||||
|
51. |
Client List on order value for
a given period |
|||||
|
52. |
Client List on order value for
a given period (function wise) |
|||||
|
53. |
List of inquiry for a given
period |
|||||
|
54. |
Client List on order value for
a given period (Vacancy wise) |
|||||
|
55. |
List of inquiry for a given
period |
|||||
|
56. |
List of inquiry for a given
period (consultant wise) |
|||||
|
57. |
List of inquiry for a given
period (Industry wise) |
|||||
|
58. |
List of inquiry for a given
period (Function wise) |
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consultants
|
1 |
2 |
3 |
4 |
5 |
||
|
59. |
List of inquiry for a given
period (Vacancy wise) |
|||||
|
60. |
List of inquiry for a given
period (Country wise) |
|||||
|
61. |
List of inquiry for a given
period (Country wise) |
|||||
|
62. |
Number of inquiries remaining
to be answered (consultant wise) |
|||||
|
63. |
Invoice (for Final Payment)
summary (client wise) for given period month wise |
|||||
|
64. |
Invoice (for Final Payment)
summary (Consultant wise) for given period month wise |
|||||
|
65. |
Invoice (for Final Payment)
summary for given period month wise |
|||||
|
66. |
Invoice (for Final Payment)
summary date wise for given period |
|||||
|
67. |
Invoice (for Final Payment)
summary (consultant wise) for given period |
|||||
|
68. |
Candidate History |
|||||
|
69. |
Analysis of order Executed
Summary (Industry Wise) |
|||||
|
70. |
Analysis of order Executed
Summary (Function Wise) |
|||||
|
71. |
Analysis of order Executed
Summary (Designation Level Wise) |
|||||
|
72. |
Analysis of order Executed
Summary (Industry Wise Details) |
|||||
|
73. |
Analysis of order Executed
Summary (Function Wise Details) |
|||||
|
74. |
Analysis of order Executed
Summary (Designation Level Wise Details) |
|||||
|
75. |
Analysis of order Executed
Summary (Total) for a given period |
|||||
|
76. |
List of inquiries which did not
convert to an order |
|||||
|
77. |
Inquiry Status |
|||||
|
78. |
Interview held Summary Client
wise |
|||||
|
79. |
Interview held Summary |
|||||
|
80. |
Load on consultant |
APPLITECH SOLUTION
www.applitechsolution.com
20/10/2000
Copy given to
Mr Nagle
CMN
10/31
3P Consultants Pvt. Ltd.,
B-1, Lok Bharti Complex,
Marol Maroshi Road,
Andheri (E)
Mumbai - 400 059
Kind Attn: Mr. Hemant Parekh /
Nirmit Parekh
Dear Sir,
Sub: Order Execution System
This has reference to our various
meetings we had at your office for the Order Execution System. You would
appreciate that designing of a software is a very important aspect of the
software development process and in order to ensure that the same is done
correctly we would like to seek clarifications on the following points:
1. Architecture
We understand that 3P will have
multiple locations in the near future. In order to develop the system
architecture, we need to have more information on:
- What kind of data would be exchanged between all
locations?
- Which would be the main location.
- What type of connectivity is desired for linking
these locations? Are there any special considerations for these
requirements? If so please elaborate.
2. Inputs
The list of inputs (masters/
transactions) has been submitted by our team during the course of SRS. The same
has to be finalized at the earliest.
3. Output
The list and the format of output
(reports) have been made by you and our team. The same should be finalized to
ensure that all relevant information is being captured. All reports must
contain at least a few lines of dummy or real data to give us a clear picture
of the report functionality. This is very important and crucial to
understanding the reports.
4. Organization Structure.
We will require the current &
the proposed organization structure. I.e. The hierarchical structure from
topmost management and below.
5. Security
We will require a document from
you stating your security needs such as the levels of security expected in the
system.
6. Audit Log
A document is required by us to
know your audit log requirements. What data would you like to back up? What
operations should be audited? The same will help us design better by keeping
your needs in mind.
Confidential Page 1 of 2
Applitech Solution Limited
102 Rock Garden, 1st Floor, Opp.
Laxmi Industrial Estate New Andheri Link Road, Andheri (West) Mumbai - 400058
Tel: 91 (22) 631 0142; 632 7119
Email: aslbmb@bom3.vsnl.net.in
An ISO 9001 Company
- Front Tool
While the back end tool has been
finalized as oracle 8i the front-end tool is yet to be decided. Although we are
in the process of finalizing the same, we request you to kindly let us know
your preferences for the front-end tool if you have any, and the reason for the
preference. We would also like to know what gains or benefits you expect by
from the selection of a particular tool.
An early response on all the
above mentioned points would be highly appreciated since the designing work can
only commence after your feed back is received and the requirements are frozen.
Assuring you of our best
services,
Yours faithfully,
For Applitech Solution Ltd.
(Signature)
(Neeraj Rathi)
admin
|
From: |
tapan tapan@asi.com |
|
To: |
nirmit nirmit@3pjobs.com; hemant@3pjobs.com; naglesys@vsnl.com |
|
Cc: |
Manish Kasliwal ManishK@ASL.COM; Neeraj
Rathi neeraj@ASL.COM; aslbmb@bom3.vsnl.net.in |
|
Sent: |
Wednesday, October 18, 2000
7:21 PM |
|
Attach: |
reportsformat.zip; MINUTES OF
MEETING for 14 oct.doc |
|
Subject: |
Reports format for OES |
October 18, 2000
Dear Sir
With reference to our visit to 3P
on 12th and 13th October 2000 and our discussion on the format of the format of
the output requirements please find enclosed file attached herewith
"ReportsFormat.zip" which contains the format of the reports. (The
zip contains the word document "report format.doc")
We request you to kindly study
the same and revert with your suggestions.
Please note that the formats so
decided would be final and would form and integral part of the requirement
catalogue. The requirement catalogue would be submitted to you once the output
format is received and incorporated.
We request you to kindly take
immediate action in the matter and revert.
We are enclosing the minutes of
meeting which you are requested to sign and send it back.
Warm Regards
Tapan, Jayant
10/19/00
Applitech Solution Ltd. 3 P
Consultants P Ltd.
MINUTES OF MEETING
|
Date 14/10/2000 |
Place: 3P Consultants P
Ltd., Mumbai. |
|
3P Consultants P Ltd. (3P) |
Applitech Solution Ltd.
(ASL) |
|
Mr. Hemant Parekh |
Mr. Tapan |
|
Mr. Nirmit Parekh |
Mr. Jayant |
|
Mr. Thakur |
|
|
Ms. Michelle |
|
|
Mr. Nagle |
|
|
Mr. Cyril |
The following were discussed and
decided upon:
- 3P will give the PEN No. along with inquiry details
in the format as requested by ASL which will be used by ASL for candidate
listing in the Order Execution System (OES).
- The existing database is being changed and the new
database prepared by 3P will be given to ASL by $1^{st}$ week of November.
The OES will use the data as captured in the existing/ revised database as
and when required.
- The list of standard reports is to be given by 3P
by 15/10/2000.
- The list of standard letters is to be given by 3P
by 15/10/2000.
- The complete matter of these reports & letters
will be given by 3P by 25/10/2000.
- The IT related industry names shall be incorporated
in single industry master.
- Designation master is not required. It has been
brought to the notice of 3P that subsequently it would not be able to
search on this criterion.
- Function master will include the IT functions.
- City master is not required. It has been brought to
the notice of 3P that subsequently it would not be able to search on this
criterion.
- Reasons for rejection of proposal are to be given.
- 3P to give the format of the invoice.
- The OES will give the information of the Candidates
selected to the existing data base of 3P.
- Format of the checklist to be given by 3P by
15/10/2000.
- Format of the Shopping Basket to be given by 3P by
15/10/2000.
- Service Master & the Product Master are not
required.
Applitech Solution Ltd. 3 P
Consultants P Ltd.
- Rate contract will only be a Text document, which
would be available at the time of making the proposal.
- The % of the alliance partners is not being
captured anywhere and the same has to be captured. The input form of this
has to be decided.
- All communications with 3P will carry the Sales
Order Number. There will be no communication with 3P without the Sales
Order Number.
- As the scope of the work has changed the effort for
the development of the order execution system has to be re-estimated. This
also leads to changes in the original project schedule. This will also
have commercial implication which will be discussed with you by our
marketing team.
Accepted for & on behalf of
3 P Consultants P Ltd.
Accepted for & on behalf of
Applitech Solution Ltd.
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consult
List of report
|
List of report |
Print reqd. (Y/N) 1 |
Print on Printed paper
(Y/N) 2 |
Print on Letter Head (Y/N)
3 |
Paper size (if other than
A4) 4 |
Frequency of report 5 |
|
|
1. Follow up details for an
order of given client |
||||||
|
2. Details of Compensation
received for an order |
||||||
|
3. Compensation details
remaining to be received for an order |
||||||
|
4. Interview call sent out for
an order |
||||||
|
5. Resumes remaining to be sent
(order wise) |
||||||
|
6. Resumes sent out for an
order |
||||||
|
7. Pending order for a
consultant chronologically |
||||||
|
8. Pending order for a
consultant (client wise) |
||||||
|
9. Pending order for a
consultant (Vacancy Name wise) |
||||||
|
10. Pending order for a
consultant (Estimated Billing Value wise) |
||||||
|
11. Pending order for a client
chronologically |
||||||
|
12. Pending order for a client
(consultant wise) |
||||||
|
13. Pending order for a client
(Vacancy Name wise) |
||||||
|
14. Pending order for a client
(Estimated Billing Value wise) |
||||||
|
15. Pending status for a given
period (industry wise) |
||||||
|
16. Pending status for a given
period (function wise) |
||||||
|
17. Pending status for a given
period (designation level wise) |
||||||
|
18. Monthly Shopping Basket
Summary (for a given Period) |
||||||
|
19. Shopping Basket Summary
(URL wise) |
||||||
|
20. Shopping Basket Statement
(for a given Period) |
||||||
|
21. Shopping Basket Designation
level wise/vacancy wise) (for a given Period) |
||||||
|
22. Shopping Basket (Industry
wise) (for a given Period) |
||||||
|
23. Shopping Basket (function
wise) (for a given Period) |
||||||
|
24. Shopping Basket (Client
wise) (for a given Period) |
||||||
|
25. Shopping Basket Consultant
wise (for a given Period) |
||||||
|
26. Proposal |
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consult.
|
1 |
2 |
3 |
4 |
5 |
||
|
27. Sales Order |
||||||
|
28. Project Plan for a sales
order |
||||||
|
29. Advertising Details for a
client (for a given Period) |
||||||
|
30. One line statement |
||||||
|
31. Interview Schedule for
Sales Order |
||||||
|
32. Invoice |
||||||
|
33. Project Variance for Sales
Order |
||||||
|
34. Follow up with client (for
a given Period) |
||||||
|
35. Follow up with candidate
(for a given Period) |
||||||
|
36. Details of prospective
candidate |
||||||
|
37. Consultant wise client list |
||||||
|
38. Compensation Details |
||||||
|
39. Client wise Expected date
of joining |
||||||
|
40. Advertising response
(client wise) (for a given Period) |
||||||
|
41. Advertising response (media
wise) (for a given Period) |
||||||
|
42. Janam Kundli (client) |
||||||
|
43. Janam Kundli (candidate) |
||||||
|
44. Executive Placed summary
(Industry Wise) (for a given Period) |
||||||
|
45. Executive Placed summary
(Function Wise) (for a given Period) |
||||||
|
46. Executive Placed summary
(Vacancy Wise) (for a given Period) |
||||||
|
47. Executive Placed summary
(Client Wise) (for a given Period) |
||||||
|
48. Executive Placed summary
(Joining Date Wise) (for a given Period) |
||||||
|
49. Executive Placed summary
(Annual Compensation Wise) (for a given Period) |
||||||
|
50. Executive Placed summary
complete list (for a given Period) |
||||||
|
51. Client List on order value
for a given period |
||||||
|
52. Client List on order value
for a given period (function wise) |
||||||
|
53. Client List on order value
for a given period (Industry wise) |
||||||
|
54. Client List on order value
for a given period (Vacancy wise) |
||||||
|
55. List of inquiry for a given
period |
||||||
|
56. List of inquiry for a given
period (consultant wise) |
||||||
|
57. List of inquiry for a given
period (Industry wise) |
||||||
|
58. List of inquiry for a given
period (Function wise) |
Applitech Solution Ltd.
Reports Layout Ver 1.0 3P Consult.
|
1 |
2 |
3 |
4 |
5 |
||
|
59. List of inquiry for a given
period (Vacancy wise) |
||||||
|
60. List of inquiry for a given
period (Country wise) |
||||||
|
61. List of inquiry for a given
period (Country wise) |
||||||
|
62. Number of Inquiries
remaining to be answered (consultant wise) |
||||||
|
63. Invoice (for Final Payment)
summary (client wise) for given period month wise |
||||||
|
64. Invoice (for Final Payment)
summary (Consultant wise) for given period month wise |
||||||
|
65. Invoice (for Final Payment)
summary for given period month wise |
||||||
|
66. Invoice (for Final Payment)
summary date wise for given period |
||||||
|
67. Invoice (for Final Payment)
summary (consultant wise) for given period |
||||||
|
68. Candidate History |
||||||
|
69. Analysis of order Executed
Summary (Industry Wise) |
||||||
|
70. Analysis of order Executed
Summary (Function Wise) |
||||||
|
71. Analysis of order Executed
Summary (Designation Level Wise) |
||||||
|
72. Analysis of order Executed
Summary (Industry Wise Details) |
||||||
|
73. Analysis of order Executed
Summary (Function Wise Details) |
||||||
|
74. Analysis of order Executed
Summary (Designation Level Wise Details) |
||||||
|
75. Analysis of order Executed
Summary (Total) for a given period |
||||||
|
76. List of inquiries which did
not convert to an order |
||||||
|
77. Inquiry Status |
||||||
|
78. Interview held Summary
Client wise |
||||||
|
79. Interview held Summary |
||||||
|
80. Load on consultant |
Oct. 30, 2000
Tapan
Applitech (Ahmedabad)
Enclosed find a few pages from
book
Amazon.Com.
While going thru these pages, I
came across some observations which, I believe, are quite relevant to our own
- website design
- Order Execution Module
- Business Model, as a whole.
I request you to study these
carefully and apply your mind as to which of these are worth copying/worth
avoiding, in our own System.
Maybe in a week's time, I will
send you the entire book (on a CD) so that we could learn from the evolution of
Amazon.com (which was launched in Aug. 1995 - as against 3pjobs which got
launched in Nov. 1997).
Regards
(Signature of H. C. Parekh)
Tapan, Jayant
(APPLITECH-AHMEDABAD)
MANAGEMENT
"e-recruitment market
expected to fetch US 1.7 billion by 2003"
While we are in the process of
finalizing the features of our "Order Execution Module", you may wish
to study SIWA and try to incorporate its best features in our Module.
As I have repeatedly stated,
after a trial-period of 6/12 months we, too, would like our clients to be able
to back/monitor their executive search assignments directly, on their
own, on our website. Hence, this migration (to web) is an essential feature
that we have to build into our Module.
For this, you may also study
Dirakis.com | www.JobDB.com etc.
Regards
(Signature)
T. Parekh 16/10/2000
cc: Michelle / CMT / Nirmit.
Note: The rest of the image
contains a newspaper clipping discussing the e-recruitment market and a new
service called jobstreet.com, with handwritten notes highlighting terms like
SIWA and the desire for clients to monitor assignments on their website.
13/10/00.
wherever consultant is involved
the Branch Name is to appear.
1. Follow up details for an
order of given client
|
Sales |
Order execution number |
Client name × Vac. Name |
Consultant name |
|
Date of follow up
(Chronologically) |
Activity of follow up |
Outcome of follow up |
Next follow up date if any |
2. Compensation details
remaining to be received for an order
|
Order execution number |
Client name × |
Consultant name |
|
PEN |
Candidate name |
Date of joining |
3. Compensation details
received for an order
|
Order execution number |
Client name × |
Consultant name Gr. An.
Comp. |
|
PEN |
Candidate name |
Date of joining |
4. Interview call letter sent
out for an order
|
Order execution number |
Client name × |
Consultant name Date of
sending interview call letter interviewcallDateofsending |
|
PEN |
Candidate name |
|
|
12345 |
5. Resume
$\stackrel{S}{Search\ result}$ remaining to be sent order wise
|
Order execution number |
Client name × |
Consultant name |
|
PEN |
Candidate name |
|
6. Resume
$\stackrel{S}{Search\ result}$ sent out for an order
|
Order execution number |
Client name × |
Consultant name |
|
PEN |
Candidate name |
Date Sent |
7. Interview letter sent for
order
(Section is blank)
8. Pending order for a
consultant chronologically
|
Consultant name |
|||||
|
Date of Proposal |
Client name |
$\frac{OEN}{SON}$ |
Proposed end date
(chronologically) |
$\frac{Vac.\
Name}{Designation}$ $\frac{Order\ name}{Est. Billing\ value}$ |
|
|
No. of Vacancy $\times$
Serv/c/e & Fees. |
9. Pending order for a
consultant [client wise]
|
Consultant name Branch |
|||||
|
Client name (sorted on) |
Date of Proposal |
$\frac{OEN}{SON}$ |
Vacancy
$\frac{Designation}{Name}$ |
$\frac{Est. Billing}{Order\
value}$ |
Proposed end date |
10. Pending order for a
consultant $\underline{[vacancy\ Name\ wise] \ \ \ designation\ wise}$
|
Consultant name Branch |
|||||
|
$\frac{Designation\ (sorted\
on)}{Vac.\ Name}$ |
Client name |
$\frac{OEN}{SON}$ |
Date of Proposal |
Proposed end date
(chronologically) |
|
11. Pending order for a
consultant [order value wise] $\underline{Est.\ Billing}$
|
Consultant name Branch |
|||||
|
$\frac{Order\ value}{Est.\
Billing}$ $\frac{Descending}{Sorting\ Order\ Value-wise}$ |
Client name |
$\frac{Vac.\ Name}{Designation
(sorted on)}$ |
$\frac{OEN}{SON}$ |
Date of Proposal |
Proposed end date
(chronologically) |
12. Pending order for a client
[chronologically]
|
Client name Branch |
|||||
|
Date of Proposal $\frac{C(\
chronologically)}{}$ |
Consultant $\frac{Br.}{name}$ |
$\frac{OEN}{SON}$ |
Proposed end date
(chronologically) |
Designation Vac. Name |
$\frac{Order\ value}{Est.\
Billing}$ |
13. Pending order for a client
[consultant wise]
|
Client name Branch |
|||||
|
Consultant name (sorted on) |
Branch |
Date of Proposal |
$\frac{OEN}{SON}$ |
Designation Vac. Name |
Order value |
14. Pending order for a client
$\underline{[Vac.\ Name\ designation\ wise]}$
|
Client name Branch |
|||||
|
$\frac{Designation\ (sorted\
on)}{Vac.\ Name}$ |
Consultant name |
$\frac{OEN}{SON}$ |
Date of Proposal |
Proposed end date
(chronologically) |
|
15. Pending order for a client
$\underline{[Est.\ Billing\ order\ value\ wise]}$
|
Client name Branch |
|||||
|
$\frac{Order\ value}{Est.\
Billing}$ $\frac{Descending}{order}$ |
Consultant name |
$\frac{Vac.\ Name}{Br.}$
$\frac{Designation}{ (sorted\ on)}$ |
$\frac{OEN}{SON}$ |
Date of Proposal |
Proposed end date
(chronologically) |
(25) 16. Pending status for a
given period $\underline{[industry\ wise]}$
Pending status for the period
from < start date > to < end date >
|
Industry |
Order value |
Function |
Consultant name |
Designation |
OEN |
End Date of project |
(26) 17. Pending status for a
given period $\underline{[function\ wise]}$
Pending status for the period
from < start date > to < end date >
|
Function |
Order value |
Industry |
Consultant name |
Designation |
OEN |
End Date of project |
(27) 18. Pending status for a
given period $\underline{[designation\ level\ wise]}$
Pending status for the period
from < start date > to < end date >
|
Designation |
Order value |
Industry |
Consultant name |
Function |
OEN |
End Date of project |
O.E. Schedule 12/10/2000
(1) List of Standard letters $\rightarrow$
names. by 15/10/2000
Actual Letter Format by
25/10/2000
(2) Add. IT Industry names in Master
List.
(3) Designation Master $\rightarrow$
Not. Required.
(4) Function. Master $\rightarrow$ Add
IT functions and have one list. of all functions.
(5) City Master $\rightarrow$ To be
dropped.
(6) Reasons for Rejection of Proposal
to be given.
(7) Interview Screen to appear side by
side of Resume.
(8) Invoice format $\rightarrow$ to be
given.
(9) Data of Executive Appointed to go to
Cyril's system.
(see reverse of page 37 of 42)
(10) Checklist for Final settlement
- whether Appt. letter recd
Applitech Solution Limited
Requirement Catalogue
for
Order Execution
Version 1.0
3P Consultants
Applitech Solution Limited
701 Shikhar, Navrangpura,
Ahmedabad - 380009, India
Tel: +91 (79) 658 0248/8709/8797
Fax: +91 (79) 658 8455
E-mail: sales@asi.com
URL: www.applitechsolution.com
Table of Contents
- INTRODUCTION
....................................................................................................
1
1.1. PURPOSE
.........................................................................................................
1
1.2. SCOPE AND BUSINESS PROCESS
OVERVIEW .......................................... 1
1.2.1. Business Rationale
...................................................................................
1
- SYSTEM DIAGRAMS AND TABLES
.................................................................. 3
2.1. Document Flow Table
.....................................................................................
3
2.2. Document Flow Diagram
...................................................................................
4
2.3. Context Level Diagram –
Proposed System ...................................................... 5
- MODULES
..........................................................................................................
6
3.1. Order Execution
..............................................................................................
6
3.1.1. List of Masters
........................................................................................
6
3.1.2. List of Transactions
.................................................................................
24
3.1.3. List of Reports
........................................................................................
41
- PERFORMANCE REQUIREMENTS
...................................................................... 41
- INTERFACE REQUIREMENTS
............................................................................
41
- OPERATIONAL REQUIREMENTS
........................................................................
41
- SECURITY/CONTROL REQUIREMENTS
............................................................ 41
- REQUIREMENT OF STANDARDS TO BE USED
.............................................. 42
- DOCUMENTATION REQUIREMENTS
................................................................ 42
- USER TRAINING REQUIREMENTS
.................................................................... 42
- OUTPUT REQUIREMENTS
................................................................................
42
- USER ACCEPTANCE CRITERIA
........................................................................
42
Applitech Solution Limited
Requirement Catalogue Ver 1.0 3P Consultants
1. Introduction
3P Consultants Pvt. Ltd., is a
leading Human Resource solution providing organisation having leading
industries and companies as their clients. The exploitation of the latest
technologies in communication and IT by 3P consultants has provided them a cutting
edge in their field of operation. The innovative schemes offered by them to the
various sources of collecting the resource (the information of the candidates)
have accelerated the reach to the grass root levels and are poised for a
leaping growth with the explosion of IT and convergence technology growth in
the coming years.
3P having visualized the growth
potential, would like to have an Order Execution System, which would
allow them to address the present and future demands.
1.1. Purpose
The purpose of this System
Requirement Study (SRS) is to provide a system of managing Order Execution
of 3P to handle Client and the executives.
1.2. Scope and Business
process overview
1.2.1. Business Rationale
3P consultants is a leading human
resource consultant. The company serves the corporate for their various
requirements.
The Requirement Catalogue being
prepared herewith covers the functionality of Order Execution System
only.
1.2.1. Technical Rationale
The proposed system should take
care of various Order Execution related activities viz Inquiry, Work order,
Clients details, Candidate details, Activity Tracking.
Applitech Solution Limited
Requirement Catalogue Ver 1.0 3P Consultants
1.3 Abbreviations
|
Abbreviation/Acronym |
Description |
|
OEN |
Order Execution Number |
|
ASL |
Applitech Solution Ltd. |
|
SRS |
System Requirement Study |
|
3P |
3P Consultants Pvt. Ltd. |
|
OES |
Order Execution System |
POINTS FOR DISCUSSION WITH
APPLITECH. 5/10/00
|
Item |
Status |
|
Database of Current System |
|
|
Scalability of Database |
|
|
Size of Database |
|
|
Rate of growth of Database |
|
|
Current No. of Users |
|
|
Scripting Language (Web) |
|
|
Current System Architecture
(Two Tier/Multi-tier) |
|
|
Load Balancing Technique Used
in architecture |
|
|
Database Server vs. Web Server |
|
|
Multiple web servers ? |
|
|
Links to other Websites. |
with Applitech 5/10/00
- Incorporation of Personal Information Management
(PIM)
- Which PIM module should be incorporated ?
- Capability to move from "Help Desk / call
centre"
- to
- "fully Interactive web-based Single
Interface"
- Capability to integrate in future
- "Voice Recognition (IVRS)" for
- capture of resumes.
- Follow-up | Reminder (Communication) strategy to
cover all modes
- Viz:
- phone | fax | email | SMS | WAP | letter
- "Online sale" (after online quotation)
- of resumes to be capable of receiving/
- accounting payments over Internet.
- Internal logic (built-in) shall trigger / activate
/ remind,
- what is to be followed-up
- who is to follow-up
- when is to be followed-up
- whom to follow-up
This screen must "greet"
each consultant first thing every morning & won't go away (or allow him/her
to proceed with today's other work) unless - and until, he/she takes
appropriate "follow-up action", which "satisfies"
the internal logic.
- All webforms to get into Module 1 AUTOMATICALLY,
as soon as database server is SWITCHED-on each morning.
- Like PEN, a unique Code no. (along with unique
Password / User Name) to get automatically generated for each Corporate
who
- Posts a job-advt. on website
Tapan - Jayant - Neeraj
Applitech
Oct - 5, 2000
Order Execution Module
Enclosed find some notes on
Corporate Profile (Janam Kundli).
- 3 page
MIS - 2 "
Oracle Front Office Suite - 1
"
Communication Database - 1 "
Interviews - 1 "
These notes are by way of
elaborations - basic ideas are already covered in the folder given to you 4/5
weeks back, when we first met.
Before you proceed with actual
programming, I suppose, you will give us print-outs of how each input screen
and output statement will look like.
Input screens should clearly
bring-out
what/which "fields"
will need to be entered
which "fields" will get
filled-up automatically from the databases created upto that point of time.
Regards
(Signature)
cc: Mr. Nagle
cc: Cyril
cc: Consultants.
NOTES (CP-1)
CORPORATE PROFILE (JANAM
KUNDLI)
|
Type of Corpo. |
Client Company |
Any Other Company |
|
Screen # 1 |
Contact data |
|
|
Screen # 2 |
Products - Services - Plants -
Branches - Collaborations - Financials |
|
|
Screen # 3 |
Job - Advt. History - Headhunt
session History |
|
|
Screen # 4 |
History of Past / Current
Orders placed |
$\times$ |
|
Screen # 5 |
Order Tracking Module |
$\times$ |
As far as CORPORATE PROFILES
are concerned, these must seamlessly integrate with our website.
That means,
- Data Capture Screens
- Database Structure
must be SAME, whether offline or
online.
It is therefore, imperative that
these are approved by Cyril in advance, so that these can be easily uploaded on
our website.
It is possible that, in each screen,
some fields are entered by us to begin with, with a provision that the
personnel manager of the concerned company can modify/edit the same at a later
date, once we give him
- Password
- Username
- Unique No.
Idea is to transfer this burden
(of maintaining / keeping the profile up-to-date) to the concerned Company's
Personnel Manager.
Of course, we cannot allow him to
change/modify/alter certain fields pertaining to past/current
orders/payments/invoices/outstandings/placements etc. etc. He can see/view
these, but only we can change these/add to these.
|
Screen |
Viewable by |
||
|
Public |
Concerned Corporate |
By 3P only |
|
|
# 1 |
|||
|
# 2 |
|||
|
# 3 |
|||
|
# 4 |
|||
|
# 5 |
CORPORATE PROFILE (Janam
Kundli)
Fields
|
1. |
Company Name |
|
|
2. |
Unique NO. |
|
|
3. |
Source of data |
|
|
4. |
Date of Entry / Modification |
|
|
5. |
Industry Category to
which it belongs |
|
|
(Click on Industry Master
dropdown) |
||
|
6. |
Management Group |
|
|
Names of Chairman/CEO |
use dropdown list/by
click/enter value |
|
|
MD/CED |
||
|
President |
||
|
Directors |
||
|
7. |
Chief of Personnel &
Phone/email/fax |
|
|
8. |
Sales Turnover (Rs Cr) in
$\_\_\_$ yr. |
|
|
9. |
HO Address/Phone/fax/email. |
|
|
10. |
Reg. Offices " along with
name |
Separate Screens |
|
11. |
Factories / Plants "
$\ell$ of Personnel Mgr. |
|
|
12. |
Products/Services |
|
|
13. |
Technical Collaborations |
|
|
(Products & Name/Country of
Collaborator) |
||
|
14. |
Joint Ventures |
|
|
(Products & Name/Country of
J.V. Partners) |
||
|
15. |
Private Screen Viewable by
3P only |
|
Name of Executive |
Designation |
Function |
MIS (Mgmt. Info. System)
{Hit Rate} = \frac{\text{No. of
shopping Baskets / month}}{\text{No. of headhunt sessions / month}}$$
{Web-Yield %} = \frac{\text{No.
of actual orders received thru our website / month}}{\text{No. of headhunt
sessions / month}}$$
{Paper-Yield %} = \frac{\text{No.
of actual orders recd. offline}}{\text{No. of proposals submitted offline}}$$
(4) % of orders booked
(A bar chart is shown comparing
Online vs. Offline orders booked by year from 1999 to 2003: 1999 (95% Online),
2000 (80% Online), 2001 (60% Online), 2002 (40% Online), 2003 (20% Online))
(5) No. of Resumes
received/Submitted / month.
(6) No. of job-advt. posted /
month.
(7) No. of "headhunt"
sessions / month ($\ell$ candidate alert)
(8) No. of "jobsearch"
sessions / month ($\ell$ auto job-alert)
(9) No. of "Shopping
Baskets" / month
(10) No. of executives appointed
(as on ---- ?
$\left. \begin{array}{l} \text{so
far } \square \\ \text{for a given period } \square \end{array} \right\}$
$\left. \begin{array}{l}
\text{for Company [ABC]} \\ \text{for [All] companies} \end{array} \right\}$
Client-company wise
"Designation-level"
wise
Function wise
Edu. Quali. wise
Age wise (Candidate's age)
Chronologically wise/Joining date
wise
Salary wise ($\ell$ Professional
Fees-wise)
Offline wise / Online wise
Industry wise
City (of posting) wise
Consultant wise
These data should be compiled
& displayed in "Tables & "graphically" ($\text{line
chart/Pie chart/bar charts etc.}$)
Any item VS. Any other item
($\text{X & Y axis}$).
(11) Similar Compilation/Analysis
should be carried out for
"No. of Executives YET to be
appointed" ($\text{Order Backlog}$) ($\text{as on ----.}$)
Relevant data should be extracted
from
Purchase Order ($\text{Search
Assignment}$)
Invoice ($\text{to be modified if
required}$)/$\text{Cheque}$
Appointment Letter
