Resume

Sign in

Senior BI Database Engineer

Location:
Seattle, Washington, United States
Posted:
May 31, 2017

Contact this candidate

Agraha Levine

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

Seattle, WA 98103

206-***-****

ac0k0k@r.postjobfree.com

Senior Database Engineer with Expertise in SQL Server for Data Analysis, ETL with SSIS and Reporting with Tableau and SSRS

15 years of work with SQL relational databases, including providing ETL and BI with extremely large datasets, database architecture, extensive SQL Server and Oracle stored procedures and triggers, as well as ETL through Informatica PowerCenter and SSIS, plus Reporting Services.

13 years of object-oriented software application development experience through full life-cycle, with an emphasis on service-oriented architecture and object-oriented design patterns.

7 years of .NET experience with C#, VB.NET, ASP.NET and XML, including Web and Windows applications, as well as Web Services.

Skills

Skill

Skill Level

Last Used

Experience

SQL Server 2016, 2014, 2012, 2008

Excellent

Currently used

15 years

Database Architecture

Excellent

Currently used

15 years

Teradata Database

Good

Currently used

1 year

ERWin

Excellent

Currently used

15 years

Informatica PowerCenter

Intermediate

Currently used

1 year

SQL Server Integration Services - SSIS and DTS Packages

Excellent

Currently used

8 years

SQL Reporting Services - SSRS

Excellent

Currently used

7 years

SQL Server Analysis Services – SSAS Tabular Model

Intermediate

Currently used

6 months

Amazon Databases – Aurora

Beginning

Currently used

2 months

SSAS – Dimensional Model

Intermediate

6 months ago

2 years for SSIS development

SQL Language

Expert

Currently used

13 years

ER Studio by Embaracadero

Good

1

6 months

R

Intermediate year ago

Currently used

5 years

SPSS

Intermediate

5 years ago

4 years

HL7 Data Integration

Excellent

1 year ago

5 years

Tableau Desktop and Tableau Server

Intermediate

Currently used

1 year

PowerPivot

Intermediate

Currently used

1 year

NoSQL with Hadoop and Pig

Exposure

Currently used

6 months

UML, Application Design

Expert

Currently used

13 years

Oracle (PL/SQL)

Intermediate

2 years ago

4 years

MySQL

Intermediate

Currently used

3 years

C#

Excellent

Currently used

9 years

VB.NET and VB Macros with Excel and Word

Excellent

1 year ago

7 years

VS LightSwitch

Excellent

1 year ago

2 years

Web Services, including WS-Security and WS-Trust

Excellent

Currently used

4 years

ASP.NET

Excellent

Currently used

6 years

.NET Framework 3.0, 3.5, 4.0

Excellent

Currently used

4 years, since released

AJAX

Excellent

Currently used

4 years

Visual Studio.NET, including VS 2012 and Visual Studio Team System Database Projects

Excellent

Currently used

7 years

Python

Intermediate

3 years ago

1 year

Service-Oriented Architecture (SOA)

Excellent

Currently used

4 years

SOAP and REST protocols

Intermediate

Currently used

4 years

ADO.NET

Expert

Currently used

7 years

Microsoft Dynamics CRM

Intermediate

Currently used

6 months

Silverlight

Intermediate

Currently used

1 year

ASP.NET MVC

Intermediate

Currently used

2 years

OR Mapping with LINQ, Entity Framework and LightSpeed

Intermediate

Currently used

2 years

Javascript

Intermediate

Currently used

4 years

JQuery

Intermediate

Currently used

1 year

Visual Source Safe

Excellent

1 year ago

13 years

Agile, SCRUM Development

Excellent

1 year ago

2 years

Team Foundn. Server

Intermediate

1 year ago

1 year

Object Oriented Development

Expert

Currently used

13 years

Access Database

Expert

Currently used

15 years

EXPERIENCE

6/2016-current

University of Washington

Seattle, WA

Senior Database Developer

Modeling data from a wide range of disparate data sources – mostly on client-side systems – onto a shared server-side SQL server.

Extensive Tableau and DOMO development – creating SQL Server stored procedures, working with Tableau Desktop and Tableau Server to publish the visualizations all using underlying stored procedures. Similar development with DOMO.

Using SSIS to map and perform the requisite data transfers from Excel and Access to SQL Server. Creating SQL Server and Access file backups on a daily basis.

Selecting and designing rapid development web-based data-intensive tools to replace the current client-side tools.

7/2014-5/2016

The Mountain-Whisper-Light Consulting

Seattle, WA

Senior Database and Business Intelligence Engineer

Moving large amounts of existing health care claims data into Teradata using Informatica PowerCenter to transfer data from flat files and other database sources.

Identifying processes for acquiring, cleansing and configuring claims data into the company-wide new database warehouse. Creating workflows through Informatica, as well as UNIX scripts to assist with automated ETL processing.

Writing packages in Oracle to transfer data from one data ingestion database to a normalized primary operating database.

5/2014-7/2014

State Board of Community and Technical Colleges & University of Washington

Olympia, WA & Seattle, WA

Senior Web Services and Database Developer

Creating RESTful web services through an MVC Web Application in ASP.NET in order to allow community college and technical college students in Washington State to see which of their courses will be accepted for how many credits if they transfer to University of Washington. Also creating SSIS packages to transfer data from older IBM data to SQL Server which the web services will employ.

8/2013-4/2014

The Mountain-Whisper-Light Consulting

Seattle, WA

Database Architect with BI Development

Architected data model for dimensional data. Analyzed client data using SSAS tabular model to evaluate the role of multiple dimensions and a few key facts on fisheries data. Transformed data in traditional normalized operational formats with SSIS to a data warehouse with data better suited for dimensional modeling. Created the SSAS model and analyses. Created daily SSRS reports as well off the dimensional data. Used data in warehouse for PowerPivot analyses. Developed with SQL Server 2014. Examined relationships between dimensions using R for multiple statistical evaluations.

Database Developer for Mobile Client with Big Data

Creating complex ETL processes using SSIS and underlying stored procedures in SQL Server Management Studio.

Architected multi-dimensional model. Designing facts and dimensions for SSAS multi-dimensional model to use as main datasource for reporting.

Wrote VBA macros inside Excel spreadsheet templates to assist Excel users in preparing spreadsheets used as sources for SSIS processing.

Recommending new reporting and analysis tools to work with very large data including Pentaho and Tableau.

Exposure to Hadoop clusters and Pig scripts for loading and extracting massive datasets.

1/2011-7/2013

Medical Consulting Network

Seattle, WA

Database Programmer and Software Developer

Installed and maintained SSRS platform for the company. Re-wrote all the SQL Server stored procedures and created new reports to fulfill existing and newly requested reports for the company, including creating new functions. Created PowerPivot reports for easy analysis inside Excel.

Developed complex SQL algorithms for sales, commissions and operations reports. Created automated synonyms for writing our own procedures and functions in custom database which refer to the Microsoft CRM objects, but run in their own database space.

Architected model for reporting database for all CRM reports. Developed several ASP.NET applications to interface with new Microsoft CRM system to run the company business including Cover Letter Wizard, report generator, letter generator.

5/2010-12/2010

The Mountain-Whisper-Light Consulting

Seattle, WA

Software Developer for PEMCO Insurance

Modified free time-tracking application to be used on an enterprise-wide level as an in-web application thereby saving the company large amounts of money with its per-user licensing and complex on-line time-keeping data entry. Added AD authentication with SQLServer authorization as one of three roles. Created new classes and stored procedures to accommodate users and task information through which users and their supervisors can show or hide tasks of interest. Used VB.NET 2010 with .NET 4.0 and SQLServer 2008.

Created many reports in SSRS and set up test and production web environments. Helped mentor co-workers on using and designing an SSIS project and an ASP.NET web application to move various data sets into SSIS and view the modified data in SSRS.

Software Development Engineer for Seattle Health Care Clients

Conducted analyses of existing data in R to identify key relationships amongst existing dimensions. Supported existing proprietary SSIS, SSRS. SSAS and SQL Server database solution for health care providers to evaluate patient concerns through evaluating large datasets of questionnaire results with a central portal. Include ed extensive HL7 data integration to transfer specific data elements to specific providers and provider agencies for review. Created and updated many reports with supporting stored procedures. Wrote macros in Excel and Word for use in improved SSIS projects which import data feeds.

10/2008-4/2010

Cell Therapeutics, Inc.

Seattle, WA

Database Architect and Senior Systems Analyst

Created PAL web application (Payroll Application Link) with C#, ASP.NET with AJAX and SQL Server Integration Services (SSIS) to transfer line-item payroll data from bi-monthly flat file into aggregated data for Oracle EBS system, including extensive user checks and approvals throughout the process. Use of Web Services for data transfer.

Architected database for order tracking. Created two other web applications using the order flow database with C#, ASP.NET and Oracle for human validation of order flow and transfer into a larger CRM system.

Co-ordinated company efforts to migrate to a new web-based human resources-payroll application. Created another SSIS process to transfer data from a daily flat-file extract feed into an in-house Oracle database.

1/2008-10/2008

Zynchros

Seattle, WA

Software Developer with SOA and Web Services

Architected Member Formulary Hosting database to include formularies, drugs and therapeutic alternatives. Developed a new service-oriented web-services application using C#, ASP.NET and SQL Server. The Member Formulary Hosting application helps users of health insurance companies to learn about their medications and also view possible alternatives. Developed sample user pages to demonstrate how Zynchros insurance customers could display the information from the Web service calls.

Used ASP.NET with extensive AJAX controls, custom links and messages for a highly interactive and efficient member experience. Work with many third-party controls, including the Telerik suite and ASP.NET AJAX controls. Created a client-sided drop-down, type-ahead custom control using mostly Javascript. Created SQL databases for the app.

LICENSES, TESTS

5/2014

BrainBench

SSRS Testing

Scored in top 3% for 2012 SSRS test with the note: “Demonstrates a clear understanding of many advanced concepts within this topic. Appears capable of mentoring others on most projects in this area.”

EDUCATION

University of Washington US-Washington-Seattle

Professional

Completed all course work for PhD in Psychology, passing Prelim Exam, designing and completing PhD study, and analyzing all the data. Extensive medical training.

Stanford University US-California-Stanford

Bachelor's Degree

BA, Cum Laude and Phi Beta Kappa

EXTRACURRICULAR INTERESTS

I am very active in humanitarian service activities to many African and Asian countries procuring and sending medical supplies, educational equipment, clothing and food. Partnering with such organizations as the Nelson Mandela Children’s Fund, Desmond & Leah Tutu Foundation and Mother Teresa’s Missionaries of Charity.

WORK STATUS

I am a US citizen and authorized to work for any employer.

LANGUAGES

Languages (written and spoken): English, French, Spanish, with basic communication in Indonesian and Russian.



Contact this candidate