Project Category: Completed
Data Mart Optimization
CompletedWhat is it? The purpose of the data mart optimization project is to streamline processes and provide a way for end users to maintain the mapped values between UNC Chapel Hill (UNC-CH) and the UNC System Office data marts. Why are we doing it? Currently, the data mapping between UNC-CH and the UNC System Office is maintained by developers, and requests for changes are dependent on the developers’ availability. This project will create an interface… Read More about Data Mart Optimization.
Decommission ADFS Infrastructure for M365 Authentication
CompletedWhen UNC migrated to Microsoft 365, we implemented an on-premises infrastructure called “Active Directory Federation Services” (ADFS) to support authentication into Microsoft 365. ADFS addressed security concerns around syncing passwords into the Azure Active Directory Cloud service, but it also created an on-premises dependency for Microsoft 365 and technical debt. Note: Technical debt can be defined as “incomplete configurations or deployments of technology that have been on the books, but due to lack of resources… Read More about Decommission ADFS Infrastructure for M365 Authentication.
Dimensionalisation of Warehouse Data
CompletedThis project will develop the Enterprise Data Warehouse’s most-used data sets in a more efficient type of schema called a “star schema” data model. The new tables and views will be available for internal use within the data warehouse, enabling the team to better serve customers. Projected Completion Date: March 31, 2023
DUO Universal Prompt
CompletedDuo is one of the multi-factor authentication tools that the University uses to keep UNC’s systems safe and stay ahead of security threats. In February 2022, Duo released a new version of its web-based prompt that improves accessibility and can automatically send to the last authentication method you used to authenticate — speeding up the process. The new version has a different look with some changes in functionality so the change will be noticeable to… Read More about DUO Universal Prompt.
Duo Universal Prompt Readiness Project
Completed, Key ProjectWhat are we going to do? Duo is ending support for the Traditional Prompt on March 30, 2024. This project is focused on updating the UNC applications impacted by this change by moving to Duo’s Universal Prompt or alternate solution. Why are we doing it? This project is crucial as individuals may be unable to use some applications and services where Duo is used as the Multi-Factor Authentication (MFA) tool potentially impacting their daily work,… Read More about Duo Universal Prompt Readiness Project.
Enterprise Firewall Migration
CompletedWhat is it? This project will migrate approximately 250 unprotected VLANs (“virtual local area networks”) to campus enterprise firewalls. Why are we doing it? Migrating these VLANs will prevent attacks and also limit the scope of attacks across the University. Onboarding the rest of campus will significantly expand the range and depth of the University’s defenses. It will also give ITS unprecedented awareness of which mission-critical systems we need to protect. How does this impact… Read More about Enterprise Firewall Migration.
esmc0 and esmc5 NetApp Storage Replacements
CompletedWhat is it? This project is performing a lifecycle replacement of storage controllers and disks that are nearing the end of their useful life. Why are we doing it? As hardware ages, it becomes less reliable, the potential for data loss grows and maintenance costs increase. This project is focusing on replacing: ESMC0 – the hardware supporting Storage.unc.edu and SecNas.unc.edu. ESMC5 – the hardware that provides some primary storage for Splunk and serves as a… Read More about esmc0 and esmc5 NetApp Storage Replacements.
ETL Redesign for Enterprise Data Warehouse
CompletedAs the Enterprise Data Warehouse grows, so does the time required to run the ETLs that keep it updated. (An ETL extracts, transforms and loads data from multiple sources to a data warehouse.) This project will redesign the nightly ETL for the Enterprise Data Warehouse to make better use of the after-hours time we have to run the jobs and to make it easier to diagnose problems.
Faculty Workload Data Collection
Completed, Key ProjectWhat is it? A new policy on faculty workload reporting has prompted a review of data collection processes. ITS is working with IT leaders across the campus to create a process and mechanism for collecting and reporting faculty workload data. All applicable schools will collect and submit workload activity for their faculty members to a shared platform. Some schools already collect the required information. Other schools will need to develop processes to start collecting the… Read More about Faculty Workload Data Collection.
Full Position Management
CompletedPeopleSoft, the software that forms the backbone of ConnectCarolina, can be structured by positions, appointments, or a mix of the two. When UNC-Chapel Hill’s implemented ConnectCarolina HR/Payroll, the decision was made to: use positions for SHRA and EHRA Non-faculty (non-student) permanent and temporary positions (64% of employees). not use positions for faculty, Post Docs and EHRA Non-faculty student positions (36% of employees). Since ConnectCarolina HR/Payroll went live seven years ago, the University has been translating… Read More about Full Position Management.
HIPAA Campus Risk Assessment for HIPAA Covered Units
CompletedThe Health Insurance Portability and Accountability Act of 1996 (HIPAA) is a broad federal law that is in part designed to provide national standards for protection of certain information related to the provision of or payment for health care. There are currently 11 HIPAA covered units outside of the School of Medicine which need to comply with the HIPAA Privacy and Security Rules. We will conduct a risk analysis to identify potential compliance gaps in… Read More about HIPAA Campus Risk Assessment for HIPAA Covered Units.
Lump Sum ePAR Redesign
CompletedWhat is it? This project will redesign the existing Lump Sum ePAR form, increasing functionality for UNC users. The redesign will also move the form to an updated version of the application software used for eForms from Gideon Taylor “GT” allow UNC to deliver additional features more easily. Why are we doing it? After this project, there should be a significant reduction in manual effort when updating lump sum payments. The updated form will be… Read More about Lump Sum ePAR Redesign.