Senior Data Engineer

• May 2022 - Present

Senior Database Architect

• Sep 2020 - Mar 2022

Brought on as primary DB architect to improve queries and resolve bottlenecks that were blocking new features. Average query improved by 50%, with numerous bottlenecks seeing a 3x or better improvement. This gave our client room for years of future development. Heavy focus on reliable, unit tested code. Brought on as primary DB architect to improve queries and resolve bottlenecks that were blocking new features. Average query improved by 50%, with numerous bottlenecks seeing a 3x or better improvement. This gave our client room for years of future development. Heavy focus on reliable, unit tested code.

Senior Software Engineer

• Dec 2019 - Mar 2020

My first task at Powell's was to create a local development environment, as we were starting from scratch on understanding a codebase previously developed by 3rd party contractors. Once we had a local development environment up and running, I quickly got to work fixing some of our most critical issues: * Patching input sanitization bugs, and ensuring input sanitization consistency. * Establishing a local testing environment for our full checkout process, including PayPal integration. * Fixing tax code issues that were costing significant income on each order. * Working with DevOps to develop a CI/CD process Powell's Bookstore was forced to lay off all non-essential staff due to the pandemic Show less

Senior Software Developer

• Oct 2017 - Sep 2019

At Evernote, I worked to maintain our service, which has over 100 million users. This included urgent responses to critical production bugs and scaling issues; developing migration plans to more scalable services; and working on new features * Evernote Spaces * GDPR compliance * Updated profile and user configuration options (front and back end) * Migration from SQL to Google Spanner * Migration from monolith to microservices model * * Architecture of both microservices and related service web * * Rebuild authentication system to handle distributed systems Show less

Senior Software Developer

• Nov 2016 - Oct 2017

I helped build their next generation of reporting system, which integrated reports across numerous projects. This made it significantly easier to track the status of multiple products, as well as enabling easy comparison to how past projects had performed. We built a company-wide data warehouse. This involved importing raw, denormalized data from numerous legacy systems. We then used that data to build a well-formatted, normalized data warehouse. From there, we built a strong reporting system architecture that could easily be extended to include new projects, or adapt to changing needs. This included displaying real-time status reports, building executive summaries, and user data input. Development relied heavily on Agile to give us a tight user-feedback cycle, ensuring that each project got exactly the dashboards and data they desired. Show less

Software Developer

• Feb 2015 - Aug 2015

I was responsible for analyzing, aggregating, and building reports for our Generation Operations (GenOps) software (a program for optimizing power generation and power trading). Due to the real time nature of the system, speed and stability are critical. However, we also needed the ability to quickly pivot and report on new aspects of the system, or add new business rules. To meet these requirements, I developed a heavily optimized rule engine where new code and rules can quickly be slotted in, and we can rapidly prototype and analyze new configurations. As a result, we could often implement new requirements in minutes. Development in C#, ASP.NET, and SQL Server 2012. Show less

Senior Business System Analyst

• May 2014 - Dec 2014

I was the sole IT contact for Clean Energy Works. As such, I was responsible for meeting with department heads, identifying projects that would help their department, and then coming up with a development plan. Work was a mix of numerous environments, including Linux and Windows servers. Programming was a mix of Python, PHP, ASP.NET, and JavaScript / jQuery. Our database was PostgreSQL. I was the sole IT contact for Clean Energy Works. As such, I was responsible for meeting with department heads, identifying projects that would help their department, and then coming up with a development plan. Work was a mix of numerous environments, including Linux and Windows servers. Programming was a mix of Python, PHP, ASP.NET, and JavaScript / jQuery. Our database was PostgreSQL.

Software Developer

• Jun 2010 - Sep 2013

I was brought in to help modernize their legacy Access97 systems, moving it to C# and SQL Server. This involved careful translation of key accounting logic, and heavy testing to ensure no discrepancies between the two systems. In the legacy environment, code routinely needed to be duplicated across multiple client databases, making maintenance and refactoring especially difficult. The new system instead used a rules engine to link numerous small, reusable business logic modules together, defining that particular client’s accounting workflow. It also allowed us to modernize our data entry UI from Access97 forms to C# WinForms. Show less