| |
| Case Study |
| |
Patni's BI solution enables business-critical, cross-functional analysis for large client in Europe
|
Through the "SMART" data warehouse, Patni provided highly efficient reporting capability outside enterprise-wide SAP R/2, using a cost-effective onsite-offshore model.
The Client
One of Europe's largest lighting manufacturer and supplier, with manufacturing facilities and distribution centers throughout Europe.
The Challenge
The client had implemented the SAP R/2 system to cater functional areas such as Finance, Logistics, Manufacturing, Customer Service and Sales Invoicing. All transactional data was captured in SAP and then used for conducting day-to-day business functions and activities.
The client required to:
 |
Reduce the costs involved in Mainframe usage |
|
Extend the ability of enterprise-wide SAP R/2 implementation to provide cross-functional reporting |
|
Measure, improve and control distribution processes |
|
Provide business-critical reporting outside SAP R/2 thus off-loading processing from the Mainframe environment. |
Patni collaborated with the client to build SMART (Sales & Marketing Analysis, Reporting Tool), a global data warehouse where data collected from SAP & Manugistics is refreshed on a daily basis.
The Solution
The Patni team used its proven BI-Data Warehouse Implementation Roadmap to develop the solution. Salient tasks engineered and executed successfully by Patni team were:
|
Analyzed existing reports from SAP and other systems |
|
Created a star-schema design to meet the Analytical Reporting requirements |
|
Designed an Oracle database to implement the star schema and Business Objects Universe for reporting |
|
Designed and constructed a fully automated ETL process to extract data from SAP R/2 system and load it into the data warehouse |
|
Developed reports using Business Objects and Web Intelligence
|
|
Provided on-going maintenance support for the environment including production support. |
The Technology
|
Methodology: JAD sessions for Requirements gathering |
|
Source System: SAP R/2, Manugistics |
|
Tools: PERL, Business Objects, Web Intelligence |
|
Server: Windows NT |
|
Database: Oracle |
| |
 |
The Benefits
|
Enabled power users with cross-functional reports outside enterprise-wide SAP R/2 |
|
Cost reduction due to elimination of resource hungry reports from mainframe |
|
Effective Supply chain management |
|
Better forecasting and fulfillment rate on Customer Orders |
|
Better control on Sales & Distribution in Europe |
|
Increased Customer Satisfaction |
|
Critical metrics like DSR, SPAN, Inventory Turns. |
|
