Sophia Bartolacci

Built and optimized engineering workflows and automation systems. Reduced switch lookup latency by eliminating redundant device collection retrievals and adding caching, improving performance from 108s to 19.8s (82%) and reducing repeat-request latency to 0.04s. Developed automated unit, integration, and E2E tests using Python, FastAPI, and XRay for Jira, improving test coverage by 40%. Strengthened CI/CD pipelines with Bitbucket, Jenkins, AWS, and Terraform to reduce deployment time by 30% while supporting release stability and MFA compliance. Contributed to scaling shared automation frameworks across AWS-based microservices, collaborating across the development lifecycle.

Built a full-stack lab inventory dashboard from scratch using React, FastAPI, and MongoDB, integrating data across multiple repositories into a centralized interface for engineers to query and analyze lab inventory. Evaluated AI platforms and approaches and designed multi-step agent workflows for automated triage of failed tests from large log files, including creating architecture diagrams to map orchestration and system flow. Implemented comprehensive automated testing (unit, integration, and E2E) and improved CI/CD reliability using modern tooling and cloud infrastructure.

Built and maintained PostgreSQL and MSSQL databases using Liquibase for automated migrations. Integrated database CI/CD using Azure DevOps and supported multiple concurrent projects (3–4), ensuring consistent database design and performance across teams.