ALLinONE

ETL

high capacity, automated, and auditable extract, transform and load functions support timely and accurate data processing

ALLinONE ETL undertakes automated collection of CDR and EDR files from multiple suppliers and locations prior to extraction, transformation and validation of data to deliver consistent billable records that are automatically loaded into the ALLinONE Billing platform for rating. Automation from end to end, ensures that appropriate data is available to be processed by the billing platform with the very minimum of delay, delivering prompt information to the client and their customers.

the value

time and accuracy optimisation are critical measurements in processing third party files, and the automated ALLinONE ETL module minimises the former, whilst maximising the latter.


timeliness of usage based charging data (e.g. CDR), where real time usage feeds or on-line charging systems are unavailable – minimises exposure of clients to lost revenue and their users to bill shock by ensuring that usage is billed without delay.


very prompt collection and mediation of Event Data Records (EDRs) not only ensures prompt rating, but may also be vital in ensuring that the customer experience is positive. e.g. where EDRs are Sim fulfilment completion notifications, the end user may be unable to activate SIM related services until other components of the ALLinONE product suite are informed SIM allocation has been completed.

automation of collection and mediation, 24/7/365, enables ALLinONE integration with third parties’ transferring data through file based interchange, ensures that files are automatically collected and validated prior to further systems processing

improved accuracy with less manual processes

automated extraction, transformation and loading 24/7/365 ensures that data is processed without delay as soon as it is made available

more efficient processing of data

validation of data is automated as part of the transformation to avoid single or multiple data record rejections. Alarms are raised for any failures to ensure that only appropriate data is loaded and that exceptions are promptly resolved

integrity of data improves accuracy

auditable outputs can be used for reporting and alarms, providing prompt exception identification of failures. Data can be used for trend analysis which enables identification of variations in usage volume or record types

powerful analytics insights

mediation rules used during transformation ensure number masking or sensitive usage records are removed from billing output to end users, whilst still being kept for client reporting if required

automated regulatory compliance

bespoke operator configuration available e.g. separating ranges of subscribers or resellers into separate feeds or formatting numbers differently for specific billing feeds

supports bespoke features

 

deployment options

the ALLinONE ETL can be deployed as a stand-alone ETRL tool, alongside ALLinONE Billing to deliver end of end automated billing or within a full ALLinONE suite to deliver an end to end business support system for clients.


Lifecycle provide the ALLinONE product suite as a fully managed, private cloud solution within UK data centres. The infrastructure is specifically designed and proven to support highly available, resilient and scalable environments, capable of processing over 1 billion chargeable events per month. A range for service support options are available to meet the needs of organisations, from new entrants to established providers.

V1.0 Copyright © 2019 Lifecycle Software Ltd. All Rights Reserved

 
 
 

keep in touch

your success is our business driver

arrow&v

contact us

t: 01635 553400

e: info@lifecycle-software.com

visiting us

Lifecycle House

1 Kings Court

Sterling Industrial Estate

Newbury

RG14 5RQ

go to maps

Riverside office

1st Floor, Unit 3

Riverside House

Mill Lane

Newbury

RG14 5RE

go to maps

  • Lifecycle LinkedIn
  • Lifecycle Twitter
  • Lifecycle Facebook

© 2019 Lifecycle Software Ltd. All rights reserved

Lifcycle Software Ltd logo lite