Hi there! I'm Roy

I am always influenced by technology. The boundaries that are pushed by the leaders of the industry today reflect my own ambition to become a member of the ever-growing tech industry. I am currently working to improve my skills to become a data analyst for your company and will use my ambition to achieve the goals and accomplish the objectives that I am tasked with.

EDUCATION

Udacity

Data Engineer Nanodegree (Udacity - 2020)

Data Modeling

Learned to create relational and NoSQL data models to fit the diverse needs of data consumers
Used ETL to build databases in PostgreSQL and Apache Cassandra

Cloud Data Warehouses

Learned about the cloud infrastructure ecosystem and how to use essential tools for computing, storage, and analytics through Amazon Web Services (AWS)
Learned to implement a data warehouse on AWS including scalable storage, ETL strategies, and design and query optimization

Data Lakes with Spark

Understand the need for a data lake and how it is different from a data warehouse
Learn the various options for implementing a lake on AWS

Data Pipelines with Airflow

Learned how to build maintainable and reusable pipelines in Airflow

Fullstack Web Developer Nanodegree (Udacity - 2019)

Developer Tools

Brush up knowledge of essential developer tools such as the Unix shell, Git, and Github
Apply skills to investigate HTTP, DNS, NAT, IPv6, Bandwith, Latency, and how to use tcpdump to explore packages in the network

Databases with SQL and Python

Learned SQL databases and built multi-user web applications using the Flask framework, SQLAlchemy, and authentication providers such as Google and Facebook

Servers, Authorization, and CRUD

Learned the CRUD pattern (Create, Read, Update, Delete) and how it relates to RESTful architectures and to the operations of a database-backed web service
Learned the difference between authentication and authorization
Learned best practices in developing a login system

San Francisco State University

BS, Computer Science / Math Minor (2019)

Coursework

Analysis of Algorithms
Data Structures in Java
Discrete Mathematics
Human Computer Interaction
Introduction to Database Systems
Linear Algebra
Machine Structures
Operating Systems Principles
Probability and Stats
Programming Languages
Programming Methodology (in C++)
Software Development
Software Engineering
Theory of Computing

SKILLS

I love coding in Python. I spend most of my free time looking for projects to code in Python and using many resources to learn new tools and frameworks using standard and third-party libraries. My favorite framework to code websites in is Flask using Jinja templating. My primary focus is coding the backend of web applications as well as designing RESTful API's. Eventually I hope to transition into data analysis and data management, which is why I've taken a few courses and read a few articles on these subjects.

You can't have a website's frontend function without the structure of HTML, the stylings of CSS, and the mechanics of JavaScript. In going through coursework to design websites, I enjoyed encountering CSS styling to make my websites look eye-catching and also was glad to reference best practices for providing a more user-friendly experience. I also like to have fun manipulating the DOM with JavaScript. Overall, using syntactic HTML is my favorite because it provides an inclusive experience for everyone visiting my sites.

Most of my undergrad curriculum involved projects coded in Java. These projects covered the basics of syntax and object-oriented programming. After a few intro courses, I was thrown into deep waters and created a video game using Java. As rigorous as the coursework was, I gained experience in debugging and knowing that not everybody knows a programming language by heart and the internet can be a programmer's best friend.

Outside of academics, in the process of learning more programming languages and frameworks, I came across Ruby as a web development language. I learned the basics of this language through Team Tree house and was able to play around with the language a bit. I actually got the inspiration to learn about Ruby through HBO's Silicon Valley when a reference to Ruby on Rails was made.

My first break into the Computer Science major was taking a course in C++. I can't say I'm not grateful for this language: it gave me the understanding of programming language syntax as well as a low-level idea of how we are communicating with the hardware of a computer through this language.

PROJECTS

Academic

Shallot

A mock stock photo website. I worked on a team of 6 students to develop a full web application using modern teamwork, SE processes and tools. My role was Frontend Lead.

1 / 4

2 / 4

3 / 4

4 / 4

❮ ❯

As Frontend Lead, I oversaw the development of the frontend of our web app as well as:

Assisted backend with file tree to ensure smooth Flask build
Developed layout for project UI
Mock up design for instructor feedback
Developed forms and navigation bar links using best UI practices

Personal

Udacity

Data Pipeline

Introduces core concepts of Apache Airflow. Custom operators are created to perform tasks such as staging the data, filling the data warehouse, and running checks on the data as the final step.

Data Lake

In this project I apply Spark tools and data laekes to build an ETL pipeline for a data lake hosted on S3. Data is loaded from S3, processed into analytics tables using Spark, and loaded back into S3. Then, a Spark process is deployed on a cluster using AWS.

Data Warehouse

In this project, I apply data warehouse concepts and AWS to build an ETL pipeline for a database hosted on Redshift. Data is loaded from S3 to staging tables on Redshift and SQL statements are executed that create the analytics tables from these staging tables.

Data Model with Apache Cassandra

Used data modeling concepts and Apache Cassandra to complete an ETL pipeline using Python. Data is modeled by creating tables in Apache Cassandra to run queries. The ETL pipeline transfers data from a set of CSV files within a directory to create a streamlined CSV file to model and insert data into Apache Cassandra tables.

Data Model with Postgres

Used Postgres to build an ETL pipeline using Python. Fact and dimension tables were defined for a star schema for an analytic focus, and an ETL pipeline was written that transfers data from files in two local directories into tables in Postgres using Python and SQL.

Capstone Project

This project combines the concepts learned throughout the Data Engineer Nanodegree Program.

Item Catalog

This project is an application that provides a list of items within a variety of categories as well as provides a user registration and authentication system. Registered users have the ability to create, edit, and delete their own items.

CRUD Server

A simple server that implements CRUD (Create, Read, Update, Delete) operations to alter information in a database using SQLAlchemy.

Log Analysis

This project is an internal reporting tool. Using information from a PostgreSQL database, it prints out a report in plain text:

The most popular three articles of all time
The most popular authors of all time
The data in which more than 1% of requests lead to errors

Udemy

Item Store

This project is a simple REST API that simulates an item storage, implemented using sqlite3 and the flask_restful module.

Book Store

Using Python, this project demonstrates a simple book store database that implements a simple GUI which allows a user to enter book information to either search, add, update, and delete an entry. User input and database entries get displayed via a window within the GUI to let the user known that an entry was added or what entries are currently in the database.

EXTRAS

This section is just a compilation of things I read to stay up-to-date with current technologies, as well as stuff I've come across in learning about new frameworks.

Stuff I Read

Hobbies

I enjoy playing open-world and puzzle-type video games. My favorite series is Legend of Zelda, specifically Breath of the Wild because of its inclusion of shrines and their puzzles. I also enjoy the God of War series because of its lore and inclusion of Ancient Greek mythology. What I love about these games is that you get to immerse yourself into new worlds and discover areas that lead to completing objectives.
I enjoy reading any books that increase my knowledge of trivia. One such book I enjoy reading is The Psychology of Zelda, which explores why the player connects to Link in the series and why we always return to Hyrule to save the kingdom.
I enjoy movies based on books and anything involving fantasy, science-fiction and lore. My favorite series (along with the books) is 'Harry Potter'. I also like 'The Imitation Game' which is about the father of computer science: Alan Turing.
Outside of indoor activities, I enjoy taking walks along the Bay near where I live, which allows me to look inward toward San Francisco's skyline, with the Bay's waters crashing on the shore.

CONTACT

Location: San Francisco Bay Area, CA
Email: rtelles64@gmail.com