Find Jobs
Hire Freelancers

CDR Remediation APP needed for Telecom Business

$30-250 USD

En curso
Publicado hace casi 15 años

$30-250 USD

Pagado a la entrega
We are in the Telecom business and need someone who is familiar with the industry that has or can develop an application that will allow us to compare call detail records between our system and the vendors system and determine where discrepancies exist. When a call is completed, the CDR rated and stored into an MS SQL 2008 database. When we receive a bill, if the total number minutes in our system does not match the bill, or if the amount is wrong, then the vendor send us their CDRs in a flat csv file format. We must import this file into our system in order to compare their records with ours. The following must happen in order to do this: 1. Their fields must be mapped to ours before import. The app you develop must allow us to pick which fields match our fields. Some companies use a start and stop time, other do not. Some enter the rate information, others don't. The system must be flexible enough to allow us to do the mapping and then save this as a template for future use. 2. Their CDR times must be syncronized with our times. Every server uses a different time zone and not every one will use ntp. As a result, there will be an time offset in order to line their records with ours. 3. A threshold must be set for discrepancies. For example, if we set it to 2%, any CDR with a discrepancy of less than 2% will be ignored. Typically, the number of minutes billed between systems will not match exactly. 4. One the CDRs are lined up by time, the fields are mapped and the data is imported into our SQL databse, an analysis must be done. This will create the following report: a. Total minutes we show b. Total minutes they show c. Total number of extra/missing records d. Total minutes over/underbilled by the vendor e. Total dollar amount over/underbilled by the vendor Once the report is generated, a csv file will be prepared for download which will contain the information necessary to show the vendor what CDRs contain discrepancies. Within the text file, there will be their CDR and ours on the same line to identify the discrepancies. These will be the disputed CDRs. Disputed CDRs will consist of the following: a. Extra/missing records d. Minutes over/underbilled e. Inaccurate amounts over/underbilled If you do not have any experience in the telecom field or have never done such a project, I recommend you do not bid as explaining the entire business and process flow will take up too much of both mine and your time. Thank you.
ID del proyecto: 423028

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 15 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
4 freelancers están ofertando un promedio de $225 USD por este trabajo
Avatar del usuario
I`ll do it..
$250 USD en 10 días
5,0 (26 comentarios)
5,6
5,6
Avatar del usuario
Hi This is Piyush Patel I have 4 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM
$200 USD en 10 días
5,0 (11 comentarios)
4,1
4,1
Avatar del usuario
I've already worked on CDR import and telecom billing application. I can deliver this tool for you. Please reply. regards, John
$200 USD en 2 días
0,0 (0 comentarios)
2,8
2,8
Avatar del usuario
plz see my PM
$250 USD en 60 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
San Francisco, United States
5,0
6
Miembro desde sept 22, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.