Sweets Manufacturing & Inventory Management
About Client
Purpose of application to manage inward process, maintain stock, supplier details, purchase order & purchase details, production then prepare final product for sales.
Improves production, better product quality,
Client manages business with Tally ERP Software and few of the process are manually.
With use of application business operations will fast, production and product quality will improve.
Requirement
- Client is using Tally ERP software but client want to manage other details.
- Business team want to transfer manually process to computer based management system.
Challenges
- Main challenge was to provide a feature to generate Purchase Order using exiting purchase order record as valid .xml file which should importable in Tally ERP software.
- Also need a feature to import Purchase Order xml file generated from Tally ERP software in new system.
- Generate reconciliation report for new RDP system vs Tally ERP software related to purchase order details, product / item details, account details etc.
Solutions
Prepared analysis and solution document, shared.
Purposed the solution with following technology stack:
- Backend: Java 1.8, Spring Boot with Security, Spring Data JPA, JSP
- Database: MYSQL
- Fronted: HTML, CSS, JavaScript, jQuery, Ajax, Bootstrap and other jQuery & bootstrap based plugins
Main Entities
Admin, Purchase Officer, Purchase Manager, Account, Store, QA & Production.
In the application
- Admin: Manages user details, supplier details, item master details, generate reports.
- Purchase Officer: Manages purchase orders & details, generate reports related to purchase, supplier & item master and also can manage supplier & item master details.
- Purchase Manager: View purchase order & details, also can approve or cancel purchase order.
- Account: View & filter purchase orders, manages inventory for purchase orders and inventory related reports.
- Store: View inventory details, manages stock & item request from product manager, generates related to inventory, stock, fault & issue.
- QA: View inventory items, do quality assurance for inventory item, generates reports related to inventory and rejection or return stock.
- Production: Get items from store for production or can reject raw materials based on production outcome, generates reports related to productions, rejection, inventory used in production.
Results
It was difficult to implement because of support required to operational teams of business. Implementation was done phase by phase.
Phase 1: It was required to provide training & guide to operational teams, technical teams and continue monitoring on system. Transferred manual work to computer based management system.
Phase 2: Added fixes in system for the issues which were found after phase 1 implementation, added new systems and extended features of existing servers as per need.
Phase 3: Applied fixes, extended existing features and added new reports for management to take decision from history of data.
Phase 4: Added features in existing reports generating, updated reconciliation feature for operational & management teams and delivered system successfully.
System is running on successful status.
Key Java EE features implemented by us
MVC
Expertise
Java Enterprise Edition
| Development Platform | Java | Java EE |
| Frame work | Spring Boot | Spring Web | Spring Security | Spring LDAP (Active Directory) | Struts | Servlets | JSF | Hibernate | Spring Data JPA | Quartz | Liferay Portal | jUnit | TestNG | Mockito | Cucumber | Selenium | Apache: Camel | Siro | Lucene & Solr |
| Presentation Layer | HTML | CSS | JavaScript | SVG | jQuery | Ajax | XML | JSON | Bootstrap | AngularJS | Angular with Typescript | VueJs | ReactJS | ExtJS | GWT | FreeMarker | JSP | JSTL |
| Middle Tier | Hibernate | Spring Data JPA | JDBC | MyBatis | EJB |
| Database | - |
| Web Servers | MySQL | MariaDB | PostgreSQL | Oracle | SQL Server | MongoDB | Amazon RDS |
| IDE | Eclipse | IntelliJ | Visual Studio Code | Net Beans | IBM RAD | WebRatio |
| Web Services | Spring | Apache Axis | JAX-WS | JAX-RS |
| Tools | Ant | Maven | Gradle | iReport | Jasper Report |
| Build & Deployment | Ant | Maven | Gralde | Jenkins | Ansible | Docker | |
More Success Stories
Call Center
Our client is leading call center service provider in USA. Our client had multiple call center sites with hundreds of support team handling support for many bit MNCs in USA.
See More
Data Warehousing - Car Rental
They specialize in offering GPS-enabled vehicles to provide real-time tracking and monitoring capabilities to their customers.
See More
Cyber Security
Our client has created a Risk engine which will prepare a detailed report by analyzing different data received from different sources.
See More