Vinni Guan Email & Phone Number

Los Angeles, Ca, Us

Boston, Massachusetts, United States

• Develop data pipelines using SQL and Python to query, join, and clean physician, primary care events, and seminar data to enhance data-driven decision-making/campaign effectiveness• Explore and apply machine learning techniques to optimize predictions in factors influencing doctors' prescribing behavior, achieving 85% overall accuracy and refining the effectiveness of educational events and engagement strategies for opioid prescription reduction• Launch a new sales channel for medical bootcamps via LMS, developing weekly Tableau dashboards and reports to track reviews, subscriptions, buyer activities, and user engagement post-launch • Manage the medical morning report by collaborating cross-functionally with clinical and digital teams to create promotional elements to drive website traffic, including implementing A/B testing on CTA button and graphic design, leading to a 46% increase in activity completions and an 18.5% increase in engagement• Utilize Excel (VLOOKUP, IF functions, Pivot Tables, SUMPRODUCT, etc.) to clean medical workshop data, evaluate physician reviews, and sort the list of clinicians for targeted marketing efforts

Boston, Massachusetts, United States

• Utilized platforms such as Sitecore, Globalmeet, and Marketo to construct webpages and oversee digital content management to update enterprise’s upcoming products and activities. • Developed supported promotional content by utilizing Marketo’s email automation platform and HTML implementation• Managed weekly podcast to bolster disease prevention awareness through insights from medical specialist, overseeing all aspects of production, from content development and guest coordination to editing, which amassed over 1 million downloads• Collaborated with marketing teams to create the promotional video for the latest enterprise website, overseeing content development, graphic design, and video production, resulting in an increase in web visits post launch on the Digital Signage Network

West Lafayette, Indiana, United States

• Facilitated market analysis leveraging the 5Cs framework to identify key value propositions to bolster fundraising and brand awareness• Launched the 'Community Engagement Expansion' program, crafting marketing guidelines that elevated community involvement and expanded the contributor base by 10%, with gains among younger demographics and academic sectors • Designed and distributed promotional materials such as posters, brochures, and business cards, enhancing brand awareness and fostering enduring partnership with educational and local business communities

West Lafayette

• Produce documentaries for BAIM students to highlight their work in business analytics and promote Kran Graduate program.• Create promo videos for businesses in downtown Lafayette to increase their awareness and support local artists.• Interview people and shoot B-roll footage around campus to create news packages about the pandemic in the University toacknowledge people how students work on their experiments through online labs.• Complete all the video and audio of news post-production including recording audio, editing effects.• Produce music videos for the band to promote its live performance; direct the entire videos and complete all post-production.• Adjust the lighting to intensify the emotion of the scene and highlight the specific objects.• Direct live broadcast and recording including commercials, newscasts, and drama in College Studio to engage viewers.

Indianapolis, Indiana, United States

•Designed the Marketing & sales plans for new attraction on long-term care insurance and designed research plans to collect real-time data from various Assisted Living and Nursing Home across Indiana.•Conducted in-person interviews with administrator, manger and executive director in each facilities to collect real-time data from over 40+ nursing home and assisted living across different counties in Indiana; Established relationship with marketing managers in facilities. •Organized, analyzed and interpreted the collected data on each facility including demographics, residences’ preferences, amount of spending, length of staying, percentage of medicaid and private paid, prices based on different plans and situation, etc. •Created datasets on both Assisted Living and Nursing home; clean and manipulate raw data using statistical software including R, JMP, Tableau and Excel; • Developed Python-based K-Means algorithm for customer segmentation, categorizing seniors by key attributes to inform targeted outreach• Generated predictive models like logistic regression to analyze cost and care factors in nursing facilities and the likelihood of seniors opting for LTC insurance, enhancing data-driven decision making• Proposed new LTC plans for corporate agents, boosting sales by 21% through targeted training and strategic marketing initiatives

West Lafayette, Indiana, United States

• Analyzed information from various sources to write the latest news for the speeches on campus and political events.• Gathered students’ opinion on Purdue strategy of limiting the spread of COVID 19 and accomplished exponent article aboutstudents' lives at Purdue.• Composed news service story of a current research in Brian Lamb School of communication

West Lafayette, Indiana, United States

•Provide outreach to supporters to raise funds for events. Utilize planning skills to recruit performers for various events.• Acts as a consultant for events, while distributing marketing material to enhance attendance.

Hong Kong Sar

• Analyzed income risks of different insurance plans in the company to define the target market• Utilized Excel to visualize the data given by the company to identify customer demographics, preference, and buying habits• Created a simulated business plan that outlined allocation of funds to maximize the company's interests.• Balanced capital between sufficient liability reserves and considerable investment returns.

Master'S Degree, Master Of Business Analytics

Bachelor Of Science - Bs & Bachelor Of Art - Ba, Marketing/Data Analytics, Mass Communication/Media Studies