|
Open Technologies
Consulting
Business Intelligence
Success Stories
Background -
A Fortune 50 Financial Services company was seeking to raise
the ROI of its Business Intelligence investments across
multiple divisions.
Business Challenge - Excessive Turnaround for key
operational reporting.
Information Integration Challenge – Disparate legacy data
sources and transaction systems across the organization
feeding the data warehouses of individual business units
resulted in bottlenecks in the workflow of BI platforms.
Multi-million dollar software tool and management consulting
expenditures had not resulted in substantial improvements.
Scope of Services
 |
Led strategic planning for corporate data
warehousing group, working with business units including
Home Equity, Credit Card, Community Banking, and
Personal Lines & Loans to assess/evaluate their
reporting platform/infrastructure, suggest a better
architecture with EDW as a key partner, do
initial planning/estimating to implement the new
architecture, and then lead project managers to a successful
implementation.
|
|
Led reengineering of Data Strategy for
corporate Enterprise Risk & Compliance Group: Designed
end-to-end business architecture for applications &
data; created and implemented integrated methodology for
selection & implementation of 3rd party vendor
solutions; created and initially managed Risk &
Compliance data team.
|
|
Program Management of Home Equity
Business Unit’s planning/implementation of Integrated
Reporting Platform (DataMart).
The program included managing a budget of approx. $4 million
and about 8 large projects over a 2 year period.
|
top of page
Background -
The leading e-prescription online network supports a rapidly
expanding ecosystem of health care organizations nationwide.
Enhancing Business Intelligence capabilities is critical to
supporting individual customers and networks.
Business Challenge –
Analyze the readiness of current Business Intelligence/ Data
Warehousing organization, architecture and infrastructure to
provide the capabilities and scalability required to meet
future needs.
|
iMonetizing Information – Turning data gathered within the
network into Information products based on historical data
and patterns.
|
|
Operational Efficiencies – Leveraging Business Intelligence
across functional areas for operational efficiencies.
|
|
Long-Term Organizational Value – Creating a resilient,
scalable BI function (people, process, and technology) will
raise the market value of the company over the longer term. |
Results Achieved -
Developed integrated plan, roadmap and executive
presentation to dramatically expand Business Intelligence
capabilities and budget, with core elements of:
|
Creating an expanded BI Business Value Presentation and
training the internal BI team to articulate and evangelize
this value proposition and purpose.
|
|
Empower BI Power Users Across the Organization by focusing
organization on Business and Data Process Architecture
Rather than Tools and Infrastructure.
|
|
Stratifying three tiers of BI usage:
-
80% pre-defined reports –used by operational and executive
users, who require fast, accurate access to a small number
of Key Performance Metrics.
-
15% ad-hoc analysis – power users drilling deeper into raw
data for what-if analysis.
-
5% analysis – In depth “trolling” for patterns and
building of models by dedicated analysts.
|
|
Enhancing Support for Ad-Hoc Reporting and In-depth
Analysis, creating a “DIRECT ACCESS” Data Mart, giving power
users the ability to drill down into the raw data
autonomously.
|
|
Enabling Expansion of capability necessary to build and
deliver analytic solutions to partners and customers by
standardizing data extract process, i.e. “Lean Extracts”, to
enable rapid, accurate, high value reports.
|
|
Creating a Drill-Thru feature which enables all numerical
values in a report to be clickable and produce a details
report that shows the data responsible for coming up with
that value. This is critical for “removing doubt from data”.
|
|
Forecasting Future Data Volume – to support sustainable
budgeting of expansion of BI capabilities.
|
|
Access Modules and Security – Defining scalable
methodology and plan for meeting multiple regulatory and
industry standards for security, including Authentication,
Authorization, role based, workflow based and individual
customization. |
top of page
Background - A national B2B leasing division of a major financial
services company had the strategic objective of developing a
robust online customer experience capability.
Business
Challenge - They needed to
expand the customer reporting functionality of their online
portal to satisfy the growing business needs of key vendor
partners.
Results Achieved:
|
Building upon first version of customer portal, provided
three new capabilities.
|
|
A dashboard capability that presents key metrics with
drilldown to detail and user controlled reporting
capabilities.
|
|
An alert management capability (email or text) when defined
events have occurred during a lease lifecycle.
|
|
A customized portal capability to deliver customer specific
content. |
top of page
Background - A Fortune 50 General Merchandise Retailer had limited ability to
perform monthly P&L reporting for each functional area.
Business Challenge – Current P&L for store leadership was
web based with limited drilldown into financial hierarchy,
difficult to change and support issues took days to resolve.
Information Integration Challenge – Financial data was
being ftp’d from transactional database to a stand alone
Unix server with an Oracle database and was not well
documented and did not tie into any other corporate data.
Results Achieved
|
Business Result – Increased report usage by over 50% and
consolidated/eliminated over 10 financial reports, over
several iterations of a two year development project.
|
|
Business Process Result – Provided users with a road map
to allow them to diagnosis their opportunities and determine
next steps through the use of leading practices and
drilldown information.
|
|
Technical Result – Effectively replaced antiquated
technology with IT supported BI software, enabling migration
of support services to offshore team. |
top of page
Background - A Fortune 50 General Merchandise
Retailer had over time developed “report creep”: too many
reports with too many metrics and delivered in too many
different formats (printed, mainframe, emailed, web based).
This made it difficult for users to effectively and
accurately analyze and solve problems.
Business Challenge -
The same reports from different business functions often did
not match results due to isolated departmental systems and
data sources. Much of the data was in non IT supported
databases, or delivered through antiquated technology
(access/excel to produce PDF reports) that were accessible
via a custom built web page. As a result, reporting
applications required expensive, manual support and
maintenance by corporate BI IT Team.
Scope of Services
|
Business Deliverable – Developed a “one-stop” shop for all
performance metrics and reports by defined user type.
Rationalized and simplified the metrics and reports to make
it easier to find and understand. Eliminated non-value add
reports and reduced support costs.
|
|
Technical Deliverable – Transform legacy static reporting
into robust drilldown web-based reporting solutions
leveraging new enterprise BI tools. |
Results Achieved
|
Eliminated 35% of the metrics on the
pyramid production dashboard and built roadmap to eliminate
up to 85%.
|
|
Organizational Result – Migrated all report development to
offshore team and developed methodology to ensure
functionality and timelines were met.
|
|
Technical Result – Migrated reports to enterprise BI tools
and established on-going support model for problem
resolution and changes. |
top of page
|
| |
 |
Executive Search -
Our Executive Search helps companies hire technology-savvy senior executives
Find out more!
Read Articles -
The
Commerce Chain, Isaac's monthly column on
Business and Technology Trends, in the
Minneapolis Star Tribune.
Read Now!
Second Edition to be released soon!
Download:
21st Century Career
Guide
|
|
|
 |
|
|
|
|
| |
|
