Get in Touch

Course Outline

Ticketing System Data Sovereignty

  • Evaluation of cloud-hosted helpdesk solutions regarding the protection of constituent interactions and metadata.
  • Technical architecture overview: Ruby on Rails, PostgreSQL, Redis, and Elasticsearch components.
  • Comparative analysis with osTicket, Request Tracker (RT), and OTRS for government use cases.

Deployment and Configuration

  • Implementation procedures via Debian/Ubuntu packages or Docker Compose environments.
  • Database initialization, schema migrations, and administrative account provisioning.
  • Elasticsearch configuration to enable comprehensive full-text search capabilities.
  • Configuration of communication channels, including SMTP, IMAP, and Microsoft 365 integration.

Ticket Lifecycle Management

  • Consolidation and merging of inquiries from disparate communication channels.
  • Management of ticket statuses, priority levels, types, and classification tags.
  • Utilization of macros, templates, and standardized response libraries for efficiency.
  • Differentiation between internal notes and customer-facing content.

Process Automation and Workflow

  • Automated routing and notification protocols driven by defined triggers.
  • Scheduled tasks for escalation procedures and data maintenance.
  • Definition of Service Level Agreements (SLAs) with calendar-aware performance targets.
  • Customization of ticket dashboards and filtering criteria.

User and Organizational Administration

  • Management of agent, customer, and organizational hierarchical structures.
  • Implementation of role-based access controls and group assignments.
  • Integration with LDAP and SAML providers for secure authentication.
  • Deployment of customer portals to support self-service initiatives.

Knowledge Management and Analytics

  • Development and publication of internal and public-facing knowledge base resources.
  • Monitoring of key performance indicators, including volume, response times, and satisfaction metrics.
  • Generation of custom reports and data export to CSV formats.
  • Integration of time tracking for billing and resource accounting purposes.

System Integration and Maintenance

  • Implementation of webhook notifications for interoperability with external systems.
  • Application Programming Interface (API) utilization for custom integrations and mobile applications.
  • Procedures for database backup, restoration, and attachment management.
  • Protocols for system upgrades and plugin administration.

Requirements

  • Competency in intermediate-level Linux systems and web application administration.
  • Knowledge of customer support operational workflows and Service Level Agreement (SLA) frameworks.
  • Familiarity with foundational concepts regarding PostgreSQL databases and Ruby on Rails development.

Target Audience

  • Support leadership seeking to transition away from commercial platforms such as Zendesk, Freshdesk, or ServiceNow.
  • Entities requiring strict local custody of ticketing systems and sensitive customer data.
  • Proponents of open-source software aiming to establish transparent and accountable support operations for government
 14 Hours

Number of participants


Price per participant

Upcoming Courses

Related Categories