Data Mart and 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