CloverDX Case Studies Data Integration Automation Recoups 6 Man-Days Of Manual Work Per Month

Edit This Case Study Record

	Data Integration Automation Recoups 6 Man-Days Of Manual Work Per Month CloverDX

Data Integration Automation Recoups 6 Man-Days Of Manual Work Per Month

CloverDX

Technology Category	Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Telecommunications
Applicable Functions	Business Operation
Use Cases	Predictive Replenishment Process Control & Optimization
Services	Data Science Services
Challenge	The company was facing a challenge with the processing of phone invoices that were sent from providers in three incompatible formats. This made electronic merging and processing impossible, and values had to be manually entered into spreadsheets. The spreadsheets were updated every few months, but this caused inconsistencies in historical data. The company was spending 6 man-days per month handling this burdensome task manually. Additionally, the company’s phone bill—$44,000 monthly—had been growing by 24% per year, but it was difficult to gather adequate insight as to why. The company required a solution that would enable them to automate phone bill processing, develop an efficient calls monitoring system through bill analysis, and monitor private and company phone usage to determine the best possible call rates. Read More
About Customer	The customer is a subsidiary of an international company that was struggling with the processing of phone invoices. The invoices were sent from providers in three incompatible formats, making electronic merging and processing impossible. The company was spending 6 man-days per month manually entering values into spreadsheets. The company's phone bill was $44,000 monthly and had been growing by 24% per year. The company needed a solution to automate phone bill processing, develop an efficient calls monitoring system, and monitor private and company phone usage to determine the best possible call rates. Read More
Solution	The company chose CloverDX to address these requirements with a data integration solution. The CloverDX team implemented a solution to consolidate data from all inputs into a uniform structure to enable better subsequent processing. Automation replaced laborious manual processing and also minimized the possibility of human error. Additionally, the implementation of standard test and conversion techniques through CloverETL sped up development and improved the quality of system updates. The company can now break down telephone expenses by person, department, or project, which not only enables the IT department to work more efficiently but also gives the management the opportunity to implement better policies for private phone usage. An additional reporting option was included to supplement the solution package. With real historical data on hand, the company is also able to choose the most cost-effective telephone plan from each provider. Read More Log in to view content
Contents

Technology Category

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Telecommunications

Applicable Functions

Business Operation

Use Cases

Predictive Replenishment

Process Control & Optimization

Services

Data Science Services

Challenge

The company was facing a challenge with the processing of phone invoices that were sent from providers in three incompatible formats. This made electronic merging and processing impossible, and values had to be manually entered into spreadsheets. The spreadsheets were updated every few months, but this caused inconsistencies in historical data. The company was spending 6 man-days per month handling this burdensome task manually. Additionally, the company’s phone bill—$44,000 monthly—had been growing by 24% per year, but it was difficult to gather adequate insight as to why. The company required a solution that would enable them to automate phone bill processing, develop an efficient calls monitoring system through bill analysis, and monitor private and company phone usage to determine the best possible call rates.

About Customer

The customer is a subsidiary of an international company that was struggling with the processing of phone invoices. The invoices were sent from providers in three incompatible formats, making electronic merging and processing impossible. The company was spending 6 man-days per month manually entering values into spreadsheets. The company's phone bill was $44,000 monthly and had been growing by 24% per year. The company needed a solution to automate phone bill processing, develop an efficient calls monitoring system, and monitor private and company phone usage to determine the best possible call rates.

Solution

The company chose CloverDX to address these requirements with a data integration solution. The CloverDX team implemented a solution to consolidate data from all inputs into a uniform structure to enable better subsequent processing. Automation replaced laborious manual processing and also minimized the possibility of human error. Additionally, the implementation of standard test and conversion techniques through CloverETL sped up development and improved the quality of system updates. The company can now break down telephone expenses by person, department, or project, which not only enables the IT department to work more efficiently but also gives the management the opportunity to implement better policies for private phone usage. An additional reporting option was included to supplement the solution package. With real historical data on hand, the company is also able to choose the most cost-effective telephone plan from each provider.

Impact #1	Consolidating call detail records from various telecommunications operators into a uniform structure
Impact #2	Process automation saves manpower and eliminates human errors
Impact #3	Calls audit reduces misuse of company phone policy

Impact #1

Consolidating call detail records from various telecommunications operators into a uniform structure

Impact #2

Process automation saves manpower and eliminates human errors

Impact #3

Calls audit reduces misuse of company phone policy

Benefit #1	37% cost savings annually
Benefit #2	6 man-days per month saved

Benefit #1

37% cost savings annually

Benefit #2

6 man-days per month saved

Download PDF Version

Overview

Data Integration Automation Recoups 6 Man-Days Of Manual Work Per Month

Operational Impact

Quantitative Benefit