Case Study Dealer Management System with CRM and POS
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client
Requirement
Client in a short stint of 10 years in India has grown to tremendous heights. It has become one of the major suppliers to almost all the reputed car-manufacturing companies in India. Client wanted a system to track all the dealers’ sales through a Dealer Management System and Point of Sales. Client demanded a web-based and desktop application for CRM and Point of Sales screen where they manage: 1. Dealers o o o
Adding a Dealer Modifying a Dealer Deleting a Dealer
2. Customers o o o
Adding a Customer Modifying a Customer Deleting a Customer
3. Items o o o o o
Adding an Item Modifying an Item Deleting an Item Applying Discounts to Items Managing Discounts
4. Suppliers o o o
Adding a Supplier Modifying a Supplier Deleting a Supplier
5. Branch Management o o o o o
Branch Regional Office Country State City
6. POS o o o o
POS Screen(Sales Type Sales/Return, Quotation, Minimum Stock Indicator) Receipt (Invoice) Printing & Reprinting Void Bill Screen Journal
7. Inventory o o o
Goods In Stock Display(Display Item Information, Quantity for particular selected items) Inventory Correction
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 2
8. Reports Sales Report Quotation Report Turnover Report Claim Sales Report Stock Report Goods In Report Minimum Stock Report Inventory Correction Report
o o o o o o o o
9. Data Import (Dealer, Suppliers, Items, Customers, Branch) 10.Events Announcement (Events Name, Events Date, Events Description, Download) 11. Authorization Management Adding a New User Account Modifying a User Account Removing a User Account Account Types
o o o o
Project
Challenges
Team faced the following challenges: •
Developing an online & Desktop Dealer Management POS System that has the routing mechanism so that dealers can fill it and route it to Bridge Stone. Generating complex reports which involved extensive querying of database without slowing down the site.
•
Implementing POS Screen that pull information from CRM backend and manage data online and offline both.
•
Providing and maintaining the database of a range of interactive features like mail service, sales & expenses, events announcement and reminders.
•
Incorporating web usability principles in the website design so as to ensure easy navigation for all types of users.
•
The most important of all was to ensure data security.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 3
Technologies Used Operating System
Development Environment Database
Linux Cent OS, POS Desktop for Windows, Multi-Server Architecture with Staging & Production environment through Version controlling releases Load Balancer, Apache optimization, security and SSL implementation, scheduler for backups, alert monitoring system integration, server performance tuning at regular intervals, software firewall configuration and maintenance, email server configuration etc. Java, Swing, J2EE, JSTL & Servlets, Spring XML Web Services, Java Script, AJAX, Tomcat Apache 6.0.28 MYSQL, DB Clustering, DB Optimization, High Availability, Master – Slave Replication, Query optimization, Slow Query Optimization, scheduler for backups, Alert Monitoring System integration, etc.
Manpower Project Leader
1
Developers
5
Designers
2
Quality Assurance Testers
1
Planning • The design approach was built around JSP using JSTL, Servlets and MYSQL Server due to the performance, security, scalability and the nature of the website. In addition to this, the development structure was specifically implemented to facilitate the 'Faster to Market' transition of such concepts. • In order to most effectively access the database in an object-oriented context an interface translating the object logic to the relational logic was used to communicate with the relational databases in an object-oriented manner. An intermediary abstraction layer was created for accessing data from the database. Stored procedures were used only for complex retrieval of the data from multiple tables and were entirely avoided with conditional syntax to ensure the smooth performance of the website. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4
Architecture Keeping in mind the enormous structure of the website and the challenges involved n-tier architecture was adopted with all the layers loosely coupled with each other as follows: • Presentation Specific Layer: This will include the page level layer which will be accessing the other layers beneath to present the data. • Business Specific Layer: This will be the bridge between the presentation layer and the data base layer. This will contain all the business logic for the different components involved in the project. • Database Specific Layer: This will be a bridge between the physical database and the business logic accessing the data. • Physical Database Layer: MYSQL5 with the tables, views, stored procedures etc.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 5 of 5