Case Studies:

Digital Transformation Services

Digital Transformation Case Studies

Building a Comprehensive Data Warehouse and Reporting/Analytics System Client profile

Client profile:

Large Retail Bank

Client Requirements/Challenges

  • Replace very old MIS system which was extensively difficult to manage and maintain
  • Build comprehensive In-house analytical system to support Bank Decision Support System (DSS) by integrating various heterogeneous databases which supply data at different intervals
  • Replace very old Pro*C programs which takes nearly 5-6 days to process Customer’s Monthly/Quarterly/Annual statements
  • Build financial dashboards (Primary and Secondary, RM Dashboard) to show progress of customer relationship management team
  • Replace existing ASP based E-Statement processing with JSP programs and to reduce processing time

How Ahana helped

  • Ahana was engaged for end to end implementation of Business Intelligence and Analytics
  • We built very comprehensive and robust data warehouse using SAP Sybase IQ by integrating various data sources (Core banking, Loans, Credit Card system, D-mat accounts, General and Life Insurance…) with Star-Dimension data modelling
  • Successfully built automated BODS jobs to integrate various heterogeneous database and to load data to data warehouse in batch mode without human intervention
  • Created various very complicated data marts (Daily, Monthly and Primary & Non-primary) to help generating month end reports
  • We built robust Java programs to replace the troublesome pro*C programs and reduced the processing time from 5 days to 8 Hours.
  • Built various JSP programs to replace older ASP programs and performance improved by 10 times


Business Benefits

  • Fully validated data from various data source became available in one platform which helped various departments to process easily and overall reduced 60% processing time
  • The new analytical system enabled business teams to identify the problem areas and respond quickly
  • Able to process customer statement (both Physical and Electronic) with-in 8 hours of month-end activity as opposed to 6 days in the previous system
  • RM’s able to update and process their progress daily against previous system updates which used to run up-to weeks. This improvement helped RM’s to reach more customers
Building of Data WareHouse and Visualisation Dashboard for Financial and TV Viewership (BARC) data

Client Profile 

Media and Broadcasting Company

Client Requirement/Challenges

  • Build an Enterprise Data Warehouse by integrating Finance and TV Viewership data.
  • Build visualization applications for Operational reporting and strategy decisions with tab/mobile compatible reports and dashboards.
  • Automate jobs to populate data into Data Warehouse with minimal human intervention
    Restrict data visibility only on need-to- know basis
  • Use SAP technology stack (SAP BODS for integration, SAP IQ for DW and Lumira/Webi/Design Studio for visualization)


How Ahana Helped/ How Ahana is engaged

  • Ahana was engaged for Phase I implementation of Finance and BARC Dynamic Dashboards
  • SAP ECC, BARC Data and external file extracts integrated into IQ DW
  • Integration of Data into DW automated using series of BODS jobs
  • Created data marts to help generate monthly reports and dashboards for Leadership and Strategy Team


Business Benefits

  • Finance dashboards based on accounting hierarchy and Business unit hierarchy readily available for strategic business decisions
  • Dashboards for TV Viewership (BARC) and TRP available for decisions around program scheduling and broadcasting
  • Quick comparison of viewership information with competitors over different time scales.
  • Dashboards with KPI’s available on multiple devices with drill down capability

Get in touch with us

4 + 14 =