Transcript Slide 1

Introductions
SPAWAR
Agenda











Overview
Capabilities
Core Competencies
Partners
Projects
Case Studies
Clientele
Certifications
Why Choose RYAN
Contact
Discussion
Copyright 2006
2
Overview
 Founded by principal consultant of a Fortune 1000
Business Intelligence Enterprise & Performance Planning
world leader
 Information technology professional services firm offering
high-end technology Solutions
 High percentage of renewed/extended contracts
 Successful track record
Copyright 2006
3
Capabilities
We enable our clients to know their data by transforming
the myriad of collected data into intelligence for planning
and managing their business.
Our professional services consist of:







Business Intelligence
Data Warehousing
Project Management
Web-based Solutions
Database /Systems Administration
Help-Desk/Desktop Support
Customized Training / Knowledge Management
Copyright 2006
4
Core Competencies
Business Solutions
Data Warehousing
Capture the data in different sources by organizing the information and getting it
to the decision makers across an enterprise, enabling them to make informative
business decisions
Business Intelligence/Decision Support Systems
Integrate data that supports technological and managerial decision making into an
easy-to-use support system as a tool for business managers
Information Portals
Save time and money by sharing information throughout an organization with a
unified user interface
Database and Systems Administration
Provide monitoring and reporting on databases and operating systems on an
ongoing basis through capacity planning, security assessments, monitoring, and
backup and recovery procedures
ERP (Reporting)
PeopleSoft, Oracle, SAP
Copyright 2006
5
Core Competencies
Applications
Databases
Oracle, Sybase, SQL, DB2
Extract, Transform, Load (ETL)
Informatica, DataStage, ab-initio
Queries – Reports Processing
Cognos, BusinessObjects, Information Builders
Web Methods
Netscape, Weblogic, J2EE
OLAP Tools
Hyperion, Microsoft OLAP Services
Business Modules
SAP, PeopleSoft, Oracle Apps
Copyright 2006
6
Core Competencies
System Development Breadth
Project Management
Configuration Management
Life Cycle Documentation
Requirements
Gathering
Requirements
Analysis




Design
Build
Test
Deploy
Customer Value
Proven & Repeatable Process
Minimized Risk
Flexible & Collaborative Approach
Scalable from Department to Enterprise
Copyright 2006
7
Business Intelligence
Partners
Copyright 2006
8
Projects
► US Army - Data warehouse analysis, Business Intelligence reporting and Systems
Administration support.
► Defense Finance and Accounting Services (DFAS) - Program and project
management; web- & client-server development; J2EE, DBA, data warehouse
implementation; reporting; database & systems administration. First and second line
support – resolution of trouble tickets, technical support, desktop printer repair,
software technical guidance – for over 3,000 users.
► Department of Homeland Security (DHS) - Program and project management, java
development, Oracle application development, SAN support, Tier 1 and 2 help-desk
support.
► US Marine Corps - Data warehouse analysis and Business Intelligence support.
► Wright Patterson AF Base - Data warehouse analysis, Business Intelligence
reporting and Web application development support.
Copyright 2006
9
Clientele
USMC – Marine Corps Community Services (MCCS)
Copyright 2006
10
Demographical Markets
WA
ME
OR
MA
NY
MI
CT
PA
IL
IN
OH
NJ
DC
CA
NC
AZ
AR
AL
GA
TX
Copyright 2006
11
Case Study [A]
Data Warehousing/Business Intelligence
Project Summary
Challenge
When a widely known international engine manufacturing company (EMC) discovered they had multiple sources of
the same customer data in different application systems and databases—with no single key identifier for any given
customer—they knew it would be next to impossible to track one customer across applications. EMC turned to
RYAN Consulting Group, a recognized Business Intelligence Solutions provider, for help.
Solution
RYAN’s team of professionals worked to deliver a cross-business unit strategy and functional design for an
enterprise data warehouse that uniquely identifies customers across different business information systems. This
Master Data Management (MDM) will have the ability to encompass both a Customer Data Integration (CDI)
application and a Product Information Management (PIM) application, enabling EMC to track both their customers
and their products as a single entity, regardless of the source of the data.
Outcomes
In giving EMC the ability to track customer data across different business units, RYAN has helped create an
environment that improves sales and expense tracking, establishes common pricing and discount policies, obtains
a full-circle view of their customers, and identifies EMC’s true valued customers.
RYAN used existing applications and technology wherever possible, including building the data warehouse as a
supplemental system. Avoiding replacing entire systems proved to be both time saving and cost effective. In the
long run, EMC will be able to operate as both a B2B business and a true B2C business.
The success of RYAN’s team working directly with EMC employees is a contributing factor to why RYAN is now
the preferred BI Solutions provider to EMC.
Copyright 2006
12
Case Study [B]
ETL/Business Intelligence Reporting
Project Summary
Challenge
A state government agency had worked with two different consulting firms over two years to help them track
payments made to employees and retirees but still had nothing to show for the consulting fees they had paid. The
agency’s newly appointed CIO was aware of the progress RYAN Consulting Group had made for other
organizations and brought them in to help. RYAN’s outstanding reputation in delivering expert results quickly
proved rewarding for the agency.
Solution
Given the agency’s previous experience with consulting firms, RYAN introduced just one BI reporting specialist with
expertise in data extraction, translation, and loading (ETL). An initial database assessment revealed that the
database was less than ideal in its structure, but its contents could not be changed at the time. Knowing the
agency’s top executives needed information right away, RYAN’s BI reporting specialist created an ETL application
that cleaned the existing data and created the necessary datasets for producing Impromtu reports.
In less than five months, RYAN was providing approximately 40 different reports for the executive levels of the
agency (CEO, CFO, Director, and Board Members) to use in making major business decisions, from tracking
employee performance to prioritizing and assigning tasks.
Outcomes
RYAN continues to produce and deliver results. Based on the accuracy of the reports, overall performance and
quality have improved at the agency, and leadership can easily spot where problems and potential problems are.
Now that one major issue has been successfully tackled, RYAN continues to help create a stable database and
reporting environment for the agency.
Copyright 2006
13
Case Study [C]
Web-Based Application Development
Project Summary
Challenge
Defense Finance and Accounting Services (DFAS) needed to develop and host a web-based training application
for employees that would provide users with information about career progression levels and related training
possibilities for all Department of Defense Financial Management fields. The application had to be secure,
accessible by 42,000 financial management employees, and support multiple HR systems on multiple platforms.
DFAS turned to RYAN to provide the solution.
Solution
Working within the existing FIP/Networking environment, RYAN’s team of professionals designed, developed, and
implemented data marts. This foundation allowed DFAS to provide a fully interactive web application that assists
both employees in determining appropriate career training paths and supervisors in guiding their employees and
making use of departmental resources.
Outcomes
In designing a data mart to incorporate all the data from heterogeneous systems into one central repository, RYAN
helped the Department of Defense save approximately $2 million.
RYAN also developed dashboards—utilizing multidimensional data cubes as sources—to allow DFAS to visualize
and analyze information about key performance indicators.
Because of RYAN’s speed and accuracy in completing the project on time and under budget, the Regional Service
Center Program Manager won the prestigious ACCENTURE and MIT Digital Government Award. “None of this
would have or could have been accomplished without you,” she wrote in a letter to RYAN employees, recognizing
RYAN for their significant contributions to the project.
Copyright 2006
14
Why Choose RYAN?
 Business Intelligence Solutions-driven company
 Business professionals who can successfully manage,
deliver, and support technology-based solutions
 Stringent recruiting process with the ability to recruit nationally
and globally
 Dedicated to delivering on-time, cost-effective solutions
 Committed to providing customer satisfaction at its best
 Proven track record, high employee retention, and 100%
reference ability
Copyright 2006
15
NAICS and SIC Codes
NAICS Codes
SIC Codes
518210
Data Processing,
Hosting, and Related
Services
541511
Custom Computer
Programming
541512
Computer Systems
Design Services
541513
Computer Facilities
Management Services
541611
Management,
Administrative, and
Technical Consulting
541519
Other Computer Related
Services
7371
Computer Programming
7373
Computer Integrated Systems
Design
7374
Computer Processing
7375
Information Retrieval Services
7379
Computer Related Services
8742
Management Consultants
Copyright 2006
16
Contact Us
R. Keith Harding
[email protected]
RYAN Consulting Group (RYAN), Inc.
9515 E. 59th Street, Suite C-1
Indianapolis, Indiana 46216
317.541.9300 Ext. 201
www.consultrcg.com
8(a) Certified through 2013
Top Secret Facility Clearance
Copyright 2006
17