Automated Telephone Billing System

已关闭 已发布的 Mar 6, 2015 货到付款
已关闭 货到付款

• The telephone billing file received from Telecom Service Provider is uploaded in the system.

• The system should have the capability of capturing the staff id, staff mobile number, staff telephone number, email id.

• One staff can have multiple mobile numbers and land line numbers.

• At the time of upload, if the system does not find the telephone number for the user, it should reject uploading the entire file and provide the exceptions thru email.

• Email alerts are send to users informing the Telephone bill available for the period and needs to be submitted before the deadline.

• User needs to login to our domain on the intranet portal.

• Application link is provided to the User (login credentials verified in the our domain) to access the application on the ESS portal.

• The webpage displays the staff ID, phones listed against the staff, total amount against each phone no and ‘View Details’ option.

• In view details option, the list of telephone calls are listed (both landline and mobile).

• The system provides a check box against each number for marking the cost of the call for deduction.

• The user has to check the calls which are personal.

• The total amount on personal calls and official calls are shown in the end.

• The user needs to select ‘Submit’ to complete the billing information.

• An Email confirmation will be send to the user providing the details on amount for personal and official calls. The email confirmation would be notified to his immediate line manager (as mapped in ESS) regarding the amount to be deducted.

• After 30 days from the upload of the bills in the application, the system would close all open bills. A summary report is generated which would contain the following details: employee number, telephone number, total bill amount, deduction amount and official call amount to the email id . If the user does not submit the bills before the time period, the entire amount is charged against personal call.

• Billing information for the previous months will not be displayed to the users after 30 days of bill upload.

• The users can anytime query for their previous month telephone bill and it should be read only and can be printed.

NOTE: We need Technical proposal before start of the project.

Excel SQL

项目ID: #7259372

关于项目

8个方案 远程项目 活跃的Apr 12, 2015

有8名威客正在参与此工作的竞标,均价$178/小时

prprojectsl

I have planned to develop this project with agile model of application development. I am sure by the help of this model we can make this success. Well I require full of your support and documentation to start working o 更多

$222 USD 在10天内
(19条评论)
5.4
sreejithakaz

I have over 9 years of experience in Excel and Access VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Tools using VBA I have done a similar project for many clients.

$166 USD 在5天内
(12条评论)
3.9
servioza

La propuesta todavía no ha sido proveída

$300 USD 在3天内
(1条评论)
1.8
SoftAr

Hi, My agency has an extensive experience in Data Process and Programming. I am very interested in work for your project. Best regards, Matias.

$111 USD 在3天内
(0条评论)
0.0
ciofupetronela

Hello, I am writing to express my interest in the job you posted. Please note that currently I am working at an international company which provides outsorcing services, for a client based in UK. My main responsabil 更多

$166 USD 在3天内
(0条评论)
0.0
amitapril1

Definitely i am interested. I have the required experience and enthusiasm,professionalism. Please have a check on me..I can start immediately and deliver in 60 hours. Thanks Amit

$155 USD 在3天内
(0条评论)
0.0