SUMMARY:

• T - SQL, PowerShell, C#
• Confidential Windows/IIS/SQL
• Project lead

TECHNICAL SKILLS:

• Languages: T-SQL SQL Server 2014, PowerShell 5.0, and C# 6.
• Software: Working knowledge of ASP.NET MVC, SSIS, and Visual Studio 2015.
• Prior experience in SSRS, JavaScript, HTML, CSS, XML, Visual Basic/COM, Windows Forms/C#, VBScript, VAX BASIC, FoxPro, C++, Unix, Ingress, and Pick.
• Exposure to Azure.
• Formal training in software analysis and design, and data modeling.
• Project Leadership: Experience as development lead and project manager.
• Project Areas: IT operations automation. Enhancement and maintenance of commercial software packages: manufacturing/distribution and customer care.
• Operations: Confidential SQL Server 2012 SP1, Windows 2012 R2, 2008 R2 SP2, clustering and AlwaysOn, IIS 7.5/8.5.
• Working knowledge of SQL Server Performance Tuning, SCOM, SiteScope, Active Directory, Networking, and SharePoint.

PROFESSIONAL EXPERIENCE:

Automation Engineer

Confidential, Bellevue, WA

Responsibilities:

• Designed and constructed a tool in PowerShell and C# using XML, XAML, XPath, and OpenXML to produce documentation suitable for presentation to external customers about any given Confidential Assessments. The tool consists of a main script plus six modules (two DLLs and four PSM1s) as well as three configuration files and a Word template. The tool is designed to be run, with little or no configuration, by project managers yet be extensible as Assessment conventions evolve over time. Project managers run the tool when a customer requests details about what an Assessment touches in their environment. It saves project managers hours of tedious manual research into the details of an Assessment workflow. This was a short-term development project for the ASD Automation group and required minimal supervision.

Service Operations Engineer

Confidential, Bellevue, WA

Responsibilities:

• Designed and constructed a SQL Server database using T-SQL (tables, stored procedures, triggers, functions, and jobs) as well as C# (assemblies), writing the proof of concept in PowerShell. This was a one-man short-term development project to automate the discovery of monitoring gaps in System Center Operations Management 2012 (SCOM) at factory locations.

Service Operations Engineer

Confidential, Bellevue, WA

Responsibilities:

• Designed and constructed automation tools in PowerShell, C# EXE, T-SQL such as the following: lights-out security patching of Hyper-V hosts, periodic maintenance scheduling, failover of TFS clusters, and disk space utilization prediction. I was originally brought in to complete an SSRS tool for server lab management. This assignment split automation projects and as-needed application support/root cause analysis into roughly equal parts. The primary line of business application included standalone servers, Hyper-V, Confidential SQL Server 2012 SP1, Windows 2012 R2, AlwaysOn, F5 load balanced IIS 8.5, and TFS.

Service Operations Engineer

Confidential, Bellevue, WA

Responsibilities:

• Designed and constructed ASP.NET/C# Web Forms, T-SQL stored procedures, triggers, and tables, as well as enhanced existing PowerShell scripts as part of my contribution to a security patching automation project. My primary duty on this assignment was to triage server and network issues in the fast-paced external facing Windows Phone application business.

System Operations Engineer

Confidential, Redmond, WA

Responsibilities:

• I oversaw support and led improvements to progressively challenging applications of increasing importance to Confidential ranging from departmental applications to tools used in the development of core Confidential products. Most involved SQL Server databases and IIS web servers. I continually strove to be in a position to hand over the oversight of my applications to those less experienced by paying attention to well written documentation and training material.
• Representative projects were as follows: Rewrote a production system in SSIS, originally written in Visual Basic, to more reliably process phone billing. Designed and constructed the T-SQL feed from Confidential to the US 911 system. Co-authored a T-SQL/VB for Applications pilot IT scorecard application. Participated in the enhancement of a production VB/SQL application to allow Excel uploads instead of manual data entry. Wrote a general purpose PowerShell script used to quickly stand up monitoring for critical application anomalies. Operated and maintained code for a production SSIS system to report Help Desk SLA. Wrote a set of T-SQL stored procedures and tables used every year to safely perform live updates of the financial fields on the records of all datacenter servers.
• Earlier on, I supported Global Networking Services (GNS) departmental applications and later, Cross-IT (XIT) corporate-wide applications. This work often included making direct improvements to JavaScript, CSS, and SQL code, or inspecting Visual Basic and Visual C++ code for bugs. I also managed the development work of several line-of-business releases requiring one to two developers.

System Analyst/Programmer

Confidential, Bellevue, WA

Responsibilities:

• As a Systems Analyst/Programmer for Confidential ’s core business application (at the time), I maintained code primarily in the manufacturing and distribution modules during a period of rapid growth and change at Confidential . I was a team leader on a number of coding projects as well as an individual contributor on others. The work often involved working with internal business partners to produce requirements, schedules, budgets, and specifications. Examples include the implementation lead on a banking EDI drop-box project, development lead on a warehouse barcoding project, development lead on the conversion of the chart of accounts to SAP, and accounts receivable history to SQL Server.

Programmer/Analyst

Confidential, Bothell, WA

Responsibilities:

• As a Programmer/Analyst, first in the customer service branch of ATL, an international medical equipment manufacturer, and later in its manufacturing branch, I worked closely with product managers to enhance the respective modules to meet growth and plant modernization needs. Module enhancements typically required working up formal project plans under the supervision of the development manager and the product manager.

Programmer

Confidential, Redmond, WA

Responsibilities:

• Self-employed programmer primarily servicing accounts for the Med-Temps package, including an installation and customization project for a Bay-area firm.

Programmer

Confidential, Mercer Island, WA

Responsibilities:

• Development and support of a commercial software package, Med-Temps, targeted at the temporary nursing agency market. Development work included payroll, billing, and scheduling modules as well as developer support for field installation.