Frequent Shopper Program Essay

The objective of this pop disclose request is to track corrupts of individual guests. The customer purchases depart be tracked and accumulated as loyalty points for redemption by the customer for gift items, specialty foods and other(a) products or serves as make available by dint of partnerships with other external companies. The strategic purpose of the public Shopper computer programme is described on the Sales & Marketing page of the Kudler elegant Foods Intranet site. Purpose Kudlerss new initiative is tracking purchase demeanor at the individual customer level and providing high value incentives through a partnership with a loyalty points program.The customer purchase conduct patterns exit help Kudler refine its processes and offerings to best satisfy their set customers. expense is not the primary differentiating factor for Kudler consumers these consumers are foc apply on choice and finding specialized items. Therefore, rather than providing everyday discount s to the customers for their purchase frequency homogeneous lower end markets, Kudler has partnered with a loyalty points program to provide customers with points which ass be geted for high end gift items, air railway first-class mail upgrades, or other specialty foods. Technology Infrastructure and ArchitectureThe avocation sections of this document testament provide an overview of the ironware, network, software, entropybases, and security measure requirements for the frequent shopper program. These requirements are revelatory Hardware Platform Kudler Fine Foods currently has an elaborate network of hardware that may be employ to implement the frequent shopper program. Client-Side hardware1. apiece store uses NCR RealPOS 82XRT terminals linked to the network through a POS server. (These terminals volition be use during purchasing to initiate information allurement including customer ID and purchase history data for the FSP) 2.The nineteen (at present count) corporat e management and other admin personnel all utilize Dell Vostro computers running Windows 7 OS. These judicial outline personnel also share 3 HP networked printers. (In relation to the FSP, these computers will be employ by management to query and analyze customer purchase history for air service refinement. )Server-Side Hardware 1. POS Servers- are utilize to process orders from the POS terminals and connect to the Kudler network for database file storage 2. HP firebrand Server system- c3000 system, Unix OS, SAP Retail SW, Print/File, Communications, Email, Storage, Web. These Servers will be used to store data regarding individual customer purchase history and queried for business analysis as well as loyalty points addition and redemption. ) meshing Platform 1. Each of the three Kudler Stores has a Local Area interlock which connects together Via T3 Dedicated high speed lines. 2. Each stores LAN is connected via 100 base T Ethernet. The communications into and out of the st ores is ported through 2 Cisco routers and firewalls. 3. Each Local Area intercommunicate is also connected to the profits via 25Mbps high speed business internet connections. 4. Network Diagrams (Shown Below)Software developing Tools 1. The rat Shopper Program is an additional service that will be implemented in conjunction with the exist schooling Technology System used throughout Kudler Fine Foods. Because of the complexity and functionality of the existing system, it is recommended that the use of AGILE development methodologies be used to develop the FSP system and merge the use into the existing system. 2. Visual Studio 2012- This Integrated Development Environment will be used to develop the application staffs and user interfaces for the FSP development. 3. The code will be implemented in the C language. (used for module development) b. ASP. NET & MVC used to develop dynamic, interactive web based application for customers to access, monitor, and redeem loyalty poin tsDatabases 1- node Table The Customer Table contains demographic data for for each one of Kudlers customers. The data in this table is used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birth dates, and so forth Order Table The Order Table is used to record information pertinent to each Order placed with a given store. Each order will have one or more entries in the Order reap Table associated with it. 3- Order Line Table The Order Line table contains detail on items seem on an order. One or more Order Lines are associated with each order and each Order Line references an item being purchased with its description, quantity, price, etc. 4- Item Table The Item Table stores information pertaining to products that may come along on an order. It describes goods that can be purchased from a Store.The current database tables can be re-used and combined to create the FSPoints Table The FSPoints table ( customary Shopper Points table), will include the Customer ID and all correlating information, Item purchase history, and Item Points Value. The sum of all points values will be expressed and added to the Customers redeemable points at the end of each FSP period. User Interfaces Describe the interface for data collection and notification to store personnel and customers.1. The initial User Interface will remain the same at the point of sale(POS). Additional software will be added to initialize the FSP on applicable motion.Software modules will be initialized as needed that will collect the CustomerID as well as the individual items purchased. 2. Web Applications Through the use of the aforementioned tools including ASP. NET and MVC, an interactive web application will be available to registered customers, and personnel to access, review, and redeem loyalty points. There will be an exclusive page created for the Frequent Shopper Program. Controls System accuracy checks will be in place to h old in unique CustomerIDs at the POS terminals. Every customer that participates in the Frequent Shopper Program will have a unique customerID.Each exploit will begin by entering this identifier which when verified for accuracy will begin collecting item purchase data. Each item is scanned at the POS, and compared to its corresponding FSPoints table to add loyalty points to the Customers FSPoint record. If the CustomerID or any items purchased to not register in the verification processing system, an exception will be returned to notify the customer and cashier at the time of purchase. Each transaction will close with a printed receipt listing the order line information, as well as the points accumulated at that transaction.A points descend may be requested via the internet based Frequent Shopper Program Web application on the Kudler Fine Foods website. Security The necessary security mechanisms need to be in place when storing and moving most data entities, especially Customer pe rsonal information. Hashing and encryption techniques will be used when sensitive data is stored in all data stores, and skillful data transfer protocols (e. g. , SSL, HTTPS, and WS-Security) will be used when data is Personal randomness will be secured through the use of data encryption methods and secure networking protocols when data is transmitted over the network.