History with SQL

Consulting as a software engineer. Mentoring programmers at all levels of experience. Volunteer time each week toward building systems to assist with coordinating community outreach. Also volunteer on open source projects.

• While helping a team with their React based frontend (without any experience with React) created a custom calendar component that fit their needs after recognizing that the off-the-shelf open source options wouldn’t work for them. Was able to deliver this component ahead of schedule with test coverage and with an array of date utilities that came to be adopted by the team throughout the rest of the code base.

• Led the development of a Natural Language Processing service to improve the usability of a client’s provider search feature

• An organization’s management was considering rewriting a legacy Rails application they’d inherited. I suggested that they might consider keeping the legacy app while adapting it to their micro service architecture. Within a few weeks the app was upgraded and Dockerized with the beginnings of test coverage (before this there were no tests). It also now had JSON API, and a new Svelte-based UI (according to organizational standards) with no prior Svelte experience.

• With no Julia programming experience was able to help a high functioning team improve the quality of their Julia code base and testing which identified a critical production bug

• Contributed Ruby, Java and Clojure bindings to a new open source programming language

• Rescued the source code of a running Rails application. The developer had unfortunately disappeared. Was able to collect source code from AWS ElasticBeanstalk deployments (while having to fill in a number of missing pieces). Got it into a Github repository, upgraded from Rails & Ruby, and resolved a number of bugs and issues on it’s Vue.js frontend (having never used Vue.js before this).

Hired on full-time after a six-month contract (from 3/2019—9/2019). Served as a lead engineer on a team of nine.

• Was awarded multiple “I Care” awards by teammates & customers

• Enjoyed mentoring junior developers

• Led the design, development and integration (across various IT teams) of a system that has become the flagship product of the team used by over 30 clinics throughout the hospital system and a waiting list of many more; saving the organization millions of dollars

• Completed a project within a few months that had been stalled for over 3 years

• Helped organization quickly pivot to remote teams by leading the development of a clean & user-friendly time-tracking application during the pandemic from a very raw prototype that had been previously developed

• Led an experimental project to create a compiler to automate the conversion of legacy applications

• With little mobile programming experience built a well received iPad kiosk app

Got started at 18 years old writing a data conversion script in Perl for my mother’s client in the manufacturing industry.

Clients have included small businesses, universities, staffing agencies (e.g. Robert Half Technology, ALTRES, & TekSystems) and large organizations (e.g. University of New Mexico Hospitals, Central New Mexico Community College, The Department of Veterans Affairs, Time Warner & Master Card) across industries (e.g. retail, marketing, health care, education, research, non-profit) in Connecticut, Hawaii and New Mexico. Have come to specialize in systems integration, business process management, and data-oriented programming.

• With minimal JavaScript experience at the time built JavaScript heavy dashboards and backend Java / JSP code for a multi-tier system that read sensors in heavy equipment, boats, yachts, and recreational vehicles.

• Without any Flash or ActionScript experience converted a Flash animation from the website of an aerospace company into a trade show display adding a ticker tape display whose message (which could be edited by a user) would transition between the ticker tape and the original Flash animation/video.

• Worked on a Java based VoIP heads up display system for a telecommunications company that they had implemented for their help desk staff. It was intermittently crashing without reporting errors. Adding logging, a test suite and cleaning up the code greatly reduced the crashing with errors being reported when it did.

• Implemented a health insurance integration for a college which involved creating complex SQL queries, creating a custom EDI 834 generator (had to quickly learn the EDI 834 standard over a weekend), and a scheduled upload to the insurance company.

• Helped an IT Services company move a stalled project forward by creating an integration for Microsoft Exchange, moving their code into source control, and getting them into a bi-weekly sprint cycle.

• Developed a logging system for a small software company that could handle thousands of requests per second and run on a hosted VPS taking inspiration from Kafka for the logging and using MySQL for permanent storage and querying based on Datalog and the EAV pattern.

Mentored university students studying computer science & software engineering, entrepreneurs and working programmers in various technologies. Did so with the help of the HackHands platform, Zoom, GitHub and email.

Performed duties as a member of a research team for a NIH diabetes study (GRADE) including meeting with patients, processing lab specimens, etc. Also, served as IT liaison for the team, and developed custom software to improve day-to-day operations as well as many small scripts and programs for impromptu reporting and data analysis.

• Developed a workflow and case management system with built-in reporting, scheduling and EHR features while handling other responsibilities as part of the research team.

• Developed an application that interfaced with a legacy console application (VistA), parsed text reports and generated PDF reports performing tasks in seconds that previously took hours.

• Coached researchers on creating complex SQL queries to query data-warehouse