Mail-in Rebate Administration System

CLOSED
Bids
16
Avg Bid (USD)
$1145
Project Budget (USD)
$750 - $1500

Project Description:
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:

Skills required:
Django, MySQL, PHP, Python
Additional Files: mail+in+rebate+system+for+bevrebates.docx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1085
in 22 days
$ 1000
in 15 days
$ 1500
in 20 days
Hire itssabya
$ 750
in 20 days
$ 1500
in 30 days
$ 850
in 25 days
Hire kommandant
$ 750
in 10 days
$ 3000
in 35 days
Hire sapewady
$ 800
in 15 days
$ 1335
in 20 days