---

 [ ARCHIVE ](https://ded2209.inmotionhosting.com/~citywa9/archive)

#  About Time: A Data Wonk as LA Controller

July 25 2013

Written by Paul Hatfield.

<a class="a2a_button_facebook"></a><a class="a2a_button_twitter"></a><a class="a2a_button_email"></a><a class="a2a_button_print"></a>[](https://www.addtoany.com/share)

![](https://ded2209.inmotionhosting.com/~citywa9/images/stories/July-2013/cw11060b.png)PERSPECTIVE - Ron Galperin’s statements in his interview with the Jewish Journal is nothing short of encouraging.

[According to the article](http://www.jewishjournal.com/bill_boyarsky/article/ron_galperin_backs_big_data_to_improve_city_hall), he wants to introduce the city’s bureaucracy to “big data.” That’s not the name of some character from The Sopranos.

Multi-billion dollar corporations could not survive without systems capable of crunching countless transactions while slicing and dicing them into meaningful information. Analysts and investors would be lost without timely reports that suggest trends in individual companies or entire industries.

Yet, the City of Los Angeles manages its finances from hand to mouth. Why else do deficit projections and cash flow forecasts jump around by hundreds of millions of dollars in a few short weeks? Why does it take the City Controller’s Office almost a year to publish audited financial statements?

It hasn’t helped that we have lacked a true controller since computer systems became the standard for financial reporting and analysis.

It goes beyond just having a system in place. The main system must be integrated with other information modules in a way that allows data to flow to and from with little or no time-consuming manual intervention. Manual transfers of data can also lead to higher error rates or lost detail.

The users of the systems are critical, too. Managers and staff charged with the responsibility of reconciling and reporting have to be savvy when it comes to extracting information and using it to guide them.

The Controller also must insist on regular variance reporting from the general managers. Variance reports compare actual performance against budgets or other metrics. They are the key to making timely adjustments in operations.

I hope Mayor Garcetti considers the financial acumen of the general managers when he makes them interview for their jobs. That would make Galperin’s job a little easier – and he has a huge challenge in front of him.

Selecting new systems, enhancing existing ones, developing processes that support the timely flow and exchange of information in an environment that still operates in the Mid-20th Century will require the vast portion of his department’s time.

But Ron has enough wonkiness in him – and the personality and professionalism to complement it – to make it happen.

*(Paul Hatfield is a CPA and serves as Treasurer for the Neighborhood Council Valley Village. He blogs at Village to Village, contributes to CityWatch and can be reached at: <phinnoho@aol.com>)* –cw

CityWatch

Vol 11 Issue 60

Pub: July 26, 2013

 [ ![Brian Goldsmith Vertical R. Col](https://ded2209.inmotionhosting.com/~citywa9/images/ADS%20FOR%202026/brian-goldsmith%20AD.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/115 "Brian Goldsmith Vertical R. Col")

 [ ![save up to 4000 on used evs](https://ded2209.inmotionhosting.com/~citywa9/images/LADWP/dwp%20ev%20ad2.png) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/107 "LA DWP | Save $4K, Green | Priority Ad")

 [ ![McKinney Campaign](https://ded2209.inmotionhosting.com/~citywa9/images/ADS%20FOR%202026/McKinney%20City%20Watch%20Ad_final.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/114 "McKinney Campaign")

 [ ![LA DWP #2 (Power Savers)](https://ded2209.inmotionhosting.com/~citywa9/images/LADWP/2026%20LADWP%20PowerSavers%20300x250.png) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/82 "LA DWP #2 (Power Savers)")

 [ ![Donna Tryfman](https://ded2209.inmotionhosting.com/~citywa9/images/ADS%20FOR%202026/Donna-Tryfman-Ad-Final-Complete-Border-White-Margin.png) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/98 "Donna Tryfman - HS1-1")

 [ ![Pay Water Bill Help](https://ded2209.inmotionhosting.com/~citywa9/images/LADWP/dwp%20-%20cares-ad.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/97 "Home - LA DWP #2 (Pay Water Bill Help)")

 [ ![David DeJute Campaign](https://ded2209.inmotionhosting.com/~citywa9/images/ADS%20FOR%202026/DejuteAd.png) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/111 "David DeJute Campaign")

 [ ![Anna Reitano Vertical R. Col](https://ded2209.inmotionhosting.com/~citywa9/images/ADS%20FOR%202026/reitano%20vertical%20rework.png) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/112 "Anna Reitano Vertical R. Col")

 ![](https://ded2209.inmotionhosting.com/~citywa9/images/banners/signup-for-cw.png)

## Get The News In Your Email Inbox Mondays & Thursdays

 Message

 [ ![Rhonda Haymon](https://ded2209.inmotionhosting.com/~citywa9/images/ADS%20FOR%202026/rhonda%20haymon%20for%20judge.png) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/113 "Rhonda Haymon campaign")

 [ ![something you should know, podcasts](https://ded2209.inmotionhosting.com/~citywa9/images/banners/something%20you%20should%20know2.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/component/banners/click/110 "Something You Should Know")

 ---

##  Featured CityWatch Stories

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/96/086d-96c5ee15.png) ](https://ded2209.inmotionhosting.com/~citywa9/election-2024/33624-prosecutor-democrat-city-attorney-mckinney-makes-his-case-to-los-angeles-voters)

### [Prosecutor, Democrat, City Attorney? McKinney Makes His Case to Los Angeles Voters](https://ded2209.inmotionhosting.com/~citywa9/election-2024/33624-prosecutor-democrat-city-attorney-mckinney-makes-his-case-to-los-angeles-voters)

ELECTION 2026 - The race for LA City Attorney has been laced with political accusations and allegations that when close…

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/ef/083a-eff2fa50.png) ](https://ded2209.inmotionhosting.com/~citywa9/la-watchdog/33544-the-la-watchdogs-2026-voters-guide-2)

### [The LA Watchdog’s 2026 Voter Guide](https://ded2209.inmotionhosting.com/~citywa9/la-watchdog/33544-the-la-watchdogs-2026-voters-guide-2)

LA WATCHDOG - My recommendations are influenced by the need for truly balanced budgets, fiscal responsibility, long ter…

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/2f/086g-2fe97089.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/los-angeles/33626-the-fools-blame-game)

### [The Fools’ Blame Game](https://ded2209.inmotionhosting.com/~citywa9/los-angeles/33626-the-fools-blame-game)

THE VIEW FROM HERE - Angelenos do not use elections to plot a wiser course of conduct for Los Angeles, but rather they…

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/cb/086f-cb06a60b.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/los-angeles/33619-california-film-tax-credits-arent-enough-the-guilds-need-to-change-too)

### [California Film Tax Credits Aren’t Enough. The Guilds Need to Change Too.](https://ded2209.inmotionhosting.com/~citywa9/los-angeles/33619-california-film-tax-credits-arent-enough-the-guilds-need-to-change-too)

LONNIE’S VIEW - California used to be the center of the movie and television universe. If you wanted to make movies, yo…

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/bc/087l-bc8ba04f.jpg) ](https://ded2209.inmotionhosting.com/~citywa9/voices/33648-heres-what-zionisms-got-to-do-with-it)

### [Here’s What Zionism’s Got To Do With It](https://ded2209.inmotionhosting.com/~citywa9/voices/33648-heres-what-zionisms-got-to-do-with-it)

ICAN - The anonymous website “BHUSD Watch” recently published a long, detailed article about the current BHUSD board an…

---

##  [ ARCHIVE ](https://ded2209.inmotionhosting.com/~citywa9/archive)

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/d4/034e-d424a385.png) ](https://ded2209.inmotionhosting.com/~citywa9/archive/15339-early-intervention-and-jobs-are-key-to-stemming-chronic-homelessness-in-los-angeles)### [Early Intervention and Jobs are Key to Stemming Chronic Homelessness in Los Angeles](https://ded2209.inmotionhosting.com/~citywa9/archive/15339-early-intervention-and-jobs-are-key-to-stemming-chronic-homelessness-in-los-angeles)

### [Tucker Carlson and Gay Rightwinger Blame California Wildfires On Hiring LGBTQ People](https://ded2209.inmotionhosting.com/~citywa9/archive/18755-tucker-carlson-and-gay-rightwinger-blame-california-wildfires-on-hiring-lgbtq-people)

### [Anti-LGBTQ Veep Just Can’t Stop Talking about Mayor Pete](https://ded2209.inmotionhosting.com/~citywa9/archive/17690-anti-lgbtq-veep-just-can-t-stop-talking-about-mayor-pete)

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/26/033j-26aa2dd8.png) ](https://ded2209.inmotionhosting.com/~citywa9/archive/15316-news-pulse-corrupt-system-reason-for-not-voting-in-2018-majority-wants-more-than-two-parties)### [NEWS PULSE: ‘Corrupt System’ Reason for Not Voting in 2018 … Majority Wants More Than Two Parties](https://ded2209.inmotionhosting.com/~citywa9/archive/15316-news-pulse-corrupt-system-reason-for-not-voting-in-2018-majority-wants-more-than-two-parties)

 [ ![](https://ded2209.inmotionhosting.com/~citywa9/media/yootheme/cache/08/1404d-08c93632.png) ](https://ded2209.inmotionhosting.com/~citywa9/archive/10245-dead-dog-set-on-fire-sparks-fears-for-strays-in-los-angeles)### [Dead Dog Set on Fire … Sparks Fears for Strays in Los Angeles](https://ded2209.inmotionhosting.com/~citywa9/archive/10245-dead-dog-set-on-fire-sparks-fears-for-strays-in-los-angeles)
