Bryan Zamora
I am pursuing a BA degree in Computer Science (Data Analytics) at Concordia College.
I am currently work at Doosan Bobcat North America as a Digital Innovation Intern. I work with the IoT team and solution architects enhancing data accessibility and decision making.
Portfolio
Hi,
Welcome to my portfolio! As the first in my family to attend college, I am determined to build a dynamic and impactful career. Driven by curiosity, I have always seen data as a powerful tool for turning questions into actionable insights but it was not until college that I started to get more formal education on it. Pairing my interest in data with cloud computing has opened exciting new directions for exploring and working with data, and I am eager to dive deeper into this innovative field. This page highlights my growth through college projects and personal initiatives. You’ll also find certifications I’ve earned, along with insights into the skills and knowledge behind each achievement. Thanks for visiting!
Got any question, want to connect? Reach out by:
- Linkedln: Bryan Zamora Montero
- Email: bzamoramontero35@gmail.com
Contents
Data Projects
Greenhouse Gas Emissions Dashboard
Developed an interactive Power BI dashboard tracking campus greenhouse gas emissions and energy consumption patterns. Utilized DAX calculations and Power Query transformations to analyze sustainability metrics across Scope 1, 2, and 3 emissions. Visualized multi-year trends supporting institutional carbon reduction goals and climate action reporting compliance.
Twin-Cities-MN-Airbnb-Data-Engineering-Project
This project demonstrates a full data engineering workflow using real-world Airbnb listings and reviews from the Twin Cities MSA, sourced from Inside Airbnb [https://insideairbnb.com/twin-cities-msa/]. The original dataset was provided in a relational (SQL) format. I performed extensive data cleaning and transformation to restructure the data for a NoSQL environment, optimizing it for flexible queries and scalable storage. The final dataset was loaded into AWS DynamoDB, showcasing the migration from SQL to NoSQL and enabling efficient access to complex, nested listing and review data. This project highlights skills in data wrangling, schema design, and cloud database integration.
Harry Potter (API) ETL Project
I explored ETL processes with this Harry Potter-themed project. Using the public Harry Potter API, I dove into the steps of Extract-Transform-Load (ETL) to turn raw API data into meaningful information stored in a MySQL database.
Fargo-Moorhead Housing Pricing
I performed a comprehensive Fargo-Moorhead Housing Pricing Tool using real state data.
Forecasting Brazil’s Freshwater Resources with Predictive Modeling
Renewable freshwater resources is a delicate resource that is most likely to reduce over time, and that even when there are measurements to stop the number of cattles or mitigations for water withdrawals, the numbers of renewable freshwater resources will not reflect a huge change since the scale in which this time series in presented is quite big. Besides, for the next 10 years is expected to decrease, which is expected.
Predicting Casualties in Traffic Crashes of New York City
After my team preprocessed a dataset of 100K car crashes in NYC, there were some interesting findings.
GIS Projects
Assessing Oil/Gas Wells in North Dakota, US
Differences in Green Spaces within Communities in the Fargo Area
Conducted spatial analysis in ArcGIS Pro examining environmental justice in Fargo, ND by integrating HOLC redlining maps, Landsat 8-9 thermal imagery, NLCD tree canopy data, and CDC Heat and Health Index. Performed geoprocessing workflows including spatial joins, zonal statistics, and overlay analysis across ZIP codes and historically marginalized neighborhoods to quantify urban heat disparities.
Certifications
dbt Fundamentals credential
Issued by dbt Labs on November 5th, 2025.
Through completing the official dbt Fundamentals v2 course and its assessment, I have demonstrated hands-on proficiency in building and managing dbt models, configuring data sources, implementing data tests, documenting projects, and deploying analytics workflows. This credential highlights my ability to apply best practices in dbt to ensure reliable, scalable, and well-documented data pipelines.
Ready for SAFE®
Issued by SAFe by Scaled Agile, Inc on August 13, 2025.
SAFe Jumpstart is an online learning series designed to educate learners on the foundations of Lean, Agile, and SAFe® while introducing the look and feel of working on an Agile Release Train (ART) and Agile Team.
AWS QuickSight Basics
Taking the LinkedIn course "Learning Amazon Web Services (AWS) QuickSight" provided me with essential expertise in leveraging AWS QuickSight for data analytics and visualization, enabling me to connect to diverse data sources, transform and analyze data, and effectively create and share dashboards and reports with stakeholders.
Intro to Web APIs
Taking the LinkedIn course "Introduction to Web APIs" gave me a foundational understanding of APIs, it also taught me how to effectively connect to APIs, navigate their documentation, parse data using JSON, and interact with APIs securely and efficiently.
