Bhavdeep Vyas

Diamond Industries Java Web Application BMV System Integration Pvt. Ltd, 702, Samudra Annexe, Off C G Road, Navrangpura, Ahmedabad-380009 Sales : +91 - (0)79 --http://www.systemintegration.in About Company BMV System Integration Pvt. Ltd. Company founded with the aim of providing a cost effective and quality software solution. Since our beginning, our commitment and fortitude to complete each project has resulted in becoming one of the most alleged IT solutions providers. Provide solutions that started from scratch product and ended up in final product, solutions that integrated with a normal product and made it a branded product. Solutions that merge creativity and technology. Our wide collection of software solutions includes software development, support services, software enhancements, software testing and consulting. Disclaimer The document is provided for general information purposes only. Your use of any of these screens and content for person use will be liable for legal action, and in case of use you need to get a professional advice and rights from the company. The provision of content in the document does not constitute legal advice or opinions of any kind or any advertising or solicitation. This document is just a proof of companies’ project development details for company personal use only. The contents of this portfolio reflects the views of the authors, who are responsible for the facts and the accuracy of the information presented herein. The opinions, findings and conclusions expressed in this publication are those of the authors and not necessarily those of the customers. The customers assume no liability for the contents or use of the information contained in this portfolio. Portfolio does not constitute a standard, specification, or regulation Diamond Industries ERP Application - BMV system integration Pvt. Ltd. Overview Diamond Industries Ltd is today a giant in soap, vegetables oils, fats and animal fed manufacturing with branches spread in all major towns in Kenya. The firm which started as a humble cottage in Limuru now boasts of having two big factories on Mombasa Island and in the Changamwe mainland area where they manufacture most of their products. Diamond Industries Ltd. are the pioneers in bar soap manufacturing having started their operations in 1954 when they produced the famous Panga Soap which is a regular in households not only in Kenya but also in Tanzania and Uganda. Features:       DIL application is working on locally in different three locations. All three location data synchronized. User can easily insert product, sell product, and manage stock of products and accounts. User friendly GUI for access application. System allows setting authorization and authentications. Easily identify record of selling and purchase. Business Model: 1.1 Brief of Overview Business of Diamond Industries Limited. The Diamond Industries Located at Mombasa Kenya. The nature of business is manufacturing the goods.    Palm Oil Soaps Palm FAT There are more than 20 types of product company are currently manufacturing. Like Soap are available with different size and brands. The basic purpose of Digital Diamond Application (ERP) it to manage the Sales, Stocks, Current Inventory, Customer Orders, Accounting, and Future Production’s needs, Packaging Materials & Its Future Needs, Raw Materials & Its Future Needs and Cargo/Trucks etc. Diamond Industries ERP Application - BMV system integration Pvt. Ltd. The Digital Diamond Application will be used in the 3 DCs (Distributions Centers) and 1 CF (Changamwe Factory) location. There are totals 3 DC’s and 1 Plant whose names and locations are below: 1> 2> 3> 4> Diamond Industries Plant - Changamwe Factory (CF) - Mombasa – Kenya Head Office – Mombasa Kenya Nairobi DC – Nairobi – Kenya Eldoret DC – Eldoret - Kenya The business functions discussed following modules are in the project/application scope. Business Functions  Sales As per the current Business model or process. There are many ways Diamond Industries uses to sell their products.          Finance & Accounting Stocks Customer Orders Managements Inventories Route Management for customer orders Raw Materials Packaging Materials Goods/Products Imports Cargo/Trucks  Technologies: - Java 1.6 - Apache Maven 3.0.4 - Apache Tomcat 7.0.11 - Apache Maven 3.0.4 - Spring 3.0.5 - Mybatis 3.1.0 - JQuery 1.7.2 - PostgreSQL 9.3 Diamond Industries ERP Application - BMV system integration Pvt. Ltd. Organized Trading System Retail Selling (Door to Door Selling Overview) Diamond Industries ERP Application - BMV system integration Pvt. Ltd. Different types of Sales: Direct Sales (OT) It is a kind of sales that is done to Distributors, Autonomous distributors, wholesalers, Core Distributors, Platform customer of Big Chain. Route Sales It is a kind of sales in which Diamond Industries salesman/Drivers is provided a company van & Handheld Computer (Mobile application). He every day report to Diamond Industries Head Office or distribution centers (Eldoret or Nairobi); loads products from the distribution center to van and then visit pre-planned customers and sell products to them and also merchandise products. Merchandising is an activity in which salesman need to organize products on the shelves installed on Customer Place. Pre-Sale It is same as route sales except salesman generally provided motorbike or any other small vehicle & Handheld Computer (Mobile application). Here he just enters orders of the customer and then passes this order to Head Office, Mombasa Kenya or any DCs (Eldoret or Nairobi) from which delivery of that orders will be organized. The Mobile application should be link with the ERP application so Head Office or Distributed Center directly approved Salesman orders and proceed with the further things related to that orders. Ex-Car Sales Ex-Car sale is exactly same as Route Sale only difference is that Invoice is not given to the customer instead a delivery note is given to customer. Invoice is given to the customer by a wholesaler who was serving that customer in the past. Then Diamond Industries Limited invoices the wholesaler. This kind of sale is introduced to do not spoil Diamond Industries Limited relationship with wholesaler. Sales Systems Organize Trade When sale to the last consumer is done through traders, wholesaler, Core Distributors etc. then this kind of trade is called Organize Trade. Also trade to some very big customers that have several branches and their own distribution system to transfer products to their sub branches are also called organize trade. In short as the word organizes illustrates that when a sell is done on the basis of order for products in advance is called Organize trade. Diamond Industries ERP Application - BMV system integration Pvt. Ltd. Door to Street As the word indicates when Diamond Industries Limited (DIL) opens their distribution centers (Nairobi & Eldoret) and move on street to sale products then this kind of sale is called Door to Street. In this case directly invoice or delivery note will be printed on time. There is not any order required in advance. Direct Sales Data warehouse & OMS Direct Sales Data warehouse application is used to enter orders of the OT Customers. This order can come through fax, telephone or through Electronic Discharge Interface (EDI) from the wholesaler or distributors etc. Order Management System is used for maintenance of orders created. Here maintenance includes order splitting, order shipment, mass update etc. Autonomous Sales This module is used to enter sales done to autonomous distributors. Autonomous distributor is a small distributor who has his own truck. He normally purchases goods from Diamond Industries Limited Head Office, Mombasa Kenya Or distribution center and put in his truck and then does sales to end customers that might be Diamond Industries Limited registered customers. The difference between Autonomous Sales and normal sales is that there is not any order management in case of autonomous sales and it will always self pick kind of order manse customer picks products by own. Pre-Sell There is other kind of sale is done by Diamond Industries Limited in which Diamond Industries Limited salesman visits small retail customers to take their orders through Handheld computer or Mobile Application. And this order is then passed to OMS system to manage delivery of the pre-sell order. So there are 2 parts of pre-sell application. One part of the pre-sell application will be in Route Power application that will be installed on handheld computer and another part will be in OMS application that will handle delivery part of pre-sell. Route Power As mentioned in Door to Street sale that when Diamond Industries Limited salesman take products from Diamond Industries Limited Head Office & distribution center and visit pre-planned customer and sell the products one and much used way is through Route Sale. For route sales Route Power application is used. This application is installed on handheld computer that Diamond Industries Limited salesman takes with him and sells products. Diamond Industries ERP Application - BMV system integration Pvt. Ltd. 1.2 BUSINESS MODEL AND ITS OPERATIONS  All stocks delivered from FACTORY are to HO, Mombasa sales depot. A document “Loading Requisition Order (LRO)” is a MUST for ALL loadings/deliveries from Factory, duly authorized.  All deliveries to Nairobi & Eldoret Sales depots are generated from HO. The balance of stocks i.e. Deliveries from Factory less sent to sales depots thus becomes stocks of Mombasa sales depot. The stocks of Mombasa are further reduced by SALES generated by Mombasa Depot. In this way physical stocks at Mombasa Depot MUST agree to book stocks each day.  Due to VAT (Value added Tax) administration matters, each Sales depots generates their own invoices for deliveries, etc to customers. An ETR (Electronic Tax Register) a requirement of Kenya Govt. Revenue Authorities is thus maintained at each of the three sales depots/points. This ETR machine produces a “tax receipt” which has to be attached to the original Invoice given to the customers.  Each depot thus keeps their own Invoicing records, etc on Standalone computers using QuickBooks software. At the end of each week and end month ( if this is mid-week ) Diamond Industries ERP Application - BMV system integration Pvt. Ltd. copy Invoice docs., bank receipts , and other accounting records are sent by Nairobi & Sales Depots to HO, which are then re-inputted into the main Accounting records maintained for the Company in Mombasa.  Even the Mombasa depot invoicing is on standalone computer, and daily transactions are again re-input into Company accounting records. The reason for this is we are using a multi-user QuickBooks software limited to 5 users ONLY and the Mombasa sales dept is at a different location to the main accounting  Factory operations o Full stock control/records of ALL raw materials, packing materials & finished goods. o Ability to generate LROs from HO automatically thru' Invoicing system to reach factory online. o Comparisons between physical stocks and book stocks to generate variance reports (with viewing/printing restrictions). o Materials usage reports within any time frame required. o Full details of suppliers of various materials, re-oder levels, automatic generation of purchase orders but these have to be authorized first before being sent to suppliers concerned (HO ONLY can authorize) o Allow factory to generate and print Delivery Notes, to accompany goods, linked (if direct to customer) with Invoice Nos. picked from the system and having that. o same blocked so that this no. Is not repeated.  Note the following Govt. Requirements: o VAT No & PIN No - Both alphanumeric o Required to have in our database and if possible to be incorporated when Invoicing customers.  Our customer base is split into the following categories: o KEY ACCOUNTS i.e. Big or major Supermarket chains o DISTRIBUTORS & WHOLESALERS o Other retail outlets  Each customer then has to be further classified: o Into sales regions o By Salesman Diamond Industries ERP Application - BMV system integration Pvt. Ltd. Screenshots  Dashboard Screen  Customer Order Screen Diamond Industries ERP Application - BMV system integration Pvt. Ltd.  Cheque Management  Application help Diamond Industries ERP Application - BMV system integration Pvt. Ltd.  Report Statement  DPF Management Diamond Industries ERP Application - BMV system integration Pvt. Ltd.  Inventory Management Diamond Industries ERP Application - BMV system integration Pvt. Ltd.