sascon
Projects     |     Domains     |     Skills     |     Sectors
 

DIRECTORATE OF EVALUATION, MONITORING & MANPOWER PLANNING (EMM), Govt. of West Bengal

Job: HEALTH SERVICES MANPOWER INVENTORY
EMM's core function is to assess the manpower requirement in all departments of the state government, carry out manpower inventory across departments and report on gaps and deviations.  In the year 1995, the Health Department of the Government of West Bengal took up the World Bank funded project to revamp, modernise and strengthen the health care facilities and services in the public sector from the level of state capital right down to the village level. The first thing that was needed to draw up the action blue print was an accurate assessment of the available resources, such as buildings, equipment and manpower and the most complex part was manpower involving more than 1,50,000 people dispersed across a 6-tier health care organisation:
 
STATE  (Several large hospitals in the state capital)
DIVISIONS  (Divisional hospital)
DISTRICTS (Central hospital in the district headquarters)
SUB-DIVISIONS (Sub Divisional hospital)
BLOCKS (Block Primary Health Centre)
VILLAGES/CLUSTER OF VILLAGES (Primary Health Centre)
 
There is a complex set of business rules that governs the number of posts sanctioned in units at the various levels.

EMM was asked by the Health Department to collect actual head count by category at each of the units, ensure 100% data accuracy, identifying variances between sanctioned  strength and actual head count and report on the gaps. Their deliverables also included a relational database on the entire manpower data across all the establishments and units under the Health Department and an accurate assessment of unbalanced manpower mix.

It was a mammoth job and the biggest challenge was data accuracy.
Our scope of work included :
  • Requirement analysis and Database design
  • Software development for:
  • Validation of data collected by the enumerators through field survey
  • Various outputs, mostly in the form of statistical tables
  • Exception reports
  • Data entry and quality assurance ( > 450,000 records)
  • Creation of the databases
  • Data processing and hard copy outputs ( > 15,000 pages)
  • Documentation of findings and recommendations
We completed the entire work in 5 months with 100% accuracy while our predecessor, a much bigger company government owned IT company, had given up after failing to do it in 11 months.
 
 
Powered by Virtualinfocom