Wrote MySQL queries to validate manually inputted data• Able to find missing, invalid, or suspicious columns in tables with thousands of entries• Implemented as model queries in Laravel for easy use as endpoints• Fully tested for accuracy and functionality with suite of unit testsDesigned and implemented Coordinate Country Verifier to find misplaced coordinates• Can find errors in manually inputted coordinates (e.g. if coordinates supposed to be in Canada but actually placed in middle of the ocean)• Found suitable GIS country boundary geometry and created program to load into MySQL database• Created Laravel + MySQL program to comb through 4000+ database entries and fetch those with mistaken coordinatesCreated AWS S3 pipeline to split PDF documents into page images• Utilized Python PyMuPDF library• Deployed on AWS Lambda for easy multiprocessing to handle 4 million documentsPorted Logo Scraper into Laravel backend for use as API endpoint• Eliminated network issues and costs associated with relying on AWS Lambda

Programmed a logo fetcher in Python to find and save company logos based on an Excel spreadsheet of ticker symbols• Reduced time to fetch logos by 99.8% over manual method• Refactored to run as an AWS Lambda API and to save into S3 bucket• Multithreaded to process logos asynchronously, speeding up program by 300X over single-threading• Containerized with all dependencies using Docker so program can run consistently on any computer• Uploaded commits using Git to both Github and BitbucketUsed Python Selenium Webdriver to automate creation of company dashboards on the Prospector website.• Reduced time to create dashboards by 90% over manual method• Automatically logged in to Prospector account using provided credentials

• Machine parts using manual machine tools including lathes, mills, and surface grinders• Read blueprints and plan machining operations• Setup machines using jigs and fixtures• Measure and inspect parts using calipers, micrometers, and gauges