Sql Server Customer Service

Lisa Adkins

*** **** **** . *********, ******** *1826 . 423-***-**** .

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

Summary of Qualifications

. Deadline-oriented, thrives in fast-paced, front-line environment.

. Offers extensive experience in program decision making, data support for

customers, and vendor coordination.

. Utilizes all means necessary to get jobs done accurately and concisely.

. Functions effectively in either autonomous or team-driven, results-

oriented work environment

. Contributes conscientiousness and self-motivation.

ETL Tools: SQL Server 2005 SSIS, SQL Server 2000 DTS, DataStage

Databases: Oracle, SQL Server

Programming Tools: SQL, Transact SQL, PL/SQL Developer Report

Writers: Crystal Reports, SQL Server 2005 SSRS

Professional Experience

Wellspan Health, York, Pennsylvania (currently telecommuting)

Knowledge Management Architect 7/2008-Present

. Designed logical and physical dimensional data model for health

insurance claims system.

. Gathered business requirements for data warehouse.

. Extracted data from health insurance claims system to data warehouse

using SSIS.

. Developed SSAS dimensional model.

. Mentored peers in SSIS and SSRS.

Practice Management Partners, Hunt Valley, Maryland 5/2008-7/2008

Programmer Analyst

. Extracted physician data from database to Excel using DTS.

. Extracted IT management data from databases to Excel using SSIS.

. Created IT management reports using SSRS.

. Created reports from proprietary system data using Crystal Reports.

NationWide Better Health, Hunt Valley, Maryland 5/2007-4/2008

Specialist, Systems Engineering and Administration

. Loaded client medical and pharmaceutical claims data into data

warehouse using DTS.

. Tested proprietary software for medical records management and client

scheduling.

. Created various reports from proprietary database using Crystal

Reports.

King Pharmaceuticals, Bristol, Tennessee 7/2005-5/2007

Application Systems Analyst III

. Loaded pharmaceutical data into data warehouse using DataStage ETL and

PL/SQL Developer.

. Coordinated data flow to and from multiple vendors.

. Directed data extraction to enable highly informative product and

market competitive analyses.

. Teamed with sales and marketing personnel to manage call planning,

goal setting, and achievement tracking.

. Created numerous reports with Crystal Reports for drug sample

inventory management.

Lisa Adkins

PAGE 2

Wilson Pharmacy, Inc, Johnson City, Tennessee 11/1999-7/2005

Systems Analyst

. Developed pharmacy management system in VB.net to analyze insurance

claims data for cost reduction and quality of life improvements for

members.

. Transferred and loaded health insurance claims data into database

using DTS.

. Designed and implemented nursing medical records application in VB.net

for home nursing and therapy services.

. Retrieved clinical data using DTS to provide resources for use in

inventory management, customer service, sales, and marketing support.

. Created reports using Crystal Reports for sales and marketing,

inventory control, nursing homes, and human resources.

. Developed and maintained corporate Web site using DreamWeaver and

Fireworks.

Early Experience

Electrolux, LLC, Bristol, Tennessee 3/1999-11/1999

Sr. Programmer Analyst

Johnson City Medical Center, Johnson City, Tennessee 4/1998-2/1999

Data Warehouse Systems Analyst

Raytheon Company, Bristol, Tennessee 10/1995-4/1998

Senior Systems Analyst

Mead Coated Board, Columbus, Georgia 7/1990-10/1995

Systems Analyst

W.C. Bradley Company, Columbus, Georgia 8/1989-7/1990

Senior Systems Analyst

Philips Consumer Electronics Corp., Knoxville, Tennessee 1/1987-8/1989

Programmer

Education and Memberships

B.S., Computer Science, East Tennessee State University, Johnson City,

Tennessee - Magna cum Laude

Upsilon Pi Epsilon Honor Society in the Computing Sciences

Phi Kappa Phi Honor Society

Alpha Lambda Delta National Scholastic Honor Society for Freshmen

Additional Training

SQL Server 2005 Reporting Services 2009

SAP Business Objects Web Intelligence XI RI/R2 2007

Crystal Reports XI 2007

DataStage Essentials for Server Edition (DX334) 2006

Implemented Database in Microsoft SQL Server 7.0 2000

System Administration for Microsoft SQL Server 7.0 1999

Post graduate studies in Borland C++ and Microsoft Visual C++, ETSU 1998

Contact this candidate