Success Stories

Virtusa / Implemented a data warehousing solution for a leading eLearning company
Implemented a data warehousing solution for a leading eLearning company

Our client is innovative leader in eLearning, online training and talent solutions for various enterprises and consumers across the globe.

The client wanted to upgrade their existing data warehouse and disparate reporting systems to make it more efficient and flexible for financial reporting.

  • The Challenge

    Our client’s existing data warehouse and disparate reporting systems were slow and cumbersome, leading to many opportunity losses. The problems included:

    • Managing multiple reporting systems on different platforms and related integration issues
    • Inability of the existing data warehouse, which was developed using home grown tools and stored procedures, to scale with growth
    • Lack of a comprehensive data model to effectively leverage the functionality of Oracle PeopleSoft EPM
    • Frequent issues related to the maintenance of the overall system
  • The Solution

    Virtusa developed a data warehouse roadmap for efficient and flexible financial reporting and analytics. The key highlights include:

    • Developed the DW architecture, leveraging Oracle PeopleSoft EPM
    • Standardized on IBM DataStage for extract, load and transfer (ETL), and Business Objects for reporting and analytics
    • Spearheaded the DataStage ETL design, development and performance tuning efforts
    • Designed and developed business intelligence reporting
    • Developed a migration plan to migrate to the new data warehouse
    • Designed and developed several reporting modules, including Accounts Receivables, Royalties and Sales Commissions
  • The Benefit

    By leading this engagement, Virtusa successfully implemented a data warehousing solution leveraging IBM Data Stage to improve operational efficiency and business agility. The key benefits include:

    • Effectively leveraged our client’s investments in Oracle PeopleSoft EPM
    • Improved reporting and analytics through an optimized data model and efficient data integration capabilities
    • Reduced cost by $167,000 per year by migrating data from unsupported old hardware
    • Reduced data conversion time from 40 hours to 20 hours for processing 110 million rows
    • Drastically reduced labor cost by using our global delivery model
    • Increased availability of the Royalties system by 50%
    • Improved business agility due to faster report generation and enhanced analytical capabilities