Federal Supply Schedule 47QTCA24D00FL

GENERAL SERVICES ADMINISTRATION

Federal Supply Service Authorized Federal Supply Service Multiple Award Schedule Pricelist

Advanced Technologies Group, L.L.C. (ATG) 1601 48th Street, Suite 220

West Des Moines, IA 50266

(515) 221-9344 www.a-t-g.com

Schedule Number: MAS Schedule Title: Multiple Award Schedule Large Category: Information Technology FSC Group: Computer Equipment, Computer Software and Accessories Product Service Codes: 7A20, 7A21, 7E21, DA01, DA10, DB01, DC01, DE01, DE11, DF01, R617

Contract Number: 47QTCA24D00FL Period Covered by Contract: Sept 10th 2024 – Sept 9th 2029 Pricelist current through Modification N/A.

On-line access to contract ordering information, terms and conditions, up-to-date pricing, and the option to create an electronic delivery order are available through GSA Advantage!®, a menu-driven database system. The INTERNET address GSA Advantage!® is: GSAAdvantage.gov.

http://www.a-t-g.com/

Table of Contents

CUSTOMER INFORMATION:

1a. Table of Awarded Special Item Numbers (SINs) 1b. Lowest Priced Model Number and Price for Each SIN

Special Item No. 33411 Purchasing of New Electronic Equipment Special Item No. 511210 Software Licenses Special Item No. 54151S Information Technology Professional Services Special Item No. 54151 Software Maintenance Services

2. Maximum Order

3. Minimum Order

4. Geographic Coverage

5. Point(s) of Production

6. Discounts from List Prices or Statement of Net Price

7. Quantity Discounts

8. Prompt payment terms 9a. Notification that Government purchase cards are accepted at or below the micro-purchase threshold 9b. Notification whether Government purchase cards are accepted or not accepted above the micro-purchase threshold

10. Foreign items (list items by country of origin) 11a. Time of delivery 11b. Expedited Delivery

12. F.O.B. point(s) 13a. Ordering address 13b. Ordering procedures

14. Payment address

15. Warranty provision

16. Export packing charges

17. Terms & Conditions of Government Purchase Card Acceptance

18. Terms & Conditions of Rental, Maintenance, and Repair

19. Terms & Conditions of Installation

20. Terms & Conditions of Repair Parts 20a. Terms & Conditions for any other services (if applicable)

Advanced Technologies Group LLC (ATG) Perpetual Software License Agreement Advanced Technologies Group LLC (ATG) Term Software License Agreement Terms of Service for Software Maintenance Services Terms of Service for Tablet Hardware

21. List of service and distribution points

22. List of participating dealers

23. Preventive maintenance 24a. Special attributes such as environmental attributes 24b. If applicable, indicate that Section 508 compliance information is available on Electronic and Information Technology (EIT) supplies and services and show where full details can be found (e.g. contractor’s website or other location.)

25. Data Universal Number System (DUNS) number and Unique Entity ID

26. Notification regarding registration in System for Award Management (SAM) database

CUSTOMER INFORMATION:

1a. Table of Awarded Special Item Numbers (SINs)

Special Item Number DESCRIPTION

33411 Purchasing of New Electronic Equipment

511210 Software Licenses

54151 Software Maintenance Services

54151S Information Technology Professional Services

1b. Lowest Priced Model Number and Price for Each SIN

Special Item No. 33411 Purchasing of New Electronic Equipment Manufacturer: Advanced Technologies Group, LLC

Item# Description UOM GSA Rate w/IFF

SCORE5C SCORE5C - 4th generation 5" Secure Tablet (MT8168 w/1GB RAM and 32GB storage), designed for use by inmates in correctional facilities. Requires agency to be current with licensing and maintenance of ATG's Inmate Enablement System and procure term license for ATG’s SCORE firmware for each tablet.

EA $92.04

SCORE7C SCORE7C - 4th generation 7" Secure Tablet (MT8168 w/1GB RAM and 32GB storage), designed for use by inmates in correctional facilities. Requires agency to be current with licensing and maintenance of ATG's Inmate Enablement System and procure term license for ATG’s SCORE firmware for each tablet.

EA $95.72

SCORE7T SCORE7T - 5th generation 7" Secure Tablet (MT8168 w/2GB RAM, 32GB storage with hardened case), designed for use by inmates in correctional facilities. Requires agency to be current with licensing and maintenance of ATG's Inmate Enablement System and procure term license for ATG’s SCORE firmware for each tablet.

EA $106.80

SCORE 8 SCORE8 - 5th generation 8" Secure Tablet (MT8168 w/2GB RAM, 32GB storage with hardened case), designed for use by inmates in correctional facilities. Requires agency to be current with licensing and maintenance of ATG's Inmate Enablement System, and also procure ATG's tablet maintenance service for each tablet.

EA $111.21

SCORE 11 SCORE11 - 5th generation 11" Secure Tablet (MT8168 w/2GB RAM, 32GB storage with hardened case), designed for use by inmates in correctional facilities. Requires agency to be current with licensing and maintenance of ATG's Inmate Enablement System, and also procure ATG's tablet maintenance service for each tablet.

EA $121.53

Special Item No. 511210 Software Licenses Manufacturer: Advanced Technologies Group, LLC

Term Software License

The ordering activity may not convert term licenses to perpetual licenses.

Item# Description UOM

GSA

Rate w/IFF

SCORE_FW

SCORE Tablet Firmware Annual Term License: Secure firmware, custom-built for SCORE Tablet, provides the required software security that controls actions inmates can perform on the tablet. Customer needs a license for each SCORE tablet.

Per tablet/per month

$14.74

* Terms: Organization (Private Company or Government Agency) must license procure term license for every SCORE tablet procured by the agency. The number of licenses required will be updated monthly, based on count of tablets in used at any time during the month.

Item# Description UOM

GSA

Rate w/IFF

ATG-

Term-

CM

Offender Case Management - Increase efficiency of corrections officers and counselors, and simultaneously equip Executive Management with strategic information needed to reduce recidivism, operate and fund the DOC.

Per offender per month

$2.75

ATG-

Term- Trust

Trust Fund Accounting - Manage offender funds and automate debt collections using robust and secure financial transaction mechanisms.

$1.27

ATG-

Term- Canteen

Commissary Administration - Manage institutional and centralized commissary sales and inventory, and support “earned incentive” programs.

$0.90

ATG-

Term-

EHR

Electronic Medical Records - Better leverage scarce medical personnel through online medical records, intelligent scheduling and improve quality of care.

$3.79

ATG-

Term-Rx

Pharmacy Administration - Assist pharmacists with dispensing prescriptions and managing pharmaceutical purchasing and inventory.

$1.99

ATG-

Term- Mental

Mental Health Module for EMR - Optional add-on to Electronic Health Records to provide documentation of mental health services.

$0.85

ATG-

Term- Dental

Dental Health Module for EMR - - Optional add-on to Electronic Health Records to provide documentation of dental health services.

$0.52

ATG-

Term- Tele

Telephone System Administration - Software system that provides a reliable, secure and scalable inmate phone system at a cost capable of generating revenue.

$0.95

ATG-

Term- InEnb

Inmate Enablement System - Inmate access to institution approved features such as MP3, Email, Commissary Ordering, Staff Correspondence, Grievance Tracking, Account Lookup, Contact Administration etc.

$0.90

ATG-

Term- Food

Food Service Administration - Administer meal plans, perform nutritional analysis. Automate procurement and provide oversight of critical control points.

$1.31

ATG-

Term- Intel

Intelligence System - Incorporate information from various operations systems into a consolidated, linked view of all activities. Provide security personnel with a tool to rapidly identify patterns.

$1.74

ATG-

Term- Invest

Critical Incident Management & Investigation System - Tracks, documents and coordinates intra-agency and public communication about incidents, manages inmate and staff investigations, and evidence control.

$1.92

* Terms:

The ordering activity may not convert term licenses to perpetual licenses.

Organization (Government Agency) must license selected application for all offenders supervised at every facility owned, managed and operated by the agency. Minimum license count is 10000 offenders. Agency may choose to license their private facilities.

Offender count is set once annually; agency chooses whether it is on contract anniversary or start of agency's fiscal year.

Volume Discount For first 25000 offenders, fee for each offender is listed fee above.

For next 25000 offenders (25001-50000), fee for each offender is 95% of the listed fee.

For next 25000 offenders (50001-75000), fee for each offender is 90% of the listed fee.

For next 25000 offenders (75001-10000), fee for each offender is 85% of the listed fee.

For remaining offenders (100001+), fee for each offender is 80% of the listed fee.

Perpetual Software License

Item# Description UOM GSA Rate w/IFF

ATG-

CM

Offender Case Management - Increase efficiency of corrections officers and counselors, and simultaneously equip Executive Management with strategic information needed to reduce recidivism, operate and fund the DOC.

Each

$81,772.63

ATG-

Trust

Trust Fund Accounting - Manage offender funds and automate debt collections using robust and secure financial transaction mechanisms.

$37,805.72

ATG-

Canteen

Commissary Administration - Manage institutional and centralized commissary sales and inventory, and support “earned incentive” programs.

$26,437.92

ATG-

EHR

Electronic Medical Records - Better leverage scarce medical personnel through online medical records, intelligent scheduling and improve quality of care.

$112,656.54

ATG-Rx Pharmacy Administration - Assist pharmacists with dispensing prescriptions and managing pharmaceutical purchasing and inventory.

$59,288.59

ATG-

Mental

Mental Health Module for EMR - Optional add-on to Electronic Health Records to provide documentation of mental health services.

$24,964.12

ATG-

Dental

Dental Health Module for EMR - - Optional add-on to Electronic Health Records to provide documentation of dental health services.

$15,602.89

ATG-

Tele

Telephone System Administration - Software system that provides a reliable, secure and scalable inmate phone system at a cost capable of generating revenue.

$27,993.05

ATG-

Record

Digital Recorder - Optional add on to existing inmate telephone system to add digital recording services.

$24,311.91

ATG-

InEnb

Inmate Enablement System - Inmate access to institution approved features such as MP3, Email, Commissary Ordering, Staff Correspondence, Grievance Tracking, Account Lookup, Contact Administration etc.

$26,570.06

ATG-

Food

Food Service Administration - Administer meal plans, perform nutritional analysis. Automate procurement and provide oversight of critical control points.

$38,781.48

ATG-

Intel

Intelligence System - Incorporate information from various operations systems into a consolidated, linked view of all activities. Provide security personnel with a tool to rapidly identify patterns.

$52,984.24

ATG-

Invest

Critical Incident Management & Investigation System - Tracks, documents and coordinates intra-agency and public communication about incidents, manages inmate and staff investigations, and evidence control.

$57,223.58

* Agency must license each facility owned, managed, and operated by the agency. The number of licenses needed for each such facility is determined by the facility's "offender count" divided by 1000 rounded up to the nearest whole number. This License fee is a one-time fee that provides perpetual right to use the software for the named institution.

Volume Discount:

For first 25 licenses of the software is as listed.

For next 25 license (licenses 26-49), fee for each license is 6.25% discount off the listed fee.

For next 25 license (license 50-74), fee for each license is 10% discount off the listed fee.

For additional licenses (license 75+), fee for each license is 16.25% discount off the listed fee.

Special Item No. 54151S Information Technology Professional Services

LABOR CATEGORY RATES1

Labor Category Minimum Education

Minimum Years of Experience

Security Clearance Required

Rate Including IFF 9/10/2024- 9/30/2025

Program Executive Masters2 24 Yes $398.66 Enterprise Software Architect Masters 20 Yes $372.48 Enterprise Database Architect Masters 20 Yes $372.48 Enterprise Network Architect Masters 20 Yes $372.48 Staff Software Engineer Masters 10 Yes $260.46 Staff Database Engineer Masters 10 Yes $260.46 Staff Network Engineer Masters 10 Yes $260.46 Senior Software Engineer Masters 5 Yes $233.51 Senior Database Engineer Masters 5 Yes $233.51 Senior Network Engineer Masters 5 Yes $233.51 Senior Quality Assurance Analyst Bachelors3 5 Yes $183.32 Software Engineer Bachelors 2 Yes $190.38 Database Engineer Bachelors 2 Yes $190.38 Network Engineer Bachelors 2 Yes $190.38 Quality Assurance Analyst Bachelors 2 Yes $144.90

1 All labor rates are for Domestic work only, and performed at Contractor Facility

2 Masters Degrees requirement can be substituted with Bachelors’ Degree plus 3 year of experience. This is applicable to Program Executive, Enterprise and Staff and Senior level positions.

3 Bachelors’ Degree plus requirement can be substituted with Bachelors’ Degree plus 5 years of experience. This is applicable to Senior Quality Assurance Analyst, Software Engineer, Database Engineer, Network Engineer, and Quality Assurance Analyst positions.

LABOR CATEGORY DESCRIPTIONS

Service Title Service Description

Program Executive

Executive level (Vice President or above) professional who is a subject matter expert with 20+ years of experience delivering the particular enterprise solution to correctional facilities. Has previously functioned as an Enterprise Architect for the particular software solution for 10+ years, manages the software team responsible for delivering the enterprise-grade correctional solution, has previously implemented the solution to at least 4 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Is a subject matter expert on the particular software solution, will advise the customer of best practices from other agencies, business decisions, coordinate the gap analysis with customer's subject matter expert, identify risks and develop mitigation strategies, oversee the software customizations needed, and ensure solution is delivered on time and on budget.

1. Project Planning: Defines project scope: objectives, deliverables, and boundaries. Creates a WBS to break down the project into manageable tasks with timelines, milestones and deadlines using Microsoft Project.

2. Resource Management: Manage resources, including personnel, equipment, and materials, ensuring they are available and utilized effectively.

3. Budget Management: Estimate costs for resources, labor, and other expenses. Ensure expenditures stay within budget.

4. Risk Management: Identify potential technical, financial, or operational risks; develop and implement strategies to mitigate identified risks.

5. Stakeholder Communication: Oversee all communications ensuring correctional agency’s executives and team members are aware of status and key decisions.

6. Project Execution: Ensure project tasks and deliverables are completed on time and to the required quality standards. Oversee testing and validation activities to verify that the project outputs are functioning as intended.

7. Project Closure: Ensure that all project deliverables are completed, reviewed, and approved by stakeholders.

Enterprise Software Architect

Executive level (Asst Vice President and above) level professional with 20+ years of experience designing and overseeing the structure of the particular enterprise grade software solution for the correctional agency. Defines technical standards governing the development and determines the system integration strategy used for the implementation at the particular correctional agency.

Has previously implemented the solution to at least 4 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Responsibilities of an Enterprise Software Architect

1. Architectural Design: Develop high-level software architecture, design patterns and frameworks that ensure scalability, reliability, performance, and compliance with FedRAMP security requirements, including implementing controls for confidentiality, integrity, and availability of data.

2. Integration: Oversee the integration of ATG’s software systems with correctional agency’s various existing software systems and technologies to ensure they work together efficiently and securely.

3. Technical Leadership: Provide guidance and mentorship to development teams, ensuring they follow architectural guidelines and best practices. Includes code reviews.

4. Standards and Governance: Define and enforce technical standards, best practices, and policies to ensure consistency across the software development lifecycle. Incorporate mechanisms for data encryption, secure data transmission, and access controls to ensure that sensitive information is protected in compliance with FedRAMP standards.

5. Stakeholder Communication: Work closely with business stakeholders to understand their needs and translate these into technical requirements and solutions.

6. Risk Management: Address and mitigate risks specific to cloud environments and FedRAMP requirements. This includes understanding and managing threats related to cloud services and ensuring that the architecture supports robust risk management practices.

Database Architect

Executive level (Asst Vice President and above) level professional with 20+ years of experience designing and managing the database servers and databases hosting CJIS data managed by ATG’s enterprise grade software solutions for the correctional agency.

Has previously implemented and managed database servers for at least 10 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Responsibilities of an Enterprise Database Architect

1. Database Design and Architecture: Create logical and physical database schemas optimized for performance, scalability, and data integrity. Develop data models using techniques like Entity- Relationship Diagrams (ERDs) and Unified Modeling Language (UML) to visualize data structures and relationships. Implement database security and scalability technologies (partitioning, data replication, data warehousing, etc.) based on correctional agency’s requirements and performance considerations.

Implement monitoring tools to track database performance, resource usage, and query execution.

2. Data Security and Compliance: Define and enforce access control policies to ensure that only authorized users and applications have access to sensitive data; includes implementing RBAC and managing database permissions; encryption standards (AES, TLS, FIPS 140-2, etc.) required by FedRAMP for data at rest and in transit.

3. Backup and Recovery: Develop and maintain backup and DR plans to ensure data availability and integrity in case of hardware failures, data corruption, or other incidents.

4. Continuous Monitoring to detect and respond to security threats and vulnerabilities. This includes integrating with security information and event management (SIEM) systems for real-time monitoring and alerting.

5. Incident Handling: Develop and integrate incident response plans specific to database security incidents, ensuring alignment with FedRAMP requirements for incident handling and reporting.

Network Architect

Executive level (Asst Vice President and above) level professional with 20+ years of experience designing and managing scalable, efficient, and secure network infrastructure to host ATG’s enterprise grade software solution for the correctional agency. The network architecture addresses compliance standards such as FedRAMP and NIST 800-53.

Has previously implemented a secure network at least 10 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Key responsibilities include:

1. Design and Planning: Developing comprehensive network design and architecture plans, including network topology, hardware, and software specifications. They ensure that the correctional institution’s LAN and Wi-Fi network, WAN network connecting institutions to central data centers and cloud providers, is is robust, scalable, and capable of supporting current and future business requirements.

2. Implementation and Integration: Overseeing the deployment and integration of network solutions, including routers, switches, firewalls, and other network devices. Work closely with other IT teams to ensure seamless implementation and integration with existing systems.

3. Security and Compliance: Ensure that the network infrastructure adheres to industry standards, regulatory requirements. Implement and manage security measures to protect against data breaches, cyber threats, and other vulnerabilities, ensuring compliance with FedRAMP's rigorous security and privacy standards.

4. Performance Optimization: Monitoring and analyzing network performance to identify areas for improvement.

5. Troubleshooting and Support: Addressing and resolving complex network issues and providing expert-level support to IT staff and users. Develop and implement disaster recovery plans to ensure business continuity.

6. Documentation and Reporting: Creating detailed documentation of network architecture, configurations, and changes. Provide regular reports on network performance, security incidents, and compliance status.

Staff Software Engineer

Senior professional with 10+ years’ experience software development experience on the particular ATG enterprise software solution for the correctional agency. The individual has deep understanding of both correctional agencies processes for the specific facet of offender supervision, and software development technologies that address CJIS security and agency’s scalability requirements.

Has previously supported the implementation of the software at least 3 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Responsibilities of a Senior Software Analyst

1. Requirements Gathering and Analysis: Work closely with correctional agency’s subject matter experts to gather and document changes required to the core ATG system. Translate business needs into detailed functional and non-functional requirements. This includes creating requirement specifications, user stories, and use cases.

2. System Design and Architecture: Collaborate with Enterprise architects to design solutions that address business needs and integrate with existing systems.

3. Technical Documentation: Develop comprehensive technical documentation, including functional specifications, system diagrams, and process flows

4. Assist project managers by providing input on project scope, risks, and dependencies. Monitor and report on project progress, including any issues or changes in requirements.

5. Issue Resolution: Investigate and resolve issues or defects reported by users or discovered during testing. Recommend and implement process improvements based on feedback and performance analysis.

Staff Database Engineer

Senior professional with 10+ years experience managing, analyzing, and optimizing database servers and databases storing CJIS data processed by ATG’s enterprise grade software solutions for correctional agencies.

Has previously implemented and managed database servers for at least 5 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Responsibilities of a Senior Database Analyst

1. Database Design and Management: Design and maintain database schemas, tables, indexes, and relationships, ensuring they are optimized for performance and data integrity.

2. Performance Optimization: Analyze and optimize SQL queries and database performance.

Implement indexing strategies and analyze execution plans to improve query efficiency. Utilize database monitoring tools (SSMS, Redgate, etc.) to track performance metrics, identify bottlenecks, and proactively address issues.

3. Data Analysis and Reporting: Extract, transform, and load (ETL) data to support business intelligence and reporting needs. Use ETL tools and SQL scripts to manage and manipulate data.

4. Database Security and Compliance: Implement and manage database security measures, including user access controls, authentication, and authorization, to protect sensitive data. Ensure compliance with data protection regulations and standards, CJIS, HIPAA, FedRAMP, by implementing appropriate data encryption and privacy measures.

5. Backup and Recovery: Perform regular backups and test recovery processes to minimize data loss.

6. Data Integration: Expert in use of data integration tools and middleware to ensure seamless data flow. Ensures data is accurately moved and transformed between systems.

7. Troubleshooting and Support: Investigate and resolve database-related issues, including performance problems, data inconsistencies, and connectivity issues.

Staff Network

Senior professional with 10+ years’ experience implementing and maintaining scalable, efficient, and secure network infrastructure to host ATG’s enterprise grade software solutions for the correctional agency. The individual has a deep understanding of how correctional agencies work, their requirements for network security, and the security standards required by HIPPA, CJIS and FedRAMP.

Has previously managed and supported secure networks at least 5 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Key Responsibilities

1. Network and Server Implementation: Configure and install network devices such as routers, switches, firewalls, and load balancers such that it conforms to architecture determined by Executive Management team. Set up network services, including DNS (Domain Name System), DHCP (Dynamic Host Configuration Protocol), and VPNs (Virtual Private Networks). Independently deploy virtual machines in both op-prem and cloud that adhere to the security and redundancy architecture approved by the correctional agency.

2. Network and Server Performance Monitoring and Optimization: Use network monitoring tools (e.g., PRTG, SolarWinds, Insight manager) to track network performance, identify bottlenecks, and detect anomalies. Optimize network performance by tuning configurations, upgrading hardware, and implementing Quality of Service (QoS) policies to prioritize critical traffic.

3. Troubleshooting and Support: Diagnose and resolve complex network and servers issues, including connectivity problems, performance degradation, and security breaches. Provide advanced support for escalated network problems.

4. Network Security: Implement and manage network security measures, including firewalls, intrusion detection systems (IDS), and intrusion prevention systems (IPS). Ensure the network is protected against threats and vulnerabilities.

5. Documentation and Reporting: Maintain comprehensive documentation of network configurations, topologies, and changes. Update network diagrams, inventory lists, and configuration records regularly.

Generate reports on network performance, incidents, and security events. Provide insights and recommendations based on data analysis.

Senior Software

Senior professional with 5+ years’ experience software development experience on the particular ATG enterprise software solution for the correctional agency. The individual has deep understanding of both correctional agencies processes for the specific facet of offender supervision, and software development technologies to ensure software systems meets the CJIS security and agency’s scalability requirements.

Has previously supported the implementation of the software at least 2 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Responsibilities of a Senior Software Analyst

1. Requirements Gathering and Analysis: Work closely with correctional agency’s subject matter experts to gather and document changes required to the core ATG system. Translate business needs into detailed functional and non-functional requirements. This includes creating requirement specifications, user stories, and use cases.

2. System Design and Architecture: Collaborate with Enterprise architects to design solutions that address business needs and integrate with existing systems.

3. Technical Documentation: Develop comprehensive technical documentation, including functional specifications, system diagrams, and process flows

4. Assist project managers by providing input on project scope, risks, and dependencies. Monitor and report on project progress, including any issues or changes in requirements.

5. Issue Resolution: Investigate and resolve issues or defects reported by users or discovered during testing. Recommend and implement process improvements based on feedback and performance analysis.

Senior Database

Senior professional with 5+ years’ experience managing, analyzing, and optimizing database servers and databases storing CJIS data processed by ATG’s enterprise grade software solutions for correctional agencies.

Has previously implemented and managed database servers for at least 2 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Responsibilities of a Senior Database Analyst

1. Database Design and Management: Design and maintain database schemas, tables, indexes, and relationships, ensuring they are optimized for performance and data integrity.

2. Performance Optimization: Analyze and optimize SQL queries and database performance.

Implement indexing strategies and analyze execution plans to improve query efficiency. Utilize database monitoring tools (SSMS, Redgate, etc.) to track performance metrics, identify bottlenecks, and proactively address issues.

3. Data Analysis and Reporting: Extract, transform, and load (ETL) data to support business intelligence and reporting needs. Use ETL tools and SQL scripts to manage and manipulate data.

4. Database Security and Compliance: Implement and manage database security measures, including user access controls, authentication, and authorization, to protect sensitive data. Ensure compliance with data protection regulations and standards, CJIS, HIPAA, FedRAMP, by implementing appropriate data encryption and privacy measures.

5. Backup and Recovery: Perform regular backups and test recovery processes to minimize data loss.

6. Data Integration: Expert in use of data integration tools and middleware to ensure seamless data flow. Ensures data is accurately moved and transformed between systems.

7. Troubleshooting and Support: Investigate and resolve database-related issues, including performance problems, data inconsistencies, and connectivity issues.

Senior Network

Senior professional with 5+ years’ experience implementing and maintaining scalable, efficient, and secure network infrastructure to host ATG’s enterprise grade software solutions for the correctional agency. The individual has a deep understanding of how correctional agencies work, their requirements for network security, and the security standards required by HIPPA, CJIS and FedRAMP.

Has previously managed and supported secure networks at least 2 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Key Responsibilities

1. Network and Server Implementation: Configure and install network devices such as routers, switches, firewalls, and load balancers such that it conforms to architecture determined by Executive Management team. Set up network services, including DNS (Domain Name System), DHCP (Dynamic Host Configuration Protocol), and VPNs (Virtual Private Networks). Independently deploy virtual machines in both op-prem and cloud that adhere to the security and redundancy architecture approved by the correctional agency.

2. Network and Server Performance Monitoring and Optimization: Use network monitoring tools (e.g., PRTG, SolarWinds, Insight manager) to track network performance, identify bottlenecks, and detect anomalies. Optimize network performance by tuning configurations, upgrading hardware, and implementing Quality of Service (QoS) policies to prioritize critical traffic.

3. Troubleshooting and Support: Diagnose and resolve complex network and servers issues, including connectivity problems, performance degradation, and security breaches. Provide advanced support for escalated network problems.

4. Network Security: Implement and manage network security measures, including firewalls, intrusion detection systems (IDS), and intrusion prevention systems (IPS). Ensure the network is protected against threats and vulnerabilities.

5. Documentation and Reporting: Maintain comprehensive documentation of network configurations, topologies, and changes. Update network diagrams, inventory lists, and configuration records regularly.

Generate reports on network performance, incidents, and security events. Provide insights and recommendations based on data analysis.

Senior Quality Assurance Analyst

Senior Quality Assurance (QA) Analyst is a Manager level professional with 5+ years of experience testing ATG’s enterprise software solutions for large correctional agencies. Individual is also responsible for creating and delivering training programs and providing second level software support.

The individual has deep and nuanced understanding of operational processes utilized by correctional agencies to manage the particular facet of offender supervision which is critical for quality assurance software testing, training agency’s trainers and supporting agency’s super users.

Has previously implemented and supported solutions deployed in at least 5 large State and Federal correctional agencies who each have at least 2000 staff and supervise over 30000 offenders.

Key Responsibilities

1) Test Planning and Strategy: Develop detailed test plans and test cases, ensuring comprehensive coverage of the affected portion of the software system, based on project requirements and design documents.

2) Testing and Validation: Execute test cases, compare outcomes against expected results and document results. Formally track defects or issues found during testing, collaborate with developers to resolve issues and verify fixes.

3) Risk Assessment: Identify quality risks associated with software releases and provide recommendations to mitigate these risks. Ensure that release meets quality standards.

4) Training Development: Develop training materials, including online user manuals, training agenda and hands-on exercises for delivery of train-the-trainer services.

5) Training Delivery: Lead training workshops, webinars, and one-on-one sessions to educate users about software features, functionalities, and best practices. Provide live demonstrations and walkthroughs of software applications.

6) Second-level Support: Provide initial software support for agency’s super users, and track and document the resolution of issues raised.

Software

Professional with college degree software programming and specifically trained on ATG’s enterprise software solution, software development framework, and the workflows used by correctional agencies to manage the particular facet of offender management. Person is a versatile professional that works on both the front-end and back-end aspects of web and thick client applications, as well as management of data in complex relational and distributed database servers (Microsoft SQL Server, IBM DB/2, Azure SQL, etc.).

Key Responsibilities

1. Front-End Development: Develop and implement the visual and interactive aspects of web applications using technologies such as MVC, HTML, CSS, Typescript and JavaScript. Ensure that applications are responsive and perform well across various devices and screen sizes.

2. Back-End Development: Write and maintain server-side code that handles application logic, database interactions, and integration with external services. Work with databases (SQL or NoSQL) to manage data storage, retrieval, and manipulation

3. DevOps and Deployment: Use version control systems like Git to manage code changes and collaborate with other developers. Deploy and manage applications on cloud platforms like AWS, Azure, or Google Cloud.

4. Problem Solving and Debugging: Identify and fix bugs or issues that arise in both front-end and back-end components. Optimize performance of the application by improving code efficiency and scalability.

Database

Professional with college degree in computer science and skilled in RDMS database administration.

Key Responsibilities

1. Database Management: Implement database schemas, tables, indexes, and relationships as defined by senior database administrators. Analyze and optimize SQL queries and database performance.

Implement indexing strategies and analyze execution plans to improve query efficiency.

2. Database Server Administration: Monitor performance of database server hardware and install patches issued by Microsoft and IBM for their respective RDMS (SQL Server and DB/2 respectively).

3. Backup and Recovery: Monitor the processes responsible for regular database and log backups, validate replication between HADR and Availability Groups is current and performing efficiently.

4. Monitor Integration Processes: Monitor all automated processes to ensure that jobs executed successfully and on time, track performance and resource utilization. Report anomaly to senior management and provide recommendation for issue resolution.

5. Troubleshooting and Support: Investigate and resolve database server issues, including hardware performance and connectivity issues. Assist software developers issue with stored procedures syntax and query performance issues.

Network

Professional with college degree in computer services focused on supporting and maintaining network and server infrastructure hosting ATG’s enterprise software for correctional agency.

Key Responsibilities

1. Network Setup and Configuration: Assist with the installation and configuration of network hardware, such as routers, switches, and firewalls. Help configure network settings and manage IP addresses, VLANs, and network interfaces.

2. Network Monitoring and Maintenance: Use network monitoring tools to keep an eye on network performance, availability, and security. Under guidance of senior network personnel, apply updates and patches to network devices and systems to ensure they are up-to-date and secure.

3. Server Setup and Configuration: Assist with the installation and configuration of servers, including physical hardware and virtual servers. Configure server settings, including network configurations, user permissions, and system preferences.

4. Server Maintenance: Apply software updates, patches, and security fixes to keep servers up-to-date and secure.

5. Backup and Recovery: Assist with regular backup procedures to ensure that server data is securely backed up and can be restored if needed. Support disaster recovery efforts, including testing and implementing recovery plans.

Quality Assurance Analyst

Quality Assurance (QA) Analyst is trained on specific ATG's enterprise solutions and the particular processes correctional agencies use to supervise offenders. The individual is experienced testing ATG's software solutions for large correctional agencies. Individual is also responsible for assisting Senior Quality Assurance Analysts deliver training and providing second level software support.

1) Testing and Validation: Execute test cases, compare outcomes against expected results and document results. Formally track defects or issues found during testing, collaborate with developers to resolve issues and verify fixes.

2) Support Training Development: Support Senior Quality Assurance Analysts effort to develop training materials and hands-on exercises.

3) Training Delivery: Co-lead training workshops, webinars, and one-on-one sessions to educate users about software features, functionalities, and best practices.

4) Second-level Support: Provide initial software support for agency’s super users, and track and document the resolution of issues raised.

Special Item No. 54151 Software Maintenance Services

Annual Fees for Software Maintenance Services is eight percent of total license and customization fees.

This fee is computed once at the beginning of each year using following approach: the previous year maintenance is adjusted for previous 12-month inflation (as announce by Bureau of Labor Statistics, Employment Cost Index, specifically the line for Information technology workers) plus 8% of cost of customizations and additional licenses that were ordered in the previous year.

Software Maintenance ensures ATG software remains compatibility with newer versions of underlying infrastructure software such as operating systems, database management systems, web servers, etc. Since ATG software are customized solutions, “Software Maintenance"" does not include additional features; those are developed and delivered as special-request customizations.

Additional support on an ala carte basis is available using SIN 54151S.

2. Maximum Order The Maximum Order value for the following Special Item Numbers (SINs) is $500,000:

• Special Item No. 33411 Purchase of New Electronic Equipment

• Special Item No. 511210 Software Licenses

• Special Item No. 54151 Software Maintenance Services

• Special Item No. 54151S Information Technology Professional Services

3. Minimum Order The minimum dollar value of orders to be issued is $ 50,000.00.

4. Geographic Coverage Domestic delivery only

5. Point(s) of Production All items under Special Item Number 33411 (Purchasing New Electronic Equipment) are determined to be made in Taiwan.

All items under following Special Item Number are U.S. made end products

• 511210 (Perpetual Software Licenses)

• 54151 (Software Maintenance Services)

• 54151S (Information Technology Professional Services)

6. Discounts from List Prices or Statement of Net Price Prices shown are NET Prices; basic discounts have been deducted.

7. Quantity Discounts None

8. Prompt payment terms.

0% Net 30 days

9a. Notification that Government purchase cards are accepted at or below the micro-purchase threshold.

No

9b. Notification whether Government purchase cards are accepted or not accepted above the micro-purchase threshold.

No

10. Foreign items (list items by country of origin)

Taiwan

• SCORE5C

• SCORE7C

• SCORE7T

• SCORE7

• SCORE11

11a. Time of delivery.

30 Days ARO

11b. Expedited Delivery.

Not Applicable

12. F.O.B. point(s).

FOB Destination

13a. Ordering address.

1601 48th Street, Suite 220 West Des Moines, IA 50266

13b. Ordering procedures For supplies and services, the ordering procedures, information on Blanket Purchase Agreements (BPA’s) are found in Federal Acquisition Regulation (FAR) 8.405-3.

14. Payment address.

ADVANCED TECHNOLOGIES GROUP, L.L.C.

10880 LINPAGE PLACE

ST. LOUIS, MO 63132

15. Warranty provision.

SOFTWARE

For three hundred and sixty five (365) days (the "Warranty Period") from the Customer’s date of purchase, ATG warrants for the Customer’s benefit alone, that (i) the Software will substantially conform to the applicable Documentation and (ii) the media on which the Software is distributed and the Documentation (if any) are free from defects in materials and workmanship and, (iii) during the Warranty Period, the Software will operate substantially in accordance with the Documentation. If during the Warranty Period an error in the Software occurs, the Customer may return the Software to ATG for either repair or replacement, or if so elected by ATG, refund of the license fee paid by the Customer under this Agreement.

THE FOREGOING ARE THE ONLY WARRANTIES PROVIDED BY ATG AND ATG DISCLAIMS ANY

AND ALL OTHER WARRANTIES, WHETHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED

TO, ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR

PURPOSE.

Because computer software is inherently complex and may not be completely free of errors, it is the Customer’s responsibility to verify its work and to make backup copies, and ATG will not be responsible for the Customer’s failure to do so. ATG’s cumulative liability to the Customer or any party for any loss or damages resulting from any claims, demands, or actions arising out of or relating to this Agreement shall not exceed the license fee paid to ATG for the applicable Software.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT WILL ATG BE

LIABLE FOR INDIRECT, SPECIAL, INCIDENTAL, ECONOMIC, EXEMPLARY, OR CONSEQUENTIAL

DAMAGES ARISING OUT OF THE USE OF OR INABILITY TO USE ATG PRODUCTS OR SERVICES,

INCLUDING, WITHOUT LIMITATION, DAMAGES OR COSTS RELATING TO THE LOSS OF PROFITS,

BUSINESS, GOODWILL, DATA, OR COMPUTER PROGRAMS, EVEN IF ATG HAS BEEN ADVISED OF

THE POSSIBILITY OF SUCH DAMAGES. THE FOREGOING EXCLUSION/LIMITATION OF LIABILITY

SHALL NOT APPLY (1) TO PERSONAL INJURY OR DEATH CAUSED BY ATG’S NEGLIGENCE; (2) FOR FRAUD; OR (3) FOR ANY OTHER MATTER FOR WHICH LIABILITY CANNOT BE EXCLUDED BY LAW.

The Contractor warrants and implies that the items delivered hereunder are merchantable and fit for use for the particular purpose described in this contract.

Limitation of Liability. Except as otherwise provided by an express or implied warranty, the Contractor will not be liable to the ordering activity for consequential damages resulting from any defect or deficiencies in accepted items.

TABLET HARDWARE

ATG warrants to the original end-user purchase, that the SCORE® Secure Device, excluding content and/or software supplied with or on it, will be free from defects in material and workmanship under normal use for a period of ninety (90) days from the date the SCORE® Secure Device is delivered to you. This warranty is non-transferrable, and you agree that this warranty may be further limited by circumstances beyond ATG’s control, including but not limited to security measures or other polices or procedures put in place by the institution in which you are housed.

ATG’s liability under this warranty, and your exclusive remedy, is limited (at ATG’s discretion) to either replacing or repairing the SCORE® Secure Device; provided however, if ATG is unable to repair or replace your SCORE® Secure Device, ATG may provide you with an equivalent product, which may be a refurbished product, at ATG’s sole discretion.

16. Export packing charges

17. Terms & Conditions of Government Purchase Card Acceptance.

18. Terms & Conditions of Rental, Maintenance, and Repair

19. Terms & Conditions of Installation

20. Terms & Conditions of Repair Parts.

20a. Terms & Conditions for any other services (if applicable).

Advanced Technologies Group LLC (ATG) Perpetual Software License Agreement

READ THE TERMS AND CONDITIONS OF THIS AGREEMENT CAREFULLY BEFORE LOADING,

AND/OR OTHERWISE USING THE SOFTWARE. THIS AGREEMENT, TOGETHER WITH THE SCHEDULE

PRICE LIST, THE UNDERLYING GSA SCHEDULE CONTRACT, AND ANY APPLICABLE GSA

CUSTOMER PURCHASE ORDERS REPRESENTS THE ENTIRE AGREEMENT CONCERNING THE

SOFTWARE BETWEEN THE GSA CUSTOMER AND ATG, AND THEY SUPERSEDE ANY PRIOR

PROPOSAL OR UNDERSTANDING BETWEEN THE GSA CUSTOMER AND ATG. THIS AGREEMENT,

HOWEVER SHALL NOT TAKE PRECEDENCE OVER THE TERMS OF THE UNDERLYING GSA

SCHEDULE CONTRACT OR ANY SPECIFIC, NEGOTIATED TERMS ON THE GOVERNMENT’S

PURCHASE ORDER.

THE GSA CUSTOMER ACCEPTS AND AGREES TO THE TERMS OF THIS AGREEMENT, AND THEREBY

CREATES A CONTRACTUAL AGREEMENT BETWEEN THE GSA CUSTOMER AND ATG. IF THE GSA

CUSTOMER IS NOT WILLING TO BE BOUND BY THE TERMS OF THIS AGREEMENT, THE GSA

CUSTOMER SHOULD NOT DOWNLOAD, INSTALL, OR USE THE SOFTWARE, AND PROMPTLY

RETURN THE SOFTWARE AND ASSOCIATED DOCUMENTATION.

1. LICENSE GRANT

ATG grants to the GSA Customer, a perpetual, non-exclusive, and non-transferable license to use software program(s) provided by ATG, and the accompanying user documentation (“Documentation”), (collectively, the “Software”) as purchased by the GSA Customer only as authorized in this Agreement. The GSA Customer may not assign, transfer, rent, or sublicense the Software. The Software consists of proprietary products of ATG or its third party suppliers, and the proprietary rights that protect such property may include, but are not limited to, U.S. and international copyrights, trademarks, patents, and trade secret laws of general applicability. All right, title and interest in and to the Software are and shall remain with ATG or its third party suppliers, as applicable. This Agreement does not convey to the GSA Customer any interest in or title to the Software, but only a limited right of use, revocable in accordance with its terms.

ATG software is licensed to a named prison facility that is owned, operated and managed by the particular ordering activity that purchased the license. The software can only be used to manage information about inmates residing at the named prison facility. The license does not limit number of users, even from other agencies that need access to the information stored. The licenses are not transferable between agencies or between prison facilities within an agency. The only exception to the previous statement is that in the event that a prison facility is permanently closed, the agency can transfer that prison’s license to another prison facility owned, operated and managed by the same agency.

The GSA Customer may use the Software on unlimited number of computers to support residents of facilities licensed for using this software. The GSA Customer may only license software for facilities that are owned, operated and managed by the GSA Customer.

For Software provided to the GSA Customer for an evaluation period, the GSA Customer may use the Software until the completion of the evaluation period.

2. CONSENT TO USE OF DATA

The GSA Customer agrees that ATG and its subsidiaries may collect and use technical and related…