Xiaoyu Ojeda
Marketing Analyst Intern · JDR International
PLAYA VISTA, CAWork Experience
Marketing Analyst Intern
JDR International2020 – 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, Inc2017 – 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 Securities2016 – 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 Management2016 – 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 Fund2015 – 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 School2020
Master of Business Administration
Graduate Certificate
Stanford University2022
Graduate Certificate
Bachelor of Arts in Communication
The University of Shanghai for Science and Technology2015
Bachelor of Arts in Communication