Case Study : Business intelligence

Data Analytics and ETL Modernization

ETL Modernization to enable metadata driven data analytics. Enable a single data repository for the enterprise

• Client Company : Wells Fargo
• Business Units : Keane International, Inc.

Re-architected information delivery platform to enable BI adoption, support upgraded ERP, and reduce costs 20%-30%.

Business Intelligence solution center established to support client's information needs. The CoE implemented several data mart and reporting applications to support business functions like Risk & Compliance, Fraud detection, Financial Reporting

• Client Company : Leading Global Money Transfer Service Provider
• Business Units : Keane International, Inc.

Build, Maintain and Operate DataWarehouse & BI Platform

Leve 2 and Level 3 support of Data Warehouse and Reporting applications, enhancements
Architect and build Marketing data marts to enable campaigns and measure the effectiveness of campaigns

• Client Company : Global Office Supplies Retailer
• Business Units : Keane International, Inc.

Comprehensive Data Management and Business Intelligence solution

Set up a Data Management and Business Intelligence CoE, implemented Master Data Management, BI and Dashboards solutions

• Client Company : National Life Group
• Business Units : Keane International, Inc.

POS, Marketing & Workforce Data Mart for Instant Oil Change Retailer

Centralized information repository and BI capabilities to support Corporate and Franchise Operations

• Client Company : Instant Oil change Retailer
• Business Units : Keane International, Inc.

Data Integration solution for Carrier

Improved reporting accuracy , accountability and response time of the reports to the end users.
Better insight into financials

• Client Company : Carrier(manufacturing industry)
• Business Units : Keane International, Inc.

Data Warehouse Development and Support for METEOR

Provided strategic, integrated and time variant enterprise wide data to Data Warehouse to enable informed decision making by Business Users
Better insight into key analysis areas within Sales,  Usage & Billing, Customer Management and Revenue.

• Client Company : Meteor Mobile Communications
• Business Units : Keane International, Inc.

SAP BW Development and Support for Transportation Major

Overall sales summary reports  through Web templates and BEx
Monitoring the performance of plant efficiency  and customer satisfaction
Tracking of delivery delays through reports which in-turn helped to plan for corrective measures in the business process to avoid penalties
On demand report extraction based on business / user needs

• Client Company : Transportation Major
• Business Units : Keane International, Inc.

Optimized BI Enables Leading Aerospace Parts Manufacturer to Hold Steady During Economic Slump

This leading aerospace parts manufacturer had implemented an SAP Business Objects BI solution for enterprise reporting. However, availability to company data for mining and reporting was often a concern due to back-office processing and other issues.

• Client Company : Not Disclosable
• Business Units : Keane International, Inc.

Automotive OEM Purchasing department - controlling of direct materials

Business controlling for direct material purchasing of the BMW AG (ca. 25 bn. €) based on SAP BI 7.0 Business and IT specification

• Client Company : BMW
• Business Units : Cirquent GmbH

Automotive OEM BMW GROUP - Corporate Long Term Planning & Controlling

Integration of project and period, including adjustments of the planning processes
Definition and implementation of integrated report- and target agreement quantities
Process improvement and system support for long term group planning process (6 to 12 years)
SAP BI in Combination with.NET
Internal functions of customer (IT project management, IT architecture, QS, PMO) staffed by Cirquent consultants

• Client Company : BMW
• Business Units : Cirquent GmbH

BI - Automotive OEM Operation of the centralized Multiproject DWH Environment

Product evaluation & architectural consulting
Conception of central migration projects
Operation of 11 multi project environments
B2x portal integration
Monitoring of the availability of the platforms

• Client Company : BMW
• Business Units : Cirquent GmbH

BI - Automotive OEM Redesign/Migration to a Cluster DWH Vehicle & Service data

Replacement of a stand alone DWH with a centrally operated DWH cluster with centric data connectivity to internal and external data sources

• Client Company : BMW
• Business Units : Cirquent GmbH

Unified Reporting System for an Insurance company - SAP BW Enterprise Datawarehouse

The Vienna Insurance Group (VIG) is now one of the largest international insurance groups in Central and Eastern Europe.
In the last years VIG has grown significantly and as a result companies belonging to it show a remarkable variance of IT systems and different understandings of technical terms.
With the introduction of SAP FI/CO a first important step towards harmonization was done recently. In the context of the SMILE program, this strategy will be consistently continued until in the end all operational IT systems in the VIG companies run on SAP.
However this and various other reasons arrogate a need for a harmonized reporting system out of the "old IT landscape" and the "new SAP IT landscape" including unified set of reports, terms and definitions.

• Client Company : Leading Insurance Company in CEE
• Business Units : Cirquent GmbH

Consultant Recommendation Validation Solution

India's largest Fast Moving Consumer Goods company. It is present in Home & Personal Care, Foods & Beverages categories. The company and group companies have more than 35,000 employees.
The company was looking for an efficient system to track their secondary sales and take an appropriate decision based on the analysis of the same. Intelligroup helped the company by building a datawarehousing solution for the same.

• Client Company : Indian CPG company
• Business Units : Intelligroup, Inc.

MSBI Business Intelligence solution

A world leader in the global household, health and personal care sectors operating in no fewer than 60 countries, while their products sold across 180 countries, delivers brilliant and fast-acting solutions to consumers.
The company was looking for an efficient system to track their secondary sales and take an appropriate decision based on the analysis of the same. Intelligroup helped the company by building a web based portal along with an enterprise datawarehousing solution.

• Client Company : Leading global CPG company
• Business Units : Intelligroup, Inc.

Cognos Reporting Solution

A global biotechnology company dedicated to improving the human condition. Their systems, consumables and services enable researchers to accelerate scientific exploration driving to discoveries and developments that make life even better. The company had sales of more than $4.5M in 2009, employs approximately 10,000 people, has a presence in more than 100 countries.
To enable client to provide and manage the huge data volumes more effectively, introduce quality checks to identify problems earlier than being detected today, report/reconcile/audit data more effectively, and to provide accurate information internally and to external stakeholders.

• Client Company : Global biotechnology company
• Business Units : Intelligroup, Inc.

Informatica Development Solution

A diversified technology firm which manufactures and distributes a wide range of products from light bulbs to the latest in consumer technology.
Intelligroup developed a reporting deck with extensive drill down for detailed analysis which are integrated with their existing web portal having reports showing inventory data.

• Client Company : Global conglomerate giant
• Business Units : Intelligroup, Inc.

Reporting and Analytics in Finance,Planning and Logistics

The company is an international specialty pharma company that is fully represented in Europe and the US through its own sales organizations in more than 50 countries. Their products are sold in about 120 countries, and where it lacks a sales organization, it markets and sells its products via agents and other pharmaceutical companies.
Intelligroup is engaged with customer as their BI AMS partner and have been supporitng their overall financial closing, planning and complaince reporting. Our federated portal and interopability solution helped them in managing all users commonly without navigating in multiple portals.

• Client Company : Specialty pharma company
• Business Units : Intelligroup, Inc.

Enterprise Datawarehouse & Reporting Factory

The company is the world's leading education company. From pre-school to high school, early learning to professional certification, our curriculum materials, multimedia learning tools and testing programmes help to educate more than 100 million people worldwide - more than any other private enterprise.
Intelligroup engaged with customer as long term BI AMS partner and helped various reporting and analytcis initiatives including system upgrade and stabilizing their BW system. Our global spend solution helped in huge savings in their procurement process, help manage and find right vendors.  Our BI optimization helped setting up right process and goverance and reduction in daily batch cycles.

• Client Company : World's leading education company
• Business Units : Intelligroup, Inc.

Global Financial Datawarehouse

The company is a global specialty pharmaceutical and medication delivery company. Being the world leader in specialty generic injectable pharmaceuticals, the company offers one of the broadest portfolios of generic acute-care and oncology injectables, as well as integrated infusion therapy and medication management solutions.
Intelligroup helped customer in building Global Financial Datawarehosue as part of their Enterprise Performance Management to reduce non value added finance activity and eliminate reconciliation inefficiencies. The solution helped customer improve finance partnership, make timely decisions and make better decison making. Common Master data and ETL Framework helped in standardization globally.

• Client Company : Global Speciality Pharamceutical and Medication
• Business Units : Intelligroup, Inc.

Complete Reporting Sales,Marketing, Suply Chjain ,Financials

The company is primarily focused on the Electronics, Game, Entertainment, and Financial Services sectors.
Intelligroup engaged with customer in upgrade their BW system, Re-designed their data models, migrated all their legacy reporting into SAP BW, and provided real time reporitng in logistics and Point of sales.

• Client Company : Leading global electronics and entertainment company
• Business Units : Intelligroup, Inc.

KPI Framework

The company makes highly integrated, analog and mixed-signal semiconductors. With revenues of a billion, the company is one of the fastest growing semiconductor companies.
Intelligroup engaged with customer in laying out the KPI framework for their 'C' executives to help monitoring their organizational level KPIs. The framework helped in aligning their all Line of Businesses to contribute their portion and roll up to top level KPIs.

• Client Company : Leading chip Manufacturer
• Business Units : Intelligroup, Inc.

Asset Utilization Dashboard

Customer is a leading global medical device company that develop, produce and market instruments, implants and biomaterials for the surgical fixation, correction and regeneration of the human skeleton and its soft tissues.
Intelligroup helped customer to solve their biggest pain area "Medical device tracking & utilization" by developing complete BI solution and executive dashbaord to track the devices and to improve asset utilization to generate sales.

• Client Company : Leading global medical device company
• Business Units : Intelligroup, Inc.

Core Team in BI Center Of Excellence

The largest producer of quality confectionery in North America and a global leader in confectionery. The  company has operations throughout the world and more than ten thousands employees.
Intelligroup is engaged with customer in various BI initiatives in the areas of Finance, Sales/marketing and Planning, system upgrades and in stabilization.
As part of long term BI vision to obtain single version of truth and to bring in the process excellence, we currently engaged with customer within their core team under BI Center of Excellence to standardize BI, eliminate reporting silos, Increase Reusability and to reduce costs.

• Client Company : Large confectionary
• Business Units : Intelligroup, Inc.

Supply Chain Analytics , Executive Dashboards

Fender Musical's vision is to champion the spirit of rock-n-roll throughout their work, and their mission is to exceed the expectations of music enthusiasts worldwide. Fenders iconic brands are known worldwide as the instruments that started the rock revolution, and they continue to be highly prized by musicians and collectors.
As a BI Application Development and Maintenance partner, Intelligroup helped customer in building solid foundation by transforming into BI maturity shop that helped improving operational excellence. Executive dashboards were built to provide visibility andinsight into their overall supply chain and finance to make better decisions. The real-time data helps with visibility and allows management to make informed decisions in a timely manner.

• Client Company : Fender Musicals(world's leading guitar manufacturer)
• Business Units : Intelligroup, Inc.

Largest Telecommunication company Case Study

A national provider of wireless voice, messaging, and data services capable of reaching over hundreds million Americans where they live, work, and play.
Intelligroup engaged with the customer to upgrade their BI systems and revitalized their architetcure to increase BI adoption and user acceptance. Currently supporting the application development for all their BI and Datawarehouse systems across platforms.

• Client Company : Large Telecommunication Company in USA
• Business Units : Intelligroup, Inc.

Major Communication and Hitech Industry customer reduces ongoing Hyperion maintainence and Supports costs

Leader in wireless transmission solutions applying innovation and IP networking expertise toward building a carrier class foundation for future mobile and fixed broadband networks.
Intelligroup got engaged with the customer to provide the portfolio of services around Hyperion application management support. Intelligroup was required to stablize, optimize and continously improve the Hyperion system for better system avialability, unleash more business benefits and maintain the same in a good health

• Client Company : Major Communications and Hi-tech Industry customer
• Business Units : Intelligroup, Inc.

Hyperion Upgrade for a leader in Hi-tech Industry

Leading provider of wireless and wired technologies for the mobile, networking, computing and consumer electronics markets.
Customer was troubled with core performance issues and lot of deviations due to its operational older version of Hyperion suite. Intelligroup was engageged to help them with Hyperion 11 version upgrade.

• Client Company : Leading Hi-Tech customer
• Business Units : Intelligroup, Inc.

Worldwide leader in intelligent semiconductor solutions goes live with Hyperion

Worldwide leader in intelligent semiconductor solutions that are powering next-generation Internet networks.  NetLogic Microsystems' best-in-class products perform highly differentiated tasks of accelerating complex network traffic to significantly enhance the performance and functionality of advanced 3G/4G mobile wireless infrastructure, data center, enterprise, metro Ethernet, edge and core infrastructure networks.
The customer engaged Intelligroup for deploying Hyperion Planning and Oracle Data Integrator in smothening the complex revenue recongition process

• Client Company : Worldwide leader in intelligent semiconductor solutions
• Business Units : Intelligroup, Inc.

Major Media and Entertainment Company goes live with Hyperion

Major Media and entertainment company which combines information, technology, services and applications to create ingenious entertainment solutions for the global market.
Intelligroup deployed Hyperion Suite to help the customer in streamlining the financial budgeting and planning process.

• Client Company : Major Media and Entertainment Company
• Business Units : Intelligroup, Inc.

Hyperion Implementation for a major Outsourcing Company

UK's leading outsourcing company, providing leading edge of redefining and transforming services.
Intelligroup helped them by providing a smooth Hyperion implementation roadmap and deployment strategy for driving financial execellence.

• Client Company : Leader in Business Process Outsourcing
• Business Units : Intelligroup, Inc.

Honorable Mention in Oracle Titan Awards 2010 for Hyperion Implementation

The Aricent Group is a global innovation and technology services company that helps clients to imagine, commercialize, and evolve products and services for the connected world.
Intelligroup's Hyperion implementation engagement at Aricent is highly commendable which included sheer thought leadership and industry recognized Best Practices. According to one of the spoksperson of Aricent "Oracle's Hyperion based solution implemented by Intelligroup reduced Aricent's closing time and reporting time, as well as, simplified our inter -company reconciliation process.  The project was executed very well and we achieved the business benefits anticipated including better compliance and reduced costs resulting in an excellent return on our investment."

• Client Company : Aricent Group
• Business Units : Intelligroup, Inc.

Migrating Oracle Reports using Oracle BI Publisher

BioMarin Pharmaceutical Inc. (BioMarin) develops and commercializes pharmaceuticals for serious diseases and medical conditions. The Company's product portfolio consists of four approved products and multiple investigational product candidates. Its approved products include Naglazyme (galsulfase), Kuvan (sapropterin dihydrochloride) tablets, Aldurazyme (laronidase) and Firdapse (amifampridine phosphate).
Biomarin engaged Intelligroup in streamlining their sales and distribution function by deploying Oracle BI Publisher

• Client Company : BioMarin Pharmaceutical Inc
• Business Units : Intelligroup, Inc.

Streamlining reinsurance process leveraging Oracle BI Suite

Leading provider of risk management services, insurance and reinsurance brokerage and human capital and management consulting.
The customer engaged Intelligroup to help create a large-scale BI solution which will fit in their business scenario for quick analysis and effective decision making

• Client Company : Leading Financial Services Company
• Business Units : Intelligroup, Inc.

Out-of-box reporting and analysis

New Age Electronics serves more than 70% of America's leading consumer technology retailers and hundreds of smaller independent and online merchants. The company strive to be a one-stop-shop for digitally-converged solutions, including: consumer electronics, home theater, networking and computing, imaging and printing, digital photography, mobile audio, handhelds, GPS, security, small appliances, supplies, peripherals, and more.
New Age Electronics being a large scale consumer product distributor required Intelligroup to help with a BI solution which can provide out of box reporting and analysis of their sales and distribution.

• Client Company : New Age Electronics
• Business Units : Intelligroup, Inc.

Improved Business Insights with real-time-data access

A pioneer and leading manufacturer of copper indium gallium selenide (CIGS) thin-film photovoltaic solar panels. Through a distinctive manufacturing process, MiaSolé has established CIGS as one of the lowest-cost, highest efficiency thin-film solar panels in the world - thus advancing the extraordinary potential for harnessing solar power as a competitive, sustainable energy source.
The client engaged Intelligroup for delivering a concrete BI strategy which could help in enhancing its operational visibility.

• Client Company : Leading Solar Panel Manufacturer
• Business Units : Intelligroup, Inc.

Driving Management Execellence with Oracle Business Intelligence Entreprise Edition (OBIEE)

Leading provider of clustered computing and storage, high-performance compute and storage, and data center technologies integrated with a choice of software, customer support services and professional services. It develops, markets and sells a range of low cost, mid-range and high-end computing servers and data storage, as well as differentiating software. It sells data center infrastructure products purpose-built for large-scale data center deployments
Intelligroup helped in migrating customers multiple Buiness Intellgence reporting legacy systems to a single source of truth - Oracle Business Intelligence Entreprise Edition (OBIEE)

• Client Company : Leading Hi-Tech Manufacturing and distributor company
• Business Units : Intelligroup, Inc.

Creation of a Cognos 8 Financial Risk Management reporting platform for a major global bank.

The Revere Group was engaged to develop Cognos 8 BI reports for business users across every division in the company.  The project was part of a multi-year program being undertaken by the finance division to redesign the risk and financial management process across the corporation and enhance the tools used by both Corporate Financial Management and business unit managers to make better informed business decisions.  Subject areas covered in this project included Finance, Accounting, Activity Based Costing Allocations, and Revenue Allocations.  The reports developed by The Revere Group are used in large part by global cost and profit centers to provide insight into previously unavailable data, and to analyze the new allocation methodologies, including the firm’s Costing and Revenue Allocations process, and monthly operational and financial actual-to-plan variances

• Client Company : Major Global Bank
• Business Units : The Revere Group

Business Integration Reporting
Being an SAP Implementation Partner

As one of Australia and New Zealand's largest retailers with more than 300 stores, 5000 team members and annualized sales in excess of $800 million, ASX-listed SuperCheap Auto Group Limited has increased their store network substantially since their initial SAP for Retail Enterprise Resource Planning (ERP) implementation in 2003.
Since 2003, the company has implemented a range of SAP tools and has remained committed to both SAP and Extend Technologies as their implementation partner throughout the journey. "You get the feeling with [Extend] that they're always looking for ways for us to improve. They know our business really well so they don't bring us product offerings for the sake of it, it's always targeted, [and is] something that will benefit us," says SuperCheap Auto Group Limited's CFO, Gary Carroll.

• Client Company : SuperCheap Auto
• Business Units : Extend Technologies

Designing a Strategic Data Governance Program for a Leading Energy Producer
Harnessing Analytics

The client engaged Revere to help create a large-scale data governance program across all divisions. Revere helped the client define the strategy for data governance and create an internal hybrid organization that would work in the shared service/distributed organization that makes up the operating structure of the company. Revere also helped the client develop data governance processes to ensure proper workflow and management of the governance function across the hybrid governance organization.

• Client Company : Not Disclosable
• Business Units : The Revere Group