Amendment+1+-+Krasan+Consulting+Services.pdf

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

CONTRACT AMENDMENT

CONTRACT NUMBER AND NAME: 096 - DATA ARCHITECTURE, STRATEGY AND

TECHNOLOGY CONSULTING SERVICES

AMENDMENT NUMBER: 3

This amendment is made to Data Architecture, Strategy and Technology Consulting Services (Contract) between the State of North Dakota, acting through its Information Technology Department in cooperation with the Office of Management and Budget State Procurement Office (STATE), and Krasan Consulting Services, Inc. (CONTRACTOR).

The parties agree to the following terms and conditions and expressly agree that if any of the following terms and conditions conflict with any of the terms and conditions of the Contract, then, notwithstanding any term in the Contract, the following terms and conditions govern and control the rights and obligations of the parties.

The parties agree to amend the Contract as follows:

Insurance Pursuant to 2021 House Bill 1057, the statutory caps on State liability (N.D.C.C. § 32-12.2-02) increase each year starting July 1, 2022 through July 1, 2026. Therefore, the insurance requires for this contract are being amended.

Contract Section 18, Insurance. Insurance requirements are hereby amended as follows, listed by subsection:

1) Subsection a: Commercial general liability, including premises or operations, contractual, and products or completed operations coverages (if applicable), with minimum liability limits of $2,000,000 per occurrence.

2) Subsection b: The Insurance is hereby amended as follows: Automobile liability, including Owned (if any), Hired, and Non-Owned automobiles, with minimum liability limits of $500,000 per person and $2,000,000 per occurrence.

3) Subsection d: Employer’s liability or “stop gap” insurance of not less than $2,000,000 as an endorsement on the workers compensation or commercial general liability insurance.

Renewal and Extension Contract Section 6, Term of Contract. The Contract commenced on its Effective Date and ends on October 31, 2021 with up to three (3) options to renew the contract for a period of 24 months each.

The parties have agreed to renew or extend the Contract for an additional 24 months; therefore, the contract is amended to change the expiration date to October 31, 2025. The Contract has one (1) renewal remaining. The Contract can be extended for an additional 12 months.

Price Adjustment Exhibit A, Compensation Details. The Compensation Details are hereby amended as follows:

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Job Title/Function Description

Representative hourly rate charged

Senior Mid- Level Junior

Systems Administrator

Responsible for effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure. This individual participates in technical research and development to enable continuing innovation within the infrastructure. This individual is accountable for the following operating systems, applications, and/or technologies: Linux, UNIX, Windows, PeopleSoft, SharePoint, Business Intelligence, Web Services, Identity management, active directory identity service, PowerShell etc.

$164.80 $139.05 $103.00

Oracle/DB2 Database Administrator

Responsible for managing and administering the enterprise Oracle / DB2 database systems, ensuring high availability and performance for The State of North Dakota enterprise applications. Configures and monitors Oracle / DB2 databases running in a 24x7 production environment. Configures and monitors development, test and demonstration databases for multiple applications. Responsible for database tuning, code optimization, and environment configuration and maintenance.

$185.40 $149.35 $103.00

SQL Database Administrator

Responsible for managing and administering the enterprise Microsoft SQL Server database systems, ensuring high availability and performance for City College of Chicago enterprise applications.

Responsible for configuring and monitoring SQL Server databases running in a 24x7 production environment. Responsible for database tuning, code optimization, environment configuration, maintenance, troubleshooting, data recovery, auditing activities and software installations. Ensures accuracy and completeness of data in master files and various support tools. Develops and administers security integrity controls. Creates policies, procedures, and standards relating to database management.

$164.80 $133.90 $97.85

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Data Analyst/BI Developer

Designs, develops and maintains business intelligence solutions. Cleans data using appropriate techniques and programming. Conducts full lifecycle analysis to include requirements, activities and design. Interprets data and analyzes results using statistical techniques and provides complex reports and dashboards. Identifies, analyzes, and interprets trends or patterns in complex data sets. Develops and implements data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. Acquires data from primary and/or secondary data sources and maintains databases.

Uses Excel, SPSS, SAS, R etc. Prepares data and results from analytical scripts to be stored in data warehouse, email, website, Microsoft SharePoint Server, relational and non- relational databases.

$185.40 $154.50 $113.30

Data Warehouse Developer

Maintains and supports on- premise and cloud Data Warehouse platforms (Amazon Redshift, Microsoft Azure SQL DW, Snowflake, Google BigQuery, etc.)

Creates traditional DW schemas using Dimensional and Normalized models. Designs and creates all related extraction, transformation and load of data functions from. Extracts data from relational databases, non- relational sources, external APOs and flat files. Performs data discovery across the organization. Designs and implements Data marts.

Develops and supports Master Data Management data hubs. Designs and implements Data security solutions.

$164.80 $123.60 $97.85

Data Scientist

Identifies data sources, collects, preprocesses and analyses data. Preprocesses structured and unstructured data. Interprets data, analyzes results, builds predictive models and machine-learning algorithms to address business problems. Presents information using data visualization techniques and business intelligence tools e.g. Tableau, PowerBI, etc. Knows R, SQL and Python.

$159.65 $128.75 $97.85

Project Manager

Ensure the project follows the designated project methodology and ensure all work has been defined and documented and adheres to best practices.

Coordinate all project activities, facilitate sessions to close any related gaps that are identified and monitor all aspects of project development on behalf of The State while acting a liaison between the project team, Office of Information Technology (OIT), the end users, the steering committee and other parties to be determined. Ensure adherence to federal and state rules and regulations relative to developing and constructing a project. Develop, review and monitor a master resource schedule and project plan to ensure that the project is completed on time and on budget.

Define all quality targets, standards, assurances, and control procedures.

$195.70 $154.50 $128.75

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Business Analyst

Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and task and workflow analysis.

Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs. Proactively communicate and collaborate with external and internal customers to analyze information needs and functional requirements. Utilize experience in using enterprise- wide requirements definition and management systems and methodologies required. Engage in multiple initiatives simultaneously. Work independently with users to define concepts and under direction of project managers. Drive and challenge business units on their assumptions of how they will successfully execute their plans. Interpret customer business needs and translate them into application and operational requirements. Possess excellent verbal and written communication skills and interact professionally with a diverse group, executives, managers, and subject matter experts. Serve as the conduit between the customer community (internal and external customers) and the software development team through which requirements flow.

Develop requirements specifications according to standard templates, using natural language.

Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.

Act as the liaison between the business units, technology teams and support teams.

$169.95 $133.90 $103.00

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Technical Writer

Demonstrate excellent technical writing skills and ability to conduct peer review of technical documents for grammar, content and style of writing. Document business processes and write detailed functional requirements. Work under tight timeframes. Good organizational skills. Handle sensitive and complex issues with discretion and good judgment. Work with business analysts and product managers in arranging user focus groups to better understand what the users need and want in terms of applications and documentation. Conduct visits with the users to understand how they perform their jobs. Work with business analysts to design and define the screens and reports. Collaborates with the subject matter expert representing the users to ensure that the design meets the requirements. Develop documentation, such as how-to guides, quick references, quick cards, or cheat sheets, using screen mock-ups and use cases. Prepare product announcements, marketing brochures, advertisements, newsletter articles, and marketing specifications. Collaborate with training staff to assemble class materials, CBTs, demos, and other training materials. Give presentations to various development groups, such as the business analyst team, the software engineering team, product managers, etc. Develop forms or web pages for different business units and produce marketing pieces, brochures, or newsletter articles for both internal and external newsletters.

$169.95 $139.05 $97.85

Testing Analyst

Leads and/or assists with all phases and types of testing (Unit, System Integration, Performance, User Acceptance Testing, Parallel Testing, etc.). Conducts regression testing as appropriate. Assists with root cause analysis and elimination of programming and database errors to support the business processes.

Develop and establish quality assurance standards and measures for the information technology services within the organization. This individual will also gather, document, and analyze data in support of business cases, proposed projects, and systems requirements. This will include writing test plans and scripts for tracking defects and fixes in product development, software application development, information systems, and operations systems. The QA Analyst will apply proven analytical and problem-solving skills to help validate IT processes through careful testing in order to maximize the benefit of business investments in IT initiatives.

$139.05 $118.45 $92.70

Web Developer

The Web Developer's role is to build the operations end of the organization's Web sites and keep them running smoothly. This includes designing, building, and implementing new Web pages and sites;

integrating sites with back end applications; migrating legacy applications to the Web.

$169.95 $144.20 $113.30

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

SharePoint Designer

The SharePoint Designer is responsible for implementing custom workflow, collaboration, and document management solutions in Microsoft SharePoint Server using a combination of SharePoint Designer, built-in functionality, and custom web parts provided by our development team or external sources.

$190.55 $154.50 $128.75

SharePoint Developer

The SharePoint Developer is responsible for developing business-changing enterprise solutions with SharePoint and other leading-edge technologies.

The ideal candidate will have experience developing web applications using Microsoft and compatible technologies.

$190.55 $149.35 $123.60

Trainer (Delivery and Development)

The Software Applications Trainer's role is to deliver training to end users in the organization about how to use various types of software programs efficiently and effectively in support of business objectives. This individual is responsible for designing, developing, delivering training and implementing organizational training strategies.

$169.95 $149.35 $103.00

Change Management/Communicatio ns Specialist

The Change Management Specialist's role is to facilitate the adoption of new or improved processes and/or procedures across the organization. These changes in governance could include technology implementations, workforce/human resources transformations, and corporate policies. The Change Management Specialist will oversee the development and deployment of change management methodologies and procedures to guide the adoption process. This individual will apply proven communication, analytical, and problem-solving skills to help maximize the benefit of organizational directives and their business goals.

$180.25 $149.35 $113.30

Information Architect

The Information Architect (IA) guides projects on their overall high level solution approach, engages with the architecture team, and chairs the formal architecture review and approvals meeting. The IA provides oversight to the portfolio of projects engaged with the architecture team. The IA is the owner of the solution architecture process and solution architecture artifacts. The Architect also plans, coordinates, architects, and supervises all activities related to the integration of software programs, applications, and third-party solutions as required to meet the business requirements of the organization.

$204.97 $175.10 $123.60

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

GIS Developer

The Geographic Information Systems (GIS) Developer's role is to coordinate, implement, and manage the organization's Internet-based strategies and initiatives for GIS software. This individual is responsible for ensuring the development and maintenance of applications based upon spatially referenced data and digital mapping. The GIS Manager will also preserve the integrity and design of geographic information databases, as well as manage and direct a team of IT professionals whose purpose is to support GIS functions.

$169.95 $133.90 $108.15

Mobile Applications Developer

Design, develop, and implement mobile applications for various mobile technologies such as iPads, iPhones, Android tablets, and Android phones.

$180.25 $149.35 $118.45

UNIX Administrator

Provide technical support for HP Alpha system (Tru64). Must be able to support various HP SAN systems: 6400, MSA, 8000 and 4400. Must be able to manage disk allocation for both Tru64 systems and various SAN environments. Familiarity with backups and tape libraries.

$180.25 $139.05 $108.15

Integration Specialist

Participate in the planning and coordination of the integration of applications and technologies within the organization’s application integration environment and perform solution development and implementation activities related to it. Recommend best practices for levering new technologies as appropriate.

$195.70 $169.95 $128.75

Functional Analyst

Responsible for complex systems process analysis, design, and implementation. Focus on process analysis and re-engineering with an understanding of functional problems and solutions as they relate to the current and future business environment. Creates process changes by integrating new processes with existing ones and communicating those changes to impacted customers. Recommends and validates quality improvement efforts.

$204.97 $180.25 $139.05

PeopleSoft Technical Developer

Provides programming support in all phases of the software development lifecycle. Develops, tests, maintains, writes software programs, and documents code using a variety of software programming languages, tools, and state-of- the-art computer technology, such as, but not limited to, PeopleTools, PeopleCode, Application Engine, COBOL, SQL/SQR, XML Publisher, Integration Broker, Change Assistant, and Data Mover. Performs upgrades to new versions of PeopleSoft applications and applies maintenance packs and fixes to Oracle/PeopleSoft Applications.

$200.85 $180.25 $139.05

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Security Analyst

Strong technical experience as a PeopleSoft (PS) security developer and administrator is required.

Should be familiar with some or all of the following modules: Campus Solutions, FSCM, HCM and Interaction Hub (Portal). Review current security setup, perform a complete security assessment and offer recommendations to improve, streamline and automate current security, where possible. Complete security and system audits. Work with process leads to develop a security approach that segregates and secures data. Create a security matrix, task plan, timeline and user guide to aid in the security design.

Perform security configuration setup. Gather and document security requirements and infrastructure to be interpreted, maintained and enhanced. Configure and develop security objects using industry best standards. Design a model for application, process, query, definition and row level security. Produce scripts and component interfaces (CIs) to automate and enhance security administration. Define, create and/or grant access to user profiles, permission lists, roles, query and department trees, process profiles, etc. Determine the user profile security sync process between PS pillars and environments. Coordinate and complete system, integration, unit and/or user testing, as appropriate. Set up and schedule recurring processes to update security tables. Maintain and support production. Document all procedures. Provide knowledge transfer and training to The State team members. Skilled in software programming languages, tools, and state-of-the-art computer technology, such as, but not limited to, PeopleTools, Application Designer, Data Mover, SQL, CIs, etc.

$200.85 $180.25 $118.45

Report Developer

Responsible for creating and testing SQL stored procedures to retrieve data from Oracle / DB2 / SQL database sources and other enterprise data systems to develop strategic and operational reports.

Develops tests and executes ad hoc queries, using SQL query or other reporting tools. Produces and distributes data output in various formats as requested (e.g., ftp, email, disk, merged documents, forms, etc.). Tests queries and verifies accuracy of data produced by other development reporting analysts.

$154.50 $133.90 $108.15

Sr. Data Center Engineer

Responsible for ensuring our virtual environment and server infrastructure is maintained consistent with industry standards and continues growth towards a world class datacenter built on reliability, scalability and redundancy. Manage data center design, server implementation and administration. Provide various operating system support functions such as updates/patches, monitoring, clustering, and performance tuning. Perform server management, monitoring backup, backup/replication configuration and reporting, VMWare configuration and optimization

$164.80 $133.90 $103.00

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Cloud Architect

Responsible for creating a well- informed cloud strategy and manage the adaption process. Regularly evaluate cloud applications, hardware, and software.

Develop and organize cloud systems. Work closely with IT security to monitor the company's cloud privacy. Respond to technical issues in a professional and timely manner. Offer guidance in infrastructure movement techniques including bulk application transfers into the cloud. Identify the top cloud architecture solutions to successfully meet the strategic needs of the company.

$216.30 $164.80 $118.45

Cloud System Administrator

The primary job responsibilities of the cloud administrator are to work in coordination with the IT department to develop and support cloud, windows or Unix infrastructure. They usually provide technical assistance on windows, cloud-based systems, and resolve operational problems. The professional will also assist in the administration of cloud service and a Windows server environment. The cloud systems administrator will install and configure the Windows operating system in cloud IaaS providers. The technician usually monitors and analyzes the capabilities and performance of the systems. They compare, evaluate, and implement new technologies, and integrate systems into the computing environment. As a requirement, the cloud systems administrator should have good knowledge of Code Green, Proofpoint, Active Directory, Exchange, Office 365, Azure, AWS, GCP, and other Windows-based technologies. The ability to configure VMs and Web Applications are added advantage.

$190.55 $144.20 $123.60

Full-Stack Developer

Possess proficiency in both front and back-end coding. The technology stack will vary based on the project including but not limited to Node.js and .NET.

Experiences with JavaScript frameworks such as AngularJS, Backbone.js, ReactJS, and presentation frameworks such as bootstrap. Must be comfortable implementing both REST and SOAP APIs

$159.65 $139.05 $108.15

CRM Administrator Proficient in the Administration and Support of one or more CRM platforms, with a good understanding of the best practices of the use of a CRM in a large, complex organization.

$169.95 $133.90 $108.15

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

Senior Information Security Analyst

Assesses information risk and facilitates remediation of identified vulnerabilities within our network, systems and applications. Reports on findings and recommendations for corrective action.

Performs vulnerability assessments as assigned utilizing IT security tools and methodologies. Performs assessments of the IT security/risk posture within the IT network, systems and software applications, in addition to assessments within the Vendor Management Program. Identifies opportunities to reduce risk and documents remediation options regarding acceptance or mitigation of risk scenarios.

Facilitates and monitors performance of risk remediation tasks, changes related to risk mitigation & reports on findings. Maintains oversight of IT and vendors regarding the security maintenance of their systems and applications. IT Security/Risk Analyst assists in all IT audits, IT risk assessments and regulatory compliance.

$204.97 $185.40 $123.60

Cyber Security Analyst

Ensure our software, hardware, and related components are protected from cyber-attacks including developing security systems, analyzing current systems for vulnerabilities. Handling any and all security incidents or attacks in an efficient and effective manner coordinating response across all IT teams. Candidates should have strong IT skills and a deep understanding of cyber hacker methodology.

$185.40 $164.80 $123.60

FileNet Architect

The FileNet Architect (FA) guides FileNet projects on their overall high level solution approach, engages with the architecture team, and chairs the formal architecture review and approvals meeting. The FA provides oversight to the portfolio of FileNet projects engaged with the architecture team. The FA is the owner of the FileNet solution architecture process and solution architecture artifacts. The FileNet Architect also plans, coordinates, architects, and supervises all activities related to the integration of software programs, applications, and third-party solutions as they relate to FileNet to meet the business requirements of the organization.

$204.97 $175.10 $123.60

Filenet Developer The FileNet Developer is responsible for developing business-changing enterprise solutions with FileNet and other leading-edge technologies.

$190.55 $149.35 $123.60

The price adjustment is effective on August 1, 2023.

96 - Data Architecture, Strategy and Technology Consulting Services - Krasan Consulting Services, Inc.

All other terms of the Contract remain in effect. This Contract Amendment is not effective until fully executed by all parties.

EXECUTION

CONTRACTOR STATE OF NORTH DAKOTA

Krasan Consulting Services, Inc. Acting through its Information Technology Department

BY:

BY:

Printed Name: Pavithra Karumuri Printed Name: Greg Hoffman

Title: President & CEO Title: Director, Administrative Services

Date: 7/17/2023 Date:

STATE OF NORTH DAKOTA

Acting through its ND State Procurement Office

BY:

Printed Name: Tricia Opp

Title: IT Procurement Officer

Date:

07/31/2023

07/31/2023 https://na2.documents.adobe.com/verifier?tx=CBJCHBCAABAAe8kq_Zpxoh3x5CISVa_6olz_6TDU9IVo https://na2.documents.adobe.com/verifier?tx=CBJCHBCAABAAe8kq_Zpxoh3x5CISVa_6olz_6TDU9IVo

112-1921 Contract Amendment - Krasan Consulting Services Final Audit Report 2023-07-31

Created: 2023-07-28

By: Tina Berger (bergertina@nd.gov)

Status: Signed

Transaction ID: CBJCHBCAABAAe8kq_Zpxoh3x5CISVa_6olz_6TDU9IVo

"112-1921 Contract Amendment - Krasan Consulting Services" History

Document created by Tina Berger (bergertina@nd.gov)

2023-07-28 - 7:25:29 PM GMT

Document emailed to Tricia Opp (topp@nd.gov) for signature

2023-07-28 - 7:26:46 PM GMT

Email viewed by Tricia Opp (topp@nd.gov)

2023-07-31 - 12:45:23 PM GMT

Document e-signed by Tricia Opp (topp@nd.gov) Signature Date: 2023-07-31 - 12:46:09 PM GMT - Time Source: server

Document emailed to Greg Hoffman (gahoffman@nd.gov) for signature

2023-07-31 - 12:46:10 PM GMT

Email viewed by Greg Hoffman (gahoffman@nd.gov)

2023-07-31 - 4:20:28 PM GMT

Document e-signed by Greg Hoffman (gahoffman@nd.gov) Signature Date: 2023-07-31 - 4:20:34 PM GMT - Time Source: server

Agreement completed.

2023-07-31 - 4:20:34 PM GMT