Fangyuan Xu

Fangyuan Xu Email and Phone Number

Business System Analyst @ BluBlu Tech
Irvine, CA, US
Fangyuan Xu's Location
Irvine, California, United States, United States
About Fangyuan Xu

As a problem solver who loves to dig deep, question assumptions, and ask, "Is there a better way?". This mindset fuels my drive to turn complex challenges into innovative solutions that not only work but also inspire change.I want to discover what truly drives people and organizations, providing them with tailored solutions that address their unique challenges. I find great satisfaction in helping others uncover their own needs and potential. This passion for understanding and problem-solving is why I chose to specialize in Business Analysis and Systems Engineering, which are allowing me to approach challenges from multiple angles and create impactful solutions.With a strong background in data analytics and systems engineering, I focused on predictive analytics, process optimization, and strategic planning. I've applied my skills in Python, SQL, Power BI, and Tableau to deliver data-driven insights and improvements across diverse projects. My experience includes developing AI-powered recommendation systems, optimizing SEO for enhanced digital visibility, and driving decision-making with data-backed proposals.I have led initiatives that resulted in a 50% boost in data retrieval efficiency, and devised strategies that cut down acquisition costs by 23%. My contributions with analytics and strategy have translated into better operational efficiency, user satisfaction, and enterprise growth.If you're looking for a collaborative problem-solver ready to make a difference, let's connect! I’m always open to discussing how we can innovate together and drive meaningful outcomes.

Fangyuan Xu's Current Company Details
BluBlu Tech

Blublu Tech

View
Business System Analyst
Irvine, CA, US
Fangyuan Xu Work Experience Details
  • Blublu Tech
    Business System Analyst
    Blublu Tech
    Irvine, Ca, Us
  • Sponsorforce
    Business System Analyst Intern
    Sponsorforce May 2024 - Present
    • Designed and implemented an AI-powered chatbot utilizing Retrieval-Augmented Generation (RAG) with vector databases to provide accurate and context-specific answers tailored to sports sponsorship queries. • Developed a recommendation system leveraging large language models (LLMs) to facilitate global matchmaking between sponsors and rights holders, delivering customized insights and increasing website users by 20%. • Enhanced the website by creating an Insights section with articles to generate more website traffic and performing keyword analysis using tools like SEMrush and Google Analytics. Implemented SEO strategies that reduced webpage load times by 30% through image optimization and code minification, and a 38% improvement on page views.
  • Directavenue
    Business Analyst Intern
    Directavenue Mar 2024 - Jun 2024
    Carlsbad, California, United States
    •Utilized SQL, Python, and Excel to analyze 500k transactional data for national advertising campaigns, performing data analysis that identified peak ads viewing time, leading to a 23% reduction in Cost Per Acquisition.•Automated predictive modeling using Logistic Regression to forecast customer conversion rates and XGBoost to identify key drivers of campaign success, improving ads allocation, customer engagement and ROI by 27%.•Developed automated reports and dashboards for real-time analysis, presenting clear and actionable data visualization insights to stakeholders by using Tableau, enhancing decision-making and strategic alignment for next ads allocation.
  • City Of Santa Ana
    Information Technology Business Analyst
    City Of Santa Ana Mar 2022 - May 2023
    •Led requirements gathering for an integrated Land Management System, halving customers wait times and converting 80% of applications online. Facilitated with five departments to translate business needs into technical specifications. •Developed Python scripts to automate data extraction and processing from SQL databases, integrating with existing workflows and reducing data retrieval time by 56%, ensuring faster and accurate data access for business analytics.•Conducted system gap analysis to address functionality gaps, reducing system process redundancies by 23%. Created BRDs, process flow using Visio to support system implementation, and conducted UAT to validate system features.
  • International Student Business Association- Uc Irvine
    Internal Vice President
    International Student Business Association- Uc Irvine May 2021 - May 2022
    Irvine, California, United States
    • Organized a student involvement fair on the UCI campus with over 300 participants, ensuring efficient student access tobusiness-related resources and career development opportunities.• Planned and advertised mentorship programs and hosted workshops for mentees to develop business skills.• Operated 50+ networking activities, such as the Alumni Night event, involving over 300+ UCI business students; invited 4 UCI alumni from World Top 500 companies to share valuable insights and experience.
  • Futurefolio Trading Inc
    Data Analyst Intern
    Futurefolio Trading Inc Dec 2021 - Jan 2022
    •Analyzed 100 GB of bank data for treasury transaction data, using PostgreSQL to design a Treasury General Ledger database and performing data cleaning tasks to impute missing values and remove outliers.•Designed an ERD within a Snowflake schema to meet treasury business needs and implemented an ELT pipeline to process large-scale daily transaction datasets from three cloud sources. Transformed data using Pandas and loaded it into a PostgreSQL Data Warehouse, improving query efficiency by 36% and enabling faster financial decision-making.•Generated 50 SQL complex queries to create tables and stored procedures and views for future references. •Established matrices and six parameter-based data storage procedures, reducing report processing time by 20% and supporting cross-departmental functions such as accounting and risk management.
  • Uci Antrepreneur Center
    Business Entrepreneurship Intern
    Uci Antrepreneur Center Mar 2021 - Jun 2021
    United States
    • Analyzed market size of garment industry by SWOT and market entry analysis; collected information of the impact of e-commerce on industry to better product market positioning.• Built a business pitch deck based on a business idea Ready Dress, an outfit matching application to present concept and business's potential market by analyzing several open datasets such as Statista and found the potential market of online garment industry.• Presented user journey, user interface design prototypes that built by Figma, and financial projections to two investors and modified prediction of future revenue and income based on the number of users of the business, cost of goods sold and operating using Excel after getting feedback from investors.
  • Wealthwave
    Financial Analyst Summer Intern
    Wealthwave Jun 2020 - Aug 2020
    United States
    • Cooperated 10 intern meetings ranging in topics from business operation, personal finance, investment and marketing.• Built a social media platform on Instagram that demonstrates personal finance knowledge and publicized a Financial Literacy seminar using Eventbrite.• Designed a flyer on Canvas to promote Financial Literacy event held by WEALTHWAVE.

Fangyuan Xu Education Details

Frequently Asked Questions about Fangyuan Xu

What company does Fangyuan Xu work for?

Fangyuan Xu works for Blublu Tech

What is Fangyuan Xu's role at the current company?

Fangyuan Xu's current role is Business System Analyst.

What schools did Fangyuan Xu attend?

Fangyuan Xu attended Cornell University, University Of California, San Diego - Rady School Of Management, Uc Irvine.

Not the Fangyuan Xu you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.