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.
By Ajay Gajjar, CPA, CMA, CFM, CIA, CTP, CGFO
November 16, 2012
A. Energetic Reporting Program
B. Everlasting Relaxation and Peace
C. Everyone Reacts in Panic
D. Enterprise Resource Planning
Joint ERP procurement and implementation by:
City of Tampa
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
l. Instill common skill set across local government
m. Attract, develop and retain talent
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.
5-Year Cost Summary ($000) Separate billing
Wave 1 Financial, Procurement, Projects/Grants, Core HR, Business Intelligence, Reporting
Wave 2 Code Enforcement (city of Tampa only)
Wave 3 JobAps, Benefits
Wave 4 Self-Service applications, Advanced Procurement
Wave 5Time Entry, Workforce Scheduling, and Payroll
Wave 6Planning and Budgeting
-- 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.
Data conversion is difficult and expensive. How much historical data should be converted?
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.
Cost Center (Department)
Natural Account (General Ledger Account)
Sub Account (Function)
Activity (for management tracking*
Project (to assist reconciliation with 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
Oracle Insight – an Oracle program to compare metrics before and after to see measure the change brought about by the ERP system.
Ajay Gajjar Assistant Finance Director
Hillsborough County Clerk of Circuit Court
Eric Johnson Strategic Planning & ERP Implementation
Hillsborough County BOCC
J. Michael Fitzgerald, Jr. Accounting Manager
City of Tampa Accounting Office