Data Mart & MIS Reporting Implementation

Project Description

Customer has grown through multiple acquisitions and has led to proliferation of different source systems for POS, Inventory, Purchase, Warehouse thereby not able to provide a single view of: Sales, Profitability, Spend Analysis, Inventory. Project was executed over a period of 3 months in an onsite-offshore model with 3 onsite and 6 member offshore team (peak size).

Business Benefits:

  • Identification of $15 Million worth of dead inventory
  • Enabled finance to do month end closing in less than 2 weeks, first time in years

Phase 1 of the implementation involved addressing the Sales, Purchase and Inventory Requirements. Radiare took complete end-to-end ownership in building the data mart, MIS reporting & supporting the data loads.

The Key areas that were delivered as part of the Project Implementation include:
  • Data Mart Development
  • Creation of Data Models for Sales/Purchase and Inventory Data Marts
  • Data Integration from various source systems such as HAYAT, FALCON, WAGDY, KHUNAINY, FPOS among others.
  • Building of Reports for Sales/Purchase and Inventory
  • Running Month-end reporting to address areas such as Weighted Average Cost, Gross Margin per Item among others
  • Support Daily Data Load from various source systems
  • Consolidated Operational Reporting like Daily Sales summary, Current Inventory etc across all systems
  • Historical and analytical reporting – Worst and Best performing pharmacies, relative pharmacy performance in terms of sales returns, Promotion effectiveness – from star schema based model

Technology Areas
Informatica 8.6.1, Microstrategy 9 and Oracle 10g

Client: Large Pharmacy Retailer based out of Saudi Arabia.