Hi, I'm Anthony Viramontes

Business Analyst

I am a Business Analyst with a background in Computer Science, skilled in transforming complex data into actionable business solutions. I leverage Excel, SQL, and PowerBI to gather insights to solve operational problems, improve efficiency, and drive data-informed decision-making.

CV

About Me

Operational Problem Solver | Business Analyst

I don't just build reports; I build solutions. My focus is on using data through SQL, Power BI, and Excel to pinpoint the root cause of operational inefficiencies and advocate for data-driven change. My Computer Science degree taught me how to build solutions that are actually practical and work for the long term.

My Projects

Hands on Project

🛒 Olist E-Commerce Analysis

  • Delivered actionable insights on customer retention, sales performance, and customer satisfaction by analyzing key business metrics.
  • Transformed and analyzed the Olist Brazilian E-Commerce dataset using Power BI to build an end-to-end solution, uncovering key trends in sales, customer behavior, and geographical performance.
  • Developed an automated ETL process in Power Query to clean raw data, remove duplicates, and build a dimensional model, ensuring a reliable foundation for analysis.
  • Designed an interactive dashboard visualizing critical metrics: identifying non-repeat customers, sales vs profit, and product category performance.
  • Identified that delayed orders cause a 10% drop in average customer review scores (from 4.2 to 3.8), providing a clear metric for prioritizing logistics improvements to protect brand reputation.
See Project

💊 Healthcare Insurance Analysis

  • Delivered actionable insights on high cost patient segments, including targeted health programs for smokers and preventative care initiatives to reduce long-term costs.
  • Analyzed a fictional insurance dataset using Excel and Power BI to uncover trends in patient demographics, lifestyle factors, and their impact on medical charges.
  • Cleaned and standardized the dataset by removing unused columns, creating age group categories, and validating data consistency before loading into Power BI.
  • Designed an interactive Power BI dashboard with KPIs such as average charges by demographic group, smoking prevalence by region, and charges by BMI category.
  • Identified regional cost disparities with the Southeast having the highest average charges, which provides a targeted insights for cost control and health outreach strategies.
See Project

🏥 Emergency Room Analysis

  • Delivered actionable insights to improve ER operations, which aims at improving the staff management in General Practice and to shift realignment for peak morning admissions.
  • Analyzed emergency room visit data using Excel to uncover trends in patient volume, average wait times, satisfaction scores, and department referrals.
  • Cleaned and transformed the dataset by splitting datetime columns, standardizing gender labels, and creating time-of-day categories for deeper insights.
  • Built an interactive Excel dashboard using pivot tables, slicers, and timelines to visualize KPIs such as total visits, wait time trends, and departmental loads.
  • Proposed process improvements for data collection and patient feedback based on findings from over 5,000 incomplete referral records and mid-range satisfaction scores.
See Project

🏦 Bank Churn Analysis

  • Identified key drivers behind a 20% churn rate using SQL and Power BI, including high complaint rates and low satisfaction scores among churned customers.
  • Simulated real-world business collaboration by using ChatGPT as a stakeholder to define KPIs, goals, and project scope.
  • Cleaned and prepared data in Excel and SQL Server Management Server (SSMS) by removing duplicates, checking for nulls, and creating calculated columns for stakeholder readability.
  • Built an interactive Power BI dashboard with KPIs such as churn rate, average tenure, active member churn, and complaint frequency by region.
  • Delivered recommendations to improve customer retention by including region-specific outreach, improving customer service, and loyalty programs for long-term clients.
See Project

👥 Human Resource Analysis

  • Delivered actionable strategies to reduce the 16.12% attrition rate, including targeted retention plans for employees aged 25–34 and those in the R&D department.
  • Analyzed HR data using SQL and Power BI to uncover trends in employee attrition across gender, age, department, and job role.
  • Cleaned and prepared the dataset in Excel by fixing formatting issues, removing duplicates, and creating calculated columns in Power BI.
  • Designed a interactice Power BI dashboard to visualize key HR metrics including attrition rate, average age, employee count, and demographic breakdowns.
See Project

🍕 Pizza Sales Analysis

  • Cleaned and converted inconsistent date formats in SQL and Excel.
  • Performed exploratory data analysis (EDA) to uncover peak sales times, top-performing pizzas, and total revenue.
  • Built an interactive Excel dashboard to visualize key performance indicators (KPIs).
  • Gained experience in data cleaning, time-based analysis, KPI tracking, and SQL data wrangling.
See Project

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.

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.

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.

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.

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.

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.

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.

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.

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.

My Skills

Analysis Skills

Excel

SQL

Statistical Analysis

Data Visualization

Data Storytelling

Professional Skills

Communication

Leadership

Problem Solving

Time Management

Adaptability

My Journey

Education

Ongoing

AWS Certified Data Engineer – Associate

This certification focuses on building, managing data pipelines, transforming, loading data into scalable storage solutions, and optimizing data workflows using AWS services. I'm gaining hands on experience with services such as AWS Glue, Redshift, S3, and Lambda. I'm also learning how to design reliable, secure, and cost-optimized data architectures. I'm using AWS Skill Builder to complete hands-on projects that simulate real world data engineering scenarios. This program strengthens my ability to prepare, process, and deliver high-quality data for analysis and business intelligence.

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 Solutions Architect - 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.