||The Orange County Transportation Authority (OCTA):
OCTA is Orange County CA's primary transportation agency. Located in Southern California, the OCTA is focused on rail, freeways, streets, and public transportation. Its primary mission is to create, coordinate, finance, and deliver an easy to use public transportation network which keeps Orange County's 2.8 million people moving.
While Southern California is known for its freeways, more than 200,000 Orange County residents a day rely on OCTA buses to travel to and from work, school, and a variety of other places. OCTA takes this responsibility seriously, placing more than 460 buses on 80 routes during peak hours. This activity generates over 5 million transactions of ridership data per month.
On Time has implemented a Data Warehousing strategy for the OCTA, consisting of Data Marts for Ridership and Pass, Coach Operator management, Incident Tracking, Bus Run Costing, and the Orange County Employees Retirement System (OCERS). All of the data warehouses/data marts were built in an Oracle 9i environment, using Oracle Warehouse Builder (OWB).
These Data Warehouses capture voluminous amounts of transit, bus operations, and employee/payroll information, which allow detailed analysis of Bus Operations, enabling the OCTA to continually improve its services to the citizens and taxpayers of Orange County. The project has involved extracting transactions from Genfare International's (GFI) Fareboxes, GIRO Inc.'s HASTUS scheduling system, Sun-Gard Bi-Tech IFAS accounting system, and Lawson Software HRIS/Payroll system to provide detail and summarized data that gives a clearer understanding of revenues, costs, utilization, and ridership statistics. On Time has also created scores of Web-based reports using Oracle 9iDS FORMS and REPORTS on an Oracle 9iAS Server.
What our clients are saying:
" We have found you and your team to be capable (your expertise in Oracle databases and Oracle Warehouse Builder is noteworthy), professional, and a pleasure to work with. I would highly recommend On Time Consulting Services to anyone responsible for prompt, accurate, and successful delivery of business intelligence projects ."
-- Ray Riggins , Data Management & Applications Support, OCTA
Forms and Reports Samples: Click Here