Tariff Finder (Updated)

I want you to design a webapp which considers the call detail record (CDR) of customers (Talk, Messaging and internet), against various GSM operators, tariffs, packages and campaigns, to present a comparison of the eventual invoice. Turkish GSM operators, TURKCELL, VODAFONE, AVEA, and BIMCELL, will be taken into account.

As an example, according to the CDR that includes the dates of 1-31 October, the system will show that what would be the exact price that the customer pay, if he was on a “Gold Plus” tariff from TURKCELL, instead of “Cep Advantage Extra” and “2GB Internet Package” from VODAFONE. While searching the suitable tariffs, packages, bundles or campaigns, the system should decide, if the customer uses a 100KB internet in any time, that which package (“Cep Advantage Extra” or “2GB Internet Package”) this consumption will be reduced from. Also, if the call minutes, SMS units or internet quota of tariffs, packages, bundles or campaigns exceeds or the use of date is expired, standard call, SMS and internet prices in the tariff should be considered.

There are many types of tariffs, packages, bundles and campaigns and they are updated very often. Therefore, the updates of packages should be made via the admin screen.

You can find the format for CDR. Also, we designed an ER diagram and its tables for giving you an idea about the project.

The System will work as follows:

1. It will get various features of customers such as special condition (student, public employee etc), age, city, customer type (personal, business), subscriber type (pre/postpaid), etc. Also, for the customers who don’t want to upload his CDR, the system will be able to take call details manually from the customer

2. It will find proper tariffs, packages and bundles and their combinations for the customer according to the features in step 1.

3. It will take the CDR and find the relative price for every row in the CDR. Also, customers will be allowed to upload more than one CDR.

4. It will display the combinations of tariffs, packages and bundles and their relative prices. For example, if the system finds 4 tariffs, 20 packages and 10 proper bundles for the customer, it will display 800 combination and their prices. In addition to the prices the system also shows a summary table that includes monthly savings, remaining SMSs, Call Minutes, Internet Quotas, devices that customer takes etc. Also, a summary table will be shown for the CDRs.

You can find the sample for summary tables as attached.

Skills: .NET, ASP, PHP, Software Architecture, SQL

See more: work finder, webapp example, types of searching in c, turkcell, system design advantage, student advantage, searching employee, internet uses in business, find operators, find design student, call minutes, turkish personal, upload er, summary table, ER diagram, design 2 comparison tables, call/sms, cdr sample, webapp design, various campaigns, php webapp, cdr call, php finder, webapp asp, call cdr

About the Employer:
( 29 reviews ) Lefkosa, Turkey

Project ID: #3999100

16 freelancers are bidding on average $3330 for this job


We have all the right technical expertise for this type of project so please check your PMB for details!!!

$2885 USD in 35 days
(68 Reviews)

Hello I look forward to talking to you further and getting started. We've been working with simple and complex Website technologies (PHP, MYSQL, .NET, C#, ASP, DRUPAL, JOOMLA, DOTNETNUKE, PERL JAVASCRIPT, CSS, HTM More

$1500 USD in 1 day
(10 Reviews)

Hi, We've already worked with CDR decoding and tracing the numbers project. We've implemented this project for the India's biggest network BSNL company and its handling billions of CDRs in a day. We know the comp More

$15000 USD in 90 days
(323 Reviews)

Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. ! With a good Profile in Freelancer and experience of over seven years in the Software Aren More

$2400 USD in 38 days
(24 Reviews)

We can work in your Tariff Finder. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of experience in Software development Windows and Web. Expert More

$1500 USD in 40 days
(19 Reviews)

Greetings from SJM Softech Pvt. Ltd. We are committed to providing our services and consultants at the most competitive rates in the marketplace. We are committed to hiring and retaining the very best talent available. More

$2500 USD in 40 days
(2 Reviews)

Good Afternoon! My name is Brian Teller and I'm quite intrigued by your web development project. After reading the description, I am confident we can design a webapp that considers the call detail record (CDR) of cu More

$2700 USD in 30 days
(2 Reviews)

Hi, Ready to start with a team of experienced professionals. Please check our offer at your PMB. Regards, ETS

$4500 USD in 55 days
(5 Reviews)

SERIOUS [url removed, login to view] PMB....Hello, We have expertize in online applications development. We focus on firm business relationship with our clients rather than quantity. Customer-specifications are a priority and tigh More

$2500 USD in 20 days
(7 Reviews)

Hi, 8+ years experience in the ( C# ) , Java script ,Ajax and Mssql field.i am Microsoft Certified Solution Developer. Please let me know if you are interested.. Thanks Sanjeev

$2500 USD in 35 days
(8 Reviews)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$2800 USD in 30 days
(4 Reviews)

I have a better plan for this. We will have this app in place and on the basis of certain criteria user will be suggest the best option. but the problem is from where we will have data for comparison. One way is to sto More

$3000 USD in 90 days
(0 Reviews)

We have done a ton of research to bring all of the proper specifications, screen sizes and everything else you'll need to get started creating your app quickly and easily.

$3000 USD in 45 days
(0 Reviews)

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

$2250 USD in 1 day
(0 Reviews)

Hi, we're a group of freelancers that definitely have the skill sets that you are seeking for this project. You can view some of our portfolio below. I would like to speak to you and make sure we freeze the project More

$3000 USD in 30 days
(0 Reviews)

I have 7 years experience in Telecom & ISP industry including preparation of payment plans and retention strategies. I can guarantee deep understanding of the matter and quality results for this project!

$2750 USD in 30 days
(0 Reviews)

I have worked on all the areas of the .Net programming and release and deployment, I can get this project to be done efficiently with build automation and testing. You will need to supply the specs in more details and More

$2995 USD in 90 days
(0 Reviews)