Sql Server Developer

DARRELL E. MASSEY

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

***-***-

*734(Cell)

Lewisville, TX 75077

**************@*****.***

SUMMARY OF QUALIFICATIONS

Over twenty years in the Information Services, Database and Software

Administration field. In-depth background in managing database issues for

in-house applications. Maintain security, backups and restoration of

databases..

EXPERIENCE

Tenet Healthcare, Inc., Dallas Texas

8/2010 - 9/2014

HRIS Application Developer

. Developed an maintained queries using TSQL in order to provide reports

related to HR analysis, including but not limited to: employee

turnover and retention, earrings information, benefit deductions, and

PTO balances

. Exported and delivered data to external vendors which managed HR

services such as employee onboarding, Leave of absences, organization

learning and development and benefits

. Imported data from legacy HR data sources from acquired companies to

create a reporting database for legacy employees

. Developed and maintained complex stored procedures.

. Developed and maintained SSIS packages for ETL processes into other

database environments and importing data from different file formats.

. Developed and maintained scheduled report distribution using SSRS.

. Created ADHOC reports using Access and Excel for upper management and

executive levels.

. Created end user applications using Access.

. Developed and maintained SQL Agent jobs that run batch processing.

. Provided data for employee turnover predictive analytics.

US Personnel, Inc. /WorkLife Financial, Irving, Texas

2/2008-7/2009

Database Administrator/Developer

. Managed several SQL Server 2000/2005 Databases for in-house

applications such as Dynamics (Darwin) production and data warehouse

for reporting.

. Monitored using Profiler and tuned database performance.

. Optimized T-SQL queries and stored procedures for optimum performance.

. Maintained database security through user logins and database roles.

. Assisted in providing data availability in disaster recovery plans.

. Provided solution to system failure by developing failover options.

. Utilized data mining techniques to provide information related to

client retention, client employees' benefits, and tax liabilities.

. Developed and maintained complex stored procedures.

. Developed and maintained DTS packages for ETL processes into other

database environments and importing data from different file formats.

. Developed and maintained Access Applications that performed processes

for State/Federal Unemployment reporting, employee 401K participation,

and COBRA eligibility.

. Created ADHOC reports using Access, Excel, Microsoft query and Crystal

Reports for upper management and executive levels.

. Developed and maintained SQL Agent jobs that run application batch

processing.

. Provided desktop and network support as needed.

Excelsior Technical Resources, Dallas,

TX 10/2007-1/2008

Database Analyst/Developer - Contractor for TXU

. Developed Application using Access to Identify report and track the

resolution of contract and billing discrepancies Related to Small to

medium and large corporate accounts.

. Eliminated manual maintenance of Excel spreadsheets.

. Reduced the time and resources necessary to effectively perform all

required audits.

. Created many reporting tools to manage and track audit discrepancies.

. Developed extract procedures and processes from Oracle using PL/SQL as

source data for the audits.

. Developed application interactivity using VBA Coding and techniques.

The Walt Disney Company/ABC Radio Networks, Dallas, Texas 9/1999-

9/2007

Database Administrator/Developer

. Managed several SQL Server 7.0/2000 Database issues for in-house

applications. Databases ranged in sizes from 4 GB to over 450 GB.

. Increased data high availability by reducing time requirements of

maintenance.

. Created ADHOC reports using Access, Excel, limited Cognos and limited

Crystal Reports for upper management and executive levels' use.

. Monitored using Profiler setting up traces and tuned database

performance.

. Optimized T-SQL queries and stored procedures for best performance.

. Maintained database security through user logins and database roles.

. Assisted in providing data availability in disaster recovery plans.

. Provided solution to system failure by developing database replication

and failover options.

. Developed and maintained complex stored procedures.

. Developed and maintained DTS packages for exporting data into other

database environments and importing data from different file formats.

. Developed and maintained SQL Agent jobs that run application batch

processing.

. Used Visual Basic 6 and PowerBuilder 6.5 to maintain applications

through enhancements and defect repairs.

. Developed and maintained Access Applications for Radio Disney.

Accelerated Christian Education, Lewisville, Texas

4/1990-9/1999

Database Administrator/Developer

. Provided database support in a SQL Server 7.0, SQL Server 2000, and

Informix environments.

. Managed database backups.

. Managed SQL Agent jobs.

. Developed and maintained stored procedures and queries for reporting.

. Maintained in-house applications using Visual Basic 4.0/6.0.

. Provided Network Support.

EDUCATION AND TRAINING

Executrain Dallas, Texas

2001

Certificate - MOC 2073: Programming SQL Server 2000 Database

Certificate - MOC 2072: Administering MS SQL Server 2000 Database

Certificate - MOC 2071: Querying SQL Server with Transact SQL

Certificate - SQL Server 2000: Database Design

Texas Institute, Dallas, Texas

1989-1991

Diploma - COBOL Programming

Dallas Christian College, Dallas, Texas

1976 - 1980

Studies in Bible and Biblical Languages

Contact this candidate