Completed project initiation and planning for update of the City of Albuquerque's ABQ View Dashboard. The goal of the project was to increase the transparency of city agencies and allow for real time data to be published instead of static data. Requirements were gathered, a proposed solution was put forward, and approved by the project sponsor. Data sets were migrated to the City of Albuquerque's open data repository to feed the chosen application and also allow for individuals to have access to the data as well.
UNM Degree Plan Viewer December 2015
At the direction of the Associate Provost for Academic Affairs, a Ruby on Rails web application was constructed to display degree plan data in a visual format that students could interact with. The application allowed students to explore different degree plans and to see what the pre-requisite requirements were for a course and also which classes opened up as a result of taking a particular course. This allows for students to see what classes are required for a degree and what are considered "key" courses that are vital to the students success.
Academic Forecasting Tool March 2016
Designed, developed, and built a redesigned SQL Server database for supporting the University of New Mexico's Academic Forecasting Tool. This system was constructed to project expenses in academic units for upcoming academic years. The redesign included additional layers of security as well as further integration with the Banner Authorization Request system and enterprise Active Directory environment. Functions were generated to automate regular database administration tasks including the import of data from external sources and archival of previous academic years for business intelligence purposes (trend analysis and projected vs actual values)
Professional Projects
Managed Workstation Migrations August 2013
At the direction of the Chief Financial Officer and Chief Operating Officer, administrative departments were migrated from departmental support to centralized and standardized services. This included reviewing existing environments to look at replicating services that were already provided while laying the groundwork for a stable experience for departments who joined the Managed Workstation program. Performed on site assessments of infrastructure, developed schedules, and coordinated resources to migrate file services and integrate the departments into the enterprise environment. Meeting with customers to align expectations was critical and to manage the risk involved in changing service providers.
Migration from eDirectory environment to Active Directory
UNM Information Technologies approved standard image
Upgrade and replacement of end of lifecycle hardware
Additional security and controls for network devices
Classroom Technologies Modernization and Standardization Project August 2014
Worked on the project team to modernize and standardize the computer lab and classroom environments to reduce the amount of maintenance and system configuration required. The goal of this project was to upgrade all the lab and classroom environments to Windows 8.1 and to reduce the number of computer images and network configurations needed to support these machines.
Update image creation and deployment toolset for improved support of newer Microsoft operating systems
Slimmed down a 53 page Group Policy Object into one that was much more effective and efficient for systems to process upon login
Worked with networking, computing platforms, and classroom technology groups to make network changes that reduced logon times for authentication
Identified DHCP reservation issues in several environments which allowed lab facilities to be used to their full capacity
Built a slim standard image for deployment in classroom environments that focused on security and usability
Provided training and guidance to technicians deploying the image
Cherwell Service Management Upgrade August 2014
Worked on the project team to upgrade our IT service management platform to include a self service portal for users to submit requests along with the ability to submit tickets on behalf of other users.
Designed incident and service request processes for workstation and hardware tickets
Built dashboards for management to track breached incidents and have increased visibility on staff workload
Tested client packages for compatibility issues with standard image
Worked with networking teams to whitelist install packages from network security appliances
Worked to identify instances where tickets were left in an "orphaned" state to ensure tickets were never abandoned
Image Consolidation and Client Standardization Project February 2015
Led the initiative to update and consolidation the workstation managements practices of Enrollment Management. Went from 17 indepedent Norton Ghost images to 2 WIM images that were easy to deploy with the Microsoft toolset. This was considered a priority as the IT operations group was spending a large amount of time troubleshooting an overwhelming number of different configurations which was taking the focus away from the project work that needed to be completed.
Eliminate non-standard configurations including a hetergeneous environment of Windows XP, Windows 7 32bit, Windows 7 64bit, and Windows 8 32bit clients
Leverage Deployment Imaging Servicing and Management tools to properly handle partitioning, drivers, image creation, and deployment
Move scripted processes from legacy vba scripts to a series of targeted Group Policy objects that were easy to maintain
Automate system setup and deployment with Microsoft Deployment Toolkit
Setup task sequences for configuring special use workstations such as shared scanning stations, public computers, and checkout laptops to prevent rework during the deployment process
Hyland OnBase Upgrade December 2016
Led the project to upgrade the University's enterprise OnBase implementation by acting as the project manager and technical lead for the project. Agile project management practices were used to ensure timely delivery and thorough testing of the application. New project management tools were introduced to track outstanding items and identify risks associated with the project. Upgrades were performed to the underlying servers including a review of system and application security in order to strengthen the integrity of this mission critical repository. The application was upgraded from OnBase 13 SP3 environment to the latest OnBase 16 SP1 build which meant careful review and testing of software enhancements, software corrections, and feature updates to ensure the behavior of the application was unchanged.
Financial Aid Counselor ReviewOctober 2017
Partnered with a cross functional team across the University to design and implement a paperless review process to streamline the processing of applications for Financial Aid. This project resulted in reducing the time to compile and review applications for aid, the management of supporting data, and greatly accelerated the departments ability to serve students.
OnBase Architecture ProjectJuly 2018
Successfully designed and implemented a redesigned architecture for Princeton's enterprise ECM platform as the Technical Lead. This included scaling the environment out to handle the additional required capacity to support the continued growth of the service. Puppet was introduced to assist with the management of the infrastructure and applications. An incremental parallel upgrade approach was used to ensure the smooth transition of various services and integrations to the new environments which resulted in minimal impact to business processes. At the conclusion of the project a 50% reduction in response times was observed at the web and application layers. Included the introduction of SAML authentication to enable Multi-factor authentication for the OnBase platform.
Database Migration ProjectJuly 2019
Managed the migration from an Oracle database to SQL Server in order to align with vendor's preferred DBMS. This involved migrating data and updating integrations with other custom applications.
Active Directory Group Implementation ProjectNovember 2019
Built process for automating the access request process for vended applications. This involved the development of a request form and transitioning authorization from a manual process within the application to an automated process leveraging Active Directory security groups.
