Attachment A
Finance and Management Committee
October 13, 2026
Consulting services to be provided by Mythics, LLC D/B/A Mythics, VIII, LLC
1. Oracle HRMS/Payroll Configuration and Support
• Configure and maintain Oracle HRMS, Payroll, Benefits, Time & Labor, and related modules to support changes in labor agreements, compensation, benefits, leave programs, taxation, and City policies.
• Develop and modify payroll elements, deductions, accruals, Fast Formulas, balances, and related configurations.
• Review, test, and validate system changes to ensure accurate payroll processing and compliance with business requirements.
2. Technical Development and System Integration
• Develop, maintain, and troubleshoot Oracle EBS customizations, interfaces, reports, PL/SQL programs, Fast Formulas, and related technical components. • Support integrations between Oracle HRMS/Payroll and City financial, timekeeping, banking, retirement, benefits, and third-party systems. • Analyze and remediate issues related to customizations, Oracle patches, data integrity, system dependencies, and legacy development.
3. Complex Payroll Processing and Compliance
• Provide expertise supporting FLSA compliance, overtime calculations, alternate work schedules, blended rates, multiple assignments, retroactive payments, and other complex payroll requirements.
• Develop, test, and maintain payroll configurations and Fast Formulas supporting City compensation rules and regulatory requirements.
• Validate payroll outcomes through comprehensive testing and analysis.
4. Legislative and Regulatory Changes
• Assess and implement payroll-related requirements resulting from federal, state, and local legislation, including the One Big Beautiful Bill Act (OBBBA). • Modify payroll configurations, formulas, deductions, reporting, and related processes to ensure compliance with evolving requirements.
• Perform testing and provide ongoing support as regulatory guidance changes.
5. Labor Agreement and MOU Implementation
Attachment A
Finance and Management Committee
October 13, 2026
• Analyze, configure, test, and implement provisions resulting from newly negotiated MOUs and labor agreements.
• Support bargaining unit changes affecting compensation, benefits, retirement contributions, leave accruals, differentials, premiums, and other payroll components. • Implement updates to medical contributions, CalPERS reporting, retirement deductions, and other negotiated provisions.
• Support retroactive calculations, settlements, and payroll adjustments associated with contract changes.
6. Retroactive Payroll Functionality
• Design, configure, and implement retroactive payroll functionality and related processing rules.
• Assess impacts to payroll balances, deductions, taxes, costing, interfaces, and employee records.
• Develop and execute testing scenarios to ensure accurate processing across multiple pay periods and compensation scenarios.
7. Testing and Quality Assurance
• Perform functional, technical, regression, and parallel testing for payroll, HRMS, interfaces, patches, legislative changes, system enhancements, and labor agreement updates.
• Identify and resolve issues prior to production deployment to minimize operational risk.
8. Oracle Patch Management
• Support the City's quarterly Oracle patching cycle, including impact analysis, testing, validation, troubleshooting, and post-production support. • Evaluate impacts to customizations, integrations, payroll processing, and related Oracle modules.
9. Customization Remediation
• Review and correct legacy customizations, interfaces, reports, Fast Formulas, and technical components that are no longer functioning as intended. • Evaluate opportunities to replace unsupported customizations with standard Oracle functionality where feasible.
10. Critical Production Support
• Provide rapid response and resolution for critical payroll, personnel, and Oracle production issues.
Attachment A
Finance and Management Committee
October 13, 2026
• Perform root-cause analysis and implement corrective actions while minimizing disruption to City operations and payroll processing.
11. Knowledge Transfer and Documentation
• Provide documentation, knowledge transfer, and cross-training to City Finance, HRMS, Payroll, and ITD staff.
• Document system configurations, customizations, interfaces, business processes, and troubleshooting procedures to reduce reliance on specialized institutional knowledge.