Talk To Us For FREE

We are in the Business of Support and that starts before you even become a client.


  • Please prove you are human by selecting the House.

Dealer Management System with CRM and POS

Categories : All, Retail / E-commerce

project_manager_cicle

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.Dealer Management System with CRM and POS 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:

  • Dealer
    • Adding a Dealer
    • Modifying a Dealer
    • Deleting a Dealer
  • Customers
    • Adding a Customer
    • Modifying a Customer
    • Deleting a Customer
  • Items
    • Adding an Item
    • Modifying an Item
    • Deleting an Item
    • Applying Discounts to Items
    • Managing Discounts
  • Suppliers
    • Adding a Supplier
    • Modifying a Supplier
    • Deleting a Supplier
  • Branch Management
    • Branch
    • Regional Office
    • Country
    • State
    • City
  • POS
    • POS Screen(Sales Type Sales/Return, Quotation, Minimum Stock Indicator)
    • Receipt (Invoice) Printing & Reprinting
    • Void Bill
    • Screen Journal
  • Inventory
    • Goods In
    • Stock Display(Display Item Information, Quantity for particular selected items)
    • Inventory Correction
  • Reports
    • Sales Report
    • Quotation Report
    • Turnover Report
    • Claim Sales Report
    • Stock Report
    • Goods In Report
    • Minimum Stock Report
    • Inventory Correction Report
  • Data Import
  • (Dealer, Suppliers, Items, Customers, Branch)

  • Events Announcement
  • (Events Name, Events Date, Events Description, Down)

  • Authorization Management
    • Modifying a User Account
    • Adding a New User Account
    • Removing a User Account
    • Account Types

Project Challenges

Team faced the following challenges:
  • Implementing POS Screen that pull information from CRM backend and manage data online and offline both.
  • Incorporating web usability principles in the website design so as to ensure easy navigation for all types of users.
  • 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
  • Providing and maintaining the database of a range of interactive features like mail service, sales & expenses, events announcement and reminders.
  • The most important of all was to ensure data security.

Technologies Used

Operating System 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.
Development Environment CJava, Swing, J2EE, JSTL & Servlets, Spring XML Web Services, Java Script, AJAX, Tomcat Apache 6.0.28
Database 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

  • 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.
  • 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.

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.
  • Database Specific Layer: This will be a bridge between the physical database and the business logic accessing the data.
  • Business Specific Layer: This will be the bridge between the presentation layer and the database layer. This will contain all the business logic for the different components involved in the project.
  • Physical Database Layer: MYSQL5 with the tables, views, stored procedures etc.
[Total: 0    Average: 0/5]

Client Saying

If you're starting a new business or want to upgrade an existing site, I strongly recommend…
Mr. Manjesh Singh
CTO
Daniel Coburn, the president of Bragshare.com gives the honest opinion regarding his experience working with Brainvire…
Mr. Daniel Coburn
Chad Gundry, the CEO of Bragshare.com says that he has worked extensively with Brainvire team since…
Mr. Chad Gundry
The best thing about Brainvire is Compatibility. Whenever we have a query Brainvire is always ready…
Mr Craig Agranoff
Brainvire is a professional company with professional developers who understand the problems that we are facing…
Mr. Clarke Verdel

Latest Happenings

  • 28 Mar 2017
    Brainvire’s Massive Stride by Exhibiting Retail Expertise at High Point Market [ + ]
  • 28 Mar 2017
    Brainvire To Hit It Big at Imagine 2017 With Its Presence [ + ]
Enquiry