Enterprise Data Management

Enterprise Data Management Services

Robust data infrastructure is the key for building an digital enterprise that intends to make decisions based on data and analytics. Radiare has many decades of experiences in building scalable Enterprise Data Management systems and enabling integration with cloud data enablers such as Hadoop platforms for handing Big Data.

Solution Architecture & Data Modelling

Radiare’s Solution Architects and Data Modelers have rich experiences of consulting assignments with customers to aid them in building a robust Data Management solution. As part of this exercise, the work would cover business value assessment, source system study, data analysis, solution and technical architecture, tool recommendations, data quality assessment and data modelling.

Building Enterprise Data Warehouse And Data Marts

Radiare has worked with many customers and numerous projects involving building of EDW and Data Marts. Our team works closely with the business in building the data models, integrating data from various source systems, ensuring data quality, ensuring backup and redundancy for the databases, data migrations as needed, data security and governance to suit the client requirements.

Master Data Management (MDM)

Our MDM solutions help in creating a single, authoritative view of business-critical data from disparate, duplicate, and conflicting information across the enterprise for customers, suppliers, partners, products, materials, accounts, etc. The services are offered in tandem with the services mentioned in the Data Quality and Data Governance section.

Data Quality And Data Governance

To ensure high levels of data quality and ensure right people are accessing the data, Radiare follows tested frameworks for data governance & data stewardship. This includes Data Quality Assessment, Data Profiling, incorporating the Data Governance processes among others.

Data Warehouse On The Cloud

Build Data warehouse on the private cloud or public cloud using technology like Amazon Redshift. Also Radiare has developed strong skills in using open source tool stack for building cost-effective DW solution that are also scalable.

Success Stories

Data Mart & MIS Reporting Implementation

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.

MI Implementation Migration and Reporting

MI Implementation, Migration And Reporting

Project Description:

Radiare anchored the core team that was responsible for building the Management Information (MI) platform. Team from Radiare was involved in working in the following sub-domains of: General Insurance, Banking and Cards.

The activities include:

  • Data Analysis, Requirements Gathering and participated in building the Data Integration and Reporting layer. The subject areas covered include: Saving Accounts, Current Accounts and Credit Cards.
  • Team from Radiare was involved in data separation, migration and testing of data from Royal Bank of Scotland to the UK based bank.
  • Ongoing support and maintenance of the entire MI application platform. The support was provided by teams working in Edinburgh, UK and Bangalore, INDIA
  • Radiare consultants were involved in Fiserv Product Implementation & working closely with Fiserv consultants. Involved in Setting up of the Products, Bonus Plan, New Interest Rates Plans etc as per the Business Requirement.
  • Played active role in implementation of Oracle Financials implementation for the Bank

Tools Involved:

Oracle, IBM Datastage, Microstrategy, Unix/Linux, Fiserv

Client: UK based Bank

 

Preferred Partner for Global Retail Major

Providing Professional Services For Large UK Based Retail Major

Project Description:

Radiare has been working with the Large UK based Retail Major since 2009 and in the last 3 years had delivered more than 15,000 person days of effort in providing Staffing Services in multiple technologies areas from the client’s Offshore Captive Center in Bangalore, India. Involved in:
  • MIS Reporting related activities, involved in analysis of data, weekly, monthly reporting for Procurement Team
  • Supporting in Installation of Oracle E-Business suite, migration of data and maintenance of database
  • Providing support for DB2 Servers, involved in maintenance, fine-tuning of DB2 instances
  • Testing of eCommerce websites and retail applications

Technology Areas
Data Analyst Services, ETL and Reporting Services around Datastage and Microstrategy, Oracle Financials, database Administration in DB2, Oracle Apps environment, Testing – Both MI testing and Web-based application Testing VBA, SQL Server, VC++, Windows Server and Unix

Client: UK based large Retailer