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

Marketing Analyst Intern

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

Co-Founder

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 Project Manager

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

Investment Analyst

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

Marketing Analyst

Find out detailed information about Xiaoyu Ojeda,  in PLAYA VISTA, CA

Xiaoyu Ojeda: in PLAYA VISTA, CA

Xiaoyu Ojeda

JDR International

Raise Think, Inc

Kaiyuan Securities

Zhongjin Guotai Asset Management

Rich Spring Fund

Pepperdine Graziadio Business School

Stanford University

The University of Shanghai for Science and Technology