• Architect, configure, optimize and manage enterprise-wide SQL Server 2012, 2014 & 2016 databases.• Work with SQL Server databases and designed Tables, Views, Indexes, Stored Procedures, Triggers, Functions• Developed and implemented agency-wide standard practices for code development• Develop enhancements to Web-based .NET (C#) applications• Design and review ASP application architecture; analyze software development process and suggested alternatives

Responsible for: documentation of complex data processing systems, SQL Server, T-SQL programming; preparing detailed system and program technical specifications; deployment of database applications; ensuring data integrity, security, and conformance to ODE standards; performing diagnosis and correction of application/data errors; developing and directing of test data bases and testing of application programs; assisting with implementation of new data bases; assisting with restoration of operations following system failures; and following rollout processes to ensuring successful code deployments. Authored code to enhance and maintain database applications using defined detailed system and application requirements. Coordinated changes to code using T-SQL stored procedures, SSRS Reports, SSIS Packages, triggers, functions, and views to apply to .NET/VB front-end interfaces. I utilized established IT standards and procedures for data base and programming design and I followed rollout processes to ensure successful code deployments to development, test and production environments.

I was responsible for identifying the business needs, designing, developing, and maintaining complex SQL Server databases that track samples, store sample results, QA/QC results, and associated metadata for the entire division. I managed the data repository for all of the environmental data in the agency, including: table maintenance, production of specialized reports and user interfaces. I designed and developed Windows applications for use as data interfaces. I designed and developed InfoPath forms for user data and support requests along with the associated SharePoint Libraries.

Create ad hoc and standard reports using various reporting tools for different functional departments. Maintain data integrity and ongoing quality control of reports. Work with all levels of end users, to define reporting requirements and to quickly develop reports used to make strategic business decisions. Make recommendations from trends in data that help to inform business strategies and decisions. Maintain programs to assure accuracy and correct functioning of instruments and equipment used for Quality Assurance. Manage projects aimed at improving the efficiency and effectiveness of the department.

Assisted in developing, implementing, and adapting procedures to ensure accurate entry, modification, and retrieval of data from the Department’s database and other electronic systems. I provided technical support for staff including: answered technical questions and provided training/troubleshooting for software and hardware related issues. Utilizing SQL, Visual Basic and Crystal Reports I programmed and administrated a number of highly complex databases including: designing the table and directory structure; programming the forms, queries and reports; and linking to external databases. I prepared contract requests and conducted contract administration duties. I also conducted studies related to assigned area, evaluated information and prepared reports that included a thorough analysis of subject along with recommendations on a course of action.

Designed company brochures, advertisements (newspaper & billboard), signs, forms, contracts, and show directories. I programmed and maintained the company websites as well as installed and maintained the company computer, telephone, and voicemail network. I provided technical support to employees including: installation of all software and hardware, LAN/WAN support, troubleshooting, and data back-ups. Using Visual Basic and SQL, I programmed and administrated numerous multifaceted databases including: designing the table and directory structure; programmed the forms, queries and reports; and linked to external databases. I provided training and recommendations to exhibitors on effective trade show display techniques. I supervised all office functions including: invoicing, developed an invoicing schedule, bookkeeping, ordered office supplies, and provided sales support.