Sql Server Data

Adriana R. Mathews

*******@**********.***, Mobile 770-***-****, Home 770-***-****

Key Skills:

Tableau, SQL, MS SQL Server, Excel, SSIS, Data Modeling, Data Design

Experience:

Business Intelligence Data Analyst at CareerBuilder (1/15 to 7/15)

Worked on Tableau to create dashboards for Daily Stats, and Help Desk Ticket Tracking reports, while using SQL Server and Redshift data sources.

Connected reports to Excel, SQL Server, and Redshift tables

Created aggregations, math calculations, date and string conversions

Used effectively groups, sort, filters, quick filters and tooltips

Used different formatting options to improve data presentation with feedback from stake holder

Used parameters for interactive Dashboards, so user could enter date range in the calendar

Wrote logic statements for better manipulation of the data

Developed logical operator functions using If/Else statements for data manipulation on worksheets

Did data analysis, and quality assurance with constant feedback from stakeholder

Defined calculated field specifications according to the user’s report requirements

Published workbooks into Tableau server, so customers can view their reports

Created SSIS packages to move data from SQL Server to Redshift.

Synchronized and automated SSIS packages together, with the purpose of updating and moving data.

Actively, participated in the definition of business rules for reports

Cherokee County Solicitor General's Office (Clerk Interpreter and Translator; Canton, Georgia, 9/12 - 5/13)

Entered, updated, reviewed records into the Criminal Records computer system

Interpreted for the Hispanic domestic victims

Translated documents for criminal cases

Advance PCS (Data Program Specialist; Hunt Valley, Maryland, 02/99 - 8/03)

Created Access reports via ODBC to Oracle and Oracle data marts in concert with end-users and senior staff

Coded, tested and debugged SQL code to meet user requirements using the appropriate tools

Evaluated and made recommendations regarding software tools

Supported end-user data management concerns on an ad-hoc basis

Created and maintaining quality documentation for both technical and non-technical personnel

Assisted in the testing and implementation of the system

Tested databases and data during database systems conversion from Sybase to SQL Server and Oracle

* (After Advance PCS job, for ten years I stayed at home to take care of family)

College Education:

Village Julie College (Stevenson, Maryland 1993-1997)

Bachelor of Science Business Information Systems

Graduation Date: Spring 1997

Grade Point Average: 3.3

References: Provided on request

Contact this candidate