Systems Administrator
Current- Created multiple Stored Procedures in SQL that referenced Data in SCCM so that they could be used for Reports or Dashboards- Created Power BI Dashboard using multiple Stored Procedures I created in SQL to provide information related to the cleanup of SCCM which tables and graphs to show what items needed to be deleted.- Created Power BI Dashboard using a Device Information Stored Procedure I created in SQL to aid with PC Refresh.- Added warranty information from Dell to a table in SQL so that it could be merged into the PC Refresh Dashboard.- Corrected multiple issues with the main imaging task sequence that were leading to inconsistencies when imaging.- Created multiple Group Policy Objects to address issues in the environment such providing a work around to the PrintNightmare issue that still provided the security created by the related KB.- Worked with Service Now team to provide a framework for Software Reclamation to reduce the number of licenses needed.- Created a tool with GUI to verify the software installed on a computer after imaging.- Created a tool to aid imaging techs in their work by providing a GUI with multiple buttons to allow the techs to collect logs when troubleshooting a failed image in progress and upload them to the network, format an internal drive when the bitlocker key was missing, set the Asset Tag of Dell systems as well as configure Dell BIOS settings.