TECHNICAL SKILLS:

• SQL Server 2000
• Microsoft Windows 2000
• Microsoft Windows 2003
• Microsoft Visual C# .NET
• Microsoft Visual Basic .NET
• Microsoft Visual C++ .NET
• Crystal Reports 9 for Visual Studio .NET
• Microsoft Visual C++ 6.0
• Borland C++ 5.0
• LEADTOOLS Versions 10, 11 and 12

WORK EXPERIENCE:

Confidential, Winston - Salem, NC\ Bentonville, AR

Database Development DBA

Responsibilities:

• Designed and successfully implemented a new process for SSIS within TCH. Migrating over older versions of SSIS packages and transferring from package deployment to project deployment on SQL Server 2014.
• Designed and successfully implemented a new process for automation of SQL scripts and installs within TCH.
• Build virtual servers
• Mentor other TCH personnel on PowerShell, SQL, T-SQL (stored procedures, functions, temp tables, table variables, and CTE s), SSRS, SSIS, DMV s VMWare, Crystal Reports, Tableau, & Microsoft System Center 2012.
• Primary SQL Enterprise Environments include: SQL Server 2016, 2014, 2012 R2, & 2008 R2
• Primary Tools: Microsoft Visual Studio 2013, 2010, & 2008; SSMS, TFS (Team Foundation Server), Red Gate SQL Compare 11.5, PSSDIAG, Nexus, Spotlight, Visio 2013, SharePoint, VMWare, HP Fortify, CA PPM (CA Project & Portfolio Management), ADP Workforce, and Microsoft System Center 2012
• Secondary Tools: Tableau 10 and Crystal Reports 2011.
• Primary scripting tools include common command line, PowerShell, vb script, and sqlcmd
• Primary OS: Windows Server 2012 R2 DataCenter, Windows Server 2008 R2 DataCenter
• Primary Clearing House Products: CHIPS, CHIPSLSIM (CHIPS Liquidity Simulation), STS, EPN Access, SVPCO, Online Adjustments, Same Day ACH, EBIDS, UPIC, and DTA Image

Confidential, Lowell, AR

Server Engineer/Network Engineer

Responsibilities:

• Work closely with application and DBA groups to meet project goals
• Primary server environments that have been/are responsible for include the following: Continuous Integration, Polarion, Planview, SharePoint, SSIS, other proprietary ETL env., SSAS, SSRS, Cognos, HP Service Manager, Computron, Fuel, Mileage, WSUS, Splunk, Bizlink (Electronic Data Interchange), FTP (Internal & External), HP CAE, DDMI, Core Install, License Activation, Solarwinds, SNMPc, File Share, Symantec Anti - virus, & Microsoft Endpoint Protection.
• Manage servers with Microsoft System Center 2012 including Configuration Manager, Service Manager, Operations Manager, & Orchestrator; developing several SSRS reports with backend stored procedures for the environment - that are used by the Information Technology departments and the company as a whole- including Outage & Availability Reporting for Servers; Incidents, Change Request Management, & Problem Management utilizing a backend DataMart with tables of billions of rows
• Responsible for as the primary engineer of 237 servers at one time.
• Manage servers with a heavy emphasis upon automation - especially in the build process & in disaster recovery situations.
• Primary scripting tools include common command line, PowerShell, vb script, rexx, and sqlcmd
• Primary Development Tools: Microsoft Visual Studio 2013, 2010, 2008, & 2005; and SQL Server Management Studio
• Primary OS: Windows Server 2012 R2 DataCenter, Windows Server 2008 R2 DataCenter, & Windows Server 2003
• Primary SQL Enterprise Environments include: SQL Server 2008 R2, SQL Server 2012 R2, and SQL Server 2014 and components of Database Engine, Reporting Services, Analysis Services, and Integration Services
• Work with SQL Cluster Quorum groups with HA (High Availability)
• Responsible for several POC (Proof of Concepts) with the successful evaluation of several software applications for purchase.

Confidential, Tontitown, AR

Database Systems Analyst

Responsibilities:

• Primary Developer of T-SQL code for Microsoft SQL Server 2005 Environment
• Primary Developer of SSRS reporting
• Database Management of Microsoft SQL Server 2005
• Determined the best course of action pertaining to the design, data retrieval, and accessibility control to a Relational Database Management System from a management proposal. This assisted me to attain the most accurate, reliable, efficient, and normalized finished product.
• Worked closely with the application programmers to help determine their data retrieval and end result needs and then develop stored procedures and functions to meet those needs
• Requirements analysis, developed, and maintain a robust in-house Document Storage & Retrieval System
• Designed & developed Master documents for the Document Storage & Retrieval System to be used as Templates where their form fields could be populated with XML information from the database.
• Developed and maintained SQL insertion and data retrieval code regarding Microsoft Great Plains version 10.0
• Developed in SQL Server Reporting Services (SSRS)
• Developed and maintained SQL Jobs
• Developed and maintained automated email notifications and user tasks
• Maintained a WebService in Microsoft Visual Basic 2008 .NET
• Maintained an application in Microsoft Visual C# .NET
• Maintained an application in Visual Basic 6.0

Confidential, Monett, MO

Programmer Analyst

Responsibilities:

• Requirements analysis, design, code, maintain, and support Object-Oriented applications associated with document imaging and the banking industry including OCR (Optical Character Recognition) and web based applications
• Data manipulation in a SQL Server 2000 environment, specialization and instruction/training of other members of the group in SQL Server, network, product, and troubleshooting aptitude
• Support of new product and product domain on over 400 customer sites using between 63 SQL Server 2000 databases and 1,555 SQL Server 2000 databases per customer site
• Project management, interface with other product support groups and vendor relationship responsibility
• Data recovery
• Documentation of SOP (Standard Operating Procedures)
• Most applications were multi-threaded, most use TCP/IP connections to interface with other programs across different platforms including Microsoft Windows 2000 and AS/400, and access to SQL Server 2000 through COM objects are also used in some programs.