Air InfoSec

• Inventory TEA and external data systems to develop a comprehensive, vendor-ready data map. • Document data sources, ownership, formats, dependencies, and data integration requirements. • Assess data quality across systems to identify gaps, inconsistencies, duplications, and standardization needs. • Recommend data cleansing and validation strategies. • Design a scalable data integration strategy that improves data accessibility, interoperability, usability, and long-term sustainability across TEA systems. • Align the data integration strategy with TEA's implementation of the Ed-Fi Data Standard. • Serve as the Business Analyst for OnePlan, gathering, analyzing, and documenting business and system requirements in Modern Requirements format. • Document process flows, skip logic, system interdependencies, and user interface mock-ups. • Translate business and system requirements into clear functional requirements for vendor design and development. • Support broader IDS team workstreams, including LASO, GSA, OneSystem, and other initiatives.

• Design and develop a new reporting framework using .NET 9.0/10.0, Blazor, and other modern Microsoft technologies. • Participate in the full Software Development Life Cycle (SDLC) within a SCRUM/Agile environment. • Analyze and enhance existing complex reports built with Crystal Reports integrated with Oracle databases. • Develop scalable, high-performance financial system solutions with seamless Oracle database integration. • Collaborate with cross-functional teams, including the DevOps team, to maintain and enhance CI/CD pipelines and automation processes. • Provide innovative solutions to modernize and streamline the existing legacy project in alignment with business goals. • Work across multiple agency stakeholders to ensure the accuracy and efficacy of assigned components. • Troubleshoot and resolve system-level issues within complex environments. • Support development and enhancement of applications serving Texas' 1,247 school districts. • Apply modern design principles and best practices throughout the software development lifecycle.

• Develop and customize Model-Driven Apps and Dataverse-based solutions. • Build server-side components, including plugins, integrations, and APIs using C#/.NET. • Implement client-side customizations using JavaScript, form scripting, and PCF controls. • Design and build data integrations using REST APIs, ETL processes, and Dataflows. • Manage the solution lifecycle using Git-based source control and CI/CD processes. • Troubleshoot and resolve production issues through root cause analysis. • Collaborate within a multi-developer team environment using a shared codebase. • Produce and maintain technical and deployment documentation.

• Support the Texas Health and Human Services Commission on the SHARP Data Engineering and Data Governance project. • Understand business objectives and problems and identify alternative solutions. • Perform studies and cost/benefit analysis of proposed alternatives. • Analyze user requirements, procedures, and problems to automate processing or improve existing computer systems. • Confer with personnel of organizational units to analyze current operational procedures and identify problems. • Learn and document specific input and output requirements, including forms of data input, data summarization, and report formats. • Write detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs. • Review computer system capabilities, specifications, and scheduling limitations to determine feasibility of requested programs or program changes. • Independently perform a variety of complicated tasks relying on experience and judgment.

• Analyze system specifications to develop software for computer applications. • Design, build, and maintain efficient, reusable, and reliable code using C# and the .NET framework. • Develop and support applications in both client/server and Azure web-based environments. • Document the methods and procedures used throughout the software development process. • Test, correct, and revise software to ensure functionality and reliability. • Participate in code reviews to maintain code quality standards. • Apply Agile development methodologies throughout the software development lifecycle. • Utilize Azure DevOps or similar source control tools to manage code repositories. • Develop user interface components using tools such as HTML, CSS, jQuery, and Bootstrap. • Incorporate security best practices into all phases of application development.

• Designs and executes database upgrades from Oracle 19c to Oracle 23ai. • Maintains multiple database environments supporting ETL activities. • Sets up and maintains Grid Infrastructure, including ASM and Clusterware. • Implements high-availability solutions using GoldenGate and Active Data Guard. • Performs performance tuning to improve database processing efficiency. • Monitors database performance and recommends efficiency improvements. • Performs logical and physical data modeling and creates physical data models from logical data models. • Maintains data dictionary standards to ensure uniformity of definitions. • Executes backup, recovery, and disaster recovery procedures for hardware and software failures. • Ensures compliance with security vulnerability requirements and database security standards. • Assists in the installation, analysis, design, and implementation of databases. • Ensures database administration interfaces comply with EIR Accessibility standards.

• Provide functional support for the CAPPS HR/Payroll Time and Labor module in coordination with module leads, CPA management, and the Tier 3 Managed Services vendor. • Support functional configurations including TRCs, Programs, Workgroups, ORCs, Task Profiles, Task Groups, Schedules, Value Lists, Security Groups, and Time and Labor Rule Programs. • Implement and support Fluid timesheet functionality, including system configuration, security and roles, integrations, testing, and training documentation. • Create and review Functional Design Documents (FDDs) and perform functional configuration system changes. • Provide Level 2 Service Desk support, including complex ticket handling, advanced troubleshooting, and documentation in coordination with the Tier 3 Managed Services vendor. • Support batch job issues and failures, including oversight of Run My Jobs (RMJ) processes. • Plan, schedule, and communicate Fiscal Year-End activities, including sick leave conversion and Time and Labor Fiscal Year-End Leave Liability File processing. • Prepare and review materials for compliance with WCAG 2.1 accessibility standards. • Provide cross-training to support junior analyst capability growth and deliver training to agency personnel as requested. • Participate in Major Incident Management (MIM) for P1 and P2 incidents, Disaster Recovery exercises, and Upgrade Testing activities.

• Configure and maintain TAM/CG and OnBoarding functionality, including recruiting statuses, templates, onboarding tasks, screening levels, and candidate application workflows. • Configure and maintain Performance Management templates, evaluation documents, rating scales, competency models, and annual ePM cycle workflows. • Administer and maintain TAM/CG, OnBoarding, and Performance Management security roles, permission lists, and row-level security in compliance with State policies. • Provide end-user support for the Candidate Gateway applicant portal and ePM document routing, troubleshooting, and evaluation processing issues. • Maintain reporting tools and dashboards for recruiting metrics, onboarding task completion, and Performance Management compliance and workforce insights. • Support cross-functional integration between TAM/CG, OnBoarding, Performance Management, and other CAPPS modules, troubleshooting data flow and batch process issues. • Provide Level 2 Service Desk support, including complex ticket handling, advanced troubleshooting, and documentation, in coordination with the Managed Services Tier 3 vendor. • Create and review Functional Design Documents (FDDs) and perform functional configuration changes for CAPPS HR/Payroll applications. • Develop test scripts and execute structured UAT and regression testing for PeopleSoft HCM functional enhancements, patches, and PUM updates. • Ensure digital products and content meet WCAG 2.1 accessibility standards, reviewing and remediating content as issues are identified.

• Lead or support Fluid UI upgrade activities, including planning, fit-gap analysis, configuration of pages and navigation collections, end-to-end testing, and post-deployment monitoring. • Provide functional support for the CAPPS HR/PY application, serving as a point of contact for CAPPS agencies and managing incidents through ServiceNow and BOSSDesk. • Create and review Functional Design Documents (FDDs) and perform functional configuration changes within PeopleSoft HCM, including Page and Field Configurator, Drop Zones, Event Mapping, and Page Composer. • Configure and manage the Approval Workflow Engine (AWE), including workflow setup, user and role management, notifications, worklist management, and troubleshooting. • Coordinate and execute Fiscal Year-End and Calendar Year-End processes, including reconciliations, system configurations, mass salary loads, and Benefit Enrollment Web Services integration with ERS. • Support Affordable Care Act (ACA) processing, including 1095-C form generation, electronic delivery, interface file construction, and adherence to IRS filing deadlines. • Provide Level 2 Service Desk support for complex ticket handling, advanced troubleshooting, and auditable documentation in coordination with the Managed Services Tier 3 vendor. • Participate in SOC-1 attestation audits, Disaster Recovery exercises, and Major Incident Management activities for Priority 1 and Priority 2 incidents. • Ensure digital content and system deliverables meet WCAG 2.1 accessibility standards, performing regular compliance reviews and implementing remediation as needed. • Deliver cross-training to junior analysts and provide comprehensive training and functional support to agency personnel across the statewide CAPPS network.

• Provide advanced consultative and functional support for the CAPPS HR/Payroll tower, including Workforce Administration, Payroll Interface, Commitment Accounting, Time and Labor, TAM/CG, and HR security setup, including row-level security. • Ensure CAPPS compliance with the Family Medical Leave Act (FMLA) by defining leave plans, customizing leave types, and supporting compliance reporting and auditing. • Serve as the functional point of contact for CAPPS agencies, creating and reviewing Functional Design Documents (FDDs) and performing functional configuration changes. • Configure system tables, business units, Set IDs, and table structures, and build workflow configurations using the Approval Workflow Engine (AWE). • Create queries and reports using PS/Query, SAP Business Objects, SQR, and BI Publisher, applying technical knowledge of Application Designer, Integration Broker, and SQL. • Monitor batch job schedules and execution, detect and respond to failures, validate output, manage dependencies, and document performance tuning activities. • Coordinate Fiscal Year-End activities, including reconciliations, system configurations, mass salary loads, and Benefit Enrollment Web Services integration with ERS. • Coordinate the CAPPS Annual Disaster Recovery exercise with the Managed Services vendor, including test scope definition, backup validation, and documentation of results. • Provide Level 2 Service Desk support for complex ticket handling, advanced troubleshooting, and documentation in coordination with the Tier 3 Managed Services vendor. • Participate in Major Incident Management (MIM) for Priority 1 and Priority 2 incidents, perform upgrade testing, ensure WCAG 2.1 accessibility compliance, and apply ITIL principles to IT service and asset management activities.