Brett C. White

*** ******* *****

Macedonia, Ohio 44056

acyg6k@r.postjobfree.com

440-***-****

http://www.linkedin.com/pub/brett-white/23/ab1/713

PROFESSIONAL EXPERIENCE

SQL Developer

Talis Clinical LLC, Cleveland, Ohio February 2016 – December 2016

Responsible for the design, development, testing, and maintenance of the schema DDL scripts for SQL Server 2008 and 2014.

Engineer views, stored procedures, SQL Job and triggers for Advanced Clinical Guidance software.

Subject matter expert for developers on DDL and DML standards.

Managed Backups and Maintenance Plans for SQL Server 2014 databases.

Created process to move SQL scripts from development to production.

Setup and maintain SQL Server 2014 HADR environment.

Database Administrator, R&D

Oracle/MICROS-Retail, Solon, Ohio July 2011 – January 2016

Responsible for the design, development, testing, documentation, and maintenance of the schema DDL install and upgrade scripts for both SQL Server (2005 and above) and Oracle (10g, 11g, and 12c).

Engineered views, stored procedures, and triggers for interface software between our products and 3rd party applications.

Subject matter expert for developers on DDL standards and DML.

Crafted utility stored procedures for database maintenance, and non-Unicode to Unicode conversion, and functions to convert binary to base64 and base64 to binary.

Troubleshot database issues for internal and external clients.

Responsible for creating and maintaining data models including data definitions in ER/Studio Data Architect. Utilized the data models to create the Database Dictionaries for the POS, CRM, and central databases.

Authored and troubleshot jasper reports used by the POS systems and central database application.

Senior Applications Developer/SQL Server DBA

US Auto/Stylin Concepts, Independence, Ohio November 2006 – July 2011

Responsible for the design, development, testing, documentation, deployment, and maintenance of Web and Windows Applications written in C# 2005/2008/2010.

Created and deployed Crystal and Reporting Services Reports.

Engineered, tested, documented, deployed, maintained, and administered SQL Server 2005/2008 Databases, Tables, View, Stored Procedures, User Defined Functions, and CLR Stored Procedures and User Defined Functions.

In charge of setting up SQL Server 2005/2008 Log Shipping, Mirroring, and Replication.

Brett C. White

954 Elmwood Drive

Macedonia, Ohio 44056

acyg6k@r.postjobfree.com

440-***-****

http://www.linkedin.com/pub/brett-white/23/ab1/713

Senior Software Systems Programmer/Business Intelligence Infrastructure

Progressive Insurance, Mayfield, Ohio February 2003 – October 2006

Responsible for the installation, development, testing, and maintenance of the Crystal Enterprise Infrastructure, the SQL Server Analysis Services 2000/2005 Infrastructure, and the SQL Server DTS/Integration Services Infrastructure which all interact with SQL Server, Oracle, and DB2 databases.

Supported desktop installations of Crystal Report, Crystal Analysis, Pivot Table, SQL Server 2005 Client Tools, and Analysis Manager.

Engineered C# and Visual Basic programs to monitor servers in all of the BI Infrastructure and writes the data to a SQL database.

Engineered C# ASP .Net programs to help my management team manage the projects their direct reports are on and a time recording system.

Served as the primary technical contact with Business Objects, the Crystal Products vendor, to correct bugs in their code and fix issue my customer were having with their reports.

Worked with Microsoft to resolve issues with Analysis Services 2000/2005.

Tested Integration Services and Analysis Services 2005.

Served as the primary contact for DTS/SSIS and taught the DTS Automation class.

Troubleshot issues with customer’s Reports, Cubes, DTS/SSIS, and web applications.

Engineered Crystal Reports and Crystal Analysis Reports to display data from Relational and OLAP sources.

MILITARY EXPERIENCE

US Army (National Guard & Reserves)

January 1986 – June 2002

Ranks: Private – Captain

Positions

Detachment Commander

Battalion Signal Officer

Company Executive Officer

Regimental Assistant Intelligence Officer

Maintenance Platoon Leader

Ground Surveillance Radar Operator

EDUCATION

Bachelor of Science in Electronic Technology

The University of Akron, Akron, Ohio

Microsoft Certified System Engineer – NT4

Microsoft Certified Professional + Internet

PROGRAMMING SKILLS

T-SQL, Basic, Visual Basic, C, C#, ASP, ASP.NET,

SQL Server 2005-2014, Analysis Services 2000/2005, DTS/Integration Services,

Oracle 10g/11g/12c

Community Service

Boy Scouts of America – Troop Committee Chairman(2016-present),Assistant Scoutmaster/Patrol Advisor(2011-2015).

Cub Scouts – Cubmaster (2009-2011), Assistant Cubmaster(2007-2009), and Den Leader(2006-2014).

Contact this candidate