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:
( 1 review ) Mississauga, Canada

Project ID: #22168495

Awarded to:

expatdev

Proposal discussed privately on the Freelancer message thread for our older, completed project- Theo

$1250 CAD in 5 days
(70 Reviews)
7.3

26 freelancers are bidding on average $1073 for this job

avto35217

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
(13 Reviews)
5.9
karthikbalu7

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)
5.7
topexpert713

Hello, Hi, Nice to meet you! I have read your requirements carefully and I am very interesting for your project. I am confident of this project as I'm a professional Python expert with over 5 years of experience. gith More

$1125 CAD in 20 days
(32 Reviews)
5.5
Softeria

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
(23 Reviews)
5.2
fivestar10

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)
4.8
phonexayphong523

Hi there? I read your project description carefully and I am really interested in your project. I have professional knowledge and rich experiences in C#, C++, Java and Python programming, and I have already finished s More

$1000 CAD in 7 days
(6 Reviews)
4.9
ThinkAndCo

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
(37 Reviews)
4.7
greenguru2018

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)
4.6
jonyahmed105

Hi I can handle it. Thanks

$1125 CAD in 7 days
(17 Reviews)
5.0
kstephens6054

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)
3.3
kiwidaniel

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
(1 Review)
2.8
ichthyocentaurs

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
(4 Reviews)
3.1
mattjparker1104

Hello, How are you? I just saw your project description carefully. I am very interested in your project. I have been developing C/C++, .NET, C#, WPF, ASP.NET, Microsoft SQL Server for 5 years and have rich experienc More

$900 CAD in 5 days
(1 Review)
1.8
makelegend17

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)
2.0
samvisy

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
(1 Review)
2.0
shengui919

As a talented Python developer, I can say, No problem. I understood clearly your project requirements. I know what you want well. If you give me a chance to show my skills, I will be very happy with your work and wi More

$750 CAD in 20 days
(1 Review)
2.0
umairkaramat24

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
(2 Reviews)
1.6
adriantennison

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)
1.5
alextech699

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)
0.0
seniordev96

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)
0.0