Hotel Loyalty Program

If you have already designed or are familiar with how Hotel Loyalty Cards work then this project is for you: We would need a system in place where a loyalty card member can swipe his card while paying his bill and get the necessary points added on to his card. The user should also be able to log onto a portal and see his points. Most imp we should be able to run all kinds of reports to find out what our cust buying patterns are, how much, how etc. If you're not sure PM us. ONLY place a bid if you can provide a detailed breakdown of how your set up would be, details of how the database would be set up, what reporting modules would be available and if possible a reference to any similar previous task completed. Bids without specific details will not be entertained. Please do not send us msg about your company etc , or generic msg. Front End (Customer): 1) Automatic Sign-Up via a Joomla CMS (that means the client becomes a Joomla User and signs automatcially up as Loyalty Program Customer ) 2) Automatic Member number Assignment (happens currently via Community Builder) and creation of a temporary Loyalty Card for the new member based on our Card design. 3) Ability to see at log-in to Joomla own current point status 4) Ability to see history of transactions which generated the Rewards Points 5) Ability to hand over all personal information and interests to the external Reservation system by different provider (XML specs existing) so it can be re-processed by the external system 6) Ability to redeem points for reservations/rewards/vouchers as well via XML to the external reservation system 7) Ability to see Special Offers based on Membership level (different levels, different offers) 8) Automatic change of Membership Level based on accummulated points (upwards only, no downgrade on point redemption) 9) Direct Feedback possibility for Members attached to the Member Profile like a Trouble Ticket System Back End (Administrators) 1) Part of the Joomla Back End (preferably as Component or extension to the Community Builder Component ) 2) Ability to create members from Back-End (for Offline Sign-ups) 3) Ability to enter transactions for single members based on amount spent in OFFLINE locations (set-up based on Member level )- for example: Standard Member spent 1 Dollar and receives 5 Points, while Gold Member spent 1 dollar but receives 7 Points etc... 4) 6 different levels of Membership - based on this levels different abilities to access different content inside Joomla (maybe needs an extension of the Standard Security System of Joomla) 5) Mass Mailing System (implementation to YaNC possible) based on Interests of Members and based on Membership level 6) Import function for basic membership data (CSV) for batch member creation 7) Import function for Spending transactions (CSV) of members for batch import from different Hotels 8) Reports based on - Membership level, transaction history all, transaction history single, transaction history range, redemptions history, redemptions to process, membership listing by each stored field, birthday report, Demographic Report, Mailing Report etc... 9) Process Reward Function (Voucher, Gift Certificate etc...) 10) Redemption Products and Categories Administration 10) Admin To Do list on log-in (prepare new sets of Membership material for new members, create new level Membership cards, prepare Redemtion Voucher, etc...) 11) Automatic deduction of points on redemption (internal and from external XML reservations booking engine