Applying Thought   
About Wipro
Newsroom
Investors
Careers
  
   
Wipro Technologies Consulting IT Services Product Design Business Process Outsourcing CONTACT US
 
Case Studies
Ideas
 
Search
Distribution Home
CPFR
eDistribution
Supply Chain Management
Logistics and Courier
Retail Solutions
 
Global Sourcing Lounge
 
 
 
DISTRIBUTION
Case Study
 
Enterprise data warehousing applications for a contract logistics company
 
 
The customer
Our client is a leading full-service contract logistics company that uses advanced management systems to integrate and simplify complex logistics operations globally, including order fulfillment, transportation, storage and distribution.
 
The challenge
Our customer wanted
 
To avoid service disruptions,
To enable supply chain visibility to customers, and
Manage inventories and labor costs.
To deliver innovative, value-added solutions to attract and retain customers and to differentiate themselves from their competitors,
To be able to achieve the above the customer needed real time access to critical business factors like Customer satisfaction & On time delivery, carrier compliance Supply chain visibility, capacity management and cost of delivery
 
The solution

Wipro provided business consulting and was responsible for building the business case and implementation road map after studying the information requirements and existing process for gathering information. We addressed the inadequacy of ETL tool for data load requirements and also managed design issues with the implementation on AS400.

 
Business benefits to the client
Availability of reports on various aspects such as modes of transportation, in-transit damages, carrier performance, shipment information etc
Completion of project in a short duration of under 5 months
 
Technical environment
Transportation data mart includes one Essbase MDDB cube that provides multi-dimensional views on various dimensions such as carrier, shipment mode, warehouse, consignee city etc. and measures such as number of shipments, total weight, costs paid to carrier etc.
Hardware - AS/400
Database - DB2/400
Data modeling tool - ERWin
Data ETL - RPG/SQL
Reporting/OLAP analysis - Cognos Impromptu, DB2 OLAP server, Show case analyzer
   
  Send us an email
Request proposal for services
Subscribe to our monthly newsletter
  CASE STUDIES
Improving the returns process of an apparel and sports accessories retailer
Localization of Unified Freight System for a global freight forwarder and logistics services provider
Wipro helps Exel Logistics improving customer service, optimize costs and build a sustainable competitive advantage
  More case studies

 
Contact us Terms of use Privacy Sitemap