• An intuitive, dedicated team
  • Quality solutions
  • Unparalleled satisfaction

It’s more than just a promise. It’s an expectation.

Business Intelligence / Data Warehousing

Solution: Business Intelligence

Industry: Energy

Summary

Technologies Used

  • IBM Infosphere DataStage, IBM Cognos, IBM TM1, IBM DB2 DBMS, Microsoft SQL Server, Oracle, IBM DataStudio Data Modeling Tool

Client

  • Fortune 500 Energy Company

Challenge

  • Establish a structured Business Intelligence environment and team within the client organization

Approach

  • Identify the necessary Extract, Transform and Load (ETL) tools and hardware components necessary for a comprehensive BI environment

Results

  • Established a long-standing partnership with the energy company, with HMB supporting the BI team through Data Warehouse/Data Modeling, ETL, and Cognos 10 reporting solutions

Client

A Fortune 500 energy company that provides natural gas transmission, storage and distribution, as well as electric generation, transmission and distribution to nearly 4 million customers located throughout a high-demand energy corridor stretching from the U.S. Gulf Coast through the Midwest to New England.

Challenge

Source system data existed on different platforms and were difficult to access in a timely manner. Reports, which were tactical in nature and scope, were generated by various groups and resources specific to the systems they supported. Reporting tools consisted of EZTrieve, Excel, and Cognos 7 directly against operational source system data and mainframe file extracts.

Establish a structured Business Intelligence (BI) environment and team within the organization to support the following goals:

  • Improve access in scope and speed to market with actionable information from source systems required to run the business.
  • Promote transparency of data and reporting from which to report against (Data Warehouse/Data Marts).
  • Eliminate the negative system and performance impact of directly accessing operational data for reporting.
  • Provide for cross-departmental (operations, planning, engineering, etc.) collection and analysis with a combination of tactical and analytic reporting.

Approach

The client partnered with HMB initially to add a single technical resource to address the data warehouse component of the BI environment. Extract, Transform, load (ETL) tools were identified and the necessary hardware infrastructure was established to support a Data Warehouse DB and ETL processing.

When the project was completed, the company extended their partnership with HMB and augmented the team with additional Cognos, ETL, and program management resources to keep pace with the growing demand and to fully leverage the BI environment.

 

Results

HMB’s strong technical expertise and vision was critical building a BI infrastructure with the right tools to meet the client’s needs. HMB remains a partner with the client today, fully embedded within the client's BI team and provides Data Warehouse/Data Modeling, ETL, and Cognos 10 reporting solutions.

With the continued support of source data/content to the Data Warehouse, the value proposition to the client continues to grow:
  • Cross-departmental reporting and analysis is a reality.
  • Interactive/analytic reporting has become the focus, with Cognos Dashboards providing real-time analytic capabilities to support the needs of the business.
  • Access to a broader scope of data needed to perform analysis and support decision-making is more readily available and easily accessible within the Data Warehouse.

  • HMB is not just another highly skilled service provider; they care about the solution they are providing their customers and how it will continue to serve them in the future.

    IT Director
    County Government Systems
  • HMB has consistently provided high quality .NET developers to our team.  The rapid ramp up and ability to become quickly productive for the project has not been matched by any other consultants.  We are very pleased with HMB's high performing, business-minded developers.

    IT Director
    Manufacturing Industry (Precision Instruments, Weights & Measures)
  • The HMB team has established themselves as not just a vendor but a partner in helping us achieve our mission. They believe and live with us our value of 'be so good they can’t ignore us.'

    Senior Director
    Educational Non-Profit Organization
  • We partnered with HMB because of their track record of successful projects, the depth of their technology staff and their flexibility. HMB provided us with the right resources in a short timeframe that allowed us to meet our client commitments in a timely and cost-effective manner. 

    Vice President of Technology
    Healthcare & Pharmaceutical Consulting Industry
  • At the end of the day it comes down to doing the right thing. If you do what's right for your clients and treat your employees well, everything else falls into place. It's just that simple.

    Mark Buchy
    Partner, HMB
  • My company chose HMB over other options primarily because of their people.  They came highly recommended, but what made them stand out amongst their peers was the professionalism and expertise of their team.

    Business Application Manager
    Commercial Real Estate Industry
  • Most importantly, [HMB] seems to live by the idea that their business is not just about performing their assignments brilliantly, but also about satisfying their clients deeply.

    Business Application Manager
    Commercial Real Estate Industry
  • Professional, experienced, reliable and trustworthy sum up our relationship with HMB.

    Chief Deputy
    County Government Systems
  • Congrats to you and the team on a successful implementation!

    Senior Vice President
    Energy Industry
  • Because of [HMB’s] diligence in understanding the process, tens of thousands of reports and requests for funds passed flawlessly through the agency at speeds 10 times faster than the traditional paper methods, with some making the way to payment in minutes.

    Director of Grants Management
    State Department of Education
  • School districts planned for and received resources faster and more efficiently because of the outstanding work of HMB.

    Director of Grants Management
    State Department of Education
  • Well done! This is the A-team!

    IT Director
    Energy Industry
  • Our biggest challenge is making the changes we need as fast as possible. HMB is quick to respond and gets things done.

    President
    Aviation Industry Software
  • HMB makes the extra effort to provide experienced developers that fit our needs.

    Senior Director of Technology
    Educational Non-Profit Organization
  • HMB exceeds their goal to deliver satisfaction by providing a service beyond our expectation.

    Vice President of Information Services
    Commercial Real Estate Industry
  • Not only are they fast and accessible, but HMB insists on doing things the right way.

    Vice President of Information Services
    Commercial Real Estate Industry
  • HMB takes initiative and ownership of the projects they work on.

    Business Intelligence Manager
    Energy Industry
  • HMB brings knowledgeable experience from the industry and integrates that skill into our business.

    Manager, IT Service Delivery
    Energy Industry
  • Their dedication to delivery and the precision of their results quantifies HMB’s strengths.

    Program Director
    Energy Industry