Study guide
26.2 Development Methodologies: Waterfall vs. Agile
Certified Government Financial Manager CGFM
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Organization, Authority and Structure of Government — Part I
1.1 Levels, Branches, and Separation of Powers 1.2 Components of Government & Public Authorities 1.3 Subnational Governments: General-Purpose vs. Special-Purpose
2 Chapter 2: Organization, Authority and Structure of Government — Part II
2.1 Legal Authority, Charters, and Sovereign Powers 2.2 Tribal Sovereignty & Intergovernmental Relations 2.3 Categorical Grants vs. Block Grants
3 Chapter 3: The Government Financial Management Cycle & Legal Framework — Part I
3.1 The Seven Phases of the Financial Management Cycle 3.2 The Closed-Loop Feedback Architecture 3.3 The Constitutional Basis: The Power of the Purse
4 Chapter 4: The Government Financial Management Cycle & Legal Framework — Part II
4.1 Types of Legislative Appropriations 4.2 The Hierarchy of Budgetary Spending Controls 4.3 Legal Mechanisms Dedicating Public Revenues
5 Chapter 5: Government Revenues, Grants & Debt Financing — Part I
5.1 Public Tax Policy and Tax Structures 5.2 Wealth and Property Taxes 5.3 Intergovernmental Grants & the Uniform Guidance Lifecycle 5.4 The OMB Uniform Guidance Grant Lifecycle (2 CFR 200)
6 Chapter 6: Government Revenues, Grants & Debt Financing — Part II
6.1 User Charges, Cost Recovery, Leases & Public-Private Partnerships 6.2 Public Debt Issuance, Bond Types & Credit Ratings 6.3 Certificates of Participation (COPs) and Lease-Revenue Bonds
7 Chapter 7: Public Accountability, Transparency & Open Government — Part I
7.1 Legislative Frameworks for Accountability: IG Act & CFO Act 7.2 Government Management Reform Act (GMRA) of 1994 7.3 Assessing Fiscal Sustainability, Solvency & SEA Reporting
8 Chapter 8: Public Accountability, Transparency & Open Government — Part II
8.1 Net Pension Liability (NPL) Recognition 8.2 Open Government, DATA Act of 2014 & Citizen-Centric Reporting 8.3 Digital Open Checkbooks
9 Chapter 9: Public Sector Ethics & Digital Government — Part I
9.1 Public Service Ethics Principles & the AGA Code of Ethics 9.2 The Ethical Spectrum: The Ethical Floor vs. The Ethical Ceiling 9.3 Managing Conflicts of Interest, Due Care, Whistleblowing & Nepotism
10 Chapter 10: Public Sector Ethics & Digital Government — Part II
10.1 Post-Employment "Revolving Door" Prohibitions (18 U.S.C. § 207) 10.2 E-Government Services, Public Portals & NIST Cybersecurity Standards 10.3 Personally Identifiable Information (PII)
11 Chapter 11: Governmental Accounting Principles & Cost Allocation — Part I
11.1 Environmental Differences, Standard Setters & GAAP Hierarchies 11.2 Standard-Setting Bodies and Jurisdictional Framework 11.3 State and Local GAAP Hierarchy: GASB Statement No. 76 11.4 Measurement Focus, Basis of Accounting & Nonexchange Transactions
12 Chapter 12: Governmental Accounting Principles & Cost Allocation — Part II
12.1 The Four GASB Statement No. 33 Nonexchange Categories 12.2 Managerial Cost Accounting, SFFAS 4 & Intergovernmental Fee Establishment 12.3 Cost Allocation under OMB Uniform Guidance (2 CFR 200 Subpart E)
13 Chapter 13: Public Budgeting Concepts & Controls — Part I
13.1 Public Budget Formulation, Structures & Budgeting Approaches 13.2 Fund 13.3 Performance-Based Budgeting (PBB) 13.4 Capital Project Financing, Capital Budgets & Revenue/Expenditure Forecasting
14 Chapter 14: Public Budgeting Concepts & Controls — Part II
14.1 Public-Private Partnerships (P3s) 14.2 Budgetary Control Techniques & General Ledger Accounting Operations 14.3 Stock Statements vs. Flow Statements
15 Chapter 15: State & Local Fund Accounting & Budgetary Accounting — Part I
15.1 The Eleven State & Local Fund Types & Accounting Bases 15.2 Capital Projects Funds (CPF) 15.3 Custodial Funds 15.4 Modified Accrual Accounting: Revenues, Expenditures & Financing Sources
16 Chapter 16: State & Local Fund Accounting & Budgetary Accounting — Part II
16.1 Other Financing Sources (OFS) and Other Financing Uses (OFU) 16.2 Budgetary Integration, Encumbrance Entries & GASB 54 Fund Balance Classifications 16.3 Nonspendable Fund Balance
17 Chapter 17: State & Local Financial Reporting & Statements — Part I
17.1 Defining the State & Local Reporting Entity & Component Units 17.2 Pathway 3: Misleading to Exclude & Affiliated Organizations (GASB 39 & 90) 17.3 Joint Ventures 17.4 The Annual Comprehensive Financial Report (ACFR) Structure & RSI
18 Chapter 18: State & Local Financial Reporting & Statements — Part II
18.1 Required Supplementary Information (RSI Other than MD&A) 18.2 Government-Wide Financial Statements, Interfund Eliminations & Reconciliation 18.3 Internal Balances (Due To / Due From)
19 Chapter 19: Federal Budgetary Accounting & the USSGL — Part I
19.1 Federal Accounting Governance: FASAB, OMB, Treasury & GAO 19.2 Comparative Analysis: The Quadripartite Leadership 19.3 Federal Budgetary Terminology, the Budgetary Equation & Fund Types
20 Chapter 20: Federal Budgetary Accounting & the USSGL — Part II
20.1 General Fund of the United States Government 20.2 The U.S. Standard General Ledger (USSGL) & Dual-Track Budgetary Accounting 20.3 Milestone 2: OMB Apportionment (Form SF 132)
21 Chapter 21: Federal Proprietary Accounting & Financial Reporting — Part I
21.1 Federal Proprietary Accounting & Fund Balance with Treasury (FBWT) 21.2 Non-FBWT Budgetary Authority (Offsets) 21.3 Stewardship PP&E: Heritage Assets and Stewardship Land (SFFAS 29) 21.4 Federal Credit Reform Act (FCRA): Direct Loans, Loan Guarantees & Subsidy Accounting
22 Chapter 22: Federal Proprietary Accounting & Financial Reporting — Part II
22.1 The Liquidating Account (Budgetary - Pre-1992) 22.2 Federal Financial Reporting: AFR, PAR, Basic Financial Statements & the U.S. Consolidated Report 22.3 The Statement of Changes in Net Position (SCNP)
23 Chapter 23: Cash, Investment & Debt Operations — Part I
23.1 Government Cash Management, Collections, Lockboxes & Banking Controls 23.2 Fees vs. Compensating Balances: Strategic Analysis 23.3 Public Investment Policies, Safety-Liquidity-Yield, Prudent Person Rule & Risk Disclosures 23.4 Authorized Public Investment Instruments: Comparative Analysis
24 Chapter 24: Cash, Investment & Debt Operations — Part II
24.1 GASB Statement No. 40: Deposit and Investment Risk Disclosures 24.2 Electronic Payments, EFT, P-Cards & Disbursement Controls 24.3 Public Benefit Disbursements: EBT and Reloadable Debit Cards
25 Chapter 25: Procurement, Asset Stewardship & Operational Systems — Part I
25.1 Public Procurement Standards, Fair Competition & Contract Administration 25.2 Contract Types and Cost Risk Allocation 25.3 Capital Asset Stewardship, Property Disposal, Inventory & OM&S Controls 25.4 Environmental Compliance and Electronic Data Sanitization
26 Chapter 26: Procurement, Asset Stewardship & Operational Systems — Part II
26.1 Financial Management Information Systems (FMIS), ERP, Cloud Hosting & Automation 26.2 Development Methodologies: Waterfall vs. Agile 26.3 Shared Services Delivery & Public Sector Project Management 26.4 The PMBOK Five Process Groups
27 Chapter 27: Financial, Managerial & Forensic Analysis — Part I
27.1 Mathematical and Financial Foundations of Time Value of Money (TVM) 27.2 Internal Rate of Return (IRR) 27.3 Financial Statement Trend and Comparative Analysis
28 Chapter 28: Financial, Managerial & Forensic Analysis — Part II
28.1 Earned Value Management (EVM) for Capital Project Oversight 28.2 Public Sector Data Sources and Reliability Verification 28.3 Common Red Flags and Public Sector Fraud Schemes
29 Chapter 29: Internal Control Frameworks & Enterprise Risk Management — Part I
29.1 COSO Internal Control Integrated Framework & the GAO Green Book 29.2 Component 2: Risk Assessment 29.3 Internal Control Deficiencies, Corrective Action Plans & Management Reporting
30 Chapter 30: Internal Control Frameworks & Enterprise Risk Management — Part II
30.1 FMFIA Reporting Sections 30.2 Enterprise Risk Management (ERM) & OMB Circular A-123 Implementation 30.3 Core Elements of a Federal Risk Profile
31 Chapter 31: Performance Measurement, Government Auditing & the Single Audit — Part I
31.1 Performance Measurement, SEA Reporting, GPRA & Public Accountability 31.2 Baselines, Targets, Benchmarking, and Stakeholder Engagement 31.3 Government Auditing Standards: The Yellow Book & Auditor Independence 31.4 Quality Management and External Peer Review
32 Chapter 32: Performance Measurement, Government Auditing & the Single Audit — Part II
32.1 Performance Audit Fieldwork, Reporting & Auditee Responsibilities 32.2 Cause ("Why It Happened") 32.3 The Single Audit Act & Uniform Guidance (2 CFR 200 Subpart F) 32.4 Internal Control over Compliance Testing
26.2 Development Methodologies: Waterfall vs. Agile
Key Takeaways Explain This Topic AI
Federal agency cloud services within FedRAMP scope must use an authorized baseline selected through the federal risk-categorization process; state and local entities follow their own applicable security and contracting rules. Master Data Management, RPA, and anomaly detection can support control objectives when governed and monitored appropriately.
System implementation strategies range from traditional Waterfall to Agile sprints, while cutover strategies evaluate risks across Big Bang (highest risk), Parallel Operations (safest and most labor-intensive), and Phased Rollouts.
System requirements analysis must define functional requirements (fund accounting, dual-track budgetary/proprietary entries, prompt payment rules), technical requirements (RTO/RPO disaster recovery), interfaces (banking APIs), and security controls (RBAC, least privilege, Segregation of Duties).
Last updated: September 2026
Development Methodologies: Waterfall vs. Agile
Traditional Waterfall Model : A sequential, linear methodology where each phase (Requirements, Design, Development, Testing, Deployment) must be 100% complete and signed off before the next phase begins. Highly structured and documentation-heavy; however, it is rigid, resistant to changing regulations, and risks catastrophic late-stage project failure if requirements were misunderstood.
Agile Methodologies (Scrum / Sprints) : An iterative, incremental approach where development is delivered in short, two-to-four-week "sprints." Functional software increments are demonstrated to end-users continuously, allowing regular feedback, adaptive prioritization, and early risk detection. Modern public sector ERP implementations increasingly adopt hybrid models combining rigid waterfall governance for compliance baselines with agile configuration sprints.
Testing Protocols
Unit Testing : Software developers test isolated code routines, custom scripts, and specific database fields to ensure they execute accurately.
System Integration Testing (SIT) : Comprehensive testing verifying that data flows seamlessly across interconnected modules and external interfaces (e.g., verifying that a payroll run accurately posts liability entries to the core GL and generates a valid NACHA direct deposit file for the banking interface).
User Acceptance Testing (UAT) : Business end-users—finance clerks, budget analysts, payroll specialists, and purchasing agents—execute structured test scripts simulating full, real-world business scenarios. UAT represents the formal contractual gate: the system cannot be launched into production until business leadership certifies UAT completion .
Deployment and Cutover Strategies
The transition from the legacy software to the new FMIS can be executed using three primary strategies:
Big Bang Cutover : The entire legacy system is decommissioned on a single calendar date (typically the first day of a new fiscal year), and 100% of operations immediately transition to the new FMIS. While Big Bang minimizes operational duration and eliminates double-entry costs, it carries the highest operational risk ; any critical system defect can paralyze civic payroll or disbursements.
Parallel Operations : The legacy system and the new FMIS run simultaneously for one or two full accounting cycles (e.g., 30 to 60 days). Staff process every transaction in both systems, and financial outputs are cross-reconciled daily. Parallel operations provide the maximum safety and lowest operational risk , but require substantial overtime, dual data entry, and significant personnel costs.
Phased Rollout : Modules or departments are transitioned sequentially in planned phases (e.g., Phase 1: Core GL, Budget, and AP; Phase 2: Purchasing and Assets; Phase 3: Payroll and HR). Phased rollouts mitigate institutional risk and spread training burdens, but require temporary interfaces between the new ERP modules and legacy systems.
Hosting Architectures: On-Premise, Cloud & FedRAMP Governance
Public sector entities are increasingly migrating financial systems from agency-owned data centers to secure cloud environments.
Cloud Service Models (NIST SP 800-145)
Infrastructure as a Service (IaaS) : The cloud vendor provides raw computing infrastructure—virtual servers, network storage, and firewalls. The government agency installs, manages, and secures the operating system, database software, ERP application, and data.
Platform as a Service (PaaS) : The cloud vendor provides and manages the underlying hardware, operating systems, and database engines. The government agency develops, runs, and manages custom software applications and data.
Software as a Service (SaaS) : The cloud vendor provides, maintains, and secures the entire application stack—from physical data centers to the financial software itself. Government users access the FMIS via secure web browsers or encrypted APIs. The agency manages only its data and user access permissions. +---------------------------------------------------------------------------------------------------+
- | CLOUD SERVICE MODEL RESPONSIBILITY MATRIX |
- +------------------------------------+------------------+-------------------+-----------------------+
- | TECHNOLOGY LAYER | IaaS | PaaS | SaaS |
- +------------------------------------+------------------+-------------------+-----------------------+
- | Application Software (FMIS / ERP) | Customer Agency | Customer Agency | CLOUD PROVIDER |
- | Data & User Access Control | Customer Agency | Customer Agency | Customer Agency |
- | Runtime & Database Engine | Customer Agency | CLOUD PROVIDER | CLOUD PROVIDER |
- | Operating System (OS) | Customer Agency | CLOUD PROVIDER | CLOUD PROVIDER |
- | Virtualization & Hypervisor | CLOUD PROVIDER | CLOUD PROVIDER | CLOUD PROVIDER |
- | Physical Servers, Storage, Network| CLOUD PROVIDER | CLOUD PROVIDER | CLOUD PROVIDER |
- +------------------------------------+------------------+-------------------+-----------------------+
- FedRAMP Authorization Standards
Federal agencies migrating financial systems to the cloud are legally mandated to select cloud service providers authorized under the Federal Risk and Authorization Management Program (FedRAMP) . FedRAMP provides a standardized, government-wide approach to security assessment, authorization, and continuous monitoring of cloud products based on NIST SP 800-53 controls:
FedRAMP Low Baseline : Suitable for low-impact public data with minimal confidentiality risks (125 security controls).
FedRAMP Moderate Baseline : Covers the vast majority of federal cloud systems (~80%), protecting Controlled Unclassified Information (CUI) , personally identifiable information (PII), and routine operational financial transactions (325 security controls).
FedRAMP High Baseline : Required for mission-critical, highly sensitive financial systems, healthcare records, law enforcement data, and critical economic infrastructure where system compromise could result in catastrophic financial or operational collapse (421 security controls).
Data Governance, Quality and Master Data Management (MDM)
A financial management information system is only as reliable as the underlying data it processes. Flawed data leads to improper vendor payments, misleading budgetary reports, and failed financial statement audits.
Data Governance Frameworks
Data governance establishes the institutional structures, policies, and responsibilities governing civic data assets:
Data Stewards : Designated senior operational managers responsible for defining data standards, monitoring data quality, and approving modifications to core financial tables within their functional domains (e.g., Purchasing Director as Vendor Data Steward; Comptroller as Chart of Accounts Data Steward).
Data Dictionaries : Comprehensive catalogs defining every data element, naming convention, field length, permissible values, and business validation rules utilized across enterprise systems.
Master Data Management (MDM)
Master Data Management (MDM) represents the discipline of creating and maintaining a single, consistent, authoritative "Golden Record" for core enterprise entities across all governmental applications:
Central Vendor Master : Eliminating duplicate vendor files (e.g., "Acme Inc.," "Acme Supply Corp.," and "Acme Incorporated"). Duplicate vendor files are the primary cause of inadvertent duplicate payments and represent a major fraud vulnerability for ghost-vendor schemes.
Chart of Accounts (COA) Master : A standardized, multi-segment accounting classification code (Fund, Sub-Fund, Department, Program, Project, Object Class) enforced across all agencies to ensure uniform reporting.
Emerging Technical Automation: RPA, Machine Learning & AI
Public financial management is undergoing a profound transformation driven by advanced software automation and artificial intelligence.
Robotic Process Automation (RPA)
Robotic Process Automation (RPA) utilizes configured software "bots" to execute high-volume, rules-based, repetitive clerical tasks across user interfaces without altering underlying database architectures:
Typical Financial RPA Applications : (1) Logging into commercial bank portals daily to download electronic statements and format them for automated reconciliation; (2) Extracting standard data from PDF vendor invoices and populating AP voucher fields; (3) Querying state tax licensing databases to verify vendor compliance prior to payment release; and (4) Executing routine monthly billing runs for municipal utilities.
Operational Benefits : RPA bots operate 24/7/365 with zero transcription error, dramatically accelerate transaction processing speeds, and liberate certified finance staff from routine clerical burdens to focus on complex analytical tasks and internal controls.
Machine Learning (ML) and Artificial Intelligence (AI)
Unlike rules-based RPA, Machine Learning (ML) algorithms analyze massive transaction datasets to detect subtle patterns, trends, and anomalies:
Fraud and Anomaly Detection : Unsupervised machine learning models ingest hundreds of thousands of expenditure records, evaluating multi-variable anomalies to identify suspicious transactions in real time: unusual weekend payment batches, sudden alterations to vendor direct-deposit bank routing numbers, split purchases designed to evade thresholds, and matching invoices across unrelated vendors.
Predictive Expenditure and Revenue Forecasting : ML models combine historical tax receipts, inflation indices, weather patterns, and regional economic data to generate highly accurate predictive cash flow and revenue forecasts.
Business Intelligence (BI) and Analytical Dashboards
Modern ERPs interface with dynamic Business Intelligence (BI) visualization platforms, replacing static monthly paper reports with interactive, real-time executive dashboards:
Finance directors and city managers monitor live budgetary execution, track department burn rates, evaluate vendor prompt-payment compliance, and detect cash positioning bottlenecks through drill-down graphical interfaces accessible on desktop and mobile devices.
Practical Public Finance Scenario: State Agency FMIS Modernization and Cloud Migration
Scenario : The State Department of Administration is executing a multi-year project to replace its 28-year-old COBOL-based mainframe accounting system with a modern, cloud-hosted SaaS ERP solution serving 42 state agencies with an annual operating budget of $18,000,000,000. During the implementation, the project steering committee encounters several critical operational challenges:
Several state agency heads demand that the ERP vendor write custom code modules replicating their existing, 40-step paper approval workflows for purchase orders, claiming their agencies have "unique statutory cultures."
The project director proposes executing a "Big Bang" cutover on October 1, completely severing the legacy mainframe overnight to avoid the $1,200,000 cost of running parallel operations.
The cloud hosting vendor proposes hosting the state's financial, tax, and social services disbursement databases in a commercial cloud environment with a "FedRAMP Low" equivalency certification to minimize monthly subscription costs.
Legacy vendor data conversion reveals over 450,000 vendor records, including thousands of inactive records dating back to 1998, multiple entries for identical commercial vendors with different addresses, and missing taxpayer identification numbers (TINs).
Strategic Corrective Decisions by the Steering Committee
Enforce Business Process Re-engineering (BPR) Over Customization :
Decision : Reject the demands for custom code replication. Writing custom code to mimic obsolete 40-step paper approvals recreates legacy inefficiencies, escalates implementation costs, and jeopardizes future vendor software updates.
Directive : Require all 42 agencies to participate in mandatory BPR workshops to adopt standard COTS best-practice electronic workflows, collapsing approval chains to a maximum of three risk-based electronic authorization tiers.
Reject Big Bang Cutover in Favor of Parallel Operations :
Decision : Overrule the project director's proposed Big Bang cutover. On an $18 billion enterprise system serving critical public functions (state payroll, medicaid disbursements, vendor payments), a Big Bang failure would cause catastrophic civic disruption.
Directive : Authorize the $1,200,000 investment to execute a minimum 30-day Parallel Operations cutover, reconciling daily GL trial balances, payroll batches, and warrants between the mainframe and the new SaaS ERP until zero material variance is certified.
Mandate FedRAMP Moderate / High Compliance :
Decision : Formally reject the vendor's "FedRAMP Low" proposal. State financial systems process Controlled Unclassified Information (CUI), bank account numbers, citizen PII, and billions in cash distributions.
Directive : Contractually mandate that the cloud ERP be hosted in a certified FedRAMP Moderate (or FedRAMP High) government cloud environment meeting NIST SP 800-53 controls with continuous third-party vulnerability monitoring.
Execute Comprehensive Master Data Cleansing :
Decision : Prohibit migrating raw legacy vendor tables into the new ERP.
Directive : Establish a Master Data Management (MDM) protocol: deactivate all vendors with zero activity in the preceding five years, merge duplicate entities into a single Golden Record, and mandate automated TIN verification via IRS bulk matching before activating records in the new Vendor Master.