Antiquated Technology in the city according to Kim Nelson, when asked by councilman Tom Berry if she thinks that our computer system is antiquated, she replied “yes”. Mr. Berry went on to ask her why then would you not put together a 5 year plan for our system in the city, and submit it to us? Council Woman Horvath pointed out that the council had never asked for a study, but Berry was quick to point out that being a self-employed small business owner, you would think that you would be proactive?, Take it upon yourself to submit a plan considering we have been discussing this for over a Year. (Good for you Tom) Liz, and Janet pointed out during this exchange that they have brought Kim before them on more than one occasion, and that this has been discussed many times.
Disturbing more than this is the fact that we have equipment breaking down, and hours and hours are spent repairing it, far exceeding the cost of replacing the broken equipment. When Janet Badalow pointed out that a hard drive (on the computer in the assessor office, was bad, and had been for over a year, why was it not replaced? The cost of a new hard drive is around $100.00. Kim answered with yes it may be only $100.00, but then you have from 4 to 6 hours of time spent downloading all the needed programs to it. So let’s start there because Liz points out that the assessor’s office has around $340.00 a week in calls to IT, and in a very short time that office had $6,000.00 worth of charges from the IT. So if you have 6 hours @ 170.00=$1,020.00+100.00 for the hard drive that brings us up to $1,120.00. compare that to 6,000.00 and in one week 19 hours of downtime, with 3 people in the office not being able to work. So what is better? Janet also pointed out that the administration has no policy in place to handle things like this, and why not? Yes,Mr. Mayor, why are you not watching our money better than this? Tom said that he feels cheated, you not alone each, and every one of us should feel cheated.
Our comptroller was on hand to talk, for the life of me I would like to understand what the hell he has to do with IT, sitting there you would think he was the IT of the city, he stated that they knew her invoice was going to be pulled because of the new internet filtration that was put in the city. He said we all knew that was going to happen because all the city employees are calling all of you on the council, that is why you pulled her invoice, happens every time the Mayor said. All took issue, to that statement, if you recall her invoice was pulled because of the charges for the assessor’s department, they felt something was wrong, and they are right. Something stinks about this whole subject. Janet did ask our great comptroller, will paraphrase here she basically asked him what he has to do with this, that is a very good question wait let me see does it say any place on the web page for the comptroller that he is in charge of IT?
The Dearborn Heights Comptroller’s Office is the financial backbone of the city. In the comptroller’s office, we take care of the debits and credits of the city.
We are in charge of the following
The treasurer’s office submits a daily cash report with a cash total for each fund. We keep track of why the money has come into the city and credit the appropriate accounts.
The Comptroller’s office, through its purchasing division analyzes all invoices that come into the city and pay them from the appropriate accounts. All checks issued from the city of Dearborn Heights originate from the comptroller’s office. Each invoice is forwarded to the treasurer’s office for a final examination before it is released to the vendor.
Every item that is ordered from the city of Dearborn Heights should have a purchase order related to it. When a department needs something to help run its department, they requisition the item on a special form. When we receive the requisition form, we make sure that it has the correct vendor for the purchase and that the item being purchased is within the limits of the budget. If everything is in order, then we issue a purchase order for the item.
The city currently has approximately 320 full time employees and about 100 part time employees. The comptroller’s office is in charge of running payroll on a bi-weekly basis. We keep track of all money earned by the employee, as well as, all taxes and all other deductions for the employee. We also keep track of all time off that a full time employee takes such as sick days, vacation time, personal days, and paid holidays.
In January of each year, the comptroller’s office along with the other department, starts its general fund budgeting process. This process will request from all departments the amount of money that is needed to fulfill that departments needs for the coming fiscal year. Each department will request time with the mayor and comptrollers to review their cases on why they need the money for the budget. When all departments are reviewed by the mayor and comptroller, budget cuts start. The city of Dearborn Heights has to have a balanced budget. We check our anticipated revenues for the next fiscal year and then compare that to all the departments needs for expenditures for the next fiscal year. In the beginning, we are always out of balance and have each department review their own department and have them cut out any un-necessary items. The comptroller then re-reviews all revenues and expenditures and checks if we are in balance at that time. If we are still out of balance, the mayor and the comptroller slash the budget to get it into balance. Per city charter, this balanced budget must be submitted to the city council by April 1st of every year. At this time the city council reviews the budget again with the departments and gives their approval of the needs for the next fiscal year. Per charter, the council must adopt the city’s general fund budget by the first Monday in June of Every Year.
The comptroller’s office is a very complex piece of the city. We are the only department that does not deal with the public. We are more than an inter-departmental department. Dealing with all of the other departments.
Donald S. Barrow
Source: City of Dearborn Heights Web Site.
Nope can’t see that it says anything about being in charge of the computer system in the city. They are so concerned about the invoice being pulled, but are not concerned about the fact that employees can download what ever programs they want to city computers. He’s not concerned that our city is not operating on a unified platform. A technology assessment plan needs to be done on the city, and then they are going to take this plan and open it up for companies to bid on, it’s about time never has this gone out for bid, we have no idea what is out there.
Since council agreed that they are going to ask Plante Moran to come, and do a study I thought maybe you would like to see a study they did for the City Of Ann Arbor MI in 2006 on this very subject.
Here’s a sample of what they have in the plane,
City IT Guiding Principles
In addition to the City’s IT Strategy and Objectives, City IT projects and processes will be guided by the following fundamental guiding principles.
1. Technology-based solutions will be deployed that meet business needs, have a satisfactory return on investment and provide the best value to the City.
2. An attitude of collaboration and cooperation will be fostered among all of the jurisdictions in local, City and State government when providing services to community stakeholders to maximize the use of taxpayer dollars and provide a “seamless” interaction in receiving governmental services.
3. Business processes should be evaluated for redesign opportunities before they are automated. IT should be included as part of this redesign effort.
4. Exploit functional commonality and sharing of data across organizational boundaries when implementing new technologies and business applications and when possible, capture data once in order to avoid cost, duplication of effort and potential for error.
5. Implement contemporary, but proven, technologies.
6. Hardware and software shall adhere to best business practices and, whenever possible, open (vendor- independent) standards while minimizing proprietary solutions.
7. Technology resources will be leveraged efficiently and effectively through the adoption of common standards and shared information. Data, voice, video, image and workflow shall be standardized and interoperable between City agencies. The IT infrastructure will define the interfaces between systems.
8. Consider the purchase and integration of commercial-off-the-shelf (COTS) software with minimal customization as the first choice to speed the delivery and quality of new business software applications.
9. Information technology projects and resource allocation will be managed using standard project management tools.
10. An on-going relationship will be maintained between IT and end-user departments such that both work to identify technologies that will provide improvement in City business processes and operations.
The earliest they can meet on this subject is March 16th, and our comptroller, who had to have his say to delay this until April again I ask what he has to do with it, I’m sure Plante Moran can study other departments while he is doing other things. They do know their jobs as you can see from the study they did for Ann Arbor. Very disappointing that after one year yet more delays, they should have made the call to them today, and have them come in next week to start the study. The Mayor said that city employees where going on porno sites on city computers, ok what did you do about it, who are these employees, the way you said it Mr. Mayor you act like they are not working for you are you not the CEO of our city? If you know that for a fact why have you left them in the employment of the city? You did not say in the past you said there are employees going on porno sites, not the past. I would think that after making that statement that today you sent out pink slips, and if they are department heads that you appointed, I expect you to do no less to them.