This is a very simple project and I need it finished very very fast. I have an Access database ready with tables already designed and data populated. You will simply be formatting the data using queries and creating a CSV output file. There are various changes I need done to the existing system to make it more versatile.
This is an application that will be used in the telecommunication industry. Your objective will be to take various sets of pricing/vendor data and transform the information into a format that can be outputted as a CSV file.
When a customer sends us a call over the internet, a switch decides which vendor to send to call to based on price. The switch will attempt the cheapest vendor first, if the call does not answer, the switch will try the next cheapest and the next until the call is completed. The switch can attempt up to 8 vendors before it gives up. Each vendor provides us a list of routes with a rate for each route. The switch does a digit match based on the first 7 digits of the number being called. For example, if the switch receives a call to 12148761404 it will look for a match in the system which would be 1214876. It then sends the call to the cheapest vendor to be completed. This system of sending calls to the cheapest vendor is called Least Cost Routing or LCR. In order for the switch to know how to route the calls, it requires that an LCR file be imported. Because there are anywhere from 50,000 to 150,000 routes per vendor, this task cannot be done by hand. An MS Access database has been prepared with all the rate and vendor data populated. You will only need to modify an application within Access to query all the rate tables and create various LCR tables.
13 freelancers are bidding on average $129 for this job
Hello Sir, I have more than 5+ Years of experience in Developing and Testing web based and desktop Applications so I can do this job offering you a better quality of work. Thank You Darshan