Eustis Mortgage
October 2018 - Current IT Service Manager / Sr. System Admin
- Proficiently generate SQL queries using SSMS to satisfy data inquiries from internal and external stakeholders.
- Skillfully align internal database data files with external requirements to meet company obligations in facilitating the seamless transfer of ownership or servicing of customer loans.
- Develop and enhance stored procedures through the integration of PowerShell, Azure, and MS SQL to streamline daily tasks, effectively eliminating the necessity for manual intervention by users.
- Innovatively design and enhance SSRS reports to cater to diverse dataset requests. Pioneered the development of two interconnected reports, synergistically contributing to a reduction in the turnaround time for recommitting loans, thereby potentially optimizing company revenue.
- Engineered SSIS packages to seamlessly deliver reports to external vendors, transforming a once manual, daily task managed by two employees into a fully automated and effi cient process.
- Developed PowerShell scripts to streamline daily operational tasks, including automating weekly server reboots with corresponding email notifi cations upon completion. Designed an Active Directory script that efficiently manages user accounts, automatically removing user groups and modifying properties when an account is disabled.
- Successfully orchestrated the migration of on-premise servers to the Azure environment, optimizing infrastructure efficiency. Implemented a strategic transition from a pay-as-you-go subscription to a cost-effective CSP license, resulting in substantial cost savings for the organization.
- Implemented a seamless transition from the previous anti-virus solution to a cutting-edge, next-generation alternative, successfully deploying it across 300+ devices. The current anti-virus solution, introduced under my oversight, has demonstrated exceptional effi cacy, with zero reported incidents of malicious activity since its deployment, underscoring its ongoing success.
- Led the deployment and support of a cloud-based VOIP system, catering to over 150 phones and managing 300+ Direct Dial Numbers. Innovatively programmed phone pathing, auto attendants, and call groups from the ground up, ensuring seamless functionality and optimal performance within the new system.
