Notes: 2001

Kind Attention Mr. Neeraj Rathi

FAX:

Attn: Mr. Neeraj Rathi

Applitech

Ahmedabad

Dec. 27, 2001

Dear Neeraj:

Change Requests

I refer to the Report Formats faxed on Dec. 25. I could not attend to this as I was extremely busy yesterday.

I have gone thru these proposals of yours, which require minor modifications.

I enclose my counterproposals, incorporating the changes desired. If in doubt, do send me a fax/email.

As far as

Item # 7 (Ally wise Order Report)
Ref. check & Regret letters

are concerned, I will send you our drafts in 2/3 days.

With regards

H. Parikh

Enclosed:

Formats for Report Nos. 3/4/5/6/8 (Serial 15)

No: 11 (Serial 17)

cc: Mangesh (Mumbai)

cc: Mr. Sahid Sayyed

SERIAL NO: 15 / Change Request No: 2 / Item No: 3

Dec. 27, 2001

PRELIMINARY INTERVIEWS - ORDER WISE REPORT.

From (Date)	To (Date)
\text{------------}	\text{------------}

SON (Reverse Chrono)	Client Name	Position (Vacancy Name)	Consultant Name	Interview Panel	Prelim. Interview Scheduled Dates
clickable values

Notes

This "SUMMARY" statement covers ALL sales orders / ALL clients / ALL consultants.
Clicking on any particular SON should open up another window/screen, where, one can view Report No: 45 for that sales order. Closing the new window would return to original screen.
If, for any given (one) position, several candidates are "scheduled" to be interviewed on different dates, then, one below another, all these different dates must appear in the last column.

SERIAL NO: 15 / Change Req st No: 2 / Item No: 4

Dec. 27, 2001

PRELIMINARY INTERVIEWS - PARENT GROUP WISE REPORT

From (Date)	To (Date)
\text{------------}	\text{------------}

Parent Group Name	clickable on a dropdown list

Client Company Name - Alpha (belonging to this group)	SON (Reverse Chrono)	Position (Vacancy Name)	Consultant Name	Interview Panel	Prelim. Interview Schedule Date.
	12356
	42986

Note

Clicking on any particular SON should open-up another window/screen, where, one can view Report No: 44 for that sales order. Closing the new window would return to original screen.

SERIAL NO: 15 / Change Request No: 2 / Item No: 5

PARENT-GROUP WISE BIO-DATA SENT REPORT.

From (Date)	To (Date)

Parent Group Name	clickable Drop-down list

Client Co. Name - Alpha (belonging to this Group)	SON (Reverse chrono)	Position (Vacancy Name)	PEN	Affiliate ID No.	Candidate Name	Date on which resume sent
	12345 clickable

Note

Clicking on any particular SON, would open-up another window/screen, where, one can view Report NO: 36, for that Sales Order. Closing the new window would return to the original screen.

SERIAL NO: 15 / Change Request NO: 2 / Item NO: 6

27-12-2001

PARENT-GROUP WISE INTERVIEW HELD REPORT

From (Date)	To (Date)

Parent Group Name	Clickable Dropdown List

Client Name (Alpha)	SON	Position (Vacancy Name)	PEN	Affi. ID NO.	Candidate Name	Date of Interview	Interview Round No.	Result.

SERIAL NO: 15 / Change Request NO: 2 / Item No: 8

27-12-01

"ALLY (AFFILIATE) WISE BIO-DATA SENT" REPORT

From (Date)	To (Date)

Type of Affiliate	Clickable Dropdown

Name of Affiliate	Clickable Dropdown

Whose Resume Was Sent?	To Whom was it sent?	When was it sent?	For Which Position was it sent?	Against which Sales order was it sent?	If this candidate got appointed
PEN	Candidate Name	Client Co. Name	Date Sent	Position (Vacancy Name)	SON

Note

To enable preparation of this REPORT, Shopping Basket is being modified so that, corresponding to each PEN (appearing on every Shopping Basket), there will be

Affiliate ID NO
Affiliate ID Type
Affiliate ID Name

} from which, resume, bearing that PEN has arrived,

SERIAL NO: 17 / Change Request NO: 2 / Item No: 11

27-12-01

CURRENT STATUS = CLIENT-WISE, DATE WISE REPORT

From (Date)	To (Date)

Branch	Consultant

Client Name	Dropdown List

Contact Person	Phone No
Designation	E-mail

SON (Rev. Chrono)	Final Invoice No	Invoice Date	Invoice Amt. Rs.	Amount Recd. so far	Amount Remaining to be Received	TDS Status	Closure Status	Reason for Closure	Remarks.
3245
	42/8-8-2001	45000	30000	15,000
	63/12-9-2001	11000	11000	-
	98/15-12-2001	18000	-	18000
6389

NOTES

All types of Invoices must be shown (es: Min. Search / Adv/ Progr. Payment/ ODP Exp/ Final Invoice etc).
There could be more than one cheque payments against any given invoice. All must be added up to compute "Amount Remaining To be Received".

APPLITECH SOLUTION

www.applitechsolution.com

August 21, 2000

3P Consultants Pvt Ltd,

R-1, Lok Bharati Complex,

Marol Maroshi Road, Andheri (E)

Mumbai: 400 059

Kind Attention: Mr. Hemen C Parikh - Director

Dear Sir,

Sub: Proposal for Internal Management System

This refers to the discussions we had in the recent past on the above-referred subject.

Further to the discussions and the Pre - System Requirement Study conducted by our Mr. Tapan Shah from Ahmedabad, we have prepared our offer for the customized software solution for your Internal Management System as per your requirement. Please find the proposal enclosed for your kind perusal.

We have taken care that the system proposed would cater your future requirements of integration with the web-enabled applications.

As we are in the process of getting the coveted CMM level 3 certification, all the processes to be followed in the making of the software solution for you would be as per the CMM methodologies and the ISO 9001 procedures. You can be rest assured about the delivery and the quality of the software solution.

We have also included the company profile, the partial client list and the profiles of our directors for your reference.

We hope you find our offer in line with your requirement and place your valuable Purchase Order with us at the earliest.

Please do contact us should you require further information or clarification.

Thanking you and assuring you our best services at all times

For Applitech Solution Ltd

K. Sudhakar (signature)

Manager - Sales

Encl: As above

ISO 9001 Company

August 2000

-1-

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: aslbmy@bom3.vsnl.net.in

An ISO 9001 Company

Applitech Solution Ltd

3P Consultants Pvt Ltd

Applitech Solution Limited

Proposal

For

Internal Order Processing

Management System

3P Consultants Pvt. Ltd.

Applitech Solution Limited

Enterprise Wide Computing Group

701, Shikhar, Netaji Marg, Navrangpura

Ahmedabad - 380013

Call: 91 (79) 6568249, 6568709, 6568797

Fax: 91 (79) 6569489

Mumbai Office:

102, Rock Garden,

New Link Road, Andheri (W),

Mumbai - 400053

Phone: 91 (22) 6327119 / 6310142

E-mail: aslahd@vsnl.com / aslbmy@bom3.vsnl.net.in

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

INDEX


Executive Summary	3
Scope of work	4-5
System Tool	6
Commercial offer	7-11
Company profile of Applitech Solution Ltd	12
Details of Director	13
Company Background	14-15
Projects Executed	16
Web project expertise	17

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Executive Summary:

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 to collection 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 Consultants Pvt Ltd, having visualised the growth potential, would like to have an Internal Order Processing Management System, which would allow them to address the present and future demands.

We, Applitech Solution Ltd, a leading IT solution provider specialising in providing customised applications, discussed with 3P consultants about their requirement of the Internal Order Processing Management System. Having conducted a Pre - System Requirement Study at 3P Consultants, we propose the following solution for the Internal Order Processing Management System.

A broad overview of the Internal Order Processing Management System is given below:

It would be a Client - Server based solution with web enabled components for the future expansions and integration using the web technology.

The system would be implemented in the Mumbai office of 3P Consultants Pvt Ltd

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Scope of Work:

The entire operation is divided in 3 Phases.

Phase I : Creation of modules which would take care of the normal work flow.

Phase II : Auto e- Mailing to candidates shortlisted from the search about the interview, extensive MIS reports, Balance of Payment for each P.O, Client etc

Audit trails on the above

Phase III : data migration from the currently existing database to the new database structure

Auto email- enabling the alerts to the potential candidates about the new requirements, and alerts to the clients on the availability of new CVs as per their requirements.

In Phase I and Phase II, the database masters of the candidates and the clients have to be newly constructed .The modules will not access the existing database directly.

The details of scope of work in each phase is given below

Phase I:

This involves the System Requirement Study, design coding and implementation of the essential modules of the Internal Order Processing Management System.

The modules would allow transactions between Client, 3P Consultants and the Candidate.

The logical sequence of the workflow would be as below.

Phase I

Creation of database structure for client, candidate
Registration of Purchase Order for each enquiry from a client
Scanning the database for the requirement
Sending the suitable resume for the evaluation
Scheduling the interview

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Getting the details of offer given to the selected candidates
Raising invoice for the service charges
Documentation of follow up for the Balance of Payment
MIS reports of the cases handled, Advance given, B.O.P/ receivables etc, client wise, P.O wise, Consultant wise & date wise

All the correspondence with the client and the candidate would be registered and is subject to audit trail.

Phase II

Auto E Mail to candidate once the client selects the CV for a particular assignment
B.O.P reminder for each client, Purchase Order.
Documentation on correspondence on the follow up
Extensive MIS reports

Note: All the data of candidate and the client have to be entered in the new system masters for the access. The system would not provide direct access to the current database

Phase III

Data Migration for the existing CV, client database
Auto e mail to the candidate once a client registers a new requirement suitable to the candidate's resume

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Auto e mail to the client once a candidate registers a new cv suitable to the client's requirement

The System Tool

The Back end for the system would be Oracle 8I for allowing the easier web enabled upgrades in future.

The front end would be decided only during the System Requirement Study as this would involve the following factors apart from suitability to the system to be developed.

Ease of use
Tool's availability, life cycle
Cost of the tool

The front end would be chosen keeping in mind that the the future requirements of web based software components have to be interfaced seamlessly.

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Commercial offer

Ref: ASL/3P/ERP/03

August 20, 2000

QUOTATION

Description	Prices (Rs.)
Internal Order Processing Management System - customized Application software including: System Requirement Study, Design, Coding, Implementation and Training	5,70,000.00/- (Rupees five lakh seventy thousands only)
Professional service charges( DBA visit for OS installation, fine tuning of Database, Network related consultations, etc)	Rs2500.00/- Per manday
Transport charges - II AC Rly ticket from Ahmedabad to the site	At actuals
Boarding and lodging charges for implementation duration more than 2 months - as given in the schedule.	Rs.2500.00/- Per Manday

The application would be developed in 3 Tier architecture to cater the future needs of web enabled application integration.

Roles and Responsibilities:

Once the work is awarded, Applitech will take the overall responsibility of the Project Execution and Project Management. However for the successful implementation, quality time and timely approvals of various documents at different stages by ¹Adani Port will be essential.

Sr. No.	Activity	Responsibility
	Preparation of System Design document and Screen prototypes	Applitech
	Timely approval of System Design document and Screen prototypes	3P Consultants
	Coding, Testing and Documentation	Applitech
	User Acceptance Testing and approval of the documentation	3P Consultants
	Implementation	Applitech
	Scheduling of the users for the Training	Applitech
	Training	3P Consultants
	Supply and Set up of Hardware	3P Consultants
	Supply and set up of Networking Components	3P Consultants

Note: Enough time will have to be given by 3P Consultants Personnel to study and approve the System Design Document and Screen prototypes.

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

It is presumed that the site would be ready in all respects (including the required hardware and networking components) at the time of implementation. However, Applitech would recommend the exact hardware specifications, only after the Design phase is over.

During Implementation and Training the users of the system at 3P Consultants will have to give full co-operation in terms of availability and time given.

Project Execution Plan

Applitech proposes to implement application software development phases. The Project development plan for application development is broadly divided into 3 phases.

Stage I

During this stage, following activities will be performed:

System Requirement Study

Entry Criterion

Receipt of confirmed Purchase Order along with advance at Applitech Solution Ltd, as per the commercial offer and terms and conditions mutually agreed.

Exit Criterion

Completion of the System Requirement Study

Deliverables

Detailed System Requirement Study document. Sufficient time would be given to 3P consultants to study the System Requirement Study documents. The System Requirement Study documents would be mutually agreed in writing to pave the way for the stage II.

The approximate time schedule for this stage would be 10 DAYS.

Stage II

During this stage, following activities will be performed:

Design and system specification

Physical design

Entry Criterion

Approval of System Requirement Study document

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Exit Criterion

Completion of the System Design

Deliverables

Detailed System Design document which shall include final data model, updated process description, screen design document and menu design document

Time Length for this stage is 30 Days from completion of stage I.

Stage III

During this stage, following task shall be performed:

Coding, testing and documentation for application software

User Acceptance Testing at development site

Entry Criterion

Approval of the System Design and Screen Prototypes

Exit Criterion

Successful User Acceptance Testing and provisional sign-off by 3P Consultants

Deliverables

Implementation Schedule

Time Length for this stage is 40 days from completion of stage II

Stage IV

During this stage, following task shall be performed:

Installation of the software at 3P Consultants

Training of the users

Entry Criterion

Provisional sign-off of the software

Exit Criterion

Implementation and completion of training of the different users

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Deliverable

Executable software

All documentation (i.e. System documentation, user and operational manuals)

Time Length for this stage depends on 3P Consultants users and the readiness of various departments. The time length proposed is 20 Days

Services

During implementation, Applitech will provide the following services:

Software Installation & Test Run

ASL will install the software on the hardware and carry out the test run jointly with 3P Consultants. This exercise will be carried out with sample test data prepared by 3P Consultants Pvt. Ltd., and all outputs taken and verified by the joint team.

Training

ASL will conduct training at different levels to prepare 3P Consultants personnel's for the computerized operations. The typical training plan is as follows:

TRAINING PROGRAM

	Duration	No. of Participants
Orientation Program for Top Management	1 day	2 to 3
Functional Operation for Operators/staff	1 week	7/week
System Administration Training	2 day	1

Warranty Maintenance

ASL will provide warranty maintenance for the software for a period of 90 days from the date of software installation at Mumbai site.

After the warranty maintenance period, ASL can provide software maintenance services under an annual contract.

Annual Maintenance Contract

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

After the expiry of the warranty period at the first site, 3P Consultants Pvt. Ltd, can choose to undertake an Annual Maintenance Contract (AMC) with ASL for the individual sites which will be charged at 16% of the total price per site per annum. The annual maintenance contract would be restricted to the correction of any bug or software defect in the application software. The AMC would not include site-visits for any purpose other than bug fixing.

Payment terms

20% with the Purchase Order
20% on Submission of System Design Documents (including ER diagram, Screen prototypes and Data Dictionary)
20% on the Provisional acceptance of the software at the Development Lab or installation of software at site (which ever is earlier)
20% on integration
20% within 2 weeks of running complete software at site.

Terms and Conditions

Prices

The prices quoted include the supply of run-time version of the software, license copy for 3P Consultants Mumbai.

The prices do not include the cost for System Software like Oracle 8i, Windows NT, multimedia tools etc. All other Govt. levies including Sales tax, Octroi etc, if applicable are extra. Master data creation, site preparation, cabling and power conditioning is not included.

License fee

The software License is for the 3P Consultants Mumbai. Installation of the software at additional site will be charged extra at mutually agreed price.

Functionality

The scope and functionality of the application software will be as mentioned in System Requirement Study Report. Any change in the scope and functionality of the application software will charged extra at Rs.60,000/- per man-month basis.

Travel and Stay

For all visits from Ahmedabad to Mumbai, during the Design / coding / implementation / training stage the travel will be charged at a rate equivalent to the second AC railway fares from Ahmedabad to the site. All travel and stay required for on-site maintenance and support services, would be extra, if out side warranty period.

Validity of offer

The license fees quoted above are firm for a period of 30 days from date of this offer. These prices may be revised thereafter.

Non-applicable Costs

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Electrical work, UPS, Air conditioning, furniture, cables, line drivers, master data creation, etc. are not included in the cost and would be provided by 3P Consultants Pvt. Ltd.

Development Work

All the development work will be carried out at Applitech Solution Ltd, Ahmedabad/ Mumbai

Company Profile

Name of the company	Applitech Solution Limited
Year of Establishment	1993
Reg. Office address	503, 'Paritosh', Usmanpura, Ahmedabad 380 013, Gujarat, India.
Locations of office with address	Ahmedabad
	503 'Paritosh', Usmanpura, Ahmedabad - 380 013, India
	Tel: (079) 7550683 / 7550685
	701, 'Shikhar', Netaji Marg Navrangpura,
	Ahmedabad - 380 009, India
	Tel: (079) 6560248 / 6568797
	Vadodara
	55, Kamlesh Park, Near Karelibaug Water Tank, Harni Road,
	Vadodara - 390006.
	Tel: (0265) 442843
	Mumbai
	102, Rock Garden, New Link Road,
	Andheri (West), Mumbai - 400 053.
	Phone (022) 6310142/6327119
	USA
	1501 Ben Crenshaw, Austin, Texas 78746
	Phone 1(512) 3271323
	Singapore
	12, Prince Edward Road, #04-09
	Podium B Bestway Building,
	Singapore - 079212.
	Phone (65) 2271184
	UK
	74 A High Street, Wansted, London EU 2RJ
	Phone: 0181 989 1110
	Australia
	Suite 9, 30-32 Rutland Road,
	Box Hill, Victoria 3128 Australia
	Phone (61-3) 9897 4885

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Details of Directors

Mr. Ankil C Patel, Managing Director

Academic Qualifications:

B.E. in Electrical Engineering from M.S. University, Baroda

M.S. in Electrical Engineering from University of Texas, Austin

Experience:

Worked in Intel Corporation, Santa Clara, California, USA, a world-renowned company in the field of computers, for seven years as Sr. Design Engineer. At Intel his duties included product definition, implementation plan, logic and circuit design and simulation, layout supervision, design verification and supporting product engineers for bringing up test programs and transfer of product into production. He worked on several products including microprocessors and peripherals. He has played a major role in the team, which has developed the 80386 chips at Intel.

In India, he has received 'IEEE Award' for best software product Dial Anything, a communication software package for Personal Computers.

Mr. Jayesh A. Parekh, Director

Academic Qualifications:

B.E. in Electrical Engineering from M.S. University, Baroda

M.S. in Electrical Engineering from University of Texas, Austin

Experience:

Worked in IBM, a world renowned company in the field of computers, for fifteen years in its offices world wide, namely, IBM Houston Marketing office, IBM Offshore Operations Singapore, IBM Corporation USA & IBM Singapore Pte. Ltd.

He is currently Managing Director of Frontier Technologies Pte. Ltd. Singapore.

Other Engagements

Director - Frontier Information Technologies Inc. (USA)

Director - Dixylar International, Inc. (USA, Singapore & India)

Director - Applitech Solution Limited, India

Director - SONY Entertainment Television (Singapore & India)

Director - Argos Communications Enterprise Pte Ltd. (Singapore)

Director - Acid Telecom Pvt. Ltd. (India)

Director - Atlas Equifin Pvt. Ltd. (India)

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Company Background

INTRODUCTION

Applitech is a leading software developer in India, providing software solutions, consultancy and software development services. It is positioned to deliver rapid, reliable and robust Information Technology solutions that work.

Applitech's mission:

Excellence through partnership, solutions and technology. Unrelenting in our drive to offer the best solutions, linking our core competencies with our customer's business requirements in ways that ensure that we are the customers preferred techn¹ology partner.

Applitech has a technical and project management staff strength of over two hundred IT professionals. Collectively this adds up to more than 500 person years of software development experience. Applitech has an established local presence in USA, Singapore and the UK, and works through business alliances in Australia.

SERVICES

Applitech has successfully executed many projects in each of the following four business focus areas:

ERP solutions for manufacturing, healthcare and service industries
Web computing based solutions and customized applications
Process Control and Automation based solutions for the Manufacturing Industry.
Software solutions in Network and Communications

Applitech provides a portfolio of solutions, services and products, both it's own and its alliance partners, that offer superior value by integrating the best combination of price, quality, reliability and delivery.

Applitech also provides a range of professional services to both its clients and alliance partners (in domestic and international markets) including IT consultancy and business process re-engineering.

Applitech's group company Dixylar has set-up a dedicated conversion center (DDC) or software factory in India, to undertake projects for Year 2000 code correction and testing. Necessary Data Conversion services is also offered. Equipped with Dixylar suite of Year 2000 tools and workbench Applitech has currently invested in setting up a 50-person year production capacity.

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Applitech has positioned itself to provide a single Point Total Business Solution. It has the required development and quality assurance processes to ensure timely delivery of hardware, networking and high quality, low maintenance software.

Applitech offers to establish Dedicated Development Centers (DDC) in India, for its clients and alliance partners, from India and abroad, in their respective niche areas. This is a long-term partnership where a team of professionals and other development resources are dedicated to work on behalf of the client/partner. The team are trained to match clients specific requirements and standards. Team management and software development process allows for extensive input and monitoring by client (via a dedicated datacom link where required). This facility works as an extension of clients' facility and has the key advantage of high quality service at lower costs.

Skills and Capabilities

Applitech technical personnel is highly qualified (a majority with technical or science degrees and over 20\% with some form of postgraduate qualification), trained in a range of computer hardware and software areas. All members of top management have lived, studied and worked abroad - ideal basis for overcoming the culture gap, as well as comprehending clients' tangible and qualitative needs and requirements.

Applitech's managers and project leaders possess the experience and management skills necessary for successful execution of large software projects. In-house processes, infrastructure and communications skills ensure trouble free interaction and smooth liaison with clients at any distance.

Overall, Applitech can deliver a competitive edge through cost and quality advantage, use of the state-of-art skills, high reliability and ability to save time on projects.

Applitech's Advantage

Experience in Oracle based applications since 1994
State-of-the-art development facilities
Global support infrastructure
Proven capabilities to build and maintain large complex systems
Culture for building application knowledge, value added professional services
Adherence to standards and methodologies
Quality - an on going process of change

Our philosophy is building relationships that last with all our stakeholders - clients, employees and shareholders. We will do so by being sensitive and responsive, and by being true to our commitments.

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Projects Executed

Expertise in Specific Industry

Applitech has catered to customers from different business segments and offered solutions to their satisfaction. The following is the partial list of type of Industries for which we had done project development.

No.	Industry	Some of our clients
1.	Manufacturing (FMCG)	Nirma Ltd.
2.	Manufacturing (Production)	Shree Rama Multi-tech Ltd.
3.	Manufacturing (Electronics)	Western Digital - Singapore.
4.	Manufacturing (Engineering)	Burnmann India Ltd.
		Vijay Tanks & Vessels Ltd.
5.	Import and Trading	Adani Wilmar Limited
6.	Petrochemical	IPCL
7.	Mineral / Mining	GMD.C.
8.	Dairy (Milk Distribution)	Gujarat Co-operative Milk Marketing Federation (GCMMF), Anand.
		Dudhasagar Dairy, Mehsana.
9.	Garment Export	Vogue.
		Parex Overseas.
10.	Drugs and Pharmaceuticals	Hoechst Marion Roussel (HMR).
11.	Entertainment Industry	SONY Entertainment Television.
12.	Fixed Deposit System	Interface Capital Market Ltd.
		CanJay Finance Ltd.
13.	Health / Pathology Laboratory	VIP Diagnostics.
		Specialty Ranbaxy Ltd.
14.	Port	Maritime and Port Authority of Singapore.
		Kandla Port Trust
15.	Telecommunications	Aura Systems, Canada (for Telecommunications Dept. of Argentina and Morocco Government).
16.	MOA Shell for Oceanography and Meteorology Applications	Space Application Centre (ISRO)
17.	Website Creation & Directory	Southern Gujarat Chamber of Commerce and Industry (SGCCI)

ISO 9001

August 2000

Applitech Solution Ltd

3P Consultants Pvt Ltd

Experience in development of web sites

MAJOR VIRTUAL WEBSITES

INTERACTIVE

NON INTERACTIVE

MAJOR NON VIRTUAL WEBSITES

D.Khushalibhai Jewelers, Surat
Shree Matushree Silk Mills, Surat
Amar Textiles, Surat
V.N. Mehta & Company, Surat
Rohit Traders, Surat
Happy Engineering, Surat
Gombhai Kalias Janwala, Surat
Vishnu Corporation, Surat
Marble House, Surat
A-One Industries, Surat
Rangoon Chemicals Works Pvt. Ltd, Surat
Saikat Texo-Food Industries, Surat
Jayantilal Chhaganlal, Surat
C & C International
Dhamma Lucas Pvt. Ltd.
Vipul Enterprises
Silver Enterprise
Laxmi Yarns Pvt. Ltd.
Jalpari Manufacturing Co.
Pooja Groups - Builders & Developers

ISO 9001 Company

August 2000

A P P L I T E C H

SOLUTION

www.applitechsolution.com

February 21 2001

3P Consultants Pvt Ltd

R-1, Lok Bharti Complex,

Marol Maroshi Road,

Andheri (E)

Mumbai: 400 059

Kind Attention: Mr. Hemen C Parikh

Dear Sir,

Sub: Estimation for the reports generation and additional scope of work

This refers to the discussions our SRS team had with you, Mr. Nirmit and Mr. Nagle for the finalization of the scope of work. The proposed Scheduler and the Change Requests have been discussed and the same has been enclosed for your kind reference.

The list of reports which are to be generated through the Order Processing Module has also been enclosed for your reference. We had suggested earlier in our offer that the reports would be generated through Crystal Reports and later it is agreed that the reports would have to be generated through the module itself. The no. of reports are 92 ( including additional 10 reports listed in the Change Request from enclosed).

Since 3P Consultants are a very important customer to us, we have reduced the man-day charges for the additional scope of work. The Commercial details are enclosed for your reference, kindly let us know your acceptance at your earliest.

We assure you that the work in the project is progressing very well and we are confident to provide you the Order Processing Module in the stipulated time.

Please let us know, should you require further information or clarification.

Thanking you and assuring you our best services at all times

For Applitech Solution Ltd,

K. Sudhakar

Manager - Sales

Encl: As Above

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: aslbmy@bom3.vsnl.net.in

Monthly Shopping Basket Summary (for a given Period)

From Month (MM/YY)	to Month (MM/YY)
Month Year	No of Inquiry received (1)	No of shortlisted PEN	Avg. No of Pen Per Inquiry	Number of inquiry converted into order (2)	Percentage conversion (2)/(1)*100	Average time (in days) to reply*

*Proposal date - inquiry date

Shopping Basket Summary (URL wise)

URL (Partner Website)

Date Arrives	Inquiry no.	Date proposal sent	Time Taken	Industry	Function	Vacancy name	Number of PEN	SON	Consultant name

Shopping Basket Statement (for a given Period)

Date	Inquiry no	URL from which came	When replied	Days taken to reply	Client Name	Vacancy name	Industry	Designation	Consultant name

Shopping Basket Designation level wise(vacancy wise) (for a given Period)

DESIGNATION. LEVEL

Inquiry no.	URL from which came	Date arrived	Date replied	Days taken to reply	Consultant	SON	Industry	Function	No of shortlisted PEN

Shopping Basket (Function wise) for a given Period

FUNCTION

Inquiry no.	URL from which came	Date arrived	Date replied	Days taken to reply	Consultant	Whether converted in to order	Industry	Designation Level	No of shortlisted PEN

Shopping Basket (Industry wise) for a given Period

INDUSTRY

Inquiry no.	URL from which came	Date arrived	Date replied	Days taken to reply	Consultant	Whether converted in to order	Designation Level	Function	No of shortlisted PEN

Shopping Basket (Client wise) (for a given Period)

Client

Address

Fax

Name of contact person

Inquiry no.	URL from which came	Date arrived	Date replied	Days taken to reply	Consultant	Whether converted in to order	Industry	Function	No of shortlisted PEN

Shopping Basket Consultant wise (for a given Period)

CONSULTANT

Inquiry no.	URL from which came	Date arrived	Date replied	Days taken to reply	Client	Whether converted in to order	Industry	Function	No of shortlisted PEN

List of inquiry for a given period

From Date:	To Date:

Date (chronologically)	Inquiry no	Client name	Vacancy name	No of vacancies	Function	City of posting

List of inquiry for a given period (consultant wise)

From Date:	To Date:
Consultant name
Branch

Date (Chronologically)	Inquiry no	Client name	Vacancy name	No of vacancies	Function	Industry	City of posting

List of inquiry for a given period (Industry wise)

From Date:	To Date:
Industry name

Date (Chronologically)	Inquiry no	Client name	Vacancy name	No of vacancies	Function	Consultant name

List of inquiry for a given period (Function wise)

From Date:	To Date:
Function name

Date (Chronologically)	Inquiry no	Client name	Vacancy name	No of vacancies	Consultant name	Industry

List of inquiry for a given period (vacancy wise)

From Date:	To Date:
Vacancy name

Date (Chronologically)	Inquiry no	Client name	Consultant name	No of vacancies	Function	Industry

List of inquiry for a given period (City wise)

From Date:	To Date:
City of posting

Date (Chronologically)	Inquiry no	Client name	Vacancy name	No of vacancies	Function	Industry	Consultant name	Country

List of inquiry for a given period (Country wise)

From Date:	To Date:
Country of posting:

Date (Chronologically)	Inquiry no	Client name	Vacancy name	No of vacancies	Function	Industry	Consultant name	City of posting

Number of Inquiries remaining to be answered (consultant wise)

Consultant name

Branch

Inquiry number	Inquiry date	No of days pending

List of inquiries which did not convert in to an order (Consultant wise)

From month/year:	To month/year:
Inquiry No.	Client name	Vacancy name	Inquiry Date	Proposal date	Proposal no	Reason (Sorted on)

Inquiry Status (Consultant wise)

From Date:	To Date:
Inquiry No.	Client name	Vacancy name	Inquiry Date	Proposal sent(Y/N)	Proposal no	Proposal Date

Proposal

As per Format (Ref. SRSPR01)

Sales Order

Standard letter format to be given by 3P

Project Plan for a sales order

Sales order no

Consultant Name

Branch

Client

Original

Vacancy name

No of Vacancy

Project plan no

Contact person name

Telephone:

Designation:

Activity	Estimated Date	Actual Date

Revision

Activity	Estimated Date	Actual Date

Project Variance for sales Order

Sales order no

Consultant Name

Branch

Client

Original

Vacancy name

No of Vacancy

Contact person name

Telephone:

Designation:

Project start Date (estimated)	Project start Date (Actual)
Project end Date (estimated)	Project end Date (Actual)
Duration (estimated) (in days)	Duration (actual) (in days)

Difference (actual duration - estimated duration) (in days)

Activity	Estimated End Date	Actual End Date	Difference in days

Pending order for a consultant chronologically

Consultant name

Date of Proposal	Client name	SON	Proposed end date (chronologically)	Vacancy name	No of vacancy	*Estimated Billing Value**

(No of vacancies)(salary to be offered)(professional fees)

Pending order for a consultant (client wise)

Consultant name

Branch

Client name (sorted on)	Date of Proposal	SON	Vacancy Name	Estimated Billing Value	Proposed end date

Pending order for a consultant (Vacancy Name wise)

Consultant name

Branch

Vacancy Name (sorted on)	Client name	SON	Date of Proposal	Proposed end date

Pending order for a consultant (Estimated Billing Value wise)

Consultant name

Branch

Estimated Billing Value (Descending)	Client name	Vacancy Name	SON	Date of Proposal	Proposed end date

Pending order for a client chronologically

Client name

Date of Proposal (chronologically)	Consultant	Branch	SON	Proposed end date	Vacancy Name	Estimated Billing Value

Pending order for a client (consultant wise)

Client name

Consultant name (sorted on)	Branch	Date of Proposal	SON	Vacancy Name	Estimated Billing Value	Proposed end date

Pending order for a client (Vacancy Name wise)

Client name

Vacancy Name (sorted on)	Consultant name	Branch	SON	Date of Proposal	Proposed end date

Pending order for a client (Estimated Billing Value wise)

Client name

Estimated Billing Value (descending)	Consultant name	Branch	Vacancy Name (sorted on)	SON	Date of Proposal	Proposed end date

Pending status for a given period (industry wise)

Pending status for the period from <SON start date> to <SON end date>

Industry	Estimated Billing Value	Function	Consultant name	Vacancy Name	SON	End Date of project

Pending status for a given period (function wise)

Pending status for the period from <SON start date> to <SON end date>

Function	Estimated Billing Value	Industry	Consultant name	Vacancy Name	SON	End Date of project

Pending status for a given period (designation level wise)

Pending status for the period

Designation level	Estimated Billing Value	Industry	Consultant name	Function	SON	SON End date	End Date of project

Load on consultant

From Date:	to Date:
Consultant name	Branch:

Sr. no	Sales order no	Client	Vacancy Name	No of vacancies	Expected end date (Reverse Chronological)

Resumes remaining to be sent (order wise)

Sales Order Number	Client name	Vacancy name	No of Vacancies	Consultant name
PEN	Candidate name			Branch

Resumes sent out for an order

Sales Order Number	Client name	Consultant name	Date Sent
PEN	Candidate name	Branch

One line statement (for consultant)

As per Format (Ref. SRSOL01)

One line statement (for client)

As per Format (Ref. SRSOL01)

(This statement will not have the contact numbers and the agency contact as per the format)

Details of prospective candidate

As per Format (Ref. SRSPC01)

Advertising Details for a client (for a given Period)

Client	Contact person name
E-mail	Phone:
Payment made by 3P (Y/N)
Reimbursed by client (Y/N)

Advt. No.	Media	Location	Date Published	Cost	Response

Advertising response (client wise) (for a given Period)

Client	Contact person name
E-mail	Phone:

Advt. No.	Media	Date Published	Response

Client	Contact person name
E-mail	Phone:

Advt. No.	Media	Date Published	Response

Advertising response (media wise) (for a given Period)

Media
Advt. No.	Client

Media
Advt. No.	Client

Interview call sent out for an order

Sales Order Number	Client name	Vacancy name	No of Vacancies	Consultant name	Date of sending interview call letter	Date of Interview
PEN	Candidate name			Branch

Interview Schedule for Sales Order

Sales order no

Consultant Name

Branch

Client

E-mail

Interview no.

Vacancy name

No of Vacancy

Contact person name

Address

PEN	Name	Venue	Tel	Date	Time	Mode of communication	Confirmation (Y/N)	Other info

Interview held Summary Client wise

Interview held Summary Client wise (Continued)

SON

Client Name

Vacancy name

No. of vacancies

Function

PEN	Candidate name	Date	Interview round no.	Result*

*SHORT LISTED, HOLD, SELECTED AND REJECTED

Interview held Summary

From Date:	To Date:
Date (Revers e Chronology)	PEN	Candidate name	Client name	Vacancy Name	Interview round no.	Result*

*SHORT LISTED, HOLD, SELECTED AND REJECTED

Follow up details for an order of given client

Client

E-mail

Sales Order Number

Contact person name

Address

Vacancy name

No of Vacancies

Consultant name

Branch

Mode of communication

Date of follow up (Chronologically)	Activity of follow up	Outcome of follow up	Next follow up date if any

Follow up with candidate (for a given Period)

PEN	Name
E-mail	Address

Follow up with candidate (for a given Period) (Continued)

Sales order no	Vacancy name
Consultant Name	No of Vacancy
Branch	Client name

Activity	Date	Out Come	Next follow up date	Mode of communication

Client wise Expected date of joining

Client name

Sales order no

Consultant Name

Branch

Vacancy name

No of Vacancy

PEN	Name	Expected date of joining

Details of Compensation received for an order

Sales Order Number	Client name	Vacancy name	No of Vacancies	Consultant name	Branch	Gross Annual Compensation
PEN	Candidate name			Date of joining

Compensation details remaining to be received for an order

Sales Order Number	Client name	Vacancy name	No of Vacancies	Consultant name
PEN	Candidate name			Branch
				Date of joining

Compensation Details

As per Format (Ref. SRSCF01)

53. Invoice

As per Format (Ref. SRSIN01)

54. Invoice (for Final Payment) summary (client wise) for given period month wise

Client name	Contact person
From month:	To month:
Month	No of Invoices (1)

55. Invoice (for Final Payment) summary (Consultant wise) for given period month wise

Consultant name	Branch
From month:	To month:
Month	No of Invoices (1)

56. Invoice (for Final Payment) summary for given period month wise

From month:	To month:
Month	No of Invoices (1)

57. Invoice (for Final Payment) summary date wise for given period

From date:	To Date:
Date (Reverse Chronologically)	Invoice number

58. Invoice (for Final Payment) summary (consultant wise) for given period

Consultant Name	Branch
From date:	To Date:
Date (Reverse Chronologically)	Invoice number

59. Out of pocket Expense Invoice Client wise

Client Name	SON	Consultant	Email	OOP Expense Invoice	Tel	Payment Received	Balance out standing
			Inv. NO	Date	Value	Cheque No.	Date

60. Out of pocket Expense Total

OOP Expense Invoice	SON	Client	Vacancy
Value Amt.	Date	Inv. No

61. Client List on order value for a given period

Client list for the period from
From Date:	To Date:
Sr. No.	SON

**(Inclusive of advance payment + progressive payment + Final payment)

62. Client List on order value for a given period (function wise)

Client list for the period from
From Date:	To Date:
Function
Sr. No.	SON

**(Inclusive of advance payment + progressive payment + Final payment)

63. Client List on order value for a given period (Industry wise)

Client list for the period from
From Date:	To Date:
Industry name
Sr. No.	SON

**(Inclusive of advance payment + progressive payment + Final payment)

64. Client List on order value for a given period (Vacancy wise)

Client list for the period from
From Date:	To Date:
Vacancy name
Sr. No.	SON

**(Inclusive of advance payment + progressive payment + Final payment)

65. Janam Kundli (client)

It will be a super-menu through all the related report will be triggered.

66. Janam Kundli (candidate)

It will be a super-menu through all the related report will be triggered.

Candidate History
Candidate name	PEN
Contact details:
Residence phone number
Email
Office phone
Mobile number
Address

Interviews Attended
Date of interview (Reverse chronologically)	Vacancy name

Resume Sent
Date resume sent	Vacancy name

* (Short listed / Waitlisted / Appointed / Rejected)

** (Short listed for preliminary interview / short listed for final interview / rejected)

67. Executive Placed summary (Industry Wise) (for a given Period)

Industry name
PEN

68. Executive Placed summary (Function Wise) (for a given Period)

Function
PEN

69. Executive Placed summary ( Vacancy Wise) (for a given Period)

Vacancy name
PEN

70. Executive Placed summary (Client Wise) (for a given Period)

Client name
PEN

71. Executive Placed summary (Joining Date Wise) (for a given Period)

Joining Date (Reverse Chronologically)	PEN	Candidate name	SON	Client name	Vacancy name	Function	Industry name	Consultant	Annual compensation

72. Executive Placed summary ( Annual Compensation Wise) (for a given Period)

Annual compensation (Descending)	PEN	Candidate name	SON	Client name	Vacancy name	Function	Industry name	Consultant	Joining Date

73. Executive Placed summary complete list (for a given Period)

Joining Date	PEN	Candidate name	SON	Client name	Vacancy name	Function	Industry name	Consultant	Annual compensation

74. Analysis of order Executed Summary (Industry Wise)

Period
From month:	To month:
Industry name	Total no. of orders executed

Total	\sum

75. Analysis of order Executed Summary (Function Wise)

Period
From month:	To month:
Function name	Total no. of orders executed

Total	\sum

76. Analysis of order Executed Summary (Designation Level Wise)

Period
From month:	To month:
Designation Level (alphabetically)	Total no. of orders executed

Total	\sum

77. Analysis of order Executed Summary (Industry Wise Details)

Industry Name
From month:	To month:
Sales Order No.	Client name

Total

78. Analysis of order Executed Summary (Function Wise Details)

Function Name:
From month:	To month:
Sales Order No.	Client name

Total

79. Analysis of order Executed Summary (Designation Level Wise Details)

Designation Level:
From month:	To month:
Sales Order No.	Client name


Total

80. Analysis of order Executed Summary (Total) for a given period

Tabular form

From month / year:	To month / year:
Sales Order No.	Client name


Total

Graphical form

Plot of cumulative percentage of order value (y-axis) against cumulative percentage of no of orders executed (x-axis)

81. Out standing Client wise

Client Name	SON	Consultant	Email	OOP Expense Invoice	Tel	Payment Received	Balance out standing
			Inv. NO	Date	Value	Cheque No.	Date

82. Out standing Consultant wise

Client Name	SON	Consultant	Email	OOP Expense Invoice	Tel	Payment Received	Balance out standing
			Inv. NO	Date	Value	Cheque No.	Date

Note:

For the reports the filter for the records wherever applicable is to be given by the user. The system shall ask the following parameters wherever applicable and the results will be filtered based on the same.

Date from date to date (in DD/MM/YYYY format)
Company (from company name to company name)
Division (from division name to division name)
Branch (from branch name to branch name)
Consultant (from consultant name to consultant name)
Candidate/Client (from respective name to other)

All the reports shall preferably be produced as print image file. The user shall be provided with the option to view the report and then print if required.

Applitech Solution Limited Order Execution System Change Request Form No. 1

Project Name	3P Placement Consultant Pvt. Ltd.
Project Leader	Mr. Neeraj Rathi
Changes Referred To	Functional Specification
Changes Request By	Client
Changes Authorized By

Change Request Form

Date: 10/12/2001

Change Number	Change Description	Priority¹
1	Add an additional field for Mobile Number where Phone Number is mentioned.	L
2	Add one more text box address 3	L
3	Date format should be DD/MM/YYYY	L
4	Keep Pincode Varchar2	L
5	Use Position Name in the place of Vacancy Name	L
6	Source should appear along with PEN. The existing data base gives the information	M
7	The label of these masters should start with "3P". For example "3P Branch Master" 1) Company Master 2) Division Master 3) Branch Master 4) Financial Year Master 5) Currency Master	L
8	Edit button should be included	M
9	"Add Mode" will be default Mode	L
10	Increase the width of Company Drop down	L
11	Put "Quit" Button on Login Screen	M
12	PAN should be optional in 3P Company Master	L
13	Branch Code should not be auto generated. The field should be of 3 characters with varchar2	M
14	Put option buttons 3P Branch/Franchisee in 3P Branch. Labels for four fields should be changed	L

¹ High, Medium, Low as defined by the Client.

Applitech Solution Limited Order Execution System Change Request Form No. 1

Change Number	Change Description	Priority¹
15	changed	M
16	Currency Code should not be Auto Generated User have to enter. varchar2 - length 3	L
17	Remove currency Short Name	L
18	Change "Currency Description" to "Remarks" for 3P Currency Master	L
19	Currency Code should be as per "Reuter" to be fed by user	-
20	Country Code should not be Auto Generated	M
21	Country Code will be according to International Code & User have to enter it. Example 091-India & 001 - USA - Varchar2 length 4	-
22	Industry Code will not be Auto Generated & User has to enter that code - varchar2 - length 4	M
23	Designation Code should be Auto Generated & User has to enter that code. 3 character	M
24	Change "Designation Description" to "Remarks"	L
25	Remove "Designation Type"	L
26	Client master: i) Client Master will be Branch Specific ii) Client Code AHMA0001 Where AHM = Branch Code A to Z - 4 Digit Number.	H
27	Following Fields will be Mandatory in client master other than already specified 1) Industry 2) Parent Group (o) 3) Source of Information	L
28	One field Should be added "Legal Company Name" in client master	L
29	Function Master: 1) Change "Functional Description" to "Remarks" 2) Remove Function Type 3) Put "%" sign behind % fields 4) Function Code will not be Auto generated	L
30	Ally Master: 1) Add one field Group Code in table for future expansion of	M

Applitech Solution Limited Order Execution System Change Request Form No. 1

Change Number	Change Description	Priority¹
	Marketing Module. Field to be made on screen which is optional.
31	2) Ally Code is Mandatory and it will not be Auto Generated 3) Put Following fields: i) Resume Rate Indicator for Rs / % ii) Charge per Resume Indicator for Rs/%	L
32	Employee Master: 1) Designation Should be free text and Optional	L
33	Rate Contract Master: 1) Remove Client's Parent group	L
34	Inquiry Transaction: 1) Initiator field should be added 2) Replace "Head Hunting" To "Search" 3) Replace "Data Search" To "Data Bank" 4) Remove "Position Temporary or Permanent" 5) Remove "Hours (Full Time)" 6) Remove "Hours (Part Time)" 7) Add Designation Field in "Resume Forwarding Details" 8) Expected Date of sending Proposal should be date of Inquiry date + 1 (Ignore Sunday) 9) Make Following Field Mandatory i) Currency ii) Posting City iii) Country iv) Contact Person	M
35	Proposal: 1) Add Expected Date of Response 2) Change "Total Amount" to	M

Applitech Solution Limited Order Execution System Change Request Form No. 1

Change Number	Change Description	Priority¹
	"Max Amount to be charged"
36	3) Make Following fields optional i) Cost Head ii) Max Amount iii) Activity Phase iv) Particulars v) Remarks
37	Proposal Ammendment
	i) Add Expected Date of Response	M
	ii) Change "Total Amount" to "Max Amount to be charged"
	iii) Make Following fields optional
		i. Cost Head
		ii. Max Amount
		iii. Activity Phase
		iv. Particulars
		v. Remarks
38	Sales Order: 1) Change all schedule Date from Optional to Mandatory	L
39	Advertising Details: 1) Change Date of approval to Mandatory	L
40	Candidate Listing: 1) Change "Preliminary shortlisting" to "Preliminary Interview" 2) Change "Contact Agency" to "Source which will come from 'Cyrill'!"	L
41	Preliminary Interview Score Sheet	H
	1) Scoring Pattern should be as follows: i) Out standing ii) Good iii) Acceptable iv) Not Suitable
	2) Change "Total Assesment Score" to "Overall Assessment"
	3) Following Fields should be shifted under "Assesment Sheet"

Applitech Solution Limited Order Execution System Change Request Form No. 1

Change Number	Change Description	Priority¹
	i) Strengths
	ii) Weaknesses
	4) Remove "Exposure to ERP" & Contribution to the Organization
	5) Change "Expected Joining Date to "Notice Period (In Days)"
	6) Add Following Fields: i) Car (Owned/Company/Leased & Confidential Remarks (Which will not be Printed) should be Added
	7) 3 Reference should be added. The details of reference should be
		i) Name
		ii) Company
		iii) Designation
		iv) Address
		v) Telephone
		vi) Mobile
		vii) Email
		viii) Fax
	8) Add "Number of People Reporting to Him"
42	Interview Schedule/Reschedule
	i) Schedule, Reschedule, Print option should be there.
	ii) Interview Schedule & Reschedule Change label "Other Information" to "Detail Reimbursement" etc.
	iii) Date/Time should not be visible to Client
43	Compensation Detail: 1) All Salary Details are Optional 2) E should be added 3) Annual Gross (Total * 12)	L
44	Fees Received: 1) Following should be Mandatory	L

Applitech Solution Limited Order Execution System Change Request Form No. 1

Change Number	Change Description	Priority¹
	i) Copy of Resignation Letter Received
	ii) Copy of Offer Letter Received
	iii) Ref Check Done
45	Prospective Candidate: 1) Add Following Fields i) Mobile (M) ii) Email(M) iii) Reports to (O) iv) Designation (O) 2) Remove "Search" - just mode of Search	L
46	Check List for Project Closure: 1) Remarks Should be at Bottom	L
47	Resume Sale: 1) In purpose - Replace Consultants with Sales Executive 2) Remove Cash from Mode of Receipt 3) Invoice should be Printed (Mentioned in R.C.) 4) Make Following Fields Optional i) Bank Name ii) Place 5) Add Wire Transfer	H
48	Fee Receipt Detail: 1) Remove Cash from Mode of Receipt	L
49	All Master will be Company, Division, & Branch independent only created at H.O. 2) Only Client Master will be Branch Wise	H
50	Menu entry by client	H

Applitech Solution Limited Order Execution System Change Request Form No. 2

Project Name	3P Placement Consultant Pvt. Ltd.
Project Leader	Mr. Neeraj Rathi
Changes Referred To	Functional Specification
Changes Request By	Client
Changes Authorized By

Change Request Form

Date: 10/12/2001

Change Number	Change Description	Priority¹
Additional requirements
1	State Master	H
2	Legal Company Master	H
3	Preliminary Interview order wise (Report)	H
4	Preliminary Interview Parent Group wise (Report)	H
5	Parent group wise Bio data sent (from date to date) (report)	H
6	Parent group wise interview held (from date to date) (report)	H
7	Ally wise order (report)	H
8	Ally wise bio data sent (report)	H
9	Send e-mail for reference check	H
10	Regret letters (e-mail) 3 type	H
11	Current status client wise date wise For which details are as follows: Sales order no Invoice no Date of invoice Amt. Of invoice Amount received so far TDS amt. Closure Status Reason for Closure Remarks	H
12	Scheduler (menu screen of reports as mentioned below which pop up on login by consultant) 1. Inquiry for which proposal are yet to be sent 2. Proposal which are yet to be confirmed by client 3. Son's against which min fees are yet to be received	H

¹ High, Medium, Low as defined by the Client.

Applitech Solution Limited Order Execution System Change Request Form No. 2

Change Number	Change Description	Priority¹
	received
4	Sons for which "candidates short listed" list yet to be sent to client
5	Sons for which preliminary screening yet to be completed
6	Sons for which client still to conduct "final interview"
7	Son wise "appointees" for whom client yet to send com-details

Advertising Details for a client (for a given Period)

List of Reports

Monthly Shopping Basket Summary (for a given Period)
Shopping Basket Summary (URL wise)
Shopping Basket Statement (for a given Period)
Shopping Basket Designation level wise (vacancy wise) (for a given Period)
Shopping Basket (Function wise) for a given Period
Shopping Basket (Industry wise) (for a given Period)
Shopping Basket (Client wise) (for a given Period)
Shopping Basket Consultant wise (for a given Period)
List of inquiry for a given period
List of inquiry for a given period (consultant wise)
List of inquiry for a given period (Industry wise)
List of inquiry for a given period (Function wise)
List of inquiry for a given period (vacancy wise)
List of inquiry for a given period (City wise)
List of inquiry for a given period (Country wise)

16. Number of Inquiries remaining to be answered (consultant wise)

17. List of inquires which did not convert in to an order (Consultant wise)

18. Inquiry Status (Consultant wise)

Proposal

As per format (Ref. SRSPR01)

Sales Order

Standard letter format to be given by 3P

Project Plan for a sales order
Project Variance for sales Order

23. Pending order for a consultant chronologically

24. Pending order for a consultant (client wise)

25. Pending order for a consultant (Vacancy Name wise)

26. Pending order for a consultant (Estimated Billing Value wise)

27. Pending order for a client chronologically

28. Pending order for a client (consultant wise)

29. Pending order for a client (Vacancy Name wise)

30. Pending order for a client (Estimated Billing Value wise)

31. Pending status for a given period (industry wise)

32. Pending status for a given period (function wise)

33. Pending status for a given period (designation level wise)

34. Load on consultant

35. Resumes remaining to be sent (order wise)

36. Resumes sent out for an order

37. One line statement (for consultant)

As per Format (Ref. SRSOL01)

38. One line statement (for client)

As per Format (Ref. SRSOL01)

(This statement will not have the contact numbers and the agency contact as per the format)

39. Details of prospective candidate

As per Format (Ref. SRSPC01)

40. Advertising Details for a client (for a given Period)

41. Advertising response (client wise) (for a given Period)

42. Advertising response (media wise) (for a given Period)

43. Interview call sent out for an order

44. Interview Schedule for Sales Order

45. Interview held Summary Client wise

46. Interview held Summary

47. Follow up details for an order of given client

48. Follow up with candidate (for a given Period)

49. Client wise Expected date of joining

50. Details of Compensation received for an order

51. Compensation details remaining to be received for an order

52. Compensation Details

As per Format (Ref. SRSCF01)

53. Invoice

As per Format (Ref. SRSIN01)

54. Invoice (for Final Payment) summary (client wise) for given period month wise

55. Invoice (for Final Payment) summary (Consultant wise) for given period month wise

56. Invoice (for Final Payment) summary for given period month wise

57. Invoice (for Final Payment) summary date wise for given period

58. Invoice (for Final Payment) summary (consultant wise) for given period

59. Out of pocket Expense Invoice Client wise

60. Out of pocket Expense Total

61. Client List on order value for a given period

62. Client List on order value for a given period (function wise)

63. Client List on order value for a given period (Industry wise)

64. Client List on order value for a given period (Vacancy wise)

65. Janam Kundli (client)

It will be a supermenu through all the related report will be triggered.

Janam Kundli (candidate)

It will be a super-menu through all the related report will be triggered.

Executive Placed summary (Industry Wise) (for a given Period)
Executive Placed summary (Function Wise) (for a given Period)
Executive Placed summary (Vacancy Wise) (for a given Period)
Executive Placed summary (Client Wise) (for a given Period)
Executive Placed summary (Joining Date Wise) (for a given Period)
Executive Placed summary (Annual Compensation Wise) (for a given Period)
Executive Placed summary complete list (for a given Period)
Analysis of order Executed Summary (Industry Wise)
Analysis of order Executed Summary (Function Wise)
Analysis of order Executed Summary (Designation Level Wise)
Analysis of order Executed Summary (Industry Wise Details)
Analysis of order Executed Summary (Function Wise Details)
Analysis of order Executed Summary (Designation Level Wise Details)
Analysis of order Executed Summary (Total) for a given period

Graphical form

Plot of cumulative percentage of order value (y-axis) against cumulative percentage of no of orders executed (x-axis)

Out standing Client wise
Out standing Consultant wise

Note:

For the reports the filter for the records is required to be given by the user. The system shall ask the following parameters wherever applicable and the results will be filtered based on the same:

Date from date to date (in DD/MM/YYYY format)

Company (from company name to company name)
Division (from division name to division name)
Branch (from branch name to branch name)
Consultant (from consultant name to consultant name)
Candidate/client (from respective name to other)

All the reports shall preferably be produced as print image file. The user shall be provided with the option to view the report and then print if required.

APPLITECH SOLUTION

www.applitechsolution.com

Commerical Offer

Q.No: ASL/BOM/KS/3P-CR/1

February 21, 2001

S.No	Description	Price (In Indian Rupees)
1	Cost estimation for the additional work as per the Change Request( enclosed) and the generation of reports ( as per list enclosed) Includes:	2,83,500.00
	> Scheduler module
	> Additional work as mentioned in the Change Request
	> Reports generation for 92 reports (including 10 reports mentioned in Change Request). List of 82 reports enclosed.
Total		2,83,500.00

Rupees Two Lakhs Eighty Three Thousand and Five Hundred only

Terms and conditions:

Validity: 30 days

Payment Terms:

30% along with the amount payable after submission of Design documents
30% along with the amount payable after prototype submission
20% along with the amount payable after project sign off

Mode of Payment: crossed Cheque/Demand Draft payable in Mumbai in favor of Applitech Solution Ltd

All other terms and conditions as given in our offer dated 20^{th} August 2000 for Order Processing Module

For Applitech Solution Ltd

(Signature)

K.Sudhakar

Manager- Sales

V. URGENT HCP NIRMIT

From: neeraj rathi [neerajr@asl.com]

Sent: Wednesday, January 17, 2001 7:27 PM

To: hcp; nagle; nirmit

Cc: bombay office; Sudhakar K

Subject: Customer Update

I suppose you have refined in consultation with Mr. Nagle 19/01.

Dear Sir,

We thank you for the courtesy extended to our team during their visit to your office on 4th & 5th of January, 2001.

We have stared making changes in the Functional Specification as per the changes pointed out by you during the visit of Tapan Shah and Yogesh Patel. Our Functional Specification has gone for internal review and we will be sending you the revised copy of the same as soon as it is finalized for your ready reference.

We are doing impact analysis of the new requirements and the modifications as suggested by you. We will send the Change Request Form to you along with new estimate and the revised schedule and will incorporate the changes only after your approval for the same is received.

While on the subject of New requirements we would like to inform you of our interpretation/understanding of Scheduler as per the hand written note given by Mr. HC Parekh on 5th January, 2001.

For the sake of simplicity the same is explained stepwise

The consultant logs in with his login name and password
The system validates the same and opens a screen Titled "Good Morning" & "Alert Statements"
The screen will show the various Project Plan Activities/ Stages like Inquiry, Proposal, Sales Order, Advt. Details, Candidate Listing, Prem. Screening, Resume Dispatch, Interview, Compensation Details.
The consultant can select any one of the above mentioned options.
Once selected a predefined report, for the option selected, will be displayed. The relevant list of reports and their formats has been mentioned in the note given to us.
These reports will display all the records which are open as on the system date.
These reports will help the consultant to determine the pending works.
There after the consultant may either view pending works for another option or enter the main OES system or logout as per his wish.

During the visit of Tapan Shah and Yogesh Patel at your Mumbai office the following issues were raised.

3P Consultant will do search on Cyrill system and the search result will be available to OES. To save search result in Cyrill database 3P consultants have to make Assignment in Cyrill then 3P consultant will able to save selected candidate from the search result. Each search result in Cyrill is Assignment based, so to access particular search result OES will need Assignment Name that should be unique

for each assignment. 3P Consultants have to make Assignment in Cyrill whose name will be equal to SON (which is generated by OES). After Assignment is saved and search is completed, OES will access relevant table of Cyrill to access data. For this OES should have access to relevant tables of Cyrill database.

Note : In Cyrill, there is no constraint for duplicate Assignment Name i.e., Consultant can make more than one assignment whose names are equal. If 3P consultants make more than one assignment of one SON then all the search result will be merged in OES system.

Cyrill system is of client server architecture. The database of Cyrill lies at 3P Consultants Pvt. Ltd.- Marol Branch. OES system has web based architecture. The database of OES will be on Web server. To access Cyrill database from OES following will be requited :

Cyrill database must be available at all times.
Cyrill database must have fixed IP address.

Please specify strategy for same, as this is very crucial requirement for OES.

To access mails of Shopping Cart, OES will need dedicated mail account at SMTP mail server of the OES web server. In present situation all the Shopping Cart mails goes to nirmit@bom3.vsnl.net.in, as decided Net Administrator of 3P will forward Shopping Cart Mails to OES mail account.

Please look in to these issues, as these issues would affect the development and the integration of the system during implementation. Tapan and Yogesh have already pointed out these issues to Mr. Nagle over the Phone during their visit. Please look in to these points and revert back to us as soon as possible.

YOU ARE REQUESTED TO CONFIRM YOUR UNDERSTANDING OF THE SCHEDULER TOMORROW ITSELF SO THAT THE CHANGE MAY BE FINALIZED AT THE EARLIEST.

Warm Regards,

Neeraj Rathi

FROM: APPLITECH SOLUTION PHONE NO.: 91796569489 Aug. 07 2000 07:23 PM P1

HCP Nirmit/CMT/Mitchell

What we will ultimately get out of the Order Execution Module, depends directly on our own, deep, involvement with Applitech team. Not only we have to be very clear what we want the system to deliver, but we have to give that in writing to Applitech - and FAST.

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, I 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 realise that these are extremely important and urgent for us, as they affect all the points mentioned below:

Architecture Information - Mr. Nagle will give
Freezing of requirements (without which tools can not be started)
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.

I am still awaiting feedback from CMT/Mitchell

We have received your feedback on the reports but it lacks the following:

Suggestions on the content and the data fields (if any fields have to be added/ deleted)
Feedback on Sorting order for each report
Sample data
The formats of the reports like janam kundli etc. as requested in report formats send to you (reports nos. 27, 42, 43)
Details if a report is to be Printed or not along with frequency etc. (last page of the report format document dated 18/10/2000)

We appreciate your efforts in grouping these reports logically and will certainly find these effort valuable, but the above points definitely requires more 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 no5) CMT was to send to Tapan
Format of the checklist to be given by 3P latest by 15/10/2000. (Point no13)
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.

Aug. 07 2000

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 write-up 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

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
Ms. Michelle
Mr. Nagle
Mr. Cyrill

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.

Thursday, 27 December 2001

CHANGE REQUEST