See my resume as a PDF here.

Rose McConnell

Software engineer | Atlanta, GA

EDUCATION

---

Bachelor of Science in Computer Science | Dec 2023

Clemson University, Clemson SC | Dean’s List

TECHNICAL SKILLS

---

ACCOMPLISHMENTS

---

• Managed and resolved over 400 internal support tickets over 1.5 years, consistently providing timely technical solutions and documenting issues to enhance the team’s knowledge base and improve response time.
• Obtained the AZ-900 (Azure Fundamentals) certification in April 2025, proving foundational knowledge of cloud services and Azure architecture.
• Utilized Shopify’s Liquid documentation to update the Upcoming Courses section so that user-submitted products will automatically update.

PROJECTS

---

Reddit Data Pipeline | AWS, Python, Apache Airflow, dbt, Docker, Terraform

• Built an end-to-end ELT pipeline to ingest and transform large-scale Reddit submission data using Python, Apache Airflow, Amazon S3, Amazon Redshift Serverless, and dbt.
• Orchestrated multi-stage data workflows in Apache Airflow with Dockerized task execution for extraction, cloud ingestion, warehousing, and SQL-based transformations.
• Designed and implemented analytics-ready transformation layers in dbt on Amazon Redshift to support downstream reporting and ad hoc analysis.
• Provisioned cloud infrastructure using Terraform, including Amazon S3 and Amazon Redshift Serverless resources, enabling reproducible environment setup and teardown.
• Developed containerized local data platform infrastructure with Docker Compose for reproducible orchestration, dependency management, and development workflows.
• Implemented a modern ELT architecture using Python for extraction/loading and dbt for transformation, following analytics engineering best practices.

FastAPI Journal | Azure, Python, FastAPI, Kubernetes, Docker, GitHub Actions, Terraform, Grafana, Prometheus

• Deployed a journaling API on Azure using containerized FastAPI and PostgreSQL virtual machines.
• Provisioned infrastructure with Terraform, implemented CI/CD using GitHub Actions, and orchestrated deployment with Azure Kubernetes Service (AKS).
• Integrated Prometheus and Grafana for real-time monitoring, demonstrating a complete cloud-native DevOps pipeline.

Cloud Resume Website Project | Azure, JavaScript, HTML/CSS, Python, CosmosDB, Azure Functions, GitHub Actions, ARM Templates

• Developed and deployed a personal resume website using an Azure Storage static website, with a HTTPS-enabled custom domain via Azure Front Door.
• Implemented a JavaScript-based visitor counter backed by an Azure Function (Python) and CosmosDB Table API.
• Built and configured cloud resources and infrastructure with ARM templates.
• Set up CI/CD pipelines with GitHub Actions to automatically deploy both the front-end and backend upon updates.
• Wrote unit tests for the Python API code to ensure functionality and maintainability.

Canary AI Deployment | Azure, Python, FastAPI, Docker, Kubernetes, GitHub Actions

• Designed and deployed a canary release strategy on Azure Kubernetes Service (AKS) for a containerized AI sentiment analysis API, ensuring safe model rollouts with minimal downtime.
• Built and pushed Docker images to Azure Container Registry (ACR) using automated CI/CD pipelines with GitHub Actions.
• Implemented Kubernetes manifests to manage multi-version deployments and load-balanced traffic between v1 and v2 services (~80/20 split).
• Verified deployment health with kubectl and traffic sampling, demonstrating controlled rollout, rollback, and promotion strategies.

Gender & Age Detector | Python, OpenCV, Deep Learning

• Built and tested a real-time image processing app to detect faces and predict age/gender using a deep learning model and OpenCV.

Face Mask Detection System | C, JavaScript, Python, Azure DevOps, GitHub

• Led a 4-person team to build a real-time face mask detection and temperature logging system.
• Utilized Azure DevOps and GitHub for version control and automation, with data sent to a live website via a custom hardware/software interface.

Check out more projects on my GitHub.

RELEVANT EXPERIENCE

---

• Write over 50 complex SQL queries to generate reports across several MySQL and SSMS databases, ensuring data integrity for multiple teams.
• Automate recurring conference data imports for over 3,500 registrants using custom PowerShell scripts, streamlining workflows and reducing manual effort.
• Build and maintain over 30 dynamic Power BI and Google Analytics dashboards to support real-time data insights and cross-departmental decisions.
• Provide training and documentation to over 40 staff members on various CMS platforms, BI dashboards, Azure DevOps practices, and AMS implementations.
• Monitor and improve site performance and uptime, resolving performance and uptime issues and applying proactive security patches.
• Develop and maintain over 10 major C# components for the NetForum AMS while adhering to Azure DevOps best practices including version control and CI/CD.
• Led QA testing and contributed technical expertise during NetForum AMS and Drupal CMS upgrades, improving stability and reducing bugs during rollout.

• Created and ran over 20 test cases to validate embedded firmware for the meters.
• Collaborated with cross-functional teams to ensure seamless integration into the metering system.
• Refactored test code to improve modularity and maintainability, contributing to successful deployment of firmware updates.

• Oversaw a team of 8 people to develop and contribute to a database with over 30 million records.
• Compiled and formatted xrefs in Python, created several SQL views, and created a plugin to monitor wastewater data.
• Engineered backend logic to calculate and store min/max environmental data across 30+ campus buildings.

• Systematized ticket backlog priority to improve work efficiency for over 50 daily incoming tasks.
• Helped troubleshoot and maintain a network of over 1,000 campus machines.
• Assisted in developing and testing the Autopilot software for campus imaging.