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
Project Description:
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.
- 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
Project Description:
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
Project Description:
- 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