Air InfoSec

• Serve as a structured liaison between CPA's OCM team and designated state agency points of contact to support communications, readiness activities, and transition coordination. • Coordinate agency communications related to UAT schedules, roles, expectations, and participation tracking across approximately 500–600 participants statewide. • Support TTT and EUT logistics, including scheduling, participant communications, dissemination of training materials, and participation and completion tracking. • Track and update agency-level readiness data across testing, training, and transition milestones using tools and frameworks established by the OCM Lead. • Develop change and readiness artifacts such as readiness checklists, agency communications, FAQ content, and talking points as directed by the OCM Lead and CPA. • Facilitate feedback loops between agencies and CPA to surface readiness gaps, common questions, and change impacts requiring CPA action. • Monitor and report on agency readiness risks and themes, contributing participation data and escalation logs to the OCM Lead's monthly summary reports. • Produce pre-milestone readiness summaries covering readiness assessment across four dimensions, open issues, participation gaps, and recommended determinations for CPA's consideration. • Maintain coordination artifacts including communication logs, agency contact directories, participation trackers, and readiness reporting inputs. • Provide weekly status reports to the CPA Contract Manager summarizing completed work, work in progress, and planned activities for the following week.

• Support the Administrative Office of Courts on the Case Management Project. • Manage vendor execution against contract scope, schedule, deliverables, and quality expectations. • Serve as the primary liaison between the Administrative Office of Courts and the vendor. • Oversee the data migration effort from the legacy system to Microsoft Dynamics. • Maintain a structured cadence for status reporting, action tracking, and escalation. • Identify performance risks and drive corrective actions with the vendor. • Produce weekly status reports and executive summaries for stakeholders. • Facilitate meetings with mixed business and technical stakeholders. • Track and manage project actions and decisions throughout the project lifecycle. • Coordinate pre-kickoff activities and ensure readiness for project launch.

• Support the Texas Education Agency (TEA) on the AI & Emerging Technology workstream. • Design and develop a structured AI and automation literacy scope and sequence for agency-wide staff use. • Create mandatory training modules covering responsible AI use, unacceptable use, TEA policy alignment, and Microsoft Copilot fundamentals. • Develop optional advanced training modules on topics such as prompting, automation concepts, Copilot agents, Power BI, and other approved tools. • Build and organize training content within an online platform, including web-based courses, digital learning assets, and reusable instructional materials. • Produce learning objectives, instructional outlines, facilitator materials, and training aids aligned to both technical and non-technical audiences. • Translate complex technical and policy concepts into clear, practical training content accessible to staff at varying skill levels. • Recommend assessment strategies and completion-tracking approaches suitable for the agency's training environment. • Develop sustainment documentation enabling TEA staff to maintain and evolve the training program after contract completion. • Ensure all training content aligns with TEA policy requirements related to governance, privacy, security, and Microsoft-first tooling. • Support staff in building foundational understanding and practical confidence in using approved AI and automation tools effectively and responsibly.

• Support the Louisiana State Office of Technology on data modernization and informatics initiative. • Lead a team of data and informatics professionals through strategic planning and implementation of data infrastructure improvements. • Oversee efforts to enhance data integration, interoperability, governance, and development of reporting and visualization capabilities. • Coordinate with subject matter experts to assess existing data environment and develop an effective data warehouse and integration strategy. • Ensure modernization efforts result in improved data timeliness, quality, reduced data burden, integration of emerging and open-source technologies.

• Support the Louisiana State Office of Technology in designing and managing a comprehensive data framework. • Establish the vision and blueprint for the organization's data ecosystem. • Lead efforts in data modeling and design, software development support, and database administration. • Write and maintain complex SQL queries to support reporting, analysis, and data operations. • Collaborate with stakeholders to identify data requirements and translate them into scalable architectural solutions.

• Support the Texas Education Agency on the Enterprise Risk Register and Governance Framework engagement. • Define end-to-end governance workflows covering risk identification and intake, risk review and validation, risk acceptance, mitigation or transfer, and ongoing monitoring and periodic reassessment. • Establish roles and responsibilities for risk owners, reviewers, and governance bodies within the enterprise risk framework. • Design escalation and reporting processes for high-risk and accepted risks. • Engage key stakeholders across business, technology, security, and governance functions to validate risk requirements and workflows. • Facilitate working sessions and workshops to socialize the risk register and governance processes with relevant personnel. • Support the onboarding of initial risks into the enterprise risk register. • Develop a standardized risk register template and taxonomy as a formal deliverable. • Produce documented likelihood and impact scales along with scoring methodology and prioritization logic. • Author audit-ready documentation covering risk register structure and data definitions, risk scoring methodology, and governance workflows and decision authorities. • Provide knowledge transfer to designated security staff to ensure ongoing operational sustainability following the conclusion of the engagement.

• Design, develop, and maintain ETL processes and systems to support agency data integration needs. • Create and implement ETL strategies that meet LDWF and OTS requirements. • Collect, clean, and integrate data from various sources, including structured and unstructured data. • Develop and maintain data models and data mappings. • Ensure data quality and integrity by implementing data validation and error handling processes. • Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize requirements. • Provide technical knowledge transfer, training, and documentation to OTS and LDWF agency staff for all requested work. • Participate in team meetings and design sessions by providing feedback and detailed design and implementation approaches in accordance with Scrum ceremonies. • Cooperate with LDWF's Technical Architect and other OTS technical teams to ensure compliance with OTS standards for state applications. • Perform additional tasks, special projects, analysis, studies, and plans as directed.

• Support the Louisiana Department of Wildlife and Fisheries in coordinating and managing data across organizational systems. • Perform data profiling, discovery, and modeling to ensure data integrity and usability. • Gather and interpret business requirements to inform data documentation and design decisions. • Coordinate various data sources across organizational systems to ensure consistency and accessibility. • Perform data modeling and design to support integration and migration efforts. • Write and execute SQL queries to extract and analyze data from relational databases. • Clean and validate data to support reporting and migration activities. • Run basic reports and maintain existing dashboards to support operational needs.

• Analyze and map data from legacy systems to new target systems • Develop and implement comprehensive data conversion plans aligned to project requirements • Design and execute data validation and testing processes to verify data accuracy and completeness • Ensure data quality and integrity throughout all phases of the data conversion lifecycle • Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize data conversion requirements • Provide technical knowledge transfer, training, and documentation to OTS and LDWF agency staff for all requested work • Participate in team meetings and design sessions • Cooperate with LDWF's Technical Architect and OTS technical teams to ensure compliance with OTS standards for state applications • Perform data profiling, normalization, and error handling activities

• Lead end-to-end project delivery for reporting and extract migration from mainframe systems to cloud or data lake environments, including the development and management of project plans, timelines, milestones, risks, and dependencies. • Facilitate cross-functional communication and coordination between technical teams, business units, and leadership to maintain project momentum and clarity. • Conduct detailed sessions with business stakeholders to understand reporting, extract, and downstream data needs. • Work closely with data engineers, solution architects, and delivery teams to ensure requirements are accurately captured and implemented. • Apply Agile methodologies, including Scrum and Kanban, to drive sprint planning, backlog grooming, and delivery milestones. • Proactively identify and manage project risks, issues, dependencies, and mitigation strategies. • Oversee quality assurance and monitor solution performance in collaboration with technical leads. • Ensure the creation and maintenance of key project documents, including plans, timelines, milestones, reports, and dashboards. • Support the Railroad Commission of Texas's regulatory obligations in the Oil, Gas, and Energy sector through disciplined delivery and documentation practices.