MOTILAL NEHRU NATIONAL INSTITUTE OF TECHNOLOGY ALLAHABAD-211 004 (U.P.) INDIA Telephone No.: 91-532-227 1123, 91-532-227 1122 Fax No.: 91-532- 2545822(Direct), 91-532-2545341, 91-532-2545677 GRAM: MNNIT WEB SITE: www.mnnit .ac.in No.991 Date: 23.12.2010 To, Subject: Expression of Inte rest (EOI) for Workflow Automation of Institute Dear Sir, Please find enclosed herewith the EOI No.013/EOI/Automation/SPO/2010. The last date & time for submitting the offer is 17-01-2011 by 12:00 Hrs in the Store & Purchase Office of the Institute. Thanking you, Yours faithfully [Faculty In-charge, (Purchase)] MOTILAL NEHRU NATIONAL INSTITUTE OF TECHNOLOGY (An Institute of National Importance declared by NIT, Act 2007, GOI) ALLAHABAD-211 004 (U.P.) INDIA Expression of Interest (EOI) For the Workflow Automation for Institute Telephone No.: 91-532-227 1123, 91-532-227 1122 Fax No.: 91-532- 2545822(Direct) ,91-532-2545341, 91-532-2545677 WEB SITE: http://www.mnnit.ac.in E-mail: Spo@mnnit.ac.in Motilal Nehru National Institute of Technology, Allahabad Pre-qualification for call for Tender for Institute workflow automation application Software Motilal Nehru National Institute of Technology, Allahabad wishes to get the entire workflow of the select offices/activities of Institute automated. MNNIT desires to develop a modern state of the art SMART OFFICE comprising of Campus Wide Network through which the official functions will be transacted so that the paper work is minimized to great extent. This Network is integrated with the Internet. There should be adequate provision for the security in the system so that it is not vulnerable to hacking. It is envisaged to have on line application processing (distributed) & data inter-change with the State Govt. /Central Govt. offices and others. The software should be capable of message handling for message received through Internet/Network. Sealed Expression of Interests are invited from reputed Registered IT Companies which have experience in Application Software Development and Implementation in Government Departments/ Central and state universities and institutions. Total estimated cost of the application software to be development; implemented and maintained for 5 years is approximately ` 30.00 Lakhs. Prequalification Tender forms can be downloaded from the Institute website www.mnnit.ac.in or can be obtained from the office of the Store and Purchase during working hours from 24/12/2010 to 17/01/2011. Filled in prequalification tender document in the prescribed form along with security deposit of ` 5,000.00 in the form of demand draft in favour of “Director, MNNIT, Allahabad” payable at Allahabad. The form should be duly signed by authorized person of the firm should reach the office of the Faculty In-Charge (Purchase), MNNIT, Allahabad on or before 17/01/2011, 12:00 Hrs. The institute wishes to automate the following workflow process (details are available in Annexure VII) in the first phase of automation: 1. Store Purchase Module a. Store, Purchase and Distribution Management sub- module b. Asset Management sub- module 2. Account Section Module a. Accounting and Financial Management sub- module b. Budget Monitoring sub- module c. Financial Accounting sub- module d. Student‟s Accounting & Management sub- module e. Departmental Grants Accounting & Management sub- module f. Establishment (HR) Management sub- module g. Payroll Accounting Management sub- module After successfully completion of first phase, the second phase of automation with workflow process given in Annexure VIII will be executed. The firm must provide the proposal for first phase and second phase separately. Prequalification Criteria a) The firm must have competency to develop, implement and maintain workflow automation application software (using open source technology) in a Government Departments/ Central and state universities and institutions. b) The firm should have minimum three years of experience of developing, implementing and maintaining workflow automation application software to educational institutions. c) The firm must be an ISO 9000-2004 certified organization. d) The firm must be financially sound to execute the work order and must have an annual turn over of more than Rs. 1 crore continuously for last three financial years. General Terms and Conditions: 1) The firm should be registered with Income Tax and Sales Tax Departments (Registration Numbers should be clearly mentioned and valid documentary evidence be attached). 2) The firm should have a minimum three years of experience of similar assignment and should have proper office and development centre in India. 3) When a quotation is called for develop, implement and maintain workflow automation application software for the select processes of the Institute, the firm will be required to submit a Earnest Money Deposit (EMD) at the rate of minimum two percent of total value of the contract in the form of Pay Order, in favour of Director, MNNIT, Allahabad, payable at Allahabad,. 4) As and when a purchase work order is placed on the firm, it will be required to deposit a “Performance Bond” amounting at least 5% (exact amount will be specified in the order) of the total value of the contract/work order in the form of FDR/Bank Guarantee in favour of Director, MNNIT Allahabad, payable at Allahabad. In case the firm/supplier fails to deposit performance security within one week of the receipt of work order, the same shall be treated as cancelled and the earnest money shall be forfeited. 5) 2% earnest money deposit, if not adjusted in the 5% “Performance Bond” will be released to the firm after deposit of 5% performance bond. The performance bond will be released to the firm after one month of successful completion of the work order and acceptance by MNNIT in accordance with the laid down specifications and time frame and completion of the guaranty/warranty/maintenance period of the Application Software developed; failing which the performance bond shall be forfeited in favour of MNNIT, Allahabad. 6) Payment of the bills will be subject to the deduction of Government Taxes/Levies. The Major Mile Stones of the Project shall be a. Start of the Project b. Approval of BPD/SRS c. Commissioning of on- line software systems d. Application Acceptance for all the locations e. Maintenance of the software for 5 years The Payment Terms for Application System shall be a. 10% of the cost after approval of BPD/SRS b. 40% of the cost after commissioning ( The firm shall provide source code of all the applications used in the systems.) c. 10% of the cost after submission of user manuals, tutorials and users‟ training d. 20% of the cost after successful maintaining the application for first two years e. 20% of the cost after successful maintaining the application for next three years 7) The proposals duly filled in the format with Annexure I, III, IV, V and VI are required to be submitted in the office of the undersigned by January 17, 2011, 12:00 hours. The Committee will open the proposals for evaluations as per criteria given at Annexure-II on a suitable date. 8) The Assessment Criteria is attached (Annexure II). 9) MNNIT, Allahabad reserves the right to accept or reject any or all proposals or extend the closing date without assigning any reason. (Faculty In-charge Purchase) MNNIT, Allahabad Annexure - I Motilal Nehru National Institute of Technology Allahabad – 211004 Pre-qualification Proposal for call for Tender for Institute workflow automation application Software Name of the firm Address (Telephone, Fax & E-mail) Year of Establishment Sales Tax Registration No. (documentary evidence attached) Income Tax No. (documentary evidence attached) Banker‟s Name & Contact Details Annual Turnover supported by income tax return (For the FY 2007-08, 2008-09, 2009-10) Assignments in Hand, presently (Attach separate sheet as per Annexure III) Clientage Attach separate list as per Annexure IV Managerial/Technical Capability a). Total No. of Permanent Staff: Technical__________+Support______=_________ b). Total No. of Contract/Project Staff Technical__________+Support______=_________ attach separate Annexure (if necessary) Details of Machinery & Equipments (Attach on separate sheet as per Annexure V) Enlistment Certificate (Copy of certificate enlisted with Government/Semi Govt. organizations, if any) Affidavit (that the firm has not been blacklisted by private, Government, Semi-Government and Autonomous Body) ISO Certification along with proof document Contact Person Date__________________ ________________________ Name & Designation _______________________ Authorized Signature & Stamp Annexure - II Motilal Nehru National Institute of Technology Allahabad – 211004 Pre-qualification for call for Tender for Institute workflow automation application Software ASSESSMENT CRITERIA The Pre-qualification proposals for call for tender for Institute workflow automation application Software will be evaluated as per the following criteria; Crite ria Marks Experience related to the similar assignments 20 Annual Turnover supported by income tax return 20 Development methodology to be adopted for workflow automation 30 application Software development, implementation and maintenance and sample works carried out in the similar area. Educational/ Professional qualifications and experience of the staff 20 As per Annexure V Clientage 10 Total 100 Note: Minimum score required to pass for Pre-qualification is 60% Annexure III PARTICULARS OF CURRENT PROJECTS IN PROGRESS/AWARDED PARTICULARS OF PROJECTS UNDER EXECUTION OR AWARDED S. No. Name of work/project Name of Cost of works Stipulated Stipulated Up to date Slow Name and Remarks and location (Give brief client owner in crores of date of start date of percentage progress address/phone of nature of work) Role or rupees as per completion progress if any no. of officer in project as main sponsoring Estimated cost agreement of work and to whom contractor or NSC, organization put to tender Actual date reasons reference may State name of main Tendered cost of start thereof be made contractor) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Certified that the above list of works is complete and no work has been left over and that the information given is correct. Signature of applicant (s) Annexure - IV Motilal Nehru National Institute of Technology Allahabad – 211004 Pre-qualification for call for Tender for Institute workflow automation application Software Details of all works of similar class/nature completed during the last three years ending last day of the December 2010 S.No. Name of Owner or Cost of works Stipulated Stipulated Litigation/ Name and Give brief Remarks work/project and sponsoring in crores of date of start date of Arbitration address/phone reason for location (Give brief organization and rupees as per completion Pending/in no. of officer delay in of nature of work) designation Estimated cost agreement Actual date progress to whom execution Name of officer put to tender Actual date of with reference may signing Tendered cost of start completion details * be made agreement (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Certified that the above list of works is complete and no work has been left over and that the information given is correct. Signature of applicant (s) Annexure - V Motilal Nehru National Institute of Technology Allahabad – 211004 Pre-qualification for call for Tender for Institute workflow automation application Software Educational/ Professional qualifications and experience of the project staff Please provide detail o f the project team members in the fo llo wing fo rmat Date of Awareness of l ocal Experience in Software Sl Joining the language (Hindi) to Person Name Designation Qualification Age Workflow development No organization communicate with automati on work tools known system users Signature of applicant (s) Annexure - VI Motilal Nehru National Institute of Technology Allahabad – 211004 Pre-Qualification for call for Tender for automation application Software Format for Affidavit [Rs.100/- (Rupees Hundred only) Stamp Paper duly notarized] To, The Director Motilal Nehru National Institute of Technology Allahabad - 211004 With reference to the documents submitted, we hereby undertake that at no point have we entered into any dispute / litigation / legal proceedings against any of our clients, in any of our projects, within the last 10 years, i.e. during financial years 2000-2010. All documents and information submitted for EOI for prequalification (including the above undertaking) are certified to be accurate, correct and final. In the event that any of the documents or information submitted by us is found to be in-accurate / incorrect / mis-leading, we understand that our qualification through the process of Expression of Interest is liable to be cancelled / Contract is liable to be terminated, without prejudice to any of the rights of Motilal Nehru National Institute of Technology, Allahabad, which otherwise may accruable to Motilal Nehru National Institute of Technology, Allahabad. S/d Authorized Signatory (Power of Attorney enclosed) Annexure - VII Motilal Nehru National Institute of Technology Allahabad – 211004 List of Modules for First Phase Automation 1. Store Purchase Module A. Store, Purchase and Distribution Management Sub- Module a. Approval of Purchases b. Provide for instant information of previous purchase history to help take more informed purchase decisions c. Provide for better work planning by giving on- line information of delivery schedules and status of pending purchase orders d. Provide for Material Booking against estimate number e. Improve decision making by providing on- line inventory positions and status in all the stores of MNNIT f. Identify non-moving / slow moving items g. Provide on- line information of material at site h. Project accurate material requirements in stores i. Receipt of all material from different vendors and delivery challans j. Keep record of all bills, challans and invoices k. Maintain inventory account of the items l. Purchase Order Modification m. Inspection at Store n. Possible to stamp a single item or a group of items with a unique number for tracking purposes o. Issue of items to departments and sections on receipt of indents p. Interfacing with the account section for payments of the bills to vendors q. Disposal of old items. r. Bill of Materials s. Sales and Purchase forecasting t. Pricing and discounting on basis of dimensions u. Get overview of current on-hand situation per store so that procurement can be drill down to current on- hand situation per any item or storage dimension or combination of these v. Tools for tracking batch and serial numbers throughout the system w. Stock taking and item locations x. Easy access to individual customer prices and discounts y. Backorder handling z. Cost price principles: FIFO, LIFO, standard cost price, and weighted average aa. Individual cost price principles per item group bb. Ledger reconciliation cc. Allocation of Miscellaneous charges on Cost prices dd. Handling of Blanket orders ee. Automatically retrieve prices and discounts when entering orders B. Asset Management Sub- Module Maintenance of Asset Register i. Store information on asset status, financial transactions, technical data, location for tangible, intangible and financial assets ii. Display relations between assets Asset Acquisition iii. Purchase assets using purchase orders and inventory items iv. Record purchase invoices directly against assets v. System created acquisition proposals Asset Depreciation vi. Support for different depreciation methods (like straight line, reducing balance, factor, manual percentage and consumption) vii. User-defined base for straight line depreciation („Service life‟ or „Service life remaining‟) viii. Option for alternative depreciation and automatic selection of the biggest possible depreciation Asset Revaluation ix. Write- up and write-down of fixed assets x. Revaluation other than write-up and write-down xi. Revaluation proposal based on user-defined indexes Asset Disposal xii. Invoicing external sales of fixed assets xiii. Recording sales and scrap disposals using fixed asset journal xiv. User-defined automatic reversing of asset balances at disposal 2. Account Section Module A. Accounting and Financial Manage ment Sub-Module a. Bank reconciliation process is optimized. b. Pending approved bills information is available on line. c. Information of account code/group wise expenditure is available on line. d. Manual Process of conversion of „expenditure o n capital works to asset‟ is automated. e. Manual process of depreciation calculation is automated. f. Facilitate centralized monitoring of advance adjustments at fields. g. Generate Revenue Ledger, Capital Ledger, Trial Balance, Balance Sheet and Schedules for Accounts Section, based on trial balances. h. Help manage finance by making information like amount of passed bills in various projects B. Budget Monitoring Sub-Module i. Preparation of Annual Budget ii. Budget sanction to various heads iii. Total Budget Allocation under various heads iv. Reallocations, Re-appropriation and Revision of Funds v. Budget estimation vi. Maintenance of Funds available with the institute vii. Monthly Expenditure under various heads viii. Monitoring of Expenses in respective heads with projections C. Financial Accounting Sub-Module i. Double book entry system ii. Identification of account heads by unique account codes iii. Recording of transactions iv. Transaction posting v. Imprest statement vi. Advance settled/unsettled/refunded during a period vii. Claim settlements for a period viii. Statement of Account for a period ix. The Trial Balance x. Balance Sheet xi. Profit/Loss Account xii. Payment received through Challan, cheques or cash. xiii. Payment made through cheques or cash xiv. Receipts generation xv. Bills disbursal xvi. Bank reconciliation xvii. Daily Bank book xviii. The General Ledger Maintenance xix. The Cash Book Maintenance xx. The Journal Maintenance xxi. Opening and closing of day-books xxii. Generation of Day books, ledgers and sub- ledgers xxiii. Reports required by the government xxiv. Year-end closing of accounts xxv. Statement of outstanding loans/Interest xxvi. Cash Flow/Fund flow Analysis xxvii. Age-wise analysis of debtors and advances xxviii. Ageing analysis of Receivables & other Advances on user-defined period xxix. TDS certificate and reports D. Student’s (Fees, Dues, Scholarships, Contingency) Accounting & Management Sub-Module E. Departmental grants (imprest, advances and bills) Accounting & Management Sub-Module F. Establishme nt (HR) Management Sub- Module a. Integration of existing Pay Bills and final disbursal of Salary module. b. MIS of Posting of an employee. c. Transfer of records of employees from one o ffice to another. d. Calculation of Establishment Budget. e. Creation of posts f. Organisation Structure details. g. Recruitment h. Employee Identity Cards i. Promotion, Transfer, Probation and Confirmation details j. Pay fixation and increment details k. Educational qualifications, previous experience, present posting & current service details. l. Dependent/nominee details. m. Maintenance of Leave Record n. Deputations to & from the institute o. Resignation & retirement details p. ACRs, Performance reviews q. Statistical reports r. Visiting professors /Guest faculty details s. Disciplinary proceedings & suspension details t. Maintenance of details of Foreign visits, Training Courses, conferences, seminars & workshops attended by employees u. Accommodation details v. Faculty achievement management G. Payroll Accounting (optional) Management Sub-Module a. Salary Computation and Generation of Pay Bills and Pay Slips b. Generation of Bank Statements c. Arrears Calculation and generation of arrears report. d. Payment and Settlement of Advances and Claims viz. TA, Medical etc. e. Loan Recovery including interest calculation f. Payroll accounting for Domestic travel, leave accounting g. GPF & Pension Accounting and Payment / Advances h. GPF Payroll i. PF slip and ledger generation j. Calculation of Income Tax, TDS k. Generation of Income Tax statement l. Preparation of Form 16, 24A m. Maintaining separate book of accounts for PF Trust n. Support for multiple bank transactions o. Pension Calculation p. Family pension calculation q. Monthly pension statement – Bank r. Monthly pension statement – Cash s. Bank intimation sheet t. Commutation input u. Gratuity calculation v. Pension wise arrear payment w. Income certificate to pensioners for IT purpose x. Pensioner wise yearly payment information (For C-1) Annexure - VIII Motilal Nehru National Institute of Technology Allahabad – 211004 List of Modules for Second Phase Automation A. Director a. Camp office module management b. Statistical reports management c. BOG Management d. Heads & Deans Meeting Management e. Appointment B. Administrative Module a. Session calendar management including holidays, sports calendar, cultural calendar etc. b. Co-ordination of recruitments and admissions C. Senate Management Module a. SPGC/SUGC b. DPGC/DUGC c. Data base of academic programmes and courses, their nomenclature and codification d. Institute ordinances e. Updation of course details and syllabus details D. Academic Management Module a. Admission Sub Module (PG Admissions) i. General information about institute, courses and programs and ordinances ii. Queries handling iii. Notification for Admission iv. Workflow of selection procedure for candidates for MMS, M.Tech etc. where written tests/interviews are basis for evaluation. v. Issue/sale of Admission forms vi. Receipt of application Form vii. Application data entry OCR supported viii. Merit preparation (Multiple Criterion) ix. Offer of admission x. Document Verification & Capture xi. Issue of Admission letter xii. Fee receipt b. Admission Sub Module (UG Admissions) i. Enrolment of regular students on the basis of list forwarded by AIEEE ii. Preparation of registration lists for AIEEE for admissions made iii. Courses nomenclature and codification iv. Payment of fees and linking with accounts department v. Generation of seats availability for different courses vi. Verification of Students eligibility for courses vii. Generation of admission list on the basis of merit and eligibility viii. Offer of Admission ix. Receipt of Admission fees x. Verification and capture of documents submitted like migration certificates, letter forwarded from respective institutes c. Registration Sub Module (UG + PG) i. Online – Single Window Registration ii. Online NOC from Library, accounts, proctor office and hostels iii. Generation of Registration/Enrollment Number, and students record iv. Generation of Course details, student‟s eligibility, Tutor and seat availability v. Discipline/Branch Transfer vi. Accounts: Dues and Fees vii. Other Dues: Library, Hostel, SAC and Labs viii. Academic Registration: Past Results, Subject Registration ix. Eligibility verification, flexible registration and credit system management x. Physical registration xi. Flexible registration of courses so that slow track and fast track be made possible xii. Roll list generation d. Time Table Sub module i. Resource allocation of classrooms, availability of faculty members and courses, Academic Calendar ii. Rule based generation of timetable for different courses and programs. iii. Session calendar management including holidays, sports calendar, cultural calendar etc. iv. Students Database updation v. Room allocation to courses vi. Faculty database updation for different courses vii. Maintenance of hierarchy in each department viii. Attendance records of students in classes / labs/ field ix. Classes held by faculty and session progress report e. Academic Monitoring (Departme ntal Level) i. Classes held by faculty and session progress report ii. Attendance Record, collation, display & warning notes (also to parents), reports to condone from attendance iii. Mid sem/End sem examinations: conduction and disp lay of marks/grades iv. Makeup examinations and summer semester v. Updation of data base of evaluator and remuneration details vi. Students‟ leave management record vii. Student performance analysis f. Examination and Results (with Proper Security and Protection) i. Eligibility for examination ii. On line registration for examination iii. Generation of roll numbers iv. Issue of admit cards: generation and printing v. Preparation of examination schedule and seating plan vi. Absentee statement in examination/unfair means vii. Updation of database of received answer sheets, course /subject wise, examination centre wise, student wise viii. Updation of database of answer sheets distribution to evaluators with evaluation schedule : Course, subjects and remuneration details ix. Secured on line entry of internal assessment marks by faculty x. Consolidating all marks reports xi. Grading assistance xii. Credit Transfer xiii. Tabulation of grades and updation of tabulation register xiv. Preparation of merit list for all stages xv. Examination Results declaration xvi. Re-evaluation process including fees, changes in tabulation register, revised mark sheet, audit trail of changes xvii. Fee collection, printing, issuing of Marks sheet/ Duplicate mark sheet, transcripts, Provisional, Final Degrees (Calligraphic Printing) and Migration certificates, transfer certificate xviii. Convocation xix. After course is complete the records must be frozen g. Institute Development Sub Module i. Updation of courses details ii. Updation of syllabus details iii. Maintenance of agenda, minutes of Executive council and Board of Studies iv. Co-ordination for Statistical reports to UGC E. Students Affairs Management Module a. Generation of student list of different categories (hostel wise, programme wise, course wise & state wise etc.) b. Issue of Identity Cards /renewal/duplicate c. Fee adjustment/waving d. Educational loan Certificates e. Hostel sub module i. Issue of railway/air concessions f. Students Activity sub module i. Student achievement management g. Discipline i. Updation of student‟s record ii. Generation of student list of different categories (hostel wise, programme wise, course wise & state wise etc.) iii. Temporary Discontinuation and disciplinary actions iv. Issue of conduct/bonafide certificate h. Audit Trail of changes i. Scholars hip i. Scholarship application & scrutinizing ii. Renewals of applications iii. Claim bill preparation iv. Disbursement Bill preparation v. Stipend calculation based on the attendance report from the Departments vi. Register maintenance, Sanction Register, Claim Register, Monthly Stipend Register vii. Status enquiry of the registers viii. Proficiency awards F. Training and Placement Manage ment Module a. Company database management b. Company invitation management c. Slot management d. Up-to-date bio-data database management e. Placement status recording f. Reminder services g. Communication with company personnel h. Training program to students i. PPT management j. Test/Interview management k. History of Campus placements G. Research and Cons ultancy Manage ment Module a. Seminar, Conferences and STC organization i. Utilization certificates b. Management of Accounts i. Ledger ii. Cash book iii. Audited statements iv. Statement of accounts H. Planning and Development Management Module I. Departments Management Module a. Head b. Labs c. Departmental Stores J. Meeting Scheduler & Notice Management Module a. Maintenance of agenda, minutes of executive council and Board of studies K. Diary, Dispatch and File tracking Management Module a. Recording the details of dak (files, memos, circulars) received in any department of the institute. b. Capturing the details of files created within the department. c. Tracking the whole movement of all files and diaries. d. Also, recording the details when any file/diary moves out of the department/institute. L. Central Facilities Management Module a. Library i. Integration with existing Libsys based library system b. Computer Center c. Institute Web Site i. Static Pages on the following ii. 220.127.116.11. General Information about Institute, Courses, Syllabi and programmes, Institute Policies and Guidelines etc. iii. Admission procedures iv. 18.104.22.168. Information on all the departments, hostels and their facilities v. 22.214.171.124. Important links to student development council, Web-Mail etc. vi. 126.96.36.199. Frequently asked questions by students vii. 188.8.131.52. Contact information viii. Dynamic pages on the following ix. 184.108.40.206. Course Calendar x. 220.127.116.11. Faculty xi. 18.104.22.168. Results declaration xii. 22.214.171.124. Enquiry xiii. 126.96.36.199. Downloading of Forms xiv. 188.8.131.52. Link to web- mail d. Inte rnet Maintenance e. Workshop f. Design Center g. Seminar Hall and M. P. Hall h. Vehicle i. Guest House j. Medical k. Telephone M. Engineering (Construction & Maintenance (Civil & Electrical)) Manageme nt Module a. Generator b. Provide for On line monitoring of works event wise as well as expenditure wise c. Identify and store the events associated with a Work d. Add new works and associated events with that work e. Improve transparency by allowing management to monitor the progress of work centrally, so as to have a better control on works. f. Set up various limits, rules and controls centrally g. Consolidate the data for similar works done by various divisions h. Provide public information on works completed till a particular date i. Provide information of status of a particular work j. Provide a sophisticated, easy to use, graphical user interface (GUI) to all the users of the system k. Provide an scalable system for future extension l. Help in preparation of estimate m. Maintain list of contractors and their grade n. Maintain list of all the previous works undertaken by any wing that will help in future works o. Allocation of various scheme/ sub-scheme/work to various departments. p. Preparation of milestone schedules for the execution of the work. q. Allocation of whether work is to be done internally or contract is to be awarded. r. Measurement Book entry s. Generation of bills based on Measurement Book t. Maintenance of Contracts u. Vendor Rating and profile N. Alumni Management Module a. Addition and deletion of Alumni record b. Maintenance of Alumni record O. Web Based Learning Tools a. Intranet based knowledge dissemination i. Creation of knowledge database based on user groups and their institute mail ids ii. Sharing of important links, documents etc. by the faculty iii. Giving assignments, instructions etc. on the intranet to the students b. It is proposed to have a web portal creation tool so that the institute can create manage and maintain its own contents. The following are the key features required for the web portal tool: c. Guided deployment of web sites using the web site wizard d. In Web Projects the user should be able to create new web application and group objects as private or shared project. e. Possibility of using of web forms to create, modify and deleted data directly in the main application database. f. Feature of creation of web reports and to generate PDF reports g. Use of Style sheet editor for create styles and control the layout style from one place and the content from another. h. Built in Web page editor for structuring web pages and directly handling static as well as dynamic content. i. Multilingual support j. SSL support for secure transactions k. User access protected through built in security.