Projects
SQL Analytics Dashboard – Movies & Ratings
Built an interactive dashboard using PostgreSQL and Streamlit to analyze movie data. It includes filters, aggregations, and clean visualizations.
- Raw SQL queries with joins, filtering, and grouping
- Visual charts with Streamlit + Pandas
- Interactive filtering by genre, year, and rating
Tech stack: PostgreSQL, Python, Pandas, Streamlit
QA Automation Project
Checkout Page – Automation Testing (POM)
Designed and implemented a complete QA automation framework for a checkout flow using Python, Playwright, and Pytest. The project follows the Page Object Model (POM) design pattern for modularity and maintainability. Integrated with Jenkins for CI/CD, triggered automatically via a GitHub webhook tunneled through ngrok. Test results are captured and visualized using Allure Reports.
- Automated end-to-end tests for shipping info, payment validation, and error handling
- Structured test scripts using Page Object Model (POM)
- Used Pytest fixtures for reusable setup and teardown logic
- CI pipeline built in Jenkins and integrated via GitHub Webhook
- Real-time tunneling of local Jenkins using ngrok
- Test results visualized with integrated Allure reporting
Tech stack: Python, Playwright, Pytest, Jenkins, GitHub, ngrok, Allure, Jira
Power BI – First Project
Video Meeting Usage Dashboard – Power BI
This was my first Power BI dashboard, built for a university course called Data Analysis. While the course mainly focused on Excel (pivot tables, data cleanup, automation, etc.), we were asked to pick another tool for a final project. I chose Power BI, and this is the result — a dashboard that analyzes and visualizes video meeting usage across different metrics like meeting types, quality, and geography.
- Monthly breakdown of Total, Video, and Recorded meetings
- Meeting quality and duration analysis (Good vs Poor)
- Global participant distribution by country
- Timelines of user activity and quarterly trends
Tech stack: Power BI, DAX, Power Query (for data prep)
Lord of the Rings Project
The Silmarillion Dashboard – Power BI
Built a rich Power BI dashboard to explore the vast lore of J.R.R. Tolkien's The Silmarillion. It includes timelines, character maps, and visual breakdowns of events, houses, and realms across the First Age.
- Interactive filters by age, race (Elf, Man, Maia), and house
- Character timeline and conflict chronology
- Custom map visuals of Arda and Beleriand
Tech stack: Power BI, DAX, JSON (Tolkien dataset), Custom visuals
Power BI – Survivor Support Dashboard
Impact Analytics Dashboard – Real-World Social Data
Created this Power BI dashboard to explore survivor support data from an NGO-like scenario focused on helping victims. The dashboard provides a meaningful overview of recovery programs, age demographics, participation by region, and support distribution. It simulates a real company’s internal tool for monitoring KPIs, uncovering trends, and driving data-backed decisions.
- KPI cards to show average age, program success, and survivor count
- Bar and column charts for program distribution and recovery stages
- Slicers by region and gender for personalized data filtering
- Designed for stakeholder clarity and emotional impact
Tech stack: Power BI, Power Query, DAX, CSV
Skills
Bonus
If you got this far, then you deserve a picture of the Chilean National Stadium where the most amazing football team plays: Universidad de Chile 💙