# Scottie Williamson

> Software Engineer | CS & Econ @ Columbia ‘25

Location: New York, New York, United States
Profile: https://flows.cv/scottie

Current Full Stack engineer. 

Formerly worked at Clocky LLC as a SWE Intern and at JP Morgan Chase & Co.

Contact me: s.williamson@columbia.edu

## Work Experience
### Software Engineer @ The Evaluation Company
Jan 2025 – Present | New York City Metropolitan Area
• Built an LLM-driven pipeline to process 200+ daily cases for translation and data extraction, cutting vendor costs by $93K/month.
• Deployed CDK-managed AWS infrastructure for a multi-access web app with Amplify, ECS/App Runner, RDS/S3/ElastiCache, IAM security, and CI/CD.
• Implemented the full-stack application (React + FastAPI) with Docker, SQLAlchemy ORM, and ARQ/Redis background jobs for async LLM document analysis.

### Assistant Financial Analyst @ Columbia University
Jan 2024 – Jan 2025 | New York, New York, United States
• Automated monthly expense reporting workflows (SQL, Python, VBA, Excel) to aggregate and clean data, creating more comprehensive reports.
• Collaborated with teams to analyze multi-year, multi-department financial data, conducting variance analysis and budgeting forecasts for data-driven decision-making.

### Summer Analyst, Wholesale Lending Services @ JPMorgan Chase & Co.
Jan 2023 – Jan 2023 | Newark, Delaware, United States
• Analyzed Term Loan B client financing and servicing trends over two years, identifying workload imbalances across account managers.
• Provided recommendations to senior management, leading to a 350-hour weekly man-hour reallocation and improved operational efficiency.
• Developed and automated ETL processes (Python, SQL) to consolidate servicing data from teams across North America, ensuring data integrity for a centralized Power BI dashboard.

### Software Engineer Intern @ Clocky
Jan 2022 – Jan 2022
• Designed and implemented a new retailer search interface using React.js, including backend search endpoints and MySQL query integration.
• Reduced initial page load time by 13% by consolidating duplicated React components across features.

### Claims Processing Intern @ PECO, an Exelon Company
Jan 2019 – Jan 2019 | Philadelphia, Pennsylvania, United States

### Financial Development Intern @ West Philadelphia Financial Services Institution
Jan 2018 – Jan 2018

### Loan Officer Assistant @ Pando Mortgage, LLC, NMLS #1585803
Jan 2017 – Jan 2018
Greeted and directed homebuyers, realtors and other guests
Assisted in preparing documents for loan underwriting and closings
Created and implemented different forms of advertising and informative articles

### Teaching Assistant @ Excel Philly, Inc. (Math Corps Philadelphia)
Jan 2017 – Jan 2017


## Education
### Bachelor of Science - BS in Computer Science
Columbia Engineering
Jan 2023 – Jan 2025

### Bachelor of Science - BS in Computer Science
Columbia University
Jan 2023 – Jan 2025

### Economics/ Engineering
Claremont McKenna College
Jan 2020 – Jan 2023


## Contact & Social
- LinkedIn: https://linkedin.com/in/scottie-w

---
Source: https://flows.cv/scottie
JSON Resume: https://flows.cv/scottie/resume.json
Last updated: 2026-04-01