A. Payment Information (refer to Standard Terms) B. Work Orders (refer to Standard Terms) C. Security Requirements (refer to Standard Terms) D. Insurance Requirement E. V.2.0 Site - The ATCC is requesting bids to provide the following services for the Phase 2 enhancements to the Credit Control application: 1. Create a new standalone site hosted on the current web server and migrate the Credit Control web app to a more modern framework. This site will run alongside the existing Credit Control web app: https://atccmd.maryland.gov/creditcontrol. 2. This phase is intended to maintain existing Admin functionality for ATCC staff and include minor UX enhancements. F. Setup UI framework 1. Setup the UI foundation on a modern JavaScript framework (ex. Vue, Angular or React), which provide “out of the box” libraries for navigation, form validation, material design and API integration/security for the web app to adhere to common web standards. G. Setup API framework 1. Vendor will setup the API foundation using .NET Core to communicate with the database (e.g. search/create/update/delete Retailers). Vendor will develop rolebased security (authentication and authorization) to APIs to limit access for Wholesaler and Admin users, as well as for the service account which will be used to run the automated scheduled jobs. H. Migrate login functionality (authentication and authorization) 1. Currently, the Wholesaler & Admin logins are stored in a database table with username/password. Vendor will migrate the current login system to the new Beta site which shall leverage modern OAuth2 security standards. I. Vendor will collaborate with ATCC staff to propose User Interface/User Experience updates to improve site usability & workflows for both Administrative and Wholesaler users in the next phases. J. Vendor shall optimize the Database/Code to ensure that unnecessary data is not held longer than necessary to release server resources: 1. Cleanup orphan records in TransTemp1 table 2. Create process to archive data, as some uncleared transactions data goes back to 1999. 3. Add database indexes for better query performance: 30-Day Report table, 90- Day Report table, Retailer table, etc. 4. Optimize stored procedure queries to reduce data transfer 5. Ensure database connections are closed to release server resources as soon as they are not needed for long running pages, e.g. 30-day master report 6. Configure to reduce database server load for large data results that will be returned to web server 7. Remove code which may hide underlying errors that occur and cause indirect “internal server errors” page to be displayed to user
