Sophia Bartolacci

Resume

Education

  • Bachelor of Science in Computer Science
  • Minors in Data Science and UI/UX
  • — Drexel University | Philadelphia, PA
  • — Cumalative GPA: 3.54
  • — Graduation: June 2027

Programming Languages

  • — Python
  • — Java
  • — HTML/CSS
  • — JavaScript
  • — Microsoft SQL Server, PostgreSQL, Snowflake
  • — C
  • — Racket/Scheme
  • — Haskell

Skills

  • — AWS
  • — Azure DevOps
  • — Amazon Q/Anthropic Claude Sonnet 4
  • — Cursor, Visual Studio Code, IntelliJ IDEA
  • — REWST API, FastAPI
  • — Node.js, Express.js
  • — infrastructure as code (Terraform)
  • — test case management (XRay for Jira)
  • — Bitbucket, Jenkins, Liquibase
  • — Pandas, NumPy, Matplotlib
  • — Jupyter Notebook
  • — Git
  • — Agile/Scrum
  • — Confluence
  • — Microsoft Office Suite
Awards & Honors
  • — Dean's List
Relevant Coursework
  • — Artificial Intelligence
  • — Data Structures & Algorithms
  • — Data Science Programming I
  • — Web Design I, II
  • — User Interface Design I, II
Professional Experience

Software Engineer

REsurety Inc. | Boston, MA

March 2025 - September 2025

  • — Leveraged Amazon Q to accelerate debugging and ticket resolution, increasing developer productivity by 35%.
  • — Managed full SDLC using AWS (Lambda, ECS, CloudWatch, Secrets Manager), Terraform, and Jenkins, cutting deployment time by 30% and improving release stability.
  • — Built automated unit, integration, and E2E tests with Python, FastAPI, and XRay for Jira, boosting test coverage by 40%.
  • — Acted as a SEIT, leading collaboration to scale shared automation frameworks across AWS-based microservices.
  • — Enhanced Bitbucket/Jenkins CI/CD pipelines, ensuring MFA compliance and improving REST API deployment efficiency.

Jr Database Developer

Webstaurantstore | Lancaster, PA

April 2024 - September 2024

  • — Managed an average of 5 backlog tickets daily, prioritizing and addressing issues efficiently to support ongoing project needs
  • — Developed table structures and stored procedures for a high-priority project, utilizing PostgreSQL, pgAdmin, and Liquibase in a company-first implementation
  • — Co-presented to over 100 team members from various departments, showcasing project progress and key developments
  • — Coordinated with multiple teams using Agile methodologies to deploy scripts to production, ensuring smooth integration and minimal disruption to existing procedures
Projects

DueDateDemon | AWS, Python, NotionAPI, Discord

August 2025 - October 2025

  • — Automated deadline tracking system using Python, Notion API, and Discord.py to send daily notifications for assignments due within 3 days, preventing missed deadlines
  • — Implemented async programming and AWS cloud deployment with secure credential management, eliminating manual database checking

Blueboard | HTML/CSS, Javascript, Postgres, Fly.io

June 2024 - September 2024

  • — Built and maintained PostgreSQL and MSSQL databases using Liquibase for automated migrations and Azure DevOps for CI/CD integration.
  • — Supported 3–4 concurrent projects, ensuring consistent database design and performance across teams.
  • — Delivered technical presentations to 100+ employees, highlighting key progress and architectural improvements.

Humble Bundle Website Redesign | Figma

September 2024 - March 2025

  • — Redesigned Humble Bundle website to improve usability, navigation, and visual hierarchy
  • — Conducted user testing and card sorting to inform site structure and optimize user experience
  • — Applied UX heuristics and responsive design principles to enhance clarity, consistency, and accessibility
  • — Streamlined store layout, filters, and content presentation to reduce cognitive load and highlight key elements

Drexel Electric Racing Website Redesign | Wordpress

September 2024 - December 2024

  • — Redesigned and updated club website with a modern, visually engaging design
  • — Conducted UX analysis to identify pain points and streamline navigation across the site
  • — Modernized content and design to boost engagement and attract prospective members