Independent Contractor Systems Analyst

Stuart McLeod

206-***-**** ● *************@*****.***

http://www.linkedin.com/in/stuartmcleod

Experience Summary: IT professional with 20+ years of experience supporting applications including the Tessitura CRM, implementing data improvement projects for SQL databases, writing reports, creating and maintaining documentation, and updating customizations for the latest upgrade. Demonstrated track record of working well with users, stakeholders and on teams. Possesses a calm demeanor and the ability to speak in non-technical terms with users.

Professional Experience

Independent Contractor, March 2020 – present

Consultant working on Tessitura, SQL, SSRS and Raiser’s Edge projects for:

Seattle Symphony - Updated all their customizations for the v16 Tessitura Upgrade

Zach Theater in Austin TX

Oregon Ballet Theatre

RADAR Nonprofit Solutions

Dallas Opera

Seattle Aquarium

Seattle Children’s Theatre

Seattle Opera, March 2012 – present

SQL Developer & CRM Administrator

·Primary support for the Ticketing/Fund Raising CRM software Tessitura & Security

·Led the v16 Tessitura upgrade project updating all their SQL procedures, views and SSRS reports

·Led the weekly Tessitura meetings

·Created and maintained 30 SQL Jobs for data hygiene, monthly giving rollover, data import and other overnight procedures

·Created and maintained backend SQL architecture for my Account website functionality

·Created and maintained data import/export SQL architecture and Azure pipelines between Tessitura and Gravyty databases

·Created and maintained over 200 SSRS reports and utilities

University of Washington, Meany Hall, Sept 2009 – March 2012

Tessitura Database Administrator

·Primary support for the Ticketing/Fund Raising CRM software Tessitura

·Developed SQL solutions for data cleanup, process improvement and custom fields, tabs and dashboard for Tessitura application

·Wrote and deployed custom SSRS reports with bar and line graphs

·Support, maintain and modify SSIS import utility

Independent Contractor, November 2010 – March 2012

Tessitura Support Manager and Database Consultant

ACT Theatre, June 2011 – March 2012

Seattle Children’s Theatre, June 2011 – March 2012

Intiman Theatre, November 2010 – April 2011

Experience Music Project (now MoPOP), May 2006 – April 2009

Business Systems Analyst

·Developed, built, deployed and managed a reconciliation test suite for catching and reporting financial and other errors across any of the organization’s many SQL databases; test suite included dashboard with graphical summary, drilldown by category and interactive links to resolve issues

·Led and executed development of custom data bridges and reports between ancillary databases and provided subsequent support and maintenance

·Led a project and built SQL infrastructure for reconversion of data between the old museum collection database (CIS) and TMS (The Museum System), improving collection data integrity and increasing Registrar staff’s efficiency; utilized data improvement methodologies including SIPOC, Pareto charts, and FMEA workshops

·Built SQL infrastructure to re-import data from point-of-sale to membership database, improving data integrity and enabling Development Department to accurately track attendance

·Developed a duplicate membership merge report, increasing integrity between membership databases

·Provided primary support for Raiser’s Edge membership database; Supported SQL databases including: Galaxy 3 (point-of-sale), HR Office 7.5 and TMS (The Museum System) 9.35 (collections database)

Seattle Symphony, July 1999 – April 2006

Systems Analyst

·Managed the two primary databases (Tessitura and Artsoft) used for fundraising, ticket selling, & marketing

·Managed the data conversion from Tickets.com Artsoft to Tessitura

·Wrote queries and stored procedures with T-SQL; Wrote reports in Sybase Infomaker

·Provided back-up Help Desk network and desktop support for MS Windows and Office Suite

Software and Developer Tools

·MS SQL Server & SSIS

·SQL Server Reporting Services (SSRS)

·SQL Server Management Studio & SQL Profiler

·Microsoft Visual Studio / SSDT

·Microsoft Office Suite

·Microsoft Office 365 administration

·Azure Data Factory

·Asana, Jira & Trello project management tools

·Zendesk, ConnectWise & Spiceworks help desk applications

·Familiarity with MS SQL Server SSAS, MS Visual SourceSafe (VSS), MS Visio, HTML

MAC OS X; Apple Logic; Finale; PureData

Training

·Microsoft Official Courses 2793A and 2780B: Implementing & Maintaining Microsoft SQL Server 2005 Reporting Services and Maintaining a Microsoft SQL Server 2005 Database

·University of Washington Computer Science & Engineering classes: CSE 142 Computer Programming I – Java, CSE 190 Web Programming

Education

·University of Washington (Graduated Cum Laude)

Bachelor of Arts, Music and Music Composition

·Shoreline Community College (Graduated with Honors)

Associate Degrees in Audio Engineering & Music Performance

Personal Interests: An active musician and composer, I play drums and percussion in rock, classical and experimental groups and am a graduate of the Pacific Northwest Film Scoring program. https://stuartmcleod.bandcamp.com/

Contact this candidate