Call Center
About Client
Our client is leading call center service provider in USA. Our client had multiple call center sites with hundreds of support team handling support for many bit MNCs in USA.
Business Context
Our client came to Aegis for following.
- Client already had a good technical team which supported their day-to-day operations their team had difficulty properly designing the data warehouse schema.
- Speed the report generation, like some of their reports used to take 12+ hours.
- Team of developer who can quickly design new reports, modify existing reports.
Solution Provided
- After understanding their pain points, we helped them to properly modify their current data warehouse schema.
- We helped them creating new aggregated tables for speeding up report generation.
- By utilizing Pentaho Kettle (ETL tool) we speedup their pipeline for loading data in data warehouse.
- Also utilized Pentaho Kettle as Pentaho report data source which eased the data processing for reports as compared to previous times when data processing was done through SQL procedures.
- By utilized Pentaho BI server’s scheduling feature, we helped them with report scheduling and auto emailing reports to concerned stake holders.
Benefits Achieved
- Report generation time was drastically improved.
- Report generation and emailing was automated.
