Please Note:
This profile was automatically generated using 4 references found on the Internet. This information has not been verified. Learn more...
This profile was automatically generated using 4 references found on the Internet. This information has not been verified. Learn more...
Web References
-
1. Teradata Magazine | Union Pacific: On the fast track to efficiency
www.teradata.com/t/page/127059 - [Cached]Published on: 2/14/2005 Last Visited: 9/29/2006
After using Teradata for the past 12 years, Roger Bresnahan knows a thing or two about data warehousing. But the principal engineer of the Enterprise Data Warehousing Group at Union Pacific Railroad keeps on learning and finding more uses for this versatile technology.
Union Pacific
With 39 years of service to the Omaha, Neb.-based company - the last 36 in IT roles - Bresnahan is well-positioned to reflect on the evolution of the company's data warehousing strategy and consider its continued growth.
...
The goal, according to Bresnahan, was to find a way to integrate and manage data from various sources within the business in order to improve decision-making. At the time, it was virtually impossible to meet that goal because Union Pacific's IT environment consisted of a host of stovepiped systems spread across various areas of the company.
"By the time each group got its data, there was a real loss of connectivity between the different areas of the railroad," he explains.
...
We realized that our customers weren't going to wait for the IT department to take care of it," Bresnahan says.
...
"For the first time, we can do so many types of analysis," Bresnahan says.
...
"ROI overcomes all," acknowledges Bresnahan. In fact, return on investment has always been quite positive.
...
Bresnahan says the upgrade is a significant improvement of UP's production capacity and nearly doubles the capacity for development and disaster recovery. Additionally, the team is planning to upgrade to Teradata Database V2R5, which will provide better performance, more efficient reporting and enhanced processing and data loading methodologies.
Bresnahan, who is enjoying the benefits of the upgraded Teradata system, has no intention of stopping now.
"We have just started to explore the data mining aspect of the warehouse and are looking forward to exploring other untapped areas as well. One thing leads to the next," he says.
...
"It simply took too long and was too complex to put together," notes Roger Bresnahan, principal engineer of Union Pacific's Enterprise Data Warehousing Group.
But it's critical that the crew management team be able to verify that the right crews are assigned and scheduled to the right trains because different qualifications are required for different locomotives.
Today, senior managers receive reports showing daily, weekly and monthly crew and locomotive usage at all major crew-change locations. These reports have greatly helped in analyzing "hot spots" where potential crew or locomotive shortages could bring the rail system to a standstill. "Being able to look at both locomotive and crew information instantaneously has significantly reduced trains held for crew or power," Bresnahan says.
...
"Timekeeping would have been unable to produce these results in the required two-month time frame without the use of Teradata," Bresnahan says. -
2. PARTNERS - Steering Committee
www.ncrpartners.com/what_is/sc - [Cached]Published on: 9/17/2002 Last Visited: 9/17/2002
Roger Bresnahan
...
Roger Bresnahan Senior Systems Consultant, Enterprise Data Warehousing (EDW)
...
Roger Bresnahan has been employed at Union Pacific for 35 years, of which, 32 years have been in the IT department. Roger has been working with Teradata Systems since 1993. Roger is one of the principal founders of Union Pacific's Enterprise Data Warehouse, which now has over 2,000 integrated tables covering over 35 different subject areas, with over 4,000 users. He is currently the Senior Systems Consultant for the Enterprise Data Warehouse for Union Pacific Railroad. His duties include project scoping, modeling, system design, and sourcing new subject areas or tables into the EDW. He is also the senior consultant in the retrieval and business use of EDW information. -
3. PARTNERS - Steering Committee
ncrpartners2.bridgeagency.com/ - [Cached]Published on: 3/20/2003 Last Visited: 3/23/2004
Roger Bresnahan
...
Roger Bresnahan Senior Systems Consultant, Enterprise Data Warehousing (EDW)
...
Roger Bresnahan has been employed at Union Pacific for 35 years, of which, 32 years have been in the IT department. Roger has been working with Teradata Systems since 1993. Roger is one of the principal founders of Union Pacific's Enterprise Data Warehouse, which now has over 2,000 integrated tables covering over 35 different subject areas, with over 4,000 users. He is currently the Senior Systems Consultant for the Enterprise Data Warehouse for Union Pacific Railroad. His duties include project scoping, modeling, system design, and sourcing new subject areas or tables into the EDW. He is also the senior consultant in the retrieval and business use of EDW information.

