In Progress

Telecom Reports

Project Description:

• We currently generate a daily file cdr containing various telecom events

• We require three new daily reports tabulating certain volumes

• We require 2 of those daily reports be consolidated into monthly reports

• Source file is space delimited text file. We will supply field descriptions and source file location.

• These programs need to run on Linux and can be scripted to execute on different source text files.

• We require the source code upon completion of this project.

• Preference to Python. C/C++ and Java also acceptable.

• We can provide an AWS instance for sample files and testing

• Output files need to be comma delimited

Report 1: Bucket Usage Report (Daily)

• Some subscriber usage may deduct from various buckets

• We need a report that gives us total usage per bucket for each account

• There may be multiple voice/sms/data buckets. Each bucket must be reported in different columns.

• Some usage events do not use buckets, but still count towards total records.

• Bucket identifier id may not be consecutive (ie B01, B03, B07, B11).

• Bucket identifier id may be letters (ie S, D, LD, R).

• Output file is required to have 1 row per account

• Output file is required to have several columns, one column per each bucket available on the system.

• Number of buckets is not static.

• Subscribers may not have usage in all buckets

• CDR types to report on are 1,59,81,82,206,207

• Output report:

o DynamicBucketDaily<YYYYMMDD>.txt , where YYYY MM DD match the last 8 digits of inputfile.

o Accountid,rateplan,total_records,<bucket id 1 total usage>, <bucket id 7 total usage>, <bucket “S” total Usage>, <bucket id 8 total usage>,etc

Report 2: Bucket Usage Report (Monthly)

• Consolidate all Bucket Report (Daily) into a Bucket Usage Report (Monthly)

• Output File

o BucketUsageMonthly<YYYMM>.txt

Report 3: Bucket Sweep (Daily)

• Besides normal usage, buckets may be removed from accounts for several reasons (account delete/ account expired/ CTS expired/deleted)

• We need a report that gives us buckets swept per bucket id for each account

• CDR type 106

• Output report:

o BucketSweepDaily<YYYMMDD>.txt , where YYYY MM DD match the last 8 digits of inputfile.

o Accountid,rateplan,total_records,<bucket id 1 swept total amount>,<bucket id 2 swept total amount>, <bucket id 3 swept total amount>,etc

Report 4: CTS Summary (Daily)

• CTS is a type of subscriber purchase used to refill buckets

• CDR will contain account, rateplan, CTS-id, cost, and several other fields

• We need a report that gives us totals per rateplan of CTS-id and costs

• CDR type 105

• Output report:

o CTSSummaryDaily<YYYMMDD>.txt , where YYYY MM DD match the last 8 digits of inputfile.

o <rateplan>,<CTS id>,<total costs for this CTS id for this rateplan>

Report 5: CTS Summary (Monthly)

• Consolidate all CTS Summary Report (Daily) into a CTS Summary Report (Monthly)

• Output File

o CTSSummaryMonthly <YYYMM>.txt

Input would be:

Executable cdrfile=[login to view URL]

Other Goals:

Total processing time for 1,000,000 records should be under 1 minute (negotiable)

Included docs:

1. CDR doc

2. Sample input file (A larger sample cdr file will be provided for testing)

3. Sample output file for each report

4. existing reports for reference

Skills: Python, Linux, Java, C Programming, Hadoop

See more: telecom market size, www telecoms, future of telecom industry, telecom news, telecommunication industry analysis pdf, telecom industry analysis, emerging trends in telecommunication sector, key advancements in the telecommunications industry, examples project closure reports website designers, access project reports, project reports job portal, can final reports project vbnet 2005 win, jasper reports project bid, visual studio 2008 crystal reports project, project reports project college admission, call crystal reports project, mba student project presentation types, mba reports project, desing reports project, telecom based project

About the Employer:
( 5 reviews ) Mississauga, Canada

Project ID: #22168495

18 freelancers are bidding on average $1094 for this job


Hi,sir. I am super interested in your project - 'Telecom Reports' :) I've already done this kind of project before. I believe that my 12+ years of experience in development makes me highly qualified for this project. I More

$1250 CAD in 5 days
(16 Reviews)

Hi, We are a team of professional software developers. We have expertise in Java and can readily work on your task. Kindly consider our proposal for the best results. Looking forward to talking for more information. More

$1000 CAD in 5 days
(103 Reviews)

Great, I have 10years exp with Masters degree Software engineering from Montreal, Canada, with North American Experience working with Fortune 50 Companies Its great that you have put all the information in detail that More

$1125 CAD in 7 days
(6 Reviews)

Hello, I am Asad.I am a Computer Engineer and completed my MS Computer Software Engineering. I have 5 years of experience of Academic writing related to Computer Science and Information Technology. I can show you some More

$1125 CAD in 7 days
(26 Reviews)

Greetings! I saw you are looking for someone to create Telecom Report and I would like to offer my sincere services for your project. I have rich experience of working on the tagged platforms. However, I have certain More

$1250 CAD in 10 days
(4 Reviews)

Dear. Sir. Nice to meet you. My name is kuanhui and I have experiences with lots of project. I have read your project detail carefully. I am sure I can complete your project within your timeline. please message me and More

$1125 CAD in 7 days
(18 Reviews)

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is More

$1125 CAD in 7 days
(19 Reviews)

Hello. I have more than 20 years experience in IT, networking and software development, including working on telco and ISP billing systems (both metering and rating) here in New Zealand. My experience in the field be More

$1200 CAD in 7 days
(4 Reviews)

Hello There. How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills C Programming, Hadoop, Java, Linux, Python. Please start the chat so we can have detailed More

$1250 CAD in 7 days
(6 Reviews)

Hi. I just read your project description and I'm placing this bid seriously. I fully understand your requirement. I'm very skilled with Swift,Objective-C, Java, ReactNative,Ionic for mobile development and JS framewor More

$1000 CAD in 20 days
(4 Reviews)

Hello, Thank you for detailed description! I would like to implement this with using Go language. If you are not familiar with this language, then you can consider it as a compromise between С/C++ and Python/Java. P More

$750 CAD in 10 days
(5 Reviews)

Hi I can handle it. Thanks

$1125 CAD in 7 days
(19 Reviews)

Greetings, I am a skilled Python programmer with significant report generation experience. From reading the specification above I am confident that I can deliver a robust solution for this project. I will need to look More

$1000 CAD in 5 days
(6 Reviews)

Hi,dear client. I am very interested in your project - 'Telecom Reports'. Because I have been familiar with similar projects. Perhaps you need brilliant web and software developers. I will always follow you. I am perf More

$1250 CAD in 7 days
(2 Reviews)

Case: TELECOM REPORTS PROCESSING Solution: Will analyze your requirement for file processing and will implement the same with efficient processing time. Why Should You Hire Me: • I have multiple developers with me f More

$1125 CAD in 7 days
(1 Review)

Hi, Sir. I have read your project description carefully and I can say I am the one you are looking for. Since I am a full-stack developer, I have experienced similar jobs before. And I can do this job perfectly and qu More

$1125 CAD in 7 days
(0 Reviews)

Hello, Thanks for posting !!!! I've checked the requirement and understand that :) I've created S.I.M.I.L.A.R.. Project in past. Do you want to see the DEMO ????? I'm not here most of the time so kindly please More

$750 CAD in 2 days
(0 Reviews)

_Greetings e-meeting you_ Hi, Sudesh here. Over 12+ years of experience in Telecom & Revenue Assurance Projects with developing successful Custom Applications & Report Automation. Profound knowledge of CDR processin More

$1125 CAD in 7 days
(0 Reviews)