Seth Terrell Email & Phone Number

Friday Harbor, WA, US

Austin, Texas, US

Seattle, WA, US

• Philanthropy
• Designed & implemented financial tabular model in Azure Analysis Services (& later Power BI Premium) with custom row-level security (RLS) scheme, enabling one set of users to view detail-level data and the other only.
• Utilized GitHub & DevOps to deploy database, Azure Data Factory, & Azure Analysis Services resources
• Wrote custom PowerShell to deploy Azure Analysis Services databases using CI/CD
• Conducted myriad administrative and troubleshooting tasks in Microsoft Azure related to Azure Analysis Services, Azure SQL Managed Instance, Azure Data Factory, Azure Active Directory, Azure Log Analytics, Azure.

Seattle, WA, US

• High Tech
• Instructor for online courses on integrating Microsoft Azure with internal MPP system & its query language
• Course segments: Modern Big Data Architecture, Azure Portal, Azure Data Factory, Azure Data Lake, Azure SQL Database, Apache Spark, REST APIs, Azure Databricks with Python, Azure Synapse Analytics, Azure Stream.

Seattle, WA, US

• Microsoft
• Embedded in Microsoft Azure forecasting team
• Wrote custom scripts for internal MPP system
• Implemented the redesign of the client’s Pricing Engine, simplifying & improving its performance dramatically
• Assisted with Salesforce integration with SQL Server
• Earned Certification: MCSE Cloud Platform and Infrastructure

Seattle, WA, US

• Healthcare
• Designed & created new data mart integrated with IBM Netezza to address employee turnover
• Integrated four source systems' data to support full picture of employee turnover
• Reverse-engineered the existing personnel turnover report, and recreated it exactly using the new data mart
• Quickly got up to speed with IBM Netezza, IBM Infosphere DataStage, Bitbucket, SourceTree, and an in-house proprietary code promotion system

Seattle, WA, US

• Microsoft
• Migrated large licensing application from on-premises to Azure
• Took initiative utilizing client's proprietary XML-driven deployment engine to rapidly construct and deploy required database objects, ETL, and reporting code
• As Lead, handled multiple releases simultaneously, including report migration & development, performance tuning, mentoring, and XML-related tasks

Seattle, WA, US

• T-Mobile
• Completed data analysis and produced functional specifications to address significant infrastructure changes
• Data modeled large heavily integrated system in SAP HANA using PowerDesigner

Seattle, WA, US

• Bill & Melinda Gates Foundation
• Designed, modeled, and implemented a successful, organization-wide Financial Dashboard, allowing users to track grants, contracts, and expenses throughout their lifecycle
• As part of small team, redesigned and rebuilt organization's entire enterprise data warehouse
• Converted over 30 Reporting Services reports to the new system, addressing performance issues therein

Seattle, WA, US

• Starbucks
• Analyzed poorly performing OLTP system on SQL Server, made and implemented performance-tuning recommendations
• Dramatically improved performance of stored procedures by adding indexes and rewriting code, in some cases reducing reads by 3000%
• Built out nine new SQL Servers on new hardware and was responsible for their production DBA support
• Designed process to reduce the size of a 35M-row business-critical table by over 80%
• Provided reliable DBA support for original team as well as short-handed production support team

Seattle, WA, US

• Microsoft
• Created large dashboard with Reporting Services & Dundas charts featuring a heat map with progress toward business goals
• Dashboard enabled drilldown into increasingly detailed views of the data
• Bridged the gap between two teams to provide a useful, sustainable, and scalable reporting solution
• Mentored, taught, and supported a junior member of the team in the ways of advanced reporting methodologies and techniques

Seattle, WA, US

• Expedia
• Designed & implemented end-to-end OLAP system to replace existing OLTP architecture, integrating data from several lines of business
• Designed ETL processes to ingest and relate the data, loaded it into integrated model to support several cubes
• Implemented OLAP cubes that enabled users to slice and relate the data in ways that were previously impossible
• System utilized Microsoft SQL Server 2005’s Integration, Analysis, and Reporting Services
• Dramatically increased report efficiency and scalability

Seattle, WA, US

• Microsoft
• Designed OLAP system with complex ETL to ingest and relate several disparate systems' data
• Wrote advanced queries to allow organization-spanning views of the data that were previously unavailable
• Worked with stakeholders to identify key performance indicators

Seattle, WA, US

• Expedia
• Designed & implemented OLAP solution for user review data, allowing users to slice the data by region, time, etc
• Created DTS packages to transform and load the user review data into dimension and fact tables
• Developed OLAP cube including hierarchical dimensions, calculated members, and named sets using complex MDX
• Created SQL Server Reporting Services reports with T-SQL & MDX to allow users to view the data using input parameter values

Seattle, WA, US

• T-Mobile
• Migrated four business-critical Microsoft Access databases to Microsoft SQL Server, removing the limitation on 2GB database sizes and allowing a more scalable solution
• Completely automated several manual T-SQL scripts, greatly reducing human overhead and process execution times
• Modified and further developed executive-level SQL Server Reporting Services reports
• Trained new employee on advanced SQL Server techniques

Seattle, Washington, US

• Wrote stored procedures in SQL Server for the web portal and performed database administration activities
• Earned Microsoft Certified Database Administrator certification (MCDBA) for Microsoft SQL Server 2000