[00:00:04]
LATE. THIS IS ANOTHER PART OF THE BUILDING. WE ARE IN CITY COUNCIL WORK SESSION TODAY IS TUESDAY, NOVEMBER 2ND YEAR, 2021. IT IS. THREE FOUR IN THE AFTERNOON AND WE'RE IN COUNCIL CHAMBERS AT 2 22 NORTH TENNESSEE STREET. IN THE GREAT CITY OF MCKINNEY. FIRST ORDER
[PUBLIC COMMENTS ON AGENDA ITEMS]
OF BUSINESS IS PUBLIC COMMENTS. SHOW NONE HERE. YES, I DO. SORRY. NINA DOWELL RINGLEY. YOU KNOW, YOU KNOW THE DRILL. SAW SPARE YOU THE INSTRUCTION, OKAY? NEEDED OUR RINGLEY HISTORIC DISTRICT, BUT I JUST WANTED TO SAY PAY TRIBUTE TO UM MAYOR BILL WHITFIELD, WHO WE JUST LAID TO REST. I JUST CAME FROM PECAN GROVE CEMETERY. AND THE FAMILY SAID THEY SAW DEER LAST NIGHT, WHICH IS VERY FITTING FOR MAYOR WHITFIELD. BUT I WANTED TO HUMOR ALL OF YOU JUST FOR A MINUTE. I KNOW THIS IS BUSINESS, BUT. HE WAS SUCH A HUMOROUS MAN HE HAD SENT TO HUMOR. AND UH SO THAT ARE THINGS THAT WE DID FOR HIM. WE'RE KIND OF OFF THE WALL, SO I WANTED TO READ ONE TO YOU THE FIRST ONE THAT I ORGANIZED WITH 20 WOMEN AND WAS CALLED WINE WOMEN AND WHITFIELD. SEE I THOUGHT THAT WAS PRETTY CLEVER. TALK ABOUT FAMILY TALK ABOUT FRIENDS. TALK ABOUT HORMONES. TALK ABOUT BUSINESS. TALK ABOUT HUSBANDS TALK ABOUT STRESS.TALK ABOUT TEAMS TALK ABOUT FACIALS. TALK ABOUT CHILDREN. TALK ABOUT TEETH. TALK ABOUT WRINKLES. TALK ABOUT MOVIES. TALK ABOUT POLITICS, WINE, WOMEN AND WHITFIELD. AND, UM.
THAT WAS THE FIRST TIME HE RAN THE SECOND TIME IT WAS WISE WOMEN FOR WHITFIELD ANOTHER LADIES' NIGHT OUT. AND THAT WAS HERE AT MOM. AMELIA'S THE SAME 20 LADIES AND HALF OF US WERE ALL SHORT MY SIZE MY HEIGHT, AND HE USED TO SAY WHENEVER HE WAS TALKING ABOUT THE WATER.
ISSUES YOU KNOW, WITH T C. Q ALL THAT, UM IN THE WEST SIDE, HE WOULD SAY WE GOT TO DO SOMETHING ABOUT THAT WATER BECAUSE ALL OF YOU ARE SO SURE. SO I JUST WANTED TO HUMOR YOU AND THAT'S ALL. THANK YOU VERY MUCH. THANK YOU, NINA. RIGHT? YOU'RE NOT GOING TO RECOGNIZE THAT. FORMER CITY COUNCIL, LADIES FIRST. UH YES. WHERE OH, SORRY. YOU KNOW, WITH THE READERS ON I CAN'T SEE BEYOND RIGHT HERE. RICHARDSON WOODS. HOW ARE YOU? WHERE HAVE YOU BEEN? WE SO MISS YOU UP HERE, AND THAT'S AND I MEAN THAT AGAINST ARE PUTTING ON KIDDING.
UM BUT WE MISS YOU, BUT OF COURSE, YOU KNOW WE'RE IN GOOD HANDS UP HERE, BUT GOOD TO SEE YOU. SO GOOD TO SEE YOU. UM JUST NUMBER OF, UH, WE'RE AT THE, UH, WHERE MAYOR WHITFIELD'S FUNERAL AND TO HEAR. HIS FAMILY MEMBERS TALK ABOUT HIM IN THE STORIES THEY SHARED.
AND I REMEMBER JUST A FEW YEARS AGO WHEN HE WAS IN HERE, TALKING ABOUT THE FACT THAT HE WANTED TO CONTINUE TO BE ABLE TO SHOOT SQUIRRELS. FROM GOING INTO, YOU KNOW, KEEP THE SQUIRRELS OUT OF HIS HOUSE AND BY GOD HAVE BEEN DOING IT FOR 100 YEARS GOING TO CONTINUE TO SHOOT HIM, AND HE DIDN'T WANT TO BE TOLD THAT HE COULDN'T DO THAT. REMEMBER? THAT WAS AN. IN A AS IN ELDORADO, JUST RIGHT. BUT HE WAS LAUDED BY THEN HE WAS LAW ABIDING. YES, TALK AND BB GUN. IT WAS A BIG GUN INTERVIEW. BUT THERE WAS NO BB GUN TRYING TO BE KIND, BUT HE WAS. HE WAS THE FIRST MAYOR THAT I REALLY GOT TO KNOW. AND, UM WOW WHILE HE WAS IN OFFICE, SO. HE WILL BE MISSED IN THIS COMMUNITY. OUR FIRST WORK SESSION ITEM IS 210986 UPDATE
[Update on the Enterprise Resource Planning (ERP) Project]
ON ENTERPRISE RESOURCE PLANNING. THAT'S THE ERP. PROJECT AND I THINK SAID. SIR.SO MAYOR COUNCIL MR GRIMES WANTED TO GIVE YOU A QUICK UPDATE ON THE E R P IS GOING UH, PERSON. I'D LIKE TO START WITH A FEW POSITIVE NOTES ON THE PROJECT. JUST REAL QUICK.
IT'S NOT IN A SLIDE. PROBABLY BE MORE TALKING THAN I WILL SLIDE TALKING. SO WE'VE HAD A VERY DEDICATED GROUP OF PEOPLE WORKING ON THIS PROJECT FROM BUILDING SPECIFICATIONS TO PREPARING THE RFP TO PUTTING IT OUT TO BID. GOING THROUGH SELECTION AND FAMILY PICKING A PRODUCT. UM. WE ARE TOO FAST FORWARD TO TODAY. WE ARE CURRENTLY GOING THROUGH STEP TESTING THAT SYSTEM INTEGRATION TESTING. UM IT'S GOING VERY WELL AS FAR AS THAT TESTING GOES. THE VENDORS EVEN SAID THAT ARE TESTING IS PROBABLY SOME OF THE BEST TESTING I'VE EVER SEEN DONE. THAT'S NOT TO SAY WE DON'T HAVE CHALLENGES THAT THIS PART OF THE PROJECT
[00:05:01]
IS GOING VERY WELL. MM. SO I'D LIKE. TO MOVE ON TO HELP ME, EMPRESS. THEY'RE JUST I WANTED TO MOVE ON. WANTED TO MOVE ON TO THE BUDGET. WE ORIGINALLY STARTED THIS PROJECT WITH $12,650,000. IN JANUARY OF 2021 COUNCIL DID APPROVE THE PROJECT AND ALL THOSE CONTRACTS THAT WENT ALONG WITH IT. THAT WAS IN THE AMOUNT OF $9,264,000. ALSO AT THAT TIME WE ASKED TO HAVE.SOME EXTRA RESOURCES TO HAVE INTERIM STAFF HIRED TO HELP US THROUGH OUR DAY TO DAY TASKS, WHILE FULL TIME STAFF WORKED ON CONFIGURATION OF THE SYSTEM AND CONVERSION TO THE NEW SYSTEM.
SO WE ASKED YOU FOR 568,569. WHICH YOU GRANTED US IN WHICH WE HAVE BEEN LEVERAGING QUITE A BIT. SO THAT LEFT US WITH A BALANCE OF $2,824,000. THAT TAKES US TO THE LINE OF SIERRA CEDAR PREPARED INTERNATIONAL, AND I'M GOING TO ADVANCE THE SLIDE HERE IN A MINUTE JUST TO TALK THROUGH THIS PARTICULAR LINE. THIS IS WHERE OUR CHALLENGE COMES IN. AND OUR CHALLENGES. OR THIS. UM WE DID AGREE TO AN AGGRESSIVE TIMELINE. WE DIDN'T WANT TO SEE THIS PROJECT STRETCH OUT FOR YEARS ON END. WE WANTED TO TRY TO MOVE THROUGH FAIRLY QUICKLY RIP THE BAND AID OFF AND GET ON TO A NEW ERROR WITH THE CITY IN OUR IN OUR SOFTWARE. UM WE'VE HAD STAFF RESIGNATIONS IN SEVERAL AREAS. MY PARTICULAR AREA IS THE ONE THAT'S CAUSING US THE MOST HEARTBURN AT THE MOMENT AND THAT I'VE HAD THREE RESIGNATIONS IN MY APPLICATIONS AREA AND THOSE THREE RESIGNATIONS WERE WORKING ON OUR DATA CONVERSION PROCESS. SO WE HAVE ALREADY STARTED SHORING THAT UP WITH TEMPORARY STAFFS OF HIRED TEMPORARY ANALYST TO HELP US GET THROUGH SOME OF THAT DATA CONVERSION WORK OF ALSO HIRED DEVELOPERS TO HELP US WITH OUR INTERFACE DEVELOPMENT. TO TRY TO KEEP THOSE THINGS ON TASK. AND THEN ORACLE CLOUD USES WHAT'S CALLED AS WHAT'S CALLED TEMPLATES TO GET OUR DATA FROM OUR LEGACY SYSTEM INTO THE NEW SYSTEM. SO WE TAKE OUR DATA OUT OF NOVEL LINE. PUT IT INTO THESE TEMPLATES. AND THEY UPLOADED INTO THE INTO THE ORACLE CLOUD. THAT'S CAUSED US SEVERAL ITERATIONS ITERATIONS AND HAS CAUSED US SOME CHALLENGES AS WELL. SO WHAT IS OUR PRIMARY THREAT? IT IS DATA CONVERSION. WHAT'S OUR SOLUTION? AT THIS POINT, IT'S A COMPANY CALLED PREMIER INTERNATIONAL. AND I'LL GO BACK A SLIDE. TAKE US BACK TO THE BUDGET, AND THAT IS THE SERIOUS CEDAR PREMIER INTERNATIONAL SLIDE OR LINE. THAT IS A CHANGE ORDER AND THE AMOUNT OF $1,488,000 700. I'LL GO INTO THAT CHANGE ORDER. SO YOU KNOW SPECIFICALLY WHAT'S IN IT IN JUST A SECOND. IF YOU ALLOW US TO EXECUTE THIS CHANGE ORDER THAT WILL LEAVE US A BALANCE OF THE MILLION 336,000. AND THEN SO WE CAN BE NIMBLE FROM HERE THROUGH JULY, WHICH IS OUR GO LIVE DATE. JULY 2022. WE'RE ASKING YOU TO GIVE THEM CITY MANAGER OF THE AUTHORITY OF $500,000 WORTH OF LATITUDE AND IN PURCHASING AUTHORITY SO THAT WE COME ACROSS OTHER CHALLENGES SOFTWARE HARDWARE. RESOURCES WHATEVER THE CASE, MAYBE I CAN JUST GO STRAIGHT TO THE CITY MANAGER AND SAID MR MANAGER. THIS IS WHAT I NEED. HE CAN SIGN AND WE CAN GO. SO IF YOU ALLOW HIM THAT LATITUDE THAT WOULD LEAVE US $836,000 IN THE PROJECT BUDGET AS A BALANCE AS A SIDE NOTE. ON THE NOTE. WHERE THE LINE THERE WE DO HAVE CONTINGENCY AND ALL OF OUR CONTRACTS OF 588,503. THAT JUST DOESN'T CHANGE ORDERS TOO LOUD AT LARGE TO ALLOW US TO USE THAT CONTINGENCY. BECAUSE IT BROKE UP INTO FIVE DIFFERENT CONTRACTS. BUT IF WE CAN GET THROUGH THE REMAINDER OF THIS PROJECT WITHOUT TOUCHING MUCH OF THAT, THAT WILL ROLL BACK TO THE BALANCE. SO WITH THAT. JUST TO GET INTO THAT ONE LINE ITEM A LITTLE BIT. THE TWO LINES IN THAT CHANGE ORDER IS AN EXTENSION OF THREE MONTHS FOR SIERRA CEDAR IN THE AMOUNT OF $375,000 THAT WILL TAKE US TO JULY OF 2022. AND HIGHER PREMIER INTERNATIONAL, WHICH IS BASICALLY A HIRED GUN TO GET US THROUGH OUR DATA, CONVERSION PROBLEMS AND THE AMOUNT OF $1,113,700. FOR A TOTAL CHANGE ORDER OF 1,000,488 700. SO WITH THAT. TAKE ANY QUESTIONS.
EVIDENCE IF WE SAY NO. I'M KIND OF STUCK. WE'LL HAVE A WE'LL HAVE A VERY LONG DELAYED PROJECT. THAT WILL, UM DR WOULD COST US A LOT MORE. THIS IS I MUST SAY, UH, PROBABLY ONE OF
[00:10:01]
THE WORST AND JUST IS WHAT IT IS, BUT IT'S ONE OF THE WORST TIMES YOU COULD DO ANY RP TURNOVER OR CHANGE OVER OUR IMPLEMENTATION AS WE CALL IT. WITH THE WHITE HOT MARKET FOR IT QUALIFIED PEOPLE ALL AROUND. UM IT IS VERY DIFFICULT TO KEEP FOLKS ON BOARD FOR THINGS LIKE DATA CONVERSION, UM, BECAUSE THEY LITERALLY CAN GET HIRED RIGHT FROM UNDERNEATH YOUR NOSE.AND UM, YOU KNOW, IT'S NOT. WE'RE NOT TALKING ABOUT $5000 DELTA AND THEIR SALARIES, EITHER. THERE'S SIGNIFICANT INCREASES AND IT IT POSES A ONE OF THE MOST CHALLENGING STAFFING. UM. CONTINGENCIES THAT I'VE SEEN IN MY CAREER. THIS CURRENT MARKET RIGHT NOW IT'S ALWAYS BEEN THE LAST DECADE HAS ALWAYS BEEN. A VERY COMPETITIVE MARKET. RIETI FOLKS, BUT RIGHT NOW IS PRETTY INCREDIBLE. AND SO MY RECOMMENDATION TO SAID WAS, WHAT DO YOU NEED? WHAT RESOURCES YOU NEED FOR US TO BRING IN HIRED. FIRM THAT JUST DOES DATA CONVERSION AND THEY CAN HELP US GET THIS OVER THE HUMP. AND THIS IS THEIR SOLUTION. AND I'M SUPPORTED, OF COURSE. HARD TO IMAGINE THAT. THE ACT OF DATA CONVERSION AND ENTRY IS JUST NOT A TREMENDOUSLY SOUGHT AFTER AND DESIRED. ASPECT OF IT, SO THAT'S A VERY THAT'S SO INTRIGUING. YEAH UM, OBVIOUSLY SAID, THAT'S THAT'S SOUNDS.
IT'S A LARGE AMOUNT OF MONEY. AND SO OBVIOUSLY WE'RE TALKING ABOUT. THOUSANDS AND THOUSANDS OF MAN HOURS. I'M IMAGINING THAT IT TAKES TO DO THIS IT UP IN THE LAST THREE MONTHS, JUST IN THOSE 33 OR FOUR STAFF MEMBERS, ALMOST 2000 HOURS. SOLELY DEDICATED TO THIS. AND SAID, JUST FOR EDIFICATION FOR OTHERS, COULD YOU JUST IN LITERALLY TWO SENTENCES? UM.
WHAT WE'RE DOING IS A CITY THAT THIS IS A HUGE. OVERHAUL UNDERTAKING REIMPORT IMPLEMENTATION OF A COMPLETELY NEW SYSTEM AND JUST A COUPLE SENTENCES FOR ANYONE WONDERING, YOU KNOW WHAT? WHAT? WHAT ARE WHAT ARE WE DOING? SURE SO THIS PART OF THE PROJECT. THIS IS WHERE WE'RE SWAPPING OUT ALL OF OUR. CORE APPLICATIONS FINANCE HUMAN RESOURCES, EVENTUALLY UTILITY BILLING OR IMPLEMENTING A WORK ORDER SYSTEM, RENDERING A NEW TOWN KEEPING SYSTEM FOR PUBLIC SAFETY. THERE ARE FIVE DIFFERENT MAJOR APPLICATIONS THAT ARE BEING REPLACED. THESE ARE 20 TO 25 YEAR OLD APPLICATIONS THAT WE ARE REPLACING. YOU CAN'T EVEN FIND ANYBODY THAT CODE. IN THE PROGRAMMING LANGUAGE THAT OUR CURRENT APPLICATION IS WRITTEN IN SO BUT THIS SETS US UP. IT IS A SIGNIFICANT AMOUNT OF MONEY, BUT THIS SETS US UP FOR THE NEXT 20 TO 25 YEARS. HOPEFULLY BEFORE WE REPLACE AGAIN. MORE THAN A LONG HAND, CHARLIE. THAT MIGHT HAVE BEEN MORE IN TWO SENTENCES, TOO. SO THESE ARE THESE ARE SIGNIFICANT PROJECTS BUT ADVANCES THE CITY GREATLY IN THE AMOUNT IN THE WAY THAT WE CAN REPORT AND KEEP TRACK OF OUR FAMILY FINANCES AND THE WAY WE MOVED PEOPLE THROUGH THE ORGANISM, THIS TREMENDOUSLY MORE EFFICIENT, MUCH MORE. THE OTHER QUESTIONS CANNOT NOT DO IT. YES THAT'S FOR SURE. SO. REALLY NEED A FORMAL ACTION LATER. MARK THIS IS JUST WORK SESSION AND WE'LL HAVE A FORMAL ACTION TODAY AND CONSENT ITEMS, SO OKAY. THANK YOU FOR ACCEPTING UNDERSTAND.
THANK YOU. COUNCIL LIAISON UPDATES REGARDING VARIOUS CITY BOARDS AND COMMISSIONS. THINK I HAVE ANYTHING, MR MIR? NOTHING YET. BRICK. ALL RIGHT, WELL WITH THAT WE'RE GOING TO MOVE
[EXECUTIVE SESSION]
INTO EXECUTIVE SESSION IN ACCORDANCE WITH. TEXAS GOVERNMENT CODE SECTION 55172 DELIBERATIONS ABOUT REAL PROPERTY MUNICIPAL FACILITIES SECTION 55187 DELIBERATION REGARDING ECONOMIC DEVELOPMENT MATTERS. AND I DO NOT BELIEVE BUT SECTION 55171 CONSULTATIONS WITH ATTORNEY ON ANY WORK SESSION. SPECIAL SESSION REGULAR SESSION AGENDA REQUIRING CONFIDENTIAL ATTORNEY CLIENT VICE NECESSITATED BY THE DELIBERATION AND DISCUSSION OF SAID ITEMS. AND 55187 B PROJECT HEMISPHERES. AND THERE WILL BE ONE ACTION ITEM. OF. OH, I'M SORRY. I'M SORRY. I'M SORRY. WE DID NOT YEAH, THANK YOU. IS THERE ANY ITEM ON REGULAR MEETING? COUNCIL WOULD LIKE. TO ASKED CITY STAFF AND I APOLOGIZE. EVERYONE IS HERE, READY TO ON THE READY TO JUMP UP AND ANSWER QUESTIONS. NOBODY WANTS TO TALK TO ANYONE OUT THERE SO. YOU ARE ALL FREE TO GO. SO, UM. WE'RE READY. PROVEN TO THINK WE HAVE[ACTION ON EXECUTIVE SESSION]
A MOTION. I WOULD LIKE TO MAKE A MOTION THAT WE APPROVED THE, UH, SALE AND CONTRACT ON THE WONG OF PROPERTY IN ASSOCIATION WITH THE NEW MUNICIPAL COMPLEX. SECOND. ALL IN FAVOR. I OPPOSED[00:15:05]
MY EMOTION TO A JOURNEY. SALUTE FROM FAVOR HIGH BY* This transcript was compiled from uncorrected Closed Captioning.