Stephen Wire Email & Phone Number

• Working in all aspects of designing and maintaining a large longitudinal database.• Created processes for data import, data clean up, and data matching• Developed front end utilities to manage processes related to data, security, and server performance• Developed backend processes to report on server performance, long running queries, log file size issues, and reboots• Account and database security management, created backend automated process and front end display to quickly search and show all security roles for servers, databases, and users.

Cincinnati, Oh, Us

• As a consultant learned how to handle working with multiple clients simultaneously in their vastly different and fast changing environments, developing skills in requirement gathering, organization, prioritization, efficiency, and budgeting.• Tasked with SharePoint farm builds, migrations, upgrades, and data imports from single server to fully redundant multi-server high availability load balanced environment using SQL clusters or SQL Always-On for SharePoint 2013 and SharePoint 2016.• Created Azure Functions to read and write to and from both SharePoint Online and SharePoint On Prem. Used to create functionality such as custom end of day email notifications on all changed work items in a site, monitoring a lengthy custom approval process with specific notices, and manipulate PDF documents.• Trained users to use SharePoint Online, create sites, lists, content types, permissions, and basic workflow functionality.• Created a series of PowerShell scripts to monitor server and network performance for short term and long-term tracking. Functionality includes ping times, network transfer speed, CPU and Memory usage of all farm machines, server reboots in the last 30 days, and SharePoint database sizes. The results were logged to a database and a report was automatically generated and emailed once a week.• Built an all in one SharePoint server in Azure using MSDN credits. Created a PowerShell scripted menu for other developers to configure their Azure accounts, setup the storage, copy the VHDs, create the VM, and have it accessible as a SharePoint development environment.• Developed an application using .NET, MVC, EF, and Kendo to document and track Highway Funding Requests approval status from the start all the way to the Secretary of Transportation.• Utilized the Microsoft Risk Assessment as a Service program to diagnose and successfully fix performance and security issues on SharePoint 2013 farms.

Frankfort, Kentucky, Us

• Responsible for installing, configuring, and administering SharePoint 2007, KnowledgeLake Imaging product suite, Team Foundation Server, and SQL Servers• Researched, designed, and wrote a custom windows application to migrate 1.1 million documents from the old imaging system to the SharePoint/KnowledgeLake system• Created a SharePoint 2010 environment for upgrading the KnowledgeLake Imaging system. Upgraded and migrated the SharePoint 2007 databases to the 2010 environment• Created a secure DMZ environment and moved the necessary applications to the DMZ• Database administrator over multiple SQL servers and SQL clusters• System Administrator for both internal and external web servers• Technical troubleshooter responsible for maintaining all existing applications and database• Reviewed hardware and planned future upgrades of SQL, web, and application servers• Worked with Network Engineer to implement VMware virtual servers

• Developed coding standards, was UI team point of contact, and assisted others learning XML/XLS• Built interactive application using XML/XSL, JavaScript, VB COM, and SQL