RCR Technology considers data one of the most valuable organizational assets, when used properly, it provides a basis for intelligent, informed empirical decision making process critical for any successful business entity. For us, Big Data has always been a big deal well before the term has become part of current day IT jargon.

In fact, our company was built on a big data project in 1997 when we were contracted by the State of Indiana to build the data warehouse for the Family Social Services Administration (FSSA).  This solution is still fully functional and managing most of the agencies social service program data and the mandated information exchanges required by the Federal Government. Today it generates volumes in excess of 5 million records monthly.

RCR Technology has an extensive portfolio of Data Management tools, capabilities and experience in designing, building and maintaining a successful data warehouse. Additionally, we have experience implementing state of the art Business Intelligence solutions that have provided our clients the opportunity to make informed business decisions.

Data Warehouse

Data Warehousing is a science of storing enterprise wide data of multiple business or subject areas for query and analysis. Data mart on the other hand is a subset of data warehouse holding data about one business or subject area. It’s usually built focused on dimensional model using star schema. Data warehouse solutions should deliver; fast results, allow for cost effective storage and management, optimize performance and reduce risk and cost of operations. Modern day solutions should also address an increase need for agility of the solution, allow for new and important types of data including structured and unstructured, and leverage new open source platforms if appropriate, while reducing cost of building and maintaining the platform.

Data Management Capabilities and Expertise

RCR Technology have done significant data projects locally for almost 20 years involving large volume State and Federal projects which include demanding detailed reporting requirements. Additionally, we have successful engaged in small and mid-sized business projects to provide data solutions to address their issues. Our best practices are deeply rooted in proven theory and years of practical experience of projects of all sizes, scopes and levels of complexity. A summary of the capabilities:

  • Consulting
  • Data Warehouse Planning: Architecture Design, Development & Implementation
  • Business Intelligence Solution: Design, Development & Implementation
  • Master Data Management
  • Data Security
  • Leading Open Source Big Data platforms including Hadoop
  • Metadata Management
  • Data Migration
  • Data Integration
  • Data Cleansing
  • Data Mining
  • Data Conversion

RCR Technology’s approach to data warehousing is based on Ralph Kimball and Bill Inmon methodologies and our own practical experiences. Essentially several significant theories existing in the industry today around data warehouse architecture which includes principles approach with relational versus dimensional approaches and architecture to support each approach.

Robert Reed, the CEO and Founder of RCR Technology a formally trained and certified TDWI data architect, was trained by Bill Inmon and is certified with the Kimball methodology. These industry standard data warehousing approaches have helped to shape our core company DNA built on these principles generally and our own practical Big Data experience specifically.

Our Proven Methodology for Successful DW or BI Projects

Our methodologies have evolved over many years of successful project implementations. Our senior team possess many years of expertise and practical experience in the field and can handle challenges of all sizes. Our capabilities are comprehensive and include the ability to:

  • Understand Data and Desired Outcomes
  • Design Data Mart and Data Warehouse
  • Data Cleansing Plan Development and Execution
  • Data Migration Plan Development
  • Data Aggregation Plan Development
  • Business Intelligence Solution Development and Execution

methodolog

Data Integration/Interoperability Approach

Understanding client data, their use and solution objectives are critical to ensure that data from various disparate systems can exchange and use information from all sources as required. Our approach accounts for and utilizes:

  • Operational Agnostic View
  • Common Practices
  • Extensible Capability
  • Measurable
  • Implementable
  • Sustainability

data_integration

 

BI Reporting Capabilities and Techniques 

We utilize a number of industry leading solutions and capabilities to offer a breadth of reporting options and access to business critical information for many user types. Our approach includes:

  • Multi-Dimensional Analysis
  • Predictive Analytics
  • Data Modeling
  • Reporting
    • Ad Hoc
    • Customized
  • Dashboards

 

Data Warehouse Consulting Services

We offer a breadth of services at market competitive rates. No project is too small. Additionally we have the ability to work in a prime capacity or if required to work directly with a partner. Our services include:

  • Data Modeling
    • Define and Analyze Data Requirements
  • Data Warehouse
    • Design, Development, Operations and Support
  • Evaluating Industry leading ETL Tools and Recommendations
  • Oracle/DB2/SQL Server/Post VRES SQL
  • Cognos/Tableau/SSRS/Informatica
  • Data Mart Development
  • Data Integration
  • Data Conversion
  • Data Analysis

data_warehouse