I have worked on many test automation projects and CI/CD pipeline projects to improve developer efficiency, increase ROI, and find defects earlier to boost customer satisfaction. Here are some of the highlights of projects I've worked on at Snowflake.Automation ArchitectureThe majority of my time at Snowflake has been dedicated to designing and implementing an E2E test automation framework for Snowflake in a team of four engineers and expanded to six. The framework is based on Pytest and significantly improved performance by 40% and reduced test flakiness by 95% compared to the legacy test framework that we replaced.Test ToolingI wrote a suite of tools that could automatically port legacy SQL and Python tests to the new framework with minimal manual edits. The tools also validate your ported tests run identically to the legacy tests to identify potential issues early and build confidence that you're retaining test coverage. The tools saved over 200 dev-weeks vs manual porting estimates and were used by nearly every team in the company.CI/CDAdded a CI/CD pipeline to test a new aws-gov storage provider. Upgraded build scripts to set up test accounts in Snowflake test deployment and hooked up to automatic Jira logging for failures.Security Champion for our TeamDuties include attending regular tech talks to keep up on tools and processes. Partnered with my team and the Snowflake security team to validate risk assessments and review threat models of new designs for accuracy and gaps.

International TestingWhen I arrived at Tableau, we shipped eight languages, but all of our automation was hard-coded in English. Literally no testing was done on the other seven languages. I took the initiative to design and implement a system that would translate the English tests at runtime to whatever language Tableau was using. This also allowed me to use window-opened events to automatically take screenshots of all UI in all languages so the international testing team could stop paying for a third-party tool.Automation ArchitectureI rewrote the cross-process communication layer for the end-to-end testing framework due to flakiness. I used dedicated pipes for input and output and labeled messages with ID's to match responses with the commands that generated them. The result was that the Python automation could communicate with the C++ product and run tests 50% faster with significantly improved reliability. DataCrawler ToolI designed and implemented a UI automation tool that could use customer workbooks from the Tableau Public cloud and perform standard operations on them to look for errors. For example. when the Runtime team decided to rewrite their internal visualization pipeline to improve performance, my tool found over 100 backwards compatibility issues before they were shipped to customers.CI/CD PipelineOne of the improvements I made to the pipeline was to integrate end-to-end BVT tests into pre-commit testing. Developers often made changes to the product on which the automated Python tests had dependencies. Since the tests weren't compiled, these failures wouldn't be found until the next test run. By moving the tests "left", I was able to prevent check-ins that would break test automation.

I define my own role, focus on improving engineering and automated testing efficiency, and find challenging projects that impact not just my team or even my division, but all of Microsoft. During this stage of my career, I've worked on F12 Diagnostic Tools for IE11, the Silverlight Designer, XAML Designer, and Expression Blend for Visual StudioAccomplishments: --Led a virtual team of six testers to design and develop a user-interface automation tool based on Windows UI Automation used to automate and ship over 50 products across Microsoft --Leveraged an existing tool and modified it to work for F12 in IE to use real-world data-driven testing to find over 200 crashes, asserts, script errors, and functional defects in IE, F12, and the JavaScript Runtime --Rearchitected the Expression Blend QA Automation stack to account for the XAML designer becoming in-process in Visual Studio and being written against the WinRT sandbox --Gained TypeScript/JavaScript experience by upgrading the F12 Tools from compiler version 0.8.3 to 0.9.5 by fixing over 4000 compile errors and found 20 TypeScript compiler bugs during my dogfooding --Gained Software Development experience by stepping in and helping the Developer team implement debugger features, write unit tests, functional tests, and fix bugs across the entire F12 tools for IE11 --Led a virtual team of five testers and four developers to create a common extensibility layer for functional component testing across all five Visual Studio Client teams --Architected a Visual Test wrapper on top of my UI automation framework to port tests owned by the Windows Division to 64-bit. This saved Microsoft over $4 million preventing the need to hire IBM to implement 64-bit Visual Test for Microsoft

Led a team of five testers on the Windows Forms Designer in .NET v1.0 through v2.5. Continued owning features and remaining extremely technical while managing my team.Accomplishments: --Led a team of testers to develop Maui (Microsoft Automation of UI) in VB.NET using object-oriented programming. Made design changes, bug fixes, and documentation updates to support all internal customers using it to ship hundreds of products across all of Microsoft. --Managed schedules and work items for five employees --Owned the Windows Forms Inheritance area and wrote automated functional regression tests in C# --Did interviews and wrote personnel reviews --Performed on-site interviews in Redmond, and campus recruiting at colleges all over the country

Worked on Visual InterDev v6.0 and Visual Basic v6.0. Owned one of the very first set of web controls for ASP.Accomplishments: --Wrote automated UI tests for Web Controls and was the top bug-finder on the team --Designed and implemented a dynamic resource extraction mechanism to allow automated string testing in any locale and applied for a patent on this technology

This was one 10 month co-op with the Microsoft Access team in 1995, and one 3 month internship with Visual InterDev 1.0 in 1996. I received a full-time offer after the second internship before returning to school my last semester.Accomplishments --Authored and debugged user-interface automated tests using Visual Basic --Wrote a sample ASP app to create and administer custom surveys. Handed off my code to a product team who turned it into an officially-supported internal survey site that won an Engineering Excellence Award