Home » Services » Application Development » Case Studies  
 
Application Development Case Studies
 
Rain Guage analysis application
  Sellcraft has developed technology to combat the disaster caused by rains and water level accumulation. This technology is implemented in Mumbai, where every years rain claims the lives of the people by drowning. This ambitious project and technology is implemented for MCGM ( Municipal Corporation Of Greater Mumbai) It is valuable contribution to society and residents of Mumbai.
   
  Overview of the system
  Rain gauges are installed in 50 locations to measure the water levels and transmit the same continuously through the PCs to the Disaster recovery data center. This information is processed to build graphs and monitor the levels in real time and give alert on danger levels.
   
  The data can be accessed via multiple monitoring stations via WAN links.
This project creates a multi-tier rain gauge analysis application that involves
 
   
User authentication
Data collection (retrieval)
Data processing (transformation and logging)
Data analysis (calculation of data levels and other parameters)
Report generation ( hourly bar and 24-hour line graphs)
Visual alarm triggering (based on threshold values defined)
   
  The data can be visualized in the form of graphs from the monitoring stations. The monitoring stations access the rain guage server through a web interface.
   
The following figure shows the overall system layout
 
   
Technology for implementation
  Based on an analysis of the requirements, the following technology is used to implement this solution:
   
 
Application Tier Technology
Front end (web)
HTML/CSS
Presentation Layer
JSP
Business Layer / Infrastructure
J2EE Servlets
Persistency/ORM
Hibernate
J2EE framework database
Spring Oracle 10g
Database
Oracle 10g
Web Server
Apache tomcat
Operating System
Linux
  Go to top
Architectural Overview
  This system is designed based on the leading edge J2EE spring/hibernate framework.
   
 
The Spring framework decouples the application code from the choice of the J2EE server and also provides best practices and design patterns to improve the overall quality of the code.
The hibernate framework allows a clean mapping of Java objects into relational tables, and provides a layer of abstraction to allow the code to be database independent.
Rainfall guage data is transferred to the analysis server via a suitable protocol such as FTP. This data will be parsed by the server and then persisted.
Various Java bean classes are created for each database table, e.g. Region, Zone, Location etc. These beans will be persisted and loaded using Hibernate. JSP (Java Server Pages) technology will be used for the presentation layer.
   
Functional Overview
  The following modules are involved in building the rain guage server web application.
   
Module Feature Overview
   
 
Module Feature Overview
User Management
User administration
Access control lists
Role-based access
Data collection, Transformation and Logging
Periodic retrieval and conversion of data into Unix text files at 50 locations
Transformation of data and logging into into the Worli server Oracle databases into the defined schema.
Data collection and transformation will be performed at a defined periodic rate
Data Analysis and Reporting
Report generation, in the form of line and bar graphs
Refreshing of reports at a user-defined refresh rate
Alarm triggering (visually) for values crossing thresholds (user-defined)
Web-based Access
Web authentication
Web-enabled reports - bar and line graphs
   
Data Visualizations
  Charts of the actual data.
   
 
Go to top
Resume Management System
 
Resume Management System is a desktop application system. With the help of RMS, recruiters can maintain and manage their resumes, documents.

Screening and managing the large amount of resumes. Resumes come in a multitude of forms - applicant emails, web forms from the company website, online job boards and third party recruiters.
 
Facilities
 
Manage own profile.
Add different members of the sourcing team and manage their rights.
View latest posted resumes on the home page.
View list of all resumes posted through view list.
View the detail resume by clicking on the ‘name of candidate’.
Manage report for all the candidates to make the system process dependent.
Manage current openings.
Schedule interviews for the candidates applied.
Send invitations for the interview to the interviewer as well as interviewee.
Take data backup to make the data more secure.
View statistics of the sourcing process which can help for root cause analysis.
   
  The following are the new features incorporated in Resume Management System
 
Resume parser and import resume with edit option.
Search interface with resume document launch option.
Resume Management System in different languages.
Resume Management System with different skins.
Additional interface to add/modify skills.
Resume Management System with print option.
Refined user interface.
More help option.
   
  Recruiters use the RMS to read, analyze, sort, store, track and organize all the resume documents
  Go to top
For example
   
  They keep their data in the home directory.
 
   
  They save the Cvs of the candidates.
 
Go to top
 
© 2008 Sellcraft Softech. All Rights Reserved. Home | About Us | Services | Clients | Careers | Feedback | Contact Us | Sitemap