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

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

Product

CloverDX

Tech Stack

Data Integration

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements

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

About The 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.

The 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.

The 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.

Operational Impact

Consolidating call detail records from various telecommunications operators into a uniform structure
Process automation saves manpower and eliminates human errors
Calls audit reduces misuse of company phone policy
Optimized phone rates by switching to the most cost-efficient provider

Quantitative Benefit