Summary
Overview
Work History
Education
Skills
Websites
Languages
Timeline
Generic

Fernando Gonzalez

Burnaby,BC

Summary

Data Analyst with a strong foundation in SQL, Python, and data visualization, passionate about data integrity, fraud detection, and predictive analytics. Experienced in web scraping, ETL processes, and dashboard development to drive business intelligence and decision-making. Adept at data cleaning, trend analysis, and automation, optimizing workflows and reducing inefficiencies.

Overview

Work History

Fraud Detection System

Personal Project
  • Developed a data-driven fraud detection system using SQL and Python to identify fraudulent credit card transactions.
  • Implemented SQL joins, indexing, and complex queries across multiple tables (transaction, customer, fraud, and card information) for comprehensive analysis.
  • Utilized data visualization (Tableau, Matplotlib) to enhance fraud monitoring and reduce false positives in transaction assessments.

BC Rent Tracker

Personal Project
  • Created a Python-based web scraper using BeautifulSoup to track rental prices across BC’s Lower Mainland.
  • Designed an ETL pipeline to extract, transform, and load data into a SQL database, ensuring efficient data storage and querying.
  • Developed an interactive Tableau dashboard to visualize rental market trends, providing insights for landlords and tenants.

Cafe Order Management System

Personal Project
  • Built a dynamic web application for cafe order management using PHP, MySQL, and JavaScript, integrating real-time order tracking.
  • Designed an optimized relational database schema for handling orders, payments, and customer data efficiently.
  • Applied data analysis techniques to track order trends, enabling better inventory management and sales forecasting.

Education

Associate of Applied Science - Computer Science

Langara College
Vancouver
01-2025

Skills

  • Programming & Data Processing: SQL, Python (Pandas, NumPy, BeautifulSoup)
  • Data Visualization & BI Tools: Tableau, Power BI, Matplotlib, Seaborn
  • Database Management: MySQL, PostgreSQL (Queries, JOINs, Indexing, Optimization)
  • Data Analysis & Reporting: A/B Testing, Hypothesis Testing, Statistical Analysis
  • ETL & Automation: Web Scraping, API Data Extraction, Data Cleaning (Normalization, Aggregation)
  • Web Technologies: PHP, JavaScript (for data-driven web applications)

Languages

English
Native or Bilingual
Spanish
Native or Bilingual
French
Elementary

Timeline

Fraud Detection System

Personal Project

BC Rent Tracker

Personal Project

Cafe Order Management System

Personal Project

Associate of Applied Science - Computer Science

Langara College

Similar Profiles

  • Carlos Guerron

    Carlos GuerronCarlos Guerron

    Graphic Designer at Personal ProjectGraphic Designer at Personal Project

    View Profile
  • Carter Jones

    Carter JonesCarter Jones

    Snakesweeper Game Website at Personal ProjectSnakesweeper Game Website at Personal Project

    View Profile
  • Neftali Gutierrez

    Neftali GutierrezNeftali Gutierrez

    Lawn Mower at Personal ProjectLawn Mower at Personal Project

    View Profile
Fernando Gonzalez