.

Graham MacFarquhar

San Francisco, CA 650-***-**** ad08yz@r.postjobfree.com LinkedIn Github Portfolio TECHNICAL SKILLS

Languages - Javascript, TypeScript, Python, Java, C, SQL, GraphQL, HTML5, CSS3 Libraries / Frameworks - Node.js, Express, React, Flask, Django, PostgreSQL, SQLAlchemy, JQuery, Jest Tools - VSCode, Github, AWS, Heroku, Figma, Photoshop SOFTWARE ENGINEER EXPERIENCE

Lead Software Engineer Oct 2023 – Present

PEEL - Node.js, Express, React, PostgreSQL, AWS, Heroku, Figma Remote

● Built an API with a user profile system, Oauth, transactions, full-text search, and more.

● Designed UI/UX with Figma and transposed designs to React.js components.

● Integrated Stripe webhooks for payment assurance and Amazon S3 storage for photos. Full Stack Development Intern June 2023 – July 2023 Foqal.io - TypeScript, React.js, GraphQL Remote

● Implemented a high-priority feature to allow the assignment of user groups to queues.

● Refactored dynamic assignment of variables in Request-Type workflows and Tag workflows.

● Debugged and amended GraphQL queries while maintaining backward compatibility. Research Assistant Aug 2018 – May 2020

Memory Lab and CERLAB at Carnegie Mellon - Python, CSS3, HTML5 Pittsburgh, PA

● Utilized external Python scripts to process audio files in Audacity.

● Developed a Python application on Raspberry Pi to record audio data of sleep apnea patients.

● Maintained the Memory-Lab website front-end, leveraging prior knowledge of CSS and HTML.

● Demonstrated a functional prototype and pitched our device to future clients. TECHNICAL PROJECTS

Warbler

Full-stack Social Media Application - Python, SQLAlchemy, Bcrypt, WTForms, Jinja Github

● Developed user-following and message-liking features using many-to-many relationships with SQLAlchemy.

● Conducted unit and integration tests, achieving 100% coverage.

● Implemented user authentication and authorization using the Bcrypt hashing algorithm. Jobly

Full-stack Job Board Application - JS, React, Bootstrap, Node.js, Express, JWT, Bcrypt Github

● Deployed a REST API using a test-driven development approach, achieving 100% coverage.

● Implemented authorization and authentication using JSON Web Tokens.

● Designed object-oriented models to encapsulate database operations and produce SQL statements.

● Validated API requests using JSON Schema to ensure data adheres to type and format constraints. EDUCATION

Rithm School 2023

Full Stack Web Development Bootcamp San Francisco, CA Carnegie Mellon University 2022

B.S. Degree - Electrical and Computer Engineering Pittsburgh, PA