Mail-in Rebate Administration System

specs in attachment Mail-in Rebate System Project Goal: Web Based System that allows the input, manipulation and reporting of Mail-In Rebate Data Input of Mail-in Rebate Data • First name • Last Name • Address • City • State • Zip • Email address • Tax ID (not required) • Date of Birth • Retailer • Brand • Reference (not required) • Paid Out Date (not required) • Pay or Not Pay (selection) • Status: Approved/Denied/Not yet Redeemed/Duplicate (selection, not required) Security and Authentication • https with password authentication (because we could be storing SS information), your going to need this data behind a firewall in PCI compliance environment. Reporting (.pdf or excel) • Mail-ins by Retailer by State – IE # of Mail Ins in August Program, report similar to the one broken down by States below • All Approved/Denied by Retailer – For a data range, view all approved/denied entries by a specific Retailer. • Filters o By default do not show Denied/ Not yet Redeemed, with the option to view those Exportation of Data • Export of data to check processor in proper format • Option to mark all exported data as approved and set paid-out date Tools • Find and View Duplicates – Report that would find all sets of duplicates for a Retailer/Brand/All and filtered by date range and an option to mark each one as a duplicate if needed. Show the following information in the tool: Payee name, Reference, Payout Amount, Street City, State, Zip, Country, Retailer, Brand Find and View Likes - Report that would find all sets of like entries(similar but non-exact information) for a Retailer/Brand/All and filtered by date range and an option to mark each one as a duplicate if needed. Show the following information in the tool: Payee name, Reference, Payout Amount, Street City, State, Zip, Country, Retailer, Brand Import Data from Excel – either the programmer can do it one-time or we can create a tool to have you import the data from an excel spreadsheet Search Tool – Find specific entries by name, address, zip, Brand, Retailer, Reference with option to override any of the information Example Report: