Success Stories
Our Success Story

Success Stories
Radiare is a focused solutions company and we are proud of the fact that we have been able to deliver more than 100+ Information Management Projects across the spectrum of Data Management, Business Intelligence, Visualization, Performance Management and Analytics in the past 6 years. We have delivered solutions across the globe in Africa, Saudi Arabia, Dubai, Germany, Thailand, Singapore, UK, USA and India to different verticals such as Retail, Telecom, Banking, Manufacturing among others.
Enterprise Data Management
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
Business Intelligence & Visualization Solutions
Enterprise Management Consulting & Strategy
Project Description:
Radiare is engaged in building the Enterprise Management Strategy for streamlining the information flow across the organization that would aid in building superior Grant Processes.
Key Activities include:
- Use the business strategy of the department/organization for defining information technology and systems architecture to support that strategy.
- Catalogue the data/information, establish information usage by the various business and stakeholder groups, that supports the Grant Management Process.
- Development of business logical Information Model and Data Flow Architecture for new Grant Life Cycle process.
- Define and identify reference data, and provide strategy and process to harmonize Master Data creation and access across the organization
- Identification of needs for Data Integration, Data Life Cycle management related to Grant Management
Consulting & Advisory for Analytics Practice
Project Description:
Client: India based Third Party Outsourced Customer Service Provider.
Cross Channel Reporting For A Large Media House
Project Description:
The end client is one of the largest media house which carries out media planning, execution and reporting for its end clients.
Key Challenges:
- Diverse data sources varying with client and high volume associated with click level tracking
- Identification and implementation of standard sources and standard reports for a diverse client base
- Seamless and reduced timeline to onboard multiple clients
- Ensure data reconciliation with standard reports published by data providers
Solution
- Build of Standard connectors to source all data from data providers to ensure standardization across clients
- Build of a data warehouse at the most granular level to provide comprehensive reporting & analytics capability
- Client specific marts to ensure robust security and address client specific dimensional reporting
- Flexibility of user specified visualization tools accessing SSAS cubes
- Rich set of auxiliary applications
- Extend reporting capabilities through user defined KPI
- On boarding tool to ensure seamless on boarding of multiple clients with diverse requirements
- Robust validation process to ensure reconciliation with data providers
Benefits
- Creation of a consistent data asset integrating multiple sources for enterprise wide use in a secure manner
- Ability to determine efficacy of different media channels on a single reporting platform
- Near real time reporting that allows alteration to campaigns
- Increased leverage of platform through seamless on boarding of multiple clients
Business Analytics & Big Data Solutions
Analysis of Customer Satisfaction Index Scores
Project Description:
Client: India based Large Financial Services Company
Marketing Solution using Predictive Analytics
Project Description:
The predictive model solution involves:
- Churn Management: For the Churn Management, the solution built provides output in the form of churn probability scores for the subscribers. The Subscribers are sorted in descending order of churn scores to divide them into ten deciles (groups). The top 3 deciles capture 88% of churners. The model is refreshed every 7 days.
- Segmentation Management: In case of Segmentation management, the model output divides the subscribers into 6 clusters with subscribers within the same cluster having similar characteristics. The subscribers identified by the models are targeted through promotion campaigns. Effectiveness and efficacy of campaigns to be determined by having control groups
Potential business benefitted from the above exercise resulted in revenue increase of around USD 1.8 Million.
Client: Large India-Africa Telecom Service Provider
Demand Forecasting of Merchandise
Project Description:
The Sales data contains:
- Sales past data for variant SKUs
- Contains different number of sold SKUs in past
- Contains inventory product id
- Contains SKU id
- Contains color, brand, discount, dimensions columns to calculate color index, brand index, discount band
Demand calculation:
Demand is forecasted by taking sales value of product, counts of product sold earlier, brand index, discount band, price band, topic values (deal text data), seasonal index and color index. Most of these values are a value of strings but we converted them to numbers by using index using moving averages (in case we have sales data for all the 52 weeks for that brand or color).
Topic modeling and forecasting and validation:
Topic modeling is done by using text mining using tools like R, Pyhton and SAS using the text information from deal text data, like color, brand, shape, size etc. The solution looks at clustering similar words into different cluster (we call them topic1, topic2 etc), this is done by latent drichlette allocation.
The prediction window is for 7-15 days, the prediction monitored everyday using web based tableu account and the model is refreshed in every 3 months.
- The benefit of having a forecast model is to ensure higher customer satisfaction in terms of delivery time and availability of product.
- The forecast model also helps the company to ensure to have to correct amount of inventory at disposal.
- The liquidation cost is also reduced by a large amount and hence saves lot of cost.
Prediction of Propensity Score for Advt Clicks
Project Description:
Key challenge is the processing of click through rate data is difficult to perform on standalone system due to large volume of data. Also it leads to Increase in cost of infrastructure due to space usage and processing time.
The solution proposed include:
- Hadoop is used to distribute the big data across various systems connected
- Cloudera is used for managing the big data with integration of R and Hadoop
- R is used to as an analytical tool to build the business model based on CRISP-DM
The customer was greatly benefitted in terms of:
- Reduced costs as all the tools are open source
- Better efficiency due to increased processing of big data in real time
Propensity to Renewal ans Cross-sell Modeling
Project Description:
Radiare built Analytical Models for Propensity to Renewal and Propensity to Cross-sell that helped to Optimize campaigns and in identifying the most potential customers.
The work involved
- Identify modeling variables and model dataset development
- Data examination and preparation for rectifying anomalies
- Bivariate analysis for identifying important variables
- Logistic regression analysis for developing the final models
- Apply the models on new data for identifying potential customers
Social Media Intelligence
Project Description:
The Solution helped in :
- Monitoring Buzz/Online activity related to the Client’s brands and products.
- Identification of features likely to have an impact on choice
- Identification of possible online opinion leaders / influencers for targeted messages / updates on product features
- Structuring / Restructuring of market survey questionnaires based on buzz research
Client: India based Home Appliances Major
Performance Management Solutions
Financial Consolidation Solution
Project Description:
Radiare is involved in:
- Requirement analysis, design, planning dimensions and outline metadata based on the Chart of Accounts in financial system.
- Interaction with users to understand the current methodology and account principles used to work out consolidation rules.
- Development of consolidation rules using VB scripts to automate calculations for Minority Interest Calculations based on the Ownership principles used for consolidation as per Accounting Standards (IFRS requirements).
- Training the end users (incl. administrator) and facilitating the UAT process
Budgeting and Planning Solution
Project Description:
- Various scenarios of Budgeting are captured in Hyperion Planning and are compared with their Actual performance.
- The solution also helped the Organization in publishing their monthly Actual reporting to their Management and to their Parent Company.
- The solution involved pull data from their ERP system and the Budget data is pushed back to the ERP system from Hyperion Planning.
- Solution Analysis and Design of the budgeting model and Actual reporting system.
- Budgeting Modeling and building covering many steps starting with setting the baseline till final consolidation and approval
- Bottom up budgeting and what if analysis as part of the Budgeting process
- Designing driver based cost allocation to various Rigs.
Product Engineering & Platform Solutions
Competitive Intelligence for Pharma
Project Description:
The Competitive intelligence information is gathered from different sources and uploaded into the platform at regular intervals of time with respect to different molecules and therapeutic areas and the same is presented in a structured format for the end users. The platform also provides advance search capabilities for the users for uploaded content. The Competitive Intelligence platform also has the features for collaboration like discussion forums, messaging, sharing as well as search capabilities for the end users.
Solution Benefits:
- Provided efficient and standard content repository for the users on competitive intelligence information
- Facilitated user collaboration and discussions to share ideas and strategies with respect to specific molecules
- Advance search capabilities for the users to easily find relevant information
Architecture Consulting
Objective
Architecture Constraints:
- 1. Platform should offer high level of customization
- 2. High degree of modularity to leverage components in multiple applications
- 3. Seamless data integration from different data sources and varied format
- 4. High degree of personalization, collaboration and automation
- 5. Reduce operational overhead
Proposed Architecture:
Radiare architects proposed architecture based on the Microsoft tool stack of ASP.Net and SQL Server 2008 with integration with Sharepoint portal being optional. The architecture provided included logical, technical and physical architecture. The propose architecture also laid out the guidelines for Securit, Caching, Data Flow / Data Access, Data Storage Design, State Management, Transaction and Exception.
- Reusability
- Maintainability
- Scalability, through Horizontal Scaling ( Scaling Out)
- Security
- Optimum resource utilization
- Easy Extension & Maintenance
- Scalability & Performance
Client: Client is a leading solutions provider in the Retail space.