Systems Integration Software Solution and Services

The Vendor is required to provide for systems integration software solution and services.
- The solution should be software with no-code / low-code application and interface development capability and a queuing / message broker platform to securely integrate disparate information systems and databases, primarily on-premises.
- The solution should be capable of calling or being called by web services, accessing databases, parsing data files, performing programming logic and data manipulation, transferring files, sending emails, and other functions.
- The solution should also include annual maintenance and support service to provide software updates and technical support.
- Services should include training, installation and configuration, consultation on design and architecture, development, and project support as well as optional as-needed professional services.
- Systems to be integrated:
• Customer Information / Utility Billing (CIS)
• Advanced Meter Infrastructure (AMI)
• Meter Data Management (MDMS)
• Field Service Work Order System
• Outage Management (OMS)
• Text Messaging Service
• File Transfer, Internal and External, SFTP
• Others
- These systems perform critical business functions such as customer account management, billing, smart meter read data collection, validation, and processing, field service work orders, automated turn on and off of electric services, customer notice communication, posting transaction summaries to financial system, exchanging data with contract service providers, and more. Many of these systems are part of the "meter to cash" set of business processes.
- E-SCADA staff administer, develop, maintain, and support the systems on the E-SCADA network, and a contracted managed IT service provider does the same for systems and infrastructure on the City network.
- Provide a comprehensive on-premise network infrastructure, including firewalls and appliances capable of server load balancing, reverse proxy server, web application firewall (WAF), virtual IP assignment, network address translation (NAT), and DNS resolution.
- If artificial intelligence (AI) is used for support, ability to escalate to a competent human support representatives upon request
- Ability to open support tickets online, by email, or telephone
- Emergency support for critical issues should be available 24 hours / day, 7 days / week, 365 days per year
- Review city documentation and meet with city and contract IT service staff to review and understand city hardware, network, software, application integration, and security requirements that are relevant for the Solution implementation.
- Configuration
• Configure single-sign-on (SSO)
• Security groups, roles, and permissions
• SMTP mail configuration
• Database connections
• SFTP connections
• Aliases / names
• Security Certificates
• Other configuration items.