Ontario Ministry of Government and Consumer ServicesInfrastructure Technology Services Co-op
May. 2019 - Aug. 2019Toronto, Canada AreaDesigned an algorithm using multiple technologies to successfully automate the process of user modifications in IBM's Privileged Identity Manager. Developed a graphical user interface for this automation process.
Technologies used: Microsoft Flow, Azure Functions, Azure Queues, SQL, PowerShell Scripts, ASP.NET, HTML, CSS, Bootstrap.
Achieved the reduction of countless man-hours as well as an approximate of 18-fold decrease in
time consumption, and a consistent workflow with much less chance of human error. Optimized SQL queries sent through PowerBI reports by completing a thorough organization and cleanup of SQL code in SSMS and recreating reports. Achieved a 7-fold decrease in time taken to compile a PowerBI report.