Sql Server Engineer

Scott McNairy **** *th Ave NW Seattle, WA ***** 425-***-**** ******@*******.***

Summary A customer-focused Software Engineer with strong attention to detail. Expert in C#, .NET, and T-SQL with database analysis, index/key tuning, stored procedure authoring, and DB schema design. Demonstrated improved customer satisfaction at all phases with a strong dedication to applicable newsgroup channels. I offer value around implementation and/or improvements of new or existing technology.

Experience by Area

Area of expertise

Years’ Experience

Notes

.NET Framework – CLR

9

Used for most applications that I have written with the intent of Testing or servicing the product by extension

ATL (for designing COM interfaces)

10

Designed dual interface ATL COM server with C++ in order to support a multi-threaded script client

C#

9

Used to author test scripts and numerous toolsets

C++

6

Authored several client features including two in the Outlook client application in addition to tests

Cosmos

8

Authored several Cosmos scripts to consume Telemetry data sent up for Outlook Desktop

Debuggers (windbg, Visual Studio, kd)

8

Used to debug Watson supplied crash, performance, and heap corruptions and automatically debugged hangs.

Insert XML to SQL via T-SQL used in a stored procedure

8

Used to take large data sets from a client supplied cache into a SQL Server via a stored procedure

Leadership

7

Successfully led the TWC Automation efforts to drive improvements in the pass rate of the Test Suite up to 98% passing

LINQ, MVC, and Data Sources (xml and sql based)

6

Used to query XML data sets as well as SQL MDX files for report data source in SSRS via LINQ queries to provide view state

Modern Apps for Windows 8+

6

Coded up an exploratory app using XAML and C# was functional but not submitted to the store

MSI (Microsoft Installer Technology)

8

Authored silent installations for several partner installations including MSI property modification for deployment via AD

Deployed solution to client computers using Group Policy and to hide UI from end

users to achieve consistency in the installed client software environment.

OOD

9

Almost always use object oriented design for what I have done including base

class, sub-class, and interfaces.

REST (Representative State Transfer)

4

Implemented stateless implementation for maintenance of forms based web page servers using SSRS as well as other dynamically generated web pages.

I have authored. I learned a lot about REST when passing parameters between

Web reports using SSRS to drill into data further with data graph mouse clicks.

SCRUM/Agile

7

I worked within the environment doing dual contributor coding and Scrum

SQL Server 2000-2014

9

Authored several SQL DB backend structures including tuning and query

performance analysis

VBA (Office Visual Basic)

9

Tested Macro’s using Office on several occasions including those that hooked up

to ODBC SQL connect

VBScript and Jscript (aka JavaScript)

9

Authored an inventory system for analyzing Customer Hardware inventory with

Script via Group Policy

WCF (Windows Communication Framework)

4

Issued a SOAP request to a locally authored Web Service in an educational

sample project for team demo

WEB API

7

Checked the validity of some dependent Web supplied endpoints for the Outlook

team within a C++ environment.

Have also issued web requests to endpoints via the .NET APIs.

Windows OS Familiarity (since NT4 SP4)

8

As one of the only testers in the WMI group testing providers that supplied OS

data I am very familiar

WMI and WQL

10

WQL is Windows Management Instrumentation query language. I know the

language well.

XML (and related metadata) and HTML

7

I’ve used HTML for sending custom mails (Alerts) and authored Web pages dynamic and static.

I’ve used XML technology as a caching mechanism for export from the client to the SQL endpoint.

Achievements

Outlook Desktop Team - Microsoft

Title: Software Design Engineer 2 Dates: 2009-2015

Worked on the Telemetry feature (testing and development) included in the Outlook client using Agile development methodology

Maintained and provided a stable SQL Server for the team to store Telemetry data sent up from Outlook Desktop client sessions and feature use globally.

Instrumented an Alerting mechanism that eliminated the necessity to view dynamic data reports by analyzing data as a part of the Alerting delivery mechanism

Features implemented to ensure data flow did not have a negative impact on Performance of the custom alert system.

Attained goal of < 1 hour from time of event to understanding of that data anomaly delivered in email.

Wrote numerous SSRS (SQL Server Reporting Services) reports based on client event data surfaced through the telemetry rules engine from ETW and ULS client events to gain understanding of faults within the Outlook client that helped increase customer satisfaction with their Outlook experience.

Found and acquired fixes for 3 different Security bugs (exploitable Access Violations based on modifiable rules file downloaded to all Telemetry clients by default) within the Telemetry Rules Engine parser as a result of File Fuzzing efforts making the Rules Engine significantly less exploitable. Environment we worked with here was a console app and a debugger to discover failure points

Worked extensively with Cosmos data streams to populate SQL Data Tables for ease of reporting with SQL Server Reporting Services. Project was coded in Cosmos.

Coached other Developers on how to implement their own application Telemetry data using SQL Server Reporting Services. Project was coded in SSRS Reporting including Rest parameterization for loading of form data.

Developed an Outlook Desktop Client feature that incorporated a base class, a standard interface, and a subclass so that Outlook Desktop Client could execute a variety of things that I cannot currently disclose. Environment that I coded this project in was C++.

The interface is extensible and was designed so that clients can implement as complex of a scenario that they wish and covered the most common return data with Plain Old Data structures

Used a configurable throttling mechanism to ensure that any single instance would not run so often as to have a negative impact on client performance.

Provides a way to dig into any critical user scenario that implementers wish to gather further information on for the client with an instantaneous feedback mechanism.

Trustworthy Computing (TWC) Group - Microsoft

Title: Software Design Engineer in Test 2 Dates: 2005-2009

Successfully led the TWC Test Team Automation efforts

Brought the Automated Test suite from an inherited 79% pass rate up to a 98% pass rate for the Team’s automated test suite as Test Team Automation Contact

Reduced the number of Office application hangs by creating an automated hang debugging tool to support TWC’s Responsiveness testing efforts for multiple teams in Office. Project was coded with a mix between SQL Server and C# application.

Gathered data from each unique hang for storage into a SQL Store and identified the faulting function which enabled prioritization of hang issue based on frequency and hang duration to help prioritize the issues.

Supported running in conjunction with the test automation framework in order to aggregate results based on existing team owned automation.

Automated Gatekeeper File Format Performance Testing for opening legacy file formats. Project was coded in C# environment.

Resulted in the ability to ship a computationally intensive security feature while protecting a good user experience for key usage scenarios.

Result of the testing performed was an improvement of the performance of the Gatekeeping action by around 50% from developer code complete to release which made the additional action for this new Office feature un-noticeable.

Extended to support testing of the Secure Reader and Multi-Threaded Metro file open/save features (aka Protected Mode) for the Word, Excel, and PowerPoint applications. Project was coded in C# and a SQL Server backend.

Windows Management Instrumentation (WMI) (Volt Computing, Ciber, or Microsoft Employee during this time) - Microsoft

Title: Software Test Engineer Dates: 1998-2004

Wrote an application to execute all interfaces for each WMI providers Microsoft shipped in Windows XP and Server 2003. Project was coded in VB6 environment.

Facilitated faster WMI Provider development efforts with standard WMI API level testing of each provider.

Significantly reduced bug detection time for new or existing WMI Providers.

Used multiple threaded tool to overcome complete enumerations of all instances returned to the client for lengthy API calls

Newsgroup Participation

Won the Most Valuable Professional (MVP) Award from Microsoft during two separate time periods 2004-2005

See this link for additional detail of actual newsgroup participation in this area.

Increased customer satisfaction for Developers using WMI service through Developer newsgroup support participation

Improved reliability of Windows by taking 2nd place in a Windows Watson Crash Debugging competition held company wide.

Education

BA, Economics and Business Administration

Western Washington University, Bellingham, WA Graduated in 1994

Contact this candidate