© Hexaware Technologies. All rights reserved. www.hexaware.com
Business Analytics for Global leader in the production of copper, goldand molybdenumClient Overiew
Client Benefits
Case Study Manufacturing
Hexaware Approach
A leading International Mining company wanted to acclimatize to an EDW environment from Legacy Systems, SAP and to provide ad-hoc capabilities on
Business reporting / Dashboards to 2000 end users spread across 20 locations with local currency support
Solution Framework
The Challenge
Value Delivered
RDBMS
OLAP tools
ETL Tools
O/S
Transaction Systems
Other EDW Application
Teradata 13.1 , Oracle 10g
Business Objects 3.1
Business Objects Data Services 3.1
Unix, Windows
Ellipse, SAP ECC 6.0
SAP BW, Teradata EDW
Technology Environment
India Headquarters
152, Sector – 3 Millennium Business Park
‘A’ Block, TTC Industrial Area
Mahape, Navi Mumbai – 400 710
Tel.: +91-22-67919595
Fax: +91-22-67919500
APAC Headquarters
180 Cecil Street,
#11-02, Bangkok Bank Building,
Singapore 069546
Tel.: +65-63253020
NA Headquarters
1095 Cranbury South River Road
Suite 10, Jamesburg, NJ 08831
Tel: 609-409-6950
Fax: 609-409-6910
For all Hexaware office locations, visit: http://www.hexaware.com/worldwide.htm
EU Headquarters
4th Floor, Cornwall House
55-57 High Street, Slough
Berkshire SL1 1DZ, UK
Tel: +44 (0)1753 217160
Fax: +44 (0)1753 217161
About HexawareHexaware is a leading global provider of IT &
BPO and consulting services. The company has
achieved a leadership position in Business
intelligence solutions across a wide range of
domains such as Banking, Financial Services,
Insurance, Travel, Transportation, Logistics, etc.
Hexaware focuses on delivering business results
and leveraging technology solutions by
specialising in Business Intelligence & Analytics,
Enterprise Solutions, Quality Assurance and
Testing Services, Founded in 1990, Hexaware
has a well-established global delivery model
armed with proven proprietary tools and
methodologies, skilled human capital and SEI
CMMI-Level5 certification. Hexaware has a
significant presence in the European market with
local offices in the UK, Germany &the
Netherlands. Our global footprint spans across 5
continents, 20 countries and 31 locations.
Hexaware assessed the current IT environment, including PeopleSoft and SAP (PeopleSoft
replaced by SAP later) and prepare a strategic roadmap for building EDW
Analysis of compensation, benefits, payroll and safety, Inventory, Stock-in Transit, etc. and
developed mappings to transform data
Admin activities by offshore for BODS(Configuring, Scheduling and Monitoring of the ETL Jobs)
Developed reports to facilitate end-user reporting
•
•
•
Operational Asset Analytics done in key areas
like Asset Availability & Efficiency, Perfor-
mance & Quality, Production, Utilization &
Maintenance, Consumables
Integrated data warehouse provided a unified
view of organizational information
The response time was reduced by Massivep-
arallel Processing feature of Teradata
Built the semantic layer with business
definitions to foster end-user reporting
Developed 1000+ reports using 4 TB of
database volume to address the functional
areas like HR, Supply Chain and Sales
•
•
•
•
•
Creation of an Enterprise Data Warehouse on Teradata platform, with data sourced from SAP
Developed reports addressing the functional areas like HR, Supply Chain and Sales
Leveraged Hexaware’s pre-built frameworks such as HR, Supply Chain for accelerated deployment
Support and Maintenance of warehouse
•
•
•
•
•
•
The organization’s existing reporting requirements was addressed largely by ERP suites, People-
Soft and SAP. The existing reporting environment could not satisfy the enterprise HR and Supply
Chain needs in analyzing various domain areas like compensation, benefits, payroll and safety,
Inventory, Stock-in Transit, etc.
Reporting out of the ERP suites (People Soft, SAP) resulted in resource contention and perfor-
mance
•
•
•
Data Quality was > 99.99% therefore it helped business to take timely decisions
Decrease in the HR Analytics solution effort by 40% through Hexaware‘s Pre-Built Logical Data
Model/Framework
Increase in throughput of service requests on a monthly basis leading to faster turnaround time for
new user requirements