Project Category: Completed

What 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.

When 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.

This 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 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.

What 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.

What 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.

As 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.

PeopleSoft, 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.

The 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.

What 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.

What is it? ITS is adding 2-Step verification (Duo) for student access to ConnectCarolina. Students will be prompted for Duo authentication after entering their Onyen and Password to log in to ConnectCarolina. Current students who register for Carolina Key can log in to ConnectCarolina without entering their password or using Duo. Why are we doing it? This change is needed to help the University comply with the increased cybersecurity safeguards requested by the Department of… Read More about Mandatory DUO for student access to ConnectCarolina.

The Mass Storage system (also known as StorNext or /ms) is used for archiving research data files and storing very large files, files that are too large to fit within an individual researcher’s or a department’s storage space. This project will move the Mass Storage system to the next generation of hardware.