Nathan A. Cosgray
===============================================================================
                                                       Seattle, Washington, USA
                                                       linkedin.com/in/ncosgray


ETL/DATABASE DEVELOPER
----------------------
Proven track record of excellence in database development, data management, 
and business intelligence.

"Truly exemplary work." -- Jim, IT Director

TECHNICAL SKILLS
----------------
* Microsoft SQL Server, Azure SQL Database
* T-SQL (queries, views, stored procedures, etc.)
* SQL Server Integration Services (SSIS)
* SQL Server Reporting Services (SSRS)
* Power BI, Tableau
* C#.NET, VB.NET, MVC, Entity Framework
* PowerShell

PROFESSIONAL EXPERIENCE
-----------------------

Analyst/Developer                                    The Seattle Public Library
November 2015 - Present                                             Seattle, WA

* Design and implement library data warehouse
  - Work with stakeholders to determine data and reporting needs
  - Work with data owners to identify sources and understand contexts
  - Build ETL processes using SSIS, T-SQL, C#, and PowerShell
  - Build enterprise reports, dashboards, and KPIs using SSRS
  - Work with business analysts to expose data to Tableau and Excel
* Web developer for internal and external web applications and web services
  - ASP.NET (VB) online payments web application
  - ASP.NET (C#, MVC, Entity Framework, Bootstrap) volunteer data entry tool
* Accomplishments:
  - Proposed, designed, and implemented self-service reporting for Library staff
  - Built 35+ end-to-end ETL processes and 80+ SSRS reports in 3 years
  - Grew data warehouse from 0 to 200GB (over 300 million rows) in 3 years
  - Published and continually refreshed 4 datasets for Seattle Open Data Initiative
  - Project managed migration of Horizon ILS from Sybase ASE to SQL Server
  - Implemented donation feature in online payments web application

Analyst/Developer                           IT Services - Amalga Data Warehouse
May 2014 - November 2015                               UW Medicine, Seattle, WA

* SQL developer for CIP V3 entity data pipeline
  - Loaded datasets from many sources and combine into V3 system format
  - Designed and implemented data pipeline, error handling, and logging
  - Architected custom SSIS package, stored procedures, and table structures
* Authored reports using SQL, SSRS and SSIS, and the Amalga system
  - Primary developer for institutional metrics dashboards ("Patients Are First")
  - Presented new reports and visualizations to UWM leadership
  - Built reports (scheduled and on-demand) per requirements of UWM end users
* Accomplishments:
  - Wrote modular stored procedures for reuse by many data pipeline data sources
  - Devised method to improve data pipeline by loading only when updates detected
  - Wrote C# data comparison application for use during system migration

Senior Systems Analyst                               The Seattle Public Library
June 2008 - May 2014                                                Seattle, WA

* Managed and supported Integrated Library System (ILS)
  - SirsiDynix Horizon ILS with SIP2-based TechLogic ACS self-checkout
  - Worked with staff, librarians, and vendors to troubleshoot and solve ILS issues
  - Created reports using SQL, VBScript, and Excel
  - Planned and implemented software/hardware upgrades and migrations
* ASP.NET web application and web service developer
  - Primary developer of PayPal-based online fine/fee payment system
  - Wrote 3M/SirsiDynix SIP2 API library for .NET applications
  - Built a suite of .NET web services for retrieving data from library systems
  - Developed web tool used by librarians to track reference questions
* Database administrator for Sybase, SQL Server, Access, and MySQL databases
* Accomplishments:
  - Enabled library patrons to pay fines online, totaling over $50,000 per month
  - Automated over 100 scheduled reports saving staff thousands of hours of time
  - Created ILS database mirroring scheme for backup, testing, and training

Senior Computer Specialist         Center for Studies in Demography and Ecology
June 2003 - May 2008                      University of Washington, Seattle, WA

* System administrator for academic research center
  - Maintained 1,000-user Active Directory domain and 15 terminal servers
  - Participated in Unix infrastructure support, including Apache and MySQL
* Assisted with supervision of student workers
* Web programming projects in PHP and Perl
  - Account request forms and backend request queue management system
  - Workshop registration form with roster/attendance tools
  - Data extraction tool for sharing specialized research dataset

System and Database Administrator                Department of Medical Genetics
March 2000 - May 2003                      Indiana University, Indianapolis, IN

* Maintained Solaris servers, NIS+ namespace, statistical/genetic analysis software
* Database support for research projects
  - Developed MS Access databases with forms-based front ends
  - Took a leading role in data management for variety of genetic research projects

EDUCATION
---------
B.A., Computer Science
Indiana University, Bloomington, IN

TRAINING
--------
Microsoft MOC coursework: .NET Development, SQL Server, Data Warehousing
Recent conferences: SQL PASS Summit, Google I/O

CERTIFICATIONS
--------------
Microsoft Certified Professional (MCP)

OPEN-SOURCE PROJECTS
--------------------
Developer of "Cuppa" tea timer apps for macOS, iOS, and Android
(github.com/ncosgray)