Micaela
Reyes

Project Description:

Data Analysis and Visualization:
Analyzed attendee and financial data using Python to support data-driven planning and reporting.

Utilized Pandas, Matplotlib, and Seaborn for data aggregation and visualization to interpretability and stakeholder engagement.

Reporting:
Created a detailed PDF slide deck report, featuring charts that provide insights and observations aimed at strategic decision-making. This report was presented to a non-profit grants committee to aid in their assessment and funding decisions.

Project Details:

• Tools Used: Python, Pandas, Matplotlib, Seaborn + Canva
• Date: October 2023

Project Description:

Developed a data strategy that established a roadmap for data-driven decision-making within the organization.

Analyzed data usage and integrated technology to improve business outcomes and set data management guidelines.

Project Details:

• Tools Used: Canva
• Date: August 2023

Project Description:

In this academic project, I assumed the role of a Data Scientist for FoodHub, a hypothetical food aggregator company. The company provided a dataset detailing customer orders placed through their online portal, seeking to derive actionable business insights.

Objective:

• Conduct a detailed analysis of the order data to answer specific questions from the Data Science team, aiming to uncover trends and behaviors that could inform strategic business improvements.

Utilizing Python, I analyzed the data to identify key insights that could enhance customer satisfaction and operational efficiency. This project showcases my ability to apply Python in practical data analytics scenarios, providing the foundation for data-driven decision-making in a business context.

View Project

Project Details:

• Tools Used: Python, Pandas, Matplotlib, Seaborn
• Date: October 2023

Project Description:

In this project, I tackled the challenge presented by New-Wheels, a company experiencing a steady decline in sales and a drop in new customer acquisition due to negative online feedback and ratings.

Objectives:

• Utilize MySQL to organize and analyze the data to address specific business questions.
• Create data visualizations from the analyzed data.
• Provide actionable recommendations and insights in the Quarterly Business Report for executive leadership.

This case study showcases my ability to transform raw data into valuable business insights, driving strategic decisions to improve customer satisfaction and company performance.

View Project

Project Details:

• Tools Used: SQL, Excel, Powerpoint
• Date: September 2023

Project Description:

This project focused on Gamers' Arena, a website that provides detailed information about video games, including releases and sales data across various platforms and genres. Recently, the company introduced a subscription model allowing gamers to play a limited number of games monthly.

Objective:

• Design an interactive Tableau dashboard to monitor key performance indicators (KPIs) crucial for assessing the health and effectiveness of the new subscription sales model.

The dashboard I created enables the director to visually track subscription metrics, analyze user engagement, and make data-driven decisions to optimize the subscription strategy. This project highlights my ability to leverage Tableau for strategic business storytelling and operational oversight.

View Project

Project Details:

• Tools Used: Tableau
• Date: August 2023

Project Description:

A platform where folks can conveniently access information about the Regional PyCons in APAC, all on a single page.

Been collaborating with some awesome folks from the APAC community on this, and it's been an exciting journey so far.

Pull requests are welcome! :)

View Project

Project Details:

• Tools Used: JavaScript, HTML, CSS
• Date: November 2021

Project Description:

This script, developed for PyCon PH 2015, automates the creation and emailing of attendance certificates. It processes a CSV file with attendee names and emails, generates PDF certificates, and sends them to each participant.

Due to its efficiency, it has been used annually to distribute certificates to hundreds of attendees.

View Project

Project Details:

• Tools Used: Python (reportlab, smtplib, csv)
• Date: July 2015