IT Automation Developer Co-Op
Sentia Solutions
Jan - Apr 2022
Summary
- Implemented Ansible testing environment in MS Azure to automate configuration and patch management of high-value IT solutions in VMware, Windows, Linux and AIX, effectively reducing need for manual execution
- Designed business workflow automation solutions using MS Power Automate to build an in-house parser for COVID assessments and request forms, expediting provisioning and eliminating costs associated with using third-party resources
- Provided exceptional customer service and problem solving skills to resolve tickets in ConnectWise Manage and thoroughly documented change management processes through RAID logs
Power Automate Project
Problem:
In the midst of the COVID-19 pandemic, our office required employees who wanted to come in for the day to complete a survey indicating whether they have tested positive for the virus recently or are exhibiting symptoms. We used a survey website to send a scheduled link every morning. However, the office administrator still had to set up the surveys daily and then go through them one by one to see if any employees are advised not to come in.
Requirements:
- Eliminate the need to use a third party survey app, instead using Microsoft Office which we already had licenses for. This would cut down the company’s yearly expenses by getting rid of a subscription.
- Automatically send the email instead of needing to set it up daily
- Develop a method which can parse through survey automatically and flag responses
Solution:
- Using Microsoft Power Automate, I built a flow which sent out a Microsoft Form at 6 am from our office administrator’s email
- Employees are prompted to fill out the survey. Upon completion, the build would parse through the responses and flag if the employee confirmed exhibiting symptoms or having a positive COVID test.
- To maintain confidentiality, only the office administrator was notified of the flagged response. It was up to their discretion to advise the employee to stay home.
Beyond COVID forms, others in the company liked the solution so much they asked me to implement more flows in other departments. I adapted the flow to be used also in onboarding access requests and customer contracts. I also created a guide document which outlined common issues I ran into during the development of the flow, and how to troubleshoot them.
