App for US Govt. Organization to Measure Microbial Content of Food

App for US Govt. Organization to Measure Microbial Content of Food 2017-11-04T09:27:45+00:00

Project Description

Project Details

Customer Size: Large Organization
Country: US
Domain: Management and Technology Consulting
Application Software Server: Oracle Fusion Middleware/ WebLogic Server 12.x
Database Server: Java EE7
Backend Enterprise Web Application: MySQL -server 5.7.19
Rest Web Services: Spring 1.4.1
SOAP Web Services: JAX-WS JEE7
Development Environment: Eclipse or NetBeans
Database Persistence Layer: JPA with Hibernate

Client Profile

Client provide Management and Technology Consulting for small-business and Federal government agencies with actionable and creative business IT solution, solving mission critical and complex business challenges.

Business Scenario

Client required robust and scalable Web and mobile based solution to create a FDA compliant solution for the largest Government Organization dealing with Health and Hygiene that carried out the tests of microbial content in the meat available in the departmental store

Client was facing various challenges to

  • Managed Workflows and Sample Collectors’ Profile from Different Regions
  • Easy Uploading of Sample’s Data
  • Generated Advanced Reports

Our Solution

US laboratory conduct annual surveillance of approximately 17,280 retail meat samples, the participating laboratories collect meat samples and isolate bacteria before forwarding sample and associated data to the FDA for further analysis and reporting.

We analyzed requirements and adopted a discovery approach and developed a web portal and a mobile application.

The right to access authority through mobile application is only permitted to the Sample Collectors whereas web portal can be accessed by Administrator, FDA Manager, Site Manager and Lab User.

The functionalities that were considered during the application creation were:

Authentication and Authorization

FDA Manager and Admin activated Site Managers using badge login.

The Site Managers, Lab Users and Sample Collectors logged in using the activation message or mail.

Activity Log: The details of the samples collected or assigned offline, lab results and activated new sample collectors were displayed in the activity log.

Sample Log: the Sample Collector mentioned the details of the samples assigned and collected offline, viewed, edited and searched

The test result of a specific sample was added, updated, viewed and searched by the Lab User and Site Manager.

The sample log sheet could also be exported to CSV format and then be scheduled for emailing. In-case Sample collectors couldn’t access the Internet while travelling in remote locations; they could easily upload their data offline which would then be published online when Internet was available.

Business Benefits

  • Response time of the application was less than 8 seconds
  • The application was scalable to support at least 10,000 customers
  • Reliability of the application was estimated to 99.5%
  • Security due to authentication and authorization during login
  • Easy evaluation of samples through reporting
  • Offline Data Upload supported