Sql Server Data
Resume:
STEPHEN J. NEWMAN
Graham, Washington 98338
**************@*******.***
PROFILE
Database professional with eight years experience in Designing and Developing Reporting Systems Infrastructure. Applied expert knowledge of Business Intelligence concepts accompanied with professional experience translating business needs into effective reporting solutions. Creative and articulate solutions development.
Core Competencies
Data Modeling
SQL Server Reporting Services
Applied Business Intelligence Concepts
Data Visualization
SQL Server 2005\2008\ 2012
T-SQL Programming
Data Warehousing Concepts
SQL Server Integration Services
Query Performance Tuning
.NET Programming
WORK HISTORY
SQL Server Developer; Super Floors (Robert Half Staffing) - Kent, WA June 2016 – Present
Programmed internal reporting applications addressing organizations current needs (SQL Server Reporting Services, T-SQL Programming).
Integrated Super Floors data logic with strategic partners programming applications exposing discrete internal functionality (SQL Server, T-SQL Programming)
Redesigned existing reports improving on design format and content adhering to effective reporting design standards (SQL Server Reporting Services).
Sr. Business Intelligence Developer; Sound Physicians - Tacoma, WA June 2014 – Feb. 2016
Programmed reporting procedures analyzing Performance Metrics using Healthcare Cost and Utilization Project (HCUP) dataset as a baseline (SQL Server, T-SQL Programming).
Designed and programmed Physician Quality Reporting System Suite which improved manager’s ability to easily identify performance outliers (SQL Server Reporting Services).
Maintained ETL process loading Data Warehouse with attention to data accuracy and integrity (SQL Server Integration Services, T-SQL Programming).
Led development of numerous internal Analytical as well as Operational Reports.
Data Analyst III; Garden City Group - Seattle, WA August 2010 – May 2014
Programmed Regression Functions to conduct internal analysis (SQL Server, T-SQL).
Programmed Regression Analysis Report analyzing Claims Application Processing (SQL Server Reporting Services)
Designed Project Tracking System which increased productivity and response time by 80%
Mentored teammates in Designing and Development of Reporting Systems.
Designed and programmed Status Monitor system (SQL Server, T-SQL, and Reporting Services).
Lead/primary Data Analyst for multiple major projects.
Migrated Tenrox Finance and Accounting Reporting System from Crystal Reports to SQL Server Reporting Services format.
Modelled Call Center Management System Infrastructure and Reporting System (Data Modeling, C#, SQL Server Reporting Services).
Lab Assistant; Microsoft - Redmond, WA March 2010 – July 2010
Assisted in the final release phases of Windows Mobile 7 Operating System.
Installed latest Windows Mobile Operating System on well-known/branded manufacturer’s phones (Samsung, LG, ASUS, HTC, et. al.).
Tested functionality comparing actual outcomes to expected performance.
Software Builder & .NET Programmer; Microsoft - Redmond, WA July 2007 – May 2008
Build Teams Merger Project:
Assisted Build Lead in integrating build scripts (Perl).
Modeled Build Status Database to integrate multiple team’s data.
Programmed database functions in build script capturing status data (Perl).
Designed Build Status reports (ASP.NET, ADO.NET, SQL Server 2005).
Revised teams Build Launcher Tool (ASP.NET, SQL Server 2005).
Software Build Management:
Monitored production builds processes.
Addressed build breaks ensuring effective resolutions.
Documented Build System issues and prepared mission-critical reporting metrics.
Debugged build scripts as needed (Perl).
Maintained accurate source control using Source Depot.
Technology Refresh Associate; Costco - Issaquah, WA April 2007 – June 2007
Surveyed existing PCs by gathering technical specifications.
Configured and imaged new PCs.
Deployed approximately 350 new machines for Corporate Headquarters.
Technical Assistant; Center for Real Estate Research - Pullman, WA May 2005 – Dec. 2006
Managed key IT processes for WCRER’s website, Apartment Vacancy System, and Low Income Housing System.
Managed critical web files and databases.
Redesigned Apartment Vacancy reporting code in VB.NET which eliminated need for labor intensive code editing.
Led Low Income Housing project integrating data from an Excel format to SQL Server
Designed physical database using SQL Server for the Database Management System.
Developed an online web form application in ASP.NET/VB.NET to input quarterly survey data.
EDUCATION
Business Intelligence Developer Certificate 2010 Bellevue College; Bellevue, Washington
Data Warehousing, Multi-Dimensional Analysis, Dimensional Modeling, and Data Visualization.
Bachelor of Arts in Business Administration (BA) 2006
Washington State University; Pullman, Washington
Systems Design and Development, Project Management, Business Core Courses
HONORS AWARDS
Graduated summa cum laude from Washington State University
Beta Gamma Sigma Honor Society, Member
Employee of the Month Award - The Garden City Group Jan 2011
Contact this candidate