1. Web Development
• Expedited development of custom reporting module using rails, sidekiq, librato, and aurora db
• Added suite of unit and integration tests to existing application then refactored critical pieces to improve readability/maintainability and eliminate edge-cases.
• Wrote api to facilitate connection of the reporting module to other services and created UI for clients to customize and schedule the reports they needed.
• In order to improve internal efficiency and facilitate our CS and Analyst teams, I created a tool that functioned as a hub for all our internally facing services. Our teams needed one place to access custom integrations and reporting, metrics and troubleshooting tools, as well as a secure way to interact with sensitive client data.
• Coordinated with many different teams to get all the service oriented internal APIs spec'd and built to connect to the hub built with rails, rabbitmq, and several monitoring/metrics services.
• This tool, which started as a side project, led to $19K in one time revenue and currently supports over $70K in monthly recurring revenue (MRR).
2. Backend Data Engineering
• Designed communication paths between several databases (Mongo, Dynamo, Aurora, MySQL, PG, ES) and our data warehouse solution Redshift including writing the necessary DDLs and ETLs.
• Redesigned several database tables in Redshift and Aurora to facilitate new or improved services.
• Wrote a series of python modules and documentation for our internal Data Science and Analyst teams to use for advanced reporting and analytics.
3. DevOps Engineering
• Used Ansible to design and maintain the provisioning and automated deployment processes of two client critical services used for managing scheduled and/or long running tasks
• Architected distributed, scaling systems in the Amazon cloud with very simple to use process/workload management, along with full monitoring/metrics and error alerts
• Pager Duties and New Relic