Software Development

- ICMS (Integrated Campus Management System)

ICMS (Integrated Campus Management System) is being developed by SPIC for the complete computerization of Govt. College of Art, Chandigarh which includes the computerization of Admission Procedure, Post Admission, Finance, Human Recourse, Library, and Inventory. The project can be divided in to three implementation phases.

Phase - I

  • Eligibility Report: All the preliminary information required for generation of eligible student report fed into the system as soon as forms received from the students. The system will generate the list of eligible candidates for entrance test.
  • Merit List: After the test, the result of the test will also be fed into the system and merit list will be generated
  • Roll no. generation: All the data pertaining to the admitted candidates will be keyed in. This includes information like the course of admission, hostler/day scholar, fee details etc. System will generate the roll no. for the candidates..
  • Attendance: This module will keep track of the lectures attended and delivered in each subject by the student. Then a detailed report of the lecture shortage will be generated by the system at the end of the session..
  • Examination and result processing: The awards /sessional received by the students will be fed into the system. Then reports like class topper, subject topper, retention list and report cards will be generated.

Phase - II

  • Personnel Management Information System: This module will keep details pertaining to each employee with regard to his/her service details, which will include salary, leave, training and academic records.
  • Finance and Accounts: This module will include the computerization of fees receipts procedure. System will generate the fee receipt, allocate receipt number and generate daily case reports
  • DDO and Accounting: In this section we will computerize voucher/bill level accounting. This includes Finance and Accounts (Contd.)
    1. Expenditure done by college
    2. Collection from fees, securities, non-refundable/refundable funds.
    3. University funds available and dispatched

Budget: This section will monitor the budget provisions regularly with specific aim that budget allotments are not exceeded without authority and the expenditure in incurred only on the objects and purposes for which the funds have been provided

Phase - III

  • Inventory: This section will computerize all functions relating to inventory control of store stock items in different departments. There will be generation of stock ledgers which will facilitate issuance of no due certificate to a person and check duplicate/repeated purchase of equipments.
  • Library: This section will computerize the complete working of the library. This includes data base of members, books in circulation and reference section, issue /return of books and sending reminders to defaulters.

- Personal Information System

Personal Information System is being developed by SPIC for Chandigarh Police Department. The scope of the project has been defined to manage all the information about all the personals of the Police department. The Personal Information System is proposed to have a centralized database which shall reduce the problem of storing and retrieving the data regarding all the personals. Using the system, the officers in the Police Department shall be able to know all the details regarding the personals by reducing the amount of file work involved in the various record keeping related procedures. Features of the system are:-

  • Master Entry of Personal & Official Details: One time entry of the details of Police personal at the time of recruitment.
  • Entry of posting details: Entry of all the posting details of the official time to time so that all the history regarding his posting can be easily generated in future.
  • Entry of Cases: This includes entering all the details of Departmental Enquires held against the officials during tenure and also all criminal Cases filed against them.
  • Entry of Promotion and Suspension: Time to time entry of all the promotion and suspension of officials during tenure.
  • Report Generation: Report can be generated for all officials according to the requirement of the management.
    1. Personal & Official status: For a particular official or for a particular Rank wise
    2. Posting status: For a particular official or for a particular Rank wise this report can be generated. This report can also be generate to get information about the official posted in a particular period wise
    3. Promotion & Suspension details: For a particular official or for a particular rank wise to get all his/her Promotion and Suspension.
    4. Retirement Report: To retrieve the information about the official who are going to be retired in a particular period.
    5. Other Reports: This include different type of reports required as per requirement which include to know details of Leaves, Physical status, Nominee status & Cases filed against the police official during his working tenure etc.

- IEMS (Integrated Excise Management System)

ERP Solution is being developed by SPIC to be implemented at the Chandigarh Administration’s Excise and Taxation Department. The scope of the project has been defined to include computerized Licenses generation and printing and license search and maintaining register of treasury receipt/ Challaan The ERP Solution is proposed to have a centralized database which shall reduce the problem of storing and retrieving the data. The ERP Solution shall include easy license generation utility, license cancellation utility, a module to revalidate the license and calculate fees of the Individual Licensee. Some features of the system are:-

  • Master Entry of License Format: One time entry of the format of the Licenses.
  • Entry of liquor Brand: Time to time entry of liquor brand possessed by the individual licensee.
  • Duplicate License Generation: In case of loss of License or any other unforeseen eventuality, a duplicate license can be generated with ease
  • Cancel License: In case of error occurring while generating a license ,the license can be cancelled and a fresh one generated..
  • Entry of treasury receipts: Daily entry of treasury receipts.
  • Reconciliation: Reconciliation of treasury receipt with the permit and license receipts
  • DCR Generation: Daily Collection Report or DCR can be generated for management review according to the requirement of the management. The DCR can be generated with the following constraints:
    1. Day Wise: Between a range of dates.
    2. Month Wise: For a particular month
    3. Year Wise: For a particular year.
    4. Canceled License Report: Cancelled License Report can be generated between any two dates..

- Library Soft

Client: Chandigarh College of Architecture (CCA)

Technologies Used: VB 6.0 and MS Access

The "LibrarySoft" software is all about managing a Library. Managing a Library includes Issue/Return of Items, Inventory Control, Generation of Reports, Computation of Fine, Making ID cards, Maintaining Registers containing information of various articles in the Library, assigning Accession Numbers, Call Numbers to articles, ID numbers, Membership Numbers to Borrowers, Marking Lost articles and assigning Withdrawn Numbers to them, clearing of Dues etc.

- Challaning System (CHD Traffic Police)

Client: Chandigarh Traffic Police

Technologies Used: VB 6.O AND SQL Server 2000

This Project maintains information regarding CHALLANS done per day. It also provides small window in which violators can pay their challan without going to court. This project helps in determining the amount a person has to pay for a particular challan. Entries for the Challan amount paid at various Sampark Centre are also entered here.

- Employment Exchange

Client: Regional Employment Exchange

Technologies Used: VB 6.0 and Sqlserver 2000

Employment Exchange is the hub from where job opportunities are notified to all the potential candidates who have registered themselves and on the other hand, for Employers, it provides a listing of some of the capable candidates for a particular job.

- Chandigarh Housing Board Project

Client: Chandigarh Housing Board

Technologies Used: Asp.net AND Oracle 10g

Chandigarh Housing Board

This software maintains the accounts of all the allottees who have purchased flats/plots from Chandigarh Housing Board. Software is used to create ledger from Cashbook. It also maintain record of vacant houses, groundrent, pending installment, watchward etc.

CPCC-CESS

Client: Chandigarh Pollution Control Committee
Technologies Used: VB 6.0 and Sqlserver 2000

This Project maintains information regarding the Assessees,computes their CESS maintains records of Payments made and also record of reimbursement to ministry.

Student Information System

Client: ITI
Technologies Used: VB 6.0 and Sqlserver 2000

This project involves modules namely Student Information System, Employee Management, Inventory Management.

All the data associated with the students, employees, library, and accounts is operated upon manually in the files, which can even give inaccurate results, will be handled after computerization for easy storage and access.

Personal Management System

Client: Government Central Crafts Institute for Women
Technologies Used: VB 6.0 and Sqlserver 2000

This Project maintains information regarding the Inventory and the Employee Details at at GCCIW.In Inventory management System it maintains the Demand Entries,the Stock Entries,the details of Purchases made and also keeps record of finished goods

Senior Citizen and Disability Card Issue

Client: Department Of Social Welfare
Technologies Used: VB 6.0 and Sqlserver 2000

This Project maintains information regarding THE Issue of Senior Citizen Card and Disability Card.

Challaning System (State Transport Authority)

Client: State Transport Authority
Technologies Used: State Transport Authority

This Project maintains information regarding CHALLANS done per day. It also provides small window in which violators can pay their challan without going to court. This project helps in determining the amount a person has to pay for a particular challan.

STA deals with the challan of Transport/Non-Transport vehicles.

Various offences fixed and categorized by goverment include their section and punishment as mentioned ahead in the offences details

Loan Management System

Client: Punjab Backward Classes and Development & Finance Corporation (Backfinco)
Technologies Used: VB 6.0 and Sqlserver 2000

This Project maintains information regarding Loan sanctioned to various ApplicantsIt keeps record of the recovery made by Backfinco from various applicants.

Project Monitoring System

Client: Chandigarh Administration
Technologies Used: .Net Using C# and Sqlserver 2000

Keeping in view the larger public interest , various innovative projects have been launched by the Administration and in order to assist the function to pursue development strategies to complete them under a time bound manner, the Project Monitoring System has been evolved as a tool to effectively monitor the projects.

Permit Management System

Client: Chandigarh Administration
Technologies Used: .Net Using C# and Sqlserver 2000

Permit Management System is being developed by SPIC to be implemented at the Chandigarh Administration’s Excise and Taxation Department. The scope of the project has been defined to include computerised permit generation, permit printing with pre-printed stationary, permit search and record of the various liquor quotas to be implemented (if any) among others. The Permit Management System is proposed to have a centralized database which shall reduce the problem of storing and retrieving the data. Using the system, the officers in the Excise and Taxation Department shall be able to work more efficiently by reducing the amount of file work involved in the various permit related procedures. The permit management system shall include easy permit generation utility, permit cancellation utility, a module to revalidate the permits and calculate fees dynamically among other features. Authentication as well as authorization features are to be incorporated so as to provide a high level of security to avoid any misuse of the system. Some features of the system are:-

  • Master Entry of Permit Fee: One time entry of the various fees to be implemented as a part of the excise policy.
  • Master Entry of Parties: One time entry of the various parties which are issued permits to allow easy permit generation.
  • Master Entry of Suppliers: One time entry of the various suppliers linked with the parties to allow for permit generation to source liquor from only pre-designated suppliers.
  • Master Entry of Quotas: In case of liquor permits where quotas of permit are enforced, the quota for that year can be fixed and the system shall calculate the permit charges accordingly.
  • Master Entry of Liquor Types: One time entry of the various liquor types which require permits to be issued for transportation facilitating easy permit generation.
  • Duplicate Permit Generation: In case of loss of permit or any other unforeseen eventuality, a duplicate permit can be generated with ease.
  • Cancel Permit: In case of error occurring while generating a permit, the permit can be cancelled and a fresh one generated.
  • Revalidate Permit: If a permit is to be extended beyond its original validity date, it can be revalidated after paying the requisite fee.
  • DCR Generation: Daily Collection Report or DCR can be generated for management review according to the requirement of the management. The DCR can be generated with the following constraints:
    1. Day Wise: Between a range of dates.
    2. Month Wise: For a particular month
    3. Year Wise: For a particular year.
    4. License Wise: For a particular license.
    5. Party Wise: For a particular party.