RTD at a Glance

RTD provides bus, rail, and light rail transit services to Denver, Boulder, and surrounding cities in Colorado. It operates the whole year, at all hours. With 170+ bus routes, 12 rail lines, and many specialty services. The first transit company solved the last mile problem by extending its routes using rider application integration on their mobile platform. With continually increasing ridership, RTD secures the place of the 4th largest transit company in the US.

Challenges

• Aging infrastructure for Business Intelligence Applications.
• Cloud-first requirement for any new systems/applications.
• Consolidating multiple business intelligence platforms to the modern, subscription-based platform to reduce the technology debt.
• Changing ERP landscape and ever-increasing data sources.
• Need of Artificial Intelligence and Machine learning to support younger ridership.
• The requirement to change the reactive analytics to predictive analytics in the next 3 years.
• The existing reporting framework was inadequate.

Goals

• To modernize infrastructure for Business Intelligence Applications and plan a switch from reactive analytics to predictive analytics
• Moving to a subscription-based cloud platform for ETL processes.
• Replace the complex existing license framework to simple user-based, cloud-based subscription model
• Reduce the technology debt by not ever worrying about refreshes and/or upgrades.

Our Approach

• Help the internal IT and BI team in understanding the new cloud functionality.
• Bridge the expectation gap between on-premise capabilities vs. cloud capabilities.
• Adapt the new design to fit the on-premise re-architecture and determine whether this is a fundamental necessity vis- -vis a want.
• Our approach provided access to live, real-time, drillable data right in Excel
• Lift and shift/ recreate data circulation in cloud environment.

Benefits

• Sunset multiple applications were consolidated in single BI platform.
• Reduced cost of maintenance by reducing technical debt.
• Reusable web-services based integrations.
• Developed in-house knowledge base for the product.
• Enhanced Customer experience for ridership.
• Quicker turnaround time on POCs.
• Speed to market solutions.

6eTechnologies

6e Technologies is a Business Intelligence and Oracle Integration IT services firm with decades of experience with very complex Enterprise Systems. Founded and headquartered in Denver, Colorado. 6e is successfully providing Oracle support services to the Federal Government, Local Agencies, and several Fortune 500 companies.