Specifications include, but are not limited to: A. Portfolio Investment Accounting and Functionality 1. The Software should provide multi-portfolio/account capabilities. 2. The Software should support up to a ten (10) digit account/fund alphanumeric code. 3. The Software should be flexible for being able to both account for and not account for amortize/accrete premiums and discounts. 4. The Software should have a centralized security/asset master file. 5. The Software should not have a limit on the number of securities that can be entered into each portfolio/account. If there is a limit, please state the limit. 6. The Software should provide cash forecasting and cash flow trend analysis capabilities. 7. The Software should have the ability to integrate with the City’s Accounting System that is provided by CGI Advantage® Enterprise Resource Planning. 8. The Software should not have a dollar limit for the amount of an individual security or each individual portfolio/account. If there is a dollar limit, please state the limit and explain why there is a limit. B. Investment Decision Support Capabilities 1. Measure and maximize cash flow yields while maintaining liquidity for operational needs. 2. Compile investment offerings into one centralized candidate list with appropriate buy/sell recommendations on a daily basis or periodically as required by the City. 3. Compare securities at the quoted offer price to meet policy requirements and liability needs. 4. Factor in anticipated call dates so the City can more timely sell and buy comparable securities to help minimize idle discretionary cash balances. 5. Calculate various interest and amortization for a variety of investment types. 6. Allow assigned Treasury cash management staff to run sensitive analyses to ensure proper selection and execution of investment decisions. 7. Integrate custodian and/or custodian bank feeds to create a daily listing of portfolio holdings. 8. Provide performance metrics to evaluate broker-dealers’ execution and fees, best internal buy/sell execution, and peer groups. 9. Provide performance metrics to evaluate the City’s execution of recommended actions and optimization of returns. 10. Measure annual investment opportunity costs. 11. Maintain investment policy compliance. 12. Screen out securities excluded by Chapter 46-50, Hawaii Revised Statutes. C. Reporting and Performance Measurement 1. The software should allow users to view historical performance by portfolio, asset class, or individual security over various time periods. 2. The software should exhibit benchmarking capabilities. 3. The software should allow the creation of custom benchmarks to reflect the investment objectives of different portfolios. 4. The software should provide ad-hoc reporting capabilities. 5. The software should include built-in dashboards, graph, and charting capabilities. 6. The data elements should be used for searching, sorting and/or exporting. 7. The software should have the capability to generate custom reports based on user-defined fields and constraints including query selection criteria. 8. An up-to-date detailed data dictionary should be provided and maintained by the Contractor. D. Required Implementation and Support Services The Contractor’s solution must be able to: 1. Configure the system based on the City’s objectives and compliance with applicable laws, regulations and rules. 2. Should be able to export the existing investment data stored in the City’s current investment software, Sympro. 3. Review transactions and make recommendations on duration of holdings. 4. Provide at least quarterly, current and projected investment market analysis on fixed income yields. 5. Review quarterly and annual reports and make recommendations on the performance of broker-dealers ability to obtain best pricing and timely execution, staff/resource improvements. 6. Provide year-round online or in-person training and education to the City staff and any support services necessary throughout the Contract period, at a minimum, the Contractor shall provide quarterly training (online or in-person). Training shall be requested and scheduled by the City. Supply the training and user guides materials for online or in-person training. 7. The Contractor is required to meet with the City’s Department of Information Technology staff to ensure the method of securing data and information is in accordance with the City’s Information Technology requirements.
