Andrew Boylan
Full Stack Developer
Currently based in Boston, MA
MS in Computer Science, Northeastern University
Recent Projects
Youtube Sequencer
Personal Project
ReactTypeScriptGraphQLPostgreSQLAWSTerraformReduxFirebase Authentication
- Developed a full-stack web application for repurposing Youtube as a drum machine and for sharing created patterns.
- Implemented a GraphQL API with Apollo Server on EC2, leveraging GraphQL's type-safe declarative query interface to simplify client-server interactions.
- Utilized Redux and Redux Persist for state management, incorporating versioning to handle future changes to store structure by resetting persisted state upon version mismatches.
- Implemented secure file upload and download functionality by generating AWS S3 pre-signed URLs, enabling clients to upload and download from S3 without exposing server credentials.
- Optimized PostgreSQL database performance by storing likes_count directly in the Patterns table and using a trigger to update count on like/unlike events, eliminating an expensive aggregate query when retrieving a Pattern's like count.
- Automated AWS infrastructure deployment using Terraform, implementing a secure multi-tier architecture with private subnets for RDS, IAM roles following the principle of least privilege, and configured security groups for network isolation.
Gridworld Streaming
Personal Project
ReactMongoDBFirebaseStripeJWTVercel
- Developed a music streaming application using React, MongoDB, and Firebase for object storage.
- Implemented user authentication and account management.
- Created a responsive audio player with custom controls using Howler.js.
- Designed and implemented a token-based access system for premium content.
- Utilized Stripe API for secure payment processing and access token purchases.
- Deployed the application using Vercel, using serverless functions for a custom API.
For Edmonia: Together Sculpting
Commissioned Project
React
- Developed a highly interactive React website allowing users to explore sculptor Edmonia Lewis's archive while creating their own collage. Created in collaboration with artist Yétúndé Olágbajú.
- Implemented complex DOM manipulation features (drag, rotate, scale) using interact.js.
Collaborative Collage
Personal Project
JavaScriptNode.jsSQLiteWebSockets
- Developed an interactive, multi-user collage creation platform - vanilla JS front, Node.js back, SQLite database.
- Implemented dynamic image manipulation: add/delete, layer ordering, move, and resize.
- Utilized WebSockets for real-time collaboration, enabling simultaneous editing by multiple users.
- Self-hosted the application on a Raspberry Pi running Apache2.
Geochat
Academic Project
JavaAndroidFirebase Realtime DatabaseMVC
- Led development of a location-based message board Android application.
- Designed wireframes in Miro and conducted extensive planning before beginning to code.
- Integrated Google Maps API and Firebase Realtime Database.
- Adhered to Model-View-Controller principles, designing with modularity in mind.