Attachment 1 Draft PWS.docx

U.S. DEPARTMENT OF HOMELAND SECURITY

Immigration and Customs Enforcement Office of Enforcement and Removal Law Enforcement Systems and Analysis

PROFESSIONAL SUPPORT SERVICES FOR DEPLOYMENT, TRANSFORMATION, ANALYSIS, AND DOCKET MANAGEMENT Performance Work Statement (PWS)

Confidentiality Statement WARNING: This document is FOR OFFICIAL USE ONLY (FOUO). It contains information that may be exempt from public release under the Freedom of Information Act (5 U.S.C. 552). It is to be controlled, stored, handled, transmitted, distributed, and disposed of in accordance with DHS policy relating to FOUO information and is not to be released to the public or other personnel who do not have a valid “need-to- know” without prior approval of an authorized DHS official.

LESA Support Services PWS Page: 1

Performance Work Statement

1.0 PURPOSE

The purpose of this PWS is to obtain contractor support and disciplines to conduct analysis to ensure better accountability, consistency, and efficiency of statistical reports, briefing papers, and responses to requests from DHS, Congress, and the White House. The contractor will provide deployment support for ICE Information Technology (I.T.) initiatives, operations research and strategic analytics, and business process analysis and transformation project support. Tasks focus on, but are not limited to, efforts designed to generate improvements in the immigration enforcement lifecycle.

Support will include conducting business process and requirements documentation sessions with varied stakeholder groups, process analysis studies, white papers, feasibility studies, cost-benefit analyses, configuring software support tools, piloting recommendations, developing implementation plans for operational changes, and developing training content. Implementation plans should incorporate input from as many stakeholders as feasible to encourage ownership and operational support. LESA will manage these efforts through existing ICE structures that include Integrated Project Teams (IPT) and Working Groups (WG).

2.0 BACKGROUND

The ERO Law Enforcement Systems and Analysis (LESA) division is responsible for helping inform the development of ERO strategies and supporting continuous enhancement of ERO business processes to execute those strategies. Through data collection and analysis and technology and process improvements, LESA delivers tools, studies, and recommendations that assist ICE’s decision-making and planning (strategic, business, and operational). LESA studies ICE’s operations and resources (personnel, processes, technology, and infrastructure) to find areas for continuous improvement.

LESA’s service offering is comprised of seven major operational units, five of which will seek operational support that ensure the right resources are in the right place, and that agency-wide, ICE is making better, more informed decisions:

Deployment and Transformation Unit: The Deployment and Transformation (D&T) Unit provides project management and business analysis support to ensure that identified business needs can be met through business process improvements, technological enhancements, and greater internal or external information sharing. D&T comprises two sections. The Deployment Training and Communications section facilitates system deployment and releases, as well as training and communication planning across LESA. The Transformation Programs section oversees the Title 8 (T-8) portfolio and facilitates the development and management of new technical solutions.

Strategy and Operations Analysis Unit: The Strategy and Operations Analysis (SOA) Unit provides strategic support through organizational planning, workforce analysis and planning, and implementation planning; and analyzes ERO and stakeholder data to provide historical and real-time evaluation of agency metrics such as yearly removals, estimated detention space levels, as well as subsequent criminal activity assessments.

Information Technology Management Unit: The Information Technology Management (ITM) Unit generates business requirements to ensure I.T. systems meet the operational and reporting needs of each AOR, ERO leadership, and all stakeholders. ITM coordinates the prioritization of I.T. solutions as well as develops new and modernizes existing technologies in support of ICE objectives.

Statistical Tracking Unit: The Statistical Tracking Unit (STU) is the official statistical reporting unit for ERO. STU ensures the accountability, consistency, and efficiency in the statistical reporting of ERO operations. STU supports the analysis of key performance metrics by establishing and maintaining key reports/queries. STU also assesses barriers to the ICE Integrated Decision Support System (IIDS) reporting system/Enforcement Operational Records System (ENFORCE) and develops action plans for improvement.

Data Quality and Integrity Unit: The Data Quality and Integrity (DQI) Unit is dedicated to improving the accuracy and reliability of immigration enforcement and removal data. DQI supports ERO by ensuring that data is correctly entered in Immigration and Customs Enforcement (ICE) systems, information is compliant with policy and best practices, and that data quality assessment and measurement standards are applied throughout the ERO immigration lifecycle.

3.0 SCOPE

The Contractor will be required to provide support in six main areas: (1) Deployment and Transformation Support; (2) Strategy & Operations Analysis Support including (3) I.T. Information Technology Management Support, (4) Statistical Tracking and Enterprise Analysis Support; (5) Data Quality and Integrity Support.

4.0 TASK DESCRIPTIONS

1) ALL UNITS SUPPORT

The following tasks and activities represent areas where all the 5 identified LESA Units require professional services contract support for law enforcement systems programs, analysis, and operations. The Contractor shall:

· Provide onboarding and training of its new staff as well as continued training for current staff with the introduction of new methodologies, business tools or other emerging technologies. Training plans should include documentation that is delivered to federal staff and management.

· Develop and maintain onboarding and offboarding guidance for all contractor and federal staff that focus on LESA equities, projects, and collaboration.

· Develop and use a process/methodology to validate all work before delivery to government to ensure all deliverables shall be timely, accurate and free of error.

· Proactively coordinate with LESA leadership in ensuring proficient coverage and sufficient to include coverage for staffing lapses and absences and successfully deliver all tasks and duties as specified in this contract timely, accurate and free of error.

· Review, organize, and manage all records per ICE Records and Information Management Unit guidelines

· Demonstrate proficiency in both the DHS acquisition lifecycle and the ICE acquisition and budgetary processes.

· Maintain and update a centralized repository of governance documentation, including DHS and ICE procedural documents, governance body artifacts (charters, rosters, etc.), meeting agendas, presentations, and minutes.

· Provide specialized expertise in Project Management, Portfolio Management, Risk Management, Business analysis, and Change Management to support project success.

· Provide an experienced Project Manager for each unit to manage the daily workflow of their assigned unit to include on-time deliverables, communicating with the Unit Chief and other federal staff on methodologies, report approaches, and other as needed projects, and to serve as liaison with other Contractor POCs in other LESA Units.

· Provide comprehensive program and project management support including consultation and recommendations on strategic initiatives, development and tracking of integrated master schedules, development of operational baseline data, key performance indicators, and performance metrics, and development of reporting mechanisms to track project impacts and return on investment.

· Develop and maintain project management plans and best practices including effective resource management including project execution and staffing coordination

· Establish, execute, and track deployment plans to include facilitating stakeholder discussions, scheduling required meetings and events, developing briefing materials, drafting summary notes, and documenting lessons learned.

· Communicating directly with Governance Chairs, member and presenters, develop stakeholder engagement and communication plans, meeting topics, and agendas for projects and communicate business information in a variety of formats depending on the intended audience (e.g. talking points, broadcast messages, PowerPoint presentations).

· Develop Risk Management plans and coordinate non-technical risk activities for new and existing projects.

· Provide requirements gathering, elicitation and/or refinement to include facilitating working groups, documenting discussions, and creating action plans.

· Conduct thorough system analyses and propose recommendations for enhancement, including system requirements. Provide ongoing support for requirements gathering, facilitate working groups, document discussions, and create action plans and roadmaps.

· Develop requirements for emerging needs to include but not limited to prototypes, operational scenarios, concepts of operations documents, workflow diagrams, etc.

· Provide consulting services, included but not limited to recommended process improvements, best practices, change management controls, improvements to standard operating procedures, emerging technologies, and innovative solutions to business challenges. Deliverables may include lunch and learns, presentations, demonstrations, and other appropriate delivery mechanisms.

· Maintain knowledge of the immigration enforcement lifecycle and be able to assess and advise on proposed policy, regulatory, legal, and budget changes that can impact DHS, ICE, ERO, and LESA equities.

· Maintain knowledge of ICE and ERO structure and mission/equites of in components parts and be able to assess and advise on collaborative opportunities with other mission supporting entities.

· Proactively identify, analyze, report on, and support business process improvements including policy updates and documentation in line with new legislation, executive orders, DHS or ERO wide policy changes, and/or budget constraints, and field office standard operating procedures that potentially impact ERO and LESA projects.

· Support cross-functional operations management and related collaboration between ERO divisions and Field Offices.

· Proactively identify and foster collaborative efforts across LESA units to facilitate cross-unit collaboration, identify dependencies, risks, and redundancies and propose recommendations and promote optimization opportunities.

· Proactively identify and communicate risks and dependencies, offer recommendations, and facilitate resolutions within and across projects to ensure proactive mitigation and resolution between project stakeholders.

· Proactively conduct comprehensive analysis of project capabilities and identify key interdependencies.

· Develop and maintain plans for project and system standardization for improving ERO systems and ensuring adherence to best practices.

· Provide near real time response to LESA requests for information and ad-hoc requests related to LESA operations and contingency scenarios to facilitate decision support.

· Support all ad-hoc activities, requests, model, and tool enhancements, prioritizing and validating requests with LESA stakeholders.

· Provide onsite support and subject matter expertise as requested by federal staff, to include but not limited to, meetings, working groups, training sessions, etc.

· Manage group mailboxes efficiently and prioritize requests to ensure timely response and resolution.

· Provide relevant metrics on task execution, backlog management, and testing completion to track project progress effectively.

2) DEPLOYMENT AND TRANSFORMATION SUPPORT

The following tasks and activities represent areas where LESA Deployment and Transformation (D&T) requires professional services contract support for law enforcement systems programs, analysis, and operations. D&T’s anticipated staffing for the following tasks and activities:

· Project Manager: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree, PMP certified.

· Technical Writer: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Integration Support: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Assistant Project Manager (Lead): at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree, preferably PMP certified.

· Management Analyst (Transformation Section Lead): at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Training and Development Specialist (Deployment Section Lead): at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Management Analyst: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Training and Development Specialist: at least two (2), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Operations Research Analyst: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

Task 4.2.1: Support of the Transformation Programs Section With regards to Support of the Transformation Programs Section, the contractor shall:

· Provide personnel with expertise supporting the Acquisition Lifecycle Framework (ALF) and the Systems Engineering Lifecycle (SELC).

· Provide subject matter expertise with business intelligence and data visualization tools, concepts, design principles, methodologies, and approaches in support of system and business reporting efforts. Specific tools to include but not limited to Power BI, ServiceNow, Tableau, and Qlik.

· Develop standardized test plans and scripts in support of universal acceptance testing of new systems and system enhancements.

· Organize and track D&T tasks of varying complexity in an automated fashion. Potential solutions include but are not limited to JIRA, Excel, Access (integrated master schedules), SharePoint, Visio etc.

· Provide Cloud computing consulting and expertise on platforms such as ServiceNow, Salesforce, AWS, and Azure.

· Provide expertise in planning and evaluating user interface and user experience (UI/UX) for new projects and systems.

· Develop plans and best practices to facilitate the transition of projects in active development to operations and maintenance (O&M).

· Prepare analysis and reports utilizing data produced by D&T systems.

· Support the planning and transition of D&T system data to enable dashboarding and reporting by other LESA Units.

Task 4.2.2: Support of the Deployment, Training & Communications Section With regards to Support of the Training & Communications Section, the contractor shall:

· Provide personnel with expertise in:

· ADDIE, SAM, adult learning theory, Blooms Taxonomy, and models for developing and evaluating adult learning content (Kirkpatrick).

· SCORM

· 508 Compliance

· Graphic design

· Technical writing and editing

· Facilitation skills

· E-authoring tools such as Adobe Captivate and Articulate Storyline

· Video and Audio development expertise.

· Microsoft products such as Teams, PPT, Word, and Excel for hosting live training and deployment events, developing detailed documentation, impactful briefings, and elaborate deployment plans.

· Adobe Creative tools (e.g., Illustrator, InDesign, Photoshop, and Dreamweaver), Microsoft Visio, and PowerPoint.

· ServiceNOW

· Provide pre-deployment/planning:

· Conduct needs assessments to determine training needs

· Identify creative solutions to user adoption challenges

· Provide instructional systems design expertise

· Author data calls and surveys

· Develop customer support packages for establishing helpdesk support

· Provide deployment support:

· User Acceptance Training

· Draft/revise testing scripts

· Conduct testing

· Facilitate testing

· Summarize and present findings of testing

· Create and execute well-thought out, effective deployment communications plans.

· Plan for and lead change management initiatives to increase user adoption of systems

· Provide post-deployment support:

· Manage group mailboxes and triage user requests

· Serve as Tiered support for help desk when necessary

· Manage SharePoint and knowledge base repositories of training materials

· Author training products such as QRGs, one-pagers, videos, knowledge articles

· Draft communications

· Outages

· Enhancements

· Bug Fixes

· Participate in meetings and extrapolate training needs

3) STRATEGY & OPERATIONS ANALYSIS SUPPORT

The following tasks and activities represent areas where LESA Strategy & Operations Analysis (SOA) requires professional services contract support for law enforcement systems programs, analysis, and operations. SOA’s anticipated staffing for the following tasks and activities:

· Project Manager: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree, PMP certified.

· Technical Writer: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Assistant Project Manager: at least one (1), LCAT - Senior, over 10 years of experience and an MA/MS degree, preferably, PMP certified.

· Integration Support: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Immigration LE Process & Data SME: at least one (1), LCAT – Senior/SME, over 10 years of experience and an MA/MS degree.

· Senior Operations Research analyst: at least two (2), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Data Scientist II: at least two (2), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Strategic Planner: at least one (1), LCAT - Junior, up to 3 years of experience and a BA/BS degree.

· Business Process Improvement Specialist: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Senior Data Scientist: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· GIS Specialist: at least one (1), LCAT – Junior, up to 3 years of experience and a BA/BS degree.

· Senior Data Scientist: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Operations Research Analyst: at least one (1), LCAT – Junior, up to 3 years of experience and a BA/BS degree.

Task 4.3.1: Predictive Analytics & Modeling With regards to Predictive Analytics and Modeling, the contractor shall:

· Identify gaps for LESA decision support tool development and improvement including opportunities to collect new data, improve data quality, and improve forecasting methodologies, reporting, and scenario planning capabilities.

· Develop, maintain, and enhance the LESA suite of Discrete Event Simulation (DES) models to better capture all components of the Immigration Enforcement and Removal Lifecycle.

· Evaluate the use of current and other modelling technology and BI platform types as appropriate, including, but not limited to: Python, GitHub, Qlik, Tableau, ArcGIS, Databricks

· Maintain and improve LESA-related geospatial capabilities.

· Maintain and improve the Transportation-Bed Space Optimization Decision Support Tool.

· Maintain and improve automated data gathering including, but not limited to, G-391 data processing and quality checks.

· Streamline reporting on key performance indicators across the data and visualization enterprise promoting information sharing among field and HQ stakeholders.

· Promote interoperability of products with other LESA DES models as needed to enhance decision-making and forecasting.

· Support all ad-hoc activities, requests, model, and tool enhancements, prioritizing and validating requests with LESA stakeholders.

· Perform recurring model maintenance, support, and governance.

· Prepare models for official DHS accreditation including supporting model documentation that describes the underlying design and methodology for the model’s concept and its constituent parts, addresses the model’s requirements, how the model is used to inform any decision-making processes, analysis of alternatives for methodology chosen, engagement with stakeholders, etc.

Task 4.3.2: Strategy Planning & Assessment ERO will receive logistics, strategy, policy, and change management subject matter expertise to advise ERO leaders on recommendations related to ERO structure, roles, responsibilities, and the overall management of ERO. With regards to Strategy, Planning, and Assessment, the contractor shall:

· Evaluate and recommend logistics systems, processes, and tools for implementation to support the connection of activities, to include the evaluation of commercial-off-the-shelf tools that could significantly streamline ERO operations and data reporting.

· Provide business process re-engineering and requirements gathering assistance to support the creation of electronic data capture and management systems and support enabling implementation activities such as process standardization and change management support.

· Create user guides and standard operating procedures and host training for impacted CORs, contract detention officers, and/or ERO law enforcement and admin support personnel who are impacted by any process change.

· Perform change management activities to streamline adoption of tools and technique to create process efficiencies within headquarters and the field.

Task 4.3.3: Data Visualization & Engineering With regards to Data Visualization and Engineering, the contractor shall:

· Identify, design, and develop visualizations on all LESA data.

· Develop and enforce data collection policies to ensure processes and procedures comply with all DHS and ICE standards and laws related to data.

· Determine the correct type of data to be collected and identify the resources with which to effectively collect them.

· Develop techniques that collect accurate data effectively.

· Identify data resources and researching historical data.

· Integrate different types of data, including structured and unstructured data, from disparate sources.

· Test data outcomes.

· Analyze data to identify patterns and insights.

· Present data in an organized manner using visualization techniques.

· Incorporate new data from systems as required.

· Design and build data pipelines, ensuring a smooth data flow from multiple sources to data warehouses or lakes.

· Mitigate algorithmic biases by ensuring that data pipelines are designed with fairness and transparency.

· Design systems that can handle large volumes of data, ensuring that as an organization grows, its data infrastructure can scale accordingly.

· Facilitate the review, storage, and integration of data into ICE’s various data analytics and engineering environments and other data engineering tools to support the reporting and analysis of data.

· Perform extract transform load (ETL) operations to transform raw data into a format suitable that analysts and data scientists can use for modeling and analysis.

· Implement security measures to protect sensitive data, essential for maintaining trust and compliance with data privacy regulations.

· Implement data cleaning and validation processes to enhance data accuracy and consistency.

· Include automated data quality reviews for data that is collected through the ERO reporting process and Operations Support Division’s invoice reconciliation processes.

· Complete documentation on data engineering practices to include continuity guides such as standard operating procedures.

Task 4.3.4: Advanced Research & Studies ERO will receive subject matter expertise surge capabilities to support special projects such as rapid development of proof of concepts, prototypes, and logistics analysis in response to congressional inquiries, unanticipated changes in policy or operations, and ERO strategic logistics related initiatives as requested.

With regards to Advanced Research & Studies, the contractor shall:

· Be able to rapidly deploy to conduct focused and discrete support for special projects relating to:

· Rigorous academic research and evidence building to support transformation and resource requirements supporting modernization of LESA process and technology.

· Issue investigation, root cause identification, best practice evaluation, recommended remedial actions and recommended recurrence controls.

· New process development and implementation,

· Change management support and field deployment of prototypes or new technologies,

· Data collection or information gathering modernization assistance.

4) I.T. MANAGEMENT SUPPORT

The following tasks and activities represent areas where LESA Information Technology Management (ITM) requires professional services contract support for law enforcement systems programs, analysis, and operations. ITM’s anticipated staffing for the following tasks and activities:

· Project Manager: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree, PMP certified.

· Technical Writer: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Assistant Project Manager: at least one (1), LCAT - Senior, over 10 years of experience and an MA/MS degree, preferably PMP certified.

· Integration Support: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Senior Analyst: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Senior Analyst: at least two (2), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Analyst: at least two (2), LCAT – Junior, up to 3 years of experience and a BA/BS degree.

· Portfolio Support Senior analyst: at least one (1), LCAT – Senior/SME, over 10 years of experience and an MA/MS degree.

· Data Analytics SME: at least one (1), LCAT – SME, 3 to 10 years of experience.

· Data Scientist: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

· Automation Developer: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/MS degree.

Task 4.4.1: Managing IT Projects IT Project management support spans a wide range, encompassing both systems in Operations and Maintenance (O&M) and new initiatives. Our methodology integrates agile development frameworks like Scrum and Kanban, ensuring projects maintain flexibility, adaptability, and efficiency from inception to completion. We provide comprehensive support across all project stages—from initial planning and requirement gathering to execution, monitoring, and continuous maintenance. Our focus is on iterative development, fostering continuous improvement, and promptly addressing evolving requirements and stakeholder expectations. To help ITM achieve these goals, the contractor shall:

· Author user stories to facilitate Agile Development processes.

· Represent the Product Owner in Agile Ceremonies to ensure alignment with project goals and priorities.

· Author, maintain, develop, and execute User Acceptance Tests (UAT), documenting bugs, system improvements, and managing testing efforts throughout the system development life cycle.

· Offer expert knowledge in software development, requirement management, testing, and deployment across the full Software Development Life Cycle (SDLC).

Task 4.4.2: Managing the Portfolio of IT Projects IT Portfolio Management Support involves monitoring both ERO-funded and non-ERO funded IT financial investments. The process assesses the health of IT projects across various stages, including pre-acquisition and acquisition, focusing on aspects such as scope, schedule, cost, and risks/issues. Additionally, the contractor will gather project health information through interactions and meetings with interactions and meetings with project stakeholders. This includes performing detailed project analysis, such as reviewing schedules and requirements. In this capacity, the contractor shall:

· Provide inputs for the LESA Quarterly Congressional Report and Monthly Executive Steering Committee (ESC) meetings managed by LESA. Interact with OCIO and its customers to validate project status content for both the Quarterly Congressional Report and the ESC.

· Review and analyze project scope, schedule, requirements, and other ICE Systems Lifecycle Management (SLM) documentation thoroughly

· Identify IT investment risks/issues that may necessitate LESA involvement in business process and requirements analysis. The contractor will communicate these needs to LESA for prioritization and execute remedies according to a mutually agreed-upon plan.

· Develop agendas and propose meeting topics for consideration by PSO leads.

· Upon finalizing all documentation, ensure accessibility and storage within the PSO Team.

· Review and update ERO Executive Steering Committee and Configuration Management Board rosters as necessary.

· Collaborate with PSO leads to communicate changes to the relevant ERO offices and update corresponding documentation promptly.

Task 4.4.3: Data Management / Automation The Data Management and Automation functions within ITM oversee critical functions related to data management, automation, reporting, and business intelligence requirements within the organization. This unit is dedicated to ensuring the integrity and accessibility of data across all ERO systems and processes. By implementing robust data automation solutions and efficient data management strategies, ITM supports streamlined operations and informed decision-making throughout the ERO. In support of this, the contractor shall:

· Provide subject matter expertise in database and data warehousing concepts, design principles, methodologies, and approaches to support system development efforts.

· Provide subject matter expertise in Business Intelligence tools, concepts, design principles, methodologies, and approaches to support system development efforts.

· Collaborate with stakeholders to gather and analyze data requirements for business intelligence and reporting purposes.

· Provide training and support to users on data management tools and best practices to promote data literacy within the organization.

· Implement data management policies and procedures to maintain data integrity and compliance with agency data management standards.

· Develop, deploy, and maintain automated processes for data ingestion, transformation, and validation to enhance operational efficiency and data accuracy.

· Collaborate with data engineers and architects to evaluate infrastructure improvements to support the scalability and performance of AI/ML workloads within the organization.

· Enhance data governance and metadata management practices to ensure the quality and lineage of data used for AI/ML applications.

5) STATISTICAL TRACKING AND ENTERPRISE ANALYSIS SUPPORT

The following tasks and activities represent areas where LESA Statistical Tracking Unit (STU) requires professional services contract support for law enforcement systems programs, analysis, and operations. STU’s anticipated staffing for the following tasks and activities:

· Project Manager: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree, PMP certified.

· Technical Writer: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Assistant Project Manager: at least one (1), LCAT - Senior, over 10 years of experience and an MA/MS degree, preferably PMP certified.

· Integration Support: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Immigration LE Process & Data SME: at least one (1), LCAT – Senior/SME, over 10 years of experience and an MA/MS degree.

· Data Scientist: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Data Scientist: at least two (2), LCAT – Journeyman, 3 to 10 yeasr of experience and a BA/BS or MA/MS degree.

· Data Scientist: at least one (1), LCAT – Junior, up to 3 years of experience and a BA/BS degree.

· Statistician: at least two (2), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS degree.

· Data Engineer: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Data Engineer: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS degree.

Task 4.5.1: Transition Plan & Training With regards to Transition Plan & Training, the contractor shall:

· Draft Transition Plan to include timeline for FTE staff onboarding, staff resumes including skillset matrices, timeline for training and taking over report deliverables, shift schedule for coverage from 7 am – 7 pm EST for normal hours of operation, and initial onboarding training plan by the end of the first week of the contract transition period to the STU Unit Chief.

· Provide a copy of any onboarding training materials to be used for federal staff review and comment by the first week of the contract transition period to the STU Unit Chief.

Task 4.5.2: Project Management With regards to Project Management, the contractor shall:

· Meet with Unit Chief and federal staff on bi-weekly basis to communicate any contract staffing changes, work schedule coverage, status on any taskings and other assigned projects, propose new process improvements, and recommendations for new projects. Deliverable report should be provided at bi-weekly meeting with STU Unit Chief.

· Provide, in writing, to the STU Unit Chief any staffing changes accompanied by an incoming staff resumes with skillset matrices to the STU Unit Chief, in writing, minimum of two weeks prior to the FTE onboarding.

· Be responsible for any subsequent onboarding of own staff and will provide, in writing, to the STU Unit Chief confirmation that new staff has been properly onboarded post two weeks of the new staff member’s start date.

· Provide the STU Unit Chief, in writing in advance, any major schedule changes impacting the 7 am – 7 pm EST normal hours of operation, and, based upon business needs communicated by the federal staff, potential POC for any high priority requests occurring over the weekend and holidays.

Task 4.5.3: Methodology & Business Requirements With regards to Methodology & Business Requirements, the contractor shall:

· Provide subject matter expertise and active participation in any methodology and reporting requirements meetings with STU, or other stakeholders as requested by the STU Chief or federal staff.

· Provide all creation of and/or maintenance of methodology documentation, standard operating procedures, user guides, and validation documentation as directed by the STU Unit Chief and in consultation with the federal staff.

· Gather and draft business requirements to develop or adapt existing business rules and reporting methodologies, participate in the testing and validation procedures of the business rule implementations, and provide final training documentation as directed by the STU Unit Chief.

· Provide Data Quality Monitoring and Recommendations by Analyzing data to identify patterns and insights, including any data quality issues, document, provide any recommendations, and report to the federal staff in writing.

· Streamline methodology updates, data queries, immigration lifecycle variables, and future changes on processing tools by reporting on key performance indicators across the data and visualization enterprise. Bridge the gap by promoting and improving information sharing among LESA, ERO and DHS--OHSS stakeholders.

· Promote interoperability of methodologies within products with other LESA and ERO models as needed to enhance reporting and decision-making and provide recommendations to the STU Unit Chief in a timely and accurate manner.

Task 4.5.4: Data Visualization & Engineering (Reporting) With regards to Data Visualization & Engineering (Reporting), the contractor shall:

· Provide all report deliverables in the standard formatting, follow the STU standard operating procedures for creation, documentation, storage, validation, and maintenance of these reports.

· Gather business requirements, design, and execute recurring reports from databases of record, at the prescribed frequency, for fed staff review.

· Gather business requirements, design, and execute reports to provide deliverables for federally directed taskings.

· Conduct daily, or as requested by federal staff, peer reviews of deliverables in support of the tasking validation process in writing. Complete a “Weekly Population Report Validation” Process by validating all standard populations and filters by the first business day of each week in the system(s) of record as identified by the federal staff, identify, and report any data quality issues to report to federal staff. Deliverable(s) will be communicated in writing by the 3 pm EST on the first business day of each week to federal staff.

· Support all ad-hoc activities, requests, model, and tool enhancements, prioritizing and validating requests with LESA stakeholders. Contractor will work with the STU Unit Chief and federal staff to determine delivery mechanisms and deadlines.

Task 4.5.5: EOFY Management & Official Reporting Process With regards to EOFY Management & Official Reporting Process, the contractor shall:

· Provide project management and lead the STU team in the EOFY Management & Official reporting process for LESA that includes end of fiscal year reporting process, locking official statistics and reporting, preparing for the new fiscal year reporting. Status updates should be included in the bi-weekly briefing with the STU Unit Chief or appropriate meeting cadence as determined by the STU Unit Chief.

· Develop a project management plan to include schedules, communications plan, scheduled meetings with various LESA and OCIO stakeholders, and list of final deliverables with delivery schedule to the STU Unit Chief and in consultation with federal staff. Initial draft plans should be submitted by the STU Unit Chief no later than first day of June prior to the end of each fiscal year in writing with subsequent updates provided on an as determined cadence between Contractor and STU Unit Chief through September of fiscal year. Deliverables shall be timely as determined by the STU Unit Chief, accurate, and free of errors.

· Schedule and lead a kick-off presentation with STU, ITM and OCIO to determine the technical logistics for “locking the data” including but not limited to: providing a business requirements delivery schedule, user acceptance testing schedule, recommendations for official “lock” schedule as well as discuss options such as ETL pauses, point-in-time reporting, archival of database and populations, as well as validation and implementation of any new fiscal year reporting. Kick-off presentation should be scheduled in June prior to the end of each fiscal year. Deliverables shall be submitted in appropriate electronic form to the STU Unit Chief no later than last day of June prior to the end of each fiscal year with subsequent updates provided on an as determined cadence between Contractor and STU Unit Chief through October of fiscal year.

· Provide project management and subject matter expertise in the following areas:

· Create, in appropriate electronic format, the tracking from delivery to sign-off of EOFY process to include the kick-off of the new fiscal year reporting.

· Conduct fiscal annual report and population audits and provide recommendations in writing to the STU Unit Chief, including but not limited to, identification of reports impacted by end of fiscal year or kick off of the new fiscal year of reporting with any recommended changes, assessment for any reports that can be retired, and identification of data quality issues that should be documented and submitted to DQI and/or ITM. Deliverables shall be comprehensive, timely, accurate, and free of errors.

· Gather business requirements, design, document, create/update, and validate and test any new methodologies or reports in consultation with federal staff, as required for the end of fiscal year process or the kickoff of the new fiscal year of reporting. Deliverables shall be comprehensive, timely, accurate, and free of errors.

· Validate all standard populations and filters for the EOFY “population reports” that will be locked, identify, and report any data quality issues immediately to federal staff and work with OCIO to quickly validate any changes. Delivery deadlines will be determined based upon the pre-approved schedule determined between Contractor and STU Unit Chief for October.

· Validate all standard populations and filters for the new fiscal year “population reports”, including relevant filter changes, identify, and report any data quality issues immediately to federal staff and work with OCIO to quickly validate any changes. Delivery deadlines will be determined based upon the pre-approved schedule determined between Contractor and STU Unit Chief for October.

· Schedule and lead all meetings, with appropriate stakeholders as directed by the STU Unit Chief, required for the EOFY process, and kick off the new fiscal year reporting and be responsible for appropriate documentation for presentation, after-action items, and minutes as determined by the Contractor and STU Chief. Deliverables shall be timely as determined by the STU Unit Chief, accurate, and free of errors.

· For the ERO EOFY Report, provide project manager support to STU, LESA and ERO-ICE as required for delivery of the ICE ERO EOFY Report, to include providing all supporting EOFY official statistics, compiling data, drafting documentation and appropriate footnotes, and provide in the appropriate delivery format determined by federal stakeholders, in a timely, accurate and free of errors.

Task 4.5.6: IIDS Development/Technology With regards to IIDS Development/Technology, the contractor shall:

· Co-lead recurring STU working groups as needed for moderation of the meetings, and any after-action items to be communicated out. Deliverables shall be timely, accurate, and free of errors.

· Provide subject matter expertise in any STU working groups, including the STU Database Working Group, and actively participate in activities such as, but not limited to:

· Identify gaps for LESA business tool development and improvement including making recommendations for opportunities to collect new data, improve data quality, and improve business reporting in consultation with federal staff to report to STU Unit Chief.

· Identify business use cases, draft technical requirements for ITM for those use cases, provide user acceptance testing and validation of said-requirements, draft methodology documentation and provide training to STU and other LESA stakeholders. Deliverables shall be timely, as dictated by the development release cycle or other federally directed timeline, accurate, and free of errors.

· Integrate different types of data from disparate sources, including structured and unstructured data, and make report recommendations and considerations to federal staff and STU Unit Chief.

· Provide status updates on the Contractor work in these STU Working groups to the STU Unit Chief as part of the bi-weekly meetings.

· Work in consultation with federal staff and attend recurring ITM-OCIO meetings (bi-weekly or weekly) to determine the kind of data to be collected, identify the resources with which to effect data collection, organize, implement, and enforce correct data collection policies and methods, and ensure compliance with all DHS and ICE standards and laws related to data.

· Be able to gather business requirements, design, document, and create or update dashboards using the current business tools as well as provide demonstrations to federal staff. Deliverables, including dashboard and documentation in writing, shall be timely, accurate, and free of errors.

· Provide any recommendations for any report or validation automation processes to federal staff in the form of documentation including methodology and relevant operation and maintenance plan, and demonstration to federal staff for sign-off prior to implementation.

· Develop and execute User Acceptance Tests to validate enhancements to the reporting databases and supporting tools. Deliverables shall be timely, and accurate as dictated by the release schedule, at least monthly.

· Provide support for governance documentation requirements and participation as directed by the STU Unit Chief and in consultation with the federal staff.

· Provide consulting service on the following subject areas: technical and business methodologies, training best practices, business Intelligence tools, and emerging technologies in the data science field. Deliverables must be timely and may be through presentations, demonstrations, written or another appropriate format as determined by the Contractor and STU Unit Chief.

· Evaluate the use of current and other business tools and methods as appropriate and provide recommendations for best practices based upon subject matter expertise including but not exclusively: Tableau, GIS, Python, QLIK, Databricks. Deliverables must be timely and may be through presentations, demonstrations, written or another appropriate format as determined by the Contractor and STU Unit Chief.

6) DATA QUALITY AND INTEGRITY SUPPORT

The following tasks and activities represent areas where LESA Data Quality and Integrity (DQI) requires professional services contract support for law enforcement systems programs, analysis, and operations. DQI’s anticipated staffing for the following tasks and activities:

· Project Manager: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree, PMP Certified.

· Technical Writer: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Assistant Project Manager: at least one (1), LCAT - Senior, over 10 years of experience and an MA/MS degree, preferably PMP certified.

· Integration Support: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Senior Data Scientist: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Senior Data Scientist: at least one (1), LCAT – Senior, over 10 years of experience and an MA/MS degree.

· Data Scientist II: at least one (1), LCAT – Journeyman, 3 to 10 years of experience and a BA/BS or MA/BS degree.

· Immigration LE SME: at least one (1), LCAT – SME, 3 to 10 years of experience.

Task 4.6.1: Project Management With regards to support of the Data Quality and Integrity Unit, the contractor shall:

· Support D&T to develop and coordinate training, training materials, and visualization for DHS systems. of record end-users on how to use the system(s) developed along with documentation in confluence.

· Identify potential ERO data quality issues and develop methods to resolve them to include addressing training gaps; providing recommendations to enhance system usability; evaluating and offering solutions to resolve historical data errors; identifying opportunities to implement automation to resolve data quality issues.

· Develop, improve, and maintain the DQI task tracker to ensure complete accountability of all tasks assigned and current statuses.

· Train fed staff in all DQI processes and procedures performed by contractor.

· Document clear instructions in Confluence for all processes and procedures performed by or related to DQI, to include recurring ad hoc assignments.

· Produce finished documents to include, but not limited to: reports; broadcasts; taskings; white papers; audit forms; best practices; accomplishment reporting; slick sheet.

· Create a repository and templates for all DQI related products with DQI branding and formatting to include, but not limited to: reports; broadcasts; taskings; white papers; audit forms; best practices; accomplishment reporting; slick sheet. Organize, facilitate, and provide notes/minutes for all calls/meetings that they are included in and provide a summary with action plan upon conclusion and add to project management hub for action.

· Provide DQI with a designated contractor POC/liaison for each Unit to act as a Unit SME that can be used to facilitate outreach/inquiries/asks among the Units for quicker DQI error analysis and plan of action development. The POC/liaison should understand key performance indicators and work completed by other Units to address DQI concerns.

· Perform audits of ICE ERO Dashboards currently in use and in development to ensure that they meet the required standards of accuracy, formats, completeness, usability, and provide valuable data to the intended audiences. The audit also ensures that all items such as titles, footnotes, data sources, and the underlying data are being reviewed as a part of the validation process to present to fed staff for concurrence and dissemination.

· Leverage audit results to inform future priorities and areas of focus.

· Monitor, track, and reply to all LESA.DQI mailbox incoming inquiries and reach out to fed staff as a resource for appropriate responses.

· Coordinate and facilitate (to include scheduling, creating agendas, collecting input from the fed DQI team, running meeting, sending out invites, updates, and summaries) monthly teleconferences with all ERO AORs and their assigned data quality POCs to provide guidance and instruction on current and upcoming DQI initiatives.

Task 4.6.2: Data Analysis, Engineering, and Automation With regards to support of the Data Quality and Integrity Unit, the contractor shall:

· Create tools for identifying, monitoring, implementing, and creating data sets, databases, and automations utilizing SQL, Python, R, VBA, Databricks, Oracle (OBIEE), and UiPath as requested by fed staff. Deliverables shall be timely, accurate, and free of errors.

· Provide data analysis and recommendations for ERO data quality error remediation utilizing emerging automation tools to include, but not limited to SQL, Python, R, VBA, Databricks, Oracle (OBIEE), and UiPath as…