Loading...
HomeMy WebLinkAboutC31700 - CA2 - New Updated Enterprise Software Pckage - OneSolutionCITY OF PALM DESERT INFORMATION SYSTEMS DEPARTMENT STAFF REPORT Request: APPROVE CHANGE ORDER #2 FOR SUNGARD PUBLIC SECTOR TO CONTRACT NO. C31700. Submitted By: Clayton Von Helf, Information Systems Manager Date: March 10, 2016 Contents: Add -On Quote Recommendation By Minute Motion: 1. Approve Change Order #2, and appropriate $133,112.00 to account 5304190-4404000; and 2. Authorize the City Manager to sign Add -On Quote. Background Council approved Contract No. C31700, to pay for the license and installation for a new updated enterprise software package called ONESolution. This software package would update our current HTE software. The package was split into two main pieces; Finance, which includes Finance, Human Resources, and Payroll; and Community Development, which includes Business License, Building and Safety, Code Enforcement, Public Works, and Planning. We went live with Finance in June of 2015. During our installation with Finance, SUNGard purchased a Community Development software company and will be utilizing their software, called TRAKiT, with the new ONESolution Community program. Since the licensing and training has already been paid for the previous ONESolution Community program, they have credited those amounts toward TRAKiT. This change order is for modules and services that we did not pay for originally with ONESolution. This includes a robust integration with our ESRI mapping software, electronic plan submittal software, and an online portal for our customers. This portal will allow for online business license renewals, among other services to our customers. We are on schedule to begin training in May 2016, with a go live in May/June of 2017. Staff Report Approval of Change Order #2 SUNGard March 10, 2016 Page 2 of 2 Fiscal Impact Approving the change order will appropriate $133,112.00 to account 5304190-4404000. Submitted by: Clay4 elf, I 7#ation Systems Manager Al: hn Wohlmuth, City Manager Department Head: Paul S. Gibson, Finance Director f -� C-y o x x -' Gl m 0 co,^. 3 C 0-0 m a N CD X Q a .o iA GS Cs 3 3 2 Vi a co r, (n w a CA m [D n• �+ m CD w o rp a CL m m o 0 m � xxmmT 0r o 630 G7mt7co n7• o F �" y rnA m-v �. 0N� ❑ m A CD 0 7�� a cc O° m 5 - @ to m Q D m m C C - Mp eD y < C7 m a m r � CD°� CD : Q N u N Z a Vl CD Tz °i N 3 � @ pia U CD Oo 'O 0 R7 o mrt =ix=iCD es w CD Z Q Q k O C Z Cl)_ m A@ v w r C N w 0. 1 L a@ m N p Q 3 t- m CD CL w ofl rn 3 ro > a rt N C 7 p1 Q to b N Q O - 3 4 3 (D 0 0 Z N i 3 N+ ,� W .a 01Co O 5 r4 0 O U CO dam' 0 0 0 OmR 04 o O 0, p T 10 o o 9 o 2' -1 C D 1II O b Co o �jo ' O 0 C) , b fa Q Af ¢1 M N o N w wm 4 � N N CDVaNM7mt CD wain0— N coo c N N� Q a a 0 0 O OQ0Ca� Q O[7 Q CD00n0 G (' CO C] @ O CDC7 CD CD CD 0 O C 40 C 4w1 o 40 A _..� s 7 a W W N A [h V , Q O , to " M 0o 0o yr.A Q NON In ❑ ❑ N No Q Cn a M O Q C]O0C? d C3 G OO 6C7Er CD RS N Q O- Q 0 Ca O Ch 0 b O a p 0 p 3 a by 3 ,o0 Al T+ 4AT. V N i bq eD A w -P ---� cp L1 [6 d A Q1 N N A {p i V O U7 0 cT C7 ; Opo� W N -,I C) A O7 Q1�7 Q C]0003 O 05. O O d d O •• *L (D C O fD 0 p C7 C7 O@ 01 O to 0 Q n N V T W T ❑ _0 O 3 c G W 0 d G} .-n (D a) C@jl -1 T y Q � X r ,. m a. N N C 0 �. W CD f�U CL CL I 0 0 CAC �ti-0(Dcno m y�= = o° v y N nC [ = a s c QC. r- w N❑ y CL n 3 C C Z ❑_ y r' t T p gz W rt s 0 7❑ 0 Cl) • -a o � 3 m Cl) (n C g ry' 2 Lp ry ❑- m ffo CD .� -a n y m Q n � o y 3 p ci (CD N �. Q N CDa-V w Cf] m - 0 '< m m 3 0 . CD 0 n rm —11 (nzr - CDC- - 3 3l<w m w a m m y N N D S— ° n�❑ ❑ A ro @ a o o 3 o m 3 m ° g 3° w 0_ n W ❑ m n to g C T N a m C• c " En m n a m m CC o 5. w fJ C = y a) �. d 0 aC o 0 N 0 r. N ?❑_�� U3 m m a)° ro m m a m h c Cr.. m �`� _� c CD m@ rn o 0, 5• 0 3 v o NCL 0 EL Q❑ CO CL 6 m d ° a)Gl � co � 4 C 41 o 0 � m oC C a� m'c n ❑ c w CL n � G}[[' a4o m aa) 0 a m c 0)5 y Q Q a -u N m a n 0. mmt b a] m p -0 cc, � [�D !]. C o �Cm1 c`<Q v m p ?6 o C a o o m (Am C Q o (A m EDs a N a a m y° c w n ZT w m ❑ [n Q C y :3❑ N N ❑�. a n t�—D n Q v G� °-0CL G) y Nm tr ° C ;� � CD r D] DN �o m -o m - C CD 0 CD `CCD ❑ � � � � {D p y m (A mQ� WSd cr CD --I Cm NC gC7 mj (na= G] :3 a3Q v _0 m Q m 0aa Q Q -Nm0 � a a C ❑- 9C3-V=aa ° ° m r- .0 ro w� (D n � o m 0 a 0 z 2 FL cn n c y ¢ --I CD m ? ❑ �' y A a 3 C C) CD M a 0 a a y Q b p N 7 CD ❑ m a w a [7• a N c n a :33 w n G7 n G7 m CD ° � O m ° , m ❑- y m Q 3 Q N =fr v 1= 3 c ❑T ti C N y C C@ to �_ Q SU O N _� rovm.�"�n CD �c ato -1 o e - n n m m-. "❑ � � p � ❑ M 41 � 3 =F � N N [7 C '+ :3O w a p ❑ N N N °`cam°°- CL o y m m _ m A cr a m -o p r- o. ❑ N- 3 c n cn 3 C Al CD n U m 7. m O CD .n. m m y N 1 y o- CD m _� Cp o y 0 y C m ? ❑ 43 D a 0 � m a s m `� co m T m , v rn 3 m m a 3• a »w C] -1 to -u v v v (n S C T [n Cn a m oK<� C m n Q. a N m .n z C � [i C C N o v CD a, a �p � � n m c ❑ d% ❑ i N.� ❑ m 3 x w 3 a 2 Q Q' m m 3 {! Q N N n' m to Q) C) C W o o , CD 3 4A N prti N p 00 O � 0 O , 1 , S O 3 O a ^i 4A N 0 o D o m o 7 d y +� n 3 m 0 r 0 N w CD w m u c an 0 [A 3 0 a a 7 r h G A G iC ep D m m N C i @ .. U) !• N N C m N W A v o too o �o 0 0 ort o , 64 N y i+s y m 1ci !A W DO V co co A W O W Cl) Q 0 O O a C a O tr cn U, O o ❑ o a 2 ❑ O N CD O to 00 O N N CD p CD a 4 a G 0 0 C] 6Q0 O O a a C) O O O n p 0 4 -A s e- � co '� 0 -0 m ^ o x. � N 7 S '0 co W r. (P N. 3 tG c0 O �+ G Z N tD G c0 CQ t0 N fi N. 17 n G O r' n N O G r C .a cD cNo N -0 3 -o �� %�N�� O� o o o «f� 0. � d: o ° m��om a= O�yo.s, d-0o ° o G2.3 cA ZON ?Is-13:" -co Sr %G) a;wA CD oo,sC,00 Z'oo oOp -1 �302 . o 3 �NOQ::r mC- nor, n c 0. CD :'•Nrn°�° m 0G m So O N rn ;.A o o am om 0° 4a u,0. rn000� tic;• °' 060 3> o q om rr. p ?.o�',� 6 0 N a CDm 0 CD 60oo^oa m 73 oCm G�� q�y mL °myo�y °CD � 0 co 3 0) Ta u+ ° 3 0 0 m Z m ^ -0 •• ° 0 0 0 o �N3 ��w 3 3N N°^ •a D 0CD 'cam 13 Nip �, �m0a°. -0 N_ °, C o CO m ° C. m° 2. °' -00 Z m °o N o- m e oo to CD o 0 7 0 0 N' 0� d%1 o qF O q qZ N U) �, 0 6 s yo c;. cn, d m ,`0 o s o 0 OC� A c a o 0 a N G c0 O co co O ^1 aQ,NO m �. o p N o' C �-G q� ZN n cow N? O,ff a ) N o.°'�O!o`3,;N o 0o NU', N ;'.?� NG r GN o N�N0�9. ° O ¢'� f- o ff? co o c ao S 3' ,► '^m0 °1' "'oo'°. 3 �a s -10 u' a�S� N d �� C' c, q� N '< qn "o, o N.o °,.� n o 0�0�'°^� m ° �0 0� oo 0.0 Q:G m �c�'o d 0?. 3 s m 6� O� � S. 4 0-o m o 7 � a m� 6 "� o 0 0 r o 0--o a o� m 0 0 0 ^. �0m Imo d cr'o a o O-A m 00 o ��4° os ��D c r O ., n, ,+ N �. Z N �J G t N p ,. N+ o p N O 0 0--.1 N 3; ° m o n cN N .0�L a c o o s 0 ao -, �A o O-o y '" � =a $ '° 0� 0 � d ��.N<? c o 0o.�c °'0-1m �o - OG= 5 0•om° o•4-0 6a m Cl-6 L �,: �'* N NO O ^O N t�D m mom ccoo NLo -A 0) Q o d� m . N 3 ^ G r- O ni n tC ^CO G N0 c° % N %a 6 6g �q m o a-o 0 0 3 3. n roi 0 n 0 -0� N G° cc N N. A �� 00 so �G6 �c a �N 75 0 N° o m� 0 m 4, m N o rn o C� n N o 0� o -0 0 0 t° • co n y t^C -p O cD .� o r. d^ N r N O N 0 t � N r to s« 0 G@ CO 0 l N N N ^' S N Z q �'\ 0 0 i G n N 6 N O O) 3d G 0� O ) N o N �p y O ^1 co N N 4 pt N n 5. -5 9, 3 a N N N 4 N O° O %1 ? G Z= 0 �� N N G 0 O to 4 � ��� 9° N to E O N N a O 7 ��'0 0 �O N p ?; CO Oco co cGoo G O 00 o Qso3 ° ..w o W U' o �' N o o o 6 ots oco �� N• o OD C� G CC,, co G 0 o 0 c 0 Noco+ NN'o°2�ooGoaa0 o° oe%� �` nOO�� 0°6 �-otm�0 0. ° °' �HN .o n rn 9O0 0,- ^00 °°�.0�4pG�0) � -op� °°o oO?.c° Gco ZqL CP NZn q o� Q° CD cour« Oo 2 n. co O 9 ffNNca0 O O o 0 Um � ao Q a� S0.N coo0. Cj O H O%NN Z n N 0 '"o s (ID s O q o co �Z`G^ZG�mm) 0— 0 rnG� �7o� amg.0-6 o0 000m-A-0aN o�03 0,0 °' Q ; p ip ° Zq n� G 0 M 0 0 �. 0 0 oo CD or O 2-0 G) 0N O qodd o to. °°%uo CD CO co O a cp 0 G °° n y � a cm�0 so 0 o o . N o 3. 0 �o oc+cNom ^ mmo Z nO O� 00oa ° S.N°N . �G 0- sN O n Cn �rGo m 3 � co T°i��3m m N Co mp Q. 210 0° o. 0. Z a �cCI M m o -1U, '"m'a a ONnG%N ^ o, a � oma0�ad ° o�?,� o -A ff0b° ro0c,m o Napo o % m m -o a t:f 3 0- N 4� ,.G N K . N �o - 7 N DN m (A N"•N 3to �n n104, OC�L 9 i� N N N �. 0- 0 N nyNcyO °CDSg �^ aco3 G o n �G�prC���o+'n �rn7--� cNo3 °� m-10 O 0 N 0 3 '� 0. p m 0' H> N � O O O �+ n N o N Q7u+ s Zm DNA N ��' ° o� a.� tea° o° N0 O N fir► t�P a �Z �•( %„ N G N �' 0 0 G O O M i 04 G° m m A O S -A i -A ? 0 O .G tU N 0 t:r 3 Q 7 3 m(P N N-O t�D O �_ Q O N q• 1 41 3 CD 0r, �. ��. m 0 N p G 0- G i r. W. n. N� d Z O (' N 7 CD a N N v, n 0 0 0 N r o� o i a N I- m 'n CE O N 3. 0 `� u' m N c6 m ro 3 °,. 0 o tD d7 , O �-A m � m m o- ,m° d% s 7� N 0 m �co� c0 n 7✓ cD 7 N'@ N N G O n O� 0 0� tD � 3� O CD CO n� ?J Q Z m !� CD N cD N a m 0 (0 q N m�7 T 7r-to 0 �ma ,, N m o^ o c0 n ;� �m m 7 6 a a 7 �O N N m% 7 N G p1N N m N G N L ll N '^ Q1 7p u' cf1 9� m c t0 N p N G T m� N° O ^ cD ° y. .+ a 0 O O �. �• co O G i? .�-1 0-0 -• .� S 7 O o t0 n 6 O O N '• 7 d• fl N t0 41 T' Z c L f�D m 2 a X 3 '' % n CD ^ o, C � ti �Ln '° �-0n 0 7 O Z 0-5 a° �� cl% N°� o o� S m c cn GINo�. c0m -;)0 fir" Z N OON 1 m p Q� o%'m N 3°C• �' mp 00, o N N oZ O o, o -� ° o n It 0 a fp U, � m N. � �Ots `o �cv p� 2 � a ° d S ao � o °CD �. O N 3 N i�O 0)? �, q G'y N ^O coo 4 N �o ° m m NoN 7. N m 50 cP�G �,m ° n m o �3. LO mG n 9� d 0 O �' G C O n (p -4 Ni N O ^, �• NG 3. m ° �0 3 c°D °'c Z m � m °� ° 3 c oj. m d. o 7 7 O 7� O N N O N N N d a m os d ��3C� ; O p SZ� o �0 �d� �Q o '0 0 70. 0.0 X N O o �3 co� co to G O N o° Ofl 41 N m o m M;'-moo iN � m yqm ai. o N r�o ° et 0 o .,.O N� N o m oGo C) 7. o-� Cs No n qO � Q 3 cp ° mmg 3o m0.,O C CD to l-k O T OO'` to ^ NJ 7 � 37 cDScoc ?� D' O G 0 m N o o m co �-A ° p On Co N O cG7 GC67 IS,. o CD o ^ cP U) y r- 7r. .G NJ�^ �: N N O O CD ? N (P 7 n: O N � wm �� ym o � (P v O Grcn ° �o:4 �co S.� o m ow s �� 0,3 o L O Zr G o :, N° 7 �u+-c- � �m oo° m G p�Z m a 7 0.0,, o 0- .0 0 CDN N O O� O G CDn91 G m o N N Oa n y °O G dG 0 o d ? O r. p � ° N ON r�� co N7 N O �G 0 0 G�' o 0 97 '� Q C�U�r m.0 m 4 m. N 3 ° 3 Z .G T a r r N CO °o o 0 07�D^ 0, to o `". o Y. o Z Qo0 m O �� �p 3 a d o c O ° 4� eA�OG m u� 0N o m Z r m0 q ° s �O oo o0 M d O cP oG3°°� m°m c o G N N, °��• a0-O0 Z G Q O N 7� O• co4 N 7 m O -A Co N� o O o� iji '4 7r. � r• 7G O 7 05 M Z.,° 7 � � � O � 4 N d C/) m (/) K D cn 0-0 3 � -can C --I - D 0 � = A C/) n � D o c m 0 c v c A (D a m . °» c �' m n 3 3 c� 0 (D ,' m 0 m v 3: v(o mm� 3 m 3� m�� 3 c c NM o �� ZN Snm A -p Q _0 O v -0 N n m =' .aa) l< cr ^? O o (-D N' N O1 N � =O � .0 � � � 0 j O C `< C O 7 c- 0 m 3 .+ O' S `< N a �% m O A 7 7 N o m S 3 y M i7 7 m m 7 m 0 X m C S ° m -0 m �. (=D m 3 m 0 n' (�' cn (nS=U ()' O °_ N N O_ (D N �. N y y N N 3(D c a om i2 a m N O m ° m m A m 0° O N C y v m 3-0 0 y 3 m 7 n O O m n- 3 A m A 7 (O Q O C m .z m �. (p C m (7 .. ,-. �, C-0 ]• N i N m y o(D ° m o m ° c D 0 o cco �C°C m� my. °0v Nm �X0 Wo c� N o0o c 0 3 o�'a 5. N m o o m p_ 7 n � X S O O m , N- n N y n N '< Oo :3 m n a n• d N �. m C D 3 (p 3 y °' N m N gcn m �� cn 0 (m O g m am m ca s� �3 -^ .m0 c m mmcn W A ? c O N- S m c < m m m 3 S w m °- n 6 C N d cn N O 3» m N A 3 m N fD a N d <° y n N Q C (D -O .0.. m 0 C ° m 0 pa n m m m -1° c s'o,�� m c o co SoS »� c y m- (D X a ? n m o 'm c00 i c y �• _� w� X S.� m -0 (D 7 A N m- c m ~ c d7•L7-I d3 "O0 A 7 = (n C N y a fD N N 3 D n n X m N? -0 m N= 3. o o y 3 n• -a �• C a m N• phi f° y m (AD X m> '� n N p• C 3. vCD 0 cnG) m a y -o y <n 3 ma °•-0 0'm0 cc n mmm 3'atoC �°�t0 mn my °m �.0 <� a� -0 3-y ° vmovv °gym N C 3 n a lD O r; (D O m (0 (n (n �< ° .. N (n S > >' tt 0 o A 3. N n' < �, _v in 0 0 -to 0 3 n A m a m N n (n S' (MD �i 7 c O- N N O W y Q A m C 3 (gyp (gyp m N_ �� � C 3 m c 0 AO, aN O ? S m cn Scam m '»m a0 N m m C n 'a cn S. O 0 Q - _> > O O p A m >' CD < a A -, O �i N 3 O n N "� 0 A y (n m 3 (D N 7 N c rn A a N 5 n o m (D c° c U) m- v c m m o° S <' d ma a N N -0 fD N= m m c a n 3 Q• A m -« fD (n a y' (p o m O Q O 6 m o j N N a- a) 6) c° m ? C Nv v N < < � ;:W CD - m 3 c m N m �. G) n _» O ? m o n w (SD =° m °' m m m m m C m 01' m < D v� O �. m N = N Q a CD 0 W M- O A N d 0 7 D S m � n Q= N � � � 7 0 S cr y j S C m �. 3 y N v mm ,< 0 3 (om m m m 0 <NS a oco -d ° mD CN O p v-aN mi ° mo mNo o 0 N n 3(n _go c`< oo ao �°, S. m °<_ N� 3 N m r 0 3 N m N m A N c v(D N 7 O_ �' .�•. C ci m m 'o m 3 cn w m o m 3 A» m D v �' m n � N p c m CD cn y m M m v n c'� m d o mm c c� m 0 M c0 c s v m m w N c 3 c m m 0 =rC:r c m N m 0 3a A °�< m v �c0 nc Imo' noacmio m3 oy < m ? mS » mm A Q CL (D m coo CD o>lJ a >> (n 3,' 0 o ' 00• �00ma Q3m0 -0 d c m n Gl - N (p m a " cn a O p Cf n p<j 7 m. c n c 0 n o a 3 0 an d 3 3 m o 3 0 ; m c_ gy m° .v N A (D m< 1 y C y N < A co S p' 0 O S <0 0 m m Q m w C y� In - m n' O o ° �. j (0 m n. C- m w cn com N c �( -0 DI N N (D - 7 N m y O 0 Q 0 '.: y v o m� m: °a �, a v m �. ° m c� M --D Cl o c _" � Nc 0. 3 0 0 '� N 7 ,-. n N_ S mj en 3 m N C m m m N tU N S y 0 S (AD G (n - (SD ° n C N O -.0 U) d m y N m0 a= N M - 0 m cn 3� O� n N 0 m n 3 N S » S - 0 to O O N S X c m N rl m 0 5 � m N O N N N o m N 3 m »_ =ri N -i `< 0 (D o a c - - n m �• � m c� 3' A cci 3 3 m°» 3 (D (D 0 0 m �< S 3 » 3 °m to Q _� a m wo m -0-0 C ° N ° (� S M (D 7 p. �' O (O v a> 3 N y• a .+ A 3 O N O m -a 3 v c _ c (p 0 O m n� m S y fD ° m CL c » m N ° 3 cn o_ U) m ° o m C v C m m �' G) m c fD a m N » CA m^ o moo- ~m �mcu= �osa)-0 A m 3 m e N N CL m n. O o m' m »N M 3 m m < 3 m < u' 0'm o m 0 o m 0 _ _ -_ m N o'. 3 w n m o nm 30 �'N 0'y X� 0 0 m m• n c 0 3 m m nQ a ('n nm o amc m �, w� < cM p� c Y 0 A m A -0 < m m aC.»m �''»- n 0 G) ma S< do o n nmc°n m�0� 05'0 ElF°' vm Q co -c S- CDw� c cn m� :3 (a m m m ° m m (n ^ < A x (� m Q3 �,» �a m1- ° o� N v0Y ° ° flm ,vmE; �� m v ?�N ° m �om� scoom N m o x 0a n o 3 m m a, m m m 3 d N c o (yp N m n N S o N N c C _ CY S 3 ,-- 01 .. N 3 N ° C d A m S j fSn (gyp 3 0 M 3 N a - m S m n 0 `< c c - c° a) S m A m° ay m 0- d_ m tu °-' i S m 0 v v m0 cn a' c r CI- .�. o) O (SD l< M p� O Ln N p N 91 a m cn a O-« ?. N M. n N n -0 cq0 .. ^ p O O � N G (D tH N O• cNo ?:�in�o3.3 Q 9Qp 1 O (J) N 41 Dt n 6 O O � CD G r N O' {D G CD -00- (D :A 0) y O , . N p �? o N CZ N G 0. O 4A p O T' cn 7 O� O 300 .=oa N 0-0 O 0 �1 r G N O ow0 3 3 @-0 N n to O G N G G^' O O N co CDco m ,� a�.N c (P `•o0 G CD (D n N m n 3 O 3• N O N• O m 7 �• �. G � fD N G CD O N :5 3 7 N 0 "t' y p o 0 G S•3� C 0 y ...G O tD 0 N N N �O N N _ Ck. (P 7 .+ 0) -. Zm.N m c w N ^ tD N O— C C' m N �^ N Q N 0 O � 6 n A N N n N m 7 tD p O c° NG�c3 CO N N G• (D N G {^jf N m N �p 00 m�oom �CD N 6• N• -d < 0. < 9 �^ r•N cnu Om 0(D d N G N Q l N O� O T O EL