• Build and deploy reports using CCL (Cerner Command Language) and DA2 (Discern Analytics 2.0)• Schedule jobs and reports through OpsView Scheduler (particularly useful for custom CCL scripts and sFTP deliver)• Permission users through Discern Administrator• Setup automated deliver of reports through DA2 (Discern Analytics 2)• Build and deployed SSIS packages using SSIS 2017, SQL Server 2017, Visual Studio 2015, and the SSH.NET library to automate the the secure transfer and retrieval of payment and collections files to vendors via SFTP• Work extensively with T-SQL and SSRS to provide data to directors and practices• Set up communication and jobs between SQL Server and Oracle (via ODBC and Linked Servers) to aggregate data between disparate sources and provide reporting data for billing• Build web applications with .NET and SQL Server where SSRS would not be sufficient• Successfully aggregated and removed duplicates for ~140,000 patient demographic records from 3 separate EMRs (Allscripts, NextGen, Greenway) for import into Athena• Manage and automate the backup plans, maintenance, and jobs for 60 SQL Servers with versions ranging from SQL Server 2000 to SQL Server 2017• Install, configure, and maintain SQL Server instances/clusters, SSIS, and SSRS on production servers• Facilitate the installation of SQL Server service packs by coordinating with vendors and application owners• Maintained formulary updates (FDB) for McKesson HCI

• Managed backups, maintenance, and jobs for SQL Servers• Converted MS Access desktop applications to ASP.NET/C#/SQL Server Enterprise applications• Created SSIS package to export SQL Server 2008 data to Excel 2007 (cannot be done natively had to be built)• Built file comparison package using SQL Server and SSIS to import large groups of before and after text files, compare sets, and output differences• Wrote whitespace parser in C# and WinForms to remove whitespace from text files prior to import into SQL Server• Mentored team members regarding SQL Server, SSIS, SSRS, ASP.NET, and C#

• Responsible for development and maintenance of all SQL Server backups, jobs, and maintenance plans• Maintenance of 12 SQL Servers (2005 and 2008)• Build, test, and deploy SSIS Packages• Creating and scheduling reports using SQL Server Reporting Services• Responsible for the creation of all stored procedures, triggers, and custom queries• Built web applications using ASP.NET 3.5, C#, and SQL Server 2005/2008• Met with clients to gather requirements, determine needs, and demonstrate applications

• Developed applications using PHP5, MySQL 5, JavaScript, and AJAX• Implemented custom PDF reports for clients using PHP, SQL, and Fytek Software• Performed general database duties such as table and view creation, custom queries, query optimization, and indexing• Performed on-call duties to repair and bring failing production code back online

• Developed applications using PHP5, ColdFusion, AJAX, SQL Server 2005 (using queries, stored procedures, views, and triggers) and large custom PHP libraries for Apache Web Servers running on Linux• Performed general database duties such as table and view creation, custom queries, query optimization, and indexing.• Implemented custom PDF reports for clients using PHP, SQL, and Fytek Software• Performed on-call duties to repair and bring failing production code back online.• Met face to face with internal clients to determine software needs and how to make applications a success• Took code from spec to functioning, tested applications with external clients• Managed software through CVS to ensure proper version control and to follow SDLC

• Developed web applications using Java/J2EE that pulled credit card information from the mainframe computers

Wrote custom triggers, stored procedures, and queries in SQL Server 2000 to enable Novell Audit software to track events across the networkConfigured IIS 6.0 to install and secure web applications and web services for Online BankingDeveloped ASP.NET applications using VB.NET, C# and SQL Server 2000 to allow security analysts to maintain a web-based, paperless method of recording security scans and vulnerabilities of serversDeveloped intranet applications using ColdFusion MX7, J2EE, Tomcat, and SQL for delivering reports to customers, executives, and employeesWrote policies in XML to specify the events that needed to be recorded on the network using Novell Audit

Developed custom web sites and applications for customers using ASP.NET, C#, and SQLResponsible for taking sites and applications from customer concept to finished productResponsible for maintaining contact with the customer and performing updates and custom developmentHands on in ALL areas of development including graphics, client and server side development, and database implementationApplications also developed in PHP, ColdFusion MX7, Java, and Flash

• Redesigned company's website taking it from a static HTML site to a dynamic, ColdFusion driven site• Developed HTML email for distribution in monthly e-newsletter• Developed a small username and password protected intranet for employee usage• Kept all clients and servers updated, streamlined, and virus free