Fernando Gonzalez

Developed a data-driven fraud detection system using SQL databases and data analysis techniques to identify fraudulent credit card transactions. Implemented SQL joins across multiple tables (transaction, customer, fraud, and card information) for comprehensive transaction analysis. Enhanced transaction monitoring by utilizing data visualization for reporting and risk assessment, improving the detection of suspicious activities and reducing fraud risks.

Created a web scraper using Python and BeautifulSoup to track rental prices across the Lower Mainland in BC, Canada. Utilized SQL for efficient data storage and querying. Developed an interactive dashboard in Tableau for visualizing trends in rental prices, providing valuable insights into the rental market and enabling better decision-making for both tenants and landlords.

Built a dynamic web application for a cafe order management system using PHP, MySQL, and JavaScript. Integrated user authentication and real-time order tracking features. Designed a streamlined order process that improved customer experience and operational efficiency. Utilized data analysis to track order trends, helping the cafe optimize inventory and sales strategies.

Each of these descriptions is concise but highlights the core technologies and methodologies used in each project, with a focus on relevant skills like SQL, Python, data analysis, and data visualization. Let me know if you want to add anything or make adjustments!