Trison's Projects

All Projects

October 2025

Cleaned a 10,000-row Kaggle dataset of cafe sales using Python (pandas) and SQL, addressing missing values, duplicates, and format inconsistencies. Loaded data into AWS RDS (PostgreSQL) and ran advanced queries to analyze sales trends. Visualized results in an HTML page. Read more in my blog post. View results.

September 2025

Contributed a Terraform script and Python Lambda handler to ElevenLabs' open-source elevenlabs-nextjs-starter repository, automating AWS Free Tier setup for their AI voice text-to-speech demo—generating MP3 clips and storing them in S3. Reduced deployment time by about 30% with dynamic configs and beginner-friendly docs. Read more in my blog post.
Implemented secure IAM roles with least-privilege policies, resolved Lambda dependency issues (e.g., bundling requests library), and enforced lowercase bucket naming for AWS compliance—demonstrating cloud security, DevOps automation, and problem-solving skills for junior roles in AI ops or infrastructure.

September 2025

Designed and deployed a secure AWS VPC with public and private subnets using Terraform, enabling private EC2 instances to access the internet via a NAT instance. Configured security groups and NACLs for least-privilege access, integrated AWS Security Hub for monitoring, and documented the process in a technical blog post.
Troubleshot NAT connectivity issues by verifying source/destination checks, route tables, iptables, and IAM permissions, using AWS CLI and VPC Flow Logs attempts to identify and resolve network blocks, showcasing cloud security troubleshooting skills.

June 2025

Designed and deployed a secure serverless website using AWS services, Terraform, and GitHub Actions. Implemented DNSSEC, WAF, least-privilege IAM, and CI/CD pipeline hardening, showcasing cloud security engineering skills. Documented the process in a technical blog post.
Developed a real-time visitor counter using AWS Lambda for backend logic, DynamoDB for storing visit counts, and API Gateway with CORS enabled for secure cross-origin JavaScript requests, enabling dynamic updates to the webpage.

2025

Built an interactive frontend-only game to simulate SQL injection attempts, using HTML, CSS, and JavaScript. Users input SQL commands, and a bot detects attacks with regex, responds with snarky roasts, and logs attempts to the console. Click here to play the game.