glenture

ABOUT GLENTURE

Global Headcount – 1k+

Projected 2012 Revenue - $140M

Clients – 250+

Verticals covered – 10

Offices:

Quick Facts

Dallas

Chicago

AustinWashington

Bangalore

Sydney

Toronto

CUSTOMER SUCCESS

FEATURED:

• INFORMATION WEEK

• MICROSOFT CASE STUDIES

• FORRESTER BI IMPLEMENTER

SELECTOR TOOL

• MICROSOFT BI CONFERENCE

GOAL AND STRATEGY

STRATEGY

Develop Industry and Line Of Business competencies and Intellectual Property to allow for rapid and robust implementation of Business Intelligence and Enterprise Collaboration / Knowledge / Content management solutions using Microsoft technology platform

GOAL

Make it easy for our customers to choose Glenture as the GO-TO partner to implement Microsoft based solutions

WHY GLENTURE?

Glenture is 100% focused on solutions based on Microsoft technology

Tight partnership with Microsoft development, solutions and account management teams

Depth and breadth of expertise across various Microsoft technologies

Strong Business Acumen (across various industries, functions and LOBs)

Strong Project Management

Proven track of large fixed fee implementations

Ability to handle large and small assignments; Full-lifecycle support

Volume, tenure, and prompt pay discount options.

Focus

As a national SI, Glenture can often minimize travel costs by utilizing local consultants

Flexible, on-demand operating model reduces resource cost

Multiple engagement options (from staff augmentations to fixed fee engagements)

Quality

Value

.NET

Business

Intelligence

Enterprise

Collaboration

and Knowledge

Management

Custom

Application

Development

SOLUTIONS

.NET

MICROSOFT IS A LEADER IN BUSINESS INTELLIGENCEGartner

“Microsoft exhibits one of the best value propositions on the market with a low cost and a

highly favorable price / performance ratio”- Gartner, February 2012

[Gartner, Inc., Magic Quadrant for Data Warehouse Database Management Systems Magic Quadrant, Mark A. Beyer, Donald Feinberg, Merv Adrian, Roxane Edjlali, February 6, 2012.

The Magic Quadrant is copyrighted 2012 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for a specific time period. It depicts Gartner's analysis of how

certain vendors measure against criteria for that marketplace, as defined by Gartner. Gartner does not endorse any vendor, product or service depicted in the Magic Quadrant, and does not advise technology users to select only

those vendors placed in the "Leaders" quadrant. The Magic Quadrant is intended solely as a research tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or implied, with respect to this

research, including any warranties of merchantability or fitness for a particular purpose.

Business Intelligence

Connector

and ETL

SOLUTION ARCHITECTURE

Fact Data

Master DataReporting Model

(Analysis Services Tabular)

Relationships

Calculations

Images

SharePointScorecards

Excel Workbooks

SharePointSearch &

Dashboards

Templates:

Financial

statements

Score Card

PowerView

glenture

Source Systems:

• CRM

• Financials/GL

• Flat files

• Database access

BUSINESS INTELLIGENCE

BI STACK

• Data Warehouse

• Master Data Management

• Data Visualizations

• Dashboards

• Reports

• Ad-Hoc

• Enterprise Information

Management

SHAREPOINT SERVICESContent Management

•Document Management

•Versioning

• Intuitive Navigation

•Managed Taxonomy

•Search Customization and Optimization

Social Networking & Collaboration

•Communities

•Wikis and Blogs

•My Sites

•Portals

•Microsoft Office Integration

Business Process Automation

•Workflows and Data Driven Alerts

•Management by Exception

•Dashboards and Reporting

•BI and External Systems Integration

•Custom Web Parts

•Corporate Governance

Implementation Services

•Assessments and Best Practices Guidance

• Infrastructure and Site Architecture

•Upgrade and Migration

• Intranet and Extranet Deployments

•Custom Branding

•Application Maintenance

Document

Management

Knowledge

Management

Business

Process

Management

User

Experience

Pervasive

Insight

Actionable and Collaborative Insight

INTELLECTUAL PROPERTY

• Accelerators

• Connectors

• Quick start and Jump start kits

• Industry focus tracks

DEVELOPMENT/DESIGN METHODOLOGY

Glenture uses a structured, iterative development approach

Learn & Plan

Identify business

and project

priorities

Review current

state processes

and systems

Inventory

requirements, pai

n points, and

metrics

Align business

and IT to

conceptual

solution design

Finalize project

plan and release

strategy

Technical

Readiness Assess current

systems

environment for

conversion

Set-up

development, tes

t and production

environments

Install /

Configure

software

Formulate

conversion

approach

Realization - Build Build ETL and

Data Validation

components

Build data

migration and load

processes

Implement Security

Realization -

Requirements

Traceability

Perform unit

testing

Certify results

against inventoried

requirements

Stabilization-

System Load, test, and

certify end-to-end

processing

Convert full data

Stabilization- -

Quality Assurance

Certify all data

Validate input

schedules, reportin

g with business

areas

Tune and

optimize

Complete the

support

plan, usage /

training materials

Deployment &

Support

Knowledge Transfer

and User Training

Production roll-out

and support

Project closure /

wrap-up

Blueprint

& DesignRealization Stabilization

Deployment & Support

Learn &

PlanTechnology

Readiness

Blueprint Define component

and data

architectures

Map master data

and source data

Design Design the

Prepare, Stage, Ma

nage and Consume

tiers

Map master data

and source data

Produce solution

design document

reflection pilot

outcomes

Learn & Plan

Technology

Readiness

Blueprint &

DesignRealization

Stabilization

Deployment

ELI LILLY

Impact

Opportunity

The Orion project delivered comprehensive project portfolio data on a near real time basis, supplemented by a set of the reporting and analytical tools to allow managers and decision scientists to make right decisions at the right time. The solutions included the following:

Data Warehouse (Microsoft SQL Server) ETL from various disparate sources Data Visualizations deployed in SharePoint portal Analysis Services cubes Ad-Hoc reporting capabilities

Solution

Assist 350 Business Managers to

manage Lilly’s R&D portfolio through a

variety of lenses:

$$$ spent

Milestones

Clinical Trials

Risks

Probabilities

Return on Investment

Existing process took months to

collect, cleanse, and aggregate data

from multiple applications which made

it difficult to make strategic decisions

in a timely fashion.

$23B IN

REVENUE

38K

EMPLOYEES

PHARMACEUTICALS

BEALLS

Impact

Opportunity

Glenture developed an Analysis Services cube over the Operational Data Store that enabled a consistent sub-second response time for reporting and ad-hoc analysis

Over 100 Key Performance Indicators were developed to provide insight into the sales, ordering and merchandise inventory

Data from different business units were consolidated into a single repository to enable the single and complete source of reporting across the entire business

Glenture assisted with training and Change Management to insure successful user adoption of the solution

Solution

Merchandise buyers are constantly challenged to manage the ordering and

inventory of the merchandise. The existing data management and reporting assets

are stressed beyond their limits to support billions of transactions and terabytes of

data to provide near real time response for reporting and ad-hoc analytics

$1B+IN

REVENUE

500+

STORES

RETAIL

11,000

EMPLOYEES

TAKEDA PHARMACEUTICAL USA

Impact

Opportunity

Glenture built a Data Warehouse and an Analysis Services

Cube as it automated the load of General Ledger and Cost

Center data from the SAP FI/CO modules. Various financial

reports such as Income Statement, Balance sheet, Cash

flow, and Cost Center Analytics have been developed. These

reports can now simply be refreshed for the desired reports

parameters and they no longer require any manual data

manipulation or additional work effort to maintain. The

accuracy of the underlying data has been substantially

increased while reducing the report generation time from

weeks to minutes.

Solution

The finance and accounting functions of the company are frustrated with

the accuracy and the manual effort of the existing processes for

generating management and statutory reports. Inefficiencies in

manipulation of SAP and Cognos data lead to delays of the monthly close

process as well as the delayed visibility into the financial performance of

the company.

$16B+IN

REVENUE

FOUNDED IN

1781

20,000

EMPLOYEES

PHARMACEUTICALS

glenture

?