Managed department of 5-6 developers, 1 quality assurance engineer, and 1 project manager on the development of core CMS product/client implementations. Managed departmental budget, performance reviews, departmental hiring.Advocated for true agile practices with an emphasis on close collaboration with clients to iterate on solutions to their problems, in contrast to rigid process-focused approaches. Increased quality through introduction of formal QA practice.Fostered a positive, inclusive department culture by implementing engineering standards, coaching/mentoring, creating clear growth paths, improving team morale and productivity. Amplified team impact significantly via leader-leader model.Shipped key modules of NDG’s core CMS product, iteratively transitioning from a monolithic system with significant tech debt to microservices, improving performance and scalability while reducing regressions.Provided key technical architecture/leadership and integrated key business systems, including Jira and HubSpot.Tech stack: Node.js, Angular, C#, Blazor, PostgreSQL, Terraform, AWS

As a Senior Staff Software Engineer, Andrew has worked with stakeholders from the entire Lightcast organization, directly with clients, and managed a team of senior and junior software developers for 6 years to create high performance, scalable, and reliable APIs that deliver and protect the data that Lightcast is famous for. He has accomplished this through strategic planning, implementation of various technologies, and integration of key systems. Directly responsible for the creation of APIs that drive a multi million/year ARR API business.Andrew has worked with many technologies, from the Microsoft stack (C#/.NET core), OAuth2/OIDC, data storage technologies such as PostgreSQL, SQLite, RDS, Elasticsearch, and Cassandra. Other technologies include Docker for container orchestration, Terraform/Terragrunt for infrastructure as code, linux, git, CI/CD, OpsGenie, Coralogix, and Datadog. Andrew is very familiar with AWS as a cloud provider - including EC2, RDS, Route53, S3, Secrets Manager, IAM, VPC, ECR, and more.Key projects and accomplishments include:* Architected, designed, and developed the Core LMI data API, which drives a multiple million/year ARR API business, a core product at Lightcast (Formerly Emsi) which allows highly performant lookup of labor market data, also driving core functionality in Lightcast's Analyst, Developer, and other platforms. * Managed people, provided technical leadership and built a team consisting of engineers with skill levels from Intern to Senior Software Engineer.* Developed the OAuth2 authentication service that controls access to all of Lightcast's API services, as well as OIDC services for interactive login. Architected this with a highly available design that has provided 100% uptime over the past three years.* Brought significant process improvements early on - microservice architectures, centralized logging w/correlation, authentication industry standards, profiler usage, migration to cloud, and more.

Andrew was Treasurer and a founding member of The Jubilee School board, serving a two year term as the school formed and grew from 5 students to 140.

* Develop, maintain, and support microservices within the Xbox Live ecosystem. * Utilized cloud technologies (Azure and Autopilot) to build scalable content ingestion systems for Xbox One. * Architected workflow solution for Xbox One content ingestion platform, integrating pre-existing workflow solutions. * Developed UI/UX experience for Xbox One console content ingestion platform. * Designed and developed next generation tool for internal certification of next gen console titles, using ASP.Net MVC, SQL server, Entity Framework, and related technologies. * Developed tooling to integrate content ingestion tooling with specialized Microsoft code signing services to code sign Xbox 360 and Xbox One console products. * Contributed to development and maintenance of X360 certification and mastering tooling. * Developed content ingestion tool for Title Managed Storage relating to Xbox360 products. * Designed & developed WPF-based Certification Tool for next generation console apps. * Developed custom reporting solution pertaining to Content Ingestion for Xbox360

* Implemented a custom SharePoint solution for a large wholesale company in the Seattle area. * Contributed design and development for the Microsoft Xbox Community Forums, particularly surrounding Windows Live authentication and XBL gamertags. * Developed a custom website to drive sales for a large ERP system.

A few examples of chargeable client projects Andrew was responsible for:* Developed an ETL between two major accounting systems to provide technical support for a migration at a major temp work agency.* Developed a custom dispatch management system for a regional work zone flagger provider, accounting for business rules from ten separate workers unions and the business needs.* Designed a $65,000 custom integration solution to integrate Microsoft CRM, Execupay, and Dynamics GP 10.0 for a payroll firm. * Implemented Microsoft Dynamics CRM 3 and integrated it with a company website to automate lead creation.* Architected, designed, and developed a $26,000 integration solution between Salesforce.com and Total Construction Lending, using Salesforce.com as a loan origination system.* Developed an IT Project Roadmap for Attenex Corporation. Conducted interviews to develop business requirements, wrote an RFP, conducted vendor interviews/selection to implement a knowledge base, incident management system, and project accounting system. Approximate project cost was $48,000.* Contributed development to an integration project between Microsoft CRM, SharePoint 2007, and Appian.* Maintained chargeability over 75%.

* Led Quality Assurance effort for the Port’s Employee Parking application, which is one of the chief revenue generators for the Port of Seattle. * Wrote applications to help gather, organize, import, and present metrics and requirements. Some examples include project status aggregation from Sharepoint sites, automated build deployment tools, and other small utilities.* Wrote and participated in code reviews for other team members C# code, including developer team code, and QA team code.* Implemented a formal build system and standards for its use. Components include Cruise Control.NET, fxCop, NAnt, msbuild, and WiX.* Increased team value by conducting informal training on various issues such as scripting, TSQL, C#/VB.net, troubleshooting, etc.* Improved our QA process by suggesting and/or implementing new processes that help increase predictability and decrease costs.

* Design, develop, and implement automation platform solutions, handling the entire development process from beginning to end.* Key accomplishments include solutions for a centralized database of expected test results, build script generation system, package testing automation, and day to day scripting of the in-house build system.* Increased productivity and value of QA team by educating them in basic and intermediate windows scripting.* Increased automation level of testing by helping to design and implement a BVT system for a group that previously had no automated testing.* Wrote various automation platform tools in VB.NET and C#, with extensive database usage.* Consistently earned praise and accolades for strong work ethic and excellent communication.* Created standards and improved processes in order to increase predictability of release dates and decrease costs of software development.

Remote Assistance Team* Roughly tripled the amount of test coverage on Remote Assistance component, including some code that had never been touched. (Reference: Code coverage data)* Created test plans, wrote test case, filed bugs.* Improved automated regression pass implementation, creating a rotating schedule for regression passes to provide optimum OS/SKU coverage using the lab machines assigned to the group. Went from one automated regression pass every 2-3 weeks to one per week.* Handled roughly half of the private binary smoke testing, prior to checkin.

Zone.com Content Team* Wrote test plans and test cases* Increased test coverage on several existing projects by up to 50%.* Conducted audits of outsourced test work, uncovering an average of 4 show stopping bugs per project, while testing binaries that had been signed off for release by the outsourced test houses.* Wrote test automation using Visual Basic.NET and vbscript.

* Lead tester for Client Service for NetWare. Reported to QA group manager.* Automated 80% of testing for CSNW using Visual Basic.NET and vbscript.* Updated test plans, created test cases, and tested CSNW.* Increased test coverage from 35% to 69% (Reference: Code coverage data)

* Completely automated interoperability testing for DNS Client.* Developed an application to automate test result reporting into WTT (Test Tree).* Ran test cases according to test plans.* Administered several Linux and Solaris based servers for interoperability testing of the DNS Client and Server. (BIND 4, 7, 8)

* Designed and implemented networks based on Windows NT and 2000, using Microsoft products such as Exchange, ISA Server, etc.* Increased sales of network equipment by 13%.* Installed custom network applications and databases.* Conducted on-site service and administration of networks.

* Offered web hosting services, dialup internet service, web design, and on-site consulting in the southern Stevens County area, with a target on small business and end users.* Conducted on-site training of employees and end users in the use of the internet, their computers, and various applications.