Hi, I'm Anthony Viramontes

Data Analyst

I'm currently thriving as a substitute teacher, and I'm dedicated to fostering a positive learning environment. Beyond the classroom, I'm driven to become an impactful Data Analyst by honing my analytical skills. I'm passionate about uncovering insights from data and contributing to data-driven decision-making.

CV

About Me

Data Analyst in the Making!!

A Computer Science graduate engaged in continuous learning within the field of data analysis. Building upon a foundation of strong programming skills, I am acquiring proficiency in data analysis tools and techniques. Developing practical projects to reinforce theoretical knowledge, with the objective of contributing to data-driven strategies. I'm really excited about data visuals, because they let you see patterns and trends that you might otherwise miss.

My Journey

Education

03/25

Google Data Analytics - Google

This comprehensive program provided an immersive understanding of data analytics practices and processes. I gained proficiency in key analytical skills, including data cleaning, analysis, and visualization, using tools such as spreadsheets, SQL, R programming, and Tableau. The course covered data organization, analysis, visualization techniques, and finished with a real-world data analysis project.

12/24

SQL for Data Analysis - LinkedIn

SQL for data analysis was covered from the basics to fundamental queries, with an emphasis on asking effective data-driven questions and translating them into SQL for insights. The course also included integrating SQL queries, which further developed my SQL skills. Practical experience was gained through GitHub Codespaces.

11/24

Business Analysis Foundations - LinkedIn

This course introduced the fundamentals of business analysis, emphasizing its role in project success by clarifying stakeholder requirements. This course explained the business analysis process, from needs assessment and stakeholder identification to testing, validation, and release. I gained insights into the BA role, essential skills, and how to apply business analysis to help the company achieve its goals.

11/24

Excel: VLOOKUP and XLOOKUP for Beginners - LinkedIn

This mini-course explained the powerful lookup functions VLOOKUP and XLOOKUP in Excel. It provided a step-by-step guidance on creating simple lookups and error-proofing formulas. I gained practical skills to significantly improve my Excel abilities and save time with these essential functions.

11/2024

Learning Data Analytics: 1 Foundations - LinkedIn

This course provided a foundational understanding of data analytics principles, and practices. It explored core concepts such as data thinking, collaborative data acquisition, and essential data tools like Excel, SQL, and PowerBI. I gained practical skills in SQL query syntax, data interpretation, data cleaning, and data governance. The course also covered data manipulation techniques, including importing and working with CSV files, creating datasets, and utilizing Power Query in Excel. The challenge/solution sets reinforced my learning.

03/2024

AWS Cloud Quest: Security

During my participation in AWS Cloud Quest: Security, I acquired a comprehensive set of skills crucial for ensuring robust cloud security. This immersive course equipped me with the expertise to build solutions such as projects that respond to incidents, automate remediation, detect vulnerabilities, and prevent data loss effectively. Through hands-on experience, I delved into various aspects of cloud security, including data security, security architecture, security management, and serverless security. Notable projects during the course, such as Securing 3-tier architecture, Lambda Security, incident response, and Application logs analysis have provided me with practical insights applicable in professional environments.

01/2024

AWS Certified Cloud - Associate

Pursuing the AWS Certified Cloud Associate certification has been a transformative journey, deepening my knowledge across a spectrum of AWS services. I've seamlessly integrated AWS Training into my learning process, allowing me to not just understand but also execute real-life projects. This hands-on approach ensures a practical understanding of AWS, enhancing my ability to contribute effectively in diverse cloud environments.

10/2023

AWS Certified Cloud Practitioner - Foundational

During my pursuit of the AWS Certified Cloud Practitioner certificate from Amazon, I immersed myself in a comprehensive exploration of over 100 AWS services. This journey not only provided me with a broad understanding of the AWS ecosystem but also equipped me with hands-on experience in utilizing foundational AWS services.

08/2023

AWS Academy Graduate - AWS Academy Cloud Security Foundations

In the East Los Angeles Cloud Security class, I delved into the fundamentals of cloud security through the AWS Academy Cloud Security Foundations program. This comprehensive course equipped me with a solid understanding of cloud security basics. Notably, I gained practical skills in utilizing CloudWatch to vigilantly monitor logs, adeptly identifying and addressing malicious activities within cloud environments.

2022

Bachelor Degree - University

At Cal State LA, I embarked on a transformative journey honing my skills as a software engineer through diverse coursework. This experience not only equipped me with a solid theoretical foundation but also provided practical insights into utilizing agile methodologies. I actively applied these skills by leading a collaborative group in a significant project, showcasing my ability to navigate complex tasks and deliver impactful results.

Experience

2024 - Ongoing

Substitute Teacher - LAUSD

I've led classrooms as a substitute teacher, overseeing diverse classes, quickly adapting swiftly to various subjects and grade levels. Enforcing effective classroom management strategies, I consistently maintained an engaging and focused learning environment. My versatility in teaching and collaborative approach ensured a seamless transition between regular and substitute educators.

2021 - 2022

Team Lead - InART

I took the lead in a groundbreaking project – developing a Virtual Reality Application with a team of 10 individuals, all venturing into uncharted territory. Embracing the role of team lead, I navigated challenges as a software engineer, dedicating countless hours to ensure project completion by the end of the spring semester. The adoption of agile methodology in the latter stages proved crucial, markedly enhancing our productivity and contributing to the project's success.

2021 - 2022

Webmaster - Association for Computing Machintery Club

I oversaw the club's website and directed the web team.This involved active participation in weekly meetings, introducing fresh design concepts, engaging in fundraising efforts, promoting club membership in classes, and maintaining the availability of the website for members' access.

2020 - 2021

Web Officer - Association for Computing Machintery Club

As the Web Officer for the Association for Computing Machinery, I was entrusted with crafting captivating designs for web pages and managing the development of a singular webpage. My role not only involved the creative aspect but also required active participation in meetings, fostering collaboration and ensuring alignment with the organization's goals.

2018 - 2019

Program Assistant

As a Program Assistant at East Los Angeles College, my main responsibilities included efficiently registering and enrolling students into non-credit classes. This dynamic role frequently took me offsite to coordinate and set up classrooms for teachers, while also actively participating in public events to promote and sponsor our programs. Beyond student services, I seamlessly handled various office tasks, contributing to the smooth operation of the program.

My Skills

Analysis Skills

Excel

SQL

Statistical Analysis

Data Visualization

Data Storytelling

Professional Skills

Communication

Leadership

Problem Solving

Time Management

Adaptability

My Projects

Hands on Project

3/2025

Udemy Course Data Exploration

  • Analyzed Udemy course data to identify popular course categories and student enrollment trends.
  • Utilized Excel's data analysis tools 0to calculate course completion rates and student ratings.
  • Gained experience in extracting insights from large datasets to inform course development strategies.
2/2025

Customer Service Call Analysis

  • Investigated customer service call data to identify common issues and resolution times.
  • Applied data cleaning techniques to standardize customer feedback and call durations.
  • Developed skills in using Excel to analyze customer service metrics and identify areas for improvement.
1/2025

McDonald's Sales Dashboard

  • Examined McDonald's sales data to analyze product popularity and sales patterns.
  • Employed Excel functions to calculate sales averages and identify sales outliers.
  • Improved my proficiency in creating dynamic dashboards to track key sales indicators.
12/2024

Coffee Sales Insights

  • Explored coffee sales data to determine customer preferences and regional sales performance.
  • Utilized Excel formulas to calculate sales growth and identify top-selling products.
  • Enhanced my ability to create interactive charts to visualize sales trends.
11/2024

Bike Sales Analysis

  • Analyzed bike sales data to identify trends and peak sales periods.
  • Cleaned and transformed raw data to create meaningful visualizations.
  • Developed skills in using Excel pivot tables to summarize and present key sales metrics.
4/2024

Multi-Language Medical Text Processing

  • Leveraged Amazon Athena for SQL queries on S3 data and created BI dashboards with Amazon QuickSight.
  • Extracted medical information from unstructured text using Amazon Comprehend Medical.
  • Utilized Amazon Translate to programmatically translate multiple languages.
2/2024

Database freedom for medical appointments

  • Converted database schemas for seamless migrations using the AWS Schema Conversion Tool.
  • Executed diverse database migrations with the AWS Database Migration Service, which showcases my database migration practices.
  • Migrated data from an MS SQL server to an Aurora serverless Cluster, which expanded my database migration knowledge.
1/2024

Using an Amazon S3 Trigger to Create Thumbnail Images

  • Troubleshot S3 configuration and Lambda function setup to ensure proper functionality.
  • Resolved deployment package dependency issues to successfully create thumbnail images.
  • Honed my problem-solving skills in a cloud-based project, reinforcing my programming and cloud troubleshooting abilities.
12/2023

Hosting Web Portfolio on S3

  • Purchased a domain on NameCheap and integrated it with Amazon Route 53 by creating a hosted zone.
  • Configured an Amazon S3 bucket for static website hosting.
  • Implemented access controls on S3 for CloudFront and ensuring protection against unauthorized access.