Julian Vazquez

Created a database of endangered species

• Designed a normalized entity relationship diagram (ERD)
• Forward engineered ERD
• Pulled data from Google Sheets into MySQL database
• Wrote queries to gather insights, such as "most common category of endagered species in each region"

Created a fictional product as part of a team

• Applied Double Diamond design process model
• Contextual Inquiry: conducted interviews and distributed surveys to understand users' needs and requirements
• Contextual Analysis: constructed work activity affinity diagram and work domain diagram
• Design Thinking: created multiple personas to represent target users
• Ideation: created sketches, storyboards and low-fidelity wireframes
• Testing conducted informal rapid evaluation with users

Web scraping using the BeautifulSoup module

• Scraped data from a science-based nutrition website (examine.com)
• Imported module to access my personal Gmail account
• Used Windows Task Scheduler to email myself weekly a summary and URL of the latests articles

Recommendation reports based on statistical findings

• Worked with multiple large datasets, including the General Social Survey (GSS)
• Imported packages/libraries in order to recode variables and simplify the analysis process
• Created graphs (scatterplots, boxplots, linear regression plot, etc.) to visualize and interpret findings
• Wrote memo-style papers addressed to key decision-makers to support recommendation to take or not take a course of action