Technology At Dallas Area Rapid Transit

Transcription

Technology atDallas Area Rapid TransitAllan SteeleVP/CIOJuly 23, 2013asteele@dart.org

ture and OperationsIntelligent Transportation Systems TechnologyApplications Systems ManagementProgram Management OfficeProjects to Improve Customer ExperienceProjects and Workload1.2.3.4.InfrastructureIntelligent Infrastructure TechnologyApplications SystemsInformation Management9. Capacity vs workload and the need for contractors10. Concluding Points Dallas Area Rapid Transit 20122

IT VisionThe Information Technology Departmentoperates as the technology services providerto the Agency and its customers. It deliversand maintains effective technology solutionsusing internal and external resources asavailable and needed. Dallas Area Rapid Transit 20123

IT InfrastructurePrimary Data Center – allsystems hosted internallyexcept Google MailSecondary Data Center for DRReal time data replication,virtual servers for very fasttransferMPLS WAN connecting 20 sitesGigabit LAN in all facilitiesOracle is primary DBMSSAN storage architecture1,800 desktop PCs, 400 laptops Dallas Area Rapid Transit 20124

Desktop Services Repurpose about 1,500 PCs as thin client machines– Much longer life - 10 years– Eventually replace with thin client devices at 150 Applications delivered “virtually” from servers– using 2X/Citrix/Terminal Server technology “Power users” retain full featured PCThe Result Reduces annual hardware cost by 250,000 Much easier to support, greater flexibility for change Potential to reduce license costs Dallas Area Rapid Transit 20125

Telecommunications Replacing PBXs with VoIP communications servers inthe data center, and new hand sets Quality of Service (QoS) on MPLS ensures qualityvoice transmission Reduce PBX maintenance and local phone line costsby 250,000 Positions platform for future unified messaging –interchange of voice mail and email, desk top videoconferencing (2014) WiFi 802.11n upgrade/roll out to support mobility 3G/4G cellular for vehicle & small facility connections Dallas Area Rapid Transit 20126

Systems Engineering/PDC –2013 Increase Thin Client Terminal Server farm hardware and capacityVirtualize 90% of all servers - approximately 250110 terabytes of storage in 3 tiers cloudSecondary Data Center (SDC) for disaster recoveryMigrated e-mail and collaboration into cloud services– Google mail; Google sites Support mobilityinternally and externally Consolidate remotehardware to PDC and SDC Dallas Area Rapid Transit 20127

ITS Technology Vehicle-based systems– VBS on rail; VLU on bus;– Wireless system onvehicles Radio, WiFi, GPS, AVL– Right of way systems Traffic signal priority,maintenance of way,corridor management– Camera systems– Geo-information systems Routes, bus stopinventory Dallas Area Rapid Transit 20128

Technology in Transportation OperationsBus Based Systems Vehicle monitoringFare CollectionPassenger information displayGPS based Automatic Vehicle Location(AVL) Automatic Passenger Counting Security cameras Dallas Area Rapid Transit 2012Buses and trainsequipped with aprivate radio systemfor operator voicecommunications toDispatch, and vehiclelocation data every90 seconds4G wireless underconsideration9

Enterprise Class Applications SystemsTrapeze – 16 modules Route planning, design and scheduling for busesOperator scheduling and work assignmentsRoute performance managementTrip planning for riders via web site or call centerSPEAR – 2 modules Maintenance logistics and work orders Materials ManagementLawson – 18 modules Finance, Procurement and Human Capital System Dallas Area Rapid Transit 201210

PARATRANSITPASS - TRAPRZETrip cationsRIDESHARETRAPEZETrip MatchingAVL (Automatic Vehicle Locator)BASE MAP (GIS) - ESRIBus Stop Inventory (GIS) – Clever DevicesTime Points (GIS) - Clever DevicesTransit Works – Bus DispatchFLEET/FACILITIES MAINTENANCESPEAR 2000OverhaulsPreventative Maint.Re-BuildsPaint & BodyCampaignsFacilities Maint.Ways/ & StructuresMaterial Mgt.Barcode SystemFLEETWATCH Fueling SystemsMMII Online Maintenance Manuals - AITSERVICE PLANNINGTRAPEZEPlanning DemographicsSchedulesBus Stop InventoryRoute PlanningMAPS – GISBlockBusterCUSTOMER SERVICECustomer Information - TRAPEZE(Schedule Information, Trip Planning)Complaints/Commendations – TRAPEZEWeb Based Trip Planning -TRAPEZEInterActive Voice Response (IVR) - Ontira(Paratransit,Bus,Rail,Comm Rail, Other)Photo ID’s (Reduced Fares) - In-HousePass/Ticket Sales - LAWSON, In-HousePoint-of-Sale DART Store - InfoGenesisHuman Resource irement - PEN-CALRisk Management - Risk SciencesTRANSPORTATIONTRAPEZERun BiddingTime KeepingPerformance Mgt.Bus Yard Mgt.Daily DispatchingOperator Sign-InCHARTERSCharter Bus Orders - In HouseCustomer Billing - LAWSONADMINISTRATIVEAccounts Payable - LAWSONAccounts Receivable - LAWSONGeneral Ledger - LAWSONCash Mgt. - LAWSONAsset Mgt. – LAWSONEmployee Self Service - LAWSONBudget - LAWSON, In-HouseContracts - In-HousePurchasing – LAWSONMBE - In-HouseBudgeting/Cost Modeling - COGNOS Dallas Area Rapid Transit 2012FARE COLLECTIONGFI - General Farebox IncorporatedTVM’sPASS/TICKETS - LAWSONRidership - General Farebox IncorporatedIn-HouseDART TechnologyFunctional Area Support Systems11

Custom Applications Systems DARTNet – intranet and workflow FileNet – Records management Telestaff – Police scheduling and timekeeping Fleetwatch – fuel and fluids consumption Electronic Parts Catalog – images of parts and sub-assemblies COGNOS – budget development Ripplestone – Crystal Reports server ESRI – geo-information systems Namsys – revenue cash management Primavera – program management for construction Expedition– document management for construction CMS – Contract management system for construction costs Dallas Area Rapid Transit 201212

DARTNet – DART’s intranetThe Web Applications team supports and develops applicationsand workflows on the agency's web sitesap.DART.org (accounts payable)www.DARTnet.org (intranet)transporteDART.org (Spanish)m.DART.org (mobile)www.DART.org

Technology Program Management Office“Doing the right things and doing things right.”2011 Focus Providing project management support for projects in IT and other departmentsAssisting project leaders get projects into the “done” bucket – 57 in 2011Maturing project management capabilities with targeted coaching and trainingContinue developing program and project standards and templates Dallas Area Rapid Transit 201214

IT Projects and Workload

Infrastructure WorkloadMaintenance and Support - 21 people– Running the network and data centers, desktop supportProjects UNIX upgrade Thin client roll out WiFi LAN at all facilities Cellular connection in WAN for small sites End user experience Dallas Area Rapid Transit 201216

Intelligent Transportation Systems Workload Maintenance and Support - 4 people– Traffic signaling, computers on light rail, auto passenger countersProjects TRE Next Train signs In-vehicle technology for bus and light rail– Communications, monitoring Connection protection Customer digital displays in transit centers In-vehicle technology for non-revenue vehicles– Field Supervisors – laptops and tablets Dallas Area Rapid Transit 201217

Applications Management WorkloadMaintenance and Support – approx. 10 people 3 enterprise application suites, approx 40 modules Departmental applications and intranetProjects Oracle R11g upgrade Lawson Procurement Phase II Lawson Grants module Lawson V10 upgrade Enterprise Asset Management for TRE Enterprise Asset Management for DART (SPEAR replacement) D&EO software Intranet work requests – web development Dallas Area Rapid Transit 201218

Architecture &Information Mgnt Workload Maintenance and Support - 3 people– IVR, auto attendant, project portfolio, business intelligenceProjects Mobile ticketing application – September launch Enterprise architecture documentation and development Information Management – business intelligence Program Management – PM tools, standards Reporting analysis and standards Business process engineering Geospatial projects Dallas Area Rapid Transit 201219

Capacity vs Workload IT has 64 full time positions Approximately 38 of those are needed for maintenance andsupport – “keep the lights on” Another 12 are needed for routine requests & minor projects The balance of 14 is insufficient to address the project backlog We are considering a General IT Services contract– Contract with one vendor who will supply skilled resources as needed– Task order concept for engagements of 3 to 9 months– General contractor will be expected to subcontract much of the work Hope to have an RFP on the street in August Dallas Area Rapid Transit 201220

Category 1 (General Skill - Lowest Risk Category)Skill LevelEntryIntermedAdvancXXMicrosoft System Engineer experience managing Windows servers withMCSE 2K8 or higher certification and/or terminal server managementexperience using Citrix / 2X.XXHP-UX System Administrator with current CSA CertificationXXSkill setSystem Engineers experienced in VMware virtualization with VCP5Certification and/or experience designing and implementing disasterrecovery plans in Site Recovery Manager.PC Technician with current A certificationXXTechnical Support Specialist with an emphasis on mobile technology(i.e. Smart Phones, Tablets) and GoogleXXSystem Engineer with experience in HP EVA/3PAR SAN environmentsXNetwork Engineers with one or more of the following: Experience managing Enterasys switches and Routers Experience with 4G LTE router implementation Experience managing Cisco network equipment with current Cisco CNAcertificationService Desk Specialist with excellent customer service skills and the abilityto monitor servers, reset password, etc.XXXApplication Support Specialist able to support ITS software andhardware. Knowledge of Init VBS a plus. Dallas Area Rapid Transit 2012XExpertXXX21

Category 2 (Specialized Skill - medium risk category)Skill LevelEntryIntermedSkill setSQL Server Database Administrator with experience setting up and configuring aserver farm and security.Web Developers with one or more of the following skills and experience: HTML,ASP, .Net, Java, XML, VbScript, Javascript, Visual Basic, MS Access, MS SQL andOracle SQL. Experience with Google APIs (Apps, Transit, Geo/Maps) skills a plus.AdvancXXXCrystal Reports Developer with SAP Business Objects and enterprise datamanagement skillsMobile Application Developer (Android, iOS) with understanding and experienceusing HTML 5.0XXMS Project Server 2010/2013 Consultant experienced in the installation, setup,and configuration of the softwareXPMO Consultant with experience implementing standards and supportingprocessesXIT Project Manager with demonstrated ability to lead various sized software andinfrastructure implementation projectsXBusiness Analyst with strong process analysis and design skillsXITSM Consultant with demonstrated ability to implement ITIL best practices andprocesses. Dallas Area Rapid Transit 2012ExpertXXX22

Category 3 – Premium Specialty Skills – High Risk CategorySkill LevelEntryIntermedSkill setLawson Financials Consultant with detailed understanding of the setup andconfiguration of the Grants, Budget, and General Ledger modules as well as thedata relationships and dependencies between the modules.AdvancExpertXXLawson HR Consultant with demonstrated ability to manage upgrade,implementation and business process improvement projects.Lawson Payroll Consultant with strong business process design and improvementskills.Lawson Procurement/Supply Chain Consultant with demonstrated ability tomanage upgrade, implementation business and business process improvementprojects. Detailed understanding of Supplier Portal, Strategic Sourcing, Punchoutand Contract Management.Lawson Technical Consultant with development skills in Process FlowIntegrator/Business Process Automation, Lawson BI to include SmartNotifications and Dashboards, and other toolsets.XXLawson Systems Consultant with skills in Lawson Systems Administration,upgrades, WebSphere, and configuration of Portal and End Points Dallas Area Rapid Transit 201223

Trapeze System Administrator/Consultant experienced in the setup andconfiguration of Bus Stop Manager, Info, Plan, FX, and OPS with detailedunderstanding about security and the database schema. Strong analytical skills withthe ability to troubleshoot trip plans and schedule data as well as debug Trapeze logs.XIBM FileNet Consultant experienced in system design and deployment for multirevision upgrades and/or migration to other electronic document managementsystems.IBM Cognos Business Intelligence Developers with Cognos BI v10.2 experience withthe following modules: Framework Manager, Data Manager, Query Studio, ReportStudio, Analysis StudioXXTrapeze ITS (Transitmaster) ConsultantGIS Consultant with the ability to work in a map network environmentXXXSecurity Video Management Integration Consultant experienced in large-scaledeployment of mobile and stationary camerasXTraffic Engineer with advanced traffic signal controller design and operationexperience, traffic signal simulation experience, knowledge of Advanced SignalController (ASC) hardware and Software,XITS Technical Project Manager familiar with the Traffic Signal Priority (TSP), INITVehicle Business System (VBS), and Camera implementationXXITS Technician with solid understanding of electrical and communicationengineering and experience with detectors, cameras, knowledge of IR detection andWhat’s Up Gold network management a plusXXCommunications Engineer (Fiber / 802.11 switches) with understanding ofelectrical as well as network design Dallas Area Rapid Transit 2012XXX24

Concluding Points Public transit is an important asset for the 4th largest SMA,with economic impact exceeding 10 bn More comprehensive application of technology will improvethe rider experience and potentially increase ridership Technology will improve interoperability of different modes oftransportation Technology will increase productivity and deliver informationto Agency management, including on mobile devices The technology department challenge is to maintain pacewith the rapid changes in technology to deliver lower costsand improved rider experience while protecting investments. Dallas Area Rapid Transit 201225

ENDAllan Steeleasteele@dart.org Dallas Area Rapid Transit 201226

Vehicle monitoring Fare Collection Passenger information display GPS based Automatic Vehicle Location (AVL) Automatic Passenger Counting Security cameras Buses and trains equipped with a private radio system for operator voice communications to Dispatch, and vehicle location data every 90 seconds 4G wireless under