John R. Molina
Software Engineer
Hello! I'm a software engineer with a B.S. in Computer Science and experience in data management, database systems, and full-stack web development.
At Columbia University, I supported The Columbia Commitment fundraising campaign through data quality, platform maintenance, and reporting. The campaign raised $5.48B by 2022, with over 197K donors and 159K engaged alumni.
I'm currently building projects in C/C++, Python, SQL, and JavaScript while strengthening my data structures and algorithms skills through MIT OpenCourseWare.
Projects
Built preemptive deduplication workflows for admissions cycles at an Ivy League university, scoring records across eight dimensions (name, gender, age, employer, email, address, spouse, degree) to prevent duplicates in a 5M+ record database. Developed PL/SQL views, reports, and BI dashboards, using CSVs and spreadsheets for both automated and manual data review.
Structured study plan built around MIT 6.006, CLRS 4th Edition, and LeetCode. A CS refresher for technical interview preparation.
Single-page reference for a terminal-centric dev environment built around Zsh, Tmux, and Neovim. Documents my dotfiles setup.
Full-stack TypeScript e-commerce platform for home-baked goods. Built with Next.js, Prisma, and PostgreSQL.
Multithreaded chat application built over TCP/IP using Linux sockets. Handles persistent connections, message parsing, and data transmission with JUnit tests.
Data visualizations connecting global events to economic trends. Built as a data science capstone at Montclair State University.
Automotive design case studies applying matrix transformations, animation, and geometric operations to model and visualize 3D structures in Python.
About
I'm a software engineer based in New Jersey and New York with a B.S. in Computer Science and experience in data management, database systems, and full-stack web development.
Until 2022, I worked with Columbia University's Data Management Group, maintaining Athena, the system of record for 5M+ alumni, donors, and organizations. I exported, cleaned, and re-imported data using SQL, Python, and Excel, built PL/SQL views for reporting, and mapped family relationships to support multi-generational outreach. I also audited records, integrated external data sources, and helped reduce the "lost" constituent population (those with no active contact info or who may be deceased) from 18% in 2017 to under 4% by 2022.
I contributed to data governance, reporting, and BI dashboards that supported The Columbia Commitment campaign, which raised $5.48B. I'm currently building projects in C/C++, Python, and JavaScript while continuing to strengthen my data structures and algorithms skills through MIT OpenCourseWare.
- Python
- SQL
- JavaScript
- Java
- PHP
- C/C++
- Django
- TypeScript
- React
- Node.js
- PostgreSQL
- Docker
- AWS
- GitHub Actions
- Linux
- Data Management
- BI Dashboards
- Excel/VBA
Contact
Open to new opportunities and always happy to talk shop. Feel free to reach out.