Database Management Systems
I developed a database specification and prototype database for a non-profit organization consisting over 100 members. I created a conceptual schema (ER model), logical schema (relational table design), and a data dictionary for the prototype database. I used SQL statements to create each table and generated materialized views and procedures. I implemented and populated the database and produced queries to support operations and provide value for the organization.
Marketing Strategy Proposal
I collaborated with two teammates to synthesize and propose a marketing strategy for an existing small company. I conducted a SWOT analysis and a situation analysis by examining Warby Parker's mission statement, initiatives, and products to have an understanding of their overall brand image. I then conducted user research and analyzed Warby Parker's target audience based on its social media followers to provide recommendations to reach and engage with the audience.
Econometric Study Replication
I collaborated with two teammates to replicate a peer-reviewed econometrics study using R and Rmarkdown to analyze data and interpret descriptive statistics. We were able to generate and display results that corresponded with the conclusion from the original study.
Content and Audience Analysis
I continued my research on each of Warby Parker's external communications including their social media pages to gain better insight into the genre and context that their their content appears in and determine whether it effectively communicates the company's mission statement and brand image.
SCU Alpha Phi Omega Public Relations
In my role as Alpha Phi Omega's Public Relations Officer, I conducted user research on each Alpha Phi Omega's social media pages as well as email communications to find the reach and engagement of each of the posts. In doing so, I developed ideas of posts and communications to continue the engagement as well as improve on reaching more people.
​
Through my research, I was able to create my first Instagram post in consideration of the target audience and keeping with the image of the organization.