David Gillett

Sierra Madre CA

626-***-**** / adlkd3@r.postjobfree.com

SQL Database Developer/Architect

MCSE in Data Management and Analytics / MCSA in SQL 2016 Database Development

SUMMARY

Microsoft-certified SQL 2016 Database Developer

T-SQL programming expert with over 20 years of experience

Industry experience: Insurance, Financial, Legal, Heathcare, Insurance

Led several full life-cycle database development projects using SQL Server 2008/2012. These projects involved all phases of development from business requirements gathering through transfer to production support.

As a database architect, designed and built several data warehouses from scratch. Reviewed and improved enterprise database designs.

Optimized code efficient by using performance tuning skills for complex queries and stored procedures. Analyzed query plans to solve performance problems utilizing indexing strategies, query hints and SQL Server configuration

Knowledge of implementation of SQL Server best coding practices gained from 20 years as a database developer.

TECHNICAL SKILLS

Languages

T-SQL, PL-SQL, VB.NET, ASP.NET, VB6, ASP, HTML, CSS, JavaScript, VBScript, VBA, XML/XSD/XLST, JSON

Databases

MS SQL Server 2005 / 2008 / 2012 / 2014 / 2016 / 2019, Oracle 11g

O/S

Windows Server 2012, 2012 R2

Software

SSIS, SSRS, Erwin, Visio, Excel, Project, PowerPoint, SourceSafe, SourceGear, OpenText Content Server

Tools

DOS batch scripting, PowerShell scripting, RedGate suite

PROFESSIONAL EXPERIENCE

QTC Management, San Dimas CA October 2018 – Present

Database Developer

Make continuous improvements as lead developer on Data Warehouse

Perform code reviews for all database code

Review database architecture of all new database applications

LD Products, Long Beach CA

through DesignMind Sept. 2018 – October 2018

BI Developer

Designed and built data warehouse from scratch to support Marketing department

Planned extensions to other departments

Trained inhouse developers to implement ETL framework

Developed robust ETL process for data from multiple sources

Relation Insurance, Los Angeles CA

through DesignMind May 2018 – Sept. 2018

BI Developer

Improved SSRS report performance by refactoring stored procedures

Increased the speed of converting reports from Crystal to SSRS

Simplified and improved data flow processes integrating newly purchased companies

Improved consistency of data flow processes by clarifying logical and physical data models

Answer Financial, Encino CA October 2017 – March 2018

through KForce

Database Administrator

Reduced lag time for responding to Business Intelligence team requests

Identified locations of Personally Identifiable Information (PII) in all production databases as part of an initiative to reduce the PII footprint by Answer Financial’s corporate parent (Allstate)

Regularized the Business Intelligence’s team access to all databases. Great care was needed to not interfere with the teams’ ability to do their jobs.

Reduced SQL Agent job failures by analyzing all failures and working with the BI team to correct them.

Set up regular process to refresh statistics and rebuilt or reorganize indexes.

Independent Sql Developer Consultant, NY and CA March 2015 – October 2017

Designed logical and physical database architecture, including models and schemas

Programmed database objects: stored procedures, functions, triggers

Provided troubleshooting of problem queries using query plans, trace and profiler

Designed and built ETL flows in SSIS to support data warehouse operations

Bessemer Trust, Woodbridge NJ January 2003 – October 2014

Database Analyst/Developer

Technical lead on a 4-year project to replace a customized DMS based on FileNet Content Services with a SQL Server backend with an installation of OpenText Content Server with an Oracle backend. The company successfully transitioned to an up-to-date, powerful document management system providing increased overall efficiency and reliability

Converted complex T-SQL stored procedures to PL-SQL for enterprise applications that interacted with the DMS (Workflow, Check Processing, Tax Reporting, etc.) resulting in a seamless migration to the new system.

Administered a SQL Server database which functioned as the backend for a customized DMS based on FileNet Content Services maintaining a high level of user satisfaction until the application was decommissioned.

Tuned query performance using SQL Server Enterprise Manager to identify necessary indexes, query hints and rewrites which resulted in stellar application performance.

Created a nightly process to import and reconcile extensive enterprise data into

DMS database using SSIS which integrated the DMS into the enterprise.

Created a reporting system to provide senior managers with reports on all aspects of the application: performance, usage, metadata utilization, data integrity which allowed them to address user concerns and guide needed development.

Sitrof Technologies, Woodbridge NJ February 2002 – January 2003

Database Analyst/Developer

Performed data modeling for a customized DMS for Bessemer Trust, including logical and physical design of the database schema.

Led full life-cycle database development for the application, including complex T-SQL stored procedures which provided access to the DMS front-end as well as other enterprise applications.

Tuned query performance using SQL Server Enterprise Manager to identify necessary indexes, query hints and rewrites which resulted in excellent application performance.

Consolidated Edison, New York NY

through Aetea Information Technology July 2001 – December 2001

Senior Analyst/Developer

Performed business analysis with in-house attorneys to port Legal Case Management System from a DB2 mainframe application to the ConEd Intranet.

Wrote SQL queries against a DB2 mainframe which allowed the firm to maintain its legacy back-end while moving to more modern front-ends.

Wrote intranet app using ASP using AJAX-like techniques to provide a web application that performed like a thick-client application.

Lifetime Television, New York NY

through Spherion Staffing Services December 2000 – June 2001

Senior Business Analyst

Supervised a team of business analysts in the integration of a new billing system which resulted in a solid requirements document on which the client could base their design.

Interacted with a national sales team to ensure that business needs were addressed across the organization which resulting in user buy-in from all sales offices.

Blackberry Technologies, New York NY April 1999 – November 2000

Project Manager

Led a team of specialists to maintain and extend a complex portfolio management, analysis and reporting system for Donaldson, Lufkin & Jenrette which enhanced DLJ’s ability to take advantage of rapidly emerging business opportunities.

Managed the full-development lifecycle for enhancement of DLJ’s Deal modeling method, based on XML, to support a web-based version of the system which allowed DLJ’s traders to quickly access reports in support their trading activities.

Kept abreast of constantly changing client needs and managed the team to extend the system’s functionality, often resulting in releases on a weekly basis which kept the application relevant in a fast-moving company.

Proskauer Rose, New York NY May 1993 – March 1999

Intranet Analyst/Developer

Created first company intranet which allowed departments to share information and documents within and between departments.

Created web pages for each practice area and implemented upload methods for business users which resulted in the business users being in control of their own content.

Wrote company directory application using ASP and T-SQL which allowed employees to more easily identify and interact with colleagues in a rapidly growing company.

DMS Manager

Managed PC Docs installation; provided 2nd tier support for document issues

Migrated 200,000 documents from file folders into PC Docs

Managed stakeholders from all departments so that document metadata would serve their needs

EDUCATION

Master’s Degree in Theater, University of North Carolina at Greensboro

Bachelor’s Degree in Music, Wesleyan University, Middletown CT

Contact this candidate