Jul 2021 – Apr 2024 · 2 yrs 9 mos · Remote (Idaho) · Remote

• Developed stored procedures, table schemas, and views for data models in a data lake: Snowflake, SQL, JavaScript, Python
• Developed a stored procedure template used by a team of 10 developers to write Snowflake stored procedures: Snowflake, SQL, JavaScript
• Developed a test framework used by a team of ~10 developers to create unit tests for stored procedures in a datalake. Improved unit test coverage from 0% to over 90%: Snowflake, Python, pytest, SQL
• Developed tooling used by a team of 10 developers to validate JSON configuration files and generate SQL migrations: Python, SQL, Flyway
• Assisted with transitioning the company to 100% cloud from a legacy system. Loaded data into a datalake and verified medical data quality. Resolved data quality issues: Snowflake, SQL, Airflow, AWS
• Developed data models for medical data ingested from various formats (CSV, HL7 FHIR). Developed and maintained dbt models and pipelines: Snowflake, SQL, dbt

Mar 2019 – Sep 2020 · 1 yr 6 mos · Jersey City, NJ

• Maintained middleware that supports various 3rd-party user identity and authentication services, print subscription management, and metered paywall access: Python, Flask, Zappa, AWS
• Designed, implemented, and deployed a new version of the middleware to address increasing demands of scaling to additional markets and integration with 4 external APIs. This is currently in production serving thousands of users and averaging ~10-20 queries/second: Python, Django, Zappa, AWS (Lambda, Aurora, ElastiCache)
• Maintained and added features to existing web-based tools used by developers and support staff to resolve customer account and identity management issues: Python, Django, JavaScript, JQuery, AWS
• Worked with front-end developers utilizing React to design the API and back-end for updated account management tools: Python, Django, Zappa, AWS (Lambda)
• Maintained and updated various reporting jobs. Wrote scripts to generate reports and user account audits: Python, AWS (Lambda), SQL

Oct 2018 – Feb 2019 · 4 mos · Wilton, CT

• Maintained and added features to a web-based development tool used by embedded software engineers of photolithography machines to visualize and analyze automated test results and data: Python, Django, MySQL, JavaScript, Bootstrap 4
• Developed new front-end UI functionality and implemented enhancements to existing UI elements. Converted ad-hoc elements to utilize highly-reusable open-source JavaScript and CSS libraries such as ag-Grid and Bootstrap 4.
• Refactored existing Django templates and views to utilize an API-based design. Developed new API endpoints and modified front-end components to utilize these new endpoints: Python, Django, Django Rest Framework, JavaScript, JQuery
• Developed Python and JavaScript libraries to normalize relational JSON data, thus reducing REST payload sizes and minimizing code complexity in the Python and JavaScript codebase.
• Developed custom Django form widgets and related frontend assets to improve reusability and adhere to DRY principles: Python, Django, JavaScript, Bootstrap 4
• Completed the ASML Software Academy: 3 weeks of software development process and Agile training. Gained familiarization of photolithographic processes used in the semiconductor fabrication industry and development of related embedded software.

Jan 2018 – Sep 2018 · 8 mos · Boston

• Maintained and added features to a leads routing and bidding system: Python, SQLAlchemy, MySQL
• Maintained and added features to a data portal used internally for querying metrics, campaign settings, and reporting: Python, Tornado, SQLAlchemy, MySQL, JavaScript, Flask
• Developed and maintained tools and scripts, deployment scripts, various scrapers/crawlers, and utility programs for internal use: Python, Fabric, MySQL
• Developed automated testing to ensure proper synchronization and consistency of data across various systems in the technology stack: Python

Jan 2017 – Jan 2018 · 1 yr · Boston, MA

• Developed Python applications to support data collection from semi-autonomous railway track inspection vehicles.
• Developed and implemented a cloud-based data portal to enable operators and clients to view, visualize and analyze data collected by robotic vehicles. Sole full-stack developer on project. Technologies used: Python, Ubuntu, AWS, Amazon IoT, PostgreSQL, Flask, Django, RabbitMQ, React

Jun 2016 – Jan 2017 · 7 mos · Merrimack, NH

• Completed the LEAP training program (Mainframe Track). This included business acumen training as well as technical training on IBM z/OS series mainframe and related technologies: ISPF, JCL, COBOL, CICS, DB2
• Maintained online (CICS) and batch programs for z/OS in support of trading and brokerage platforms.

Jan 2016 – Mar 2016 · 2 mos · Sandy, UT

• Worked on a team that helped rewrite software components critical to the business in need of optimization.
• Assisted with identifying and implementing changes to improve reliability and maintainability of code encompassing core business logic.
• Assisted with the consolidation of several systems and processes into one cohesive product developed in Ruby/Rails.
• Developed the front-end component of a web-based business rules engine.

Oct 2015 – Dec 2015 · 2 mos · Salt Lake City, UT

• Worked on a team responsible for the creation and maintenance of a dashboard tool to
• track statistics of other company software development projects.
• Implemented tools to assist with the tracking of code quality and helped to eliminate
• technical debt.
• Worked primarily with open-source technologies such as Spring MVC and AngularJS.

Jun 2015 – Sep 2015 · 3 mos · Draper, UT

• Worked on a team with four other students to create a functional testing framework for the 1-800 Contacts website.
• Developed an automated browser testing solution using NodeJS, Grunt, Selenium, Intern, LeadFoot, SauceLabs, and Python.
• Won first place at the Summer 2015 Neumont University Project Showcase in the Enterprise Projects category.

Oct 2012 – Sep 2013 · 11 mos · Lehi, UT

• Maintained and developed new features for call center software utilizing Python, Django, PostgreSQL, Cassandra and FreeSwitch.
• Assisted clients with generating reports from large amounts of data consisting of call records and related performance and usage statistics.
• Provided technical support to call center personnel and assisted with troubleshooting and resolving technical issues and software bugs.
• Devoloped documentation for software products and tools.
• Worked in the Philippines for two months interviewing and training a Philippines-based development team in Python, Django, and proprietary tools

Jan 2012 – Aug 2012 · 7 mos · Mobile Gang (Powder River Division)

• Assisted with the construction and maintenance of rail signals and grade crossing warning devices.
• Conducted various tests and troubleshooting of new and existing signal installations and related equipment including wiring, relays, and electronic control systems.
• Developed training aids for personal use: http://transvec.com/bnsf_signals

May 2011 – Jul 2011 · 2 mos · Idaho Falls, ID

• Designed and developed a customer rewards site using Django, Python, and MySQL.
• Performed data entry tasks and assisted with the preparation of catalogs and marketing publications.

Oct 2010 – Mar 2011 · 5 mos · Idaho Falls, ID

• Tested customer-facing retail website and internal customer/order management software for correct operation.
• Submitted bug reports and tracked progress of bug corrections.
• Ensured that bug corrections functioned correctly.
• Performed regular regression testing of new software builds prior to release and deployment.
• Assisted software developers with troubleshooting.
• Occasionally performed call-center duties.

Feb 2010 – Oct 2010 · 8 mos · Draper, UT

• Assisted customers in a retail setting.
• Organized home deliveries.
• Worked at the full-serve desk and as a cashier during times of peak customer volume.
• Assisted customers on the loading dock.
• Cleared the parking lot of carts.

Feb 2008 – Sep 2009 · 1 yr 7 mos

• Attended Warrant Officer Candidate School and Rotary-Wing Flight Training.
• Completed Primary and Instrument Flight Training for the TH-67 helicopter.

Jul 2005 – Feb 2008 · 2 yrs 7 mos

• Earned the Military Skill Identifier of 15J.
• Maintained armament, electrical, communication and avionics systems on OH-58D Kiowa scout helicopters.
• Conducted troubleshooting to identify and diagnose malfunctioning equipment.
• Performed various repairs and preventative maintenance in accordance with technical publications and safety directives.
• Ensured forms, tags, and maintenance logs were completed accurately.
• Served as an Information Management Officer and SharePoint information portal administrator as an additional duty while enlisted.