• Developed Selenium-based browser automation apps (Windows Forms apps in C#.NET/Visual Studio 2022 and Python in PyCharm) to automate CRM updates and streamline user interactions• Tested APIs using Postman and created apps that work with those APIs (e.g. reports from Zoom event attendees, MailChimp integration)• Built R project in RStudio/Posit and Shiny dashboard with SQL scripts, R data processing, and sent automated emails with attached HTML dashboards• Designed BI reports and dashboards in Tableau Desktop connected to the CRM• Created a Windows Forms app to launch/stop AWS EC2 instance and connect through Windows Remote Desktop, simplifying server connection without logging into AWS Management Console• Managed IT infrastructure and technology, annually developing budgets and procuring hardware, software, and services to align with business objectives• Extracted customer data from CRM, categorized into 10 regions using Google Maps API, exported to Excel, and maintained mailing list via Selenium automation in Python• Implemented backup and disaster recovery solution with site-to-site VPN tunnel and Veeam Backup and Replication at co-location data center• Automated server shutdowns in server room in power outage/high temp scenarios using APC Network Management Card, Temperature Sensor, PowerChute, and PowerShell scripts• Designed and developed corporate website based on DNN Content Management System, with custom DNN modulesKey Achievements:• Created personalized T2202A education tax receipts (PDF reports) using SQL Server Reporting Services (SSRS) and custom ASP.NET pages in the CRM (iMIS)• Migrated company's CRM to custom 3rd party solution, handling database design, data mapping, and data export• Virtualized 7 servers into one physical server using Microsoft Hyper-V, reorganized server room, and rewired all workstations and phones

• Offered IT consulting services for clients with administrative and on-site support for servers and workstations• Developed websites using DNN content management system• Performed network device installation and troubleshooting• Implemented Search Engine Optimization for clients

• Configured IBM laptops and desktops to meet customer specifications• Assembled and set up IBM xSeries servers, BladeCenters, and Storage Area Networks per customer needs• Installed software, applied patches, and validated system functionality• Tested client-server software on IBM systems in simulated customer environments• Troubleshot and resolved issues using system diagnostics• Built, installed, and tested OS-based cash registers for large Canadian and US department stores