Data Sql Server

**** **. ******** **.

Lithonia, GA *****

404-***-**** (C)

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

Tonya L. Davenport

Executive Summary:

Solutions driven business and data analyst with extensive leadership experience. Effective communicator able to explain complex concepts and ideas to individuals at all levels. Well organized and able to handle multiple, diverse projects simultaneously. Additional areas of competencies include:

oInformation Management

oReporting and Analysis

oBusiness Process Development and Improvement

Professional Experience:

2014 – 2017 Aetna, Inc. Atlanta, GA

Sr. Application Support Analyst

Responsible for defining, planning, and monitoring all application support activities for IT applications including trouble shooting, performance monitoring, recommendation of resolution, installation, training, and script/code writing.

Design, extract, load, aggregate and reconcile large platforms of data using MS Excel, Access, SQL, Business Objects, and or other data warehouse analytical and query tools.

Work in conjunction with other database and development teams to ensure all data is moved efficiently in the development and implementation of ETL processes using SQL Server.

Advise development teams on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.).

2008-2014 Aetna, Inc. Alpharetta, GA

Project/ Team Lead

Provide end-user levels II and III support to determine requirements for data, reports, analyses, metadata, training, data quality and performance for the Data Warehouse.

Provide extensive research of complex health care data questions utilizing various skills and techniques, including identification and communication of data issues, in-depth research of root causes of data inconsistencies and business issues.

Perform proactive and reactive analyses to ensure data integrity, debug and troubleshoot issues using .Net programming languages, Visual Basic, SQL and Crystal Reports.

2004-2008 Aetna, Inc. Alpharetta, GA

Senior Consultant

Provided ad hoc market specific and regional data reporting and analysis to support business operations, including the definition of data reporting criteria, report format and statistical analysis.

Worked cross-functionally to collect data and make actionable recommendations at all levels.

Business Systems User Specialist, Alpharetta, GA (2000-2004)

Data Analyst, Prudential Healthcare, Vinings GA (1997-2000)

Education and Training

Tonya L. Davenport

Page 2

Texas Southern University: Information Systems/Business

Interactive College of Technology: Medical Administrative Specialist Certificate

Radium Soft : Diploma in Programming: Visual Basic, Access, SQL Server, COBOL, C+

Toastmasters International: Distinguished Toastmasters (DTM).

Corporate Continuing Education: SQL Server, SAS, Crystal Reports, Microsoft Access, Hadoop, Mosaic, Data Meer, and Hive.

Technical Skills

Honors and Awards:

MS Office: Access, Excel, PowerPoint, Word, Publisher

Crystal Reports

.Net Programming Languages

Business Objects

SAS Systems

DB2 Command Center

SQL Server

Data Warehouse

Tableau

Oracle

DataMart/Data Mining

Business Intelligence

Jira

Visual Basics

Visio

Windows XP and 7

Service Now

Author of self-published book. Step Up Reach Out Make Things Happen: 7 Powers to Win

National Association of Professional Women

Healthy Voice Toastmasters

Recipient of the Division Governor of the Year Award

for Toastmasters International District 14 (State of Georgia)

Contact this candidate