Customer Size: Large Organization
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 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.
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
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.
- 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