IT SpecialistDeveloped and administered custom database applications using Microsoft SQL Server as a back end and Microsoft Access as a front end. These database applications were secured using Microsoft Access User-Level Security and SQL Server roles and schemas, and were accessible by multiple simultaneous users with varying levels of access. Record changes were logged and data was backed up on a weekly basis. Coded extensively in Visual Basic to customize form and report behavior, validate input data, maintain data integrity, as well as to manipulate and format data pulled from and written to the backend SQL Server databases.Used Microsoft Access, SQL, and Visual Basic to facilitate data entry, implement data validation, and generate reports and queries.Used Microsoft Access, SQL Server, Microsoft Excel, SQL, and Visual Basic to analyze, manipulate, aggregate, and present information extracted from various data sources in specified formats according to varying requirements as they arose, within established deadlines.Provided desktop IT support and excellent customer service to over 600 users within the department. Served as point of contact on all IT issues within the department, to include installing hardware and software, setting up workstations, managing user accounts, troubleshooting day-to-day equipment failures, software problems, and network connectivity issues.Provided technical advice and guidance for managers and employees and other organizational elements. Provided IT-related training and consultation support services to employees.Created and customized various SharePoint sites, web parts, workflows, and sub-sites. Created custom page layouts using Microsoft SharePoint Designer. Created custom integrated forms using InfoPath. Maintained and implement SharePoint site security. Procured and maintained accountability of all IT equipment for the department. Conducted quarterly inventories to maintain accountability of assets.