Nathan A. Cosgray
===============================================================================
                                                       Seattle, Washington, USA
                                                         nathanatos.com/contact


QUALIFICATIONS
--------------
IT professional with over fifteen years of experience as a web application
developer, SQL developer, DBA, and system administrator. Led a number of
web development projects. Worked in teams with IT staff and a broad range of
other users to implement new systems and tools to increase efficiency.

EDUCATION AND TRAINING
----------------------
B.A., Computer Science and History of Art, with Distinction --
Indiana University, Bloomington, IN; 1998.

Microsoft training in ASP.NET Development, SQL Server, SharePoint Development,
Data Warehousing; 2003-2013.

Udacity online training in Android Development, GitHub; 2015.

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

TECHNICAL SKILLS
----------------
High level of proficiency in a wide range of technologies, including the following.

Programming Languages:
  - C#, C++, Objective-C
  - Visual Basic
  - SQL (queries, views, stored procedures, functions)
  - PHP
  - Perl
  - Java
  - HTML, CSS, JavaScript
  - VBScript, Unix shells, PowerShell

Frameworks and Services:
  - .NET and ASP.NET
  - REST and SOAP web services
  - XML, JSON
  - jQuery
  - PhoneGap
  - Apache, IIS

Development Tools:
  - Visual Studio, XCode, Android Studio
  - TFS, SourceSafe, GitHub
  - regular expressions
  - Adobe Photoshop

Database Development and Administration:
  - Microsoft SQL Server
  - SQL Server Reporting Services (SSRS)
  - SQL Server Integration Services (SSIS)
  - Microsoft Access
  - Sybase ASE
  - MySQL
  - Oracle

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

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

* SQL developer for CIP V3 entity data pipeline
  - Load datasets from many sources and combine into V3 system format
  - Design and implement data pipeline, error handling, and logging
  - Architect custom SSIS package, stored procedures, and table structures
  - Write documentation, coach team members on use of custom pipeline processes
* Author reports using SQL, SSRS and SSIS, and the Amalga system
  - Primary developer for institutional metrics dashboards ("Patients Are First")
  - Present new reports and visualizations to UWM leadership
  - Generate scheduled and on-demand reports per requirements of UWM end users
* Plan and test major migration from Amalga V2 to Caradigm CIP V3
* Assist affiliated developers with reporting needs and data questions
* 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
  - Created dozens of charts and reports, helping increase quality of patient care

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

* 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
  - Developed a suite of .NET web services for retrieving data from library systems
  - Wrote self-service web application for library collection maintenance reports
  - Developed online "Clicker" used by librarians to track reference questions
* 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
  - Planned and implemented software/hardware upgrades and migrations
* Database administrator for Sybase, SQL Server, Access, and MySQL databases
  - Applications included Horizon ILS, SharePoint, internal applications
  - Configured data warehouse and ETL processes for operational data store
  - Created reports using SQL, VBScript, and Excel
* Participated in library circulation policy decision-making processes
* Presented project work at industry events
  - "Automating and Customizing Horizon Notices" (COSUGI Conference, 2013)
  - "Seattle Public Library Online Payments" (COSUGI NW user group, 2011)
* Accomplishments
  - Enabled library patrons to pay fines online, totalling over $50,000 per month
  - Automated over 100 scheduled reports saving staff thousands of hours of time
  - Wrote web services enabling custom staff mobile app to communicate with ILS
  - Implemented robust, clustered back-end database for SharePoint intranet
  - 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

* Maintained 1,000-user Windows domain with Active Directory
* Operated 15 terminal servers with a variety of statistical software
* Assisted with 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
  - Customized web form-based data extraction tool
* Other accomplishments
  - Spearheaded departmental implementation of server virtualization (VMWare)
  - Performed web server migration onto new Debian/Apache2/PHP5 installation
  - Rewrote Windows support website, including FAQ and real-time server status
  - Automated Windows account creation process
  - Secured over $250,000 in equipment and software grants for the Center

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
* Developed MS Access databases with forms-based front ends
* Leading role in data management for variety of genetic research projects

Web Programmer                               Hirons & Company Advertising, Inc.
January 1999 - February 2000                                    Bloomington, IN

* Worked with designers, copywriters and account managers to create websites
* HTML markup, JavaScript, CGI scripting in Perl, and extensive Photoshop work
* Lead programmer for large, custom-built e-commerce website

OTHER EXPERIENCE
----------------
Developer of Cuppa, an open-source tea timer application for Mac OS X