Transformation of telecommunication records

A computing system for automatically parsing non-uniform telecommunication data, the computing system comprising:

• one or more processors coupled to a memory, the one or more processors and memory configured to:
• receive a first telecommunication record, the first telecommunication record comprising a listing of at least one communication between a first telecommunication device and one or more second telecommunication devices, and
• for each communication between the first telecommunication device and one or more of the second telecommunication devices:
• (i) a cell site reference, (ii) communication date and time data, and (iii) one or more of:
• communication duration data, communication direction data, communication type data, a first telecommunication device identifier, or a second telecommunication device identifier for the one or more of the second telecommunication devices;
• identify, based on the first telecommunication record, a telecommunication provider associated with the first telecommunication record;
• determine that a first cell site key of multiple cell site keys is applicable during a first time frame;
• select the first cell site key based on the communication date and time data in comparison to the first time frame;
• based on the identified telecommunication provider, select, from a plurality of telecommunication provider rule sets, a first telecommunication provider rule set that defines how to transform the first telecommunication record into a normalized telecommunication record;
• transform the first telecommunication record according to the selected first telecommunication provider rule set to generate the normalized telecommunication record,
• wherein transforming the first telecommunication record further comprises a) parsing the first cell site key to identify a geographic location corresponding to the cell site reference of the first telecommunication record, and b) appending the geographic location to the first telecommunication record;
• and
• generate, from the normalized telecommunication record, a report that displays a relationship between the first telecommunication device and the one or more second telecommunication devices.

A non-transitory computer readable medium storing instructions for automatically parsing non-uniform telecommunication data, wherein the instructions are configured to cause a computing system to:

• receive a first telecommunication record, the first telecommunication record comprising:
• a listing of at least one communication between a first telecommunication device and one or more second telecommunication devices, and
• for each communication between the first telecommunication device and one or more of the second telecommunication devices:
• (i) a cell site reference, (ii) communication date and time data, and (iii) one or more of:
• communication duration data, communication direction data, communication type data, a first telecommunication device identifier, or a second telecommunication device identifier for the one or more of the second telecommunication devices;
• identify, based on the first telecommunication record, a telecommunication provider associated with the first telecommunication record;
• determine that a first cell site key of multiple cell site keys is applicable during a first time frame;
• select the first cell site key based on the communication date and time data in comparison to the first time frame;
• based on the identified telecommunication provider, select, from a plurality of telecommunication provider rule sets, a first telecommunication provider rule set that defines how to transform the first telecommunication record into a normalized telecommunication record;
• transform the first telecommunication record according to the selected first telecommunication provider rule set to generate the normalized telecommunication record,
• wherein transforming the first telecommunication record further comprises a) parsing the first cell site key to identify a geographic location corresponding to the cell site reference of the first telecommunication record, and b) appending the geographic location to the first telecommunication record;
• and
• generate, from the normalized telecommunication record, a report that displays a relationship between the first telecommunication device and the one or more second telecommunication devices.