Sql Server Data

CYNTHIA SOLLERS

Renton, WA *****

Phone: 425-***-****

Email: abhxyv@r.postjobfree.com

Objective: To obtain a Data Analyst position.

RELEVANT EXPERIENCE

January 2010 - Present I am currently taking SQL Server 2008 classes

through Bellevue College.

In TSQL have increased my knowledge in queries including full, self,

subqueries, derived tables, and correlated queries. I worked on

merge, CTE, ranking functions, views and sprocs. In SSRS I have

created reports with drillthroughs, dashboards, and charts. In SSAS I

have created cubes from a data mart and learned to pull a slice of a

cube into a spreadsheet. In SSIS I have created packages to pull data

from one source put it into a data mart.

July 2007 - October 2009 - Temporary assignments- Molly Brown Temp

Agency Bellevue -Temporary work

January 2004 - October 2006 - Care Provider for Family Member and

Volunteer

1998 -June 2003 - PROGRAMMER/ANALYST I-CITY UNIVERSITY, Bellevue

For reports I would gather business requirements, create queries, and

join tables to create reports from simple labels, data validation

checks, financial or statistical data for administrative staff to vice

presidents. I used Access, Excel, Word, Crystal Reports, SQL Server,

and Unisys software. One of my development projects was to automate

the process of paying instructor salaries from a combination of manual

and spreadsheet process. When technical issues arose from access

rights, training, or printing issues, I resolved them.

1993 - 1995 - SYSTEM SUPPORT ANALYST-REGIONAL TRANSPORTATION DISTRICT,

Denver

Trouble-shoot problems with custom software for planners and

schedulers to alleviate situation. Modified Fortran 77 program on

Prime computer to interface with MAC QUARK software and modified

program to include new data requirements for bus system. This saved 3

man days of editing time. Wrote new Fortran 77 program on DEC ALPHA

to list number of bus blocks for a single route.

1989 - 1993 - ASST SUPERVISOR & SERVICE MONITOR SUPERVISOR-REGIONAL

TRANSPORTATION DISTRICT, Denver

Supervised 18 data collectors and 1 assistant to maintain a $500,000

annual budget. Designed and wrote documentation for ridership

reporting, transit scheduling system operation, and bus stop inventory

collection. Previous documentation was unorganized, sketchy, or non-

existent.

1985 - 1989 - DATA ENTRY ANALYST-REGIONAL TRANSPORTATION DISTRICT,

Denver

TECHNICAL SKILL SET

LANGUAGES AND OPERATING SYSTEMS

PC WINDOWS98, WINDOWS2000, WINDOWS, DEC ALPHA UNIX, PC LINUX

SQL Server 2008, T-SQL, SSIS, SSAS, SSRS, SharePoint, Visual

Studio, Visio

APPLICATIONS SOFTWARE

MICROSOFT OFFICE PRODUCTS: EXCEL, WORD, OUTLOOK, ACCESS,

POWERPOINT

EDUCATION

B.S. - Business Information Systems, Cum Laude -UNIVERSITY OF COLORADO

- Denver, 1994

BELLEVUE COMMUNITY COLLEGE - Bellevue, 1998, 2003, 2010

REFERENCES UPON REQUEST

Contact this candidate