- Built a data warehousing solution for Emirates Airlines, ensuring reduced effort and increased visibility.
The Client
Emirates is the world-renowned international airline of the United Arab Emirates, based in Dubai. Currently, 103 aircraft criss-cross the earth to 90 destinations in 59 countries, while Emirates has evolved into a formidable travel and tourism conglomerate.
Solution Highlights
Designed high level ETL, OLAP and Star Schema so as the whole system architecture supported the business requirement.
Consolidation lead time reduced to 2-3 days, down from 15 days earlier.
Reduce user effort in reports generation.
Provide security and audit features to control the dissemination of information and track information usage.
Enablers
Tools: Sun Solaris 8, Win2k, IIS, SharePoint Portal Server, Informatica Power Center, BusinessObjects, Oracle 9i
- Facilitated regional and global needs of a Fortune 500 MNC that sells foods/home/personal care products, with a reporting and analytics platform for sales and supply chain processes.
The Client
A Fortune 500 MNC that sells Foods and Home and Personal Care brands
in about 100 countries worldwide.
Solution Highlights
Kalido - Sales & Supply Chain Reporting and Analytics platform for Sales & Supply Chain proc-esses (Plan/Make/Sell) of Unilever for 14 countries in the Asia-pacific region.
Enablers
Tools: Oracle, MS OLAP, Cognos Powerplay, Cognos
Analysis Area: Sales Analytics, Supply Chain Analytics
- Built an enterprise data warehouse with minimum implementation time, facilitating detailed ‘what-if’ analysis and exception reporting for one of India’s leading pharmaceutical companies.
The Client
One of India’s leading phar-maceutical companies
Solution Highlights
"EDW Development
Enterprise Data Warehouse catering to the Sales & Distribu-tion, Finance, Marketing and Market Intelligence business functions.
The data warehouse facilitates detailed ‘What-If' analysis and exception reporting capabilities. MindTree also incorporated a Generic Error Handling framework to identify and report DW errors. MindTree minimized the implementation time through extensive usage of templated-code."
Enablers
Tools: DTS, SQL Server, MSAS, MS Reporting Services, MS SPS (Sharepoint server), VSS
Analysis Area: Sales Analytics, Supply Chain Analytics, Financial Analytics, Marketing Analytics, Competition Analytics
- India’s largest liquor manufacturer and distributor prioritized initiatives with MindTree’s data warehouse readiness assessment, uncovering potential issues, and recommending KPIs for key business functions.
The Client
India's largest liquor manu-facturer and distributor.
Solution Highlights
DW Readiness Assessment
Data warehouse readiness assessment to uncover potential issues,
identify key initiatives, assess organizational readi-ness, design technical architecture and propose implementa-tion roadmap. MindTree
recommended KPIs for key business functions re-flecting our domain
expertise and knowledge of best practices in the CPG domain. MindTree’s Assessment framework was used to quantify severity of key issues and prioritize initia-tives.
Enablers
Tools: Erwin
Analysis Area: Sales Analytics, Supply Chain Analytics, Production Analytics, Financial Analytics, Marketing Analytics
- 360-degree representation of information with data collected from 15+ disparate sources, allowing capture of sales, CRM, and POS information for the world’s fourth largest tobacco firm.
The Client
World's fourth largest to-bacco firm, which manufac-tures, markets and
sells a range of tobacco and to-bacco-related products across the world.
Solution Highlights
UK Sales Analytics
Greenfield implementation of a data warehouse which cap-tures Sales,
CRM and POS information for Clients products and its competitors
The system Integrates data from 15 + disparate sources pro-viding
business users with a 360 degree representation of relevant information.
Enablers
Tools: Datastage, SQL Server, MS OLAP, Panorama, Kalido
Analysis Area: Sales Analytics, Competition Analytics
- Custom-built a low-TCO template driven enterprise data warehouse based on a strong conformed dimensions framework, assuring scalability for India's largest FMCG company, with leadership in home, personal care, and food and beverage products.
The Client
India's largest FMCG com-pany with leadership in Home & Personal Care Products, and Foods & Beverages.
Solution Highlights
EDW Development
Federated custom-built EDW catering to different business
functions of Client. IMAGE is a multi-Terabyte data warehouse with over
1000 ETLs and 100 + operational and analytical users. The solution is
based on a strong conformed dimensions framework that ensures
scalability. IMAGE uses signature and template-code based reusable components which results in a lower TCO.
Enablers
Tools: DataStage, Oracle, OSA, BO, MSOLAP, Erwin
Analysis Area: Sales Analytics, Supply Chain Analytics, Financial Analytics, Marketing Analytics.
- India's largest FMCG company, leading the market in home, personal care, and food products, was able to provide real time display of forecasted data for sales and planning teams through remote cube implementation in SAP BW.
The Client
India's largest FMCG com-pany with leadership in Home & Personal Care Products, and Foods & Beverages.
Solution Highlights
SAP-APO and BW Reporting
SAP-BW implementation catering primarily to the demand
planning/forecasting system (SAP-APO) for Sales and Plan-ning team
Solution enables real time display of forecasted data through remote cube implementation in SAP-BW.
Enablers
Tools: Oracle, SAP BW
Analysis Area: Sup Supply Chain Analytic, Demand Planning.
- Built a specification and supplier management system to expedite specification creation and supplier approval processes for the world’s second largest fast food restaurant chain.
The Client
World’s second largest fast food restaurant chain with over $ 11 billion
in sales
Solution Highlights
Specification and Supplier Management System
SSMS expedites specification creation & supplier approval process and provides a global sanitized repository of specifi-cations accessible to all customer resources
The system aims to standardize globally, business processes (implemented using lotus notes) for specification and supplier management.
Enablers
Tools: SAP BW, SAP EP
Analysis Areas: Supply Chain Analytics
- Enabled better report presentation through integration of Sharepoint Portal with BO reports, with an enterprise-wide strategic decision support system for one of the biggest business groups in the Middle East
The Client
One of the biggest business groups in the Middle-East hav-ing varied interests in airlines, ground handling, travel and leisure and resorts.
Solution Highlights
MFR
Enterprise Wide Strategic Decision Support System which helps the management to monitor the health of the business
Solution enables better report presentation through integration of Sharepoint portal with BO reports. MFR facilitates flexible report adaptation and presentation.
Enablers
Tools: Informatica PowerCenter, Oracle, BO, Oracle Designer, MS SPS (Sharepoint Server), ASP
Analysis Areas: Financial Analytics
- A leading international air travel association governing operating standards for airlines and airports worldwide was able to assure low response times despite complex reporting logic, with our STB Data Mart.
The Client
A leading International Air Travel Association that governs the operational standards for the airlines and airports across the globe.
Solution Highlights
STB Data Mart
A datamart to monitor the progress of airlines with respect to the Airlines' stated E-Ticket objectives
Low response times achieved despite complex reporting logic and large data volume
Enablers
Tools:Sunopsis, Oracle, BO XI, PL/SQL, ERwin
Analysis Areas: Sales Analytics
- MindTree reviewed existing DW architecture, established a roadmap to address current issues, and a data ownership and corporate data model framework for one of the world’s largest hotel franchisors.
The Client
The Client is one of the world’s largest hotel franchisors
Solution Highlights
CDM & Architecture Consulting
MindTree Reviewed the existing DW architecture and estab-lished a roadmap to address the current issues
MindTree also established Data Ownership and Corporate Data Model framework
Enablers
Analysis Areas: EDW
- Built a regional enterprise data warehouse integrating data from multiple regions, facilitating data loading during working hours with disruption to users and better response times, for one of Asia’s largest asset management companies.
The Client
One of the largest Asset Man-agement companies in Asia
Solution Highlights
Regional Data Warehouse
Regional Enterprise Data Warehouse integrating data from 7 countries across South East Asia
MindTree Implemented 'Materialized View Layer' to facilitate data loading during working hours without any disruption to users. This also ensures better response time. Solution sup-ports multi-currency & multi-lingual reporting
Enablers
Tools: Informatica PowerCenter, Informatica PowerAnalyzer, Oracle
- One of the top 10 companies in auto insurance was able to convert reporting applications based on Crystal Reports to Cognos ReportNet with MindTree’s reporting migration services.
The Client
Subsidiary of leading US based Global Business group and one of the Top 10 compa-nies in auto insurance
Solution Highlights
Reporting migration
Solution involved conversion of reporting applications based on Crystal Reports to Cognos ReportNet. It also covered maintenance & enhancements of ETL subsystem and reports.
Enablers
Tools: Informatica PowerCenter, Oracle, Cognos Powerplay, Cog-nos Reportnet
- Uncovered potential issues, identified key initiatives, and designed technical architecture and purpose implementation roadmap to help prioritize initiatives for a leading third party administrator servicing claims for leading Indian health insurers.
The Client
Leading third party administra-tor servicing claims for leading health Insurance Companies in India
Solution Highlights
DW readiness assessment
Data warehouse readiness assessment to uncover potential issues, identify key initiatives, design technical architecture and propose implementation roadmap.
MindTree recommended architecture components, specific to medical claims processing domain, reflecting our expertise in the healthcare domain. The assessment leveraged Mind-Tree's Assessment framework to quantify severity of key is-sues and prioritize initiatives
Enablers
Analysis Areas: EDW
- Ensured loading of only error-free data and user alerts via email, with PMA data validation services and enhancement of existing ETL subsystem for a leading global investment management organization.
The Client
Leading global investment management organization offering a variety of investment solutions
Solution Highlights
PMA Data Validation
The project involved enhancement to the existing ETL sub system by adding Data Validations using a data-model framework
Validation framework ensures that only error-free data is loaded
Users are alerted about errors through email
Enablers
Tools: Informatica PowerCenter, Oracle, Crystal, Shell Scripts, PL/ SQL
- Improved customer risk assessment with a complex data model framework to manage depthless parent-child frameworks, along with value assessment of the current DW for the corporate banking arm of a leading European bank.
The Client
Corporate banking arm of a leading bank in Europe
Solution Highlights
CDM & Architecture Consulting
Value assessment of the current DW and implementation roadmap for a proposed integrated EDW.
Defined a detailed Product Taxonomy, which is crucial for implementing a sound conformed dimensions framework
Developed a complex data model framework to manage depthless parent-child framework to assist customer risk as-sessment
Enablers
Tools: Informatica PowerCenter, Teradata, Trillium, Avelino
- Developed a utility to incrementally migrate source data to target data, based on mapping performed, for a leading international insurance organization with operations in more than 130 countries.
The Client
A leading international insurance organization with operations in more than 130 countries and jurisdictions
Solution Highlights
Data Migration
Data Conversion and Migration from legacy system to new database to re-use the available data and information.
MindTree developed a utility to incrementally migrate the whole source data to the target data, based on the mapping performed for the same.
Enablers
Tools: SQL Server, DTS, Erwin, SQL Analyzer
- Maintained data marts for business functions encompassing purchase, planning, sales order processing, enquiry management, call tracking, internal sales and supplier recovery for the world's second largest heavy trucks manufacturer.
The Client
World's second largest heavy trucks manufacturer
Solution Highlights
ODC
Maintenance of datamarts for various business functions en-compassing Purchase, Planning, Sales Order processing, Enquiry Management, Call Tracking, Internal Sales and Sup-plier Recovery.
Enablers
Tools: Informatica PowerCenter, Oracle, BO, Q-Designer
Analysis Areas: Supply Chain Analytics, Sales Analytics
- Uncovered potential issues, identified key initiatives, designed technical architecture, and proposed implementation roadmaps with a DW readiness assessment for the Indian market leader in float glass and allied products.
The Client
The market leader in manufac-turing and marketing of float glass and allied products in India
Solution Highlights
DW readiness assessment
Data warehouse readiness assessment to uncover potential issues, identify key initiatives, design technical architecture and propose implementation roadmap.
MindTree recommended the strategy to evolve the Data Warehousing solution into an Enterprise Performance Man-agement (EPM) platform
Enablers
Analysis Areas: EDW
- Minimized user training needs through customized functionalities built on productized solutions with minimal coding, with a SAP DW Dashboard Supplier Scorecard for a leading manufacturer of light, medium, and heavy-duty commercial trucks.
The Client
A leading manufacturer and distributor of light-, medium- and heavy-duty commercial trucks and related aftermarket parts
Solution Highlights
SAP BW Dashboard
SAP BW Dashboard developed by MindTree is a Supplier Scorecard covering 7 Supplier Performance Metrics spread over two categories (Quality and Logistics) in the first phase with 25 reports
User training needs minimized through customized functional-ities built on productized solution with minimal coding
BW web reports integrated with the SAP Enterprise Portal
Enablers
Tools: SAP EP, Oracle, SAP BW
Analysis Areas: Supply Chain Analytics
- Assisted with capture and analysis of key viewership metrics and print/electronic media advertisement costs with faster ETL and ROLAP reporting with huge data loads for a highly renowned media buying arm of a Global Media Group.
The Client
Highly renowned media buying arm of a Global Media Group
Solution Highlights
Media Analytics
Solution to capture and analyze the key viewership metrics and print/ electronic media advertisement costs
Calculation logic enables faster ETL and ROLAP reporting in the face of huge data loads
Enablers
Tools: DTS, SQL Server, MSAS, MS Reporting Services, MS SPS (Sharepoint server)
Analysys Areas: Media Analytics
- MindTree provided support for Legacy ITS federated DW (ETL and Reporting), and developed a new Cognos Reportnet solution for North America’s leading IT infrastructure management company.
The Client
North America 's Leading IT Infrastructure Management Company
Solution Highlights
DW Support
MindTree provided support for Legacy ITS federated datawarehouse (ETL and Reporting). MindTree developed a new Cognos Reportnet Solution.
Enablers
Tools: Informatica PowerCenter, Oracle, Cognos Powerplay, Cog-nos Reportnet, Brio, Actuate, Cognos Impromptu
