Sales Hotline: +91-11-45641144
SitemapContact Us
Zed-Axis Technologies
About Us
eBusiness Solutions
Portfolio
Case Studies
Our Clients
Blog
Career
Case Studies
Case Studies
web application design India
Our Clients
Our Portfolio
Subscribe to Newsletter
Custom Software Development Company India
Custom Software Development Company India
Custom Software Development Company India
Custom Software Development Company India
Valid HTML 4.01 TransitionalValid CSS!Protected by Copyscape DMCA Plagiarism Scanner
  Client : Sony Ericsson
Business Sector : Mobile Phone Distribution
Solution : Sales Tracking & Reporting
View Project :


Issue:
The objective was to keep track of opening stock, daily sales, daily purchases and closing stock at various levels like distributors, sub distributors, regional distributors and branches to facilitate decision making with regard to their sales strategy and business intelligence.
Solution:
Web based Sales tracking & reporting application has been provided to capture data at different levels through following five modules with report functionalities.
  • Sony Ericsson HQ Module: Manages Distributor accounts and manage Product Master, Region Master, State Master and City Master. This module has the functionality to manage a Bulletin Board on the site along with report interface to view reports on All India Basis.
  • Distributor HQ Module - Ingram: Displays the content published on the bulletin board and an interface to enter stock details. This module allows the Distributor HQ to manages their Regional Office accounts in the system like assigning of monthly targets to its regions and it has a report interface to view the relevant reports on All India data for their own network.
  • Distributor Regional Office Module (North & East): Displays the contents published on the Bulletin Board and allows the Distributor Regional Office to manage their Branch accounts in the system. Distributor RO has been provided a functionality to assign monthly targets to its branches and the relevant reports.
  • Distributor Branch Module: It has a ?manage retailer? functionality of RDS Module. It has the functionality to edit RDS historical / past data on request from the RDS.
  • RDS Module: It keeps a track of the Opening Stock, Sales, Purchases, and Closing Stock of the RDS. The opening stock for the RDS is entered once in the system when the RDS joins the system for the first time, then onward, Opening and Closing Stock is calculated as per the Purchase and Sales entered into the system.


Zed-Axis also provided one-way SMS Integration for this application to generate SMS alerts on predefined scheduled events.

Technology:
The proposed solution was a web-based application enabling easy interaction at all levels using a web browser. The data warehouse has been built using SQL Server for data storage and SQL OLAP services for the OLAP Cube(s). The BI Tool is being built in J2EE, which interact with SQL - OLAP service using XMLA.

Impacts:
  • Helped in decision making for Channel Sales. Formulating the sales strategies.
  • Central Repository of the Historical Sales Data, required for Business Intelligence.
  • Having Bulletin Board has helped in establishing a strong Communication Platform among various entities.
  • Automatic report forwarding to the individuals desktops.

Are you looking for a similar solution OR would like to have some other custom solutions made to fit in your business requirements. Click Here to Request a Free Quotation


 
   
Outsource Web Design India
Custom Software Development Company India | Outsource Software Development India | Outsource Web Design India | Offshore Software Development India | Custom Application Software Development India | Dot Net Application Development India | Custom CRM Software Solution India | Graphic Design Company India | Ecommerce Web Site Development India | Professional Web Development India | Outsourcing It Services India