IT Services: Distribution & Logistics

Search

Distribution Home

CPFR

eDistribution

Supply Chain Management

Logistics and Courier

Retail Solutions

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

Privacy

Sitemap