Projects
-
AutoHRSync: Streamlined Account Handling
Problem: Slow account creation/deletion
-
Identified a delay in new employee account creation from help desk ticket data, averaging 3 days.
-
Prioritized account automation with the team to address system complexities and staff availability issues.
Action: Streamlined Process Development
-
Introduced a method for HR to input new staff details into a centralized system, designating roles and access through specialized fields.
-
Implemented a system process to consistently check for new entries, generating a data file.
-
Deployed an automated tool that establishes user profiles from this data file, categorizing them by roles.
-
Ensured the automation also allocates the required digital resources based on user roles.
Impact: Enhanced Efficiency & Empowered HR
-
The multi-day delay for account creation was completely eliminated.
-
HR can now swiftly make access changes in just 15 minutes without needing a ticket.
-
The onboarding process is significantly streamlined, and HR can promptly remove access when necessary.
Technology Used: SQL, Powershell, cURL, Active Directory
​​

2. DoorSync: HR-Driven Access Control Integration
Problem: Manual door granting/removing of access
-
Recognized the need for enhancements in the facility's access management system to boost efficiency and security.
Action: Process Reengineering & Tool Integration
-
Developed a simplified interface for HR to efficiently manage access permissions.
-
Set up automated systems to periodically detect and log permission changes.
-
Integrated a tool to relay these updates to the centralized user management system instantly.
Impact: Streamlined Access Control & Improved Security
-
HR gained a more user-friendly interface, simplifying the access permission update process.
-
Real-time updates in the centralized user management system ensured timely modifications.
-
Centralizing the management source empowered HR with the agility to quickly adjust or revoke access, thus elevating security and operational efficiency.
Technology Used: SQL, Powershell, Active Directory
​
​

3. TextDesk: Direct Ticketing via SMS
Problem: Low engagement with students via email
-
Noticed a shift in student communication preferences from traditional email to text messaging, leading to less interaction and potentially affecting student success.
Action: Integrative Communication Overhaul
-
Collaborated with the team to integrate an SMS platform, creating a texting channel linked to our current help desk number.
-
Established a backend process to regularly check the SMS system for new student messages.
-
Designed an automated conversion of detected student texts into support tickets within our existing system.
-
Equipped support technicians with a direct link to the SignalVine message, allowing them to respond swiftly via text.
Impact: Elevated Efficiency & Improved Student Engagement
-
A dedicated texting channel now facilitates quicker responses, aligning with students' preferred communication method.
-
The IT support team's efficiency is boosted, ensuring more streamlined interactions and higher student satisfaction.
Technology Used: Python, API's
​​

4. LoneStarGuard: NTCC's Comprehensive Cybersecurity Compliance efforts
Problem: Comprehensive cybersecurity reform at the State level
-
Responded proactively to Texas's heightened cybersecurity requirements, aiming not just to comply but to set a benchmark.
Action: Comprehensive Cybersecurity Overhaul
-
Adopted the NIST 800-53 cybersecurity framework, tailoring it to integrate over 30 detailed policies that exceeded state and national standards.
-
Collaborated across departments, creating a unified, campus-wide approach to cybersecurity.
-
Successfully navigated two DIR audits, highlighting our compliance and robust cybersecurity practices.
-
Implemented a comprehensive cybersecurity awareness training program, fortifying our human firewall against potential digital threats.
Impact: Setting the Gold Standard & Ensuring Comprehensive Security
-
Achieved a ranking in the top percentile for community colleges in Texas, showcasing NTCC's commitment to cybersecurity excellence.
-
Established NTCC as a beacon of cybersecurity best practices among community colleges in the state.
-
Maintained transparent communication with the board of directors, ensuring alignment and support at the highest organizational levels.
Technology Used: NIST 800-53, RSA Archer, Sharepoint, Safecolleges​

4. ReportRevolution: NTCC's Data Turnaround
Problem: Delay accessing live data
-
Addressed the identified challenge of static data reporting by embracing Power BI for real-time insights.
Action: Data Reporting Transformation
-
Transitioned from a static to a dynamic data approach, delivering real-time report updates through Power BI.
-
Streamlined data access, significantly reducing the need for custom report requests.
-
Fostered collaboration with a third-party for an intuitive front-end design, while ensuring our team had a deep backend understanding for long-term adaptability and sustainability.
Impact: Enhanced Decision-making & Campus Satisfaction
-
Achieved overwhelmingly positive feedback across the campus for the enhanced data presentation and accessibility.
-
Elevated the college's data-driven decision-making capabilities through clearer, timely insights.
Technology Used: Power BI, SQL, Jira​
​

5. OneStepAhead: NTCC's Security & Access Revolution
Problem: Recognized the intricate challenges in NTCC's application security and responded with the strategic integration of a Single Sign-On (SSO) solution, rolled out to a vast user base.
Action: Comprehensive Security Integration & Rollout
-
Implemented a seamless and secure SSO login experience across all NTCC applications, catering to over 3,500 end users.
-
Introduced Identity and Access Management (IAM) to fortify our application security.
-
Incorporated Multi-Factor Authentication (MFA) as a standard for both employees and students, reinforcing our defense mechanisms.
-
Used the project as a catalyst to gather user feedback and buy-in, subsequently influencing a change in the institution's procurement procedures to be more secure and robust.
Impact: Boosted Security, Enhanced User Experience, &
-
Achieved heightened application security measures and a unified user experience across all NTCC platforms.
-
Paved the way for the institution's shift toward more secure procurement processes, reflecting the project's broader influence on policy-making.
Technology Used: Active Directory, SSO, MFA
