Frequent Shopper Program Essay Example for Free

Frequent Shopper Program EssayThe objective of this project request is to slash purchases of individual customers. The customer purchases lead be tracked and accumulated as loyalty points for redemption by the customer for gift items, specialty foods and other(a) products or services as made available done partnerships with other external companies. The strategic purpose of the Frequent Shopper Program is described on the Sales selling page of the Kudler elegant Foods Intranet site. Purpose Kudlerss new initiative is tracking purchase behavior at the individual customer level and providing mellow note value incentives through a partnership with a loyalty points program. The customer purchase behavior patterns will help Kudler refine its processes and offerings to best satisfy their values customers. set is not the primary differentiating factor for Kudler consumers these consumers are foc utilize on quality and finding specialized items. Therefore, rather than providing everyday discounts to the customers for their purchase frequency like dishonor stopping point markets, Kudler has partnered with a loyalty points program to provide customers with points which can be salvageed for high end gift items, airline first-class upgrades, or other specialty foods. Technology Infrastructure and ArchitectureThe following sections of this document will provide an overview of the hardware, network, software, infobases, and security requirements for the frequent shopper program. These requirements are suggestive Hardware Platform Kudler Fine Foods currently has an elaborate network of hardware that whitethorn be used to implement the frequent shopper program. Client-Side hardware1. from each one entrepot uses NCR RealPOS 82XRT terminals linked to the network through a POS server. (These terminals will be used during purchasing to initiate data collection including customer ID and purchase history data for the FSP) 2.The nineteen (at present count) integr ated management and other admin personnel all utilize Dell Vostro computers running Windows 7 OS. These administration personnel also share 3 HP networked printers. (In singing to the FSP, these computers will be used by management to query and analyze customer purchase history for business service refinement. )Server-Side Hardware 1. POS Servers- are used to process orders from the POS terminals and connect to the Kudler network for database file storage 2. HP Blade 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 strong as loyalty points addition and redemption. ) Network Platform 1. apiece of the three Kudler Stores has a Local Area Network which connects together Via T3 Dedicated high speed lines. 2. Each stores LAN is connected via ampere-second base T Ethernet. The communications into and out of th e stores is ported through 2 Cisco routers and firewalls. 3. Each Local Area Network is also connected to the internet via 25Mbps high speed business internet connections. 4. Network Diagrams (Shown Below)Software Development Tools 1. The Frequent Shopper Program is an additional service that will be implemented in federation with the existing Information 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 burstment methodologies be used to develop the FSP system and merge the application into the existing system. 2. Visual Studio 2012- This Integrated Development Environment will be used to develop the application modules and drug 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 l oyalty pointsDatabases 1- customer Table The Customer Table contains demographic data for each of Kudlers customers. The data in this table is used to access the hold and address of customers for order processing and for special mailings for anniversaries and/or birth dates, etc. revisal Table The Order Table is used to record information liable(p) to each Order placed with a given store. Each order will have one or more entries in the Order promissory note Table associated with it. 3- Order Line Table The Order Line table contains detail on items appearing 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 appear 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 tabl e (Frequent 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 corresponding at the point of sale(POS). Additional software will be added to initialize the FSP on applicable transaction.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 chec ks will be in place to verify unique CustomerIDs at the POS terminals. Every customer that participates in the Frequent Shopper Program will have a unique customerID.Each transaction 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 displace 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 total 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 entiti es, especially Customer personal information. Hashing and encoding techniques will be used when sensitive data is stored in all data stores, and secure data transfer protocols (e. g. , SSL, HTTPS, and WS-Security) will be used when data is Personal Information will be secured through the use of data encryption methods and secure networking protocols when data is transmitted over the network.