Alyssa Sun Email & Phone Number

United States

- Pulling data from SQL Reports and creating data models in Microsoft Excel to report Actuals, Forecasts, and Budgets in multiple verticals, such as department, product line, and project code- Logging invoices, credit memos, and payments in Microsoft Great Plains and ensuring vendors are paid on time on a weekly basis; managing a weekly budget of $Xm and collaborating with internal teams to validate payments- Expediting Accounts Payable responsibilities by automating Microsoft Excel sheets by coding Macros using Visual Basic for Applications; such as automating name coding, check runs, and organization

- Created monthly data visualizations through Tableau and Power BI, and organized personal stream data provided by Twitch to analyze monthly performance - including viewership, subscription count, revenue, hours streamed, and top performing categories (2023)- Assessed personal and overall streaming trends using Twitch Analytics, and tailored video game content, by streaming popular and trendy games, to increase viewership and meet my goals for streaming; organically gained 2,900+ followers, 4,000+ subscribers, 2 sponsorships, and a Discord community with over 300+ members in under a year- Actively streamed a total of 1,000+ hours on Twitch; edited and published stream highlights using DaVinci Resolve, garnering 36,000+ impressions, which led to around an average of a 62% increase in new Twitch viewers and 12% increase in Twitch subscribers

- Analyzed in-depth organic and paid campaign performance metrics (such as engagements, impressions, CPM, CPC, etc.) on Meta and Tiktok Ads Manager using Microsoft Excel and Google Analytics; translated complex data metrics results into brief, easily understandable summaries- Actively developed themes and presented feedback to the client to avoid adverse social media comments by flagging, categorizing, and identifying patterns to undercover underlying reasons for negative comments; clients saw an overall increase in positive comments- Simultaneously supported 4 large-scale projects cross-functionally with internal and client teams to drive new user growth, proposed and implemented new content strategies optimizing return on advertising spend

- Moderated and oversaw the Incredible Spoon Instagram account by deleting spam comments, actively engaging with followers, and by consistently posting content, organically increasing Instagram followers from 100 to 800+ within 4 months- Applied Adobe Photoshop, Adobe Illustrator, and Canva skills to create original content to share on the Incredible Spoon Instagram, posted 20+ personally created infographics and content that reached over 8,000+ Instagram users- Actively communicated with the CEO and CMO to formulate and to research social media strategies and to maximize reach and impressions

Riverside, California, United States

Riverside, California, United States

Taught two elementary school students from China through Skype, once a week to prepare for their English assessments in their class.