Brian Campbell ***/***-****

**** ******* ***** ****** ****, Kernersville, NC 27284

adyyk2@r.postjobfree.com

EDUCATION

Post-Baccalaureate Certificate in Information Technology Management - 2014

Bryan School of Business - University of North Carolina – Greensboro

(Coursework: Database Management, Network Design,

Web Development, Supply Chain Management)

B.A. Psychology – 1986, University of North Carolina – Greensboro, Dean’s List - Spring 1986

(Additional courses were taken post-baccalaureate including three semesters of Accounting)

CERTIFICATIONS

Microsoft Certified Application Developer (MCAD) - 2009

(VB.net Desktop Applications, ASP.net Web Applications, XML Web Services, AJAX, CSS)

EXPERIENCE

Sandhills Center Greensboro, NC

SQL Server Developer SSMS, SSRS, SSIS (February 1, 2022-Present)

Responsible for creating and deploying SSRS reports utilizing embedded T-SQL and complex stored procedures.

Responsible for creating and deploying SSIS packages for ETL processes along with moving data between database objects and spreadsheet / flat file objects.

Fully fluent in all SQL Server functions, stored procedures, temporary tables, CTEs, ‘partition by’, user defined functions, ETL Merges.

SQL Server 2019 and Visual Studio 2019.

Anomaly Squared Greensboro, NC

SQL Server Developer SSMS, SSRS, SSIS (11/2020-January 31, 2022)

Development of ETL tools for migrating call data from vendor platforms into SQL Server for a high volume call center.

Development of complex Tables, Views, Stored Procedures, User Defined Functions (including iTVF and msTVF), Pivots, CTEs, Merges, Partition_By, Cross Apply on TVFs

Development and deployment of SSIS packages for maintenance and ETL (flat files, Excel, Access) using Foreach Loop Containers for multiple files, Sequence Containers, Conditional Splits, Union/Merge, Execute SQL Tasks, C# Scripting Tasks, Backup Database Tasks

National Board for Certified Counselors, Greensboro, NC

Database Administrator (SQL Server) (3/2015-6/2020)

Responsible for the creation, enhancement, security, and maintenance of various databases with MS-Access front ends and SQL Server back ends using SQL Server 2012 and 2016.

Extensive knowledge of Microsoft VBA within both MS-Access and Excel.

Extensive skills in SQL Server creating views, parameterized stored procedures, triggers, and user-defined functions.

Extended T-SQL development involving pivots, CTEs, complex joins, index maintenance, and partitioning.

Skilled in SQL Server Agent for handling nightly database backups, batch processing jobs, and data migrations.

Skilled in routine SSIS design and implementation for ETL work to and from both Excel and flat files.

CoreLogic (Real Estate Listing Division), Greensboro, NC (Contractor)

SQL Server ETL Developer (3/2014-3/2015)

MS-SQL Server, SSIS

Hanesbrands, Winston-Salem, NC (Contractor)

SQL Server Developer (10/2013-3/2014)

MS-SQL Server, SSIS

Wells Fargo, Winston-Salem, NC (Contractor)

ASP.net Developer (6/2013-9/2013)

ASP.net, VB.net, MS-SQL Server

Lincoln Financial Group, Greensboro, NC (Contractor)

ASP.net / SQL Server Developer (2012-2013)

Developed an online software inventory system to track software purchasing, deployment, and licensing for over 6,500 PC’s.

ASP.net, MS-SQL Server, VB.net, Javascript, CSS

Forsyth County Government, Winston-Salem, NC

Software Developer (2007-2012)

VB.net desktop applications, MS-SQL Server, Oracle PL/SQL, Crystal Reports.

Contact this candidate