Scott Duncan Email & Phone Number

- Maintain SQL Server database with Microsoft Access front end- Create custom reports from SQL Server database using Visual Studio- Setup SQL Reports server for custom reports- Create custom forms for Access front end to SQL Server database- Migrate SQL Server 2000 database to new SQL Server 2014- Integrate state forms and reports into Pathway’s custom SQL database- Provide troubleshooting, support, and upgrades for all users in main office and five branch offices- Maintain Windows servers and nightly backups - Planned for and upgraded to new server hardware and software from Microsoft Windows Server 2003 to Microsoft Windows Server 2012 and Windows Server 2012 R2- Maintained website housed internally, HTML/ASP pages and Flash videos- Assist in migration of website from in house to hosted solution- Maintain Active Directory- Maintained Exchange system, frontend/backend scheme- Assist in migration from in house Exchange server to Microsoft hosted Office 365 Exchange server- Setup and installed total open source spam filter for in house Exchange server- Administer fingerprint system- Setup and maintain RDP server for users to work remotely from home and remote offices- Write custom import routines from Microsoft Excel to MAS 90 accounting software- Maintained server and workstation uptime during flood periods- Physically moved servers during two move locations with minimal downtime

- Provide first and second level support for commercial clients- Provide telephone, in-house, and on-site support and repairs to residential customers- Install / troubleshoot Apple and Windows computers for Road Runner high speed cable internet, both wired and wireless networks- Handle Commercial Roadrunner installs for Time Warner Cable in northeast Ohio

- Designed and developed reports on Oracle 8i database using Oracle Reports 2000 and 6i to meet specific user needs- Developed Access 2000 databases for tracking changes to Oracle reports- Developed and maintained WinBatch scripts- Monitor check printers and server- Provided first level software and hardware support

- Primary Contact for PC Hardware and Software Support; Repairs of internal and external desktop and laptop computers in a timely, efficient and cost effective manner.- PC Application Software Installation, Upgrades, and Support as required.- Provision of Telephone Support and Troubleshooting for a user community of over 100 Windows 98/NT/2000 Workstations in a LAN/WAN environment, providing first and second level support