Member of National IT Enterprise Support.Support for 52 internal systems and associated databases.Primary support for UiPath Orchestrator as well as support and maintenance of VMs used for robots.

Contracted to Fiserv/FirstData – Hagerstown, MD• Member of brand-new Data Solutions team for Settlement Operations.• Developed new solutions using VBA in Excel and Access to automate routine tasks, as well as maintained and updated existing automations.• Developed a VBA solution to centrally track operation of new and existing automations.• Used Power Query/PowerBI to extract data from multiple reports downloaded from a website and populate Excel template, eliminating need for VBA.• Responded to user tickets to diagnose and repair malfunctioning automations so users could meet company SLAs.Technical Environment: Windows 7/10, MS Office 2010, 2013, 2016, Jira

Managed fledgling IT Department. Monitored and maintained mission-critical databases on SQL Server 2016. Migrated internal domain from SBS 2007 domain to Windows Server 2016 including Active Directory design, Exchange 2016 and SQL Server 2016. Maintained new servers with updates and patches as necessary, set up and monitored backups.Procured and installed on-premise Celoxis project management software.Developed additional capabilities and fixed long-standing bugs in the database and associated in-house clinical inventory software. Added stored procedure to extract and email database backup history for all databases. Another would send email alert if a monitoring database had not received any new data within previous ten minutes.Created SSMS solutions for often-used ad-hoc queries for correcting data and troubleshooting data issues. Also wrote ad-hoc queries to extract data as requested by other departments.Created SSRS reports to summarize weekly and monthly time log data, eliminating need to extract data manually. Report data sources were based on parameterized stored procedures.Added an asynchronous auditing system to in-house databases to track data changes using XML, stored procedures and Service Broker.Developed and updated IT department Standard Operating Procedures.Deployed Spiceworks help desk and inventory system to improve responsiveness of IT department.Implemented Duo multi-factor authentication system.Created a Powershell script to ping critical servers and workstations at 15 minute intervals and email an alert if one did not respond.Administered badging system for building access.Added and maintained users accounts, set up user workstations. Desk side support as needed.Set up new Hyper-V based server for transition to virtual machines.

Full-time IT support for approximately 40 users at the Fisher Bioservices Wedgewood facility in Frederick MD.Some of my accomplishments:Reconfigured the existing Microsoft Access purchase order system to improve performance and usability.Designed and developed a complete front-end/back-end solution to track billable labor using MS Access, C#, .NET Winforms and SQL Server. This replaced an outdated and inefficient system that used 30-40 individual Excel spreadsheets which had to be reconciled. My system used linked Excel workbooks which allowed constant review throughout billing periods to give supervisors insight into their staff activities and leverage metrics.I learned an XML-based translation language for a mission-critical biological sample inventory system. This brought the ability to create and troubleshoot these translations in-house, turning a $300 per hour expense into a $50 per hour revenue source. For my efforts I was nominated for and received a quarterly award for quality improvement. Collaborated closely with Facility Department to procure and implement a cloud-based maintenance and repair tracking solution. Prior to this, maintenance and repair data was tracked manually in ad-hoc spreadsheets and/or databases. Developed a solution to export data from our Labwatch monitoring system into SQL Server. This allowed changes in the monitoring system to be synchronized with various other databases and enabled the creation of a Visio based facility map. This map gave a visual representation of the status of over 600 freezers and storage units in the facility. A similar map had previously been manually maintained in Excel. Forms for the storage units which had to be manually updated could updated electronically, saving hours of labor. The solution was later modified to alert appropriate staff via email when temporarily disabled alarms were not re-activated by the end of the day. Domain Administrator for in-house Windows domain.

Hired full-time by Northrop Grumman after working as a contractor for 10 months. Provided second-level telephone, remote and on-site support for all state agencies served by the VITA-NG Partnership. Service area covered over 12 counties, 8,000 computers and 10,000 users.

Contracted to Virginia Information Technologies Agency (VITA) to provide help desk and desktop support services for several agencies of the Virginia state government. These included: * Virginia Department of Transportation: First-level help desk and desktop support for VDOT Northern Virginia District (1100+ workstations and laptops). Answered help calls by phone, email or walk-in. Entered tickets into ITSM tracking system. Used LANDesk to remote to users’ machines and resolve issues where possible. Escalated tickets to other teams such as network or hardware as needed. Imaged systems from RIS server and added to Active Directory domain. Set up user profiles and specialized applications on newly-imaged machines. * Virginia Department of Health: Desktop support and inventory work on an as-needed basis. Inventoried, tagged and updated over 300 assets in six locations throughout Lord Fairfax Health District, a six-county area in northwest Virginia. Helped update 50+ assets for Rappahannock/Rapidan Health District. * Gunston Hall: Applied service packs and patches to 12 machine peer-to-peer LAN.

Worked as a self-employed independent contractor in greater Pittsburg area. Firms I have worked for: * Compucom/murTech (PNC Bank) As part of a five-member team, located over 300 laptops that had not recently been connected to the corporate network. Upgraded Marimba Client and added laptops to Active Directory domain as needed. Reported status of missing assets to Network Services personnel. * The Computer Merchant (Computer Services Corp./Bombardier Transportation) :Resolve discrepancies in asset inventory by pinging remote workstations and contacting users to determine network status of assets. Removal of hard drives and prepping outdated assets for disposal. * Smart Source, Inc. (Special Counsel):Image Windows XP workstations using Ghost and configuring them for proper operation. * Patriot Technologies (ADT, Getronics/Home Depot, Allstate, CitiFinancial) : Install various types of hardware at sites in and around Pittsburgh, working with client IT staff as needed to ensure proper connectivity and operation, including: Routers, Wireless LAN Solution Engine (WLSEE) units, Workstations (Windows 2000/XP), single/dual monitors, image workstations using Ghost (remote and local), site surveys for upgrade compatibility.

* Presented proposals to senior leadership outlining how to use Information Technology to increase productivity and provide better care to residents. Many ideas were implemented, including * Purchase or develop new software to centralize records and provide access through a web-based interface. * Create computerized versions of often-used forms to speed data entry, and implement a document control system. * How to implement new software to ease transition. * Created documents in MS Office that replaced forms that previously had to be hand-written. Developed an Excel spreadsheet that tracked staff contact hours with clients on their caseloads. Created Word documents using form fields to standardize user input for the agency planning system. * Selected to be part of the team that completely redesigned and improved the corporate website. * Served on two company committees that evaluated policy and made recommendations for change. One committee dealt with implementing HUD regulations and the other dealt with security and privacy policies.

* Two years systems administration on a Windows NT 4.0 (later Windows 2000 Small Business) based LAN. Performed hardware and software installation and repair, maintenance, training and support to 25 - 30 Windows 95/98 SE/XP workstations with 60-70 users. Responsible for configuration and maintenance of user accounts and MS Exchange accounts, performing daily and weekly server backups using ARCServe and weekly backups of the Exchange email system. Installed and configured new workstations.* Desktop and break/fix support via phone, email and in-person.* Assisted the Director of Information Technology in migrating company network from two servers running Windows NT 4.0 to a single server running Windows 2000 SBS. Also assisted setting up the network after the company moved to a new location where the server and all workstations had to be moved.* Used both MS Office 97 and 2000 at an expert level, including some application development using MS Access. Developed three applications from scratch in MS Access to share information between departments. One was later adapted for use as a part of the company's central Information Management System. Supported applications previously developed in Access, expanded their capabilities, and provided installation, tech support and training to both in-house staff and external customers who purchased our systems.* Developed an Access application for a client, tied to their existing FoxPro-based HR package, which was later modified for use in-house to simplify tracking employees' training status.* Created documents in MS Office 97/2000 in Word, Excel and PowerPoint utilizing OLE and VBA. Several documents and presentations were used in training new employees.* Extensive hands-on experience with Visual Basic for Applications in Excel, Word, Access and Outlook, including OLE Automation and Data Access Objects.