city county joint erp implementation n.
Skip this Video
Loading SlideShow in 5 Seconds..
City/County Joint ERP Implementation PowerPoint Presentation
Download Presentation
City/County Joint ERP Implementation

Loading in 2 Seconds...

play fullscreen
1 / 43

City/County Joint ERP Implementation - PowerPoint PPT Presentation

  • Uploaded on

City/County Joint ERP Implementation. By Ajay Gajjar, CPA, CMA, CFM, CIA, CTP, CGFO November 16, 2012 . What does ERP mean?. A. Energetic Reporting Program B. Everlasting Relaxation and Peace C. Everyone Reacts in Panic D. Enterprise Resource Planning. Topics.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'City/County Joint ERP Implementation' - muriel

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
city county joint erp implementation

City/County Joint ERPImplementation

By Ajay Gajjar, CPA, CMA, CFM, CIA, CTP, CGFO

November 16, 2012

what does erp mean
What does ERP mean?

A. Energetic Reporting Program

B. Everlasting Relaxation and Peace

C. Everyone Reacts in Panic

D. Enterprise Resource Planning

  • Scope of the project
  • Benefits
  • Issues related to:

-- Procurement

-- Management

-- Accounting

scope of the erp project
Scope of the ERP Project

Joint ERP procurement and implementation by:

City of Tampa

Hillsborough County:

  • Board of County Commissioners
  • Clerk of Circuit Court / Comptroller
  • Civil Service Board
erp system goals
ERP System Goals
  • Increase efficiency
  • Improve managerial and operational effectiveness
  • Promote intergovernmental cooperation and participation
  • Reduce risk
  • Maximize human capital
erp system objectives
ERP System Objectives
  • Reduce total costs of system ownership
  • Streamline business processes through improved system integration
  • Standardize business practices across organizations
  • Promote accountability
  • Improve ability to track and measure performance
erp system objectives1
ERP System Objectives

f. Improve procurement management

g. Eliminate redundant systems

h. Protect sensitive data

i. Improve ability to adapt to changing business and technical environment

j. Reduce recovery time, if there is a disaster

k. Better receivables management

erp system objectives2
ERP System Objectives

l. Instill common skill set across local government

m. Attract, develop and retain talent

why are we doing this now
Why are we doing this now?

We currently use FAMIS, which is no longer supported.

The number of separate computer systems will increase and become entrenched if we do not go to a single ERP system.

what did we buy
What did we buy?
  • Licenses for Oracle E-Business Suite (EBS) version 12, Kronos, JobAps, and Vertex
  • AST Corporation is the system integrator consultant for implementation
  • Oracle on Demand will host the system for both the City and the County
erp contract overview
ERP Contract Overview

5-Year Cost Summary ($000) Separate billing

subledgers modules purchased
Subledgers/Modules Purchased
  • General Ledger
  • Purchasing and Inventory
  • Accounts Payable, iSupplier, and iExpense
  • Accounts Receivable
  • Cash Management and Treasury Management
  • Fixed Assets
  • Projects and Grants
  • Business Intelligence (OBIEE)
subledgers modules purchased1
Subledgers/Modules Purchased


  • Human Resources and Self Service
  • Budgeting (Hyperion)
  • Payroll (Kronos)
  • Others
project phases
Project Phases

Wave 1 Financial, Procurement, Projects/Grants, Core HR, Business Intelligence, Reporting

Wave 2 Code Enforcement (city of Tampa only)

Wave 3 JobAps, Benefits

project phases1
Project Phases

Wave 4 Self-Service applications, Advanced Procurement

Wave 5Time Entry, Workforce Scheduling, and Payroll

Wave 6Planning and Budgeting

project governance
Project Governance
  • Executive Sponsors (Elected Officials)
  • Governance Committee
  • Executive Steering Committee
  • Project Managers (Consultant, City, County)
  • Functional Leads
  • Subject Matter Experts
benefits of joint procurement and implementation
Benefits of Joint Procurement and Implementation
  • Same consulting firm handles both
  • Save about $6.6 million
benefits of joint implementation
Benefits of Joint Implementation
  • Both City and County personnel assigned – twice the involvement for a higher quality implementation
  • County and City personnel learn from each other and open up lines of communication for future collaboration.
benefits of joint implementation1
Benefits of Joint Implementation
  • Possible savings on procurements by making purchases against City contracts, and vice versa.
  • Employees would have more marketable skills and job opportunities across employers using the same system.
project infrastructure
Project “Infrastructure”
  • Joint office space set up for the project at the County
  • County network IDs assigned for e-mail and scheduler access to all members of the ERP team including the AST consultants
  • Dedicated conference rooms
  • Dedicated training rooms
project infrastructure1
Project “Infrastructure”
  • SharePoint set up for ERP for plans, documents, schedules, user guides
  • Change managers at AST, County, and City
  • Purchased Oracle books for office library
how do you set the requirements
How do you set the requirements?

-- hired a consultant to guide us through the process.

-- If the requirements are too stringent, all responses will be “nonresponsive.”

-- If the requirements are too vague, they will not be useful.

when will the core financial system go live
When will the core financial system go live?
  • Our choice: April 1, which was pushed to May 1 due to a delay in negotiating the contract.
  • Benefits: It gives us several months before the busy fiscal year-end period to work out any problems. It avoids the busy year-end period of time.
  • When Oracle upgrades are done, all modifications will need to be re-established (at a high cost in consultant or staff time).
  • We are trying to minimize the number of customizations.
  • Modifications are paid for jointly or separately depending on who benefits.
historic data
Historic Data

Data conversion is difficult and expensive. How much historical data should be converted?

  • Our decision: 2 years of historic data and the current year in detail.
  • Trying to convert data on active grants and projects (which are set up as inception-to- date).
new business processes
New Business Processes?
  • 3-way match vs. Instant 3-way match
  • Expense reports vs. iExpense
  • Journal Entries after the fact vs. time reporting
  • Cash controls vs. allocating budget by
getting information from old system
Getting Information From Old System
  • Reports from old system will be available on Spoolview (report viewing software).
  • Old system with data through April 30, 2013, will be available for viewing only until the new budget system is implemented (Wave 6).
transaction detail
Transaction Detail

System Support Department will download transaction detail, year by year, just in case the details are needed for audits by:

- Federal Emergency Management Agency

- Arbitrage audits by the Internal Revenue Service,

- Grant audits by state or federal grantors.

superusers training
Superusers & Training
  • What “superusers” do and why is it important to identify them early in the process?
  • How will training be handled during and after implementation of all ERP waves?
getting staff involvement
Getting Staff Involvement
  • Joint City/County meetings on requirements
  • Joint City/County demonstrations by potential vendors
  • Meetings early in the process to discuss “pain points” associated with the old systems
why do we need change management
Why do we need Change Management?
  • We overestimate the disadvantages of change and underestimate the advantages of change.
  • Adapting to change is difficult. Some people fear losing their jobs to “automation.”
  • Some sharing between City/County/AST Change managers
general ledger objectives
General Ledger Objectives
  • Meets statutory reporting needs
  • Meets management reporting needs
  • As simple as possible
  • Room for growth and additional entities
  • BOCC and Clerk share General Ledger
    • For example, natural accounts are shared
accounting segments general ledger
Accounting Segments – General Ledger


Cost Center (Department)

Natural Account (General Ledger Account)

Sub Account (Function)

Activity (for management tracking*

Project (to assist reconciliation with subledger)


accounting segments projects and grants subledger
Accounting Segments – Projects and Grants Subledger

P - Project number for grants and capital projects

O - Organization (i.e. department)

E - Expenditure natural account

T - Task, a subdivision of a project

A - Award, the funding source for a grant or capital project

capitalization of erp costs
Capitalization of ERP Costs
  • Capitalize internally generated software such as actual programming work.
  • We capitalize the ERP Director’s time, the salary cost of the consultant hired as the County’s project manager, and the cost of AST system integrator.
shared vendor file
Shared Vendor File
  • The same vendor file will be used for the City and County. But the vendor may be 1099 reportable at one entity and not the other.
  • Solution: Use a code to distinguish City and County vendors, but use the same file. And possibly vendor maintenance by one area for both entities.
how do you know if the conversion was successful
How do you know if the conversion was successful?

Oracle Insight – an Oracle program to compare metrics before and after to see measure the change brought about by the ERP system.

other governments with erp systems
Other Governments With ERP Systems
  • City of St. Petersburg, FL (Oracle)
  • Polk County, FL (Oracle)
  • Pinellas County, FL (Oracle)
  • Loudoun County/Loudoun County School Board (Oracle)
hillsborough county contacts
Hillsborough County Contacts

Ajay Gajjar Assistant Finance Director

Hillsborough County Clerk of Circuit Court


Eric Johnson Strategic Planning & ERP Implementation

Hillsborough County BOCC


city of tampa contact
City of Tampa Contact

J. Michael Fitzgerald, Jr. Accounting Manager

City of Tampa Accounting Office