Employee Work Management System (EWMS)
Office of the Collector and District Magistrate Mehsana

A. Problem Analysis

 1. What was the problem before the implementation of the initiative?
Service delivery is very important job of district administration. Delivery of every service involves various processes and persons. If the processes are complex or there are delays at the level of persons (employees) then service delivery becomes very delayed and cumbersome, and ultimately it is the public at large which get the suffering. Timely service delivery with full transparency is main objective of district administration. With the available mechanism of manual reporting and old reporting procedures, service delivery and transparency both are not maintained. Applicant cannot ever get a clear status of his/her application. He/she need to visit offices several times to know status of the application. Even then without the knowledge of exact location of file, it becomes harder for him to find the appropriate person/table to ask about the status of file. The link between citizen/applicant and service provider (government agency) is getting thinner, as citizen find it cumbersome to enquire about the status of the file and also the existing mechanism takes a lot of time to service provider to reach to applicant to collect some more information/supplementary documents from applicant. As in the existing mechanism most of the reporting systems are manual or reports are man-made, it becomes harder for the top level management to do objective measurement of work and efficiency of employee. Also analysis of citizen charter cannot be done, as it defined based on old criteria. In government system hundreds of employees are involved in service delivery. Present system of supervision and evaluation of employees is not effective. Present incentive system does not distinguish between hard working and hardly working employees. Hard working employees’ gets more and more work and hardly working employees get away without any disincentives. At present there is no system which can measure work load and performance efficiency of government employees. Before inception of EWMS - Average time for disposal of a file 100 day. - Average file residency period on each table was 10-15 days. - Average file disposal rate of each employee was 6.13 file per day. - Average number of disposed file per month 523.

B. Strategic Approach

 2. What was the solution?
Timely service delivery with full transparency is main objective of district administration. With the new automatic mechanism/EWMS reporting, service delivery and transparency both are maintained. Applicant can get a clear status of his/her application. He/she need not to visit offices times to know status of the application. To get the status of file applicant need to send SMS and file status and its location automatically get delivered on his/her mobile. The link between citizen/applicant and service provider (government agency) is getting stronger, as citizen find it easy to enquire the status of the file by simply sending SMS with unique file id and also with the new system service provider (government agency) can contact in real-time buy using SMS system to connect to applicant and request him to submit supplementary documents in given time limit, so it ensures stronger link between applicant and service provider and faster service delivery. As in the new system all of the reports are automatics, precise, and real-time, it becomes easier for the top level management to do objective measurement of work and efficiency of employee. Also analysis of citizen charter analysis can be done, as average service delivery time can be calculated. Every task in government office moves in form a file, these files keeps moving from one table to another daily for one or another reason. Tracking of movement of these files and census of pending files are done manually. Using the traditional methods of tracking file leads a lot of problems i.e. delay in processing, login pendency, incorrect file census, un-even work-load balancing on employee, incorrect performance evaluation of employees, etc. In addition to that keep track of the files sent to other office (government and taluka offices) is also a difficult job. Many times files remain untouched for months or keep moving between same tables many times, this leads to unnecessary delay in file processing. To make processes simple, measure the work load and working efficiency and manage the work of employees we have taken recourse of Information Technology & developed EWMS. Employee Work Management System (EWMS) has been developed with the following broad objectives - To identify work load each employee. - To find out efficiency of each employee. - To track each file of district administration. Total no. of files in the system. - To find location of pending files. - To find duration of pending files. - Provide better platform for review and disposal of files in collector office. - Inform applicant using SMS facility about the decision taken on his/her file/application. - To increase the transparency in the system applicant can send SMS to the system to know the actual status and location of file/application.

 3. How did the initiative solve the problem and improve people’s lives?
After EWMS, a technical/automatic system came in place to generate real-time reports of very important statistics as File Arrival Rate (No. of files arriving per day at each employee) and File Disposal Rate (No. of file disposed/transferred per by each employee). This system helped administration to check real-time statistics of work-load on employees and identify hard-working and hardly working employees. Every task/application in now uniquely identified and its real time location can be checked. Applicant is updated by SMS about the latest status of the file. Using SMS gateway applicant can be asked to submit any document if required in real-time, rather sending a mail-post. Earlier whenever government agency required to contact applicant for supplementary document, it usually sent through normal post. Now with the new system SMS is sent in real-time with details and time-limit to submit the document. This ensures faster service delivery. By analysis of file arrival rate (FAR) and file disposal rate (FDR) of each following parameters were managed. - Low File arrival rate and Low file disposal rate, employee were warned to increase the efficiency and help other guys to complete the work in time. - Low File arrival rate and high file disposal rate, employee were given addition charge/key posts to use his/her efficiency in at a better place. - High File arrival rate and low file disposal rate, employee were removed from the post of high work-load and given post where low work-load and additional charge. - High file arrival rate and high file disposal rate, employee were awarded for better efficiency and better management of key post. With managing above four parameters, better work-load management can be done and system efficiency got improved.

C. Execution and Implementation

 4. In which ways is the initiative creative and innovative?
- File tracking system is designed to keep tracking of file. File tracking system basically starts with new file generation, as whenever a new file entered into the system, then a unique id is given to the file. Location of file is set pending on current system. With every moment of file, employee needs to keep track of the file. For example if file got entered on table-1 then its first location should be kept pending on table-1 and when file is sent to table-2 then its new location with date-time stamp is marked into the system. Every movement of file is record in this way. When the file goes to any senior officer or decision making authority, then authority passes the order and send it to concerned branch-table for last action taken. Based on file’s unique-id, its movement is tracked from its origin to last destination. - Based on the experience of file tracking EWMS web-portal developed for technically tracking of files. A web-portal is developed using some basic technology to automate the whole procedure. - All the branches and table were indentified and personal logins with secure credentials created for every user in the EWMS system. - Intensive training and technical support to staff of collector office Mehsana to use EWMS portal. - Small survey got done to identify the need of new computer hardware, so that actual need can be identified. Based on survey purchase of computer hardware and various other IT products were done to balance the resources equally among the staff. - Every staff member was instructed to enter all file pending on his/her table should be entered into the EWMS system. By entering all file unique if of each file got generated and a bar coded receipt also got printed of for each file. Printed receipt got affixed on each file. - After entry of 100% files, file movement is started. Every staff member also instructed to move file electronically in EWMS along with physical movement of file. - By tracking every movement of file various reports i.e. file pendency report, work load report, efficiency report, list of highly efficient employees, list of poor employees. - Regular meetings for evaluation of work done in EWMS web-portal by employees of collector office mehsana. - 100% files and employees of collector office Mehsana are being tracked in EWMS. Beyond that all four sub-divisional magistrate offices and 9 mamlatdar offices are added into EWMS. So movement of files from one office to another office is also covered. - 362 different file types are tracked. - 28000 files of citizen application are entered. - 318 employees of collector office mehsana and other offices are registered into EWMS.

 5. Who implemented the initiative and what is the size of the population affected by this initiative?
- Collector & District Magistrate Mehsana:- o Taken main initiative to start the project. o Finalize the stakeholders and inspired them for the successful implementation of the project o Continuously monitored and evaluated the whole project for effective implementation and corrective measures. o Purchased new computer hardware for better resources. - National Informatics Centre (NIC)-Mehsana:- o Developed the EWMS web-portal. o Provided technical support to the staff of collector office Mehsana. o Advised for purchase of new computer hardware as required for better implementation of the project. o Updated EWMS web-portal as per suggestions and recommendations discussed in staff meetings to make it more simple and informative. - Employees collector office Mehsana:- o Entered all files details into the system. o Real-time transferring of files from their own table to another table. o Keep their online status in sync with physical status of table. - Applicant o Get service delivery on time o Reduce service delivery time o Status of his application on his/her mobile timely submission of required document supplementary document.
 6. How was the strategy implemented and what resources were mobilized?
• New computer hardware was purchased by conducting a small survey on available computer hardware, as regular up gradation of office. Total funds were arranged from ‘Best Collector award – 2011’ and ‘e-Seva Society’ fund. • Several meetings were taken and extensive technical support was provided by NIC to help staff of collector office to enter 100% file into the system. • Project is developed in-house by district official of NIC. Web-site hosted on local web-server connected to GSWAN (Gujarat State Wide Area Network). So no expenses incurred in development and hosting of website. • Web-portal was continuously upgraded to make it easier and more informative for the users. • Staff of collector office not required to do any additional work to manage the system, as it requires minimum efforts to keep sync physical movement of files and electronic movement of files on EWMS, so minimum man hour incurred to manage the system. • System is evaluated by continuous feedback received from active participation of employees, so EWMS is very stable now and working automatically without active participation of technical team and involvement of senior management in up gradation.

 7. Who were the stakeholders involved in the design of the initiative and in its implementation?
By continuously monitoring the uses and data generated by the EWMS system, following very effective results came out. Just to compare the outcome two periods were identified to compare the some key factors: Period 1 (Before EWMS): April-2011 to March-2012 Period 2 (After EWMS): April 2012 to March – 2013 (EWMS was started in April-12) A) Application status and interactivity with service provider using SMS: a. Earlier there was no system to tell applicant the status of his/her application in real-time. Even whenever supplementary documents were required by government agency, then a request was sent by using mail-post. It takes 15-30 days to reach the mail to the applicant and then only applicant submits the supplementary document. Overall procedure delays the service delivery time. b. After EWMS, applicant can get his application status by sending a simple message. Also EWMS itself updates the applicant by sending SMS about the status and location of file. Most importantly now applicant can be informed in real-time to submit the supplementary document with given time limit. So it takes less time in processing the application. Overall using SMS technology service delivery time got reduced a lot. B) Number of files Disposal per month : a. Before inception of EWMS, number of files disposed per month was approx 523 files. Based on the data provided by subordinate office manually. b. After inception of EWMS, number of files disposed per month increased to 1001 almost double then earlier. Now the data is real and generated automatically. C) File Residency Period per employee a. Before inception of EWMS, average number of days a file resides on a particular table was 14 days. Only manual calculation of few hundred files. b. After inception of EWMS, average number of days a file resides on a particular table is 4 days. Data is based on average residency period automatically calculated by analysis of 28000 files. D) Average service delivery time per application in days a. Before inception of EWMS average number of days service delivery time was 100 days approximated. Based on random sampling of few hundred files. b. After inception of EWMS average number of days service delivery time is reduced to 35 days. Data is based on average file residency period automatically calculated by analysis of 28000 files. E) Efficiency of employees (File Disposal rate) per day per employee a. Before inception of EWMS, employees with highest level of efficiency were clearing 6.15 files per day. No factual data available, based on first data got from EWMS. b. After one year of inception of EWMS, employees with highest level of efficiency are clearing 13.21 file per day. Data automatically generated by the system.

 8. What were the most successful outputs and why was the initiative effective?
After inception of EWMS • Administration ensured 100% data-entry of file. To do this team in the supervision of collector, randomly checks branches. There every table is check for 100% file data-entry is done in EWMS. Files which were kept in cupboards are also checked, on which no decision was taken. So 100% data-entry of files is ensured. • Base on data-entry valuable reports generated. Base on reports strict Review in staff meeting every fort-night by Collector: Review of the branches taken every fort-night about pendency and efficiency of staff working. Analysis of every table is done in terms of pendency and duration of pendency. Files which are pending from long are individually taken care. • In review meeting employee and branches with heavy work-load were identified. Base on the work-load addition man-power was provided and work redistribution got done. Employees having heavy work-load with better disposal rates were appreciated: Employee having high File Arrival Rate and equally good file disposal rate are appreciated and asked to share their experiences about the system. Hence output of the branch is increased and average disposal time got reduced. • Employees having longest pending and most numbers of pending files were warned: Justification is asked to the employee, which are holding largest number of pending files with long duration. • Branch inspection: Senior Officer decided to not accept any file without EWMS entry. Whenever a file is sent to senior officer, then senior does not accept the file on his table, if it is not entered in EWMS and it should be shown pending in login of corresponding senior officer.

 9. What were the main obstacles encountered and how were they overcome?
• Obstacle: Lack of IT awareness or computer literacy of staff is major concern before developing any IT project for improvement in efficiency. • EWMS is designed by keeping ability of staff. As minimum and one-time data-entry is required to enter a file. • Movement of file kept very simple, as it does not require any typing; only selection of destination branch-table and a button press is required. • No remarks entry is required while transferring the file. As staff needs not to do duplicity in writing remarks in physical file and entering remarks online. • Home page is designed to show pendency of files in real-time and of concerned table only. So employee need to struggle to find where to work and how to find his/her file. • Obstacle: Lack of Computer Hardware • A small audit of available hardware in branches was conducted to identify the actual requirement. • New computer hardware was purchased to full fill the gap. • Web-based portal was developed, so maintenance issues of computes least affect the running system. • Obstacle: Work-load balance • Objective measurement of work-load on employees based on File Arrival Rate and File Disposal Rate • Employees with more File Arrival Rate, additional support provided to reduce file arrival rate. • Obstacle: Many files are kept in Await Mode, as physical file is kept at any table, and a letter is sent to some another table or applicant for taking some advice. So these type of files are very long pending files. • Await file are marked pending at source table. And it is considered pendency at source table. • Obstacle: Offices receives a lot of letters, this increased the work-load of employees, but this not a regular work which really affects the performance. • Letters are not tracked into the system • Only those letters are tracked, which will letter convert into a file. BY RESOLVING EVERY MICRO LEVEL ISSUE IN IMPLEMENTATION OF EMPLOYEE WORK MANAGEMENT SYSTEM, IT BECAME A BIG SUCCESS. MANY TIMES THESE MICRO LEVEL BLOCKAGES BECOME MAJOR CAUSE OF REJECTION OF SYSTEM.

D. Impact and Sustainability

 10. What were the key benefits resulting from this initiative?
Service Delivery time: Service delivery is very important job of district administration. Delivery of every service involves various processes and persons. If the processes are complex or there are delays at the level of persons (employees) then service delivery becomes very delayed and cumbersome, and ultimately it is the public at large which get the suffering. Delivery of service mainly depends on a lot of factors like work-load management, effective link between applicant and service provider, effective reporting system which generates informative and accurate reports, lack of transparency, etc. Earlier manual system was not giving these key features. EWMS is designed focusing on these key parameters. As EWMS provides automatic and effective link (using simple mobile technology) between applicant and government agency, better and valuable reports that helps senior management to take decision for work-load management, transparency on status of application. After EWMS system service delivery time is reduced from 100 days to 35 days. Interaction with applicant using SMS: Earlier there was no system to tell applicant the status of his/her application in real-time. Even whenever supplementary documents were required by government agency, then a request was sent by using mail-post. It takes 15-30 days to reach the mail to the applicant and then only applicant submits the supplementary document. Overall procedure delays the service delivery time. After EWMS, applicant can get his application status by sending a simple message. Also EWMS itself updates the applicant by sending SMS about the status and location of file. Most importantly now applicant can be informed in real-time to submit the supplementary document with given time limit. So it takes less time in processing the application. Overall using SMS technology service delivery time got reduced a lot. Work-load management: In government system hundreds of employees are involved in service delivery. Present system of supervision and evaluation of employees is not effective. Present incentive system does not distinguish between hard working and hardly working employees. Hard working employees’ gets more and more work and hardly working employees get away without any disincentives. At present there is no system which can measure work load and performance efficiency of government employees. EWMS system generated various reports as File Arrival Rate (FAR) and File Disposal Rate (DFR). By analysis of file arrival rate (FAR) and file disposal rate (FDR) of each following parameters were managed. - Low File arrival rate and Low file disposal rate, employee were warned to increase the efficiency and help other guys to complete the work in time. - High file arrival rate and high file disposal rate, employees were awarded for better efficiency and better management of key post. With managing above four parameters, better work-load management can be done and system efficiency got improved. Using the approach employee efficiency increased from 6.15 files per day to 13.21 file per day. In addition to above mentioned two very important benefits. Following are also key measurable indicator of success of the story: - Real time tracking of file location. - List of longest pending files. - Improve disposal of files. In last one year 15283 were entered and 14413 files disposed in collector office mehsana. - Objective measurement of each employee’s performance. - Objective measurement of employee’s performance become very easy and practiced on regular basis. - Classification of files on line, A, B, C and D. - IT awareness increased among collector office staff. - Classification of employee Good Working and Low Working - Real-time file pendency data for review by higher administration. - Online work-sheet generation. - Digitization of files, which can be retrieved from any where - Poor performing employees can be identified using reports. - Citizen charter analysis can be done based on real data and processing system. - Files which were pending from long period got identified and clarification was asked from responsible person. - Poorly performing employees were warned for holding up files for more than required periods. - File processing speed increased as transparency arrived in file location and movement through EWMS.

 11. Did the initiative improve integrity and/or accountability in public service? (If applicable)
- EWMS project is running successfully in Mehsana district since 15 April 2012. 100% files of collector office mehsana are entered into the EWMS system. Till today 28000 files are entered and 125000 file movements on table are recorded. - Web-site is developed using .NET as front-end and MS SQL Server 2005 express edition as back-end. - Basic file details are only stored, complete file is not available into the system. - All users have their user-id and passwords, so they can work only on their personal files. - Regular trainings are given to user to use the system. - By the order of government of Gujarat, the system is replicated in more than 10 districts of Gujarat state. - A central portal development is also in progress to making the system available for every one without any stand-alone installation.

 12. Were special measures put in place to ensure that the initiative benefits women and girls and improves the situation of the poorest and most vulnerable? (If applicable)
1. Transparency and stake holder participation Every system should have ability to communicate with its users in more interactive and simple way. By improving the interaction between different stakeholder transparencies and established. Many times using simple technology like SMS and other simple but interactive web-portal can produce magical results. As the user feels comfort to interact with the system, it automatically becomes transparent. In government to avoid red-tape and unnecessary delay transparency between different stakeholder should be increased. In EWMS this part is specially taken care by increasing interaction at various levels with different type of information useful for stakeholder. As applicant got information about his application using simple SMS received on his/her mobile, employee find an easy solution to work on as it required to press a few buttons to transfer. Senior management gets valuable reports to take decision to improve service delivery. So every stakeholder gets the appropriate information by the use of EWMS. Stakeholders have been very actively participating in this project since inception. As being a technical project and an employee can directly manage his/her table with least efforts using his own credentials. Implementation of EWMS has improved the transparency in the system as anyone can trace location of each file. Just by keying ID no of file one can find the log of any file, its delay at each employee, and its present location. 2. Innovativeness of the initiative and its replicability For the first time this platform provides the work load and efficiency of each employee, objective method to review and grade each employee. It can be used for performance linked pay structure, practical method of ACR writing. This project is fully replicable, as it can be customized technically to use in any office. Being a web-portal, a central portal can be developed, that can be used by any office by simply customizing master data. Objective measurement of employees can be done to real time statistics. This helps administration to classify employees. 3. Increased efficiency of outputs/processes and effectiveness of outcomes After inception of project, real time tracking of files is being done and pendency duration has been reduced from 15 days/employee to only 4 days / employee. This has helps in faster disposal of files. Status of particular file can be checked in real time, so that long pending files got disposed soon. Real time pendency report of employees/table helps administration to understand busy and not- so-busy employees. 4. Sustainability Of The Initiative This initiative is fully sustainable as it is very simple to use, so even a personal with little computer knowledge can operate his/her own table using their credentials. For expansion of project or increasing requirements computer hardware resources are available in market. Starting from one office, other offices can also be connected within the same portal, so that more staff/offices can be covered and monitored. At present this project is successfully running since last year in collector office Mehsana.

Contact Information

Institution Name:   Office of the Collector and District Magistrate Mehsana
Institution Type:   Government Agency  
Contact Person:   Rajkumar Beniwal
Title:   Head of Collector Office Mehsana  
Telephone/ Fax:   02762222200 / 02762222202
Institution's / Project's Website:  
E-mail:   collector-meh@gujarat.gov.in  
Address:   Block No. 3, Collector Office, MS Building, Rajmahal Road
Postal Code:   384001
City:   Mehsana
State/Province:   Gujarat
Country:  

          Go Back

Print friendly Page