XO

Xiaoyu Ojeda

Marketing Analyst Intern · JDR International

PLAYA VISTA, CA

Work Experience

Marketing Analyst Intern

JDR International

2020 – 2021

Develop consistent processes and templates to more accurately predict sales forecasting. • Analyze sales transaction history to categorize product types, export Salesforce actuals into local database; employ Excel Time Series and Linear Regression to create forecasting model and provide metrics with daily visual reports in Power BI • Compare projected data to actuals and develop a "Go to Market" strategy using Power Query and "What-if analysis" to enhance the accuracy of the forecasted customer conversion rate (CCR) with an aggregate customer acquisition cost (CAC) of $1 million • As a Scrum Master: guide and coach a team of 6 on how to apply Agile values and principals and Scrum Methodology to deliver the high- quality solutions for customers; produce Minimum Viable Product model to standardize analysis process for cross-functional teams

Co-Founder

Raise Think, Inc

2017 – 2018

Created and implemented financial model to facilitate successful application launch. • Leveraged social media platforms to connect with market influencers, expand network, and attract customers; eliminated time and expense of list acquisition and cold calling • Collaborated with five internal teams to formulate financial model for sales and operations planning; established accurate controls of daily activities for $150,000 budget

Investment Project Manager

Kaiyuan Securities

2016 – 2017

Led cross-departmental team to conduct investment planning for a bond acquisition project. • Served as main point of contact and client liaison for top-tier investment institutes and commercial banks • Researched prospective client financial statements and operating reports to screen for capabilities • Provided sell-side research and asset management to assist clients in reaching at least a BB credit ranking • Achieved $3.2 million investment goal ahead of six-month deadline

Investment Analyst

Zhongjin Guotai Asset Management

2016 – 2016

Planned and organized $1.5 billion city tourism project. • Developed forecasting tool to plan resource availability and create clear process for each project phase • Conducted daily updates with internal teams and city officials to ensure transparency and reinforce trust • Negotiated $1.8 million contract and maintained relationship with business partners through proactive communication and accurate financial reporting

Marketing Analyst

Rich Spring Fund

2015 – 2016

Analyzed financial products, organized investment portfolios, and facilitated website launch to promote new business. • Established financial product database criteria for size, market plan, and ROI to create a reliable reference for investment analysts • Sourced web-dev partner and spearheaded launch of fully-functioning website that enabled live transactions and promotional funds

Education

Master of Business Administration

Pepperdine Graziadio Business School

2020

Master of Business Administration

Graduate Certificate

Stanford University

2022

Graduate Certificate

Bachelor of Arts in Communication

The University of Shanghai for Science and Technology

2015

Bachelor of Arts in Communication