bodhtree'com

1
bodhtree.com
2
Agenda

• Company Overview
• Management Team
• Leadership Team
• Business Lines
• IT Services
• Customer Partner Profile
• Data Hygiene A Global Business Problem
• Common Data Anomalies and Questions
• MIDAS (Multi Industry Data Anomaly Solution)
• MIDAS Offerings
• Turn Key Solution Tool Agnostic Scenario
• Process and Methodology
• Tools and Technology
• Industry expertise
• MIDAS Reference Implementations
• Healthcare Implementation
• Pharmaceutical Implementation

3
Company Overview

• Established in 1999 to offer IT Consulting and
  Development Services
• Early adopters of Web Services
• Established players in data management
• Focus on niche IT solutions
• Funded by angel investors
• Listed on Hyderabad Stock Exchange
• Resource strength of 540 associates
• Offering re-deployable IT solutions and
  professional IT services Incubating
  technology-driven ideas.
• Worldwide customer base including Fortune and
  Forbes Companies
• Awards
• HYSEA Best Product Innovation 2005
• Deloitte Technology Fast 500 Asia Pacific 2007

4
Management Team

• Sanjiv Gupta, Founder CEO
• Over 22 years of industry experience in diverse
  business areas of infrastructure and consumer
  products. Co-founder of several successful
  ventures in Web Services, Digital Media, Online
  Education and other niche business areas.
• Akila Jaikumar Ph.D., Executive Director Sr.
  Vice President
• 14 years at DE Shaw Virtusa as Delivery
  Manager, Global Head of Competency Excellence
  Group. Published 13 papers in International
  scientific journals. CMMi Assessment Team Member)
• Vinay Aggarwal, Director
• 14 years with Unisys Corp., USA (Including 7
  years with Tata Unisys now called Tata InfoTech
  as CFO). Last job with Unisys was as Director,
  Corporate Marketing, Professional Services at
  their world headquarters in Blue Bell, PA. 13
  years with TCS Asia's largest software services
  provider as CFO / Senior Vice President.
• Muktesh Sharma, Director
• Business Partner, Karvy Stock Broking, a
  top-rung financial services company
• Gusti Noria, Director
• Chairman Managing Director, Normak with
  extensive exposure in international trade and
  marketing with number of international
  recognitions and awards.

5
Leadership Team

• Dr. Uma Garimella
• Over 25 years of IT industry and academic
  experience- DE Shaw, SQL Star International and
  Bodhtree. Been at University of Hyderabad as
  faculty in Department of Computer Science.
  Certified information system auditor Specializes
  in program management and enterprise security.
• SubbaRao Devulapalli,
• Over 20 years in IT industry in Healthcare
  domain - specially Hospital Information Systems,
  Spend Analytics and Materials Management.
  Worked in Apollo Hospitals and Perigon
  Consulting, US.
• PVS Chalapathi Rao
• Over 35 years experience in ERP, EAI and
  IT administration. Worked as General Manager in
  BHEL and consulted several PSUs and Government
  Organizations like ECIL, CDM etc Specializes in
  PSU / Government based projects.
• Raghavan Madabhushi
• 12 years in IT industry with ERP, BI-DW, EAI,
  SOA, Web 2.0 implementations with strong project
  and product management expertise. Oracle /
  Microsoft Certified Professional specialist in
  data warehouses and J2EE based implementations.
• Dwarakanath Narasimhan
• Over 25 plus years of experience in Domain and
  about 11 years of experience in SAP
  Implementations/ Support. Headed several SAP
  implementations as Project Manager/Delivery
  Manager in reputed organizations such as ABB,
  TCS, IBM etc. globally

6
Business Lines
Professional Services Solutions
Technology Incubation Group
7
IT Services

• Application Servers Portals
• Web Logic / Web Sphere / IIS / Sharepoint /
  JBoss / Apache-Tomcat / Oracle IAS
• Programming Languages
• J2EE / PHP / MS.NET
• Databases
• Oracle / MySql / MS SQL / HSql / Sybase / DB2
• Case Tools
• Erwin / ER Studio / Rational Suite
• Web Technologies
• HTTP / HTTPS / XML / Ajax / XACML
• QA Tools
• Winrunner / Loadrunner / QTP

• IT Consulting Application Development
• Product Engineering, Release Maintenance
• Data Warehouse Business Intelligence
• Data Cleansing and
• Data Management
• Testing and Test Automation

8
IT Services
9
Select Customers
10
Select Partners Certifications
11
Data Hygiene A Global Business Problem

• According to The Data Warehousing Institute, U.S.
  businesses suffer losses, problems or costs of
  more than 600 billion per year due to poor
  quality data, and typical business between 10
  25 of revenues. Source Aug 2008 newsletter of
  ECCMA
• By 2012, dirty data will cause 50 of insurers
  to have compromised decision-making assumptions,
  despite the deployment of enhanced BI and
  analytic tools. Source - Gartner Inc. research
  report of Feb 2008
• A European Gartner BI survey of more than 600 BI
  users found that more than 35 per cent identified
  data quality as a top-three BI problem facing
  their organisation in the next 12-18 months,
  making it the second biggest challenge overall.
  Source - Gartner report of 22 January 2008 titled
  Organisations Must Establish Data Stewardship
  Roles to Improve Data Quality
• Although 92 of companies surveyed believe having
  an integrated view of customer data is either
  "critical" or "very important," only 2 have
  actually managed to achieve this. Source -
  Forrester Research report
• Research by Marketing Direct magazine indicates
  that direct marketers waste 195m in postage
  costs by sending incorrectly addressed
  international mail

12
Data Hygiene A Global Business Problem

• A survey by QAS found that 28 percent of the
  direct marketers admitted that their company
  rarely cleans its data or in some cases, not at
  all
• 88 M per year is spent mailing the deceased(!),
  100m per year mailing people who have moved
  house
• Up to 67 of UK B2B mailings contain errors
• 37 of companies still do not have a data quality
  strategy in place
• 88 of all data integration projects fail because
  of poor quality data Source http//www.dqglobal.c
  om/, http//www.dataflux.com

13
Common Data Anomalies
14
Data Hygiene - Questions

• Completeness does the organization have data
  assets that are incomplete or missing? Example,
  do all customers have addresses?
• Accuracy Is the organizations data assets
  sufficiently accurate to meet internal (business
  processes, decision making) and /or external
  (regulatory, third parties) requirements?
• Integrity Are the organizations data assets
  consistent across the enterprise? for ex, does
  the list of suppliers in a companys ERP system
  match those in the finance application? Do the
  relationships between different data assets make
  sense? Are duplicates removed from the system?

15
MIDAS (Multi Industry Data Anomaly Solution)
answers and solves these critical and vital
questions.
16
MIDAS Offers
17
MIDAS - Technology

• MIDAS is open standard based J2EE application
  which adheres to best industry practices in form
  of vertical specific pre-canned data /
  application integration steps, data connectors
  and reports.
• SOA JSR 168 compliant architecture
• Comes with Role based access control (RBAC)
  mechanism
• Inbuilt data connectors for industry leading OLTP
  / ERP / DSS systems such as
• SAP, Oracle EBS, JD Edwards, People Soft
• Salesforce, SugarCRM, Siebel On Demand
• Quickbooks
• EDI Connectors
• JMS, XML
• Starlims, Labadvantage etc
• CSV and Excel Files
• ELN systems

18
MIDAS Data Integration Suite
19
MIDAS

• Bodhtrees MIDAS addresses data hygiene issues
  across different verticals, using proprietary
  tools and processes which are flexible, scalable
  and robust.
• MIDAS offers convenient options
• SaaS (Software as a Service), where in customer
  data has been transmitted to Bodhtree servers
  using secure FTP layer. Bodhtree performs data
  hygiene operations and report back results and
  enriched data through web based portal.
• On Premise, where in Bodhtree installs MIDAS at
  customer premises using data hygiene jump start
  templates. Jump start templates are set of tools
  and processes that Bodhtree has built over years
  of experience in handling critical customer
  needs. These templates enable faster deployment
  of solution at customer end.
• Turn-key Solutions, where Bodhtree proven
  processes would be applied at customer location
  using customer specific tools. MIDAS process is
  tool agnostic and can be applied on customer data
  using any existing toolset that customer owns.

20
MIDAS Turn Key Solution

• MIDAS process can be leveraged with existing
  customer tools. Bodhtree team has expertise with
  following tools.
• Informatica
• BO Data Integrator
• Oracle Warehouse Builder
• XFusion (SAP Certified Product)
• Pentaho Data Integrator (Open Source Product)
• JBoss Metamatrix
• Pervasive

21
MIDAS Process Methodology

• Bodhtree has proven data management methodology
  which has been implemented globally to several
  Fortune 500 and Forbes 200 customers.
• Methodology comprises of following stages.
• Data Acquisition
• Data Profiling
• Metadata Analysis
• In Scope Data (9 Step Data Hygiene Process)
• Data Exclusion Steps
• Data Inclusion Steps
• Relationship Discovery
• Business Rule Validation
• Data Enrichment (Domain Specific)
• Client Validation through reports on secure
  portal
• Final Data Dump Integration
• Data Monitoring, on continuous basis

22
MIDAS Expertise

• MIDAS has proven implementations in following
  industries.
• Healthcare
• Financial Services
• Pharmaceutical
• Retail Online Services
• Media and Entertainment
• CRM
• EDI Transactions / Claims Processing
• SCM
• Product Data Management

23
MIDAS Item Master
24
MIDAS - Healthcare Implementations

• Partnership with Owens Minor (Fortune 250
  Healthcare Supply Chain Solutions company with gt
  7 Billion annual revenue)
• Implementations at some of the largest healthcare
  providers in US
• University of Kentucky
• University of Rochester
• Catholic Health East
• Staten Island University Hospital
• Lafayette General Medical Center
• Parrish Medical Center
• University of California, LA
• Memorial Hermann Health Systems
• IOWA Health System
• University of Texas - South West
• West Chester Medical Center
• Lennox Hill
• New York University
• Yale New Haven
• Allina Hospitals and Clinics
• Stellaris Hospitals

25
MIDAS Pharmaceutical Implementation

• Executive Dashboard (BIS) Open standards based
  comprehensive dashboard solution for C group.
  Integrated with BI infrastructure and intranet
  portal. 3 Phases completed. Oct 02 to Dec 04.
  Phase 4 started and expected to end by Mar 09.
• Product Portfolio Management Centralized view
  of molecule, from inception, under development,
  pending approval to sales. Integrating different
  OLTP systems. Completed in Mar06. Phase II
  started and expected to end by Mar 09
• Financial Data Mart Financial Data Mart
  Solution for Formulations SBU, with sales,
  budgets, manufacturing information. Jul04 to Dec
  05.
• Integrated Demand Supply Planning System
  Implemented Integrated Decision Support System
  for capture and analysis of all data required by
  Demand and Supply Planning Processes. Serves as a
  platform for calculation and reporting of Demand
  and Supply Planning Metrics. Partnered with
  Accenture, where Accenture defined the SCM
  processes and Bodhtree provided BI technology. 2
  Phases completed. Jan 05 to Feb 06.

26
MIDAS CRM Integration

• MIDAS integrates with industry leading CRM
  vendors, Salesforce and Siebel on Demand.
• Data in the CRM applications is accessed using
  MIDAS secure web services API.
• Using MIDAS users of CRM applications can detect
  duplicates among contacts, leads and prospects.

27
MIDAS - Advanced Analytical Engine
Retail
Entertainment
HealthCare
Pharma
Media
Others

• Nearly 70 of the business metrics that
  executives in various industries track are
  common.
• Custom BI projects have lt 30 success rate due to
  - Long Time-to-Value, Shelf-ware, Tepid Exec
  Support, Lack Implementation Expertise
• Bodhtree is leveraging prior implementation
  experiences to build Pre-Built BI solutions
  offer them to customers in SaaS / Jumpstart
  models, MIDAS in following areas
• Enterprise Analytics (Marketing, Sales, Service,
  Marketing Product)
• Healthcare Analytics (Operational, Spend,
  Clinical and Financial)
• Pharma Analytics
• Service Analytics (Call Center Analytics)
• Finance Analytics
• Retail Analytics
• Media Analytics

28
MIDAS - Advanced Analytical Engine

• Ad Hoc Analysis Business users can slice and
  dice around specified data cube and
• perform advanced analysis of the data. Ad Hoc
  Analysis allows you to create various
• charts based on the business requirements and
  analyze the data as per the need.
• Ad Hoc Query Users can create detail reports by
  performing GUI based query tool.
• Dashboard A dashboard is a visual display of
  the most important information
• needed to achieve one or more objectives
  consolidated and arranged on a single
• screen so the information can be monitored at a
  glance.
• Report Portfolio Pre-canned domain specific
  reports which provides insights into
• details of data.
• Data Model Pre-designed data models for
  analytical purpose.
• Data Mappings Pre-built data mappings for
  extract, transformation and loading of
• data.

29
MIDAS Reports Advanced Analytical Engine
30
MIDAS Reports Advanced Analytical Engine

• MIDAS Analytical Engine provides metrics around
• New Product Selection
• Patent Standing
• Development Milestones
• Product Filing Performance
• Product Launch Performance
• With
• Highlights
• Lowlights

31
MIDAS - Marketing Campaigns
32
MIDAS - Sales
33
MIDAS - Service
34
MIDAS - Web Analytics
35
MIDAS - Health Care Cost per Adjusted Patient Day
36
MIDAS - Health Care Operating Margin
37
MIDAS - Profit and Loss Account
38
Contact

• For further details email to
• Raghavan VSR Madabhushi
• Head - SOA - DW
• rmadabhushi_at_bodhtree.com (M) 91 98661-20009
• Vonage 650-384-0422
• www.bodhtree.com
• Deloitte Technology Fast 500 Asia Pacific 2007
  Award Winner