Loading...
2024-08-20 CC Agenda Packet - ITEM D19 - Tyler TechnologiesReplacement of City's Enterprise Resource Planning System Presented by: Jose Calderon, Paul Chung, and Rebecca Redyk ELSECUNDO 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 1 What is ERP? • Pillar of Finance and HR Operations • Largest and undertake most complex technology project a City can • Enables organizational efficiency ELSEOUNDO 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 2 Selection of Tyler Enterprise ERP • Evaluating options since May 2023 • Several on -site and remote product demonstrations • Presented to Finance Committee and City Council 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 4 ELSEOUNUO Implementati r Post Implementation FTotal Year 1 Year 2 Year 3 Year 4 Year 5 Tyler Technologies 5% CPI 5% CPI Implementation Services $ 279,550 $ 279,550 $ - $ - $ - $ 559,100 Annual Maintenance 255,302 255,302 255,302 268,067 281,470 1,315,444 Eden (6 month Credit)* (39,796) - - - - (39,796) Tyler Technologies Costs $ 495,056 $ 534,852 $ 255,302 $ 268,067 $281,470 $1,834,748 Koa Hills (PM Services) $ 120,000 $ 120,000 $ - $ - $ - $ 240,000 Temporary Employees (Staff Coverage) $ 50,000 $ 50,000 $ - $ - $ - $ 100,000 Total Estimated Project Costs $ 665,056 $ 704,852 $ 255,302 $ 268,067 $281,470 $ 2,174,748 * Year 1 includes 6 month credit for current Eden ERP System ** Years 4 and 5 include 5% maximum CPI increase per agreement Finance Tyler Enterprise ERP • Tyler Content Manager (TCM) provides electronic documents and attachments • TCM provides an intuitive user interface for system workflow, such as processing invoices and cash receipts • Tyler's Hub Platform centralizes access to information. Robust financial reporting, budget tracking, and document retention • Tyler's Utilities Pro module automates utility billing while providing dynamic reporting capabilities in an intuitive user interface 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 6 Project Manger Koa Hills • 80+ ERP Implementations • Various agencies on Eden to Enterprise ERP ✓Conduct regular status meetings with core project team members ✓Serve as the City's Project Manager in monitoring and reporting on project status ✓Collaborate with Tyler project management on the scheduling of resources and tasks ✓Ensure that Tyler project deliverables are fulfilled ✓Provide core -team and end -user training ✓Track the project budget EL,SEGUNDO 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 7 Human Resources Project Manager *Provides credibility to the implementation process *Serves as an impartial third party to implement changes for optimal workflow *Assists staff struggling with change to new system •Preserves positive internal staff relationships Tyler Enterprise ERP *Trusted system for government entities Converts manual processes to automated for efficiencies *Greater ability to track and report on specific metrics for analytics *Import capabilities from other systems (NeoGov, Telestaff) eigecuNoo 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 8 Tyler Technologies' Presence in California Mendocino County City of Pasadena City of Santa Monica City of Monrovia City of Wasco City of Napa City of Santa Barbara City of El Centro City of Richmond City of Woodland Yuba County City of Newport Beach City of Encinitas City of Palmdale City of Redlands City of Oroville Cityof Walnut Creek City of Lakewood City of San Carlos City of Diamond Bar City of West Covina City of Simi Valley City of Martinez El Dorado County City of Monterey Park City of Lancaster City of Santa Fe Springs City of Upland City of Hayward City of Culver City City of Stockton City of Alameda City of Lincoln City of Port Hueneme CityCity of Shaffer of Benicia City of Madera City of Mission Viejo City of Coronado Town of Los Gatos Cityof Manhattan Beach City of Westminster City of Burlingame City of Loma Linda City of Oxnard City of Livermore CityCity of Berkeley of Pleasanton City of Covina City of Rohnert Park City of Glendora Helix Water District Bonita USD City of Rocklin City of Perris Visalia USD Clovis USD City of Los Altos City of La Habra City of Fontana Mar in County ty of Lompoc City of Taff City of Gilroy City of Laguna Beach CityCity of Temecula City of Poway City of Chino City of Merced City of Oakley City of Dublin City of Ceres City of Lodi City of Carson City of Arroyo Grande City of El Cajon City of Hanford Town of Danville City of Palm Springs City of Menifee City of Fresno � City of Watsonville City of Chula Vista City of Fairfield City of Pacifica San Jose USD City of Victorville City of Chino Hills City of Morgan Hill City of Tulare Cityof Vacaville City of Albany City of Rancho Mirage City of Hillsborough City of Alhambra City of San Juan Capistrano City of Redding Santa Barbara USD City of Farmersville City of Milpitas City of Rancho Palos Verdes Plumas County City of La Mirada City of San Marcos Del Norte County West Contra Costa USD of Ukiah San Bernardino County City of Glendale City of Daly City Contra Costa CountyCity Office of City of Fremont Alameda County Waste Comm. City of Paso Robles City of Orange Education (& 16 Dist.) Lassen County Midpeninsula Reg. Open Space Dist. City of Tracy City of Coachella Delta Diablo Sanitation Dist. City of Turlock Golden Gate Bridge Highway & City of Vista Port of Stockton South Coast Water District City of Yorba Linda Transportation Dist. City of Lemoore City of San Rafael Las Vir enes Municipal WD g p City of Bakersfield Hayward Area Rec &Park Dist City of Indio City of San Bruno, Padre Dam Municipal Water Dist City of Beverly Hills Sacramento Public Library Auth. City of Union City City of Davis' Riverside County Transportation City of Indian Wells Desert Water Agency City of National City City of Yuba City` San Diego Association of Govt. Vallejo Flood & Water Dist. Canine Companions for Ind. City of Citrus Heights City of El Segundo` Dublin San Ramon Sery Dist. City of Cathedral City City of San Ramon City of Fullerton City of Pittsburg San Bernardino Water Dept City of Hawthorne City of Hemet Cruz County Cucamonga Valle Water 9 Y Santa Margarita Water Dist. Placer County Water Agency Town of Apple Valley Nevada Irrigation District 9 Indio Water Authority Encina Wastewater Authority Central Fire Dist. of Santa City of Huntington Park 'contract negotiations 9 Cityof Rialto El Monte City School Dist. City of La Canada Flintridge North County Transit Dist. City of Solana Beach City of Vernon tyler Otay Water District East Side Union HSD City of Long Beach Sacramento Area Sewer Dist. City of Yucaipa •;•' City of Redondo Beach San Joaquin Delta CCD Napa County p ty eU. r. CaNr W •r � -- r•.••i Bwr-a••r t.l.eWvPr . [:bvr a..I•Mi..M MrlMO M rYr:1.•IUEVE•y 11ti Mrr.T.:.rs(V-mry(Nr Cube Conr*clr q Kyrl1. hl,� p A—N1.W V •. F�A�rr lyw.r V••.�wi•y Spending and Budget Trends • J J 2 J J J 2 •; Overtime YTD , .. MEU FLEET .. .F I FIRE —AT FIFE I—RT w rr:iMhen rq prll nRE OERART •11 eCW4: FIRE CiYAT FRE..RT •i�+`N*•i MECFwnI_I FLEET 1.: YLLU FARE CISPAT "K OE—T _—M .��..I _�� •'E aTJ•.s 3. RBl C9Jai Il[WYI ` J f, �,� �,.,`�, <r •' . ,'JJ i�.r ..1.>, w.�L E.F urcF•Ery LE uncuLry we Revenue Collected a:l S '.• .. � IRFFWr. ••. 4 �. Part Time YTD Hours Approaching 1080 _ j nolw. y pit; _..r I b]0 �_560000 16SI 53G.o00 00 16TT 5306fi000 ISi9 535 OOd TO i So3 515.=T300 330353/0 I SOB W -'O b0 1520 SIE7SB UJ Quick Links Q V - CenRal QE•p...._a Cen, .i QC,.t. to F.pn� Q ERP E.e.1 I11i31 i. ® Enryo�e. l.er,lie� Fr �EIl�clee kll S.I.« C ticnl�EC E �I a� � U6 Cw.1r: sniwn3 E.— .�FaYm mz IL .al Fa.3:lli Mana3e P[Im1y_ eFOIIiI>:Yni :i:lleGcn �• Ing IA n:ger � i Questions? ELSEGUNDO 08/20/2024 City of El Segundo 1 350 Main St. El Segundo, CA 90245 11